Re: Temporal Databases

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: niall.litchfield@xxxxxxxxx
  • Date: Thu, 6 Nov 2008 15:52:28 -0600

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
>

Other related posts: