Deriving Application Level Relationships by Analysing the Run Time Behaviour of Simple and Complex SQL Queries

Abstract

This paper describes a unique approach to perform application behavioral analysis for identifying how tables might be related to each other. The analysis techniques are based on the properties of primary and foreign keys and also the data present in their respective columns. We have also implemented the idea using JAVA and presented experimental results in Demo Section.This paper introduces a unique approach to predict the possible application level relationships in databases with the help of the application relationship analysis of simple and complex SQL queries. Complex SQL queries are those which contain multiple constraints at different levels of the database. In the process of deriving relations, we first parse the SQL statements and then analyse the parsed information to extract related information.