Distributed database management system

From Wikipedia, the free encyclopedia

A distributed database management system is a software system that permits the management of a distributed database and makes the distribution transparent to the users. A distributed database is a collection of multiple, logically interrelated databases distributed over a computer network. Sometimes "distributed database system" is used to refer jointly to the distributed database and the distributed DBMS.

v • d • e Database management systems

Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing

Concepts	Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key

Objects	Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition

SQL	Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter

Implementations	Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores · Triple stores

Components	Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan

Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented