Authors:
Brad Arshinoff
1
;
Damon Ratcliffe
1
;
Martin Saetre
1
;
Reda Alhajj
1
and
Tansel Özyer
2
Affiliations:
1
University of Calgary, Canada
;
2
TOBB Ekonomi ve Teknoloji Üniversitesi, Turkey
Keyword(s):
Visual Query Language, SQL, Data Extraction, Relational Query Language, Form Based Query Language, HCI, Data extraction.
Related
Ontology
Subjects/Areas/Topics:
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Legacy Systems
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.