How Oracle's pluggable databases will work
Pluggable databases will offer new advantages in efficiency, Oracle executives argued at OpenWorld
IDG News Service - Oracle CEO Larry Ellison revealed this week at the OpenWorld conference that the next version of the company's flagship database, Oracle 12c, would feature a radical new architecture called pluggable databases.
Pluggable databases will allow multiple databases to run under one copy, or instance, of the Oracle database software, a feature he called "multitenancy."
Unlike open-source MySQL databases, work on which is largely conducted in public view, Oracle's work on its flagship database is largely conducted behind closed doors. So, the company did not reveal many details about how pluggable databases would work and the software is not due to be released for another year.
However, some basic details emerged in the days after Ellison's announcement Sunday.
Two of Oracle 12c's principal architects -- Oracle distinguished product manager Bryn Llewellyn and Oracle architect Kumar Rajamani -- talked at one conference session about how Oracle 12C differs from the current Oracle 11g database. Oracle Vice President Tom Kyte, who authors the popular Ask Tom Oracle technical blog, also spoke more about how pluggable databases will help users.
In a nutshell, the new design splits today's database into two separate entities, an act Llewellyn called "architectural separation." One portion, often referred to as the Root or the container database, will hold all the functionality and metadata required to run the database itself. The second portion will be the user's database and it will be independent from the container database.
"We separate Oracle's metadata from the tenant's metadata," Llewellyn explained. "The root contains Oracle's metadata, while the pluggable database contains the customer metadata."
Dividing the database operations cleanly from the user's content is a major transformation from traditional database architectures. Oracle 11g, and all its predecessors, could only run one database at a time, Kyte said. If an organization wanted to run multiple databases on a single server, it would need to run multiple instances of Oracle 11g, one for each database.
As the name implies, pluggable databases allow multiple tenant databases to run under one copy of Oracle 12c. In fact, Oracle 12c can run up to 250 user databases, Llewellyn said, adding that 250 is an arbitrary number that Oracle chose, and the architecture could probably support more. The new database is compatible with older Oracle databases, Llewellyn said.
This change in architecture brings a number of benefits that Oracle touted through the week, including improved efficiency, stronger security and easier upgrades.
Today, many organizations are running multiple databases on a single server or they try to build a huge database that supports multiple applications. Both approaches are inefficient, Oracle argued through the week.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- SIEM: Keeping Pace with Big Security Data Learn how SIEM can have the right database back-end and offer security intelligence that leverages contextual data to achieve a strong security posture...
- HP HAVEn: See the big picture in Big Data HP HAVEn is the industry's first comprehensive, scalable, open, and secure platform for Big Data. Enterprises are drowning in a sea of data...
- What Datapipe customers need to know about the new PCI DSS 3.0 compliance standard This handy quick reference outlines what PCI DSS 3.0 is, who needs to be compliant and how Alert Logic solutions address the new...
- Meg Whitman presents Unlocking IT with Big Data During this Web Event you will hear Meg Whitman, President and CEO, HP discuss HAVEn - the #1 Big Data platform, as well...
- The New Way to Work Knowledge Vault This Knowledge Vault focuses on how, in today's increasingly virtual world, it's more important than ever to engage deeply with employees, suppliers, partners,... All Databases White Papers | Webcasts