More Java posts
February 08, 2003
Query Rewriting

I'm looking for some information on query rewriting and optimizing system. In particular rules based query rewriters. I want to be able to write a "query" in some declarative way similar to SQL and have it translated into a specification of the actions to carry out to implement the query. I've found a few papers, for example, Specifying Rule-based Query Optimizers in a Reflective Framework that describe the sort of thing I'm after. There are also a number of Java based rules engines such as drools, Jess and Mandarax that could form the substructure for such a system. Does anyone have any tips or pointers to share?

Posted by Alex at February 08, 2003 04:56 PM
Comments
The VLDB conference papers are free to read if they're more than a couple of years old. http://www.vldb.org/. If you're not an ACM member or a student this might help you find relevant papers. There's usually a few papers each year on query optimization techniques. VLDB is of most interest if you are implementing a database. If you're just doing O-R mapping, or any other kind of querying, the Arcus project (http://www.objectarchitects.de/arcus/) contained information on the design of a query builder that worked by matching subtrees (prefabricated query parts) to perform a larger query. I see the site is supposed to have more up-to-date stuff here: http://www.objectarchitects.de/ObjectArchitects/orpatterns/index.htm Hope this helps. Posted by: Brian Ewins on February 26, 2003 10:10 AM
Post a comment
Name:


Email Address:


URL:


Comments:


Remember info?