Wednesday, July 15, 2009

Oracle Database

The Oracle Database consists of a relational database management system produced and marketed by Oracle Corporation. Users of Oracle databases refer to the server-side memory-structure as the SGA the SGA typically holds cache information such as data-buffers, SQL commands, and user information.

In addition to storage, the database consists of online redo logs which hold transactional history. Processes can in turn archive the online redo logs into archive logs, which provide the basis for data recovery and for some forms of data replication.

The Oracle RDBMS stores data logically in the form of table spaces and physically in the form of data files. Table spaces can contain various types of memory segments, such as Data Segments, Index Segments, etc. Segments in turn comprise one or more extents. 

Oracle database management tracks its computer data storage with the help of information stored in the SYSTEM table space. As of Oracle remains a major presence in database computing. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Apex.

No comments:

Post a Comment