Graphical Web Based Tool for Generating Query from Star Schema

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...

Full description

Saved in:
Bibliographic Details
Main Author: Anbar, Mohammad F.R.
Format: Thesis
Language:eng
eng
Published: 2009
Subjects:
QA76 Computer software
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.

Similar Items