Efficient GCD functions in SQL

Abstract

Querying a database in an intuitive way is becoming more important. Users expect their tools to present an easy-to-use interface that can interpret complex search criteria. These criteria can be optional, mandatory, unwanted or grouped together, according to what the developer of a tool wishes to offer to the user. This research focuses on making it possible to interpret a complex aggregation of criteria and retrieve results in the standard language of the target database. The translation of user query to database query is presented and some experiments regarding performance are given.