SIMPLIFIED QUERY CONSTRUCTION - (Queries Made as Easy as Possible)

Brad Arshinoff, Damon Ratcliffe, Martin Saetre, Reda Alhajj, Tansel Özyer

Abstract

QMAEP- Queries Made as Easy as Possible, is intended to be a system that greatly simplifies the process of query construction for statisticians and researchers. This document is focused on the usability of the database query language and deals with visual representations of the query process, in specific the select query. Methods of integrating simple Graphical User Interfaces (GUIs) for building queries into pre-existing database forms is explored to provide users an intuitive method for query construction. This paper explores data mining as it pertains to clinical research with emphasis on simplifying the data extraction process from complex databases so as to accommodate analysis using important statistical software such as SASS, QMath and MS Excel.

References

  1. Celko, J. (2004). Joe Celko's SQL for Smarties: Trees and Hierarchies. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA.
  2. Doan, D. K., Paton, N. W., Kilgour, A. C., and al Qaimari, G. (1995). Multi-paradigm query interface to an object-oriented database. Interacting with Computers, 7(1):25-47.
  3. Ezekiel, J. (2004). Ethical and Regulatory Aspects of Clinical Research: Readings and Commentary. Johns Hopkins University Press.
  4. Owei, V., Navathe, S. B., and Rhee, H.-S. (2002). An abbreviated concept-based query language and its exploratory evaluation. J. Syst. Softw., 63(1):45-67.
  5. Preece, J., Rogers, Y., and Sharp, H. (2002). Interaction Design. Wiley.
  6. Show, G. Y., Kong, H., and Lin, W. K. (1993). Intelligent user interface to sql-based database system. In Engineering Applications of Artificial Intelligence, volume 6, pages 307-316.
  7. Siau, K. (1998). A visual object-relationship query language for user-database interaction. Telemat. Inf., 15(1-2):103-119.
Download


Paper Citation


in Harvard Style

Arshinoff B., Ratcliffe D., Saetre M., Alhajj R. and Özyer T. (2007). SIMPLIFIED QUERY CONSTRUCTION - (Queries Made as Easy as Possible) . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 125-130. DOI: 10.5220/0002398601250130


in Bibtex Style

@conference{iceis07,
author={Brad Arshinoff and Damon Ratcliffe and Martin Saetre and Reda Alhajj and Tansel Özyer},
title={SIMPLIFIED QUERY CONSTRUCTION - (Queries Made as Easy as Possible)},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={125-130},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002398601250130},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - SIMPLIFIED QUERY CONSTRUCTION - (Queries Made as Easy as Possible)
SN - 978-972-8865-88-7
AU - Arshinoff B.
AU - Ratcliffe D.
AU - Saetre M.
AU - Alhajj R.
AU - Özyer T.
PY - 2007
SP - 125
EP - 130
DO - 10.5220/0002398601250130