Re: References

Gordon Hooker wrote: >On 1 Nov 1995 dlittl01@interserv.com wrote: > >> We're considering using Informix (which product isn't decided yet) for a large data warehouse (100-500Gb) with a large number of >> users (100-500). We saw our first presentation yesterday by informix and was quite impressed. It surly looks like they've covered a >> lot of ground with the new architecture and offer considerable function. > >For loads from your transactional databases be sure to use a very high >isolation level, as a default Informix does not support a read consistent >view of the data. [SNIP] >I would suggest a bench mark, but be sure to insist on read consistency >from all vendors... Hmmmm, an interesting pair of observations... As far as I know, Orable are the *only* DB vendor selling "read consistency", which, IMHO, is a rather inferior way of addressing concurrency. Without any real idea of the value of the data, and indeed data warehousing, I'm equally unaware of the value of concurrency control when loading data into a new database that no-one else is using.... -- Cheers, Billy ----------------------------------------------------------------------------- INCLUDE "Disclaimer.4gh" -- my opinions are INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts! INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk INCLUDE "ThirtySomething.4gh" -- header file for this class -- Written by : Billy Wheeler, Date: today -- Copyright (c) 1995, The West Solutions Group