Database: Difference between revisions

Revision as of 13:23, 19 November 2013

Revision as of 13:27, 19 November 2013

Line 1:

A '''database''' is an organized collection of [[Data (computing)|data]]. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.

Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database prick itself to capture and analyze data. A general-purpose '''database management system (DBMS)''' is a [[Computer software|software]] system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include [[MySQL]], [[PostgreSQL]], [[SQLite]], [[Microsoft SQL Server]],[[Oracle Database|Oracle]], [[SAP AG|SAP]], [[dBASE]], [[FoxPro]], [[IBM DB2]], [[LibreOffice Base]] and [[FilemakerPro|FileMaker Pro]]. A database is not generally [[Software portability|portable]] across different DBMS, but different DBMSs can interoperate by using [[Technical standard|standard]]s such as [[SQL]] and [[ODBC]] or [[JDBC]] to allow a single application to work with more than one database.

==Terminology and overview==