Database as a Service: Intel Technology Optimizations for Oracle Database 12c

Oracle Database innovation continues on Oracle Database 12c by optimizing the use of Intel Xeon Processors for the compute and storage nodes. Oracle multitenant database lets you plug into the cloud by allowing for multiple configurable databases to join a master container database, resulting in lower processing and memory overhead. The performance and energy efficiency of Intel Xeon Processors further enables Oracle to drive this innovative approach to IT, creating a better way to scale critical information processing needs in any company Pauline Nist (@panist), General Manager, Intel Datacenter Software Division June 25th marked the release of the new, much discussed Oracle Database 12c. The "c" in 12c stands for cloud and this database represents Oracle's attempt to realign conventional cloud infrastructures onto a database architecture to increase security, improve compute and storage efficiency, and simplify management in the cloud.

What Oracle Database 12c introduces is a new architecture called a containerized or multitenant (pluggable) database that enables multitenancy at the database layer. In Oracle's words, you can now "plug into" the cloud's a formidable engineering achievement. But is this really a cloud technology in a true IaaS sense? Traditional cloud infrastructures feature multitenancy at the application layer: if you want to run multiple database operations on traditional IaaS and SaaS cloud infrastructure, you will need to run multiple individual instances of a database application for each database.

This results in each server running multiple database applications simultaneously, to the detriment of efficient memory, compute, and operations management. Oracle's new architecture is made up of a database container running a single container database (similar to yesterdays DB instance) of the 12c database software, which provides the functionality and high-level metadata necessary to run the database itself. Within this database container, users can then plug in multiple independent multitenant (formerly private in pre-release documentation) databases that operate on the 12c infrastructure. The 12c database keeps the independent databases separate, but allows them to share underlying hardware and resources like memory, processing and file storage. In theory, the separation between two "pluggable" databases is as impermeable as the separation between two independent, standalone databases in unconnected servers.

This multitenant database architecture offers great improvements for data security and provides many operational and management benefits. Creating a Database-as-a-Service (DaaS) model is certainly a major feat and may represent a great business opportunity, as it may trump many of the advantages of current SaaS and IaaS product offerings. Simply put this has raised the bar for yesteryears schema separation and consolidation. This can also help at the application code layer. Oracle 12c virtualizes the database layer to reallocate memory usage and maximize utilization of compute nodes to increase database flexibility. But how do these virtualized database services plug into the cloud? From what I'm hearing DaaS doesn't equal the IaaS that you'll get from VMWare vSphere 5.5 or Microsoft Hyper-V. DaaS only virtualizes the storage & compute layers, but not the network. Hence, kind of cloudy, but not fully cloudy. Nevertheless, DaaS is a huge innovation, likely a game changer for Oracle and the database industry as a whole.

Learn more about the general availability here and Intel’s participation at launch here. So you may ask what have Intel engineers contributed to the Oracle Database 12c robust revolutionary feature set? Specifically, Intel has helped with threading algorithms, minimizing checksum issues, improving NUMA scalability and optimizing it for Intel Xeon Processors with SIMD and AVX instruction set implementation. Follow the growing list of data management & #Bigdata @TimIntel followers.

Published on Categories Archive
Tim Allen

About Tim Allen

Tim is a strategic relationship manager for Intel driving enablement for enterprise software companies related to the cloud, big data, analytics, AEC, commercial VR, datacenter, and IoT. Tim has 20+ years of industry experience including work as a systems analyst, developer, system administrator, enterprise systems trainer, product marketing engineer, and marketing program manager. Prior to Intel Tim worked at IBM, Tektronix, Intersolv, Sequent and Con-Way Logistics. Tim holds a BSEE in computer engineering from BYU and an MBA in finance from the University of Portland. Specialties include - PMP, MCSE, CNA, HP-UX, AIX, Shell, Perl, C++