Results 11 to 20 of about 34,853 (265)
Query Optimization Algorithm Based on Learning to Rank [PDF]
Jisuanji kexueQuery optimization is a key aspect of relational databases.In the traditional query optimization process,cardinality estimation of join and filter operations in a query is usually required in order to obtain a better execution plan.However,due to the ...
YU Yang, PENG Yuwei
doaj +1 more source
Query Optimization in Teradata Warehouse
Journal of Telecommunications and Information Technology, 2023 The time necessary for data processing is becoming shorter and shorter nowadays. This thesis presents a definition of the active data warehousing (ADW) paradigm.
Agnieszka Gosk
doaj +1 more source
On the Effectiveness of the Minimization Approach to the Query Optimization
Моделирование и анализ информационных систем, 2016 A standard problem of DBMSs usage is a lack of efficiency and high cost of the access to the stored data. The acceptable level of system performance may be achieved by query optimization technics that determine the most efficient way to execute a given ...
N. Mendkovich
doaj +1 more source
Optimization of Analytical Queries in Heterogeneous Systems
Современные информационные технологии и IT-образование, 2021 According to International Data Corporation (IDC) reports, humankind produced more than 64 zettabytes of data in 2020. Global data creation and replication are expected to grow 23% annually between 2020 and 2025.
Petr Kurapov, Areg Melik-Adamyan
doaj +1 more source
Analysis of the possibilities of optimizing SQL queries
Journal of Computer Sciences Institute, 2021 Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL).
Piotr Rymarski, Grzegorz Kozieł
doaj +1 more source
Genetic Algorithm for Relational Database Optimization in Reducing Query Execution Time
Scientific Journal of Informatics, 2018 The relational database is defined as the database by connecting between tables. Each table has a collection of information. The information is processed in the database by using queries, such as data retrieval, data storage, and data conversion.
Kukuh Triyuliarno Hidayat +2 more
doaj +1 more source
Survey on AI Powered New Techniques for Query Processing and Optimization
Jisuanji kexue yu tansuo, 2020 As one of the most challenging problems in data management, query processing and optimization are always widely concerned by researchers. However, it is very difficult for traditional techniques to meet the diverse requirements of modern database system ...
SONG Yumeng, GU Yu, LI Fangfang, YU Ge
doaj +1 more source
IEEE Access, 2022 In a distributed database environment, multi-join query optimization is one of the key factors affecting database performance. Genetic algorithms have a good application in dealing with this type of problem. However, the traditional genetic algorithm has
Bingxu Zheng +3 more
doaj +1 more source
An Overwiew of Evolution of Lexical Query Optimization Techniques
Труды Института системного программирования РАН, 2018 The presented overview is concerned with lexical query optimization and covers papers published in the last four decades. The paper consists of five sections.
N. A. Mendkovich, S. D. Kuznetsov
doaj +1 more source
Parametric query optimization [PDF]
The VLDB Journal The International Journal on Very Large Data Bases, 1997 In most database systems, the values of many important run-time parameters of the system, the data, or the query are unknown at query optimization time. Parametric query optimization attempts to identify at compile time several execution plans, each one of which is optimal for a subset of all possible values of the run-time parameters. The goal is that
Yannis E. Ioannidis +3 more
openaire +2 more sources