IT Innovation, Oracle News | April 7, 2017

Oracle Data Warehouse Solutions: Delivering Business Value from the Data Center to the Cloud

By: Edgar Haren


Leading-edge organizations differentiate themselves through analytics, and are further expanding their competitive advantage with new data sources. This initiative does include several obstacles and challenges.

Today’s digital world is already creating data at an explosive rate, but the next wave is on the horizon, and this momentum is driven by the emergence of IoT data sources. These sources include connected cars, smart-appliances, wearable technology and industrial sensor data.

As a result, IT leadership is faced with two diametrically opposed forces. On one hand, IT resources are consumed dealing with the operational challenges associated with the constant acquiring, deploying and maintaining of necessary infrastructure to support data consumption. On the other hand, IT leadership is pulled in the opposite direction to support evolving requirements of line-of-business owners. These polarizing pressures create a bitter dichotomy where IT attempts to address both demands, but becomes incapable of doing so to the satisfaction of all stakeholders.   

Why Provision Oracle Data Warehouse In The Cloud?

The scale and velocity of incoming data is placing crushing demands on traditional data marts, enterprise data warehouses, and analytic systems. Can a Data Warehouse-as-a-Service (DWaaS) cloud solution help customers meet these demands?

Many customers are proving the value of DWaaS through hosted enterprise data warehouses, “sandbox” environments, line-of-business data marts, and database backups. More advanced monetizing use cases include high-performance data management projects, data warehouses coupled with cloud computing analytics, and big data cloud implementations. Oracle is the industry's leading data management platform for delivering business insights, and has been recognized by industry analysts for its technological innovations, as well as the ability to provide customers the flexibility of product and deployment choices.

Reduced Capital & Operational Costs: The explosion of newer data sources are exposing the limitations posed by traditional software and hardware platforms. These burdens generate several negative impacts including self-perpetuating capital expenditures with diminished ROI, reduced ability to service internal customers and an IT staff focused on non-revenue generating activities.

Speed of Deployment: Because Oracle has the unique ability to innovate on both hardware and software, customers can deploy Oracle Database and related applications much more quickly than other cloud services.

Industry Mandates: Organizations in industries such as healthcare have regulatory requirements mandating the duplication of data.  A cloud data warehouse can help them fulfill these mandates while also reducing risk and ensuring business continuity.

Big Data Enablement: Oracle’s data management cloud services enable customers to implement big data solutions—either as standalone platforms or tethered to Oracle Database 12c, for a more complete solution.

Accelerated Analytics:  Customers requiring a solution for large-scale systems to conduct intensive analytics, can utilize Oracle Database Exadata Cloud Service as a fast and efficient way to gain extra capacity for temporary projects.

Oracle’s Data Warehouse Cloud Differentiation

A handful of vendors now offer data warehouse cloud services, but only Oracle offers a complete platform environment.  Let’s now do a double click to understand Oracle’s data warehouse cloud differentiation. 

Platform Completeness: Cloud services were intended to help reduce vendor sprawl and the complexity that arises from having managing multiple technology providers. However, recent studies show that enterprise customers on average subscribe to several cloud service providers and are forced to expand further.

Oracle offers a complete ecosystem of cloud services including SaaS, IaaS and PaaS. For many customers, the path to the cloud begins with SaaS, and for this segment Oracle offers the largest software marketplace including third-party solutions. Secondly, customers can choose to leverage Oracle IaaS for sandbox or line-of-business data mart environments, but keep production environments on premises. 

The key value proposition for an Oracle hybrid cloud environment is the 100% compatibility across deployments. No code changes, same software and same architecture ensure customers can leverage their existing skills and reduce the time to value. Oracle’s Data Management Cloud platform provides a complete and integrated set of capabilities for building, deploying, and managing data-driven initiatives.

An Optimized Cloud Platform for Analytics:  Oracle Database Exadata Cloud Service combines innovations across hardware and software to deliver a cloud infrastructure designed to provide the highest performing platform for running Oracle Database. Exadata was designed from the beginning as a cloud architecture featuring scale-out database servers that provide an optimized storage solution for data warehousing that delivers performance gains for large-scale queries and highly efficient data compression. Exadata software adds incremental value through features that are particularly valuable to data warehousing.

Solutions such as Smart Scan technology offload data-intensive SQL operations from the database servers directly into the storage servers. By pushing SQL processing to the storage servers, data filtering and processing occur immediately and in parallel. Only the rows and columns that are directly relevant to a query are sent to the database servers, greatly accelerating analytic queries. Exadata includes many more software capabilities that enable its unparalleled scalability, performance, and availability.

The Best Database: When we consider an environment consisting of data warehousing, big data and advanced analytics there are some innate differentiators found in Oracle Database 12c Release 2. First, we must consider the importance of availability. Oracle provides innovations such as Oracle Real Application Clusters, which removes individual database servers as a single point of failure, and Oracle Data Guard, which provides real-time data protection, availability, and disaster recovery. Performance was another key design tenet, and Oracle Database In-Memory delivers leading-edge columnar data processing to accelerate your data warehouse analytics by orders of magnitude.

Oracle also understands that companies are creating new information architectures consisting of multiple physical data stores (relational, Hadoop, and NoSQL). Technologies such as Oracle Big Data SQL make this distributed architecture into an integrated reality. Big Data SQL provides data virtualization capabilities, so that SQL can be used to access any data, whether in relational databases, Hadoop or NoSQL. Oracle Advanced Analytics offers a combination of powerful in-database predictive-analytics algorithms and open source R algorithms, accessible via SQL and R languages. 

Lastly, these heterogeneous IT environments require a facilitating element for data integration and replication.  Oracle GoldenGate solves these issues through streamlined, real-time, data delivery into the most popular big data solutions, including Apache Hadoop, Apache HBase, Apache Hive, Apache Kafka, NoSQL Databases, JDBC, Cloud Databases, data warehouses and many more. 


Oracle Database is the market leader for data warehousing, built upon a solid foundation of scalability and performance, and augmented by innovative features and powerful analytic capabilities. Oracle’s goal has been to bring its expertise, proven through on-premise solutions, and replicate this in a suite of data management cloud services that truly deliver executable value for our customers. Customers can try a variety of our cloud services with free cloud-credits. In addition, the Oracle Live SQL portal was launched to provide the Oracle database community with an easy way to test and share SQL and PL/SQL application development concepts.

Please be sure to download the latest report from Database Trends & Applications featuring the Future Of Data Warehousing - http://www.dbta.com/DBTA-Downloads/WhitePapers/New-Trends-in-Data-Warehousing-2017-7041.aspx

For more information on Oracle Data Management solutions, please visit us at  https://cloud.oracle.com/en_US/data-management  or https://www.oracle.com/database/data-warehouse/index.html

Edgar Haren is principal product marketing director for Oracle Database.


Follow Us On Social Media:

This is a syndicated post, view the original post here