Database management system

From Wiki @ Karl Jones dot com
Jump to: navigation, search

A database management system (DBMS) is a computer software application which allows user (and other applications) to manage a database.

Description

A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

Well-known DBMSs include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, SAP HANA, and IBM DB2.

A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS.

Database management systems are often classified according to the database model that they support, notably the relational model.

Sometimes a DBMS is loosely referred to as a 'database'.

See also

External links