Re: Do I Need A DBMS or Data Warehouse??

Christopher J. Wood wrote: > > Hi, > > We are experiencing, what I seem to think, very poor performance. Many possible reasons, proper implementation of keys, machine speed, memory, DBMS tuning ... > We need to do a ot of look-ups and reports. Yes databases are ment to do just this > We don't need to do a lot of inputs, or data/order entry. > > I was thinking that maybe we need to take a data warehouse or DSS > approach. > > I have been told that conventional DBMSes are good at accomodating a lot > of transactions ("getting data into the system"), but not good at > letting information get extracted. Not true a one way pipe does no one any good. > Any opnions here? Fact of the matter many DSS systems are built right on top of an RDBMS we do just that for or CROME product http://www.quantumsi.com/, the point is you can probably always write custom code to max out performance for a given probelm set (3-15X) but you lose flexibility and the possibility to link your data trough a known access interface ESQL , SQL, ODBC and many times that is a lot to give up. Looking at your data in the right way many times can provide fantastic performance - this includes adding keys or indecies using summary or rollup tables to ease the burden of repetitive queries and tuning your hardware/software. - Jon > Thank you! > > Chris