Scalability—is It An Advantage Of Cloud Computing?

By Author: Alston Dsouza
Total Articles: 12
Comment this article

Databases have developed from conventional relational databases to more sophisticated databases, including No SQL, columnar, key-value, hierarchical, and distributed databases, due to the proliferation of web and cloud technologies. Structured, semi-structured, and even unstructured data can all be handled by each kind.

Furthermore, databases continually handle delicate and crucial data. The need for compliance and the dispersed nature of most data sets have made managing databases difficult. To maintain large databases, organizations need tools that are reliable, secure, and easy to use. Database management systems fill this need by providing a framework for managing databases. Let’s look at it.
What is a database management system?

Using a DBMS, the following common database administration tasks can be carried out

Users may easily manage databases thanks to a piece of software called a database management system (DBMS). Through this, users can access and interact with the database’s data. These operations might be as simple as data queries or as complex as creating database schemas that significantly ...
... alter the structure of the database. Additionally, DBMS provides secure, concurrent user interaction with a database without compromising data integrity or interfering with other users.
Database management systems types

Although there are many distinct types of DBMS, we may divide the three types that are most frequently used into three groups.

Relational database management systems (RDBMS)

This DBMS type is the most prevalent. They are used to communicate with databases that have preset relationships and tables of structured data. Additionally, they communicate with databases using a structured query language (SQL). Popular DBMS in this area include Microsoft SQL, MySQL, and Oracle Database.
Document database management systems (DoDBMS)

Databases containing information stored in JSON-like forms with little to no relationship structure are managed using this DoDBMS. Database operations are powered by query languages like MongoDB query language (MQL). Some well-known examples of DoDBMS include MongoDB and Azure Cosmos DB.
Columnar database management systems (CDBMS)

As the name implies, this kind of DBMS is designed to manage columnar databases, which emphasize high performance by storing data in columns rather than rows. Apache Cassandra, Apache HBase, and other databases use a columnar format.
Database Management System Components

Every DBMS has a variety of integrated parts and tools that are required to complete practically all database management tasks. Some DBMS software even offers the option to go beyond the basic features by interacting with external tools and services, either directly or through plugins. In this section, we’ll examine the elements that all DBMS software has in common, such as

Source: https://www.esds.co.in/blog/database-management-systems-managing-your-data-landscape/