Question: what is the difference between transactional database and data warehouse databases?
Answer: The traditional database stores information in a relational model and prioritizes transactional processing of the data. This is known as an OLTP database. Data warehouses prioritize analysis, and are known as OLAP databases.