Parsing AQL Queries into SQL Queries using ANTLR

Abstract: An Electronic Health Record is a collection of each patient’s health information which is stored electronically or in digital format. openEHR is an open standard specification for electronic health record data. openEHR has a method for querying a set of clinical data using the Archetype Query Language (AQL).  The EHR data is in XML format and this format is a tree like structure. Since XML databases were considerably slower, AQL needs to be translated to another query language. Researchers have already investigated translating AQL to XQuery and tested the performance. Since the performance was not satisfactory, we now investigate translating AQL to SQL. AQL queries are translated to SQL queries using the ANTLR tool. The translation is implemented in Java language. The AQL queries which are translated into SQL queries are also tested in this thesis work. Finally, the result is to get the corresponding SQL query for any given AQL query.