Temporal functional dependencies (TFDs) add a temporal component to classical functional dependencies to deal with temporal data. As an example, while functional dependencies model constraints like “employees with the same role get the same salary”, TFDs can represent constraints like “for any given month, employees with the same role have the same salary, but their salary may change from one month to the next one” or “current salaries of employees uniquely depend on their current and previous roles”. In this paper, we propose a general framework for specifying TFDs, possibly involving different time granularities, and for checking whether or not a given database instance satisfies them. The proposed framework subsumes existing formalisms for TFDs and it allows one to encode TFDs which are not captured by them.

A uniform framework for temporal functional dependencies with multiple granularities

Carlo Combi
;
Pietro Sala
2011

Abstract

Temporal functional dependencies (TFDs) add a temporal component to classical functional dependencies to deal with temporal data. As an example, while functional dependencies model constraints like “employees with the same role get the same salary”, TFDs can represent constraints like “for any given month, employees with the same role have the same salary, but their salary may change from one month to the next one” or “current salaries of employees uniquely depend on their current and previous roles”. In this paper, we propose a general framework for specifying TFDs, possibly involving different time granularities, and for checking whether or not a given database instance satisfies them. The proposed framework subsumes existing formalisms for TFDs and it allows one to encode TFDs which are not captured by them.
Temporal Database, Functional Dependencies, Granularity, Biomedical Data
File in questo prodotto:
File Dimensione Formato  
paper-SSTDcarloAngeloPietroRapporto.pdf

accesso aperto

Tipologia: Documento in Post-print
Licenza: Dominio pubblico
Dimensione 371.75 kB
Formato Adobe PDF
371.75 kB Adobe PDF Visualizza/Apri

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: https://hdl.handle.net/11562/1052856
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus ND
  • ???jsp.display-item.citation.isi??? ND
social impact