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.

[img] PDF
Mohammed_F_R_Anbar.pdf
Restricted to Registered users only

Download (1MB)
[img]
Preview
PDF
1.Mohammed_F_R_Anbar.pdf

Download (124kB) | Preview

Abstract

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)
Uncontrolled Keywords: Database Design, Data Warehousing, Query Language
Subjects: Q Science > QA Mathematics > QA76 Computer software
Divisions: College of Arts and Sciences (CAS)
Depositing User: Mrs Norazmilah Yaakub
Date Deposited: 17 Mar 2010 08:33
Last Modified: 24 Jul 2013 12:12
URI: http://etd.uum.edu.my/id/eprint/1612

Actions (login required)

View Item View Item