Introduction to the new features of Oracle 10G I release (next)

Oracle
Introduction to the new features of Oracle 10G I release (next)

by Fenng 2003-07-10

NOTE: Recently Oracle has officially announced that this version of Oracle named 10G, where G is the meaning of the grid. hereby correct.


The strengthening of high availability

1. Reduce downtime for application and database upgrades

By using the standby database. Allows switching between different versions of the standby and product databases. Existing online
Redefining functionality enables you to clone all related database objects in one step.

2, Flash back (flashback) any errors

This version of Oracle also expands the capabilities of flashback. Added a new type of log file, This file records changes to the database block. This new log file is also managed by the automatic disk backup and restore feature. If there is an error. For example, a DBA can run flashback for unsuccessful batch operations. With these before Images quickly restores the entire database to a previous point in time-no recovery operation is required. This new feature can also be used in the standby database.

Flashback is a database-level operation. It is also possible to flash back the entire table.

The capacity of existing flashback queries has also been strengthened. In this release, administrators can quickly see the changes caused by a particular transaction, and so on.

3, enhanced Data Guard infrastructure

4. Security strengthening

VPD has been improved (hopefully this name will not change to anything else), supporting more security protocols and not saying much.

DATA Integration

1. Oracle streams

This release also includes Oracle streams features, performance, and management improvements. New features include downstream capture/offloading the capture and mining operations on the product database. Support for data types such as long, long RAW, NCLOB is enhanced. The iot/cascade deletion is enhanced. Performance is also improved.

2, Data Pump

Oracle data pump--A high-speed, parallel technology architecture that enables rapid movement of data and metadata between databases.
The original export/import was replaced by the Data Pump export/data Pump Import and provided a perfect granularity of object selectivity.

The Data pump operation is recoverable. Think more than Exp/imp, there has been a great improvement.
Archived data, logical backup data, and removable tablespace can be manipulated using the pump.

This feature is very similar to NCR's product tools (even the names are very similar), what will be the functional performance, let us wait and see.


Business Intelligence/Data warehousing and bioinformatics (bioinformatics)

1, the support of the Super large database

can support up to 8E of data volume. Improved storage, backup, and recovery management also have great support for large databases.
Partitions can support indexing organization tables.

2, shorten the information turnaround time

The new version of Oracle provides enhanced ETL capabilities. Easy to build large data warehouses and multiple data marts

A new change data capture framework allows administrators to easily capture and distribute data changes. The new CDC feature uses the Oracle Stream technology architecture.

For large data transfers, the new version provides cross-platform support for the transfer table. Allows large amounts of data to be quickly detached from the database and attached to a second database.

3, enhanced external table function.

4, the function of SQL loader is strengthened.

5, enhanced SQL analysis capabilities

Simply put, the functionality of the SQL statement is greatly enhanced for BI.

6, the Enhanced OLAP analysis function

Oracle-built analytics is enhanced. Provides a new interface based on Pl/sql and XML.

New parallelism capabilities are provided to facilitate aggregation and SQL Impert operations.
Some algorithms have been improved. OEMs can also be used to monitor and manage data mining environments

7, bioinformatics support.

This release contains specific support for the bioinformatics technology. Includes native support for double and float data types. Built-in statistical functions support common ANOVA analysis.

8. Improved data mining capabilities

Extended Data Management

1, the enhancement of XML

2. Multimedia
In the previous release, there was a restriction on the media file 4G. The 4G size limit for the media file is now removed (the limit is now: 8-128t). Multimedia data can be accessed through the SQL Multimedia standard. Provide support for more new multimedia formats.

3. Document and Text management
Provides the ability to automatically discover languages and character sets for unknown documents. Support for new German spelling rules Japanese adverb, and so on.

The text index of the local partition can be created online.
The document can be inserted when the index is created and rebuilt. Document services, such as highlighting, do not need to rebuild the index.

The ability to retrieve documents is also improved.

The strengthening of application development

1, the enhancement of SQL language

SQL and PL/SQL support for regular expressions. An exciting feature that is afraid to rewrite many people's programming habits. You might see an SQL statement that accomplishes more complex functions.

This version also supports the function of expression filtering.

2, the enhancement of pl/sql
The most important when the number of new Pl/sql Optimizer compilers provides a framework for effectively optimizing the compilation of Pl/sql programs.

This release also introduces two new database packages: Utl_compress, Utl_mail.

3. Globalization and the enhancement of Unicode

Globalization Development Kit (GDK) was provided. The Oracle nls definition file begins to have platform independence.

4, Java improvements

Better support for JDBC.

Others include the following:
Improvement of OCCI and Pre compilers;
Improvement of database Web services;
The enhancement of web-based development environment.

Source: Oracle Whitebooks. is a generalization of the translation. You are welcome to join the discussion with this interested person.