New Experience Oracle 9i

Oracle Background information

Before we introduce Oracle 9i, let's introduce some information about Oracle company to give our friends more insight into Oracle.

In 1977, Larry Airison and Bob Miner and Ed Oates created a software development lab (Software Development Laboratories). The development of the new database technology-relational database system, and the first product named "Oracle", meaning "the source of wisdom." The 1978 Software Development Laboratory was renamed the Relational Software company (Relational Software Inc. (RSI)), and in 1982, the Relational software company was renamed Oracle Systems Corporation (Oraclesystem Corporation), Oracle is named with the name of the product. Oracle shares were officially listed on March 12, 1986, and Oracle launched the first client/server architecture database in the year. In 1987, Oracle's annual revenue reached 131 million dollars, becoming the world's largest relational database software company. Oracle officially provided the world's first Internet database--oracle 8i in 1999. 2000, Oracle launched this is the industry's first complete, Integrated E-commerce application Suite E-commerce Suite (E-business Suite), and through the application of their own E-commerce suite successfully launched E-commerce.

Today, Oracle has a Trinity E-commerce strategy that includes platform products, applications, and services, providing users with the most complete E-commerce technology and consulting services. Oracle 9i is a new generation of complete, simple E-commerce infrastructure platform products, composed of Oracle 9i database and Oracle 9i Application Server, providing all the key software infrastructure of e-business Enterprise and all the important functions needed to develop e-business application. Provides strong support for E-commerce applications and Web sites to effectively improve speed, achieve outstanding application scalability and availability, and enable users to effectively develop fast, highly available, secure and reliable e-commerce applications and Web sites without the need to consider expensive software integration and maintenance costs.

New features of Oracle 9i

Oracle 9i continues to focus on the Internet, as Oracle 8i, by providing a range of specific features and packages for the e-business environment. In addition, Oracle 9i adds new features and capabilities to expand investment in mission-critical infrastructure. Here we introduce the new features of Oracle 9i in some key development areas:

I. New features in key infrastructure areas

1. To achieve continuous data availability

Oracle 9i dramatically expands Oracle's position on Internet database availability. These include:

A. World-leading data protection environment

Oracle 9i includes a number of new features that improve data protection. In addition to the emphasis on existing standby products, a framework for monitoring, automation and control is included. Many of the tasks associated with managing standby data are also automated, including initialization implementations, error jumps, and easy handover between master and slave. Logminer is also enhanced in Oracle 9i to provide a comprehensive, sql-based log analysis.

B. Online data evolution

Oracle 9i includes a new online restructuring and redefinition of the architecture, which provides a more robust restructuring. Oracle 9i currently allows the "Create Table as Select" operation to be connected to the machine. In the new architecture, the contents of the table are copied into a new table, and the database tracks updates to the original table while the content is being copied. With the new architecture, you can change any physical property of a table, and many other logical properties can be changed. Oracle 9i also supports the online creation, rebuilding, and so on of the tier indexes on the indexing table. Administrators can also quickly stop a database to perform operations that require inactive transactions.

C. Accurate database repair

Oracle 8i contains very complete recovery capabilities, and Oracle 9i extends them by making these features more powerful and accurate. Oracle 9i includes a better way to prevent and improve disk damage. Oracle 9i can also recover from crashes faster by using the new two-pass recovery algorithm, which ensures that only blocks that need to be processed are read from and written to data files.

D. Self-service error correction

Oracle 9i contains powerful techniques for handling human errors, including the ability to authorize end users to correct their own errors in a more accurate, efficient, and easier manner. To change errors, end users need to be able to identify errors by viewing the history of changes, and they need to be able to exit the error by restoring the data to the data before the error occurred. There are two ways to query, one is to use the Oracle 9i flashback (back-Flash) query feature to allow querying of data from a certain point in the past, one of which is to use Logminer to trace the history of changes from a log file to a database.