A database has many models depending on whom the database is targeted for use. Different people having different requirements would want to use the database. So, they get different database models to use.
Common Database Models
Mainly, the following database models are used:-
- Strategic database model
- Tactical database model
- Clerical database model
The strategic database model is for those group of users that need to work on building strategies based on the data they have in the database. And they generally don’t perform day to day transactions on the data.
The Tactical database model refers to utilizing specific resources to achieve sub-goals that support the defined mission. It mainly depends upon experiences, best practices, plans, processes, and teams.
Clerical Layer or the operator layer is where most of the day to day operations happen. An operator in an organization requires a normal database application for day to day work. This creates most of the data for an organization, which is passed on for strategic operations on it later.
Also, the Database can be categorized into three types depending upon the use of the data, it contains.
Database types (based on database models)
- Current/Transaction Database
- Data Warehouse/History
- Data Mining
The transactions that take place in an organization while interacting with customers/users produces some data. Actually a lot of data. This goes into the Current or Transactional Database. It gets updated and altered very frequently. It can grow at a very high rate.
The data which becomes old and no operation takes place on that data, is taken out from the current database and stored separately. This is called the Data Warehouse. Also, it may also be a copy of the current database. Now, why do we need it? We need it for making future predictions, based on the patterns or insights that we produce from the data. We can use it to analyze trends and for analytics purposes.
Finally, Data mining is the process of analyzing data. The data may or may not be structured. Therefore, it may need some further processing.