home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!sun-barr!ames!lll-winken!iggy.GW.Vitalink.COM!cs.widener.edu!dsinc!cdin-1!icdi10!fr
- From: fr@compu.com (Fred Rump from home)
- Newsgroups: comp.databases
- Subject: Re: C-tree and db-VISTA, any experiances ?
- Message-ID: <1992Sep14.162115.5816@compu.com>
- Date: 14 Sep 92 16:21:15 GMT
- References: <1992Sep11.104758.1@elde1.epfl.ch> <1992Sep12.155601.3823@compu.com> <13SEP199214391683@stars.gsfc.nasa.gov>
- Distribution: usa
- Organization: CompuData Inc.
- Lines: 41
-
- thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040) writes:
-
- >In article <1992Sep12.155601.3823@compu.com>, fr@compu.com (Fred Rump from home) writes...
- >>extremely difficult to do though, mainly because of the rather fixed nature of
- >>network style databases. You just don't willy-nilly rearrange them. These
- >>suckers need to be designed up front and rather carefully.
-
- >That brings up an interesting question. I've lately been looking into a number
- >of SQL databases. As I understand it, Raima claims that for their database,
- >the user can either choose to use or not to use the network capabilities, and
- >that even if you do, the view to the user is always relational.
-
- The view to the user would be carefully laid out via CREATE VIEW statements.
- But in no way is Raima relational by design. You can sort of fake it, but
- that's about it.
-
- >How important is the network structure to Raima Data Manager? They claim it
- >speeds up queries--is it slower than other databases if you don't use it? Does
- >the database look any different to the user than if it were maintained with a
- >purely relational engine?
-
- While I'm not directly writing code in our development effort, I have been
- involved in the design. So, from a non-technical viewpoint, the many to many
- linkage requires intermediary sets. MDBS III/IV was better that way. (Of course
- the smelled as a company) The queries that a network enables are just about
- instant as everything has been pre-indexed by design. Now, if you want
- something different, travel down and up or sort things out as an afterthought,
- you'll probably take a lot longer than a pure relational database which is
- much more open to the user's whim.
-
- The beauty is all the linking between sets that you know you'll need in
- advance. The downside of this is the stuff you need later.
-
- Bottom line then, a well designed custom database using Raima probably has no
- equal as far as speed of access goes. It is also one of the most difficult to
- develop under. Basically for professionals only. The end-user basically sees
- screens and should not be concerned with how the DB looks internally or how it
- is maintained. It should just do it.
-
- fred
-
- --
- W. Fred Rump office: fred@COMPU.COM 'mans feet have grown/so big
- 26 Warren St. home: fred@icdi10.compu.com that he/forgets his littleness'
- Beverly, NJ. 08010 Don Marquis
- 609-386-6846 bang:uunet!cdin-1!icdi10!fr
-