Database and Code Analysis - Downloads
The following projects have been developed in cooperation with the
Lehrstuhl für Informatik I
at the university of Würzburg:
Squash (Sql Query Analyzer and Schema EnHancer)
Squash is a tool supporting the analysis and recfactoring of applications that
base on a relational database.
The basis of the analysis is an SQL logfile containing all SQL statements that were sent to
the database (the "Workload") and the description of the underlying database schema (tables and indexes).
Squash synchronizes the SQL statements with the modified database schema
and also includes checks for common SQL errors. Additionally it proposes optimized statements after
having analyzed the database schema and its contents.
The tool has been integrated in the
DisLog Developers' Toolkit (DDK)
within the module "database" and can be used with Prolog.
The link to the publication.
JSquash
JSquash has been developed in the field of Squash.
It removes the need of having an SQL logfile and determines all SQL statements directly from the
source code of a given java application.
This frees from the assumption that while generating the Workload all SQL statements that would be
executed during productive use in fact have been generated and are included.
JSquash analyses Java source code of embedded database applications by means of static code analysis.