Oracle Database (10g)

The key role of Oracle 10g database:

1, reduce management costs;

2, improve performance;

Enhancements to Oracle 10g include:

1, high availability enhancement, new flashback ability, support rollback update operation;

2, to enhance the security, easy to manage a large number of users;

3, the BI aspect enhancement, including the improved SQL ability, the analysis function, the OLAP, the data mining ability and so on;

4, the ability to store non-relational database is improved;

5, the ability of XML;

6. Strengthen support for development ability and support to bioinformatics.

Key features of Oracle 10g:

1, performance expansion and expansion capabilities

(1) Support for new architectures

(2) High-speed data processing capability

(3) RAC workload Management (a new service framework. Enables administrators to set up as services to manage monitoring application load)

(4) Partitioning for OLAP (the ability to provide a large number of concurrent insertions by supporting the global index of a hash partition)

(5) New improved scheduler (introducing a new database scheduler to provide enterprise-level scheduling)

2. Manageability (This version has been simplified)

(1) Simplified database configuration and upgrade

(2) Automatic storage Management

(3) automatic disk-based backup and recovery

(4) Application optimization

(5) Automated statistical collection

(6) Automation instance adjustment

(7) Automatic memory adjustment

3, the enhancement of high availability

(1) Reduce downtime for applications and data upgrades

(2) Back Flash (Flashback) any errors

(3) Enhanced Data Guard Infrastructure

(4) Strengthening of security

4. Business Intelligence

(1) Large database support (can support to 8E database)

(2) Shorten information turnaround time (easy to build large database warehouses and multiple data marts)5. Extended Data(1) Enhancements to XML(2) Multimedia(3) Document and text management

Oracle Database (10g)