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.