Re: How Large is a BIG Relational DB

Posted in 1994

Kent S. Gordon — Tue, 8 Mar 1994 15:41:22 GMT — source: Informix-list mailing list archive (1991-1998)

>>>>> "Adam" == Adam Green <adamg@informix.com> writes: In article <adamg.763048040@infmx> adamg@informix.com (Adam Green) writes: >> ddargo@us.oracle.com (Dave Dargo) writes: >>> aevans@kaiwan.com (Alan B. Evans) writes: >>>> (SVR4) using Oracle 7. Oracle 7 has a design limitation in that 1 >>>> instance of Oracle can only handle 256 GB of data. >>> Most definately not correct. More like a design limitation of >>> around 4 Terrabytes. There are production databases in Oracle >>> larger than the 256 GB you mention (including one on a Sun box). >>> Dave (ddargo@us.oracle.com) >> Hi Dave, I kinda figured on someone questioning the old 256 gig >> limitation - I guess you're right; only, Alan was more likely >> talking from experience, no so much on what brand O can address, >> but what the nag can actually handle. Care for a benchtest? >> Still, pretty soon 4 Tbs will be small and the number of installed >> nCUBE 'video jukeboxes' doing mainframe corporate DBMS replacement >> is still pretty thin on the ground. Does any relational database engine other than TeraData allow for multiple cpus and disks to work on a single query/insert/update/delete/load/indexing? I know Oracle 7.1 is supposed to support multiple cpu's id queries (maybe loading and indexing), but I believe it will not use more than one cpu in a insert/update/delete statement. I think Informix 6.x will have similar functionality. I am not sure when Sybase/Ingres/?? will have similar functionality. I am working on a large (300GB - 2TB) combined DSS/OLTP application. I would like to have an alternative to using TeraData (NCR 3600), but have found no other database that will use multiple cpu's well in handling large (10 - 100 million row) insert/update/delete statements. Any Comments, helpful hints, corrections are welcome. -- Kent S. Gordon, American Airlines Decision Technologies email: kgor@aadt.com / All opinions are my own. Telephone:(817)931-2286 (day)/(817)431-8775 (night)/(817)963-2692 (fax) Postal: 76 Corral Drive North, Keller, TX 76248