Abstract
In this paper we describe the main results of a fifteen years research activity in the area of repositories of Entity-Relationship conceptual schemas. We first introduce a set of integration/abstraction primitives that are used in order to organize a large set of conceptual schemas in a repository. We describe the methodology conceived to produce the repository of schemas of central public administrations in Italy. Then we describe an heuristic methodology, applied in the production of the set of schemas of the public administrations of an italian region. We also compare the former exact methodology and the heuristic one according to their correctness, completeness, and efficiency. Finally, we show how such repositories can be used in eGovernment initiatives for planning activities and in the identification of projects. Further work highlights possible evolutions of the repositories toward enhanced semantic representations and usage.
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
Batini, C., Lenzerini, M.: A methodology for data schema integration in the Entity Relationship model. IEEE Transaction on Software Engineering (1984)
Batini, C., Battista, G.D., Santucci, G.: Structuring primitives for a dictionary of entity relationship data schemas. IEEE Trans. Software Eng. 19(4), 344–365 (1993)
Batini, C., Garasi, M.F., Grosso, R.: Reuse of a repository of conceptual schemas in a large scale project. In: Advanced Topics in Database Research, Idea Book (2005)
Batini, C., Grosso, R., Longobardi, G.: Design of repositories of conceptual schemas for large scale e-government projects. Journal of Electronic Government (March 2006) (to be published)
Elmasri, R., Navathe, S.: Foundamentals of database systems, 1st edn. Addison-Wesley Publishing Company, Reading (1994)
Bertoletti, M., Missier, P., Scannapieco, M., Aimetti, P., Batini, C.: Improving Government-to-Business Relationships through Data Reconciliation and Process Re-engineering. In: Wang, R. (ed.) Information Quality - Advances in Management Information Systems-Information Quality Monograph (AMIS-IQ) Monograph, Sharpe, M.E (2002) (Shorter version also in ICIQ 2002)
Themistocleus, M., Chen, H.: Investigating the integration of smes’ information systems: an exploratory case study. International Journal of Information Technology and Management 3(2/3/4), 208–234 (2004)
Batini, C., Lenzerini, M., Navathe, S.: Comparison of Methodologies for Database Schema Integration. ACM Computing Surveys 18(4) (1986)
Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal 10, 334–350 (2001)
Batini, C., Grosso, R., Longobardi, G.: Design of repositories of conceptual schemas in the small and in the large. In: Proceedings of the eGovernment Workshop 2005 (eGOV 2005), Hosted at Brunel University, September 13, West London UB8 3PH, UK (2005)
Mirbel, I.: Semantic Integration of Conceptual Schemas. In: Proceedings of the First International Workshop on Applications of Natural Language to Databases (NLDB 1995), Versailles, France, pp. 57–70 (1995)
Motro, A., Anokhin, P.: Fusionplex: resolution of data inconsistencies in the integration of heterogeneous information systems. Information fusion (2004)
Shoval, P., Danoch, R., Balaban, M.: Hierarchical entity-relationship diagrams: the model, method of creation and experimental evaluation. Requir. Eng. 9(4), 217–228 (2004)
Perez, J., Ramos, I., Cubel, J., Dominguez, F., Boronat, A., Carì, J.: Data reverse engineering of Legacy Databases to object oriented conceptual schemas. Electronic Notes in Theoretical Computer Science 74(4) (2002)
Madhavan, J., Bernstein, P.A., Doan, A., Halevy, A.Y.: Corpus-based schema matching. In: ICDE, pp. 57–68. IEEE Computer Society, Los Alamitos (2005)
Halevy, A.Y., Madhavan, J.: Corpus-based knowledge representation. In: Proc. International Joint Conference on Artificial Intel ligence (IJCAI 2003), vol. 18, pp. 1567–1572. Morgan Kaufmann, San Francisco (2003)
Taxonomic Databases Working Group Annual Meeting: Taxonomic Databases Working Group on Biodiversity Informatics, University of Canterbury, Christchurch, New Zealand. Taxonomic Databases Working Group Annual Meeting (2004)
Ruggia, R., Ambrosio, A.P.: A toolkit for reuse in conceptual modelling. In: Olivé, À., Pastor, J.A. (eds.) CAiSE 1997. LNCS, vol. 1250, pp. 173–186. Springer, Heidelberg (1997)
Wohed, P.: Conceptual patterns for reuse in information systems analysis. In: Wangler, B., Bergman, L.D. (eds.) CAiSE 2000. LNCS, vol. 1789, pp. 157–175. Springer, Heidelberg (2000)
Palopoli, L., Terracina, G., Ursino, D.: Dike: a system supporting the semi automic construction of cooperative information systems from heterogeneous databases. Software Practice and Experience 33(9), 847–884 (2003)
Gruber, T.: A translation approach to portable ontology specification. Knowledge Acquisition (5) (1993)
Guarino, N.: Formal ontologies and information systems. In: Guarino, N. (ed.) Proceedings of FOIS 1998. IOS Press, Amsterdam (1998)
Breuker, J., Hoekstra, R.: Epistemology and ontology in core ontologies: FOLaw and LRI-Core, two core ontologies for law. In: Proceedings of EKAW Workshop on Core ontologies. CEUR (2004)
Valente, A., Breuker, J.: Towards principled core ontologies. In: Proceedings of the Tenth Knowledge Acquisition for Knowledge-Based Systems Workshop, Banff, Alberta, Canada (1996)
Beneventano, D., Bergamaschi, S.: The MOMIS methodology for integrating heterogeneous data sources. In: IFIP Congress Topical Sessions, pp. 19–24. Kluwer, Dordrecht (2004)
Benetti, I., Beneventano, D., Bergamaschi, S., Guerra, F., Vincini, M.: An information integration framework for e-commerce. IEEE Intelligent Systems 17(1), 18–25 (2002)
McGuinness, D., van Harmelen, F.: Owl web ontology language overview (2003), http://www.w3.org/TR/2003/WD-owl-features-20030331/
Patel-Schneider, P., Hayes, P., Horrocks, I.: Web ontology language (owl). Technical report, W3C (February 2003), http://www.w3.org/TR/owl-semantics/
Antoniou, G., van Harmelen, F.: Web ontology language: Owl. In: Handbook on Ontologies, pp. 67–92. Springer, Heidelberg (2004)
Barone, D., Viscusi, G., Batini, C., Naggar, P.: A Repository of Services for the Government to Businesses relationship. In: Etzion, O., Kuflik, T., Motro, A. (eds.) NGITS 2006. LNCS, vol. 4032, pp. 47–58. Springer, Heidelberg (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Batini, C., Barone, D., Garasi, M.F., Viscusi, G. (2006). Design and Use of ER Repositories: Methodologies and Experiences in eGovernment Initiatives. In: Embley, D.W., Olivé, A., Ram, S. (eds) Conceptual Modeling - ER 2006. ER 2006. Lecture Notes in Computer Science, vol 4215. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11901181_30
Download citation
DOI: https://doi.org/10.1007/11901181_30
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-47224-7
Online ISBN: 978-3-540-47227-8
eBook Packages: Computer ScienceComputer Science (R0)