Database Management System (DBMS) Framework
A Database Management System (DBMS) Framework is a data management framework with a database engine that can solve a database management task (facilitate the access and management to databases).
- Context:
- It can manage one or more DBMS Databases.
- It can (typically) support a Data Querying Language.
- It can (typically) support a Data Manipulation Language.
- It can (typically) support a Data Definition Language.
- It can (typically) support a Database Backup Capability and a Database Restore Capability.
- It can be instantiated in a DBMS Instance.
- It can range from being a Structured Data DBMS, to being a Semi-Structured Data DBMS, to being an Unstructured Data DBMS, to being a Hybrid-model Database System.
- It can range from being a Single-Platform DBMS to being a Cross-Platform DBMS.
- It can range from being a Single-Computer DBMS to being a Distributed DBMS.
- It can range from being a Row-based DBMS to being a Column-based DBMS.
- It can range from being a Disk-based DBMS to being a Memory-based DBMS.
- It can range from being a Batch DBMS to being a Real-Time DBMS.
- It can have an Access Control Capability.
- It can have an API.
- …
- Example(s):
- a Structured Data DBMS, such as a relational DBMS (such as a SQL DBMS), or a graph DBMS, or a Object DBMS.
- an Unstructured Data DBMS, such as a Document Management System.
- a Hive DBMS.
- a Semi-Structured Data DBMS, such as an XML Database System.
- a Key-Value Store, such as: Apache Cassandra.
- a Microsoft Access DBMS Package.
- …
- a Structured Data DBMS, such as a relational DBMS (such as a SQL DBMS), or a graph DBMS, or a Object DBMS.
- Counter-Example(s)
- See: Operating System.
References
2014
- (Wikipedia, 2014) ⇒ http://en.wikipedia.org/wiki/Database Retrieved:2014-5-9.
- A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.
Database management systems (DBMSs) are specially designed software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, SAP HANA, dBASE, FoxPro, IBM DB2, LibreOffice Base, Altibase, FileMaker Pro and InterSystems Caché. A database is not generally portable across different DBMSs, but different DBMSs can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database.
- A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.
- (Wikipedia, 2014) ⇒ http://en.wikipedia.org/wiki/Database#Terminology_and_overview Retrieved:2014-5-9.
- Formally, "database" refers to the data themselves and supporting data structures.
Databases are created to operate large quantities of information by inputting, storing, retrieving and managing that information. Databases are set up so that one set of software programs provides all users with access to all the data.
A "database management system" (DBMS) is a suite of computer software providing the interface between users and a database or databases. Because they are so closely related, the term "database" when used casually often refers to both a DBMS and the data it manipulates.
Outside the world of professional information technology, the term database is sometimes used casually to refer to any collection of data (perhaps a spreadsheet, maybe even a card index). This article is concerned only with databases where the size and usage requirements necessitate use of a database management system.[1]
The interactions catered for by most existing DBMSs fall into four main groups:
- Data definition – Defining new data structures for a database, removing data structures from the database, modifying the structure of existing data.
- Update – Inserting, modifying, and deleting data.
- Retrieval – Obtaining information either for end-user queries and reports or for processing by applications.
- Administration – Registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information if the system fails.
- A DBMS is responsible for maintaining the integrity and security of stored data, and for recovering information if the system fails.
Both a database and its DBMS conform to the principles of a particular database model. [2] "Database system" refers collectively to the database model, database management system, and database. [3]
Physically, database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Database servers are usually multiprocessor computers, with generous memory and RAID disk arrays used for stable storage. RAID is used for recovery of data if any of the disks fail. Hardware database accelerators, connected to one or more servers via a high-speed channel, are also used in large volume transaction processing environments. DBMSs are found at the heart of most database applications. DBMSs may be built around a custom multitasking kernel with built-in networking support, but modern DBMSs typically rely on a standard operating system to provide these functions. Since DBMSs comprise a significant economical market, computer and storage vendors often take into account DBMS requirements in their own development plans. Databases and DBMSs can be categorized according to the database model(s) that they support (such as relational or XML), the type(s) of computer they run on (from a server cluster to a mobile phone), the query language(s) used to access the database (such as SQL or XQuery), and their internal engineering, which affects performance, scalability, resilience, and security.
- Formally, "database" refers to the data themselves and supporting data structures.
- ↑ Jeffrey Ullman 1997: First course in database systems, Prentice–Hall Inc., Simon & Schuster, Page 1, ISBN 0-13-861337-0.
- ↑ Tsitchizris, D. C. and F. H. Lochovsky (1982). Data Models. Englewood-Cliffs, Prentice–Hall.
- ↑ Beynon-Davies P. (2004). Database Systems 3rd Edition. Palgrave, Basingstoke, UK. ISBN 1-4039-1601-2
2011
- http://en.wikipedia.org/wiki/Database_management_system
- A Database Management System (DBMS) is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists. A database is an integrated collection of data records, files, and other database objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, recovering the database after failures and restoring it from backup files, as well as maintaining database security.
2009
- (Wordnet, 2009) ⇒ http://wordnet.princeton.edu/perl/webwn
- a software system that facilitates the creation and maintenance and use of an electronic database
- http://en.wiktionary.org/wiki/database_management_system
- A suite of interrelated computer programs designed to manage message processing and database update in a tightly controlled manner
2007
- (Hellerstein et al., 2007) ⇒ Joseph M. Hellerstein, Michael Stonebraker, and James Hamilton. (2007). “Architecture of a Database System.” In: Foundations and Trends in Databases Journal, 1(2). doi:10.1561/1900000002
- QUOTE: Database Management Systems (DBMSs) are a ubiquitous and critical component of modern computing, and the result of decades of research and development in both academia and industry. Historically, DBMSs were among the earliest multi-user server systems to be developed, and thus pioneered many systems design techniques for scalability and reliability now in use in many other contexts.