TITLE:
Modeling and OLAP Cubes for Database of Ground and Municipal Water Supply
AUTHORS:
Taskeen Zaidi, Annapurna Singh, Vipin Saxena
KEYWORDS:
Modeling; Database; Object-Oriented; Unified Modeling Language; OLAP Data Cubes; Water Supply
JOURNAL NAME:
Computational Water, Energy, and Environmental Engineering,
Vol.2 No.3,
July
9,
2013
ABSTRACT: Modeling plays an important role for the solution of the complex research problems. When the database became large and complex then it is necessary to create a unified model for getting the desired information in the minimum time and to implement the model in a better way. The present paper deals with the modeling for searching of the desired information from a large database by storing the data inside the three dimensional data cubes. A sample case study is considered as a real data related to the ground water and municipal water supply, which contains the data from the various localities of a city. For the demonstration purpose, a sample size is taken as nine but when it becomes very large for number of localities of different cities then it is necessary to store the data inside data cubes. A well known object-oriented Unified Modeling Language (UML) is used to create Unified class and state models. For verification purpose, sample queries are also performed and corresponding results are depicted.