Graphical Web Based Tool for Generating Query from Star Schema
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 w...
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | en en |
| Published: |
2009
|
| Subjects: | |
| Online Access: | https://etd.uum.edu.my/1612/1/Mohammed_F_R_Anbar.pdf https://etd.uum.edu.my/1612/2/1.Mohammed_F_R_Anbar.pdf https://etd.uum.edu.my/1612/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1833435692045172736 |
|---|---|
| author | Anbar, Mohammad F.R. |
| author_facet | Anbar, Mohammad F.R. |
| author_sort | Anbar, Mohammad F.R. |
| building | UUM Library |
| collection | Institutional Repository |
| content_provider | Universiti Utara Malaysia |
| content_source | UUM Electronic Theses |
| continent | Asia |
| country | Malaysia |
| description | 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.
|
| format | Thesis |
| id | my.uum.etd-1612 |
| institution | Universiti Utara Malaysia |
| language | en en |
| publishDate | 2009 |
| record_format | eprints |
| spelling | my.uum.etd-16122022-04-21T03:37:36Z https://etd.uum.edu.my/1612/ Graphical Web Based Tool for Generating Query from Star Schema Anbar, Mohammad F.R. QA76 Computer software 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. 2009 Thesis NonPeerReviewed text en https://etd.uum.edu.my/1612/1/Mohammed_F_R_Anbar.pdf text en https://etd.uum.edu.my/1612/2/1.Mohammed_F_R_Anbar.pdf Anbar, Mohammad F.R. (2009) Graphical Web Based Tool for Generating Query from Star Schema. Masters thesis, Universiti Utara Malaysia. |
| spellingShingle | QA76 Computer software Anbar, Mohammad F.R. Graphical Web Based Tool for Generating Query from Star Schema |
| title | Graphical Web Based Tool for Generating Query from Star Schema |
| title_full | Graphical Web Based Tool for Generating Query from Star Schema |
| title_fullStr | Graphical Web Based Tool for Generating Query from Star Schema |
| title_full_unstemmed | Graphical Web Based Tool for Generating Query from Star Schema |
| title_short | Graphical Web Based Tool for Generating Query from Star Schema |
| title_sort | graphical web based tool for generating query from star schema |
| topic | QA76 Computer software |
| url | https://etd.uum.edu.my/1612/1/Mohammed_F_R_Anbar.pdf https://etd.uum.edu.my/1612/2/1.Mohammed_F_R_Anbar.pdf https://etd.uum.edu.my/1612/ |
| url_provider | http://etd.uum.edu.my/ |