Re: Large DB questions

In article <3206B153.7581@keanefed.com>, Ken K <kkachnow@keanefed.com> writes >Hi: > >I am working on the initial design for a project that will be >building a very large (at least, in my opinion) database. We hope to >store between 4.5 and 5 billion records. The records will be added at >a rate of 1 to 2.5 million records per day. The data stored will be >under 1K in size, but will involve a couple of 1 to many detail tables. >We will have a couple hundred users accessing the data during the day. > >Does anyone have any experience with databases of this size? > Informix does - talk to their sales people. >Is this something that can be handled with a relational database such >as Informix? > Yes - when I was on my Tuning course on of the Informix in-house guys was on the course (Yes new Informix people take their training courses). He mentioned a new installation with 365 disks!! >What kind of response times could we expect? > Hard to say, I've never worked on a database of that size. >We have not picked any hardware either so any input on what has worked >or not worked for others would be greatly appreciated. > > Talk to Informix and mention Informix 8.1 XPS (eXtended Parallel Server). This runs on MPP (Massively Parallel Processing) machine. According to Informix's Web Site it will be available on " Hitachi Ltd., IBM Corporation, ICL, Inc. and NCR hardware platforms later this month". 10 July 1996. >Thanks, > >Ken No problemo - I'd be interested to here how it goes and which platform you deceide upon. -- David Williams