Detailed description of various technical features of Oracle 9i

Source: Internet
Author: User
Tags end extend file system functions include new features version oracle database

Before we introduce oracle9i, we'll introduce some information about Oracle, and let your friends know more about 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 (Oracle System 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--oracle8i 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. Oracle9i is a new generation of complete, simple e-business infrastructure platform products, composed of oracle9i database and oracle9i 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.

2. Scalability and performance

Oracle 9i allows e-business to be extended to tens of millions of users, and each user performs millions of of things per hour. Including: 9i Real Application Clusters-cache Fusion

Oracle 9i Real Application clusters enables the application of the database for high availability, scalability, and high performance without modification. The Oracle 9i cache Fusion architecture uses the aggregation cache of all nodes in the cluster to satisfy the database request. Oracle 9i Cache Fusion transports data blocks directly from one node's cache to another's cache in read/read, read/write, and write/write contention. This is based on the previous Oracle 8i Cache Fusion execution that deals with read/write contention.

B. Scalable session-state management

New shared memory features, improved JAVA session support, networking, and multi-line server improvements have significantly reduced the coverage required for each user on Oracle 9i-allowing more users to be hosted on the same or larger hardware platform.

C. Optimization characteristics that play a key role in electronic commerce

Specific performance improvements in Oracle 9i focus on areas and performance that are critical to improving e-business solutions. The support for improved Pl/sql optimizations for local compilation greatly improves the performance of many applications today. For connections between application servers and Oracle 9i databases on the back end, the new features of Oracle Net Services--vi (virtual Interface, Protocol) Support performance improvement 10%. In addition, specific network interface optimizations, newly improved virtual line I/O, and unified event/wait patterns greatly improve client/server communication performance. Using OCI to redo database/database communication improves the performance of distributed databases.

3. Provide end-to-end security architecture

Oracle 9i continues to provide the industry's most secure application platform and deployment platform. Including:

A. Robust three-storey security

Enhanced three-tier security through proxy authentication, including X.509 license file or discriminant (DN) credit agents, support for fat JDBC, Connection Sharing for application users (fat jdbc and thin jdbc, OCI), and integration with Oracle Internet directory.

B. PKI based on the standard

The standards-based PKI for Oracle Advanced security (Advanced secure) includes the public Key certificate (PKCS) #12的支持, allowing existing PKI credits to be shared by Oreacle Wallet, This reduces the cost of PKI deployment and enhances interoperability.

C. Deep Database protection

Oracle Label Security, a product based on Viretual private database (virtual private databases, VPD), has a stronger VPD function, more granular audit, can provide more reassuring host safety. Granular auditing allows for the definition of audit policy, which enables the database to specify the access that triggers the corresponding audit event, and utilizes a flexible event handler to notify the system administrator of the event that is triggered.

D. Improved enterprise user security (for enterprise users)

Oracle Advanced Security's Enterprise user security has been enhanced, including the ability to provide password-based user management in Oracle Internet directory, and password management enhancements. These have facilitated improvements in user and security policy management.

E. Data encryption

Oracle has added a data storage encryption feature that incorporates a secure random number generator (RNG) into Dbms_obfuscation_toollkit. Label Security (Oracle label secure)

Oracle Label Security is a precision granular access control product. It adds a special label to the data row, providing complex and flexible label security. Internet directory (Oracle Internet directory)

Oracle 9i supports LDAP technology to manage the network naming system and facilitate system deployment, with more than 10 or tens of thousands of users per database, regardless of whether the customer owns one or hundreds of databases.

4. Development platform for E-business applications

Oracle 9i continues to provide the best development platform for e-business applications and the development of traditional applications. Including:

A.enterprise Java Engine

In the third edition of Oracle 8i, a series of Java features have been provided, and Oracle 9i Database First edition support for Java is focused on: improving the performance of embedded Java Virtual Machine (virtual machines), providing new IDBC and SQLJ capabilities , enhanced Java stored procedures, and bug fixes to the EE container.

