From: paulwo@informix.com (Paul Wolmering)
Newsgroups: comp.databases
Subject: Re: Date's 12 Rules for DISTRIBUTED databases
Date: 28 Sep 92 10:36:11 GMT
Organization: Informix Software, Inc.
Originator: paulwo@cheetah


hi,

 since informix was mentioned but not scored...

bye,
paul

-------------------------------------------------------------------------
In article <v+0nj8=.tcox@netcom.com> you write:
>In article <a#4nvr=.tcox@netcom.com> tcox@netcom.com (Thomas Cox) writes:
>
>>  The most functionally complete distributed RDBMS today (to the best of
>>my knowledge) is INGRES.
>
>I wanted to expand on this and wasn't able to immediately.  Since I've
>gotten a flurry of confused e-mail on it, here is a fuller treatment of
>the issue.
>
>The topic had been commercial products, so I spoke only of commercial
>products -- Ingres 6.4, Informix 5.0, Sybase 4.x, and the like,
>including Oracle 6.0 and 6.2.  If one allows non-commercial software to
>be considered, the unquestioned winner must be Oracle v7.  (Some of you
>wondered if I thought otherwise.  Hardly.)
>
>The classic rule of thumb evaluation of a distributed relational
>database was offered by C.J. Date in his "12 Rules for Distributed
>Database", a follow-on to Codd's earlier 12 rules for relational.
>
>Here is a re-posting of Date's 12 Rules, and my own evaluations as to
>how Ingres and Oracle stack up.  
>
>The quick score:  	Oracle 6, 6.0 rules (8 if you're generous)
>			Ingres,   6.5 rules (7 if you're generous)
>			Oracle7, 10.0 rules (10.5 if you're generous)
			Informix  9.0
			Informix 10.0 (if you apply a transaction monitor
				       for rule #12)
>
>
>		DATE's 12 Rules for Distributed Databases
>
>
>Rule 0: A distributed database should look no different than a database
>that is not distributed.
>
>	v6 PARTIAL ('yes', but read-only)
>	v7 YES
>	Ingres YES
	Informix: Rule 0????
>
>The implication here is that the *users* of the database, either people or
>applications, should be shielded from the fact of the database being
>distributed.  (Those databases that must hard-code data locations into
>triggers, i.e. Sybase, cannot truly be said to comply with this rule.  Note
>that Oracle v7 triggers avoid this error.)
>
>
>Rule 1: Local Autonomy; Local data is owned and managed locally
>with local accountability and security.  Local operations remain local and no
>site should depend on another for successful functioning.
>
>	v6 YES
>	v7 YES
>	Ingres NO
	Informix YES
>
>
>Rule 2: No Reliance on a Central Site; All sites must be treated as
>equals, with no reliance on a master site.
>
>	v6 YES
>	v7 YES	
>	Ingres NO
	Informix YES
>
>Note that this Rule is not a reference to a two-phase commit coordinator, but
>rather to the idea of a SINGLE central "daddy" machine.  Ingres*Star, for
>example, requires that one site be the "daddy" site that maintains a master
>list of all database objects and resources.  Thus, Ingres' latest product fails
>Rule 2; ORACLE versions 5, 6, and 7 all pass Rule 2.
>
>
>Rule 3: Continuous Operation; There should never be any need for a
>planned shutdown, so that installations at one site should not affect
>operations at another.  New installations should not affect existing
>programs, nor should removing a node from service cause interruptions in
>service.  Portions of databases should be able to be created and
>destroyed without stopping any component.
>
>	v6 YES
>	v7 YES	
>	Ingres PROBABLY YES
	Informix YES
>
>This is a reference to several features, such as site autonomy and the ability
>to activate or de-activate a node without having to take some central "daddy"
>database offline to be modified.  Any node can create or modify its own
>resources and need neither (A) register this with any central authority such as
>a central data dictionary, nor (B) shut down other nodes.
>
>
>Rule 4: Location Independence; Users should not have to know where data
>is physically stored and should be able to act as if all data were
>stored locally.
>
>	v6 PARTIAL (i.e. only if the read-only limitation is acceptable)
>	v7 YES
>	Ingres Yes in theory; NO in practice
	Informix YES
>
>Most commercial Ingres sites seem to have hard coded data locations into
>their applications, to avoid the network delays that Ingres' Master-
>Slave architecture forces.
>
>
>Rule 5: Fragmentation Independence; Relations between data elements
>should be able to be fragmented for physical storage.  Nonetheless,
>users should be able to act as if data were not fragmented.
>
>	v6 NO
>	v7 NO
>	Ingres PROBABLY NO
	Informix NO
>
>
>Rule 6: Replication Independence; Relations and fragments should be able
>to be represented at the physical level by multiple, distinct, stored
>copies or replicas at distinct sites, transparent to the user.
>
>	v6 NO
>	v7 PARTIAL
>	Ingres NO
	Informix NO
>
>(The V7 snapshot facility provides a partial solotion.  It allows for
>multiple read-only copies of a master table which are updated at a user defined
>interval.  Also V7 triggers and 2PC provide a partial synchronous replication
>facility.  The problem here is that you have to code your own in
>triggers, which is less elegant.)
>
>
>Rule 7: Local processing and input/output activity needs to take place
>at multiple sites, with some amount of data communications between them.
>Both local and global optimization of query processing should occur.
>
>	v6 PARTIAL
>	v7 PARTIAL (better)
>	Ingres PROBABLY YES
	Informix YES
>
>V6 does some query optimization.  V7's optimizer does a better job optimizing
>distributed queries.
>
>
>Rule 8: Distributed Transaction Management; Single transactions
>execute code at multiple sites, causing updates at multiple sites.
>
>	v6 NO
>	v7 YES	
>	Ingres YES
	Informix YES
>
>This covers the Transparent Two Phase Commit, the RPCs that are protected by
>2PC, Triggers and Stored Procedures that can have effects across sites.
>
>
>Rule 9: Hardware Independence; Distributed databases should be able to
>run on different kinds of hardware, with all machines participating as
>equal partners where appropriate.
>
>	v6 YES
>	v7 YES	
>	Ingres NO
	Informix YES
>
>Ingres does not allow equal partnership.  
>
>
>Rule 10: Operating System Independence; Distributed databases should be
>able to run under different kinds of operating systems.
>
>	v6 YES
>	v7 YES	
>	Ingres SOMEWHAT
	Informix YES
>
>Ingres Star was confined to VMS; it may have made it to some Unix
>platforms by now.
>
>
>Rule 11: Network Independence; Distributed databases should be able to
>work with different kinds of communications networks.
>
>	v6 YES
>	v7 YES	
>	Ingres PROBABLY YES
	Informix YES
>
>
>Rule 12: Database Independence; Distributed databases should be able to
>work with different kinds of databases, providing they have the same
>interfaces.
>
>	v6 PARTIAL read-only and using SQL*Connect
>	v7 YES	Foreign databases can be included in 2PC.
>	Ingres AT LEAST SOMEWHAT
	Informix NO
	Informix YES ( if you use a transaction monitor )
>
>Specifically, a 2PC coordinated by an ORACLE database can include one foreign
>database.  A 2PC coordinated by a Transaction Processing Monitor (TP Monitor)
>can include any number of foreign databases.
>
>
>   You should be able to win free drinks with a simple bar room bet:  ask
>   someone how many rules there are in Date's 12 Rules.  (There are 13 Rules,
>   numbered 0 through 12.)
>-- 
>Tom Cox      DoD #1776   '91 CB 750 Nighthawk   tcox@netcom.netcom.com
> This note is my exercise of my First Amendment right to make a fool of
> myself in public.  I do not speak for anyone but myself.  Ever.
Newsgroups: comp.databases