SQL for Data Warehousing and Analytics

Here it is….. THE ultimate, comprehensive review for big data warehousing for #OOW18. This review is for everyone who either missed this year’s conference or just wants to relive the amazing experience all over again ( but focusing on just the best bits obviously! ). So here you go, my complete view nicely packaged and available free of charge in a number of different formats…           Following on from this year’s OpenWorld I have now put together the ultimate, comprehensive review for big data warehousing content from #OOW18. This free review contains the following information: Key video highlights from the main executive keynotes Overview of the announcements for Autonomous Database - contains the links you need to learn even more about how the Autonomous Database can simplify and speed up your big data warehousing projects! Full list of Oracle Product Management and Development presenters, links to all their social media sites are included alon...

Here’s your absolutely Must-See agenda for Monday at OpenWorld 2018... It all starts today -   OpenWorld 2018.  Each day I will provide you with a list of must-see sessions and hands-on labs. This is going to be one of the biggest and most exciting OpenWorlds ever! Today is Day 1 so here here is my definitive list of Must-See sessions for the opening day. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. MONDAY'S MUST-SEE GUIDE     Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well. Have a great conference. If you ...

It’s  not long until the doors open at the Moscone Center in San Francisco for the biggest and most exciting tech conference in the calendar. Looking at the online content catalog it’s hard to know where to start because there are so many sessions and just not enough time! Which is here my Must-See Guide comes to the rescue. It lists all the most important data warehouse, big data, analytics, machine learning sessions and labs at #oow18 is now available as a comprehensive Day-by-Day version: My Day-by-Day guide for OpenWorld 2018 is available in both old-fashioned PDF format as a free download from here  and the more useful Apple Book format as a free download   from here   ( open this link in a browser and then click on the blue “View in iBooks” button below the cover-picture ). As usual, all feedback is welcome and if I have missed a session or a hands-on lab that you think should be included in this guide then send me a quick email with the details: keith.lak...

That’s right: Autonomous Data Warehouse Cloud is LIVE  and available in the Oracle Cloud. ADWC Launch Event at Oracle Conference Center We had a major launch event on Thursday last week at the Oracle Conference center in Redwood Shores which got a huge amount of press coverage. Larry Ellison delivered the main keynote covering how our next-generation cloud service is built on the self-driving Oracle Autonomous Database technology which leverages machine learning to deliver unprecedented performance, reliability and ease of deployment for data warehouses. As an autonomous cloud service, it eliminates error-prone manual management tasks and, most importantly for a lot readers of this blog, frees up DBA resources, which can now be applied to implementing more strategic business projects. The key highlights of our Oracle Autonomous Data Warehouse Cloud include: Ease of Use: Unlike traditional cloud services with complex, manual configurations that require a database expert to...

If you missed all the major announcements from OpenWorld 2017 about Oracle Autonomous Data Warehouse Cloud  then take some time to review this blog post Review of Big Data Warehousing at OpenWorld 2017 - Now Available . Take a look a Chapter 2 - YOUR ORACLE DATA WAREHOUSE IN THE AUTONOMOUS CLOUD. Once you have fully digested the powerpoint presentations and videos included in Chapter 2 you will then be ready to watch this exciting new video: Below is an excerpt of Thomas Kurian’s Keynote session at Oracle Cloud World in Feb 2018. In this video, George Lumpkin, VP of Product Management, shows how easy it is to create an new data warehouse inside the Oracle Autonomous Data Warehouse Cloud, how fast and elastic it is and how quick and easy it is to integrate with other parts of Oracle's Cloud portfolio - in this case Oracle Analytics Cloud. This demo will take you from zero-to-dashboard in around 10 minutes!    For the full-length video of Thomas Kurian's keynote at O...

Did you miss OpenWorld 2017? Then my latest book is definitely something you will want to download! If you went to OpenWorld this book is also for you because it covers all the most important big data warehousing messages and sessions during the five days of OpenWorld. Following on from OpenWorld 2017 I have put together a comprehensive review of all the big data warehousing content from OpenWorld 2017. This includes all the key sessions and announcements from this year's Oracle OpenWorld conference. This review contains the following information: Welcome - an overview of the contents. Let’s Go Autonomous - containing all you need to know about Oracle’s new, fully-managed Autonomous Data Warehouse Cloud . This was the biggest announcement at OpenWorld so this chapter contains videos, presentations and podcasts to get you up to speed on this completely new data warehouse cloud service. Keynotes - Relive OpenWorld 2017 by watching the most important highlights f...

Day 2, Monday, is here and this is my definitive list of Must-See sessions for today. The list is packed full of sessions and labs that follow on from yesterday's (Sunday) big announcements around Oracle Autonomous Database and Oracle Autonomous Data Warehouse Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts. MONDAY's MUST-SEE GUIDE Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well. Have a great conference. If you are here in San Francisco then enjoy the conference - it's going to be an awesome conference this year. Don't forget to make use of our Big DW #oow17 smartphone app which you can...

