loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Authors: Uriy Grigorev 1 ; Andrey Ploutenko 2 ; Aleksey Burdakov 2 ; Olga Pluzhnikova 1 and Evgeny Detkov 1

Affiliations: 1 Bauman Moscow State Technical University, Moscow, Russia ; 2 Amur State University, Blagoveschensk, Russia

Keyword(s): Cardinality Estimation, CardEst, Sampling, Full Outer Join, Approximate Calculation of Aggregates.

Abstract: Efficient query planning is crucial in large smart databases, where the complexity of joining tables can exceed a hundred. This paper addresses the pivotal role of cardinality estimation in generating effective query plans within a Database Management System (DBMS). Over the past decade, various estimation methods have been developed, yet their accuracy tends to decrease as the number of joined tables increases due to specific constraints and prerequisites. This paper introduces EVACAR, a novel cardinality estimation method rooted in the theory of approximate aggregate calculations. Unlike existing methods, EVACAR is designed to alleviate limitations associated with increasing table joins. Our method not only matches but often surpasses the accuracy of machine learning methods, achieving superior results for 75-88% of the evaluated queries (subplans). This advancement signifies a promising step towards optimizing query performance in large-scale smart databases.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.142.131.51

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Grigorev, U.; Ploutenko, A.; Burdakov, A.; Pluzhnikova, O. and Detkov, E. (2024). Sample-Based Cardinality Estimation in Full Outer Join Queries. In Proceedings of the 9th International Conference on Internet of Things, Big Data and Security - IoTBDS; ISBN 978-989-758-699-6; ISSN 2184-4976, SciTePress, pages 235-244. DOI: 10.5220/0012682000003705

@conference{iotbds24,
author={Uriy Grigorev. and Andrey Ploutenko. and Aleksey Burdakov. and Olga Pluzhnikova. and Evgeny Detkov.},
title={Sample-Based Cardinality Estimation in Full Outer Join Queries},
booktitle={Proceedings of the 9th International Conference on Internet of Things, Big Data and Security - IoTBDS},
year={2024},
pages={235-244},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0012682000003705},
isbn={978-989-758-699-6},
issn={2184-4976},
}

TY - CONF

JO - Proceedings of the 9th International Conference on Internet of Things, Big Data and Security - IoTBDS
TI - Sample-Based Cardinality Estimation in Full Outer Join Queries
SN - 978-989-758-699-6
IS - 2184-4976
AU - Grigorev, U.
AU - Ploutenko, A.
AU - Burdakov, A.
AU - Pluzhnikova, O.
AU - Detkov, E.
PY - 2024
SP - 235
EP - 244
DO - 10.5220/0012682000003705
PB - SciTePress

- Science and Technology Publications, Lda.
RESOURCES

Proceedings

Papers

Authors

Ontology

CONTACTS

Science and Technology Publications, Lda
Avenida de S. Francisco Xavier, Lote 7 Cv. C,
2900-616 Setúbal, Portugal.

Phone: +351 265 520 185 (National fixed network call)
Fax: +351 265 520 186
Email: info@scitepress.org

EXTERNAL LINKS

PRIMORIS

INSTICC

SCITEVENTS

CROSSREF

PROCEEDINGS SUBMITTED FOR INDEXATION BY:

dblp

Ei Compendex

SCOPUS

Semantic Scholar

Google Scholar

Microsoft Academic