Database

A database is a structured collection of data. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).

The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called a database system.

The term database system implies that the data are managed to some level of quality (measured in terms of accuracy, availability, usability, and resilience) and this in turn often implies the use of a general-purpose database management system (DBMS). A general-purpose DBMS is typically a complex software system that meets many usage requirements to properly maintain its databases which are often large and complex.

This is specially the case with client-server, near-real time transactional systems, in which multiple users have access to data, data is concurrently entered and inquired for in ways that preclude single-thread batch processing. Most of the complexity of those requirements are still present with personal, desktop-based database systems.

Well known DBMSs include FoxPro, IBM DB2, Linter, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL and SQLite. A database is not generally portable across different DBMS, but different DBMSs can inter-operate to some degree by using standards like SQL and ODBC together to support a single application built over more than one database. A DBMS also needs to provide effective run-time execution to properly support (e.g., in terms of performance, availability, and security) as many database end-users as needed.

A way to classify databases involves the type of their contents, for example: bibliographic, document-text, statistical, or multimedia objects. Another way is by their application area, for example: accounting, music compositions, movies, banking, manufacturing, or insurance.

The term database may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to the physical database as data content in computer data storage or to many other database sub-definitions.

Read more about Database:  Database Type Examples, Major Database Usage Requirements, Major Database Functional Areas, Implementation: Database Management Systems

Other articles related to "database, databases":

Open ERP - Architecture - Database
... OpenERP uses PostgreSQL as database management system. ...
UK Statute Law Database - Current Limitations
... While the database reflects amendments to primary legislation, it is not up to date ... Also the database does not currently include Pre-1991 repealed legislation Most pre-1991 local Acts and revisions to post-1991 local Acts Secondary ... There are no plans to extend the database to include the above material ...
Lantibiotics - Database
... BACTIBASE is an open-access database for bacteriocins including lantibiotics. ...
IBATIS
... framework which automates the mapping between SQL databases and objects in Java.NET, and Ruby on Rails ... that a developer needs to access a relational database using lower level APIs like JDBC and ODBC ... model (in Java, say) by the user, and create and maintain the relational database automatically ...
Implementation: Database Management Systems - DBMS Support For The Development and Maintenance of A Database and Its Application
... and later maintain an application built around its respective database type ... Examples for tools relate to database design, application programming, application program maintenance, database performance analysis and monitoring, database configuration monitoring, DBMS ...