Key Features
- They are used for storing historical data.
- Low Latency / Response time is fast.
- Data consistency and quality of data.
- Used with Business Intelligence, Data Analysis & Data Science.
By doing all the above, it answers some of the questions the business/needs.
- Sales of particular items this month compared to last month?
- Top 3 best-selling products of the quarter?
- How is the internet traffic before the pandemic / during the pandemic?
It's read-only for end-users and upper management.
Who are the end users?
- Data Analysts
- Data Scientists.
Data Size
A query can range from a few thousand rows to billion rows.