Valid time database implementation using Oracle11g Workspace Manager

Simple item page
dc.contributor.authorRugtanom, Sitti
dc.contributor.authorChittayasothorn, Suphamit
dc.date.accessioned2026-08-06T10:05:17Z
dc.date.available2026-08-06T10:05:17Z
dc.date.issued2012-12-01
dc.description.abstractValid time database comprises valid time state tables, which keep facts that are currently true, believed to be true in the past, and expected to be true in the future. Temporal queries on these tables are both useful and necessary for many applications. However, the introduction of valid time periods to database tables leads to complex data manipulations especially delete and update operations. Conventional Database Management Systems users have to use standard SQL to handle temporal queries and temporal data manipulations which lead to long and complicated SQL statements. This paper investigates the valid time temporal database features which are available in Oracle11g. We found that the Oracle11g Workspace Manager provides valid time temporal database operations comparable to those appear in temporal database literatures.
dc.identifier.citationWmsci 2012 the 16th World Multi Conference on Systemics Cybernetics and Informatics Proceedings, 1, 172-177, 2012
dc.identifier.other2-s2.0-84875461596
dc.identifier.urihttps://dspace.kmitl.ac.th/handle/123456789/4489
dc.sourceWmsci 2012 the 16th World Multi Conference on Systemics Cybernetics and Informatics Proceedings
dc.subjectOracle11g Workspace Manager
dc.subjectTemporal database
dc.subjectValid time state table
dc.titleValid time database implementation using Oracle11g Workspace Manager
dc.typeConference Paper

Files

Collections

Research