Search Results - SQL query optimization

STRATEGIES FOR IMPROVING THE PERFORMANCE OF RUBY WEB APPLICATIONS: DATA CACHING AND SQL QUERY OPTIMIZATION

Authors: Topalidi A.

Subject Terms: data caching, SQL query optimization, web application performance, Redis, Memcached, ActiveRecord, N+1 queries

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

Authors: Nisuli Hettiarachchi Prasan Yapa

Source: 2025 5th International Conference on Machine Learning and Intelligent Systems Engineering (MLISE). :31-39

SPARK SQL QUERY OPTIMIZATION WITH REINFORCEMENT MACHINE LEARNING

Authors: Aakula, Ajay

ADVANCED QUERY OPTIMIZATION IN SQL DATABASES FOR REAL-TIME BIG DATA ANALYTICS

Authors: Rahman, Md Mostafizur Islam, Siful Kamruzzaman, Md et al.

Source: Academic Journal on Business Administration, Innovation & Sustainability; Vol. 4 No. 3 (2024): Academic Journal on Business Administration, Innovation & Sustainability; 1-14; 2997-9552

Index Terms: SQL Query Optimization, Multi-level Indexing, Query Rewriting, Dynamic Query Execution Plans, Big Data Analytics, info:eu-repo/semantics/article, info:eu-repo/semantics/publishedVersion, Peer-reviewed Article

URL: https://allacademicresearch.com/index.php/AJBAIS/article/view/77
https://allacademicresearch.com/index.php/AJBAIS/article/view/77/72
https://allacademicresearch.com/index.php/AJBAIS/article/view/77/72

The Examination of SQL Queries Efficiency in Chosen IT System

Authors: Krzysztof Barczak

Source: Journal of Computer Sciences Institute, Vol 28 (2023)

Subject Terms: 03 medical and health sciences, 0302 clinical medicine, databases, SQL query optimization, Electronic computers. Computer science, 0202 electrical engineering, electronic engineering, information engineering, Information technology, QA75.5-76.95, 02 engineering and technology, performance analysis, T58.5-58.64, testing

Access URL: https://doaj.org/article/9a9200af262249c58ce6bd01fcedff74

Spark SQL Query Optimization Based on Runtime Statistics Collection

Authors: Yong Zhao Rong Chen

Source: 2021 IEEE 6th International Conference on Cloud Computing and Big Data Analytics (ICCCBDA). :250-255

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=9442524
http://xplorestaging.ieee.org/ielx7/9442468/9442488/09442524.pdf?arnumber=9442524

SQL Query Optimization in Distributed NoSQL Databases for Cloud-Based Applications

Authors: Aristeidis Karras Christos Karras Antonios Pervanas et al.

Source: Lecture Notes in Computer Science ISBN: 9783031334368

Optimizing SQL Query Execution Time: A Hybrid Approach Using Machine Learning and Deep Learning Technique

Authors: Bethineni Saritha

Source: International Journal of Intelligent Systems and Applications in Engineering; Vol. 12 No. 4 (2024); 110-116

Subject Terms: Sql, Query optimization, machine learning, deep learning

File Description: application/pdf

Access URL: https://www.ijisae.org/index.php/IJISAE/article/view/6179

Adaptive SQL Query Optimization in Distributed Stream Processing: A Preliminary Study

Authors: Darya Sharkova Alexander Chernokoz Artem Trofimov et al.

Source: Communications in Computer and Information Science ISBN: 9783030938482

SQL Query Optimization Techniques

Authors: Kajal P. Pathak Priyanka R. Munot Dipali R. Patil

Source: IJARCCE. 8:87-90

SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS = SQL QUERY OPTIMIZATION RESEARCH

Authors: Jurgita Lieponienė

Source: Taikomieji tyrimai studijose ir praktikoje, Vol 13, Iss 1, Pp 94-101 (2017)

Subject Terms: sql query, database index, normalization of the database, denormalization of the database, Social sciences (General), H1-99

File Description: electronic resource

