Real-time Data Warehouse

Share an example of a real-time data warehouse.
The customer is a municipal Tobacco Company and needs to analyze the cigarette sales data in real time. About 0.1 million pieces of data are collected every day, which occurs within four hours.
Our solution is:
1. The dimension table information is processed every night (the customer will not maintain the basic File Content During the smoke setting process on the Day );
2. historical fact table data is processed every night;
3. The smoke data of the current day is used as a view to query the data of the business system. Only the data of the current day is queried (the query time is about 2-3 seconds );
4. Combine the historical data and the current-day data into another view to display the data;
5. Some content to be calculated (such as sales gross profit) is implemented in front-end tools.