NDLI: Query Size Estimation for Joins Using Systematic Sampling

Content Provider	Springer Nature Link
Author	Ngu, A.H.H. Harangsri, B. Shepherd, J.
Copyright Year	2004
Abstract	We propose a new approach to the estimation of query result sizes for join queries. The technique, which we have called “systematic sampling—SYSSMP”, is a novel variant of the sampling-based approach. A key novelty of the systematic sampling is that it exploits the sortedness of data; the result of this is that the sample relation obtained well represents the underlying frequency distribution of the join attribute in the original relation.We first develop a theoretical foundation for systematic sampling which suggests that the method gives a more representative sample than the traditional simple random sampling. Subsequent experimental analysis on a range of synthetic relations confirms that the quality of sample relations yielded by systematic sampling is higher than those produced by the traditional simple random sampling.To ensure that sample relations produced by systematic sampling indeed assist in computing more accurate query result sizes, we compare systematic sampling with the most efficient simple random sampling called t_cross using a variety of relation configurations. The results obtained validate that systematic sampling uses the same amount of sampling but still provides more accurate query result sizes than t_cross. Furthermore, the extra sampling cost incurred by the use of systematic sampling pays off in a cheaper query execution cost at run-time.
Starting Page	237
Ending Page	275
Page Count	39
File Format	PDF
ISSN	09268782
Journal	Distributed and Parallel Databases
Volume Number	15
Issue Number	3
e-ISSN	15737578
Language	English
Publisher	Kluwer Academic Publishers
Publisher Date	2004-01-01
Publisher Place	Boston
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Processor Architectures Computer Communication Networks Data Structures, Cryptology and Information Theory Information Storage and Retrieval
Content Type	Text
Resource Type	Article
Subject	Information Systems and Management Information Systems Software Hardware and Architecture

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

Multidatabase Query Optimization

Query Optimization in Multidatabase Systems

Solving Local Cost Estimation Problem for Global Query Optimization in Multidatabase Systems

Window Query Processing in Linear Quadtrees

Capabilities-Based Query Rewriting in Mediator Systems

Query Processing and Optimization on the Web

Query Decomposition for a Distributed Object-Oriented Mediator System

Dynamic Query Operator Scheduling for Wide-Area Remote Access

Load Balancing for Parallel Query Execution on NUMA Multiprocessors

Query Size Estimation for Joins Using Systematic Sampling

Similar Documents

Multidatabase Query Optimization

Query Optimization in Multidatabase Systems

Solving Local Cost Estimation Problem for Global Query Optimization in Multidatabase Systems

Window Query Processing in Linear Quadtrees

Capabilities-Based Query Rewriting in Mediator Systems

Query Processing and Optimization on the Web

Query Decomposition for a Distributed Object-Oriented Mediator System

Dynamic Query Operator Scheduling for Wide-Area Remote Access

Load Balancing for Parallel Query Execution on NUMA Multiprocessors

Query Size Estimation for Joins Using Systematic Sampling