Stability constraints and stability normal forms for temporal relational databases

S. Y. Liao; H. Q. Wang; W. Y. Liu

doi:10.1016/S0950-5849(98)00120-7

Author(s)

S. Y. Liao
H. Q. Wang
W. Y. Liu

Related Research Unit(s)

Department of Information Systems

Detail(s)

Original language	English
Pages (from-to)	131-138
Journal / Publication	Information and Software Technology
Volume	41
Issue number	3
Publication status	Published - 25 Feb 1999

Link(s)

DOI	DOI https://doi.org/10.1016/S0950-5849(98)00120-7 Final Published version
	Check@CityULib
Link to Scopus	https://www.scopus.com/record/display.uri?eid=2-s2.0-0348133586&origin=recordpage
Permanent Link	https://scholars.cityu.edu.hk/en/publications/publication(c12efdcb-47f3-4fd1-90fb-e67d3de687ee).html

Abstract

This paper presents a new dynamic dependency and a new normal form. We give the concept of the stability constraint and establish complete axioms for stability constraints. In addition, we propose a stability normal form. A temporal third normal form can be losslessly decomposed into a sequence of stability constraints. Using the decomposition, the storage space can be reduced. The stability constraints allow to fill a suitable value into a null value. Thus, this null value therefore turns into a known value. © 1999 Elsevier Science B.V. All rights reserved.

Research Area(s)

Relational model, Stability constraints, Stability normal form, Temporal database

Citation Format(s)

[ RIS ] [ BibTeX ]

Stability constraints and stability normal forms for temporal relational databases. / Liao, S. Y.; Wang, H. Q.; Liu, W. Y.
In: Information and Software Technology, Vol. 41, No. 3, 25.02.1999, p. 131-138.

Research output: Journal Publications and Reviews › RGC 21 - Publication in refereed journal › peer-review

Liao, SY, Wang, HQ & Liu, WY 1999, 'Stability constraints and stability normal forms for temporal relational databases', Information and Software Technology, vol. 41, no. 3, pp. 131-138. https://doi.org/10.1016/S0950-5849(98)00120-7

Liao, S. Y., Wang, H. Q., & Liu, W. Y. (1999). Stability constraints and stability normal forms for temporal relational databases. Information and Software Technology, 41(3), 131-138. https://doi.org/10.1016/S0950-5849(98)00120-7

Liao SY, Wang HQ, Liu WY. Stability constraints and stability normal forms for temporal relational databases. Information and Software Technology. 1999 Feb 25;41(3):131-138. doi: 10.1016/S0950-5849(98)00120-7

Liao, S. Y. ; Wang, H. Q. ; Liu, W. Y. / Stability constraints and stability normal forms for temporal relational databases. In: Information and Software Technology. 1999 ; Vol. 41, No. 3. pp. 131-138.