Slide 11.1: Oracle database management systems

Slide 10.10: Using JDBC on the server shell
Slide 11.2: Using SQL*Plus: the Oracle interface
Home

Oracle Database Management Systems

Oracle7 (1992) is a client-server based relational database management system. The query language is based on SQL.

Oracle8i (1999) is a relational database system with object capabilities included. The i in the name stands for Internet. It is a database specifically designed as an Internet development and deployment platform including two major functions:
- Oracle8i JVM, a server side Java engine, includes a native compiler, a CORBA 2.0 ORB, an EJB server, an embedded server side JDBC driver, and an SQLJ translator.
- Oracle8i for Data Warehousing, a part of the Oracle Internet Platform, supplies a solid foundation for data warehousing.

Oracle9i (2001) features full XML database functionality and other improvements.

Oracle10g (2003) is designed for enterprise grid computing. The g in the name stands for grid.
Grid computing—A global effort to develop an environment in which individual users can access computers, databases and experimental facilities simply and transparently, without having to consider where those facilities are located.
Oracle11g (2007) is for Linux and Microsoft Windows.

^†Note that the Oracle Enterprise Edition for higher education does not include advanced features such as WebDB. However, most basic tools such as JDBC are available on that edition.