Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: MultiValue Databases

Re: MultiValue Databases

From: Neo <neo55592_at_hotmail.com>
Date: 10 Jun 2005 14:48:17 -0700
Message-ID: <1118440097.433682.125620@g14g2000cwa.googlegroups.com>


> Not all constraints can be enforced in the Database, but the
> fundamental ones are best done there (data types, foreign keys, not null).

Each data model has a scope where it is the most efficient beyond which a more general data model is more efficient. Compared to xrdb, RM is more suitable for applications where things are uniform thus allowing stricter constriants at db level. xrdb is suitable for applications where things are highly variable thus constraints have to be more lenient and application specific. For instance, xrdb can handle applications where each thing has different attributes and each attribute has 0 to many values, without incurring NULLs or having to split tables. Constraints and flexibility are mutually opposing characteristics. Received on Fri Jun 10 2005 - 16:48:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US