Introduction to the New Features of Oracle 10g First Release (below)
By Fenng 2003-07-10
Note: Recently Oracle has officially announced that the version of Oracle is named 10g, where G is Grid. Here.
High availability
1. Shorten the downtime of application and database upgrade
By using the StandBy database. Allows to switch between different versions of Standby and product database. Existing online redefine features support all relevant database objects.
2, flashback, any error
This version of Oracle also expands the ability of Flashback. Add a new type of log file that records the change of the database block. This new log file is also managed by the automatic disk backup and recovery function. If there is an error occurs. For example, for unsuccessful batch operations, DBA can run flashback. Use these Before Images to quickly recover the entire database to previous point in time - no resume operation. This new feature can also be used in the Standby database.
Flashback is a database level operation. It may also flash all tables back.
The ability of existing Flashback queries has also been strengthened. In this release, administrators can quickly see changes caused by specific transactions.
3, Enhanced Data Guard Infrastructure
4, safe strengthening
VPD has been improved (I hope this name will not be replaced), support more security protocols, not to say.
Data Integration
1, Oracle Streams
This version also includes Oracle Streams feature, performance, and management improvements. The new features include DownStream Capture / Offloading The Capture and Mining Actions for Product Database. Support for data types such as long, long Raw, NClob. Strengthening IOT / Cascade. Performance is also improved.
2, Data Pump
Oracle Data Pump - High-speed, parallel technical architecture, can quickly move data and metadata between the database. The initial Export / Import is replaced by Data Pump Export / Data Pump Import and provides perfect granular object selectivity.
Data Pump operation has recoverable. It is a great improvement than EXP / IMP. Archive data, logical backup data, and transferable tablespaces can be operated with Data Pump. This feature and NCR product tools have Very big similarity (even the name is very similar), what will functional performance, or let us wait and see.
Business Intelligence / Data Warehouse and Bioinformatics
1. Support for large databases
It can support the amount of data to 8E. Improved storage, backup, and recovery management also have a good support for large databases. Partitions can support indexing organizations.
2, shorten information turn-free time
The new version of Oracle provides a reinforced ETL function. It can be convenient to build large data warehouses and multiple data mages.
A new changing data capture frame allows administrators to capture and publish data changes. The new CDC function is used by Oracle's Stream technology architecture.
For the transfer of large data, the new version provides support for cross-platform across the transferable table. Allows large quantities of data to quickly get off from the database and attached to the second database.
3, enhanced external table function.
4, the function of SQL Loader is enhanced.
5, enhanced SQL analysis capabilities
Simply put is that the function of the SQL statement is greatly enhanced for BI.
6, enhanced OLAP analysis function
Oracle's built-in analysis function is enhanced. New PL / SQL and XML interfaces are available.
New parallelism is provided to facilitate aggregation and SQL Impert operation. Some algorithms are improved. At the same time OEM can be used to monitor and manage data mining environments
7, BioInformatics support.
This version contains specific support for BioInformatics technology. Includes Native Support for Double and Float data types. Built-in statistical functions support common ANOVA analysis.
8, the ability to improve data mining
Extended data management
1, XML enhancement
2. Multimedia is in the previous version, there is a restriction of the media file 4G. Now the 4G size limit of the media file is removed (now restrictions are: 8-128t). Multimedia data can be accessed by SQL multimedia standards. Support for more new multimedia formats. 3, documentation and text management provides the function of automatically discovering unknown documents. Support new German spelling rules Japanese Adverb, etc.
The text index of the local partition can be created online. Documents can be inserted when index creation and reconstruction. Document services, such as highlighting, no need to rebuild indexes.
The ability to retrieve documents is also improved.
Strengthening application development
1, SQL language strengthening
SQL and PL / SQL support for regular expressions. Excited characteristics, this feature is afraid to write a habit of many people programming. Perhaps you can see a SQL statement to complete more complex features.
This version also supports the function of expression filtration.
2, PL / SQL Enhanced Most Important Double PL / SQL Optimization Compiler provides a framework to effectively optimize compilation PL / SQL program.
This version has also introduced two new database packages: utl_compress, utl_mail.
3, globalization and Unicode enhancements
Provides the Globalization Development Kit (GDK). Oracle NLS definition file starts with a platform-independent.
4, Java IMProvements
Better support for JDBC.
Other also include: OCCI and Pre Compilers improvements; improvements in database web services; the strengthening of web-based development environment.
Source: Oracle WhiteBooks. It belongs to a general translation. Welcome to join the discussion.
