Implementation of a historical/geographical database with support of imprecise dates

  • O. Signore
  • R. Bartoli


Art history data management leads to express dates in a “fuzzy” way, which is not suitable for electronic processing.

A standardized, easy to use, way of coding dates, mantaining all the semantics of the “natural” format, has been defined. Each date is therefore expressed (in the extended way) as a string of characters, with a well defined syntax, while it is really managed as a set of fields, which contain, in a coded way, the same information that are contained in the extended format.

The coded format of dates is easily and transparently managed by every DBMS, thus allowing selection by exact values or by ranges.

This conventional way of managing dates has been tested in the implementation of a DBMS based historico-geographical authority file.


Extended Format Probable Date Imprecise Date Historical Geography Semantic Richness 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Chen, P.P.: The Entity-Relationship Model: Toward a Unified View of Data, ACM TODS 1, n. 1, 9–36, 1976CrossRefGoogle Scholar
  2. [2]
    Chen, P.P.: The Entity-Relationship Model: A Basis for the Enterprise View of Data, National Computer Conference, 77–84, 1977Google Scholar
  3. [3]
    Date C.J.: Defining Data Types in A Database Language,ACM SIGMOD RECORD, Vol. 17, N. 2 (June, 1988)Google Scholar
  4. [4]
    Papaldo S., Signore O.: A methodological approach to producing a historical/geographical databank,Multigrafica Editrice, Roma 1989 (ISBN 88–7597–105–6)Google Scholar
  5. [5]
    Signore O., Campari I., Magnarapa C., Ferrari O., Grita G., Papaldo S.: Schema di realizzazione ed elaborazione cartograf ea di un thesaurus Storicogeogra Pico CNUCE - Internal report C88–14, March 1988, PisaGoogle Scholar
  6. [6]
    Signore O., Bartoli R.: Controlling geographic descriptions: a case study for lzi.storico-geographical authority, International Conference on Terminology for Museums, 21–24 September 1988, Cambridge, UKGoogle Scholar
  7. [7]
    Signore O., Bartoli R.: Managing art history fuzzy dates: an application in historicogeographical authority, Historical Social Research, Vol. 14 (1989) No. 3Google Scholar
  8. [8]
    ISO/TC 97/SC 21/WG 3: Information Processing Systems - Database Language SQL ISO Standard 9075 (1989)Google Scholar
  9. [9]
    ISO/IEC JTC Database Language SQL2 SC21/WG3 N745Google Scholar
  10. [10]
    Overmyer R., Stonebraker M.: Implementation of a Time Expert in a Data Base System Acm Sigmod Record, Vol. 12, N. 3 (April, 1982 )Google Scholar

Copyright information

© Springer-Verlag/Wien 1990

Authors and Affiliations

  • O. Signore
    • 1
  • R. Bartoli
    • 1
  1. 1.Institute of CNRCNUCEPisaItaly

Personalised recommendations