> From: Nancy Anthracite <[EMAIL PROTECTED]> > Reply-To: [email protected] > Date: Thu, 14 Apr 2005 17:00:12 -0400 > To: [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/hardhats-members
