Database: Difference between revisions

Revision as of 01:24, 13 November 2013

Revision as of 01:26, 13 November 2013

Line 1:

A '''database''' is aan unorganized 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.joesph hainegi

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.