Migration of Legacy Mumps Applications to Relational Database Servers

Abstract:

An extended implementation of the Mumps language is described that facilitates vendor neutral migration of legacy Mumps applications to SQL-based relational database servers. Implemented as a compiler, this system translates Mumps programs to operating system independent, standard C code for subsequent compilation to fully stand-alone, binary executables. Added built-in functions and support modules extend the native hierarchical Mumps database with access to industry standard, networked, relational database management servers (RDBMS) thus freeing Mumps applications from dependence upon vendor specific, proprietary, unstandardized database models. Unlike Mumps systems that have added captive, proprietary RDMBS access, the programs generated by this development environment can be used with any RDBMS system that supports common network access protocols. Additional features include a built-in web server interface and the ability to interoperate directly with programs and functions written in other languages.

Keywords:

Mumps - SQL - Patient Records - Relational Database Server

• REFERENCES

• 1 Bowie J, Barnett GO. MUMPS – an economical and efficient time-sharing language for information management. Computer Programs in Biomedicine 1976; 6: 11-21.
• 2 Barnett GO, Greenes RA. High level programming languages. Computers and Biomedical Research 1970; 3: 488-97.
• 3 M Technology Association, M Sources ’94, M Technology Association, 1738 Elton Road, Suite 205, Silver Spring, Maryland 20903, Tel.: [phone], Fax: [phone].
• 4 American National Standards Institute, Inc.. ANSI/MDC X11.4-1995 Information Systems - Programming Languages – M, American National Standards Institute, 11 West 42nd Street, New York, New York 10036 ( http://web.ansi.org/default_js.htm ).
• 5 American National Standards Institute, Inc.,. ANSI/MDC X11.4-1995 : MUMPS - X Window System Binding, American National Standards Institute, 11 West 42nd Street, New York, New York 10036 ( http://web.ansi.org/default_js.htm ).
• 6 American National Standards Institute, Inc.,. ANSI/MDC X11.3-1994 : Graphical Kernel Systems (GKS) - MUMPS Language Binding, American National Standards Institute, 11 West 42nd Street, New York, New York 10036 ( http://web.ansi.org/default_js.htm ).
• 7 Barnett GO. et al. COSTAR – a computer-based medical information system for ambulatory care. Proc of the IEEE. 1979 67 (9).
• 8 Veterans Administration Medical Resources Management Office, DM&S ADP Plan, Fiscal Years 1984-1989, Washington, DC (February 1984); also see: http://www.va.gov/dhcp/cdrom
• 9 Addison-Wesley CJ. An Introduction to Data Base Systems. Reading; Massachusetts: Date 1990
• 10 O’Kane KC, McColligan EE, Davis GA. Implementing a Distributed Intranet Based Information System. Topics in Health Information Management 1996; 17 (Suppl. 02) 54-62.
• 11 O’Kane KC, McColligan EE. A case study of a Mumps intranet patient record. Journal of the Healthcare Information and Management Systems Society 1997; 11 (Suppl. 03) 81-95.
• 12 O’Kane KC, McColligan EE. A Web Based Mumps Virtual Machine, Proceedings of the American Medical Informatics Association 1997 Fall Symposium. Masys DR. ed. Abstract: p 881, Text: CDROM Document D004079.pdf Philadelphia: Hanley & Belfus; 1997
• 13 O’Kane KC, McColligan EE. A Web access script language to support clinical application development. Computer Methods and Programs in Biomedicine 1998; 55: 85-97.
• 14 Sanders R. ODBC 3.5 Developer’s Guide (Warehousing/Data Management). Computing McGraw-Hill; 1998
• 15 The PostgreSQL User’s Guide, 1998-10-01, The PostgreSQL Global Development Group. The University of California; Berkeley, CA: 1998
• 16 O’Kane KC. Design for a relational data base system in MUMPS. MUMPS Users’ Group Quarterly 1985; 15 (Suppl. 02) 33.
• 17 O’Kane KC. An expert systems and relational database management facility for Mumps. Computers in Biology and Medicine 1986; 16 (Suppl. 03) 205-13.
• 18 Free Software Foundation Inc.,. 59 Temple Place Suite 303. Boston, Massachusetts: 02111-1307, USA.
• 19 Knowledge Based Systems, 585 Grove Street Suite 201, Herndon, Virginia 20170, USA ( http://www.kbsystems.com ).
• 20 InterSystems Corporation. One Memorial Drive. Cambridge, MA: 02142, USA ( http://cache.intersys.com/homepage.html ).