Relation: https://ojs.panko.lt/index.php/ARSP/article/view/40/27; https://doaj.org/toc/2029-1280; https://doaj.org/toc/2669-0071

Access URL: https://doaj.org/article/0eab8f59551940b484092b3fa656c273

SQL Query Optimization by Predicting Multiple Logical Plans with Machine Learning

Authors: Punter, Wieger R.

Index Terms: Master, Master

URL: https://pure.tue.nl/ws/files/305006245/Punter_W.pdf
https://pure.tue.nl/ws/files/305006245/Punter_W.pdf

External optimization of SQL-query under conditions of databases structural uncertainty

Authors: Mykhaylo Zagirnyak P. Kostenko

Source: 2016 17th International Conference Computational Problems of Electrical Engineering (CPEE). :1-4

Subject Terms: 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: https://ieeexplore.ieee.org/document/7738723/

A novel approach for SQL query optimization

Authors: Fernaz Jasdanwala Sahista Machchhar Fazal Mithani

Source: 2016 IEEE International Conference on Computational Intelligence and Computing Research (ICCIC). :1-4

Access URL: https://ieeexplore.ieee.org/document/7919717/

SQL query optimization in Content Based Image Retrieval systems

Authors: Nicoleta Angelescu Catalin Dragoi Ion Caciula et al.

Source: 2016 International Conference on Communications (COMM). :395-398

Subject Terms: 0209 industrial biotechnology, 0202 electrical engineering, electronic engineering, information engineering, 02 engineering and technology

Access URL: http://ieeexplore.ieee.org/document/7528344
https://ieeexplore.ieee.org/document/7528344

Query Optimization using Sketches in Relational Database Systems

Authors: Izenov, Yesdaulet

Subject Terms: Computer science, Computer engineering, Information science, cardinality estimation, database, plan enumeration, query optimization, sketches, sql

File Description: application/pdf

Access URL: https://escholarship.org/uc/item/5k8334fs
https://escholarship.org/content/qt5k8334fs/qt5k8334fs.pdf

MPP SQL Query Optimization with RTCG

Authors: M. A. Sakkeer Jimson Johnson Shiju Andrews et al.

Source: Lecture Notes in Computer Science ISBN: 9783030047795

Access URL: https://dblp.uni-trier.de/db/conf/bigda/bigda2018.html#SridharSAJ18
https://link.springer.com/chapter/10.1007/978-3-030-04780-1_16
https://rd.springer.com/chapter/10.1007/978-3-030-04780-1_16

Improving SQL Performance Using Middleware-Based Query Rewriting

Authors: Bai, Qiushi

Subject Terms: Computer science, Database, Middleware, Query Optimization, Query Rewrite

File Description: application/pdf

Access URL: https://escholarship.org/uc/item/5pw8w7rj
https://escholarship.org/content/qt5pw8w7rj/qt5pw8w7rj.pdf

AI-driven SQL query optimization techniques

Authors: Juopperi, Tatiana

Subject Terms: fi=Tietojenkäsittely|sv=Informationsbehandling|en=Business Information Technology, SQL, query languages, databases, optimisation, artificial intelligence, database programs, machine learning, Query, relational databases, distributed systems, Degree Programme in Business Information Technology

Relation: https://www.theseus.fi/handle/10024/861818

Availability: https://www.theseus.fi/handle/10024/861818

The Examination of SQL Queries Efficiency in Chosen IT System

Authors: Barczak, Krzysztof

Source: Journal of Computer Sciences Institute; Vol. 28 (2023); 186-189 ; Journal of Computer Sciences Institute; Tom 28 (2023); 186-189 ; 2544-0764

Subject Terms: SQL query optimization, databases, testing, performance analysis

File Description: application/pdf

Relation: https://ph.pollub.pl/index.php/jcsi/article/view/3606/4163; https://ph.pollub.pl/index.php/jcsi/article/view/3606

Availability: https://ph.pollub.pl/index.php/jcsi/article/view/3606