Abstract
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.
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
Chen, P.P.: The Entity-Relationship Model: Toward a Unified View of Data, ACM TODS 1, n. 1, 9–36, 1976
Chen, P.P.: The Entity-Relationship Model: A Basis for the Enterprise View of Data, National Computer Conference, 77–84, 1977
Date C.J.: Defining Data Types in A Database Language,ACM SIGMOD RECORD, Vol. 17, N. 2 (June, 1988)
Papaldo S., Signore O.: A methodological approach to producing a historical/geographical databank,Multigrafica Editrice, Roma 1989 (ISBN 88–7597–105–6)
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, Pisa
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, UK
Signore O., Bartoli R.: Managing art history fuzzy dates: an application in historicogeographical authority, Historical Social Research, Vol. 14 (1989) No. 3
ISO/TC 97/SC 21/WG 3: Information Processing Systems - Database Language SQL ISO Standard 9075 (1989)
ISO/IEC JTC 1.21.3.3: Database Language SQL2 SC21/WG3 N745
Overmyer R., Stonebraker M.: Implementation of a Time Expert in a Data Base System Acm Sigmod Record, Vol. 12, N. 3 (April, 1982 )
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1990 Springer-Verlag/Wien
About this chapter
Cite this chapter
Signore, O., Bartoli, R. (1990). Implementation of a historical/geographical database with support of imprecise dates. In: Tjoa, A.M., Wagner, R. (eds) Database and Expert Systems Applications. Springer, Vienna. https://doi.org/10.1007/978-3-7091-7553-8_43
Download citation
DOI: https://doi.org/10.1007/978-3-7091-7553-8_43
Publisher Name: Springer, Vienna
Print ISBN: 978-3-211-82234-0
Online ISBN: 978-3-7091-7553-8
eBook Packages: Springer Book Archive