I do not know of any national mapping of Fileman fields to SQL that is available via FOIA. All the mapping tools mentioned are proprietary and thus not available via FOIA. Whatever tool one selects, I would ask that vendor do they have something already developed that makes doing the mapping easier.
It is erroneous to think that the DD structure for VistA is relatively static. I would not say it is a moving target. But every month there are several patches released that either add or update or delete DD elements. So any SQL mapper would be labor intensive and require constant update assuming you mapped all of VistA. If you only mapped a specific set of files, then the upkeep would be much less. But given the heavy use of pointers in the DDs, if you wanted to map just Lab, I would expect that once you are through you would have mapped nearly all of VistA in order to have all pointers resolved. I have seen demonstrations of Cache's SQL mapper at ITC. Cache was able to do a SQL query on a 440,000 patient file using 3 fields as filters in less time than I could with a M FOR loop. They probably had a very high end machine they were running on. But they got results out in less than 2 seconds. ----- Original Message ----- From: "K.S. Bhaskar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 19, 2004 5:09 PM Subject: Re: [Hardhats-members] SQLI On Thu, 2004-08-19 at 16:33, steven mcphelan wrote: > If you are running Vista on Cache, you have a SQL manager built into > Cache. As stated though, you need to mapped the VistA FM file > structure. Steve, so a separate mapping from Fileman fields to M globals is required no matter what M implementation is used? If so, is this mapping available (e.g., is it available under FOIA)? In theory, once the mapping is defined, there would be a one time effort to convert the mapping to each SQL engine, following which there would only be a need to update it whenever the mapping changes (which hopefully is not very common, since one would expect the VistA schema to be reasonably static). Thanx in advance for your insight. Regards -- Bhaskar *************************************************************************** This electronic mail transmission contains confidential and/or privileged information intended only for the person(s) named. Any use, distribution, copying or disclosure by another person is strictly prohibited. *************************************************************************** NOTE: Ce courriel est destine exclusivement au(x) destinataire(s) mentionne(s) ci-dessus et peut contenir de l'information privilegiee, confidentielle et/ou dispensee de divulgation aux termes des lois applicables. Si vous avez recu ce message par erreur, ou s'il ne vous est pas destine, veuillez le mentionner immediatement a l'expediteur et effacer ce courriel. ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Hardhats-members mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Hardhats-members mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hardhats-members
