Database Design of a Geo-environmental Information System

George Roumelis, Thanasis Loukopoulos, Michael Vassilakopoulos

Abstract

Environmental protection from productive investments becomes a major task for enterprises and constitutes a critical competitiveness factor. The region of Central Greece presents many serious and particular environmental problems. An Environmental Geographic Information System is under development that will maintain necessary and available information, including existing environmental legislation, specific data rules, regulations, restrictions and actions of the primary sector, existing activities of the secondary and tertiary sectors and their influences. The system will provide information about the environmental status in each location with respect to water resources, soil and atmosphere, the existence of significant pollution sources, existing surveys, studies and measurements for high risk areas, the land use and legal status of locations and the infrastructure networks. In this paper, we present a Database Design that supports the above mentioned objectives and information provision. More specifically, we present examples of user queries that the system should be able to answer for extraction of useful information, the basic categorization of data that will be maintained by the system, a data model that is able to support such data maintenance and examine how existing indexing structures can be utilized for efficient processing of such queries.

References

  1. Beckmann, N., Kriegel, H.P., Schneider, R., Seeger, B., 1990. The R*-tree: an Efficient and Robust Access Method for Points and Rectangles. In SIGMOD Conference, 322-331.
  2. Comer, D., 1979. The Ubiquitous B-tree. ACM Computing Surveys 11(2), 121-137.
  3. Corral, A., Vassilakopoulos, M., 2009. Query Processing in Spatial Databases. In Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, Vol II, 269-278, Information Science Reference.
  4. Dinu, V., Nadkarni, P., 2007. Guidelines for the effective use of entity-attribute-value modeling for biomedical databases, International journal of medical informatics, 76 (11-12), 769-779.
  5. Gandhi, V., Kang, J. M., Shekhar, S., 2009. Spatial Databases. In Encyclopedia of Computer Science and Engineering, Cassie Craig (Eds.), Wiley.
  6. Kim, Y.J., Patel, J., 2010. Performance Comparison of the R*-tree and the Quadtree for kNN and Distance Join Queries. IEEE Transactions on Knowledge and Data Engineering 22(7), 1014-1027.
  7. Manolopoulos, Y., Nanopoulos, A., Papadopoulos, A.N., Theodoridis, Y., 2006. Rtrees: Theory and Applications, Springer, London.
  8. Regina, O., Hsu, L., 2011. PostGIS in action, Manning Publications Co., Stamford.
  9. Roumelis, G., Vassilakopoulos, M., Corral, A., 2011. Performance Comparison of xBR-trees and R*-trees for Single Dataset Spatial Queries. In Proc. of ADBIS 2011, 228-242.
  10. Thalheim, B., 2000. Entity-Relationship Modeling: Foundations of Database Technology, SpringerVerlag New York, Inc. Secaucus.
  11. Vassilakopoulos, M., Corral, A., 2009. Spatio-Temporal Indexing Techniques. In Handbook of Research on Innovations in Data base Technologies and Applications: Current and Future Trends, Vol II, 260- 268 Information Science Reference.
  12. Wainwright, J., Mulligan, M. (Eds), 2013. Environmental Modelling: Finding Simplicity in Complexity, John Wiley & Sons, Chichester, 2nd ed.
  13. Paolino, L., Sebillo, M., Tortora, G., Vitiello, G., 2010. Integrating Discrete and Continuous Data in an OpenGeospatial-Compliant Specification. Transactions in GIS, 14 (6), 731-753.
Download


Paper Citation


in Harvard Style

Roumelis G., Loukopoulos T. and Vassilakopoulos M. (2014). Database Design of a Geo-environmental Information System . In Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 2: ICEIS, ISBN 978-989-758-028-4, pages 375-382. DOI: 10.5220/0004952603750382


in Bibtex Style

@conference{iceis14,
author={George Roumelis and Thanasis Loukopoulos and Michael Vassilakopoulos},
title={Database Design of a Geo-environmental Information System },
booktitle={Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 2: ICEIS,},
year={2014},
pages={375-382},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004952603750382},
isbn={978-989-758-028-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 2: ICEIS,
TI - Database Design of a Geo-environmental Information System
SN - 978-989-758-028-4
AU - Roumelis G.
AU - Loukopoulos T.
AU - Vassilakopoulos M.
PY - 2014
SP - 375
EP - 382
DO - 10.5220/0004952603750382