全部 标题 作者
关键词 摘要

OALib Journal期刊
ISSN: 2333-9721
费用:99美元

查看量下载量

相关文章

更多...

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

DOI: 10.4236/cweee.2013.23009, PP. 77-82

Keywords: Modeling, Database, Object-Oriented, Unified Modeling Language, OLAP Data Cubes, Water Supply

Full-Text   Cite this paper   Add to My Lib

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.

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.

Full-Text

Contact Us

service@oalib.com

QQ:3279437679

WhatsApp +8615387084133