Dynamic Metadata based Query Formulation for Multiple Heterogeneous Database Systems

Abstract

A method may comprise receiving a template query and one or more keywords from a user, generating a SQL query specification based on the template query and the one or more keywords, formulating SQL code based on metadata specification, sending the SQL code to a query execution engine, receiving correlated query results from multiple physical databases and providing the query result to the user.

1 . A method comprising:
 receiving a template query and one or more keywords from a user;   generating a SQL query specification based on the template query and the one or more keywords;   formulating SQL code based on the SQL query specification;   sending the SQL code to a query execution engine;   receiving a query result; and   providing the query result to the user.   
   
   
       2 . The method of  claim 1 , wherein the generating comprises:
 receiving data from a configuration repository, the data associated with the template query and the one or more keywords, wherein the configuration repository comprises a plurality of tables and each table comprises metadata associated with one or more databases; and   wherein the formulating comprises formulating one or more select statements, one or more join statements, and one or more where statements based on the received data.   
   
   
       3 . The method of  claim 1 , wherein the SQL code joins two or more tables. 
   
   
       4 . The method of  claim 1 , wherein the SQL code joins a first table from a first database and a second table from a second database. 
   
   
       5 . The method of  claim 1 , further comprising:
 receiving a query modification from the user; and   providing a second query result to the user.   
   
   
       6 . The method of  claim 5 , wherein the query modification comprises an instruction to sort by, order by, or specify criteria. 
   
   
       7 . The method of  claim 1 , wherein the SQL query specification is written in XML. 
   
   
       8 . An apparatus comprising:
 a processor; and   a computer readable medium storing instructions that when executed by the processor cause the apparatus to perform a method, the method comprising:   receiving a template query and one or more keywords from a user;   generating a SQL query specification based on the template query and the one or more keywords;   formulating SQL code based on the SQL query specification;   sending the SQL code to a query execution engine;   receiving a query result; and   providing the query result to the user.   
   
   
       9 . The apparatus of  claim 8 , wherein the generating comprises:
 receiving data from a configuration repository, the data associated with the template query and the one or more keywords, wherein the configuration repository comprises a plurality of tables and each table comprises metadata associated with one or more databases; and   wherein the formulating comprises formulating one or more select statements, one or more join statements, and one or more where statements based on the received data.   
   
   
       10 . The apparatus of  claim 8 , wherein the SQL code joins two or more tables. 
   
   
       11 . The apparatus of  claim 8 , wherein the SQL code joins a first table from a first database and a second table from a second database. 
   
   
       12 . The apparatus of  claim 8 , further comprising instruction to:
 receive query modification from the user; and   provide a second query result to the user.   
   
   
       13 . The apparatus of  claim 12 , wherein the query modification comprises an instruction to sort by, order by, or specify criteria. 
   
   
       14 . The apparatus of  claim 8 , further comprising:
 a database comprising configuration repository, wherein the configuration repository comprises a plurality of tables, each table comprising metadata associated with one or more databases.   
   
   
       15 . The apparatus of  claim 8 , wherein the SQL query specification is written in XML.