home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases
- Path: sparky!uunet!wupost!monsanto.com!bigez!dmmatt
- From: dmmatt@bigez (Mike Mattix)
- Subject: Re: References wanted on Distributed Databases
- Message-ID: <1992Dec16.175436.1@bigez>
- Lines: 38
- Sender: news@tin.monsanto.com (USENET News System)
- Organization: Monsanto Agricultural Company
- References: <1992Dec10.170708.5610@cs.brown.edu> <kitchel.724014868@manta> <1992Dec11.080514.17132@cs.ruu.nl> <1992Dec11.114955.1@bigez> <Dec.15.16.02.57.1992.27495@andromeda.rutgers.edu>
- Date: Wed, 16 Dec 1992 17:54:36 GMT
-
- In article <Dec.15.16.02.57.1992.27495@andromeda.rutgers.edu>, holowcza@andromeda.rutgers.edu (Richard D Holowczak) writes:
- >
- > I think there is a big difference between distributed partitioned data and
- > distributed replicated data. I would be interested to know how Rdb (and
- > others) handle site failures, communication failures and recovery.
- > Any comments?
- >
- >
- >
- > Rich Holowczak
- > Rutgers University
- > holowcza@andromeda.rutgers.edu
-
- Since I brought up Rdb (I just get sick of hearing about the NEW ADVANCED
- features of Oracle/Ingres), I probably should take a stab at this. The
- application we did originally had distributed partitioned data (multiple table of
- different data on different network nodes). The application worked fine we ended
- up consolidating the application on one node for performance reasons. I don't
- believe many people will argue that distributed applications tend to perform worse
- than applications where all the data resides on one node. The failure of a node is
- handled by the two phase commit function during a transaction. The failure of a node
- is handled by error trapping after that, ie the application will not be able to
- attach to the remote node and the remote database. Running VMS and DECNet if an
- alternate path to the database is available the application will be able to resume
- as soon as that path is established. Neither the programmer nor the system/network
- manager will need to do anything.
-
- I am not sure I have covered all you asked (I am not even sure I am qualified),
- however if more detail is needed, just post.
-
- regards,
-
- --
- Mike Mattix
- Agricultural Group of Monsanto
- P.O. Box 174
- Luling, LA 70070
- INTERNET Address: dmmatt@bigez.monsanto.com
-