AUTOJOIN: PROVIDING FREEDOM FROM SPECIFYING JOINS

Terrence Mason, Lixin Wang, Ramon Lawrence

2005

Abstract

SQL is not appropriate for casual users as it requires understanding relational schemas and how to construct joins. Many new query interfaces insulate users from the logical structure of the database, but they require the automatic discovery of valid joins. Although specific query interfaces implement join determination algorithms, they are tied to the specific language and typically limited in scope or scalability. AutoJoin provides a general solution to the query inference problem, which allows more complex queries to be executed on larger and more complicated schemas. It enumerates query interpretations at least an order of magnitude faster than previous methods. In addition, the engine reduces the number of queries considered ambiguous. Experimental results demonstrate that query inference can be efficiently performed on large, complex schemas allowing simpler access to databases through keyword search or conceptual query languages. AutoJoin also provides programmers with a tool to iteratively create SQL queries without requiring explicit knowledge of the structure of a database.

Paper Citation

in Harvard Style

Mason T., Wang L. and Lawrence R. (2005). AUTOJOIN: PROVIDING FREEDOM FROM SPECIFYING JOINS . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 5: ICEIS, ISBN 972-8865-19-8, pages 31-38. DOI: 10.5220/0002516100310038

in Bibtex Style

@conference{iceis05,
author={Terrence Mason and Lixin Wang and Ramon Lawrence},
title={AUTOJOIN: PROVIDING FREEDOM FROM SPECIFYING JOINS},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 5: ICEIS,},
year={2005},
pages={31-38},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002516100310038},
isbn={972-8865-19-8},
}

in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 5: ICEIS,
TI - AUTOJOIN: PROVIDING FREEDOM FROM SPECIFYING JOINS
SN - 972-8865-19-8
AU - Mason T.
AU - Wang L.
AU - Lawrence R.
PY - 2005
SP - 31
EP - 38
DO - 10.5220/0002516100310038