Modeling and OLAP Cubes for Database of Ground and Municipal Water Supply


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.

Share and Cite:

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.

Conflicts of Interest

The authors declare no conflicts of interest.


[1] Object Management Group, “Unified Modeling Language Specification,” 2012.
[2] G. Booch and J. Rambaugh, “The Unified Modeling Language,” User Guide Addison Wesley, Reading, 1999.
[3] Wikipedia, “OLAP Cube,” 2013.
[4] A K. Barua, “Water Technology Management Challenges and Choices in Sustainability of Water Use,” Dominant Publishers and Distributors, New Delhi, 2001, pp. 2-3.
[5] Bureau of Indian Standards, “Indian Standard Specifications of Drinking Water,” B.S. 2001.
[6] J. A. Camargo and A. Alonso, “Ecological and Toxicological Effects of Inorganic Nitrogen Pollution in Aquatic Ecosystems: A Global Assessment,” Environment International, Vol. 32, No. 6, 2006, pp. 831-849. doi:10.1016/j.envint.2006.05.002
[7] L. S. Clesceri, et al., “Standard Methods for the Examination of Water and Waste Water,” American Public Health Association, Washington DC, 1998, p. 19.
[8] A. Singh, et al., “Status of Ground Water and Municipal Water Supply of Lucknow Region U.P.,” International Journal of Plant, Animal and Environmental Sciences, Vol. 2, No. 4, 2012, 4 Pages.

Copyright © 2022 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.