Oracle Unveils 11g Database, R2 - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Government // Enterprise Architecture
10:40 PM
Connect Directly

Oracle Unveils 11g Database, R2

Release 2 of Oracle's flagship database seeks to consolidate departmental, smaller systems on a data center grid.

Oracle announced Tuesday that the second release of its Oracle 11g database system is available for download. The new release adds dozens of grid-oriented features and improves performance, the company said.

Mark Townsend, VP of database product management said in an interview that Release 2 "is a good consolidation platform. You can move smaller department databases onto the data center grid" and let one Oracle system replace several smaller systems, some of which are likely to be Microsoft's SQL Server.

By grid, Oracle means users should run its flagship product on a cluster of Intel or AMD-based servers and move away from more expensive, high end servers, where Oracle typically runs under Unix. Oracle cluster management software, Real Application Cluster, manages the grid for running databases and applications. RAC by definition is designed to run on multiple servers, but Oracle with Release 2 is offering an option to run it on a single server, called RAC One Node, where multiple databases on consolidated on the node and gain redundancy and high availability through the RAC One Node software.

In Release 2, Oracle has improved data compression and partitioning data to storage, allowing more granular assignment of data to lower cost storage. Both measures cut overall storage costs, Townsend said.

In addition, Release 2 can invoke Automatic Storage Management procedures used with data for the Oracle databases' own binary files, the code that makes it run in production. By using ASM procedures, the database itself requires less high priced storage to keep itself running, Townsend said.

Another grid feature is Release 2's ability to load data into the memory of multiple servers, and then execute high speed queries against it there. "Grid machines tend to have a lot memory. We can load a terabyte of data into memory" and treat it as a shared pool across multiple servers, he said. The feature is most likely to be utilitized in data warehousing operations, he added.

This release of 11g also allows a customer's database applications to be upgraded without taking the database system offline. This feature eliminates the need for a separate upgrade environment. As the upgraded application comes on line, it is guided to a redefined version of its database tables, and the old editions are then deleted, Townsend explained.

The system includes updated versions of automated, online technical support, such as DBA Productivity Advisor and High Availability Advisor, which provide wizard-like question and answer sessions with the DBA and make changes to the underlying system based on the responses.

InformationWeek Analytics and have published a database administrator's guide to security. Download the report here (registration required).

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
What Becomes of CFOs During Digital Transformation?
Joao-Pierre S. Ruth, Senior Writer,  2/4/2020
Fighting the Coronavirus with Analytics and GIS
Jessica Davis, Senior Editor, Enterprise Apps,  2/3/2020
IT Careers: 10 Job Skills in High Demand This Year
Cynthia Harvey, Freelance Journalist, InformationWeek,  2/3/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
IT 2020: A Look Ahead
Are you ready for the critical changes that will occur in 2020? We've compiled editor insights from the best of our network (Dark Reading, Data Center Knowledge, InformationWeek, ITPro Today and Network Computing) to deliver to you a look at the trends, technologies, and threats that are emerging in the coming year. Download it today!
Flash Poll