Oracle Database: Difference between revisions

Revision as of 11:32, 21 September 2003

Revision as of 22:30, 29 September 2003

Line 15:

In 1997, Oracle version 8 was released with support for object-oriented development and multimedia applications.

In 1999, Oracle 8i was released which is more in tune with the needs of the Internet (The "i" in the name stands for Internet). The database has a native Java Virtual Machine.

In 2001, Oracle 9i was released with 400 new features including the facilty to read and write XML documents.

In 2003, Oracle 10g was released. The "g" stands for Generation, which was a popular software marketing term at the time.

Oracle's numbering conventions have confused many people; they warrant a brief explanation. Since version 8, Oracle's [[RDBMS]] release numbering has been as follows:

*Oracle 8: 8.0.0 - 8.0.6

*Oracle 8i: 8.1.5.0 - 8.1.7.4

*Oracle 9i: 9.0.1.0 - 9.0.1.4

*Oracle 9i: 9.2.0.1 - 9.2.0.4 (Latest current patchset as of October 2003)

*Oracle 10g

In addition to its powerful [[RDBMS]], Oracle has released several related suites of applications. These have historically followed their own release numbering conventions. For example, Oracle Designer's upgrade path led from 6i to 2000 to 9i, when it was subsumed into Oracle Developer 9i. As of the RDBMS 10g release, Oracle seems to be making an effort to standardise all current versions of its major products on the "10g" label. This will be most confusing to Oracle Applications users, who will have to upgrade from version 11i to version 10g.

Some of the major database-related suites of Oracle applications are:

*Oracle Designer/Developer

*Oracle Forms

*Oracle Reports

*Oracle Applications

*Oracle HR

Newbies to Oracle who need to get it up and running should check out the comp.databases.oracle [[Usenet]] discussion groups. Users who have Oracle support contracts should turn to Oracle's Metalink website, see below (requires password).

==List of Firsts==

*Oracle is the world's first [[RDBMS]].

*Oracle is the first database product tested to comply with the ANSI SQL standard.

*Oracle is the first database to incorporate a native JRE

*Oracle is the first commercial [[RDBMS]] to become available on Linux (August 1999)

==External linklinks==

*[http://oracle.com/ip/deploy/database/oracle9i/ Oracle 9i Database page from oracle.com]

*[http://otn.oracle.com/documentation/oracle8i.html Oracle 8i documentation on Oracle's Technet]

*[http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage Oracle 9.2 documentation on Oracle's Technet]

*[http://metalink.oracle/com Metalink, Oracle's online support site; requires password]