In my last post I looked at Oracle’s Cloud Services for data warehousing and described how they are based around engineered systems running the industry’s #1 database for data warehousing, fully optimised for data warehousing workloads and providing 100% compatibility with existing workloads. Most importantly, Oracle customers can run their data warehouse services on-premise, in the Cloud or using hybrid Cloud using the same management and business tools. I also looked at how Oracle’s Cloud Services for data warehousing are designed to simplify the process of integrating a data warehouse with cutting edge business processes around big data. Oracle Cloud offers a complete range of big data services are available to speed up the monetisation of data sets: Oracle Big Data Cloud Service, Big Data Preparation Cloud, Big Data Discovery, IoT Cloud. In this post, the last in this series, I am going to discuss Oracle’s cloud architecture for supporting data warehousing projects. Complete ...

In the last blog post ( Data Warehousing in the Cloud - Part 1 ) I examined why you need to start thinking about and planning your move to the cloud: looking forward data warehousing in the cloud is seen as having the greatest potential for driving significant business impact through increased agility, better cost control and faster data integration via co-location. In the last section I outlined the top 3 key benefits of moving your data warehouse to the Oracle cloud: it provides an opportunity to consolidate and rationalise your data warehouse environment, it opens up new opportunities to monetise the content within your warehouse, new data security requirements means require IT teams to start implementing robust data security systems alongside comprehensive audit reporting. In this post I am going to review Oracle’s cloud solutions for data warehousing, how Oracle’s key technologies enable Data Warehousing in the cloud and why Oracle’s Cloud runs Oracle better than any other clo...

Why is cloud so important? Data warehouses are currently going through two very significant transformations that have the potential to drive significant levels of business innovation: The first area of transformation is the drive to increase overall agility. The vast majority of IT teams are experiencing a rapid increase demand for data. Business teams want access to more and more historical data whilst at the same time, data scientists and business analysts are exploring ways to introduce new data streams into the warehouse to enrich existing analysis as well as drive new areas of analysis. This rapid expansion in data volumes and sources means that IT teams need to invest more time and effort ensuring that query performance remains consistent and they need to provision more and more environments (data sandboxes) for individual teams so that they can validate the business value of new data sets. The second area of transformation is around the need to improve the control of costs...

    Your COMPLETE REVIEW of data warehousing and big fata from #OOW16 The COMPLETE REVIEW of OpenWorld covers all the most important sessions and related content from this year's conference, including Oracle's key data warehouse and big technologies: Oracle Database 12c Release 2, Oracle Cloud, engineered systems, partitioning, parallel execution, Oracle Optimizer, analytic SQL, analytic views, in-memory, spatial, graph, data mining, multitenant, Big Data SQL, NoSQL Database and industry data models. The COMPLETE review covers the following areas: On-demand videos of the most important keynotes Overviews of key data warehouse and big data sessions and links to download each presentation List of data warehouse and big data presenters who were at #oow16 Overview of Oracle Cloud services for data warehousing and big data Details of OpenWorld 2017 and details of how to justify your trip to San Francisco Links to the data warehouse and big data product ...

“From the keynotes to the connections to the entertainment, there truly is something for everyone at Oracle OpenWorld”  … This year OpenWorld was bigger, more exciting and packed with sessions about the very latest technology and product features. Most importantly, both data warehousing and Big Data were at the heart of this year’s conference across a number of keynotes and a huge number of general sessions. Our hands-on labs were all completely full as people got valuable hands-on time with our most important new features. The key focus areas at this year’s conference were: Database 12c  for Data Warehousing Big Data  and the Internet of Things  Cloud  from on-premise to on the Cloud to running hybrid Cloud systems Analytics and SQL  continues to evolve to enable more and more sophisticated analysis.  All these topics appeared across the main keynote sessions including live on-stage demonstrations of how many of our news features ...

A great news story from one of our US data warehouse customers, Targetbase , that ties in nicely with another report that we have just issued and the themes that form the basis for my soon to be released whitepaper on in-database analytics. Who is Targetbase? Targetbase is a US base data-driven marketing agency that delivers customer engagement through database, digital, and direct marketing expertise. They are based in Iriving, Texas and have approximately 200 staff. They use data-driven insight to create powerful brand communications that combine the right messages and tactics through the best channels with optimal timing. The results are strong creative services that drive customer engagements and deliver motivated individuals, ready to take action. Targetbase uses Exadata as the analytical engine for all their data: The Targetbase use case is a great example of how data warehousing is evolving to take on a wide variety of data sources and workloads. This evolution has ...