In 1983, OracleV3 database publishing, became the industry's first to support PC, minicomputer, and the host database
August 1991, Oracle established in Beijing, a wholly-owned company, its Chinese name "Beijing Oracle Software Systems Co., Ltd.", that is, Chinese people today the title of Oracle Corporation.
ORACLE7.0 new features
Database integrity constraints
Storage function, process, process packages
Database Triggers
View Editor
User-defined SQL functions
Role-based security
Double log file
Resource constraints
Audit to improve
Incomplete database recovery
Performance Optimization
To clear the table
SQL * NET V2
Detection point process
Data replication
ORACLE7.1 new features
Meet the American National Standards Organization ISO SQL92 standard entry
Balanced data replication
Distributed Recovery
Dynamic SQL
Distributed query optimization
Server Management
Read-only database
ORACLE7.2 new features
Can automatically expand the physical file data
Manual compression of the rollback can be
Creating tables and indexes can not be recycled
Support for subqueries in FROM clause
PL / SQL package
PL / SQL cursor variable
Inspection and
Distributed to create a table
DBMS transaction queue
DBMS_SPACE
In 1996, Oracle7.3 common database server release
The view can be split
Bit image index
In the table scan operation before the asynchronous read
Standby database
Affairs at instance startup delay recovery
You can modify the connection view
SQLDBA not custom
Index rebuild
Check the database to read and write
Context options
Spatial Data Option
Table space changes, there are combinations, temporary or permanent.
Database trigger editing and error correction
Storage parameters to support an unlimited number of data segments
init.ora parameters can be modified
HASH connection and anti-connectivity
Relationship of trust
ORACLE tracking operation
High-level replication object group
PL / SQL application function package
In 1997, Oracle launched a database for network computing Oracle8,
Object-related database
Object category increase (not a date, character, number three types)
Support international standards SQL3
Can call an external process
Each table's LOB field can be greater than 1
You can split tables and indexes
export / import of other partition table
Partitions can exist where different tablespace
online / offline, backup / recover partition table of the other
Combined and balanced partition
Advanced queue management information processing
SQL, PL / SQL, OCI performance improvement, efficient use of memory and CPU
VARCHAR2 can exceed 4000 bytes, each table field can be redundant 1000
DML statements can be distributed execution
Connection pool to support more online
"STAR" Query optimization
V $ trying to get multiple instances of the parameters, the database failed to clear a new instance of the point to point
Database data interface can handle pictures, video, context, time, space and other information
Backup and recovery performance
The introduction of security services management center
Fast refresh a snapshot, the introduction of Replication Manager
Deferred integrity constraint checking
NET8 replace SQL * NET
Keyword can be sorted in reverse
You can change any view
New ROWID format
In 1999, Oracle officially the world's first Internet database providing Oracle8i.
New features:
Internet computing
- WebDB, for creating, deploying and monitoring Web application
- IMedia
- OracleInternet file system
Java
- Database JavaVM
- Java stored procedures, functions and triggers
- In Java, SQL and PL / SQL to interact seamlessly between the
- Java code embedded in SQLJ
- Enhanced JDBC driver
Data warehouse
- Summary management
- Hash and composite partitioning
- Resource Management
- Transparent Tablespace
- Function index and virtual columns
- Online indexing and reconstruction
- Descending index
- Automatic parallel query level
- The joint index and single-sheet summary DML
- Read-only standby database
- Direct path load API
- New bitmap indexing
- Sample function
- Parallel and fine-grained ANALYZE
- Abolition of the legal limit state
- Copies of statistical data
- MERGE into operation
- Before the "n" query optimization
Transaction Processing
- Publish and subscribe capabilities
- Database event triggers
- Autonomous transactions
- Single table hash cluster
- Partition table object type column
- The partition table in the LOB
- Index-organized table partition
- Stable optimizer execution plan
Oracle Parallel Server
- For instance internal scalable query ConsistentReadServer
- Installation Wizard
- Automatic connection load balancing mechanism
- Mandatory on a particular node to perform operations
Object-relational database
- Temporary LOB
- A collection of non-nested technique
- Enhanced object view
- Enhanced Object Cache
- Enhanced SQL * Loader, support objects, collections, and loading the LOB
- LOB performance enhancements
- LONG to LOB data migration
- User-defined object identifiers and nested identifiers
- Analysis of the detection of unstable REF
Security
- Fine-grained access control
- Scalable and parameter-driven application context specification
- LDAP Integration
N-tier authentication and authorization
SSL support with X.509v3
PADIUS adapter
System management and ease of use
- Java-based multi-user Oracle Enterprise Manager
- Java-based Oracle Universal Installer
- Java-based database configuration assistant
- Use automatic instance listener registration
- Parallel parallel transaction recovery
- Cancel out
- For long-running operation in the process monitor
- Recovery Manager of Performance Improvement
- Recovery Manager capability to detect the disk affinity
- Automatic standby database
- Recovery time for instance recovery limit
- The damage block detection and repair
- Locally managed tablespaces
- Multi-file process and objectives
- Simple point in time tablespace recovery
Copy and Decision Automation
- To facilitate the deployment and deployment of complex snapshot of modules
- Offline instantiation
- Updatable snapshot in column-level subsetting
- Built-in application package
- Performance improvements snapshot refresh
- Distributed Query Optimization
- Enhanced security model
- Support OracleLite
PL / SQL improvements
- In PL / SQL (bulkbinds), the control of a SQL statement multiple data items
- In PL / SQL, the parameters passed by reference
- In PL / SQL in embedded dynamic SQL
- For tool vendors and cover PL / SQL code
- Unlimited PL / SQL package size
Scalability
- Scalable indexing mechanism
- Extensible Optimizer
- Data cartridge service
- Pro * CTM external process
- Oracle Call Interface callback registration
- In index-organized tables for secondary indexes
- Support the process of external objects
Other new features
- Support for the euro symbol
- Temporary table
- The relationship between the calling program to perform routine safety
- Integration with Microsoft Transaction Server
- NetTM the HTTP protocol adapter
- RETURNING clause of the performance improvements
June 2001, Oracle launched a new generation of Internet e-commerce infrastructure Oracle9i.
Oracle9i key focus areas include:
• Providing the world's leading zero data loss protection of the environment
• Through the support of more on-line operation off-line maintenance requirements to reduce
• Provide for the damaged database fast and accurate repair
* Allows end users to identify and correct their own errors
The world's leading data protection environment
Oracle9i includes many new features to improve data protection. In addition to the existing products of the Standby key enhancements, including a provision monitoring, automation and control framework.
And management of the standby database is on the automation of many tasks, including initialization instance, the error jumps and easily switch back and forth between master and slave. Administrators can also optionally specify that each backup site lags behind the production environment, delayed application of the log (to relieve human error or damaged line errors) and select a zero data loss mode, in this mode redo logs to be synchronized sent to the alternate site.
Also enhanced in Oracle9i LogMiner, in order to provide full SQL-based Log Analysis (log analysis). LogMiner now supports indexing of clustered tables, chain line, direct load, scalar object type, LOB, LONG data types and DDL. LogMiner also showed support for the primary key and change the content based on query logs (for example, show the employee "Smith" all changes). A new graphical user interface and other database features also make this product easy to learn, easy to use.
Online Data Evolution
Oracle9i contains a new online re-organization and re-define the architecture, this architecture provides a more powerful re-organization capabilities. Administrators can now define the table to perform various on-line operations, including the heap-organized tables online re-organization. In essence, Oracle9i now allows on-line "CREATETABLEASSELECT" operation. In this new architecture, the table is copied to a new table. While copying the contents of the database to track updates to the original table. The copy is complete, updates will be applied to the new table. Once the update is applied, you can create indexes on the new table. After creating the index will be applied to any other updates, and the results table will replace the original table. Updating the dictionary data, while only in operation at the beginning and end of the lock table in exclusive mode. Using this new architecture, you can change the form of any online physical properties. Table can be moved to a new location, a table can be partitioned, the table can also be from an organization (such as deposits) to another organization (such as indexing of).
In addition, many logical properties can be changed. For example, you can change the column name, type and size, and columns can be added, deleted or merged. The main restriction is not to modify the table's primary key.
Oracle9i also supports the current index-organized tables online last level index create, rebuild, and so on. Can now be created online indexes and analyze them simultaneously. Secondary indexes support efficient use of the block tips.
Administrators can quickly stop the database in order to perform the requested operation inactive transaction. In addition, you can dynamically adjust the Oracle9i buffer cache and shared pool size. Finally, Oracle9i can also be the object the user is online and is accessible and to verify the structure of objects (analytical validation).
Accurate database repair
Oracle8i contains very complete recovery. Oracle9i by making them more powerful and more accurate they were extended.
Oracle9i includes disk damage
In 2004, the release oralce10g.
July 12, 2007, Oracle announced a database in the United States New York, Oracle 11g, which is the latest version of the Oracle database