UUM Electronic Theses and Dissertation
UUM ETD | Universiti Utara Malaysian Electronic Theses and Dissertation
FAQs | Feedback | Search Tips | Sitemap

Graphical Web Based Tool for Generating Query from Star Schema

Anbar, Mohammad F.R. (2009) Graphical Web Based Tool for Generating Query from Star Schema. Masters thesis, Universiti Utara Malaysia.

[thumbnail of Mohammed_F_R_Anbar.pdf] PDF
Restricted to Registered users only

Download (1MB)
[thumbnail of 1.Mohammed_F_R_Anbar.pdf]

Download (124kB) | Preview


Novice users have difficulty to generate structured query language from the star schemas because they are not familiar with formulating SQL queries and SQL syntax. This study proposed graphical web based tool to generate queries from star schema and represent the data in tabular or graphical forms which help novice user to formulate SQL query. A prototype for a web based tool to generate the query has been developed using Java Server Pages programming language. The developed tool can facilitate complex query construction which is faced by non-technical and/or novice users. The output of SQL query is presented in tabular and graphical forms which can help users especially top management in better understanding and
interpreting query results.

Item Type: Thesis (Masters)
Supervisor : UNSPECIFIED
Item ID: 1612
Uncontrolled Keywords: Database Design, Data Warehousing, Query Language
Subjects: Q Science > QA Mathematics > QA76 Computer software
Divisions: College of Arts and Sciences (CAS)
Date Deposited: 17 Mar 2010 08:33
Last Modified: 24 Jul 2013 12:12
Department: College of Arts and Sciences
URI: https://etd.uum.edu.my/id/eprint/1612

Actions (login required)

View Item
View Item