Myschool CBT Challenge Season 6 - Cash Prize Of N200,000 To Be Won!

List 4 classifications of database?

List 4 classifications of database?

To get notifications when anyone posts a new answer to this question,
Follow New Answers

Post an Answer

Please don't post or ask to join a "Group" or "Whatsapp Group" as a comment. It will be deleted. To join or start a group, please click here

Answers (3)

isaaq
3 days ago
Types And Classification Of Database Management System + PDF
Based on the data model
Relational database – This is the most popular data model used in industries. It is based on the SQL. They are table oriented which means data is stored in different access control tables, each has the key field whose task is to identify each row. The tables or the files with the data are called as relations that help in designating the row or record, and columns are referred to attributes or fields. Few examples are MYSQL(Oracle, open source), Oracle database (Oracle), Microsoft SQL server(Microsoft) and DB2(IBM).

Object oriented database – The information here is in the form of the object as used in object oriented programming. It adds the database functionality to object programming languages. It requires less code, use more natural data and also code bases are easy to maintain. Examples are ObjectDB (ObjectDB software).

Images Source: Free Coloring Pages



Object relational database – Relational DBMS are evolving continuously and they have been incorporating many concepts developed in object database leading to a new class called extended relational database or object relational database.

Hierarchical database – In this, the information about the groups of parent or child relationships is present in the records which is similar to the structure of a tree. Here the data follows a series of records, set of values attached to it. They are used in industry on mainframe platforms. Examples are IMS(IBM), Windows registry(Microsoft).



Network database – Mainly used on a large digital computers. If there are more connections, then this database is efficient. They are similar to hierarchical database, they look like a cobweb or interconnected network of records. Examples are CA-IDMS(COMPUTER associates), IMAGE(HP).



Based on the number of users
Single user – As the name itself indicates it can support only one user at a time. It is mostly used with the personal computer on which the data resides accessible to a single person. The user may design, maintain and write the database programs.

Multiple users – It supports multiple users concurrently. Data can be both integrated and shared,a database should be integrated when the same information is not need be recorded in two places. For example a student in the college should have the database containing his information. It must be accessible to all the departments related to him. For example the library department and the fee section department should have information about student’s database. So in such case, we can integrate and even though database resides in only one place both the departments will have the access to it.

Based on the sites over which network is distributed
Centralized database system – The DBMS and database are stored at the single site that is used by several other systems too. We can simply say that data here is maintained on the centralized server.

Parallel network database system – This system has the advantage of improving processing input and output speeds. Majorly used in the applications that have query to larger database. It holds the multiple central processing units and data storage disks in parallel.

Distributed database system – In this data and the DBMS software are distributed over several sites but connected to the single computer.

Further they are classified as

1.Homogeneous DBMS – They use same software but from the multiple sites. Data exchange between the sites can be handled easily. For example, library information systems by the same vendor ,such as Geac Computer corporation, use the same DBMS software that allows the exchanges between various Geac library sites.

2.heterogeneous DBMS – They use different DBMS software for different sites but there is a additional software that helps the exchange of the data between the sites.

Client-server database system – This system has two logical components namely client and server. Clients are generally the personal computers or workstations whereas servers are the large workstations, mini range computers or a main frame computer system. The applications and tools of the DBMS run on the client platforms and the DBMS software on the server. Both server and client computers are connected over the network. We can relate it to client and server in real life to understand in a much better way. Here the applications and tools act as a client send the requests for its services. The DBMS processes these requests and returns the result to the client. Server handles jobs that are common to many clients say database access and updates.

Multi-tier client-server database system – The rise of personal computers in business has increased the reliability of the network hardware leading to evolution of two-tier and three-tier systems which use different software for the client and software.

Based on the cost
Low cost DBMS – The cost of these systems vary from $100 to $3000.

Medium cost DBMS – Cost varies from $10000 to $100000.

High cost DBMS – Cost pf these systems are usually more than $100000.

Based on the access
This classification simply based on the access to data in the database systems

Sequential access – One after the other.

Direct access

Inverted file structures

Based on the usage
Online transaction processing(OLTP) DBMS – They manage the operational data. Database server must be able to process lots of simple transactions per unit of time. Transactions are initiated in real time, in simultaneous by lots of user and applications hence it must have high volume of short, simple queries.

Online analytical processing(OLAP) DBMS – They use the operational data for tactical and strategical decision making. They have limited users deal with huge amount of data,complex queries.

Big data and analytics DBMS – To cope with big data new database technologies have been introduced. One such is NoSQL (not only SQL) which abandons the well known relational database scheme.

XML DBMS – two types

Native XML DBMS – Use the logical,intrinsic structure of XML document.
2.Enabled XML DBMS – Existing DBMS with facilities to store XML data and structured data in integrated way.

Multimedia DBMS – Stores data such as text, images, audio, video and 3D games which are usually stored in binary large object.

GIS DBMS – Stores and queries the spatial data.

Sensor DBMS – Allows to manage sensor data, bio-metric and telematics data.

Mobile DBMS – Runs on the smartphones, tablets. It Handles the local queries. Supports self management( no DBA).
mhizzlee
2 days ago
classification Based on Data Model
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 on mainframe platforms. However, they are not commonly used due to their complexity. These are all referred to as traditional models because they preceded the relational model.

In recent years, the newer object-oriented data models were 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.

The object-oriented models have not caught on as expected so are not in widespread use. Some examples of object-oriented DBMSs are O2, ObjectStore and Jasmine.

Classification Based on User Numbers
A DBMS can be classification based on the number of users it supports. It can be a single-user database system, which supports one user at a time, or a multiuser database system, which supports multiple users concurrently.

Classification Based on Database Distribution
There are four main distribution systems for database systems and these, in turn, can be used to classify the DBMS.

Centralized systems
With a centralized database system, the DBMS and database are stored at a single site that is used by several other systems too. This is illustrated in Figure 6.1.


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.

Distributed database system
In a distributed database system, 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.

Diagram showing three circles, separately labelled Site 1-3, and each containing several computer monitors and a computer tower. A line connects each of these to a central oval marked Computer Network.
Figure 6.2. Example of a distributed database system.
Homogeneous distributed database systems
Homogeneous distributed database systems 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.

Heterogeneous distributed database systems
In a heterogeneous distributed database system, 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.
mhz vee
3 days ago
There are now three separate classification of Data base which are relational, business intelligence, and NoSQL
Ask Your Own Question

Quick Questions

See More Academic Questions Questions