• DocumentCode
    3203372
  • 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
  • fYear
    2011
  • fDate
    4-9 July 2011
  • Firstpage
    443
  • Lastpage
    450
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • 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
  • Type

    conf

  • DOI
    10.1109/SERVICES.2011.24
  • Filename
    6012727