Database Systems

Introduction

In the era of data analytics, big data, database management plays a crucial role in both the creation and management of data. Without it, running and managing data effectively is not practicable.

Types of Database

There are various types of databases used for storing different varieties of data. Few are: [1] JavaTPoint. Types of databases. 2018.

Centralized Database:

Centralized Database: It’s an easement to the users as they can access the stored data from different locations through several applications.

Relational Database:

It stores data in the form of rows(tuple) and columns(attributes), and together forms a table(relation). It uses SQL for storing, manipulating, as well as maintaining the data. Few examples are MySQL, Microsoft SQL Server, Oracle, etc.

NoSQL Database:

Non-SQL/Not Only SQL is a type of database that is used for storing a wide range of data sets. It is not a relational database as it stores data not only in tabular form but in several different ways. It could be further divided into four different categories:

• Key-value Storage: A simplest type of database storage where every single item is stored as a key(or attribute name) holding its value, together.
• Document-oriented Databases: Data is stored as JSON-like documents. Its advantage is that it helps developers in storing data by using the same document-model format as used in the application code.
• Graph Databases: They are used for storing vast amounts of data in a graph-like structure. Social networking websites most commonly use graph databases.
• Wide-column stores: It is similar to the data represented in relational databases. Instead of storing data is rows they are stored in large columns together.