Actually, the VA hospitals that have converted to Cache, have SQL access to their data. They also have object access to their data. Many of the VA hospital personel have had training on how to use Cache to access the data using objects and SQL with the result that some are familiar with objects and SQL and like it, while others want to stick to the old technology they are familiar with (Mumps).
The real problem is that there is so much FUD coming from the RDBMS world in particularly the big O, that the management (these are the only people who run with FUD, because they don't know) run scared. The biggest problem with technology is that management does not understand it, so they are influenced by big money companies more than by their own technical staff. Admittedly that doesn't say much for their intellegence, but money makes the world go round. My mix of knowledge and opinion. Bob On Sat, 2005-04-16 at 15:04, Dr Molly Cheah wrote: > This is what I found from this web-site. > > > http://www.virec.research.med.va.gov/DataSourcesName/VISTA/VISTAaccess.htm#SQL > > > > > SQL > > > > > > <http://www.virec.research.med.va.gov/DataSourcesName/VISTA/VISTAaccess.htm#Top> > > > > > > > > Investigators planning to construct a relational database of VistA > > data will find that few sites offer direct access to VistA data using > > SQL (Structured Query Language). Instead, data are most often exported > > from VistA with an M or MUMPS ( Massachusetts General Hospital Utility > > Multi-Programming System) program and then mapped to a relational > > database . > > > > Commercially available software applications like MUMPS Data Extractor > > (MDE) and KB SQL allow direct SQL access to MUMPS data. Another > > M-based SQL mapping system is built into VistA's Cache. A few sites > > have the necessary software for direct M-to-SQL access but several > > more tried and abandoned it. They found it was too expensive and/or > > put too much strain on the operation of the local VistA system. > > > > The VA FileMan application SQL Interface (SQLI) was an attempt to > > provide the data dictionary information needed to map VA FileMan files > > to a relational database. SQLI is not able to provide access to VA > > FileMan data on its own. Instead, it provides information about VA > > FileMan's internal data dictionary to an M-to-SQL application like KB > > SQL or MDE. Since the available M-to-SQL products can map VA FileMan > > data without help from SQLI, SQLI has not been heavily used. > > > Molly > > Cameron Schlehuber wrote: > > >VistA uses the Data Extracts package to collect and pass out data > >specifically for the purposes of management decisions support for budget > >analysis, projection, business changes for better use of resources etc. The > >tool used for the analysis is a COTS product ($$$$$). > > > >-----Original Message----- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of Eriam > >Schaffter > >Sent: Wednesday, April 13, 2005 9:21 AM > >To: hardhats-members@lists.sourceforge.net > >Subject: [Hardhats-members] Hospital Cost analysis > > > >Hello all this is Eriam Schaffter > > > >I'm in europe and i'm working on a cost analysis software for hospitals. > > > >Is there such a module in OpenVista ? > > > >If not i would investigate the need for integration of OpenVista with > >the software i'm working on, could you tell me if there would be an > >interest for such a solution (a light business intelligence tool) in the > >world of OpenVista. > > > >For integration techniques i'll have to go into the code but is there > >any way to fetch datas from Openvista with sql queries ? > > > >Thanks > > > >Eriam Schaffter > > > > > > > > > >------------------------------------------------------- > >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 > > > > > > > >------------------------------------------------------- > >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Ãk > >_______________________________________________ > >Hardhats-members mailing list > >Hardhats-members@lists.sourceforge.net > >https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > > > > > > > > > > ------------------------------------------------------- > 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 ------------------------------------------------------- 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
