Design and Use of ER Repositories: Methodologies and Experiences in eGovernment Initiatives

  • Carlo Batini
  • Daniele Barone
  • Manuel F. Garasi
  • Gianluigi Viscusi
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4215)


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.


Public Administration Conceptual Schema Abstraction Level Logical Schema Abstract Schema 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Batini, C., Lenzerini, M.: A methodology for data schema integration in the Entity Relationship model. IEEE Transaction on Software Engineering (1984)Google Scholar
  2. 2.
    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)CrossRefGoogle Scholar
  3. 3.
    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)Google Scholar
  4. 4.
    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)Google Scholar
  5. 5.
    Elmasri, R., Navathe, S.: Foundamentals of database systems, 1st edn. Addison-Wesley Publishing Company, Reading (1994)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    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)CrossRefGoogle Scholar
  8. 8.
    Batini, C., Lenzerini, M., Navathe, S.: Comparison of Methodologies for Database Schema Integration. ACM Computing Surveys 18(4) (1986)Google Scholar
  9. 9.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal 10, 334–350 (2001)MATHCrossRefGoogle Scholar
  10. 10.
    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)Google Scholar
  11. 11.
    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)Google Scholar
  12. 12.
    Motro, A., Anokhin, P.: Fusionplex: resolution of data inconsistencies in the integration of heterogeneous information systems. Information fusion (2004)Google Scholar
  13. 13.
    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)CrossRefGoogle Scholar
  14. 14.
    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)Google Scholar
  15. 15.
    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)Google Scholar
  16. 16.
    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)Google Scholar
  17. 17.
    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)Google Scholar
  18. 18.
    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)CrossRefGoogle Scholar
  19. 19.
    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)CrossRefGoogle Scholar
  20. 20.
    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)CrossRefGoogle Scholar
  21. 21.
    Gruber, T.: A translation approach to portable ontology specification. Knowledge Acquisition (5) (1993)Google Scholar
  22. 22.
    Guarino, N.: Formal ontologies and information systems. In: Guarino, N. (ed.) Proceedings of FOIS 1998. IOS Press, Amsterdam (1998)Google Scholar
  23. 23.
    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)Google Scholar
  24. 24.
    Valente, A., Breuker, J.: Towards principled core ontologies. In: Proceedings of the Tenth Knowledge Acquisition for Knowledge-Based Systems Workshop, Banff, Alberta, Canada (1996)Google Scholar
  25. 25.
    Beneventano, D., Bergamaschi, S.: The MOMIS methodology for integrating heterogeneous data sources. In: IFIP Congress Topical Sessions, pp. 19–24. Kluwer, Dordrecht (2004)Google Scholar
  26. 26.
    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)CrossRefGoogle Scholar
  27. 27.
    McGuinness, D., van Harmelen, F.: Owl web ontology language overview (2003),
  28. 28.
    Patel-Schneider, P., Hayes, P., Horrocks, I.: Web ontology language (owl). Technical report, W3C (February 2003),
  29. 29.
    Antoniou, G., van Harmelen, F.: Web ontology language: Owl. In: Handbook on Ontologies, pp. 67–92. Springer, Heidelberg (2004)Google Scholar
  30. 30.
    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)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Carlo Batini
    • 1
  • Daniele Barone
    • 1
  • Manuel F. Garasi
    • 1
  • Gianluigi Viscusi
    • 1
  1. 1.Dipartimento di Informatica Sistemistica e Comunicazione (Disco)Università degli Studi di Milano-BicoccaItaly

Personalised recommendations