in Dataware house by
Q:
What is the Difference between Operational Database and Data Warehouse

1 Answer

0 votes
by

Difference between Operational Database and Data Warehouse

Operational Database and Data Warehouse

The Operational Database is the source of information for the data warehouse. It includes detailed information used to run the day to day operations of the business. The data frequently changes as updates are made and reflect the current value of the last transactions.

Operational Database Management Systems also called as OLTP (Online Transactions Processing Databases), are used to manage dynamic data in real-time.

Data Warehouse Systems serve users or knowledge workers in the purpose of data analysis and decision-making. Such systems can organize and present information in specific formats to accommodate the diverse needs of various users. These systems are called as Online-Analytical Processing (OLAP) Systems.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
0 votes
asked Oct 16, 2019 in Dataware house by Robin
0 votes
asked Oct 20, 2019 in Dataware house by rajeshsharma
0 votes
asked Sep 19, 2019 in Interview Question by Robin
0 votes
asked Oct 20, 2019 in Dataware house by rajeshsharma
0 votes
asked Feb 5, 2020 in Big Data | Hadoop by SakshiSharma
...