Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temporal /BiTemporal Data & Reporting

757111May 25 2010 — edited May 27 2010
Its about Temporal Data.

Is there any way we can implement Temporal Data Management (with valid time and transaction time attributes-bitemporal) within Oracle ??

I have just started POC. I am more interested in knowing best storage mechanism (history with row level timestamping or attribute level timestamping).
Retrieval of the temporal data is also a pain to me, we can use analytical functions but in general what are the operations involved in converting temporal data into temporal reporting (what kind of queries usually consumers do on temporal data?), any implementatoin ideas ?

Appreciate your help.

-Dhaval
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2010
Added on May 25 2010
1 comment
883 views