Results 11 to 20 of about 202,389 (329)
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
Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources [PDF]
, 2018 Apache Calcite is a foundational software framework that provides query processing, optimization, and query language support to many popular open-source data processing systems such as Apache Hive, Apache Storm, Apache Flink, Druid, and MapD.
Begoli, Edmon +4 more
core +2 more sources
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
On the Complexity of Query Result Diversification [PDF]
, 2013 Query result diversification is a bi-criteria optimization problem for ranking query results. Given a database D, a query Q and a positive integer k, it is to find a set of k tuples from Q(D) such that the tuples are as relevant as possible to the query,
Abiteboul S. +35 more
core +5 more sources
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
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