This Article 
 Bibliographic References 
 Add to: 
Incremental Implementation Model for Relational Databases with Transaction Time
December 1991 (vol. 3 no. 4)
pp. 461-473

An implementation model for the standard relational data model extended with transaction time is presented. The implementation model integrates techniques of view materialization, differential computation, and deferred update into a coherent whole. It is capable of storing any view (reflecting past or present states) and subsequently using stored views as outsets for incremental and decremental computations of requested views, making it more flexible than previously proposed partitioned storage models. The working and the expressiveness of the model are demonstrated by sample queries that show how historical data are retrieved.

[1] R. Agrawal, "Alpha: An Extension of Relational Algebra to Express a Class of Recursive Queries,"Proc. Third Int'l Conf. Data Eng., CS Press, Los Alamitos, Calif., Order No. FN762, 1987, pp. 580-590.
[2] M. E. Adiba and B. G. Lindsay, "Database snapshots," inProc. Sixth Int. Conf. very Large Databases, 1980, pp. 86-91.
[3] A. Bolour, T. L. Anderson, L. J. Dekeyser, and H. K. T. Wong, "The role of time in information processing: A survey,"ACM SIGMOD Rec., vol. 12, no. 3, pp. 27-50, Apr. 1982.
[4] J. A. Blakely, N. Coburn, and P. A. Larson, "Updated derived relations: detecting irrelevant and autonomously computable updates,"ACM Trans. Database Syst., vol. 14, pp. 369-400, 1989.
[5] J. Blakeley, P. Larson, and F. Tompa, "Efficiently updating materialized views," inProc. ACM-SIGMOD Int. Conf Management of Data, Washington, May 28-30, 1986.
[6] S. Cammarata, "Deferring updates in a relational data base system," inProc. Seventh Int. Conf. Very Large Databases, 1981, pp. 286-292.
[7] E. F. Codd, "Extending the relational database model to capture more meaning,"ACM Trans. Database Syst., vol. 4, no. 4, pp. 397-434, Dec. 1979.
[8] J. Clifford and A. V. Tansel, "On an algebra for historical relational databases: Two views," inProc. ACM SIGMOD, 1985, pp. 247- 265.
[9] C. J. Date,An Introduction to Database Systems--Vol. II, The Systems Programming Series, first, corrected edition. Reading, MA: Addison-Wesley, July 1985.
[10] C. J. Date,An Introduction to Database Systems, vols. 1 and 2. Reading, MA: Addison-Wesley, vol. 1, 1981, vol. 2, 1983.
[11] U. Dayal and P. A. Bernstein, "On the updatability of relational views," inProc Fourth Int. Conf. Very Large Data Bases, 1978, pp. 368-377.
[12] P. Dadam, V. Lum, and H.-D. Werner, "Integration of time versions into a relational database system,"Proc. 10th Int. Conf. Very Large Databases, 1984, pp. 509-522.
[13] K. S. Gadia, "A homogeneous relational model and query languages for temporal databases,"ACM Trans. Database Syst., vol. 13, no. 4, pp. 418-448, Dec. 1988.
[14] N. Gehani, "Databases and unit of measure,"IEEE Trans. Software Eng., vol. SE-8, no. 6, pp. 605-611, Nov. 1982.
[15] S. K. Gadia and C.-S. Yeung, "A generalized model for a relational temporal database," inProc. ACM SIGMOD '88, 1988, pp. 251-259.
[16] E. Hanson, "A performance analysis of view materialization strategies,"ACM-SIGMOD Int. Conf. Management of Data, San Francisco, CA, May 28-30, 1987.
[17] P. Hall, J. Owlett, and S. J. P. Todd, "Relations and entities," inModelling in Data Base Management Systems, G. M. Nijssen, Ed. Amsterdam, The Netherlands, North-Holland, 1976, pp. 201-220.
[18] C.S. Jensen and L. Mark, "A framework for vacuuming temporal databases," Tech. Rep. CS-TR-2516, UMIACS-TR-90-105, Dep. Comput. Sci., Univ. of Maryland, College Park, MD 20742, Aug. 1990. Submitted for publication.
[19] K. A. Kimball, "The data system," M.S. thesis. Univ. of Pennsylvania, 1978.
[20] M. Karr and D.B. Loveman III, "Incorporation of Units into Programming Languages,"Comm. ACM, May, 1978, pp. 385-391.
[21] A. Klug, "Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions,"J. ACM, Vol. 29, No. 3, July 1982, pp. 699-717.
[22] V. Lum, R. Dadam, R. Erbe, J. Guenauer, P. Pistor, G. Walch, H. Werner, and J. Woodfill, "Designing DBMS support for the temporal dimension," inProc. ACM SIGMOD '84, June 1984, pp. 115-130.
[23] M. V. Mannino, P. C. Chu, and T. Sager, "Statistical profile estimation in database systems,"ACM Comput. Surveys, vol. 20, no. 3, pp. 191-221, Sept. 1988.
[24] L.E. McKenzie, "An algebraic language for query and update of temporal databases," Ph.D. dissertation, 88-050, Univ. of North Carolina at Chapel Hill, Dep. Comput. Sci., CB 3175, Sitterson Hall, Chapel Hill, NC 27599-3175, Oct. 19880.
[25] E. McKenzie and R. Snodgrass, "An evaluation of algebras incorporating time," Tech. Rep. TR-89-22, Dep. Comput. Sci., Univ. of Arizona, Tucson, AZ 85721, Sept. 1989. Conditionally accepted forACM Comput. Surveys.
[26] A. B. O'Hare and A. P. Sheth, "The interpreted-compiled range of AI/DB systems,"ACM SIGMOD Rec., vol. 18, no. 1, pp. 32-42, Mar. 1989.
[27] N. Roussopoulos and H. Kang, "Principles and techniques in the design of ADMS±,"computer, vol. 19, no. 12, Dec. 1986.
[28] N. Roussopoulos, "The logical access path schema of a database,"IEEE Trans. Software Eng., vol. 8, no. 6, pp. 563-573, Nov. 1982
[29] N. Roussopoulos, "View indexing in relational databases,"ACM Trans. Database Syst., vol. 7, no. 2, June 1982.
[30] N. Roussopoulos, "The incremental access method of view cache: Concept, algorithms, and cost analysis," Tech. Rep. UMIACS-TR-89-15, CS-TR- 2193, Dep. Comput. Sci., Univ. of Maryland, College Park, MD 20742, Feb. 1989.
[31] D. Rotem and A. Segev, "Physical organization of temporal data," inProc. Third Int. Conf. Data Eng., Feb. 1987, pp. 547-553.
[32] R. Snodgrass and I. Ahn, "A taxonomy of time in databases," inProc. ACM SIGMOD '85, 1985, pp. 236-246.
[33] R. Snodgrass and I. Ahn, "Partitioned storage for temporal databases,"Inform. Syst., vol. 13, no. 4, pp. 369-391, 1988.
[34] P. Selinger,et al., "Access path selection in a relational data base system," inProc. 1979 ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, June 1979.
[35] A. Shoshani and K. Kawagoe, "Temporal data management," inProc. VLDB, Kyoto, Japan, 1986, pp. 79-88.
[36] B. J. Salzberg and D. Lomet, "Access methods for multiversion data," inProc. ACM SIGMOD '89, June 1989, pp. 315-324.
[37] R. Snodgrass, "The temporal query language TQuel,"ACM Trans. Database Syst., vol. 12, no. 2, June 1987.
[38] R. B. Stam and R. Snodgrass, "A bibliography on temporal databases,"Data Eng., vol. 7, no. 4, pp. 53-61, Dec. 1988.
[39] F. W. Tompa and J. A. Blakeley, "Maintaining materialized views without accessing base data,"Inform. Syst., vol. 13, no. 4, pp. 393-406, 1988.
[40] J. D. Ullman,Principles of Databases Systems. Rockville, MD: Computer Science Press, 1982.

Index Terms:
incremental computations; data retrieval; relational databases; transaction time; relational data model; view materialization; differential computation; deferred update; stored views; decremental computations; partitioned storage models; queries; historical data; database theory; relational databases
C.S. Jensen, L. Mark, N. Roussopoulos, "Incremental Implementation Model for Relational Databases with Transaction Time," IEEE Transactions on Knowledge and Data Engineering, vol. 3, no. 4, pp. 461-473, Dec. 1991, doi:10.1109/69.109107
Usage of this product signifies your acceptance of the Terms of Use.