SQL for Data Warehousing and Analytics

The latest Data Warehouse Magic Quadrant is out and we (Oracle) has been positioned in the leaders quadrant. How do you get into the leaders quadrant? This is how Gartner defines a leader: vendors in the Leaders quadrant, “demonstrate the greatest support for data warehouses of all sizes, with large numbers of concurrent users and management of mixed data warehousing workloads. These vendors lead in data warehousing by consistently demonstrating customer satisfaction and strong support, as well as longevity in the data warehouse DBMS market, with strong hardware alliances.  Here is a great quote from my boss, Cetin Ozbutun, vice president, Data Warehousing and Big Data Technologies: “We believe Oracle's position in Gartner's Magic Quadrant for Data Warehouse Database Management Systems recognizes the outstanding performance of the Oracle Exadata Database Machine, as well as Oracle’s delivery of innovative, integrated solutions for big data with the Big Data Appliance and ...

If you want to get hands-on time with Oracle's big data technology stack then we are rolling out, in collaboration with OTN, a new complementary one-day hands-on workshop - yes it really is FREE! The date will is Wednesday, February 20, 2013 at Oracle's HQ in Redwood Shores, California . The workshop will be based around the MoviePlex demonstration application that was first shown at last year's OpenWorld and you will get hands-on time with the source code and we will show you how to develop some of the key features of this application. What is Oracle MoviePlex? The Oracle MoviePlex is a fictional on-line movie streaming company and like many other on-line stores, they needed a cost effective approach to tackle their “big data” challenges. They recently implemented Oracle’s Big Data Platform to better manage their business, identify key opportunities and enhance customer satisfaction. The key challenge for Oracle Movieplex is how to manage and process massive vo...

Many of our customers spent 2012 kick-starting big data projects. Based on the number of analyst reports, news articles and general chatter on the web I think it is fair to say that 2012 was the Year of Big Data. To help our customers plan and coordinate their big data projects we developed a very simple high level five step workflow for big data (Stream-Acquire-Organize-Analyze-Decide) as shown here: Many of the projects that our customers stated in 2012 have at least completed the first three steps (with some having completed stages 4 and 5 and now looping back to stage 1 to kick-start the next round of data enrichment and knowledge discovery ): 1) STREAM - all the relevant data streams have been identified and the APIs coded to collect the data on a regular basis 2) ACQUIRE - these data streams are increasing landing on our Big Data Appliance and that is great news! 3) ORGANIZE - many project teams have completed the first round of light-touch transformations and made thei...

I am currently working on a chapter about in-database analytics for a new book which will published early next year. During my research it  has been interesting to note all the different specialised engines that have evolved to solve specific business problems. However, using isolated stand-alone analytical engines creates problems for business users because they end up building numerous data-silos and sharing data becomes a total nightmare. The Oracle Database supports a wide range of analytical features: data mining, text mining, spatial, graph, statistics, multidimensional (OLAP) etc etc. By creating a integrated analytical platform, Oracle allows developers and business users to create analytical mashups that they can then embed in applications, reports and dashboards. So far so good. Oracle has a great story for analytics: single, complete, integrated analytical platform. So Oracle has worked hard to help customers avoid building analytical silos but now there is a new problem on...

Data Warehouse and Big Data - Highlights from Oracle OpenWorld Day 5 Welcome to this online review of day five of Oracle OpenWorld 2012. Here are the latest press reports, blog posts, analyst reports and related activities covering the last day of this year's conference. Thoughts on Larry Ellison’s Big Data Demo Post on ITConvergence blog Oracle founder and Chair Larry Ellison provided a Big Data demonstration the other day at Oracle OpenWorld. The results were impressive. Lexis had a problem. It wanted to determine which Olympic athlete should it sponsor. A generation ago such decisions relied on a little bit of analysis and a lot of gut instinct. But here in 2012 our social media-powered culture gives us hard data on which such multi-million dollar decisions can be b...

Data Warehouse and Big Data - Highlights from Oracle OpenWorld Day 4 Welcome to this online review of day four of Oracle OpenWorld 2012. Our aim is to keep you up to date on all the press reports, blog posts, analyst reports and related activities from this year's conference. Don't forget to visit the Big Data PM website bigdata.us.oracle.com - Your One Stop Shop for everything related to Big Data Big Data Performance Delivered: Oracle NoSQL Database on Cisco UCS - Part 2 Ramesh Chitor (Cisco) interviews Oracle Senior Director Ashok Joshi about the benefits of choosing commercial grade solutions and NoSQL at Oracle OpenWorld 2012 in San Francisco. Watch the video, [click here] ...

Data Warehouse and Big Data - Highlights from Oracle OpenWorld Day 3 Welcome to this online review of day three of Oracle OpenWorld 2012. Our aim is to keep you up to date on all the press reports, blog posts, analyst reports and related activities from this year's conference. Don't forget to visit the Big Data PM website bigdata.us.oracle.com - Your One Stop Shop for everything related to Big Data Fast Data: Go Big. Go Fast. Fast data processing (and especially real-time) has always been our credo at Oracle with each one of these products in Fusion Middleware. For example, Oracle GoldenGate continues to be made even faster with the recent 11g R2 Release of Oracle GoldenGate which gives us some even greater optimization to Oracle Database with Integrated Capture, ...