It contains data in the form of word files, spreadsheets, and presentations. Each user has a workstation and which acts as a small database itself. End-User database Software: There are different types of users using a database. Group has its own database, which can be combined to form the main database ofĥ. Offices, manufacturing units, distributed databases are used there. Makes the process of identifying the key trends easily.ĭatabase Software: The organizations that have various branch offices, regional Present year in comparison of those from previous years to predict trends. These sources of information are required to analyze the data of Warehouse Software: Some data sets are required to be archived for a long The data can be analyzed and utilized for the betterment of an organization. It can keep a track of inventories and store details of customers.
This type of database management software is used in the media and telecom industries.ĭatabase Software: An operational database software supports inventory and customerĭatabases.
Thus, different tables are related to one another with the help of different key fields. Each table requires a unique key that is used to connect one table to another. In a relational database, the data is stored in the form of data tables. Relational Database Software: These are the most common types of databases.
Let’s have a look at the types of free and open source DBMS software availableġ.
Operational database, database warehouses, distributed database and end-userĭatabase. The databases are majorly divided in 5 types: Relational database,