what is oracle system-Oracle-php.cn

The oracle system is a database management system built based on the Oracle relational database for data storage and management. Oracle was developed by Oracle. Oracle's entire product line includes database servers, enterprise business Application suites, application development and decision support tools.

what is oracle system

The operating environment of this article: Windows 7 system, Dell G3 computer, Oracle 11g version.

What is the oracle system?

Oracle system is a database management system built based on the Oracle relational database for data storage and management. Oracle, the world's first commercial database that supports SQL language, is positioned on high-end workstations and small computers used as servers, such as IBM P series servers, HP's Integraty servers, and Sun Fire servers. Oracle's entire product line includes database servers, enterprise business application suites, application development and decision support tools.

Introduction to Oracle:

Oracle was developed by Oracle Corporation and officially entered the Chinese market in 1989, becoming the first world software giant to enter China. Of course, Oracle was still unknown at the time, and the commercial relational database technology developed by Oracle began to serve Chinese users that year. In July 1991, Oracle established a wholly-owned company in Beijing. Oracle Database is a database system that has accumulated many leading advantages. It leads the industry in cluster technology, high availability, business intelligence, security, system management, etc.

Basically at the same time as the Oracle database, there is also the informix database system. Users of both use them differently. The Oracle database system is mostly used in the banking industry, and the Informix database system is mostly used in the communications industry.

Because ORACLE database products are typical representatives of current database technology, in addition to database systems, her products also include application systems, development tools, etc. People who are new to Oracle have this feeling: Oracle has too many products, each product has profound content, and they don’t know where to start.

In order to better understand and use the Oracle database system in a small amount of time, it is necessary to understand some basic terms and concepts of Oracle. Here are some concepts and terms often used in management for beginners. Provides convenience for scholars to quickly understand the Oracle database system.

ORACLE7 and ORACLE8

ORACLE7 is a complete relational database system that does not support object-oriented. ORACLE8 is a database system that introduces object-oriented database. It is neither a pure object-oriented database nor a pure relational database. It is a combination of the two, so it is called "object-relational database".

ORACLE8 and ORACLE8i

In later versions of ORACLE8, many improvements have been made, and ORACLE 8.0.X version appeared. However, ORACLE 8I, released (launched) in early 1998, can be regarded as an extended set of functions of ORACLE 8. Since ORACLE 8I provides more functions than ORACLE 8, in addition to the common RDBMS functions, it also provides many INTERNET-related capabilities. The most important thing is that it integrates JAVA as an internal data language. This language It can act as or replace it, and it also integrates a WEB server and development platform (Web DB). For ORACLE 8.0.x, it only ended with the ORACLE 8.0.5 version, and then the ORACLE8i 8.1.5 version was launched. The ORACLE8i 8.1.5 version is also often called Release 1; and the ORACLE8i 8.1.6 version is called Release 2; ORACLE8i 8.1.7 version is called Release 3.

ORACLE8i and ORACLE9i

At the end of 2000 before officially entering the 21st century, ORACLE officially released the new ORACLE 9i database system. It was originally expected that there might be ORACLE 8i V8.1.8 and other versions, but the ORACLE8i version was only replaced by Oracle9i after 8.1.7 was launched. ORACLE, like other software companies, is no longer willing to make more improvements and optimizations on the original version in order to seize the market, but directly launches new products as a strategy. Comparing ORACLE9i with ORACLE8i, ORACLE 9i mainly includes the following three parts:

l Database core (Database) l Application server (Application Server)

l Development tool set (Developer Suite) Oracle9i main focus (Oracle9i Focus):

l E-Business Intelligence (E-Business Intelligence).

lApplications Development

lApplication Hosting

l Portals and Content

l E-commerce Continuity (E-Business Continuity) Oracle9i is designed to integrate with the Internet market.

Oracle9i is suitable and competent for all the demanding requirements on the market.

l Oracle9I Real Application (Oracle9i Real Application)

l Oracle9I High Availability (Oracle9i High Availability) l Oracle9I System Management (Oracle9i Systems Management) l Oracle9I Security (Oracle9i Security)

Oracle9i Database Services:

lBusiness Intelligence and Data Warehousing

l Oracle9i Dynamic Services

lOracle9I JAVA and XML(Oracle9i Java and XML)l E-Business Integration(E-Business Integration)

ORACLE OAS and ORACLE iAS

The early version of ORACLE's iAS was ORACLE Web Server. Later, the 4th version was renamed ORACLE APPLICATION SERVER, and before the end of 2000, it was renamed ORACLE9i Internet. Application Server (ORACLE iAS). iAS is a comprehensive development tool that can be combined with ORACLE8i or ORACLE9i. Providing a complete Internet platform for creating and deploying any network-based application, iAS includes portals, transaction applications, business intelligence tools, wireless Internet applications, and enterprise integration. Oracle Internet Application Server provides the industry's most comprehensive range of middle-tier products, including communications, presentation, business logic, data caching and system services.

1. Communication service: ORACLE HTTP Server based on Apache, mainly includes the following modules: mod_jserv: distributes HTTP requests for servlets to the Servlet engine of Oracle iAS. Mod_perl: Distributes the HTTP requests of the perl program to the Perl Interpreter of the Apache Web Server. Mod_ssl: Provides a public key based on an SSL certificate, which is used for encrypted communication between the client and the Apache Server. Mod_plsql: Oracle's special module, used to pass HTTP requests to PL/SQL and Java stored procedures in the database.

2. The presentation service provides the following methods for content presentation: Oracle portal (Oracle portal) Apache Jserver (Apache Java server) Perl Interpreter (Perl interpreter) Oracle JavaServer Pager (JSP) Oracle PL/SQL Server Pages ( PSP)

3. The business logic service can provide the following service components: Oracle8i JVM (Java virtual machine) Oracle8i PL/SQL Java business component (BC4J) Form Service Report Service Discoverer Viewer

4. Data management service Oracle 8i cache

5. System service Oracle Enterprise Manager (Oracle Enterprise Manager) Oracle Advanced Security (Oracle Advanced Security) Developer's KITS (development tools),

includes: l Oracle database client developer's Kit l Oracle XML developer's Kit (XDK) l Oracle LDAP developer's Kit

ORACLE Application R11i

In addition to providing a perfect database system, Oracle company also A suite that provides a complete solution, a complete application system, is often called Oracle Application R11i. It is a fully integrated e-commerce suite.

It includes:

1． Data Warehouse Platform

Oracle 8i Enterprise Database Server

Oracle Warehouse Builder(Data Warehouse Builder)

2. Business Intelligence Tool Set

Oracle Discoverer

Oracle Express Product Series

Oracle darwin

3.Oracle Financial Services Application l Performance Management l Customer Relationship Management l Risk Management

4.ORACLE Finance The Internet-based financial management system includes the following modules: