SQL for Data Warehousing and Analytics

NEW KEYNOTE: Transforming Businesses with Big Data and Analytics Monday Sept 23 @ 8:00am, Moscone North - Hall D There has been an exciting addition to the agenda for this year's OpenWorld. On the Monday morning (Sept 23), Mark Hurd is using his keynote to talk about how businesses can transform themselves using big data and analytics. Given all the hype around these two hope topics this keynote will look at the promise of big data and how it enables your business to leverage a range of information to provide new services, operate more efficiently, and market more effectively. This keynote will include key Oracle customers and other Oracle experts who will explain how to harness the value of big data; craft an IT strategy to stream, acquire, organize and analyze to make transformational decisions about business operations and products and services. To make sure you do not miss this important session I have updated the Data Warehousing and Big Data Guide to includ...

One thing I have noticed when looking at many bigs data projects is that a lot of time is spent collecting data but then the next step, analyzing that data, can quickly become overly complicated.  Working with many big data sources and analyzing this data is just too hard. SQL, on the other hand, is the most commonly used language for data analysis. So how can we combine these two? This session discusses Oracle’s analytical SQL capabilities and how complex analytical queries running on large to extremely large data sets are becoming a reality, even on datasources outside the relational world. I will be delivering a presentation at OpenWorld on using SQL to simplify and enrich the analysis of big data. It is on Tuesday (September 24) at 10:30am in Salon 7 of the Marriot Marquis Hotel - this hotel is a short walk from the Moscone Center. Sign up now ( there is limited space available! ) to attend this session and learn how Oracle sees the future of a unified analytical...

Just a quick reminder that I will be running a hands-on lab for the new Database 12c pattern matching feature at this year's OOW. This is a great opportunity to learn more about this exciting new feature and ask any questions you might have about how to use pattern matching in your projects. Both myself and our expert developers will be in the room to help you and answer your questions. The lab is divided into 5 sections: Part 1 - Introduction to SQL Pattern Matching  Part 2 - Searching for more complex patterns Part 3 - Understanding how SQL Pattern Matching works Part 4 - How to use built-in measures Part 5 - Advanced Topics  I will have all the content available on a USB stick so you can take the schema, data and workshop away with you at the end of the lab. Click through to the OOW content catalog to register for this lab:  https://oracleus.activeevents.com/2013/connect/sessionDetail.ww?SESSION_ID=10068 . The number of seats available for this lab is strict...

This is great new whitepaper written in collaboration with The Economist. In the report Oracle's big data strategist, Paul Sonderegger, looks at how big data is becoming part of everything from New York City’s inspectional services to Intel’s silicon manufacturing, from public policy implications to visual design innovations, and more. The paper will help you understand how many companies and using big data to remake themselves and their industries, and using analysis of data-based decision processes to tell compelling stories through data visualization and predictions. Big data is future and it will have a major impact on society. Click on the link now and find out how to find value in Big Data http://www.oracle.com/us/technologies/big-data/finding-value-in-big-data-1991047.pdf Technorati Tags: Analytics , Big Data , Data Warehousing , Oracle

I have converted my last whitepaper on in-database analytics to the multi-media iBook format so it can be viewed on Apple's iPad and iPad mini. This great new iBook contains a lot more content including how-to videos and presentation slide-shows for each product. This is a must-have multi-media guide to Oracle's data warehousing analytics:   Chapter 1: Oracle’s Approach to Analytics Chapter 2: Oracle's Rich Framework for Analytics Overview of analytics and extensibility framework SQL Data Mining Spatial Analytics Network Analytics Multidimensional Analytics Unstructured Analytics Extensibility Framework Chapter 3: Realizing the benefits of in- database analytics Chapter 4: Conclusion Chapter 5: Where to get more information This iBook is packed full of information that help you get the most Oracle's in-database analytics. You can download the iBook from my Google Drive folder  here . As I am still experimenting with delivering content via the iBook f...

Our BI team has added SQL pattern matching to their demo VM environment which is used by the sales teams and Oracle partners to demonstrate the capabilities of our BI system. There is a short demo on YouTube:  http://www.youtube.com/watch?v=rgwAgckaiTU  - "SampleApp V309 What's New Overview" which shows a SQL pattern matching dashboard in OBI EE. If you jump to point 1:50 this is where the pattern matching content starts and it runs for about 15-20seconds - obviously there is a lot of great content so do please watch the complete video . The data set in the demo is the publicly available flight information data which is commonly used with the R language demos. Technorati Tags: Big Data , Data Warehousing , Database 12c , Oracle , Oracle Database 12c , Pattern Matching , SQL Analytics

There's so much to learn at Oracle OpenWorld because it provides more educational and networking opportunities than any other conference dedicated to Oracle business and technology users. What to expect at OOW 2013 - We will be announcing a wide range of continuous innovations from query optimization and partitioning to advanced analytics, Oracle Exadata and more. All these features make Oracle Database the world's most popular database for data warehousing. Join Oracle experts as we dive deep into the latest generation of database innovations for analyzing enterprise data and diverse big data streams to derive real business value from your data warehouse. You will also learn data warehouse best practices and hear from customers consolidating business analysis onto a common scalable platform. Hands-on labs for both beginners and experts give you the chance to try some of these innovative data warehouse technologies first-hand. To help you get the most from this year's ev...