Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Entity-Attribute-Value
Message
From
28/12/2006 15:08:18
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01179283
Message ID:
01180742
Views:
13
>Hi, Anton.
>
>>Thank you all!
>>Finally I start thinking about moving to InterSystems Cache. Do you have any meaning about that DBMS?
>
>I never heard of it before. It sounds interestig, although I'd be quite scheptic until trying it. Reading a bit their documentatin, sounds like a relational engine with some sort of ORM integrated on top. Sincerely, I wouldn't bet a lot of money in it, but if you find something really cool, I'd love to be proved wrong!
>
>Best regards,

AFAIK no. They use 30-year old MUMPS (http://en.wikipedia.org/wiki/MUMPS) data storage engine which store data as a some kind of multidimensional arrays of "globals|. Each global node is a structure that contains a list of attributes. Very close to EAV isn't it?
So the same data could be interpreted (or "projected") as a relational tables for SQL access, objects for OOP or multidimensional structures for direct access.

I'll continue investigating but only one thing that there is no more need to "press" structural data into flat tables sounds like a sweet dream.
/A new technology turns into completely outdated stuff before you have a time to read "Getting Started..." section.
/If there are some "system programmers" then others are unsystematic.
Previous
Reply
Map
View

Click here to load this message in the networking platform