In DBMS, there are different types of databases. We can choose from these various types of databases depending on our requirements.
- Relational Database
- Operational Database
- Database Warehouses
- Distributed Databases
- End-User Database
- External Database
- Hypermedia Database
- Navigational Database
- In-Memory Database
- Document-Oriented Database
Among all the different types of databases, this is the most common. Databases in a relational database are stored in various data tables. There is a key field in each table that allows it to be connected to other tables. Therefore, all the tables are linked through key fields. Databases like these are widely used in various industries and are the ones you are most likely to see when working in IT.
Organizations generate a large amount of data on a daily basis. Consider things like inventory management, purchases, transactions, and financials. In a database, all the data is stored, which is often called an operational/production database, a subject-area database, or a transaction database.
Organizations are required to keep all relevant data for several years. In the UK it can be as long as 6 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.
A distributed database system is the union of what appear to be two diametrically opposed approaches to data processing. This binds the database system and computer network together. There are many organizations that have several offices at different locations, manufacturing plants, regional offices, branch offices, and head offices at different locations. Each of the workgroups may have its own database which together will form the main database of the company.
- Advantages and Disadvantages of DBMS
- Normalizations and Different of Distributed Database
- Types of Database Network Models
- Responsibilities of a database administrator DBA?
There is a variety of data available at the workstation of all the end-users of any organization. Each workstation is like a small database in itself which includes data in spreadsheets, presentations, word files, notepads, and downloaded files. All such small databases form a different type of database called the end-user database.
Vast information available outside the world is required by an organization. They are privately-owned data for which one can have conditional or limited access for a fortune. This data is meant for commercial usage. All such databases outside the organizations which are of use and limited access are together called external databases.
The World Wide Web is interconnected and they all contain text, audio, visual, clips, photographs, and any other graphics materials. These all need to be stored and “Called” from somewhere when the webpage is created or accessed. All of them together form the hypermedia database.
The navigational database has all the items which are references from other objects. In this, one has to navigate from one reference to another or one object to other. It might be using modern systems like XPath. One of the applications is the air flight management system.
Memory databases store data in a computer’s main memory instead of using a disk-based storage system. It is faster and more reliable than that in a disk. They find their application in telecommunications network equipment.
A document-oriented database is a different type of database which is used in applications that are document-oriented. The data is stored in the form of text records instead of being stored in a data table as usually happens.