State of data over the time

From: Patrick J. <patrickj_at_kneipN-O-S-P-A-M.com>
Date: Thu, 6 Sep 2001 11:44:06 +0200
Message-ID: <3b974576$1_2@news.vo.lu>

Hi,

We are currently analyzing an application that will be based on an Oracle database. This database will contain about 40 tables, with many foreign keys between all these tables.
An important requirement for this application is that it must be able to show the data as it was at any given date and time in the past, this concerning every data in the database, and therefore also the links between the data. The implementation of this functionality should not compromise the integrity of the database (most important point), nor result in too bad performances of the application.
I am looking for the better way to fulfill this requirement, in terms of organization of data at the database level. Could you please give me some advices, based on your own experience?

Thanks,

Patrick J. Received on Thu Sep 06 2001 - 04:44:06 CDT