Question: what is the difference between operational database and data warehouse?
Answer: Difference between Operational Database and Data Warehouse. ... 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.