Database System

A database system is a term that is typically used to encapsulate the constructs of a data model, database management system (DBMS) and database.

A database is an organised pool of logically-related data. Data is stored within the data structures of the database. A DBMS is a suite of computer software providing the interface between users and a database or databases. A DBMS is a shell which surrounds a database or series of databases and through which all interactions take place with the database. The interactions catered for by most existing DBMS fall into four main groups:

  • Data Definition. Defining new data structures for a database, removing data structures from the database, modifying the structure of existing data.
  • Data Maintenance. Inserting new data into existing data structures, updating data in existing data structures, deleting data from existing data structures.
  • Data Retrieval. Querying existing data by end-users and extracting data for use by application programs.
  • Data Control. Creating and monitoring users of the database, restricting access to data in the database and monitoring the performance of databases.

Both a database and its DBMS conform to the principles of a particular data model. Data models include the hierarchical data model, the network data model, the relational data model and the object-oriented data model.

Other articles related to "database, database system, database systems, databases":

In-memory Database - Hybrids With On-disk Databases
... The first database engine to support both in-memory and on-disk tables in a single database was released in 2003 ... Manufacturing efficiency is another reason a combined in-memory/on-disk database system may be chosen ... If such devices require a database system, a manufacturer can adopt a hybrid database system at lower and upper cost, and with less code ...
Atomic Commit - Database System
... Atomic commits in database systems fulfil two of the key properties of ACID, atomicity and consistency ... in the example atomic commits are critical to multistep operations in databases ... modern hardware design the physical disk on which the database resides true atomic commits cannot exist ...
Commitment Ordering - CO Variants: Interesting Special Cases and Generalizations - Strong Strict Two Phase Locking (SS2PL)
... This property is widely utilized in database systems, and since it implies CO, databases that use it and participate in global transactions generate together a serializable global schedule (when using any ... No database modification or addition is needed in this case to participate in a CO distributed solution The set of undecided transactions to be aborted before committing ... A transaction can be voted on by a database system immediately after entering a "ready" state, i.e ...
Commitment Ordering - CO Variants: Interesting Special Cases and Generalizations - Multi-version CO (MVCO)
... Multi-version Commitment Ordering (MVCO (Raz 1993b)) is a generalization of CO for databases with multi-version resources ... and performance by generating a new version of a database object each time the object is written, and allowing transactions' read operations of several last relevant versions (of ... Theorem MVCO compliance of every autonomous database system (or transactional object) in a mixed multidatabase environment of single-version and multi-version databases is a necessary condition for ...

Famous quotes containing the word system:

    There are obvious places in which government can narrow the chasm between haves and have-nots. One is the public schools, which have been seen as the great leveler, the authentic melting pot. That, today, is nonsense. In his scathing study of the nation’s public school system entitled “Savage Inequalities,” Jonathan Kozol made manifest the truth: that we have a system that discriminates against the poor in everything from class size to curriculum.
    Anna Quindlen (b. 1952)