QueryBuilder

Description

The report describes the QueryBuilder part of the SBDB project, for Bayer Schering. Its purpose is to generate SQL queries from criteria and patterns it receives from the user interface without knowing the database it should work on in advance. In other words, the table layout is not hard coded in the QueryBuilder but gets loaded from an external XML file as the QueryBuilder starts. In the case of SBDB, there were over 180+ tables, which made such automated graph-theoretic approaches necessary. Furthermore, the QueryBuilder was designed to run on relational database schema that are derived from object models and thus supports heritage relationships between tables.

I wrote the QueryBuilder in Java during a one-month internship at the Structural Biology and Genomics Laboratory (IGBMC Strasbourg), under the supervision of Olivier Camus and Jean-Marie Wurtz.

File type

PDF document

Language

English

Available versions

	Published on	Size	Changes
	09/11/2004 @ 00h02	928.49 KB	Publication du document.