Dynamic construction of lattice of cuboids in data warehouse. Issue 6 (17th August 2020)

• Record Type: Journal Article
• Authors: Mann, Suman; Phogat, Ajay Kumar
• Is Part Of: Journal of statistics & management systems. Volume 23:Issue 6(2020)
• Page Start: 971
• Page End: 982
• Publication Date: 2020-08-17
• Subjects: 94D94 -- Information Technology; Lattice of Cuboid -- Data Cube -- DW; Statistics -- Periodicals; Mathematical models -- Periodicals; Mathematical models; Statistics; Periodicals; 519.5
• DOI: 10.1080/09720510.2020.1799498
• Languages: English
• ISSNs: 0972-0510

Abstract

Abstract: In the field of Business Intelligence we require quick and efficient analysis of multidimensional data. Data warehouse (DW) and Online analytical processing (OLAP) approaches have been developed for this purpose which represents data in the form of cuboids. Lattice structures have been developed which consists of data cubes or cuboids. In the Lattice framework base cuboid contains all N - dimensions and moving up to the hierarchy we reach to 0 - Dimensional cuboid called apex cuboid. New cuboid may be generated by roll-up through dimension reduction. Dimension of cuboid may be reduced and increase according to business requirement. In this paper an algorithm is proposed for constructing cuboid dynamically. Cuboid are need to select in all ways for materialization purpose. Dynamic construction of cuboid enables materialization in fast and efficient way.