Abstract
Logs of SQL queries are useful for building the system design, upgrading, and checking which SQL queries are running on certain applications. These SQL queries provide us useful information and knowledge about the system operations. The existing works use SQL query logs to find patterns when the underlying data and database schema is not available. For this purpose, a knowledge-base in the form of an ontology is created which is then mined for knowledge extraction. In this paper, we have proposed an approach to create and evolve an ontology from logs of SQL queries. Furthermore, when these SQL queries are transformed into the ontology, they loose their original form/shape i.e., we do not have original SQL queries. Therefore, we have further proposed a strategy to recover these SQL queries in their original form. Experiments on real world datasets demonstrate the effectiveness of the proposed approach.
Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
