Database: Difference between revisions

Revision as of 14:50, 14 November 2013

Revision as of 14:51, 14 November 2013

Line 1:

A '''database''' is an organized collection of [[Data (computing)|data]]. The data is 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. Steam is also a database. (Subscribe to TheXirasno, and President Pizza on youtube.com)

Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database 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.