Re: What Database Best Supports Quick Retrieval Of One Child Table

From: Chester West II <cwest2_at_mindspring.com>
Date: 1997/01/20
Message-ID: <5bukuf$aq@camel5.mindspring.com>#1/1

Not to sound biased or anything, but I personally like Oracle. I think before you make any decisions, you will need to come up with a few more requirements.... For example, what type of scalability is needed? Do you prefer a specific platform for the OS & HW, and how do the commercial RDBMSes rate on it? Do youhave a need for spatial data now or in the future? What languages do your developers know now and how do they compare to the commercial RDBMSes native languages in syntax, capabilities and style? Would you prefer a relational or OO database? ... also, a list of restrictions... for example, The DB server must run on Windows NT or Novell. We can't spend bu $10,000.00. We already have expertise in... and best of all, We need to be able to integrate with...

Chet West
Tactics, Inc. (Oracle BAP)
http://www.tacticsus.com

westes_at_usc.com (Will Estes) wrote:

>I have an application that has a parent record and up to ten million
>child records. I am guaranteed that for this application there will
>never be relational joins against other tables. In theory, which kind
>of database would best support these requirements, and which
>commercial product best instantiates the theory. The requirements
>are:

>- Must be able to very quickly create a new database and copy the one
>parent record and its ten million child records into the new database

>- Must be save against multiple-thread access (dozens of threads might
>be active against the same database at any one time)

>- Must be very fast for random access for read/write operations
>against individual child records

>- Locks on the child records must not lock the parent record or any
>other child (i.e., record-level locks, not page locks)

>Is a relational database the best kind for this sort of access?
>Which commercial database product will support these requirements?

>--
>Will Estes U.S. Computer
>Internet: westes_at_usc.com POB 3150
> Saratoga, CA 95070
> FAX: 408-446-1013
Received on Mon Jan 20 1997 - 00:00:00 CST