Real time study of existing warehouses
Answers
Answer:
- Real-time data warehousing Aggregation of analytical data in a data warehouse using continuous or near real- time loads. - Operational reporting and dashboards Selection of operational data into a reporting database for Business Intelligence tools and dashboards.
Answer:
Real-time Data Warehousing describes a system that reflects the state of the warehouse in real time. If a query is run against the real-time data warehouse to understand a particular facet about the business or entity described by the warehouse, the answer reflects the state of that entity at the time the query was run. Most data warehouses have data that are highly latent – or reflects the business at a point in the past. A real-time data warehouse has low latency data and provides current (or real-time) data.
Business demands are growing faster ,to sustain in the market it is necessary to serve the customers more quickly and accurately. This gives rise the need for very recent ,zero latent and fresh data for the data warehouse environment for making better decision making. Staleness of data would not be able to give proper guidelines and decision making for some specific domain applications. So for such domain applications real time or near real time environment is desirable. For arriving at faster and quicker decision making process Real time or near real time environment is becoming boon.