Abstract
There currently exist many geographical databases that represent a same part of the world, each with its own levels of detail and points of view. The use and management of these databases sometimes requires their integration into a single database. One important issue in this integration process is the ability to analyse and understand the differences among the multiple representations. These differences can of course be explained by the various specifications but can also be due to updates or errors during data capture. In this paper, after describing the overall process of integrating spatial databases, we propose a process to interpret the differences between two representations of the same geographic phenomenon. Each step of the process is based on the use of an expert system. Rules guiding the process are either introduced by hand from the analysis of specifications, or automatically learnt from examples. The process is illustrated through the analysis of the representations of traffic circles in two actual databases.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Hurson, A., Bright, M.: Multidatabase systems: An advanced concept in handling distributed data. Advances in Computers 32, 149–200 (1992)
Sheth, A., Larson, J.: Federated database systems for managing distributed heterogeneous, and autonomous databases. ACM Computing Surveys 22, 183–236 (1990)
Özsu, M., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs (1999)
Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys 18, 323–364 (1986)
Rahm, E., Bernstein, P.: A survey of approaches to automatic schema matching. Very Large Database Journal 10, 334–350 (2001)
Dupont, Y.: Resolving fragmentation conflicts in schema integration. In: Proceedings of the International Conference on Conceptual Modeling/Entity Relationship Approach. LNCS, vol. 881, Springer, Heidelberg (1994)
Kim, W., Choi, I., Gala, S., Scheevel, M.: On resolving schematic heterogeneity in multidatabase systems. Distributed and Parallel Databases Journal 1, 251–279 (1993)
Spaccapietra, S., Parent, C., Dupont, Y.: Model independant assertions for integration of heterogeneous schemas. Very Large Database Journal 1, 81–126 (1992)
Levy, A.: Combining artificial intelligence and database for data integration. In: Veloso, M.M., Wooldridge, M.J. (eds.) Artificial Intelligence Today. LNCS (LNAI), vol. 1600, pp. 249–268. Springer, Heidelberg (1999)
Calvanese, D., Giacomo, G.D., Lenzerini, M., Nardi, D., Rosati, R.: Knowledge representation approach to information integration. In: Proceedings of AAAI Workshop on Artificial Intelligence and Information Integration, pp. 58–65. AAAI Press/The MIT Press (1998)
Lemarie, C., Badard, T.: Cartographic database updating. In: Proceedings of the 20th International Cartographic Conference (ICC), vol. 2, pp. 1376–1385 (2001)
Devogele, T.: A new merging process for data integration based on the discrete fréchet distance. In: Proceedings of the 10th International Symposium on Spatial Data Handling (SDH), pp. 167–181 (2002)
Vangenot, C., Parent, C., Spaccapietra, S.: Modeling and manipulating multiple representations of spatial data. In: Proceedings of the 10th International Symposium on Spatial Data Handling (SDH), pp. 81–93 (2002)
Kidner, D., Jones, C.: A deductive object-oriented gis for handling multiple representations. In: Proceedings of the 6th International Symposium on Spatial Data Handling (SDH), vol. 2, pp. 882–900 (1994)
Timpf, S., Frank, A.: A multi-scale dag for cartographic objects. In: Proceedings of Auto-Carto, vol. 12, pp. 157–163 (1995)
Egenhofer, M., Clementini, E., Felice, P.D.: Evaluating inconsistencies among multiple representations. In: Proceedings of the 6th International Symposium on Spatial Data Handling (SDH), vol. 2, pp. 901–920 (1994)
El-Geresy, B., Abdelmoty, A.: A qualitative approach to integration in spatial databases. In: Quirchmayr, G., Bench-Capon, T.J.M., Schweighofer, E. (eds.) DEXA 1998. LNCS, vol. 1460, p. 280. Springer, Heidelberg (1998)
Devogele, T., Parent, C., Spaccapietra, S.: On spatial database integration. International Journal of Geographical Information Science 12, 335–352 (1998)
Strauch, J., de Souza, J.M., Mattoso, M.: A methodology for gis databases integration. In: Technical Report, Federal University of Rio de Janeiro (1998)
BelHadjAli, A.: Qualité géométrique des entités surfaciques. Application à lappariement et définition dune typologie des écarts géométriques. Phd thesis, Universit é de Marne-la-Vallée (2001)
Devogele, T.: Processus d’intégration et d’appariement de bases de données géographiques; application à une base de données routières multi-échelles. Phd thesis in computer science, Université de Versailles (1997)
Walter, V., Fritsch, D.: Matching spatial data sets: a statistical approach. International Journal of Geographical Information Science 13, 445–473 (1999)
Parent, C., Spaccapietra, S., Devogele, T.: Conflicts in spatial database integration. In: Proceedings of the 9th International Conference on Parallel and Distributed Computing Systems, pp. 772–778 (1996)
Parent, C., Spaccapietra, S.: Database integration: the key to data interoperability. In: Advances in Object-Oriented Data Modeling, The MIT Press, Cambridge (2001)
Mustiere, S., Gesbert, N., Sheeren, D.: A formal model for the specifications of geographic databases. In: Proceedings of the Workshop on Semantic Processing of Spatial Databases (GeoPro), pp. 152–159 (2003)
Gesbert, N., Libourel, T., Mustière, S.: Apport des spécifications pour les modèles de bases de données géographiques. Revue Internationale de Géomatique (2004) (under review)
Mitchell, T.M.: Machine Learning. McGraw-Hill International, New York (1997)
Sester, M.: Knowledge acquisition for the automatic interpretation of spatial data. International Journal of Geographical Information Science 14, 1–24 (2000)
Malerba, D., Esposito, F., Lanza, A., Lisi, F., Appice, A.: Machine learning for information extraction from topographic maps. In: Geographic Data Mining and Knowledge Discovery, pp. 291–314. Taylor & Francis, Abington (2001)
Sheeren, D.: Spatial databases integration: Interpretation of multiple representations by using machine learning techniques. In: Proceedings of the 21st International Cartographic Conference (ICC), pp. 235–245 (2003)
David, J.M., Krivine, J.P., Simmons, R.: Second Generation Expert Systems. Springer, Heidelberg (1993)
Badard, T., Braun, A.: Oxygene: an open framework for the deployment of geographic web services. In: Proceedings of the 21st International Cartographic Conference (ICC), pp. 994–1003 (2003)
Jess: A rule engine for the java platform (2003), http://herzberg.ca.sandia.gov/jess/
Visser, U., Stuckenschmidt, H., Schuster, G., Vogele, T.: Ontologies for geographic information processing. Computers and Geosciences 28, 103–117 (2002)
Quilan, J.R.: C4.5: Programs for machine learning. Morgan Kaufmann, San Francisco (1993)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Sheeren, D., Mustière, S., Zucker, JD. (2004). How to Integrate Heterogeneous Spatial Databases in a Consistent Way?. In: Benczúr, A., Demetrovics, J., Gottlob, G. (eds) Advances in Databases and Information Systems. ADBIS 2004. Lecture Notes in Computer Science, vol 3255. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30204-9_25
Download citation
DOI: https://doi.org/10.1007/978-3-540-30204-9_25
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23243-8
Online ISBN: 978-3-540-30204-9
eBook Packages: Springer Book Archive