Niall, I think that temporal data is a data warehousing concept, not related to any particular database brand, although a sales person might make an argument that their database handled it better than the competitors. http://timecenter.cs.aau.dk/TimeCenterPublications/TR-28.pdf Any advantage would probably be somewhere in the analytic features rather than in the administration features. Dennis On Thu, Nov 6, 2008 at 2:54 PM, Niall Litchfield <niall.litchfield@xxxxxxxxx > wrote: > Thanks, though I must admit the particular examples you give seem to appear > in OLTP databases all the time. :) > > On Thu, Nov 6, 2008 at 5:33 PM, Pratap Singh -X (prsingh1 - Abacus at > Cisco) <prsingh1@xxxxxxxxx> wrote: > >> Temporal databases are time enabled databases. This does have overlap to >> Oracle flashback query but it is mostly used in data warehouse reference >> where database has columns like effective_start_date, effective_end_date so >> that snapshot as of certain point in time can be constructed. >> >> Thanks, >> >> PB Singh >> Tech Project Manager >> Ph: 408 424 2777 >> Email: prsingh1@xxxxxxxxx >> >> >> ------------------------------ >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Niall Litchfield >> *Sent:* Thursday, November 06, 2008 2:15 AM >> *To:* ORACLE-L >> *Subject:* Temporal Databases >> >> Nope, not a Star Trek - Voyager reference though it sounds like one, >> but something that our CEO was asked about by a customer. I have to confess >> to never having heard the term. Other than FlashBack Query/Data Archive has >> anyone any experience/understanding of this term as it relates to Oracle? >> >> -- >> Niall Litchfield >> Oracle DBA >> http://www.orawin.info >> > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info >