CSC 121 As I see it 005

10 examples of DBMS Software:

1. Oracle Database by Oracle Corporation
2. Adaptive Server Enterprise (ASE) by Sybase Corporation's
3.MySQL by MySQL AB
4. FileMaker from FileMaker Inc.
5. Informix by IBM
6. Microsoft Office Access, previously known as Microsoft Access, from Microsoft
7. PostgreSQL under a BSD-style license
8. OpenEdge Advanced Business Language, by Progress Software Corporation (PSC).
9. CSQL developed in sourceforge.net.
10. Visual FoxPro by Microsoft

"Oracle Database System"

An Oracle database system comprises at least one instance of the application, along with data storage. An instance comprises a set of operating-system processes and memory-structures that interact with the storage.

The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files. Tablespaces can contain various types of memory segments; for example, Data Segments. Extents comprise groups of contiguous data blocks. Data blocks form the basic units of data storage. At the physical level, data-files comprise one or more data blocks, where the block size can vary between data-files.

Oracle database management track its computer data storage with the help of information stored in the SYSTEM tablespace. The SYSTEM tablespace contains the data dictionary — and often (by default) indexes and clusters.

Each Oracle instance uses a System Global Area or SGA — a shared-memory area — to store its data and control-information. Oracle stores information here about the logical and physical structure of the database.