{"id":619,"date":"2021-02-01T19:24:48","date_gmt":"2021-02-02T00:24:48","guid":{"rendered":"https:\/\/www.alpharithms.com\/?post_type=term&#038;p=619"},"modified":"2021-07-27T11:24:32","modified_gmt":"2021-07-27T15:24:32","slug":"database-management-system-dbms","status":"publish","type":"post","link":"https:\/\/www.alpharithms.com\/database-management-system-dbms-482419\/","title":{"rendered":"Database Management System (DBMS)"},"content":{"rendered":"<p>A database management system (DBMS) controls the storage and access to data stored in a <a href=\"https:\/\/www.alpharithms.com\/term\/database\/\">database<\/a>. Together, the DBMS and database are referred to as the database system. The DBMS facilitates access to the structured information contained in databases.<\/p>\n<p>DBMS systems allow users to create, define, maintain and control user access to data contained in the database. Such systems include <a href=\"https:\/\/www.postgresql.org\/\">PostgreSQL<\/a>, <a href=\"https:\/\/www.mysql.com\/\">MySQL<\/a>, and <a href=\"https:\/\/www.oracle.com\/database\/\">Oracle Database<\/a>.<\/p>\n<p>DBMS is used somewhat generically as an umbrella term describing many specialized data management systems. Within the purview of the DBMS, the taxonomy includes <strong>relational database management systems<\/strong>, <strong>object-oriented database management systems<\/strong>, and <strong>object-relational database management systems<\/strong>.<\/p>\n<p>Note: All the above DBMS types are <em>systems<\/em>, all <em>manage<\/em> databases, thus all are <em>technically <\/em>expressions of a DBMS. Functionally, however, they&#8217;re quite different.<\/p>\n<h2>DBMS Responsibilities<\/h2>\n<p>Database management systems help support a wide range of interactions with databases\u2014and thus <a href=\"https:\/\/www.alpharithms.com\/term\/data\/\"><em>data<\/em><\/a>. A good DBMS will help support all the following actions and responsibilities plus more:<\/p>\n<ul>\n<li>Storage, retrieval, and updating of data<\/li>\n<li>Make catalog\/dictionary of data accessible to the user<\/li>\n<li>Supports concurrent data access and transactions<\/li>\n<li>Support for database backups and recovery<\/li>\n<li>Support for permissions-based access (user roles)<\/li>\n<li>Allow remote access<\/li>\n<li>Enforce constraints on data to ensure the integrity<\/li>\n<\/ul>\n<p>These are among the most common actions supported by a robust DBMS such as PostgreSQL. However, there are some DBMS systems that may only offer partial support for these actions. For example, SQLite supports concurrent\u00a0<em>read<\/em> operations <a href=\"https:\/\/stackoverflow.com\/questions\/4060772\/sqlite-concurrent-access\">but might run into trouble<\/a> for <em>writes<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A database management system (DBMS) controls the storage and access to data stored in a database. Together, the DBMS and database are referred to as the database system. The DBMS facilitates access to the structured information contained in databases. DBMS systems allow users to create, define, maintain and control user access to data contained in [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":622,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1,260],"tags":[156,461],"acf":[],"_links":{"self":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts\/619"}],"collection":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/comments?post=619"}],"version-history":[{"count":4,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts\/619\/revisions"}],"predecessor-version":[{"id":624,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts\/619\/revisions\/624"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/media\/622"}],"wp:attachment":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/media?parent=619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/categories?post=619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/tags?post=619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}