Valid Time Database Implementation Using Oracle11g Workspace Manager

Sitti Rugtanom and Suphamit Chittayasothorn

ABSTRACT

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: