Data Warehousing in the Cloud - Part 3

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 Architecture of Oracle’s Cloud for Data Warehousing

Oracle’s Cloud Services for data warehousing extend beyond the data management scenarios outlined in the previous sections. They cover a wide range of cloud services that together form a broad and complete set of enterprise-grade solutions for data warehousing in the cloud.


Data Warehouse Cloud Architecture

Oracle Storage Cloud Service

This provides an environment for managing staging files coming out of enterprise operational systems or ETL files that have been processed and need loading into the data warehouse. All files with the cloud are replicated across multiple storage nodes, which guarantees protection against hardware failure and data corruption. Enterprise-grade data protection and privacy policies are enforced to ensure that staging files remain secure at all times.

Oracle Database Backup Cloud Service

Oracle Database Backup Cloud Service is a secure, scalable, on-demand storage solution for backing up Oracle data warehouses, both on-premise and cloud-based, to the public cloud. The cloud infrastructure provides enterprise-grade performance, redundancy, and security to make sure that the data warehouse does not lose availability.

Oracle Data Preparation and Integration Services

This service provides a highly intuitive and interactive way for analysts and data scientists to prepare unstructured, semi-structured and structured data for downstream processing and analysis within the data warehouse. It aims to reduce the challenges of data processing and preparation of new data sets such as those linked to IoT and social media by providing a large set of data repair, transformation, and enrichment options that require zero coding or scripting.

It significantly reduces the burden of repairing, classifying, and publishing new data sets into the data warehouse, which can be on-premise or in the Oracle Cloud.

Oracle Business Intelligence Cloud Service

A best-in-class business intelligence cloud offering that provides the full array of intuitive BI tools. It includes interactive interfaces with built-in guidance, easy search, dynamic navigation, contextual analytics and tutorials to increase productivity. It offers tight integration with the sophisticated analytical capabilities of the Oracle Database and using Big Data SQL is able to integrate and join structured and unstructured data sets.

Summary

When moving to the cloud it is important to remember that all the technical requirements that have driven data warehousing over the last 20+ years still apply. A data warehouse is expected to deliver extreme query performance, scalable and robust data management, handle concurrent workloads etc. All these requirements still apply in the cloud. Oracle provides the only true enterprise-grade cloud based around a fully optimized infrastructure for data warehousing.

Oracle’s Cloud Services for data warehousing are based around engineered systems running the industry’s #1 database for data warehousing, fully optimized for data warehousing workloads and providing 100% compatibility with existing workloads. The unique aspect of Oracle’s Cloud service is the “same experience” guarantee. Customers running data warehouse services on-premise, in the Cloud or using hybrid Cloud will use the same management and business tools.

Many companies recognize that their most important use cases for moving to cloud rely on integration with big data and access to sophisticated analytics: data mining, statistics, spatial and graph, pattern matching etc. These analytical features are key to consolidation projects (moving current disconnected on-premise systems to the cloud) and delivering new projects that aim to monetize new data streams by treating them as a profit centers.

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. A complete range of big data services are available to speed up the monetization of data sets: Oracle Big Data Cloud Service, Big Data Preparation Cloud, Big Data Discovery, IoT Cloud.

Overall this provides a unique complete cloud offering: an end-to-end solution for data warehouse covering data integration, big data, database, analytics and business intelligence. Of course all of Oracle’s cloud services can be delivered as services on-premise and in the Oracle Public Cloud. The choice is yours. For more information about Oracle’s Cloud Services visit cloud.oracle.com.

Part 1 of this series is posts is available here: Data Warehousing in the Cloud - Part 1
Part 2 of this series is posts is available here: Data Warehousing in the Cloud - Part 2

Feel free to contact me (keith.laker@oracle.com)if you have any questions about Oracle’s Cloud Services for data warehousing.
Technorati Tags: 

Comments

Popular posts from this blog

My query just got faster - brief introduction to 12.2 in-memory cursor duration temp tables

Oracle OpenWorld - Highlights from Day 2

SQL Pattern Matching Deep Dive - Part 1