Abstract
In this paper, we introduce the visualization and analyses of multidimensional data sets using on-line analytic processing (OLAP). We discuss three fact table schemas for building data cubes for displaying different views and the levels of details of date sets Five operations of OLAP are used for manipulating data cubes including slice, dice, roll-up, drill-own, and rotation operations. By the five operations one can perform extraction, aggregation, sub-dividing, changing perspective of information stored in OLAP data cubes. We present a case study to explain the above operations. In the proposed case study, a student administration system was developed. To build data cubes, we established a constellation schema consisting of three fact tables and four dimension tables. We also demonstrate the five operations on the data cubes and discuss how these operations are applied to analyze data.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