B.xml supports-xml types and XDK

Oracle 9i features a number of enhanced database operations that store XML in the database through SQL and convert traditional database data to XML. Two major XML domains are supported in Oracle 9i, one is the built-in AML Developer Kit (XML Development Kit, XDK), and one is the native XML type.

C.sql and Pl/sql Improvements

SQL and Pl/sql have been improved in Oracel 9i to meet the requirements of modern development. In addition to local compilation, the overall Pl/sql compilation is improved. Support for enhancing the usefulness, inheritance, type evolution, and dynamic method allocation of objects is supported in Oracle 9i. Oracle 9i also supports new ANSI requirements, including support for case statements, ANSI-compliant links, and reserved version annotations.

5. Manageability

Management is one of the main improvements to Oracle 9i. The management approach taken by Oracle 9i has five aspects:

A. Self-managing data

Oracle 9i databases manage their own undo (fallback, Rollback) segments-administrators no longer need to carefully plan and optimize the number and size of fallback segments, or worry about assigning transactions to specific fallback segments on a policy. Memory management is another area in Oracle 9i that gives significant control.

B. Improved and streamlined operational management

Other traditional management areas of the database have also been improved. With the introduction of persistent Init.ora characteristics in Oracle 9i, parameter changes persist in multiple closures.

C. Sophisticated, automated resource management

The introduction of database Resource Manager in Oracle 8i has been greatly enhanced in Oracle 9i, with the ability to control finer resources and add new features.

D. Management tools and techniques

Oracle 9i also offers new features, tools, and techniques that make it a pleasure for administrators to leave little work. In Oracle 9i, Oracle Enterprise Manager continues to provide Easy-to-use management tools that support new features of the database and the entire e-business platform. To further simplify management tasks, Oracle Enterprise Manager includes guided expert diagnostics and problem solving. All basic management functions are web-based, and administrators can manage their systems directly from a Web browser.

E. End-to-end System Management solutions

In Oracle 9i, Oracle Enterprise Manager also allows administrators to exceed the scope of monitoring only the performance of a single target, such as a database, where administrators can monitor the response of an entire Oracle-based system and ensure that they meet the required business service-level engagements.

6.Windows Integration

Oracle 9i is a leading position on the Windows 2000 platform. Including:

A. Integration with Windows 2000

Oracle 9i supports better integration with Microsoft Transaction Servise, Microsoft Message Queuing, and Internet information Services. The PKI architecture and single signon features in Oracle 9i are also well integrated with Windows 2000, Active Directory, and Microsoft certificate Store.

B. Development and deployment on the MS Windows platform

For Windows developers, Oracle 9i provides an enhanced local OLE DB provider. Oracle Object for Windows supports XML, database event (DB events), and Oracle 9i OCI extensions.

Second, the development of key application areas of new features:

1.Internet content Management (Internet Contents Manager)

Oracle 9i allows customers to store, manage, and merge all types of multimedia content into a single database. Oracle 9i greatly strengthens the Oracle 8i database functionality to serve as a platform for creating, managing, and delivering Internet content. Including:

A. Storing and managing all types of content

Oracle 9i includes the Internet file System (FileSystem) version 1.2 release, which is a revolutionary extension of Oracle 8i databases. Oracle IFS provides the best part of the world of relational databases and file systems.

B. Web Application content Syndication organization

Oracle 9i also includes an enhanced infrastructure that supports Internet services and content Singadi organizations for portals, transactions, and other English-Internet applications through dynamic service.

C. Search and indexing

Oracle 9i is built on powerful database functionality to search for all types of content (including text and multimedia). The Ultra search in Oracle 9i searches across different companies ' information centers, Web sites, and groupware content areas.

D. Collaborative projects

Oracle 9i adds the ability to create shared workspaces to support long-term collaborative projects. Workspace support is available for existing content and allows existing applications to run transparently to the workspace view of the database.

