Reconstructing database sessions from a query log

Abstract

Some embodiments provide a method for analyzing database queries performed on a database. The method receives a log that includes a set of database queries that were performed on the database. The method identifies, from the log, two or more subsets of queries that are each associated with a different connection session between the database and a set of client applications, where each subset is associated with a set of temporary session objects that are not associated with queries in the other subsets of queries. The method performs a separate query interpretation process on each subset of queries to quantify the impact of performing the queries on the database during the connection sessions, where the query interpretation processes are performed separately in order to avoid errors associated with the temporary objects.

Dependencies are inferred from the claim text.