Valid Time Database Implementation Using Oracle11g Workspace Manager

Sitti Rugtanom and Suphamit Chittayasothorn


Valid 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.

Full Paper in PDF Document


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: