Checking and Verifying Temporal Data Validity Using Valid Time Temporal Dimension and Queries in Oracle 12C
Jaypalsinh A. Gohil, Prashant M. Dolia · International Journal of Database Management Systems · 2015
Temporal Database is the most convenient form to represent time element associated with data.Temporal validity support a unique feature of temporal database lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the start and end dates or time stamps of the period for which a given record is considered to be a valid record.This study focuses on checking and verification of temporal data using valid time dimension of temporal database.This study covers the steps for adding a valid time dimension on a table, and various methods for querying the table and retrieving records based on a specified valid time value or range with help of Oracle 12c.