Actions

::Database

::concepts

Database::model    Database::storage    System::which    Systems::dbmss    Needed::title    Other::query

A database is an organized collection of data.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> It is the collection of schemes, tables, queries, reports, views and other objects. The data is typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. 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 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; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language.{{ safesubst:#invoke:Unsubst||$N=Disputed-inline |date=__DATE__ |$B= {{#invoke:Category handler|main}}[disputed ] }} Sometimes a DBMS is loosely referred to as a 'database'.


Database sections
Intro  Terminology and overview  Applications  General-purpose and special-purpose DBMSs  History  Research  Examples  Design and modeling  Languages  Performance, security, and availability  See also  References  Further reading  External links  

PREVIOUS: IntroNEXT: Terminology and overview
<<>>