Title :
Minimum Steiner Tree for Automatic SQL Query Generation Applied on a Medical Record Database
Author :
Gillies, Christopher E. ; Patel, Nilesh ; Singh, Gautam B. ; Kruk, Serge G. ; Cheng, Eddie ; Wilson, George
Author_Institution :
Dept. of Comput. Sci. & Eng., Oakland Univ., Rochester, MI, USA
Abstract :
The size and complexity of medical record databases makes extracting information challenging. With the tables numbering in thousands, even database analysts have trouble finding important fields and discovering various associations between tables. This paper presents a case study of our initial method of finding minimum Steiner trees in the Epic Clarity Reporting database to solve this problem. In addition, we present a web service architecture that can be used to extend our approach to multiple databases.
Keywords :
SQL; Web services; medical information systems; query processing; Web service architecture; automatic SQL query generation; electronic health records; epic clarity reporting database; medical record database; minimum Steiner tree; Dictionaries; HTML; Indexes; Relational databases; Steiner trees; Web services; Automatic SQL; Databases; Electronic Heath Records; Steiner Tree;
Conference_Titel :
Services (SERVICES), 2011 IEEE World Congress on
Conference_Location :
Washington, DC
Print_ISBN :
978-1-4577-0879-4
Electronic_ISBN :
978-0-7695-4461-8
DOI :
10.1109/SERVICES.2011.24
