Author(s)

Taskeen Zaidi, Annapurna Singh, Vipin Saxena

Department of Computer Science, B. B. Ambedkar University, Lucknow, India.
Department of Environmental Science, B. B. Ambedkar University, Lucknow, India.

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.

Modeling; Database; Object-Oriented; Unified Modeling Language; OLAP Data Cubes; Water Supply

Zaidi, T. , Singh, A. and Saxena, V. (2013) Modeling and OLAP Cubes for Database of Ground and Municipal Water Supply. Computational Water, Energy, and Environmental Engineering, 2, 77-82. doi: 10.4236/cweee.2013.23009.