Oracle RDBMS

Viewing Revision #10 from 2018-12-13 04:26 View Current

Oracle RDBMS is a widely-used proprietary DBMS released by Oracle Corporation. The most recent version released was 18c; version 18.3 was released in July 2018. It supports a multi-model storage paradigm, allowing for JSON, key-value, XML, and graph models in addition to the traditional relational model.[04][05]

Logo Versions

Website: https://www.oracle.com/us/products/database/index.html[01]
Tech Docs: https://docs.oracle.com/en/database/oracle/oracle-database/index.html[02]
Developer: Oracle Corporation
Country of Origin: US
Start Year: 1977
Project Type: Commercial
Written in: C, C++
Supported Languages: C, C++, COBOL, Java, PHP, PL/SQL, Python, R, SQL, Visual Basic
Operating Systems: AIX, HP-UX, Linux, Solaris, Windows
License: Proprietary
Wikipedia: https://en.wikipedia.org/wiki/Oracle_Database[03]

Database Entry

Oracle RDBMS

Viewing Revision #10 from 2018-12-13 04:26 View Current

History[06][07]

In 1977, Larry Ellison, Robert Miner, and Ed Oates founded Software Development Laboratories, which was hired by the United States Central Intelligence Agency (CIA) in order to write a new database system based upon SQL. This system came to be known as Oracle. The company changed its name to Relational Software, Inc. in 1979 and then to Oracle Systems Corporation not long thereafter, in 1982.

Compression[08]

Naïve (Page-Level) Naïve (Record-Level) Bit Packing / Mostly Encoding

Oracle supports compression at multiple levels within the data, including by row, block, and index. It also supports network compression designed to reduce bandwidth usage and increase network throughput.

Concurrency Control[09]

Multi-version Concurrency Control (MVCC)

Oracle employs MVCC for concurrency control.

Data Model[04]

Relational Key/Value Document / XML Graph

Oracle supports a variety of data models for storage within its system.

Isolation Levels[10]

Read Committed Serializable

Oracle supports isolation levels of read committed as well as serializable, defaulting with the latter. There is an additional mode available, "read only", which is not part of the SQL standard.