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: | eng eng |
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 |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my-uum-etd.1612 |
---|---|
record_format |
uketd_dc |
institution |
Universiti Utara Malaysia |
collection |
UUM ETD |
language |
eng eng |
topic |
QA76 Computer software |
spellingShingle |
QA76 Computer software Anbar, Mohammad F.R. Graphical Web Based Tool for Generating Query from Star Schema |
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 |
qualification_name |
masters |
qualification_level |
Master's degree |
author |
Anbar, Mohammad F.R. |
author_facet |
Anbar, Mohammad F.R. |
author_sort |
Anbar, Mohammad F.R. |
title |
Graphical Web Based Tool for Generating Query from Star Schema |
title_short |
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_sort |
graphical web based tool for generating query from star schema |
granting_institution |
Universiti Utara Malaysia |
granting_department |
College of Arts and Sciences (CAS) |
publishDate |
2009 |
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 |
_version_ |
1747827176086962176 |
spelling |
my-uum-etd.16122022-04-21T03:37:36Z Graphical Web Based Tool for Generating Query from Star Schema 2009 Anbar, Mohammad F.R. College of Arts and Sciences (CAS) College of Arts and Sciences 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 https://etd.uum.edu.my/1612/ https://etd.uum.edu.my/1612/1/Mohammed_F_R_Anbar.pdf text eng public https://etd.uum.edu.my/1612/2/1.Mohammed_F_R_Anbar.pdf text eng public masters masters Universiti Utara Malaysia Agarwal, D., Barman, D., Gunopulos, D., Young, N. E., Korn, F., & Srivastava, D.(2007). Efficient and effective explanation of change in hierarchical summaries.Proceedings of the 13th ACM SIGKDD international conference on Knowledge discovery and data mining.Baresi, L., & Morasca, S. (2007). Three empirical studies on estimating the design effort of Web applications. ACM Transactions on Software Engineering and Methodology, 16 (4),40-45 Becker, K., Cardoso, M. O., Nichele, C. M., & Frighetto, M. (2000). Mail-by-example: a visual query interface for email management. Proceedings of the working conference on Advanced visual interfaces. 280-281.Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., & Paraboschi, S. (2001). Designing data marts for data warehouses. ACM Transactions on Software Engineering and Methodology, 10(4), 452-483. Borgman, C. L. (1996). Why are online catalogs still hard to use? Journal of the American Society for Information Science, 47(7), 493-503.Brambilla, M., Ceri, S.,Fraternali, P., & Manolescu, I. (2006). Process modeling in Web applications. ACM Transactions on Software Engineering and Methodology(TOSEM), 15(4), 360-409.Cao, B., & Badia, A. (2007). SQL query optimization through nested relational algebra.ACM Transactions on Database Systems (TODS), 32(3) 67 Chapple, M. (2000). Data Definition Language. Retrieved February 11th, 2009 From http://databases.about.com/od/sql/a/sqlfundamentals_2.htm Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26(1), 65-74.Chen, Z., & Li, T. (2007). Addressing diverse user preferences in SQL-query-result navigation. Proceedings of the 2007 ACM SIGMOD international conference on management of data. 641-652. Cl, B. (1999). The users mental model of an information retrieval system: an experiment on a prototype online catalog. International Journal of Human-Computer Studies, 51(2), 435-452.Conallen, J. (2000). Modeling Web Applications with UML. White paper, Conallen Inc., http://www. conallen.com/whitepapers/webapps/ModelingWebApplications. htm, March 1999.Conallen, J. (2002). Modeling Web Applications with UML (2nd ed.). USA: Addison-Wesley.Connolly, T. M., & Begg, C. E. (2005). Database Systems: A Practical Approach to Design, Implementation, and Management: USA: Addison Wesley Publishing Company.Deshmukh, H., Malavia, J., & Carter, w. J. (2003). SCWCD exam study kit : Java web component developer certification. Greenwich: Manning Publications. France, R., & Kobryn, C. (2001). UML for software engineers. Proceedings of the 23rd International Conference on Software Engineering. 705-706 68 Ginige, A., & Murugesan, S. (2001). Web engineering: an introduction. IEEE Multimedia, 8(1), 14-18.Hao, J., & Mendes, E. (2006). Usage-based statistical testing of web applications. Proceedings of the 6th international conference on Web engineering. 17 - 24 Huo, J. (2008). KMVQL: a visual query interface based on Karnaugh map. Proceedings of the working conference on Advanced visual interfaces.Inmon, B., & Kelly, C. (1994). The Twelve Rule of Data warehouse for a Client/Server World. Data Managment Review 4(5), 6-16. Jarke, M. (2003). Fundamentals of Data Warehouses. New York: Springer-Verlag.Jones, S. (1998). Graphical query specification and dynamic result previews for a digital library. Proceedings of the 11th annual ACM symposium on User interface software and technology.Jung, H., & Lee, G. G. (2002). Multilingual question answering with high portability on relational databases. COLING-02: proceedings of the 2002 conference on multilingual summarization and question answering - Volume 19 Kaner, C. (2003). What is a Good Test Case?Kappel, G., Pröll, B., Reich, S., & Retschitzegger, W. (2006). Web Engineering-The Discipline of Systematic Development of Web Applications. USA: John Wiley & Sons, Inc.Kern, J., & Garrett, C. (2003). Effective Sequence Diagram Generation. Borland (www.borland.com/together/white_papers). Kim, W. (1982). On optimizing an SQL-like nested query. ACM Transactions on Database Systems (TODS), 7(3), 443-469. 69 Krippendorf, M., & Song, I. Y. (1997). The translation of star schema into entityrelationship diagrams. Proceedings of the 8th International Workshop on Database and Expert Systems Applications.Law, A. S., Freer, Y., Hunter, J., Logie, R. H., McIntosh, N., & Quinn, J. (2005). A Comparison of Graphical and Textual Presentations of Time Series Data to Support Medical Decision Making in the Neonatal Intensive Care Unit. Journal of Clinical Monitoring and Computing, 19(3), 183-194.Malinowski, E., & Zimányi, E. (2006). Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering,59(2), 348-377. Martin, R. C. (1997). UML Tutorial: Part 1--Class Diagrams. Engineering Notebook Column, C++ Report.Nourie, D. (2006). Java Technologies for Web Applications. Retrieved January 13th,2009 From http://java.sun.com/developer/technicalArticles/tools/webapps_1/.Pokorny, J. (1998). Data Warehouses: a Modelling Perspective. In: Evolution and Challenges in System Development. Proceeding of 7th International Conference on Information Systems. Ramakrishnan, R., & Gehrke, J. (2003). Database Management Systems (3 ed.). New York: McGraw-Hill Professional. Rob, P., & Coronel, C. (2008). Database Systems: Design, Implementation, and Management. USA: Thomson Course Technology.70 Rowen, W., Song, I. Y., Medsker, C., Arynth, I., & Ewen, E. (2001). An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling. Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2001) Interlaken, Switzerland,June 4, 2001. Sibley, E. H., & Taylor, R. W. (1973). A data definition and mapping language.Communications of the ACM, 16(12), 750-759.Stoffel, K., Davis, J. D., Rottman, G., Saltz, J., Dick, J., Merz, W., et al. (1998). A graphical tool for ad hoc query generation. Proceedings of the AMIA(American Medical Informatics Association) Symposium. 503-7.Nishith. (2005). Database vs. Data Warehouse. Retrieved Febreuary 2nd, 2009, From http://opensourceanalytics.com/2005/11/02/database-vs-data-warehouse/Weininger, A. (2002). Efficient execution of joins in a star schema. Proceedings of the ACM SIGMOD international conference on Management of data. |