Abstract

WISH XML Query Composer is a tool for composing form-based queries and their associated reports for relational databases. This tool incorporates two industry standards to generate user-friendly customizable queries and reports. The Structured Query Language (SQL) has been a universal standard for accessing data in relational databases since 1989. The Extensible Markup Language (XML) is a relatively new standard documented by World Wide Web Consortium (W3C) that supports data exchange on the World Wide Web. Today, many different Relational Database Management Systems (RDBMS) utilize SQL as the primary means for accessing and manipulating data. The design of the WISH XML Query Composer is an attempt to use the very simple but flexible XML semantics to represent database schemas, SQL queries and result datasets, regardless of in what RDBMS the data is stored. This thesis describes the design and implementation of the WISH XML Query Composer. The tool is written in Java programming language with Swing components, and connects to the database through Java Database Connectivity (JDBC). Java Architecture for XML Binding (JAXB) is used to automate the mapping between XML documents and Java objects.