Andy Mendelsohn, senior vice president of database server technology at Oracle, said, "Oracle Database 11g builds on Oracle's 30 years of design experience to provide organizations with next-generation information management capabilities. Our customers are facing unprecedented pressures from rapidly growing data, increasing data integration and the continuing cost of information technology to enable data connectivity. oracle database 10g pioneered as the database designed for grid computing, and more than half of Oracle's customers have already migrated to Oracle database 10g. to accelerate the adoption of the Oracle Grid To accelerate the adoption of Oracle Grid and to scale the Oracle Grid, our customers asked us to provide some key features, and Oracle Database 11g delivers. As our customers have said, Oracle Database 11g truly overcomes challenges and enables real innovation."
Oracle Database 11g helps organizations manage corporate information, gain deeper insight into business conditions and quickly and confidently adjust to the changing competitive environment. The new release enhances Oracle Database's unique database clustering, data center automation and workload management capabilities. Oracle customers can meet the most demanding transaction processing, data warehousing and content management applications on a secure, highly available and scalable grid of low-cost servers and storage.
Andy Mendelsohn, senior vice president of database server technology, Oracle
Real-time application testing component reduces the time required to make changes, and reduces the associated risks and costs
Oracle Database 11g features advanced self-service management capabilities and automation to help organizations meet the requirements of service level agreements. For example, for organizations that need to regularly upgrade their databases and operating systems and make hardware and system changes, the Oracle Real Application Testing (OAAT) component of Oracle Database 11g is well suited. This capability makes Oracle Database 11g the first database ever to help organizations quickly test and manage changes to their IT environments in a controlled and cost-effective way.
Improving Return on Investment for Disaster Recovery Solutions
The Oracle Data Guard component of Oracle Database 11g helps customers utilize standby databases to improve the performance of their production environments and to protect them from system failures and large-scale disasters.The Oracle Data Guard component can simultaneously read and The ability to simultaneously read and restore a single standby database is unique in the industry, allowing Oracle Data Guard to be used for reporting, backup, testing and "rolling" upgrades to production databases. By offloading the workload from the production system to the standby system, Oracle Data Guard components also help improve the performance of the production system and comprise a more cost-effective disaster recovery solution.
Enhanced Information Lifecycle Management and Storage Management Capabilities
Oracle Database 11g features extremely new data segmentation and compression capabilities that enable more cost-effective information lifecycle management and storage management. Many of the data partitioning tasks that need to be done manually have been automated in Oracle Database 11g. Oracle Database 11g also extends the existing range, hash, and list partitioning capabilities by adding spacing, indexing, and virtual volume partitioning capabilities. In addition, Oracle Database 11g has a complete set of composite partitioning options that enable business rule-oriented storage management.
Oracle Database 11g builds on proven data compression capabilities to enable advanced structured and unstructured data compression in transaction processing, data warehousing, and content management environments. With the advanced compression capabilities in Oracle Database 11g, all data can achieve compression ratios of 2x to 3x or higher.
Total Recall of Data Changes
Oracle Database 11g features the Oracle Total Recall component, which helps administrators query data in a specified table at some point in the past. This is a simple and practical way for administrators to add a temporal dimension to data in order to track changes, perform audits, and meet regulatory requirements.
Maximizing Information Availability
Oracle has always led the industry in protecting database applications from planned downtime and unplanned outages, and Oracle Database 11g further strengthens this leadership position, as database administrators can now more easily meet user availability expectations. New availability features include: Oracle Flashback Transaction, which makes it easy to undo erroneous transactions as well as any related transactions; Parallel Backup and Recovery, which improves backup and storage performance for very large databases; and Hotfix, which allows database patching without shutting down the database. Hotfix, which allows database patching without shutting down the database, improves system availability. In addition, a new advisor software, Data Recovery Advisor, automates problem investigation, determines recovery plans with sufficient intelligence, and handles multiple failure scenarios to dramatically reduce the downtime required for data recovery.
Oracle Fast Files
Oracle Database 11g features next-generation capabilities for storing large objects in the database, including images, large text objects, or advanced data types such as XML, medical imaging data, and three-dimensional objects. Oracle Fast Files component enables database applications to fully match the performance of the file system. By storing a broader range of corporate information and retrieving it quickly and easily, organizations can gain a deeper understanding of their business and adjust their operations more quickly to market changes.
Faster XMLIn Oracle Database 11g, the performance of XML DB, a component of Oracle Database that enables customers to store and manipulate XML data natively, has been dramatically improved. 11g of Oracle Database adds support for binary XML data, and customers can now choose the XML storage that is right for their particular XML DB can also manipulate XML data through industry standard interfaces that support standards such as XQuery, JSR-170, and SQL/XML.
Transparent Encryption Oracle Database 11g further enhances the unrivaled security of Oracle Database. This new version of the database enhances Oracle Transparent Data Encryption by extending this capability beyond volume-level encryption.Oracle Database 11g features tablespace encryption, which can be used to encrypt entire tables, indexes, and other data stored. Large objects stored in the database can also be encrypted.
Embedded OLAP rows
Oracle Database 11g also introduces innovations in data warehousing. OLAP rows can now be used in databases like materialized graphs, so developers can query data using industry-standard SQL while still benefiting from the high performance of OLAP rows.
The new Continuous Query Notification component notifies applications of important changes to database data as soon as they occur, without burdening the database with constant polling.
Connection Aggregation and Query Result Caching
The performance and scalability enhancements in Oracle Database 11g help organizations maintain a high-performance and highly scalable infrastructure to deliver the highest quality of service to their users. leadership in performance and scalability with the addition of new features such as query result caching. Query result caching improves application performance and scalability by caching and reusing frequently invoked database queries as well as database and application tier functions. The Database Resident Connection Pooling feature improves Web system scalability by providing connection pooling for non-multithreaded applications.
Enhanced Application Development Capabilities
Oracle Database 11g provides a wide selection of development tools for developers to choose from, offering a streamlined application development process that takes full advantage of the key features of Oracle Database 11g, including: client-side caching, binary XML for speeding up applications, XML processing, and file storage and retrieval. In addition, Oracle Database 11g features a new Java real-time compiler for faster execution of database Java programs without the need for a third-party compiler; native integration with Visual Studio 2005 for developing . Tools; SQL Developer makes it easy to build queries to quickly code SQL and PL/SQL routines.
Enhanced Self-Help Administration and Automation Capabilities
Oracle Database 11g provides a variety of administrative capabilities to help organizations easily manage their enterprise grids and to meet user service level requirements. application performance, scalability, availability, and security. new Oracle Database 11g administration features include: automated SQL and memory fine-tuning; a new Partitioning Advisor component that automatically advises administrators on how to partition tables and indexes to improve performance; and enhanced database cluster performance diagnostics.