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.
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:
Business Intelligence Management
Budget Management
Consolidated Management
Cash Forecast Management
Employee Expense Management
Oracle Financial Analysis System
Oracle Project Management System
Workflow Management
Early Warning System.
Related recommendations: oracle database learning tutorial
The above is the detailed content of what is oracle system. For more information, please follow other related articles on the PHP Chinese website!
Oracle's Purpose: Business Solutions and Data ManagementApr 13, 2025 am 12:02 AMOracle helps businesses achieve digital transformation and data management through its products and services. 1) Oracle provides a comprehensive product portfolio, including database management systems, ERP and CRM systems, helping enterprises automate and optimize business processes. 2) Oracle's ERP systems such as E-BusinessSuite and FusionApplications realize end-to-end business process automation, improve efficiency and reduce costs, but have high implementation and maintenance costs. 3) OracleDatabase provides high concurrency and high availability data processing, but has high licensing costs. 4) Performance optimization and best practices include the rational use of indexing and partitioning technology, regular database maintenance and compliance with coding specifications.
How to delete oracle library failureApr 12, 2025 am 06:21 AMSteps to delete the failed database after Oracle failed to build a library: Use sys username to connect to the target instance. Use DROP DATABASE to delete the database. Query v$database to confirm that the database has been deleted.
How to create cursors in oracle loopApr 12, 2025 am 06:18 AMIn Oracle, the FOR LOOP loop can create cursors dynamically. The steps are: 1. Define the cursor type; 2. Create the loop; 3. Create the cursor dynamically; 4. Execute the cursor; 5. Close the cursor. Example: A cursor can be created cycle-by-circuit to display the names and salaries of the top 10 employees.
How to export oracle viewApr 12, 2025 am 06:15 AMOracle views can be exported through the EXP utility: Log in to the Oracle database. Start the EXP utility, specifying the view name and export directory. Enter export parameters, including target mode, file format, and tablespace. Start exporting. Verify the export using the impdp utility.
How to stop oracle databaseApr 12, 2025 am 06:12 AMTo stop an Oracle database, perform the following steps: 1. Connect to the database; 2. Shutdown immediately; 3. Shutdown abort completely.
What to do if the oracle log is fullApr 12, 2025 am 06:09 AMWhen Oracle log files are full, the following solutions can be adopted: 1) Clean old log files; 2) Increase the log file size; 3) Increase the log file group; 4) Set up automatic log management; 5) Reinitialize the database. Before implementing any solution, it is recommended to back up the database to prevent data loss.
How to create oracle dynamic sqlApr 12, 2025 am 06:06 AMSQL statements can be created and executed based on runtime input by using Oracle's dynamic SQL. The steps include: preparing an empty string variable to store dynamically generated SQL statements. Use the EXECUTE IMMEDIATE or PREPARE statement to compile and execute dynamic SQL statements. Use bind variable to pass user input or other dynamic values to dynamic SQL. Use EXECUTE IMMEDIATE or EXECUTE to execute dynamic SQL statements.
What to do if oracle deadlockApr 12, 2025 am 06:03 AMOracle Deadlock Handling Guide: Identify Deadlocks: Check for "deadlock detected" errors in log files. View deadlock information: Use the GET_DEADLOCK package or the V$LOCK view to obtain deadlock session and resource information. Analyze deadlock diagram: Generate deadlock diagram to visualize the lock holding and waiting situation and determine the root cause of the deadlock. Rollback deadlock sessions: Use the KILL SESSION command to roll back the session, but it may cause data loss. Interrupt deadlock cycle: Use the DISCONNECT SESSION command to disconnect the session and release the held lock. Prevent deadlocks: Optimize queries, use optimistic locking, conduct transaction management, and regularly
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
SublimeText3 Mac version
God-level code editing software (SublimeText3)
