Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

What is a data warehouse and how is it different from a traditional database used to support OLTP?

Contents
  1. What is data warehouse How does it differ from an OLTP system?
  2. How is data warehouse different from database and how are they similar?
A data warehouse is designed to handle large analytical queries. This eliminates the performance strain that analytics would place on a transactional system. An OLTP database structure features very complex tables and joins because the data is normalized (it is structured in such a way that no data is duplicated). 6 сент. 2018 г.


What is data warehouse How does it differ from an OLTP system?

In the OLTP database, there is authentic and current data, and the schema used to store transactional database is the entity model (usually 3NF). ... OLTP Database.Data Warehouse DatabaseOLTP DatabaseIt provides some concurrent users relative to OLTP.It provides thousands of concurrent users.

How is data warehouse different from database and how are they similar?

Databases are mainly used for recording data. On the other hand, data warehouses are designed for analyzing data. Databases are normally optimized for read-write operations of single-point transactions, while data warehouses are applied for big analytical queries.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours