SQL for Data Warehousing and Analytics

Since the term big data first appeared in our lexicon of IT and business technology it has been intrinsically linked to the no-SQL, or anything-but-SQL, movement. However, we are now seeing that SQL is experiencing a renaissance. The term “noSQL” has softened to a much more realistic approach - a "not-only-SQL" approach. And now there is an explosion of SQL-based implementations designed to support big data. Leveraging the Hadoop ecosystem, there is: Hive, Stinger, Impala, Shark, Presto and many more. Other NoSQL vendors such as Cassandra are also adopting flavors of SQL. Why is there a growing level of interest in the reemergence of SQL? Probably, a more pertinent question is: did SQL ever really go away? Proponents of SQL often cite the following explanations for the re-emergence of SQL for analysis: There are legions of developers who know SQL. Leveraging the SQL language allows those developers to be immediately productive. There are legions of tools and applications u...

There's so much to see and 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 2014 - We will be announcing a wide range of continuous data warehouse innovations in both hardware and software. Join Oracle experts as we dive deep into the latest generation of data warehouse innovations for analyzing enterprise data and diverse big data streams to derive real business value. You will also learn data warehouse best practices and hear from customers consolidating business analysis onto a common scalable platform. Hands-on labs are available for both beginners and experts giving you the chance to try some of these innovative data warehouse technologies first-hand. To help you get the most from this year’s event I have put together a comprehensive downloadable guide of all the data warehousing and big data activities at @OracleOpenWorld  2014. If y...

In one of my recent  blog post  I provided links to our OpenWorld data warehouse web app for smartphones and tablets. Now that the OOW team has released the hands-on lab schedule ( it is now live on the OpenWorld site) I have updated my smartphone and tablet apps to include the list of hands-on labs on a day-by-day basis (Monday Tuesday, Wednesday, Thursday). The list of hands-on labs can still be viewed in subject area order (data warehousing and big data) within the app via the “ Switch to subject view ” link in the top left part of the screen. I have also added a location map which can be viewed by clicking on the linked-text, “ View location map ", which is in the top right part of the screen on each application. The location map that is available within both the tablet and smartphone apps is shown below: If you want to run these updated web apps on your smartphone and/or tablet then you can reuse the existing links that I published on my  last blog...

There so many exciting hands-on labs at this years OpenWorld conference and the schedule builder is now live so you can start booking your seat at these labs. To help you get organized and pick the most useful labs to attend I have published a new shared online calendar that contains all the most important data warehouse and big data hands-on labs at this year’s OpenWorld. The following links will allow you to add this shared calendar to your own calendar application: XML format is here:  https://www.google.com/calendar/feeds/eq7thlb4sb3valjageln5g48t0%40group.calendar.google.com/public/basic .ICS format is here:  https://www.google.com/calendar/ical/eq7thlb4sb3valjageln5g48t0%40group.calendar.google.com/public/basic.ics HTML format is here:  https://www.google.com/calendar/embed?src=eq7thlb4sb3valjageln5g48t0%40group.calendar.google.com&ctz=America/Los-Angeles Hope this helps you get organised for this year’s incredible conference. Any comments then let me k...

I have published a shared online calendar that contains all our data warehouse and big data sessions at this year’s OpenWorld. The following links will allow you to add this shared calendar to your own calendar application: XML format is here: https://www.google.com/calendar/feeds/mcivrscvnkl5egnrj789i46sek%40group.calendar.google.com/public/basic .ICS format is here:  https://www.google.com/calendar/ical/mcivrscvnkl5egnrj789i46sek%40group.calendar.google.com/public/basic.ics HTML format is here: https://www.google.com/calendar/embed?src=mcivrscvnkl5egnrj789i46sek%40group.calendar.google.com&ctz=America/Los_Angeles   As soon as the dates and times for the keynote sessions are published I will add these to the calendar so keep checking for updates. Hope this helps you get organised for this year’s incredible conference. Any comments then let me know and if I missed your data warehouse/big data session then let me know and I will add it to the calendar. Enjoy. ...

In my  last blog post  I provided links to our OpenWorld data warehouse web app for smartphones and tablets. Now that the OOW team has released the session schedule (it is now live on the OpenWorld site) I have updated my iPhone and iPad apps to include the list of sessions on a day-by-day basis (Sunday, Monday Tuesday, Wednesday, Thursday). The list of sessions can still be viewed in subject area order (data warehousing, performance and scalability, analytics, unstructured data, industry models and big data) within the app via the “ Switch to subject view ” link in the top left part of the screen. I have also added a location map which can be viewed by clicking on the linked-text, “ View location map ", which is in the top right part of the screen on each application. The location map that is available within both the iPad and iPhone apps is shown below: If you want to run these updated web apps on your smartphone and/or tablet then you can reuse the exist...