The study of an abundant number of inscriptions leads to the conception of schemas and forms that can be organized into databases. This procedure allows us to arrange information with precision and to draw data and create connections between them in short time. For this reason, the relational database model has proved to be a valid support, as it makes possible to arrange data and information logically according to pre-established constraints and relationships, reducing errors and repetitions. The aim of this paper is to present an example of the use of a relational database created to catalogue inscriptions and point out positive aspects and difficulties found out during the process. The complexity of this method is mostly related to making choices about entities and identifying relationships between them; another obstacle is connected to the complexity of inscriptions as group of words and formulae. Nevertheless, the relational database allows the researcher to mix up data and information and create new relations between them using SQL operators. The software used for the case study that will be present in this paper is an open source administration and platform pgAdmin (for PostgreSQL).

The use of relational databases in epigraphy: a case study / S. Gazzoli. - In: STUDIA UNIVERSITATIS BABES-BOLYAI. DIGITALIA. - ISSN 2559-6721. - 63:2(2019 Mar 14), pp. 19-30. [10.24193/subbdigitalia]

The use of relational databases in epigraphy: a case study

S. Gazzoli
2019-03-14

Abstract

The study of an abundant number of inscriptions leads to the conception of schemas and forms that can be organized into databases. This procedure allows us to arrange information with precision and to draw data and create connections between them in short time. For this reason, the relational database model has proved to be a valid support, as it makes possible to arrange data and information logically according to pre-established constraints and relationships, reducing errors and repetitions. The aim of this paper is to present an example of the use of a relational database created to catalogue inscriptions and point out positive aspects and difficulties found out during the process. The complexity of this method is mostly related to making choices about entities and identifying relationships between them; another obstacle is connected to the complexity of inscriptions as group of words and formulae. Nevertheless, the relational database allows the researcher to mix up data and information and create new relations between them using SQL operators. The software used for the case study that will be present in this paper is an open source administration and platform pgAdmin (for PostgreSQL).
digital humanities, epigraphy, latin epigraphy, database, relational database
Settore L-ANT/03 - Storia Romana
30-dic-2018
Article (author)
File in questo prodotto:
File Dimensione Formato  
document.pdf

accesso aperto

Tipologia: Publisher's version/PDF
Dimensione 347.91 kB
Formato Adobe PDF
347.91 kB Adobe PDF Visualizza/Apri
Pubblicazioni consigliate

Caricamento pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/2434/633022
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus ND
  • ???jsp.display-item.citation.isi??? ND
social impact