? Define and describe the differences between OLTP and OLAP databases.
o What are the characteristics of each that make them different?
o What types of businesses would use an OLTP database?
o What kinds of companies would use an OLAP database?
? Describe the differences between a data mart and data warehouse.
o Is it possible that one company may set up a data warehouse that a different company may call a data mart? Support your answer.
Complete the following:
• Define and describe the differences between OLTP and OLAP databases.
Operational databases (OLTP): these database mainly for hosting a large amount of customer data, personal data, inventory data is called operation or production database or subject area database (SADB) or transaction databases. The data can be manipulated (update, deleted, insert) depending on the day to day business requirements.
It allows transaction-related applications and provides real time access to data will constantly being updated.
OLAP which stands for Online Analytical Processing refers to a process where it provides answers to simple to complicated analytical queries that are multi-dimensional in nature that business needs to get answers. ...
The differences between OLTP and OLAP databases are examined.