Search Results - SQL query optimization

Query grouping–based multi‐query optimization framework for interactive SQL query engines on Hadoop by Chen, Ling, Lin, Yan, Wang, Jingchang, Huang, Heqing, Chen, Donghui, Wu, Yong

“…Summary In the past few years, executing high‐concurrency queries with interactive SQL query engines on Hadoop has become an important activity for many organizations…”
Get full text

SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS = SQL QUERY OPTIMIZATION RESEARCH by Jurgita Lieponienė

“…Although scientific literature studies different aspects of SQL query optimization the major part of researches is limited to the theoretical analysis of problems…”
Get full text

In-database query optimization on SQL with ML predicates by Guo, Yunyan, Li, Guoliang, Hu, Ruilin, Wang, Yong

“…Extended SQL with machine learning (ML) predicates, commonly referred to as SQL+…”
Get full text

SQL query optimization in Content Based Image Retrieval systems by Angelescu, Nicoleta, Coanda, Henri George, Caciula, Ion, Dragoi, Catalin, Albu, Felix

“…This paper presents a SQL query optimization method for Content Based Image Retrieval (CBIR) systems…”
Get full text

An Experimental Study on SQL Query Structure Optimization Performance in MySQL, PostgreSQL, and Microsoft SQL Server Using Apache JMeter by Tanujaya, Gladys, Suryasari

“… The results show that Microsoft SQL Server provides the best performance for unoptimized queries, whereas after optimization PostgreSQL achieves lower response times, higher throughput, and fewer…”
Get full text

The Examination of SQL Queries Efficiency in Chosen IT System by Barczak, Krzysztof

“…Optimization of SQL queries is an important part of any system using a database. Several different optimization methods have been selected and presented in this article, The research was conducted on the MS SQL database engine…”
Get full text

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection by Hettiarachchi, Nisuli, Yapa, Prasan

“…Efficient SQL Query Optimization (QO) is a fundamental aspect of database management systems, aimed at enhancing query performance and reducing resource consumption typically involves selecting the most efficient execution plan…”
Get full text

Towards Exploratory Query Optimization for Template-Based SQL Workloads by Feng, Jieming, Li, Zhanhuai, Chen, Qun

“…SQL query optimization aims to choose an optimal Query Execution Plan (QEP) for a query. The existing optimizers usually choose the plan with the minimal execution cost…”
Get full text

Query Execution Optimization in Spark SQL by Wu, Qingxi, Zhai, Mingyu, Zhao, Maoxian, Ji, Xuechun

“…Spark SQL is a big data processing tool for structured data query and analysis. However, due to the execution of Spark SQL, there are multiple times to write…”
Get full text

An Approach to Aid Decision-Making by Solving Complex Optimization Problems Using SQL Queries by Torres-Jimenez, Jose, Rangel-Valdez, Nelson, De-la-Torre, Miguel, Avila-George, Himer

“…In combinatorial optimization, the more complex a problem is, the more challenging it becomes, usually causing most research to focus on creating solvers for larger cases…”
Get full text

ACORE: A Query Optimization Approach for Spark SQL Based on Cost Model and Markov Prediction Model by Su, Lanxin, Liu, Huiyong

“…Spark SQL is Spark’s module for working with structured data. However, there exist two problems that may impact its query execution efficiency: 1…”
Get full text

Spark SQL Query Optimization Based on Runtime Statistics Collection by Zhao, Yong, Chen, Rong

“…The Spark SQL system improves efficiency of execution by describing data analysis tasks and optimizing according to query optimization theory…”
Get full text

Optimization of Linear Recursive Queries in SQL by Ordonez, C.

“… This work focuses on the optimization of linear recursive queries in SQL. Query optimization is studied with two important graph problems…”
Get full text

Increase the effectiveness of search databases queries using the algorithm of bitmap scales by Nosova, T N, Kalugina, O B, Barankova, I I

“…Query optimization is an important part of any database application. The most effective method of an acceleration of search queries is use of index structures…”
Get full text

The use of Hints in SQL-Nested query optimization by Taniar, David, Khaw, Hui Yee, Tjioe, Haorianto Cokrowijoyo, Pardede, Eric

“… In this paper, we study an optimization technique for SQL-Nested queries using Hints. Hints are additional comments that are inserted into an SQL statement for the purpose of instructing the optimizer to perform the specified operations…”
Get full text

A novel approach for SQL query optimization by Mithani, Fazal, Machchhar, Sahista, Jasdanwala, Fernaz

“… The structure of Structured Query Language (SQL) query also plays an enormous role in gauging the performance of execution…”
Get full text

Performance Analysis of PL/SQL Query Optimization Techniques by Kumar, Naveen, Kumaran, G Mayil Muthu, Kaur, Deepjot

“…Optimization in PL/SQL Programming is the preeminent aspect for database related applications built using PL/SQL code…”
Get full text

Database Optimization, Index Optimization On Ms Sql Tables Optimization Of Sql Queries And Views [Tender documents : T42225996]

Get full text

A Robust Optimization Approach of SQL-to-SPARQL Query Rewriting by Abatal, Ahmed, Bahaj, Mohamed, Nassima, Soussi

“… approaches have the same weakness. In fact, they convert directly the input SQL query to its equivalent SPARQL one without any pre-processing phase enabling the optimization of this input query filled by users before starting the conversion process…”
Get full text

A JIT Compilation-Based Unified SQL Query Optimization System by Myungcheol Lee, Miyoung Lee, ChangSoo Kim

“… We propose a unified SQL query optimization system using JIT compilation of OLTP, OLAP, and Stored Procedure workloads for enhanced performance on modern hardware…”
Get full text