Database Management System (DBMS) Framework

From GM-RKB
Jump to navigation Jump to search

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).

References

2024

  • (Wikipedia, 2024) ⇒ https://en.wikipedia.org/wiki/Database#Database_management_system Retrieved:2024-4-19.
    • Connolly and Begg define database management system (DBMS) as a "software system that enables users to define, create, maintain and control access to the database."Examples of DBMS's include MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle Database, and Microsoft Access.

      The DBMS acronym is sometimes extended to indicate the underlying database model, with RDBMS for the relational, OODBMS for the object (oriented) and ORDBMS for the object–relational model. Other extensions can indicate some other characteristics, such as DDBMS for a distributed database management systems.

      The functionality provided by a DBMS can vary enormously. The core functionality is the storage, retrieval and update of data. Codd proposed the following functions and services a fully-fledged general purpose DBMS should provide:* Data storage, retrieval and update

      • User accessible catalog or data dictionary describing the metadata
      • Support for transactions and concurrency
      • Facilities for recovering the database should it become damaged
      • Support for authorization of access and update of data
      • Access support from remote locations
      • Enforcing constraints to ensure data in the database abides by certain rules
    • It is also generally to be expected the DBMS will provide a set of utilities for such purposes as may be necessary to administer the database effectively, including import, export, monitoring, defragmentation and analysis utilities.The core part of the DBMS interacting between the database and the application interface sometimes referred to as the database engine.

      Often DBMSs will have configuration parameters that can be statically and dynamically tuned, for example the maximum amount of main memory on a server the database can use. The trend is to minimize the amount of manual configuration, and for cases such as embedded databases the need to target zero-administration is paramount.

      The large major enterprise DBMSs have tended to increase in size and functionality and have involved up to thousands of human years of development effort throughout their lifetime. Early multi-user DBMS typically only allowed for the application to reside on the same computer with access via terminals or terminal emulation software. The client–server architecture was a development where the application resided on a client desktop and the database on a server allowing the processing to be distributed. This evolved into a multitier architecture incorporating application servers and web servers with the end user interface via a web browser with the database only directly connected to the adjacent tier.A general-purpose DBMS will provide public application programming interfaces (API) and optionally a processor for database languages such as SQL to allow applications to be written to interact with and manipulate the database. A special purpose DBMS may use a private API and be specifically customized and linked to a single application. For example, an email system performs many of the functions of a general-purpose DBMS such as message insertion, message deletion, attachment handling, blocklist lookup, associating messages an email address and so forth however these functions are limited to what is required to handle email.

2014

2014b

  • (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.

  1. ↑ Jeffrey Ullman 1997: First course in database systems, Prentice–Hall Inc., Simon & Schuster, Page 1, ISBN 0-13-861337-0.
  2. ↑ Tsitchizris, D. C. and F. H. Lochovsky (1982). Data Models. Englewood-Cliffs, Prentice–Hall.
  3. ↑ Beynon-Davies P. (2004). Database Systems 3rd Edition. Palgrave, Basingstoke, UK. ISBN 1-4039-1601-2

2011

2009

2007

Retrieved from "http://www.gabormelli.com/RKB/index.php?title=Database_Management_System_(DBMS)_Framework&oldid=920998"