SQL for Data Warehousing and Analytics

Now that Oracle Database 12c has launched you will see that we have updated the SQL Analytics home page on OTN, which is here:  http://www.oracle.com/technetwork/middleware/bi-foundation/index-092760.html . One of the new things listed on our OTN home page is a very exciting feature headlined " pattern matching" . Those of you who are using Warehouse Builder will remember the regular expression syntax that was added into the Paris 10g release and you are probably thinking that "hey, I thought Oracle Database already did pattern matching". Of course, you are quite correct. Prior to Oracle Database 12c you could search for patterns within a specific row of data using all sorts of techniques. However, this new pattern matching feature is something is really quite special. The Oracle Database 12c adds SQL pattern matching capabilities brings the simplicity and efficiency of the most common data analysis language to the process of identifying patterns within a...

Another big data win for Oracle! Southwestern Energy  chose Oracle for their big data management project to help them optimize reservoir characterization, drilling, and production operations by delivering an engineered systems platform to capture massive amounts of data, and make better operational, tactical, and strategic decisions. SWN is using Oracle's Engineered Systems Platform to capture massive amounts of data, and make better operational, tactical, and strategic decisions. (If the video above is not visible or does not play then you can view the try following this link to the post on the Oracle Media Network: http://medianetwork.oracle.com/video/player/2431393994001 ) For more videos from our big data customers explaining how they are using our solutions to drive their big data projects visit the Oracle Media Network by clicking here: http://medianetwork.oracle.com/search/results?q=big+data . If you want more information about big data in the oil and gas industry ...

Great news from the Storage Awards 2013. Oracle won the "Big Data Company of the Year 2013" award. The event took place on 6 June 2013 at The Grand Connaught Rooms, Covent Garden. The aware has received by Yanhong Tong, Storage Marketing Manager at Oracle.  (picture from http://www.storage-awards.com/ ) The 2013 Awards saw in excess of 11,500 readers of Storage Magazine vote for their favourite products, people and companies. Claiming the title of "Big Data Company" is great news for us because it tells us that our message of engineered systems to support big data along with big data tools to connect our Big Data Appliance to our Exadata data warehouse platform is the best solution to get customers up and running with big data and it allows them to maximise their analytical capabilities. Well done Oracle Big Data team. For more information about Oracle's big data solution visit www.oracle.com/bigdata

I am a big fan of Garmin's sports gadgets and at the moment I have a Forerunner 210 on my mountain bike, a 310XT watch on my Trek 5200 and an Edge 705 loaded up with a map for my area of northern England on my Trek 5900SSL. Every morning I am either out on one of my road bikes if it is not raining or running with my 310XT watch if the weather is not so good. At the end of the week I connect both my Garmin devices to my computer and upload all the data I have collected to the Garmin Connect website so I can check on all the usual training statistics.  Turns out that I am actually using Exadata every single day! Garmin runs their Connect web application, along with its data warehouse and other operational systems, on Exadata.  Here is a great video that really gets to the heart of why you want Exadata in your data centre and if you are Garmin user you will be pleased to know that every time you turn on your Garmin device you are actually using Exadata.  (If the video above is not ...

We have just released a new video to support the recent report we sponsored by Economist Intelligence Unit research program. The video is an interview with Brian Eoff who is a senior data scientist at Bitly, New York. The new video is called " In Search of Insight and Foresight: Getting More Out of Big Data ".   Brian provides an interesting insight into the whole process of how he and his team explore the huge reservoir of data their company collects. The vast majority of questions that his team start out with seem to result in solutions and features that end up in the product although there are some cases where preconceived ideas have also been proven to be incorrect. One of the most important points raised by Brian is the much talked about disconnect between IT and the business teams which Bitly seems to have resolved by having an intermediary person who works with both sides. Admittedly this is nothing new but it does raise an important point which is that big data will...

The OTN team has just posted a great video interview with Oracle ACE Director Gwen Shapira on YouTube. Gwen talks about integrating Hadoop with Oracle Database using Oracle's Loader for Hadoop and she gives her views on when to use Hadoop vs. when to use Oracle Database. If the embedded video above does not work for any reason then follow this link to the YouTube site: http://www.youtube.com/watch?v=tBpHAyTH6MU . One of the interesting points that Gwen makes during the interview is the superior performance (5X faster) offered by our Hadoop loader compared to the other open source data loading tools. The Oracle Loader for Hadoop is part Oracle's Big Data Connectors suite of software and this suite of tools supports a wide range of Oracle targets. These connectors are designed and optimized to integrate Apache Hadoop with specific Oracle products including Oracle Database, Oracle Endeca Information Discovery and Oracle Data Integrator. The suite of connectors includes the foll...