Operational Database can simply define as a database of record, consisting of system specific reference data and event data belonging to a transaction update system which contains enterprise data which are up to date and modifiable.So this is the source of data for the data warehouse. When we further go more detail study about the optional database we can identify that operational database contains detailed data used to run the day to day operations of the business. That's why we can say that it contain data which as up to data as the name implies.
So, operational database, capturing real time data and supplying data for real time computations and other analyzing processes.
--AdvantagesThere are number of advantages of using an operational database. We can identify those advantages as follows,
- System-specific reference data and event data belonging to a transaction-update system
- Contain system control and detailed data used to run the day-to-day operations
- Data are up to date and data are modifiable
- Enterprise data