International Journal of Computer
Trends and Technology

Research Article | Open Access | Download PDF

Volume 4 | Issue 3 | Year 2013 | Article Id. IJCTT-V4I3P125 | DOI : https://doi.org/10.14445/22312803/IJCTT-V4I3P125

SQL Query Optimizer-based Query Progress Indicator

Dr.S.D.Joshi, Prof.L.V.Patil, Urmila Mane

Citation :

Dr.S.D.Joshi, Prof.L.V.Patil, Urmila Mane, "SQL Query Optimizer-based Query Progress Indicator," International Journal of Computer Trends and Technology (IJCTT), vol. 4, no. 3, pp. 320-324, 2013. Crossref, https://doi.org/10.14445/22312803/IJCTT-V4I3P125

Abstract

So for this purpose it is important for users to have information about progress of query execution. Recently interest in the development of percent-done progress indicators has been increased. In this paper, we propose a method that constructs model of a percent-done progress indicators based on optimizer-based approach. Percent-done progress indicators basically used as a technique that graphically shows query execution time that means total and remaining or degree of completion. Also the proposed technique is based on postgerSQL database engine. PostgreSQL is a powerful, open source object-relational database system. Currently Postgres doesn’t have SQL query progress indicator for long-running queries. With the help of user-system interaction (interface) the progress indicator show the progress of SQL queries through various phases like parsing, analyzing, rewrite, execution. The graphical user interface show all the queries running on system and their estimated time completion. The execution phase of query is critical phase and also the cost of query varies depending disk read time, type of join used, distribution or broadcast of table, order in which tables are joined, statistics information available.

Keywords

ACID, BI, DW, GUI, PostgreSQL, RDBMSs, SQL, UNIX.

References

[1] Jiexing Li, Rimma V. Nehme , Jeffrey Naughton; “GSLPI: a Cost-based Query Progress Indicator”; 2012 IEEE 28th International Conference on Data Engineering.
[2] Basit Raza, Abdul Mateen, M M Awais and Muhammad Sher; “Survey on Autonomic Workload Management: Algorithms,Techniques and Models”; Journal of computing, volume 3,Issue 7,July 2011, ISSN 2151-9617.
[3] Kristi Morton, Abram Friesen, Magdalena Balazinska, Dan Grossman; “Estimating the Progress of MapReduce Pipelines”;ICDE Conference 2010.
[4] Elnaz Zafarani, Mohammad_Reza Feizi_Derakhshi, Hasan Asil, Amir Asil; “Presenting a New Method for Optimizing Join Queries Processing in Heterogeneous Distributed Databases”; 2010 Third International Conference on Knowledge Discovery and Data Mining.
[5] Mario Milicevic, Krunoslav Zubrinic, Ivona Zakarija; “Dynamic Approach to the Construction of Progress Indicator for a Long Running SQL Queries”; international journal of computers issue 4, volume 2, 2008
[6] Mario Milicevic, Krunosla V Zubrinic, Ivona Zakarija; “Adaptive Progress Indicator for Long Running SQL Queries”; Proceedings of the 8th WSEAS International Conference on Applied Computer Science(ACS’08).
[7] Chaitanya Mishra, Nick Koudas; “A Lightweight Online Framework For Query Progress Indicators”; 2007 IEEE.
[8] Gang Luo , Jeffrey F. Naughton , and Philip S. Yu;” Multi-query SQL Progress Indicators”; Y. Ioannidis et al. (Eds.): EDBT 2006, LNCS 3896, pp. 921 – 941, 2006, Springer-Verlag Berlin Heidelberg 2006.
[9] Christian M. Garcia-Arellano, Sam S. Lightstone, Guy M. Lohman, Volker Markl, and Adam J. Storm; “Autonomic Features of the IBM DB2 Universal Database for Linux, Unix, and Windows”; IEEE Transactions on systems, MAN, And Cybernetics Part C:Applications And Reviews, Vol.36,No.3, May 2006.
[10] Gang Luo, Jeffrey F, Naughton, Curt J. Ellmann, Michael W. Watzke; “Increasing the Accuracy and Coverage of SQL Progress Indicators”; Proceedings of the 21st International Conference on Data Engineering (ICDE 2005).
[11] S. Chaudhuri, R. Kaushik, and R. Ramamurthy, “When can we trust progress estimators for SQL queries?”  in SIGMOD, 2005.
[12] DB2, “IBM DB2 query monitor for z/OS,” ftp://ftp.software.ibm.com/software/data/db2imstools/whitepapers/ db2querymon-wp05.pdf, 2005.
[13]  Suraji  Chaudhuri, Vivek Narasayya, Ravishankar Ramamurthy; “Estimating Progress of Execution for SQL Queries”; SIGMOD 2004, June 13–18, 2004, Paris, France, 2004 ACM.
[14] Gang Luo , Jeffrey F. Naughton , Curt J. Ellmann , Michael W. Watzke; “Toward a Progress Indicator for Database Queries”; ACM SIGMOD 2004, June 13–18, 2004, Paris, France,2004 ACM.
[15] Chaitanya Mishra, Nick Koudas; “A Lightweight Online Framework For Query Progress Indicators”; 2002 ACM.