This article aims to solve the performance problems of offline data warehouses (daily and hourly) during production and usage.