Temporal databases: model design and commercialization prospects

This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In or...

Full description

Saved in:
Bibliographic Details
Published in:ACM SIGMIS Database: the DATABASE for Advances in Information Systems 1994-08, Vol.25 (3), p.6-18
Main Authors: Lai, Vincent S., Kuilboer, Jean-Pierre, Guynes, Jan L.
Format: Article
Language:English
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites cdi_FETCH-LOGICAL-c191t-6f3fc98dbf7db91d1ce272c3460c03f371a6b33188c38cd6b380342c7971d33d3
container_end_page 18
container_issue 3
container_start_page 6
container_title ACM SIGMIS Database: the DATABASE for Advances in Information Systems
container_volume 25
creator Lai, Vincent S.
Kuilboer, Jean-Pierre
Guynes, Jan L.
description This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In order to support time-related queries, the query language SQL has been extended for definition, retrieval, and control of historical relations. For the commercialization of temporal databases, several technical and non-technical issues need to be resolved. This article provides a discussion of these issues and evaluates its progress toward commercialization.
doi_str_mv 10.1145/190675.190676
format article
fullrecord <record><control><sourceid>crossref</sourceid><recordid>TN_cdi_crossref_primary_10_1145_190675_190676</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>10_1145_190675_190676</sourcerecordid><originalsourceid>FETCH-LOGICAL-c191t-6f3fc98dbf7db91d1ce272c3460c03f371a6b33188c38cd6b380342c7971d33d3</originalsourceid><addsrcrecordid>eNotz01LAzEQxvFBFFyrl4J3v0DamcxmkhylqC0UvNTzks0LWFpakl789r6sp99zeuAP8Ei4IOrNkjyKNYs_5Ao6MqwVepZr6BC9UYjMt3DX2h5RWxHTwXyXj-dTDYenFC5hDC23e7gp4dDyw78z-Hh92a3Wavv-tlk9b1UkTxclhUv0Lo3FptFTopi11ZF7wYhc2FKQkZmci-xi-tkOudfRekuJOfEM1PQb66m1mstwrp_HUL8GwuE3aJiCJoS_ASkhO0g</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype></control><display><type>article</type><title>Temporal databases: model design and commercialization prospects</title><source>Association for Computing Machinery:Jisc Collections:ACM OPEN Journals 2023-2025 (reading list)</source><creator>Lai, Vincent S. ; Kuilboer, Jean-Pierre ; Guynes, Jan L.</creator><creatorcontrib>Lai, Vincent S. ; Kuilboer, Jean-Pierre ; Guynes, Jan L.</creatorcontrib><description>This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In order to support time-related queries, the query language SQL has been extended for definition, retrieval, and control of historical relations. For the commercialization of temporal databases, several technical and non-technical issues need to be resolved. This article provides a discussion of these issues and evaluates its progress toward commercialization.</description><identifier>ISSN: 0095-0033</identifier><identifier>EISSN: 1532-0936</identifier><identifier>DOI: 10.1145/190675.190676</identifier><language>eng</language><ispartof>ACM SIGMIS Database: the DATABASE for Advances in Information Systems, 1994-08, Vol.25 (3), p.6-18</ispartof><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><cites>FETCH-LOGICAL-c191t-6f3fc98dbf7db91d1ce272c3460c03f371a6b33188c38cd6b380342c7971d33d3</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>314,777,781,27905,27906</link.rule.ids></links><search><creatorcontrib>Lai, Vincent S.</creatorcontrib><creatorcontrib>Kuilboer, Jean-Pierre</creatorcontrib><creatorcontrib>Guynes, Jan L.</creatorcontrib><title>Temporal databases: model design and commercialization prospects</title><title>ACM SIGMIS Database: the DATABASE for Advances in Information Systems</title><description>This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In order to support time-related queries, the query language SQL has been extended for definition, retrieval, and control of historical relations. For the commercialization of temporal databases, several technical and non-technical issues need to be resolved. This article provides a discussion of these issues and evaluates its progress toward commercialization.</description><issn>0095-0033</issn><issn>1532-0936</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1994</creationdate><recordtype>article</recordtype><recordid>eNotz01LAzEQxvFBFFyrl4J3v0DamcxmkhylqC0UvNTzks0LWFpakl789r6sp99zeuAP8Ei4IOrNkjyKNYs_5Ao6MqwVepZr6BC9UYjMt3DX2h5RWxHTwXyXj-dTDYenFC5hDC23e7gp4dDyw78z-Hh92a3Wavv-tlk9b1UkTxclhUv0Lo3FptFTopi11ZF7wYhc2FKQkZmci-xi-tkOudfRekuJOfEM1PQb66m1mstwrp_HUL8GwuE3aJiCJoS_ASkhO0g</recordid><startdate>19940801</startdate><enddate>19940801</enddate><creator>Lai, Vincent S.</creator><creator>Kuilboer, Jean-Pierre</creator><creator>Guynes, Jan L.</creator><scope>AAYXX</scope><scope>CITATION</scope></search><sort><creationdate>19940801</creationdate><title>Temporal databases</title><author>Lai, Vincent S. ; Kuilboer, Jean-Pierre ; Guynes, Jan L.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c191t-6f3fc98dbf7db91d1ce272c3460c03f371a6b33188c38cd6b380342c7971d33d3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1994</creationdate><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Lai, Vincent S.</creatorcontrib><creatorcontrib>Kuilboer, Jean-Pierre</creatorcontrib><creatorcontrib>Guynes, Jan L.</creatorcontrib><collection>CrossRef</collection><jtitle>ACM SIGMIS Database: the DATABASE for Advances in Information Systems</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Lai, Vincent S.</au><au>Kuilboer, Jean-Pierre</au><au>Guynes, Jan L.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Temporal databases: model design and commercialization prospects</atitle><jtitle>ACM SIGMIS Database: the DATABASE for Advances in Information Systems</jtitle><date>1994-08-01</date><risdate>1994</risdate><volume>25</volume><issue>3</issue><spage>6</spage><epage>18</epage><pages>6-18</pages><issn>0095-0033</issn><eissn>1532-0936</eissn><abstract>This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In order to support time-related queries, the query language SQL has been extended for definition, retrieval, and control of historical relations. For the commercialization of temporal databases, several technical and non-technical issues need to be resolved. This article provides a discussion of these issues and evaluates its progress toward commercialization.</abstract><doi>10.1145/190675.190676</doi><tpages>13</tpages></addata></record>
fulltext fulltext
identifier ISSN: 0095-0033
ispartof ACM SIGMIS Database: the DATABASE for Advances in Information Systems, 1994-08, Vol.25 (3), p.6-18
issn 0095-0033
1532-0936
language eng
recordid cdi_crossref_primary_10_1145_190675_190676
source Association for Computing Machinery:Jisc Collections:ACM OPEN Journals 2023-2025 (reading list)
title Temporal databases: model design and commercialization prospects
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-19T21%3A11%3A12IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-crossref&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Temporal%20databases:%20model%20design%20and%20commercialization%20prospects&rft.jtitle=ACM%20SIGMIS%20Database:%20the%20DATABASE%20for%20Advances%20in%20Information%20Systems&rft.au=Lai,%20Vincent%20S.&rft.date=1994-08-01&rft.volume=25&rft.issue=3&rft.spage=6&rft.epage=18&rft.pages=6-18&rft.issn=0095-0033&rft.eissn=1532-0936&rft_id=info:doi/10.1145/190675.190676&rft_dat=%3Ccrossref%3E10_1145_190675_190676%3C/crossref%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-c191t-6f3fc98dbf7db91d1ce272c3460c03f371a6b33188c38cd6b380342c7971d33d3%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true