There are various types of database available in the market. Each database comes into use as per the requirement.
As the name suggests, in a centralized database, all information(data) is stored at a central location from where different users access this data. In order to access data from centralized database, there is an authentication process which exhibits the data security.
A single database located at one site on a network.
Advantages of Centralized Database:
Disadvantages of Centralized Database:
In contrary of Centralized database concept, in distributed database the data is distributed among several database systems. Despite being different databases under an organization, communication is very easy because of communication links among them.
Distributed database is further divided into :
When data is collected and stored on some personal computer system is called Personal Database. In Personal Database, data is small and easy to manage and designed for single user.
Commercial databases are designed specially for paid and huge data management. These types of database are subject specific and costs very high in maintenance.
End user database is specially designed for those user who usually not concerned about all operations. Only the end result or conclusive result are managed to presentable for end user.
Relational databases are used to store only categorized type of data into tabular format. Data are arranged in rows and columns, where columns defines the specific data entry for that data and rows contain the one instance of record or data. In relational database, each table has its own primary or unique key which recognize a record uniquely from the table.
MySQL, SQL Server, Oracle etc are best example of relational databases.
NoSQL database comes into use when there is a huge data is required to store in database. Unlike relational database, it stores data in various different ways. Now a days it is being used as of demand of modern application based architecture.
NoSQL databases further divided into four categories:
Advantages of using NoSQL database:
These kinds of databases are used in the field of transaction operations. It covers the data of marketing, employee relations and customer service etc. and creates updates in real time. Suitable for those applications which comes for daily use.
Cloud database is also know as a virtual environment. A cloud database is designed for those user where the storage capacity and bandwidth is managed to provide performance on the basis of end user paid criteria. It maintains the standard of scalability on demand along with high avalablity.
These types of databases uses the object based data model approach for storing and retrieving data in the database system.
Graph Database comes into use for storing huge and complex data in graph like structure. It is used for social networking applications due to analyzing interconnections.