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 get 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 framework for temporal functional dependencies with multiple granularities
MONTANARI, Angelo;
2011-01-01
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 get 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.File | Dimensione | Formato | |
---|---|---|---|
68490404.pdf
non disponibili
Tipologia:
Documento in Pre-print
Licenza:
Non pubblico
Dimensione
236.93 kB
Formato
Adobe PDF
|
236.93 kB | Adobe PDF | Visualizza/Apri Richiedi una copia |
I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.