Of course, when you really get down to basics, it's all B-trees, whether you're talking about MUMPS or your favorite RDBMS.
--- "Richard G. DAVIS" <[EMAIL PROTECTED]> wrote: > > > > From: Nancy Anthracite <[EMAIL PROTECTED]> > > Reply-To: hardhats-members@lists.sourceforge.net > > Date: Thu, 14 Apr 2005 17:00:12 -0400 > > To: hardhats-members@lists.sourceforge.net > > Subject: Re: [Hardhats-members] BIG NEWS re HealtheVet- St. > Petersburg Tim es > > > > My understanding is that they are going to be using a relational > database that > > Cache supposedly has in it ?? > > The CORE data system in Caché is the familiar "global" system > descended from > MUMPS. > > Caché exposes this core data storage system in several different > ways. The > procedure being executed can select the method of exposing data. One > of > these ways is an SQL compliant system. > > This 'layering' of a method of access over some other specific data > storage > system is not unusual. If you peel away the method of exposing data > in > Oracle, "look under the hood", you will likely find that there too > the data > storage system is not intrinsically "SQL", or "relational". > > Caché offers the choice of access method that can be exercised > according to > the needs of each specific situation. > > In Caché an application can access the data storage system as a > though it is > a relational database or directly as global structures. The tradeoff > is > between speedy, powerful accesses or more general, slower accesses. > > Caché is unusual in the database world in that it offers the user the > choice > of high level SQL based access methods and at the same time, also > offer > direct access to the underlying data storage system. Other > "relational" > systems are "closed" to access methods that are more direct, a > shortcoming > many don't really recognize as such. > > > for now and ultimately the idea is that it > > should work with any relational database such as MySQL, etc. Note > that I > > stated that it was an Oracle LIKE database. (Steve pointed out > that this > > might not be the best choice of words. Oracle, the 1000 lb. > gorilla, is > > something many people will have heard about and thus will recognize > when > > relation database may mean nothing to them, which is why I chose > the simile.) > > I persist in doubting that the speed of a relational database based > system > > can match that of an M based system no matter who supplies it. In > fact, I > > wonder what the underlying code for the Cache database is written > in. Could > > it be an M based database with restrictions on how it can be > populated? > > Oracle, from what I have heard, will be the basis of the national > data > > repository. I could be all wet about any or all of this, however. > I am just > > piecing together things I have heard at meetings or read in the > press, etc. > > > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real > users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_ide95&alloc_id396&op=click > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members > A practical man is a man who practices the errors of his forefathers. --Benjamin Disraeli ==== Greg Woodhouse [EMAIL PROTECTED] [EMAIL PROTECTED] ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members