Database: Difference between revisions

Content deleted Content added
External, conceptual, and internal views: Use SVG vector imaging instead of PNG bitmap to demonstrate the external/internal schema.
No edit summary
Line 1:
<ref><ref--~~~~</ref></ref>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 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.