Anbar, Mohammed and Ku-Mahamud, Ku Ruhana (2009) Graphical web based tool for generating query from star schema. In: International Conference on Computing and Informatics 2009 (ICOCI09), 24-25 June 2009, Legend Hotel, Kuala Lumpur.

Preview

PDF Download (254kB) | Preview

Abstract

This paper presents the development of a graphical SQL query tool that allows novice and non-technical users to navigate through database tables and generate their own queries.The tool enables the query output to be presented in graphical and tabular forms, which can help users, especially top management in better understanding and interpreting query results.The algorithms to construct complex SQL query from star schema in databases is also presented.

Item Type:	Conference or Workshop Item (Paper)
Additional Information:	ISBN 978-983--44150-2-0 Organized by: UUM College of Arts and Sciences, Universiti Utara Malaysia.
Uncontrolled Keywords:	SQL Query Generation, Star Schema, Graphical and Tabular forms
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Divisions:	College of Arts and Sciences
Depositing User:	Prof. Dr. Ku Ruhana Ku Mahamud
Date Deposited:	02 Apr 2015 02:04
Last Modified:	02 Apr 2015 02:05
URI:	https://repo.uum.edu.my/id/eprint/13522

Actions (login required)

View Item