Relational Database, GIS Layers, and Geodatabase for Cultural Heritage Management

  • Reference work entry
  • First Online:
Handbook of Cultural Heritage Analysis

Abstract

In this chapter, we highlight the difference between a geodatabase and a series of GIS layers stored in a file system. After a short introduction on some database basics, we introduce the spatial component in a relational database structure.

In order to clarify the explained concepts, some real cases are illustrated. They are all connected to the management of cultural heritage (ancient coins cataloging and management) with relational databases and GIS tools.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Similar content being viewed by others

References

  1. Antenucci JC, Brown K, Croswell PL, Kevany MJ, Archer H (1991) Geographic information systems. A guide to the technology. Chapman & Hall, New York

    Book  Google Scholar 

  2. Berg KL, Seymour T, Richa G (2013) History of databases. Int J Manag Inf Syst 17(1):29–36

    Google Scholar 

  3. Bernstein PA, Newcomer E (2009) Principles of transaction processing. Morgan Kaufmann-Elsevier, Burlington

    Google Scholar 

  4. Brusin G (1937) Notiziario archeologico (1935–1936), Atti e memorie della Società istriana di archeologia, vol 47

    Google Scholar 

  5. Burrough PA (1986) Principles of geographical information systems for land resources assessment. Clarendon Press, Oxford

    Book  Google Scholar 

  6. Callegher B (2010) Ritrovamenti monetali di età romana nel Friuli Venezia Giulia. Province di Gorizia e Trieste, RMRFVG III-IV. EUT, Trieste

    Google Scholar 

  7. Callegher B (2015) Un milione di denari sulla collina di Centur. In: Garaffo S, Mazza M (eds) Il tesoro di Misurata (Libia). Istituto Nazionale di Studi romani, Roma

    Google Scholar 

  8. Callegher B, Favretto A (2019) Thousands of Tetrarchy folles all over the world: an hypothesis of re-composition. In: Too big to study?, Polymnia. Numismatica Antica e Medievale. Studi, vol 11. EUT Edizioni Università di Trieste, Trieste

    Google Scholar 

  9. Chrisman N (1997) Exploring geographical information systems. Wiley, New York

    Google Scholar 

  10. Clarke KC (1999) Getting started with Geographical Information Systems. Prentice Hall, Upper Saddle River

    Google Scholar 

  11. Codd T (1970) A relational model of data for large shared data banks. Commun ACM 13(6):377–387

    Google Scholar 

  12. Date CJ (1994) An introduction to database systems. Addison Wesley, New York

    Google Scholar 

  13. Favretto A (2006) Strumenti per l’analisi geografica. GIS e Telerilevamento. Patron, Bologna

    Google Scholar 

  14. Favretto A, Callegher B (2017) Burgon’s expectation: ancient and new cartographic visualization for numismatic data and coin finds. Cartographica 52:2

    Article  Google Scholar 

  15. Favretto A, Montagnari M, Vidulli M, Moser S (2019) Database relazionali e “NoSQL”. Alcuni spunt per un corretto inquadramento delle metodologie. ASITA

    Google Scholar 

  16. Guarnieri A, Masiero A, Piragnolo M, Pirotti F, Vettore A (2016) A geodatabase for multisource data applied to cultural heritage: the case study of Villa Revedin Bolasco, International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, Volume XLI-B5

    Google Scholar 

  17. Hiebel G (2010) A relational database structure and user interface for the CIDOC CRM with GIS integration. 22nd CIDOC CRM and 16th FRBR CRM

    Google Scholar 

  18. Malinverni ES, Chiappini S, Pierdicca R (2019) A geodatabase for multisource data management applied to cultural heritage: the case study of Villa Buonaccorsi’s Historical Garden, International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, Volume XLII-2/W11

    Google Scholar 

  19. MCN (1999) Implementing the CIDOC CRM with a relational database. Spectra 24(1):1–6

    Google Scholar 

  20. Petrescu F (2007) The use of GIS technology in cultural heritage. In: XXI international CIPA symposium

    Google Scholar 

  21. Pierdicca R, Malinverni ES, Tassetti AN, Mancini A, Bozzi CA, Clini P, Nespeca R (2015) Development of a GIS environment for archaeological multipurpose applications: the Fano historic centre, Heritage and Technology, XIII International Forum, Le Vie dei Mercanti

    Google Scholar 

  22. Rigaux P, Scholl M, Voisard A (2001) Spatial databases: with application to GIS. Morgan Kaufmann Publishers, San Francisco

    Google Scholar 

  23. Shekhar S, Chawla S (2003) Spatial databases: a tour. Pearson Education Inc, Prentice Hall

    Google Scholar 

  24. Vacca G, Fiorino DR, Pili D (2018) A spatial information system (SIS) for the architectural and cultural heritage of Sardinia (Italy). ISPRS Int J Geo-Inf 7:49

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Andrea Favretto .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2022 Springer Nature Switzerland AG

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Favretto, A., Callegher, B. (2022). Relational Database, GIS Layers, and Geodatabase for Cultural Heritage Management. In: D'Amico, S., Venuti, V. (eds) Handbook of Cultural Heritage Analysis. Springer, Cham. https://doi.org/10.1007/978-3-030-60016-7_46

Download citation

Publish with us

Policies and ethics

Navigation