SQL for Data Warehousing and Analytics

Data Warehouse and Big Data - Highlights from Oracle OpenWorld Day 2 Welcome to this online review of day two 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. Oracle: Big Business Has Big Data Woes (New York Times Interview) Business, the way you’re working will kill you. Storage costs, social media awareness, software application migration — they are all big problems. And, not surprisingly, Oracle is trying to address them. Last week I sat down with Mark V. Hurd, Oracle’s co-president, for a talk about Oracle’s strategy. Most of his conversation had to do with the problems facing big companies as they adapt to a world of mobile devices, cloud computing and ...

Data Warehouse and Big Data - Oracle OpenWorld Day 1 Welcome to this online review of day one of Oracle OpenWorld 2012. During this week I will you keep you up to date on all the press reports, blog posts, analyst reports and related activities from this year's conference. Oracle Big Data and Innovation: President Mark Hurd Oracle President Mark Hurd describes Big Data challenges, and the need for CIOs to both innovate while cutting costs even as storage requirements grow exponentially. Filed at Oracle OpenWorld 2012 by The VAR Guy ... [Watch the video] Oracle Big Data Strategy and Java Sensors: OpenWorld 2012 Oracle Senior VP Judson Althoff discusses how big data applications ...

I see a lot of emails pass through my inbox everyday about how big data can help companies improve their customer experience. The bit that is missing is that if your existing customer management operations are poor then adding more data to this model is not going to help. Let's take two examples: airlines and car hire. I have good status with two companies in these industries but recent experience has taught me that calling their help desks (as instructed by the error messages on their websites) is a frustrating and largely pointless exercise. Yesterday I tried for over two hours to book a flight on an airlines website using my air miles. To use your air miles on this particular site you have to navigate through a number of screens which allow you to choose your flight, enter your traveller details, enter your credit card details and then finally book your ticket. Every time I tried to book a ticket I got an error message which told me to contact the help desk. The first person I s...

Two great new books to add to your iPad (other tablet computers are available). How Data Science Is Transforming Health Care In the early days of the 20th century, department store magnate John Wanamaker famously said, "I know that half of my advertising doesn't work. The problem is that I don't know which half." That remained basically true until Google transformed advertising with AdSense based on new uses of data and analysis. The same might be said about health care and it's poised to go through a similar transformation as new tools, techniques, and data sources come on line. Soon we'll make policy and resource decisions based on much better understanding of what leads to the best outcomes, and we'll make medical decisions based on a patient's specific biology. The result will be better health at less cost. This paper explores how data analysis will help us structure the business of health care more effectively around outcomes, and how it wil...

There's so much to learn at Oracle OpenWorld - it provides more educational and networking opportunities than any other conference dedicated to Oracle business and technology users. To help everyone get the most from this year's event I have prepared a simple booklet in iBook and PDF formats which lists all the must-see data warehousing and big data sessions. It is divided into the following chapters: Welcome to OpenWorld A list of Must-See Sessions Session Calendar Data Warehousing In-Database Analytics Industry Data Models Big Data Details of the Big Data Hands-on Labs Overview of the Exhibition Halls (DEMOgrounds) List of Data Warehouse and Big Data product managers Links to product web pages, blogs and other social media sites iBook version for iPad Users:   Our iBook for iPad users is now available for download by clicking here . Please note that this iBook will only work with Apple's iPad and requires version 2.1.1 of the iBooks app. T...

To help you get started on planning which sessions to attend I have created an online calendar which lists all the relevant Data Warehouse and Big Data presentations, hands-on labs and customer panels. Depending on your calendar software, you can: Download a calendar file (.ics) and create a new local/offline calendar within your own calendar software. Subscribe directly to the online Google calendar and refresh it on a regular basis to receive updates/changes to the schedules View the Google calendar via the web interface Once you have subscribed to, or added, this calendar to your local calendar application you can then synchronize the events with your smartphone, iPhone, iPod, iPad etc. All the times listed for each presentation have been entered in Pacific Time so you will need to enable time zone support on your specific device to see the events at the correct local Pacific Time when you arrive in San Francisco. At the moment the master calendar in iCal looks like this: 1...

If you cannot attend this year's OpenWorld event in San Francisco then make sure you checkout our Oracle Day 2012 programme. This is a series of roadshows touring major cities around the globe and each one promises to be a great event. Oracle Day 2012 features learning tracks and sessions tailored for accelerating your business in today’s environment. Oracle simplifies IT by investing in best-of-breed technologies at every layer of the technology stack and engineering them to work together so you can focus on driving your business forward. Throughout its history, Oracle has proved it can address the most complex IT challenges and solve the business problems of our customers. Discover more about Oracle’s strategy for powering innovation in Data Warehousing, Big Data and Analytics. As with OpenWorld, Big Data is going to be a huge part of these events and the sessions we have scheduled will reinforce the message that Oracle is different because only Oracle offers the complete end-...