Re: Pick to Oracle conversion
Date: 14 Nov 1994 14:18:48 GMT
Message-ID: <3a7rk8$19u_at_ixnews1.ix.netcom.com>
In <784774325snz_at_sambusys.demon.co.uk> psb_at_sambusys.demon.co.uk (Paul Beardsell) writes:
>> Any suggestions on what research would be beneficial for both the
>> initial data warehouse application, and the eventual migration to
Oracle
>> (or some other SQL RDBMS)?
>
>No. What _is_ a data warehouse?
It's a database in which the data is relatively static. It gets updated at some regular interval (monthly in our case) and is separate from the "live" corporate data. It's purpose is to allow end users to run ad-hoc queries against the data at a known point in time, where everything "ties out", without affecting the performance of the live system. (And without having to worry that someone somwhow may figure out a way to corrupt the live data too).
Chuck Received on Mon Nov 14 1994 - 15:18:48 CET