Materialized View Driven Architecture over Lattice of Cuboids in Data Warehouse
Partha Ghosh, Takaaki Goto, Jyotsna Kumar Mandal, Soumya Sen · 2021
Data warehouse is used across the organizations for analytical processing. It is organized in the form of lattice of cuboids for carrying out the different types of analysis. The structure of lattice of cuboids grows exponentially with the number of dimensions. Every cuboid contains huge amount of data. The data size is multiplied in the data warehouse as a new entry takes place in any dimension. In modern day business analysis, processing the data in real-time is one of the intrinsic requirements. However, with the gigantic structure of lattice of cuboids along with the highly loaded data in every cuboid it is difficult to achieve the real-time processing. View materialization is practiced over the decades for faster query processing in the database applications. This research proposed a fuzzy based materialized data-cube driven warehouse architecture for fast decision making. Experimental output shows the proposed methodology achieves faster data analysis and better hit-miss ratio in the materialized data-cubes.