{"id":39,"date":"2013-12-12T00:09:52","date_gmt":"2013-12-12T00:09:52","guid":{"rendered":"http:\/\/opentextbc.ca\/dbdesign01\/?post_type=chapter&p=39"},"modified":"2019-06-11T15:57:24","modified_gmt":"2019-06-11T15:57:24","slug":"chapter-6-classification-of-database-systems","status":"publish","type":"chapter","link":"https:\/\/opentextbc.ca\/dbdesign01\/chapter\/chapter-6-classification-of-database-systems\/","title":{"raw":"Chapter 6 Classification of Database Management Systems","rendered":"Chapter 6 Classification of Database Management Systems"},"content":{"raw":"Database management systems can be classified based on several criteria, such as the data model, user numbers and database distribution, all described below.\r\n

Classification Based on Data<\/span>\u00a0Model<\/h2>\r\nThe most popular data model in use today is the relational data model. Well-known DBMSs like Oracle, MS SQL Server, DB2 and MySQL support this model. Other traditional models, such as hierarchical data models and network data models, are still used in industry mainly\u00a0on mainframe platforms. However, they are not commonly used due to their complexity. These are all referred to as traditional<\/em>\u00a0models<\/em> because they preceded the relational model.\r\n\r\nIn recent years, the newer object-oriented data models<\/em>\u00a0were introduced. This model is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object-oriented databases are different from relational databases, which are table-oriented. Object-oriented database management systems (OODBMS) combine database capabilities with object-oriented programming language capabilities.\r\n\r\nThe object-oriented models have\u00a0not caught on as expected so are\u00a0not in widespread use. Some examples of object-oriented DBMSs are O2, ObjectStore and Jasmine.\r\n

Classification Based\u00a0on User Numbers<\/h2>\r\nA DBMS can be classification based on the number of users it supports. It can be a single-user database system<\/em>, which supports one user at a time, or a multiuser database system<\/em>, which supports multiple users concurrently.\r\n

Classification Based on Database Distribution<\/h2>\r\nThere are four main distribution systems for database systems and these, in turn, can be used to classify the DBMS.<\/span>\u00a0<\/span>\r\n

Centralized systems<\/h3>\r\nWith a centralized database system<\/em>,\u00a0the DBMS and database\u00a0are stored at a single site that is used by several other systems too. This is illustrated in Figure 6.1.\r\n\r\n[caption id=\"attachment_41\" align=\"aligncenter\" width=\"300\"]\"Diagram<\/a> Figure 6.1. Example of a centralized database system.[\/caption]\r\n\r\nIn the early 1980s, many Canadian libraries used the GEAC 8000 to convert their manual card catalogues to machine-readable centralized catalogue systems. Each book catalogue had a barcode field similar to those on supermarket products.\r\n

Distributed database system<\/h3>\r\nIn a distributed database system<\/em>, the actual database and the DBMS software are distributed from various sites that are connected by a computer network, as shown in Figure 6.2.<\/span>\r\n\r\n[caption id=\"attachment_45\" align=\"aligncenter\" width=\"300\"]\"Diagram<\/a> Figure 6.2. Example of a distributed database system.[\/caption]\r\n

Homogeneous distributed database systems<\/h3>\r\nHomogeneous distributed database systems<\/em> use the same DBMS software from multiple sites. Data exchange between these various sites can be handled easily. For example, library information systems by the same vendor, such as Geac Computer Corporation, use the same DBMS software which allows easy data exchange between the various Geac library sites.\r\n

Heterogeneous distributed database systems<\/h3>\r\nIn a heterogeneous distributed database system<\/em>, different sites might use different DBMS software, but there is additional common software to support data exchange between these sites. For example, the various library database systems use the same machine-readable cataloguing (MARC) format to support library record data exchange.<\/span>\r\n
\r\n

Key Terms<\/p>\r\n\r\n<\/header>\r\n

\r\ncentralized database system:\u00a0<\/span><\/strong>the DBMS and database\u00a0are stored at a single site that is used by several other systems too<\/span>\r\n\r\ndistributed database system<\/strong>:\u00a0the actual database and the DBMS software are distributed from various sites that are connected by a computer network<\/span>\r\n\r\nheterogeneous distributed database system<\/strong>:\u00a0different sites might use different DBMS software, but there is additional\u00a0common\u00a0software to support data exchange between these sites<\/span>\r\n\r\nhomogeneous distributed database systems<\/strong>:\u00a0use the same DBMS software at multiple sites\r\n\r\nmultiuser database system<\/strong>: a database management system\u00a0which supports multiple users concurrently\r\n\r\nobject-oriented data model<\/strong>: a database management system in which information is represented in the form of objects as used in object-oriented programming\r\n\r\nsingle-user database system<\/strong>:\u00a0a database management system which supports one user at a time\r\n\r\ntraditional\u00a0models<\/strong>: data models\u00a0that preceded the relational model\r\n\r\n<\/div><\/div>\r\n
\r\n

Exercises<\/p>\r\n\r\n<\/header>\r\n

\r\n\r\n
    \r\n \t
  1. Provide three examples of the most popular relational databases used.<\/li>\r\n \t
  2. What is the difference between centralized and distributed database systems?<\/li>\r\n \t
  3. What is the difference between homogenous distributed database systems and heterogeneous distributed database systems?<\/li>\r\n<\/ol>\r\n<\/div><\/div>\r\n

    Attribution<\/h2>\r\nThis chapter of\u00a0Database Design<\/em> (including images, except as otherwise noted) is a derivative copy of\u00a0Database System Concepts<\/a>\u00a0by\u00a0Nguyen Kim Anh\u00a0licensed under\u00a0Creative Commons Attribution License 3.0 license<\/a>\r\n\r\nThe following material was written by Adrienne Watt:\r\n
      \r\n \t
    1. Key Terms<\/li>\r\n \t
    2. Exercises<\/li>\r\n<\/ol>","rendered":"

      Database management systems can be classified based on several criteria, such as the data model, user numbers and database distribution, all described below.<\/p>\n

      Classification Based on Data<\/span>\u00a0Model<\/h2>\n

      The most popular data model in use today is the relational data model. Well-known DBMSs like Oracle, MS SQL Server, DB2 and MySQL support this model. Other traditional models, such as hierarchical data models and network data models, are still used in industry mainly\u00a0on mainframe platforms. However, they are not commonly used due to their complexity. These are all referred to as traditional<\/em>\u00a0models<\/em> because they preceded the relational model.<\/p>\n

      In recent years, the newer object-oriented data models<\/em>\u00a0were introduced. This model is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object-oriented databases are different from relational databases, which are table-oriented. Object-oriented database management systems (OODBMS) combine database capabilities with object-oriented programming language capabilities.<\/p>\n

      The object-oriented models have\u00a0not caught on as expected so are\u00a0not in widespread use. Some examples of object-oriented DBMSs are O2, ObjectStore and Jasmine.<\/p>\n

      Classification Based\u00a0on User Numbers<\/h2>\n

      A DBMS can be classification based on the number of users it supports. It can be a single-user database system<\/em>, which supports one user at a time, or a multiuser database system<\/em>, which supports multiple users concurrently.<\/p>\n

      Classification Based on Database Distribution<\/h2>\n

      There are four main distribution systems for database systems and these, in turn, can be used to classify the DBMS.<\/span>\u00a0<\/span><\/p>\n

      Centralized systems<\/h3>\n

      With a centralized database system<\/em>,\u00a0the DBMS and database\u00a0are stored at a single site that is used by several other systems too. This is illustrated in Figure 6.1.<\/p>\n

      \"Diagram<\/a>
      Figure 6.1. Example of a centralized database system.<\/figcaption><\/figure>\n

      In the early 1980s, many Canadian libraries used the GEAC 8000 to convert their manual card catalogues to machine-readable centralized catalogue systems. Each book catalogue had a barcode field similar to those on supermarket products.<\/p>\n

      Distributed database system<\/h3>\n

      In a distributed database system<\/em>, the actual database and the DBMS software are distributed from various sites that are connected by a computer network, as shown in Figure 6.2.<\/span><\/p>\n

      \"Diagram<\/a>
      Figure 6.2. Example of a distributed database system.<\/figcaption><\/figure>\n

      Homogeneous distributed database systems<\/h3>\n

      Homogeneous distributed database systems<\/em> use the same DBMS software from multiple sites. Data exchange between these various sites can be handled easily. For example, library information systems by the same vendor, such as Geac Computer Corporation, use the same DBMS software which allows easy data exchange between the various Geac library sites.<\/p>\n

      Heterogeneous distributed database systems<\/h3>\n

      In a heterogeneous distributed database system<\/em>, different sites might use different DBMS software, but there is additional common software to support data exchange between these sites. For example, the various library database systems use the same machine-readable cataloguing (MARC) format to support library record data exchange.<\/span><\/p>\n

      \n
      \n

      Key Terms<\/p>\n<\/header>\n

      \ncentralized database system:\u00a0<\/span><\/strong>the DBMS and database\u00a0are stored at a single site that is used by several other systems too<\/span><\/p>\n

      distributed database system<\/strong>:\u00a0the actual database and the DBMS software are distributed from various sites that are connected by a computer network<\/span><\/p>\n

      heterogeneous distributed database system<\/strong>:\u00a0different sites might use different DBMS software, but there is additional\u00a0common\u00a0software to support data exchange between these sites<\/span><\/p>\n

      homogeneous distributed database systems<\/strong>:\u00a0use the same DBMS software at multiple sites<\/p>\n

      multiuser database system<\/strong>: a database management system\u00a0which supports multiple users concurrently<\/p>\n

      object-oriented data model<\/strong>: a database management system in which information is represented in the form of objects as used in object-oriented programming<\/p>\n

      single-user database system<\/strong>:\u00a0a database management system which supports one user at a time<\/p>\n

      traditional\u00a0models<\/strong>: data models\u00a0that preceded the relational model<\/p>\n<\/div>\n<\/div>\n

      \n
      \n

      Exercises<\/p>\n<\/header>\n

      \n
        \n
      1. Provide three examples of the most popular relational databases used.<\/li>\n
      2. What is the difference between centralized and distributed database systems?<\/li>\n
      3. What is the difference between homogenous distributed database systems and heterogeneous distributed database systems?<\/li>\n<\/ol>\n<\/div>\n<\/div>\n

        Attribution<\/h2>\n

        This chapter of\u00a0Database Design<\/em> (including images, except as otherwise noted) is a derivative copy of\u00a0Database System Concepts<\/a>\u00a0by\u00a0Nguyen Kim Anh\u00a0licensed under\u00a0Creative Commons Attribution License 3.0 license<\/a><\/p>\n

        The following material was written by Adrienne Watt:<\/p>\n

          \n
        1. Key Terms<\/li>\n
        2. Exercises<\/li>\n<\/ol>\n","protected":false},"author":1,"menu_order":6,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":["adrienne-watt"],"pb_section_license":""},"chapter-type":[],"contributor":[47],"license":[],"class_list":["post-39","chapter","type-chapter","status-publish","hentry","contributor-adrienne-watt"],"part":3,"_links":{"self":[{"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/chapters\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":26,"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/chapters\/39\/revisions"}],"predecessor-version":[{"id":1143,"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/chapters\/39\/revisions\/1143"}],"part":[{"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/chapters\/39\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/pressbooks\/v2\/chapter-type?post=39"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/wp\/v2\/contributor?post=39"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/opentextbc.ca\/dbdesign01\/wp-json\/wp\/v2\/license?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}