CWEEE  Vol.2 No.3 , July 2013
Modeling and OLAP Cubes for Database of Ground and Municipal Water Supply
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.
Cite this paper: 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.

[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.