NDLI: Dynamic Reconfiguration of Sub-Optimal Parallel Query Execution Plans (1998)

Please wait, while we are loading the content...

Dynamic Reconfiguration of Sub-Optimal Parallel Query Execution Plans (1998)

Content Provider	CiteSeerX
Author	Ng, Kenneth Wang, Zhenghao Muntz, Richard R.
Abstract	Existing query optimization methods do not satisfy some of today's query processing requirements. Typically, only coarse or inaccurate estimates of database statistics are available prior to query evaluation. On the other hand, massive database sizes and growing demands for sophisticated processing result in long-running queries in extensible Object-Relational DBMS, particularly in decision support, and in data warehousing analysis applications. Therefore changes in system configuration and resource availability during query evaluation are not unexpected and can result in deteriorated query performance. Considering a parallel query evaluation environment, we propose dynamic reconfiguration of sub-optimal parallel query execution plans (QEPs) to adapt QEPs to the environment as well as to refined estimates of data and query characteristics. To ensure correct query evaluation in the face of modification of the QEP, we propose an algorithm to coordinate the steps in a reconfiguration. We ...
File Format	PDF
Language	English
Publisher Date	1998-01-01
Access Restriction	Open
Subject Keyword	Sub-optimal Parallel Query Execution Plan Dynamic Reconfiguration Resource Availability Query Evaluation Therefore Change Inaccurate Estimate Query Optimization Method Deteriorated Query Performance Sophisticated Processing Result Decision Support Long-running Query Extensible Object-relational Dbms Analysis Application Correct Query Evaluation Query Characteristic Database Statistic Massive Database Size Query Processing Requirement System Configuration Parallel Query Evaluation Environment
Content Type	Text
Resource Type	Technical Report

Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302

See location in the Map
03222 282435
Mail: support@ndl.gov.in

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in