SQL Server

Overview of Database Management System (DBMS) Part – 10

Overview of Database Management System (DBMS) Part – 10

Categories of Database Application

More than a few standards are generally castoff to categorize Database Management System (DBMS). The 1st is the information modeling on which the Database Management System (DBMS) is constructed. The key information modeling castoff in numerous present commercial Database Management System (DBMS) is the relational information modeling. The object information modeling was applied in a number of commercial database application systems however has not had achieve great practice of it still now. Numerous legacy database applications still execute on database applications which are constructed on the hierarchical as well as network information modeling only. The relational Database Management System (DBMS) are developing uninterruptedly, plus, in specific have been including several of the ideas which were established in object database. This has led to a fresh category of Database Management System (DBMS) known as object relational Database Management System (DBMS). An individual can therefore classify Database Management System (DBMS) built on the information modeling which are – Object, Relational, Object Relational, Network, Hierarchical and supplementary models. The 2nd standard castoff to categorize Database Management System (DBMS) is the number of end users assisted by the database application system. Single end user application systems assist one (1) end user at a single point of time only as well as are commonly practice by means of personal computer (PC). Multi end user systems this contain the popularity of Database Management System (DBMS) assists several end users simultaneously. A 3rd standard is the number of locations over which the database application is spread. A Database Management System (DBMS) is centralized if the information is kept at a particular single computer location. A centralized Database Management System (DBMS) can assists several end users, however the Database Management System (DBMS) as well as the database themselves exist in completely at a single computer location. A Distributed Database Management System (DDBMS) can have the real database as well as Database Management System (DBMS) software spread over numerous locations, associated by means of a computer network. Similar Distributed Database Management System (DDBMS) practice the identical Database Management System (DBMS) software at various locations. A new fashion is to design software to access more than a few independent previous databases kept under mixed Distributed Database Management System (DDBMS). This helps to a joined Database Management System (DBMS) or multi database application system, in which the contributing Database Management System (DBMS) are lightly attached as well as have an amount of native independence. A lot of Database Management System (DBMS) practice client server structural design too.

This will be the last part in the series of article. Hope the readers had gain some useful knowledge from this article.

Thanks.