Distributed database management system

Encyclopedia : D : DI : DIS : Distributed database management system

---

A distributed database management system is a software system that permits the management of the 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.

Distributed database management systems can be architected as client-server systems or peer-to-peer ones. In the former, one or more servers manage the database and handle user queries that are passed on by the clients. The clients usually have limited database functionality and normally pass the SQL queries over to the servers for processing. In peer-to-peer systems, each site has equal functionality for processing.

See also

Topics in database management systems (DBMS) ( [ view] • [ talk] • [ edit] )

Concepts Database | Database model | Relational database | Relational model | Relational algebra | Primary key - Foreign key - Surrogate key - Superkey Database normalization | Referential integrity | Relational DBMS | Distributed DBMS | ACID Objects Trigger | View | Table | Cursor | Log | Transaction | Index | Stored procedure | Partition Topics in SQL Select | Insert | Update | Merge | Delete | Join | Union | Create | Drop Comparison of syntax

Implementations of database management systems

Types of implementations Flat file | Deductive | Dimensional | Hierarchical | Object oriented | Temporal Products dBASE | Oracle | Sybase | MySQL | Microsoft SQL Server | PostgreSQL | DB2 | Comparison - relational | Comparison - object-relational Components Query language | Query optimizer | Query plan | ODBC | JDBC Lists List of object-oriented database management systems List of relational database management systems List of truly relational database management systems

References

M. T. Özsu and P. Valduriez, Principles of Distributed Database Systems (2nd edition), Prentice-Hall, 1999, ISBN 0-136-59707-6

 

---

From Wikipedia, the Free Encyclopedia. Original article here. Support Wikipedia by contributing or donating.
All text is available under the terms of the GNU Free Documentation License See Wikipedia Copyrights for details.

Search Titles

0

1

2

3

4

5

6

7

8

9

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

?