SQL for Data Warehousing and Analytics

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, ...