E. Content that can be positioned and moved at any time

Oracle 9i, with Oracle Spatial, provides support for Oracle e-business, portals, and wireless ASP applications, and can easily incorporate positioning capabilities into their services.

2. E-commerce Integration

E-commerce integration includes:

A. Support millions of standard business messages per hour

Oracle 9i provides a standard infrastructure that makes it easier for customers to integrate stores, transactions, and portals with other back-end and external systems.

B. Distributed environmental improvements

In Oracle 9i, the Advanced Replication is enhanced to provide support for multiple, fast refreshes of the object data types in replicated tables, multi-tier updatable materialized views, and materialized view subqueries. Reduces the need to stop the database and improves the availability of typical scenario maintenance activities.

C.web Service Support

Oracle 9i Dynamic Services is a new java-based, service-oriented framework that supports content aggregation for Internet applications. Dynamic Servise enables developers to encapsulate application logic from Web sites, local databases, or other proprietary systems into services, and to facilitate the incorporation of these services into other applications.

3. Packaged applications


A. Globalization-expanding electronic commerce to the world market

Oracle 9i supports the development and deployment of multilingual applications on a central database and intermediate tier platforms, dramatically reducing the cost and cost of maintaining global content.

B. Providing tactical development features required by ISVs

Oracle 9i continues to be the best platform for ISV development, deployment, hosting, and porting. Features such as updatable, scrollable cursors, and ANSI case statements, date-time data types, and connection syntax migrate from applications that will be developed on other databases to Oracle 9i.

4. Business Intelligence Platform

Oracle 9i eliminates barriers to provide the best platform support for business intelligence in large and medium-sized enterprises, with particular emphasis on the challenges of High-volume data and the need for approximate, real-time, complex analysis in an e-business environment. Including:

A. Scalability, performance, and manageability

Performance, scalability, and manageability are basic requirements for business intelligence applications. As in the previous database release, Oracle 9i provides significant enhancements in each of these areas. Extend the partition capabilities of Oracle 9i to support list partitions and extend the basic partitioning functionality to cover all available data types in Oracle 8i.

B. Complete business intelligence Platform: Integrated ETL (Integrated ETL) and analysis (analytics) features

Oracle 9i is designed as a complete data warehouse platform that uses an Oracle database as a scalable data engine for all operations on data warehouse data. Oracle 9i features improvements for Java development tools. With the above analysis of Oracle 9i new features, we have summarized Oracle 9i enhancements for Java development tools:

1.Oracle 9i has improved the performance of e-business solutions, with Java, improved collection of useless unit collections, better local compilation, enhanced object sharing and session connectivity, and improved application performance for rows built into the database in Java.

2.Oracle 9i in the E-commerce application development platform for Java, improve the performance of embedded Java Virtual Machine (virtual machine), in the Java stored procedures to increase the return of multiline Records (Refcursors).

3.Oracle 9i adds support for intermedia images, audio, and video on the Internet's content storage and management capabilities. Oracle 9i greatly simplifies the new multimedia format by merging Java imageing (Jai,java advanced image Processing) into the database and providing support for the Java Media Framework (Jmf,java Media framework) in Intermedia , processing and providing the media function. In addition, it is now possible to access Intermedia audio, video and Image media processing services in the same way through the relevant pl/sql and Java interfaces.

The 4.Oracle 9i Web server is a new java-based, service-oriented framework that supports content aggregation for Internet applications.


Oracle has built its foundation for success since the 1980s. It builds the world's first fully portable, truly scalable information management platform. Today, it is the only computer platform that delivers comprehensive functionality, unlimited scalability, continuous availability, and strong security.

Oracle 9i platforms include database servers, application servers, workflow servers, e-mail servers, directory servers, portal servers, wireless servers, and so on, providing a complete and integrated solution for development and deployment of any type of application.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.