Preferences on OLAP and Generation of OLAP Schemata form Conceptual Graphical Model

This paper discuss about the OLAP preferences and generating OLAP schema automatically using conceptual graphical models. OLAP is expressed in preferences to avoid flooding of information and empty results. Main research issues are outlined when user preferences are used in OLAP multidimensional cubes. OLAP schema is generated automatically using the tool called Computer Aided data Warehouse Engineering(CAWE). BabelFish data warehouse design tool is developed for implementing such a tool and it generates the OLAP schema automatically. This paper also lists the differences between Conceptual Graphical Model notation and the data model of commercial OLAP tools. Further, it describes the graph grammars for MD schema descriptions and the generation process for OLAP schema. Keywords----Conceptual design, Data warehouse, Graphical Modeling notation, OLAP, Schema Genaration, User preferences 1.INTRODUCTION . This section gives the introduction on user preferences and OLAP schema generation automatically.