Skip to main content
Article
Ontology Evolution Using Recoverable SQL Logs
Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
  • Awais Yousaf, National University of Computer and Emerging Sciences Islamabad
  • Asad Masood Khattak, Zayed University
  • Kifayat Ullah Khan, National University of Computer and Emerging Sciences Islamabad
Document Type
Conference Proceeding
Publication Date
1-1-2021
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.

ISBN
9783030763510
Publisher
Springer International Publishing
Disciplines
Keywords
  • Bloom filter,
  • DFS,
  • Online transaction processing,
  • Ontology evolution,
  • RecSQL,
  • SQL logs
Scopus ID
85111401679
Indexed in Scopus
Yes
Open Access
No
https://doi.org/10.1007/978-3-030-76352-7_46
Citation Information
Awais Yousaf, Asad Masood Khattak and Kifayat Ullah Khan. "Ontology Evolution Using Recoverable SQL Logs" Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) Vol. 12632 LNCS (2021) p. 509 - 517 ISSN: <a href="https://v2.sherpa.ac.uk/id/publication/issn/0302-9743" target="_blank">0302-9743</a>
Available at: http://works.bepress.com/asad-khattak/95/