Types of Databases

As databases play a very critical role in the application and its existence a quality analyst must understand the usage and features of the database to plan a perfect database testing strategy.

Before heading to creating a database testing strategy we will first understand the basic database operations and different aspects of applicable test areas.

Defining Databases

Database is an organized collection of structured data which can be easily accessible and manageable. The main purpose of the database is to operate a large amount of information by storing, retrieving, and managing data.

A system that contains databases is called a database management system or DBM. There are many databases available like MySQL, Oracle, MongoDB, SQL Server, etc.

Database Management System (DBMS)

Database Management System (DBMS) is a collection of programs which is used to access database, manipulate data, reporting and representation of  data. Basically it is an interface to perform various operations like database creation, storing data in it, updating data, creating a table.

It provides protection and security to the database and in case of multiple users, it also maintains data consistency. It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).

Types of Databases

Depending upon the usage requirements, there are following types of databases available

  • Hierarchical databases
  • Network databases
  • Relational databases
  • Object-oriented databases
  • Graph databases
  • ER model databases
  • Document databases
  • NoSQL databases
What is Relational database?

A relational database represents a collection of related (two-dimensional) tables. Each of the tables are like an Excel spreadsheet, with a fixed number of named columns (the attributes or properties of the table) and any number of rows of data.