WISH QUERY COMPOSER

Vivien Liang, Greg Butler

Abstract

The WISH (With Intuitive Search Help) Query Composer is a software tool for composing form-based queries and their associated reports for relational databases. It incorporates the SQL and XML industry standards to generate user-friendly customizable queries and reports. It uses the very simple but flexible XML semantics to represent database schemas, SQL queries and result datasets, regardless of in which relational database management system (RDBMS) the data is stored. The tool is developed in the Eclipse development environment using the Java programming language with Swing components, and connects to the database through Java Database Connectivity (JDBC). The Java Architecture for XML Binding (JAXB) is used to automate the mapping between XML documents and Java objects.

References

  1. Garcia-Molina, H., Ullman, J. D., and Widom, J. (2000). Database System Implementation. Prentice-Hall.
  2. Ort, E. and Mehta, B. (2003). Java architecture for xml binding(jaxb). Technical Article, java.sun.com.
  3. Zloof, M. (1977). Query by example: A database language. IBM System Journal, 16(4):324-343.
Download


Paper Citation


in Harvard Style

Liang V. and Butler G. (2004). WISH QUERY COMPOSER . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 566-569. DOI: 10.5220/0002624505660569


in Bibtex Style

@conference{iceis04,
author={Vivien Liang and Greg Butler},
title={WISH QUERY COMPOSER},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={566-569},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002624505660569},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - WISH QUERY COMPOSER
SN - 972-8865-00-7
AU - Liang V.
AU - Butler G.
PY - 2004
SP - 566
EP - 569
DO - 10.5220/0002624505660569