Types of Databases
There are different types of databases which are categorized on the basis of their functionalities. These are as follows :
Relational Databases :
- Relational Databases is the most common of all the different types of databases.
- In this, the data in a relational databases is stored in various tables. Each table has a key field which is used to connect it to other tables (Relationship). So, all the tables are related to each other through several key fields using relationship.
- These databases are extensively used in various industries, organizations and will be the one you are most likely to come across when working in IT.
- Examples : Oracle, Sybase and Microsoft SQL Server (MS SQL Server) and these are often key parts of the process of software development.
Operational Databases :
- In day to day life, an every fields like any organization, firm, institute generates a huge amount of data.
- Think of any inventory management, purchases, transactions and financials. All this data is collected in a database which is often known by many names like operational/ production database, subject-area database (SADB) or transaction databases.
- The data stored in operational databases can be changed and manipulated depending based on what the company requires.
Database Warehouses :
- Organizations or any firm are required to keep all relevant data for several years. This data is also an important source of information for analyzing and comparing the current year data with that of the past years which also makes it easier to determine key trends taking place.
- All those data from previous years are stored in a database warehouse. Since the data stored has gone through all kinds of screening, editing and integration it does not need any further editing or alteration in it.
- Types of databases can be well separated in terms of design, scale and integrity.
Distributed Databases :
- Many companies have several office locations (Remote Branches), manufacturing plants, regional offices, branch offices and a head office at different geographic locations.
- Each of these work groups may have their own database which together will form the main database for a company. This is known as a distributed database.
For More What is Database?