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

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.

DOI: 10.4236/cweee.2013.23009                

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.

Keywords

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

Conflicts of Interest

The authors declare no conflicts of interest.

References

[1]	Object Management Group, “Unified Modeling Language Specification,” 2012. http://www.omg.org
[2]	G. Booch and J. Rambaugh, “The Unified Modeling Language,” User Guide Addison Wesley, Reading, 1999.
[3]	Wikipedia, “OLAP Cube,” 2013. http://en.wikipedia.org/wiki/OLAP_cube
[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.