Výsledky vyhledávání - SQL Query optimization

Query grouping–based multi‐query optimization framework for interactive SQL query engines on Hadoop Autor 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…”
Získat plný text

SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS = SQL QUERY OPTIMIZATION RESEARCH Autor 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…”
Získat plný text

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

“…Extended SQL with machine learning (ML) predicates, commonly referred to as SQL+…”
Získat plný text

SQL query optimization in Content Based Image Retrieval systems Autor 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…”
Získat plný text

An Experimental Study on SQL Query Structure Optimization Performance in MySQL, PostgreSQL, and Microsoft SQL Server Using Apache JMeter Autor 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…”
Získat plný text

The Examination of SQL Queries Efficiency in Chosen IT System Autor 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…”
Získat plný text

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection Autor 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…”
Získat plný text

Towards Exploratory Query Optimization for Template-Based SQL Workloads Autor 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…”
Získat plný text

Query Execution Optimization in Spark SQL Autor 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…”
Získat plný text

An Approach to Aid Decision-Making by Solving Complex Optimization Problems Using SQL Queries Autor 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…”
Získat plný text

ACORE: A Query Optimization Approach for Spark SQL Based on Cost Model and Markov Prediction Model Autor 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…”
Získat plný text

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

“…The Spark SQL system improves efficiency of execution by describing data analysis tasks and optimizing according to query optimization theory…”
Získat plný text

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

“… This work focuses on the optimization of linear recursive queries in SQL. Query optimization is studied with two important graph problems…”
Získat plný text

Increase the effectiveness of search databases queries using the algorithm of bitmap scales Autor 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…”
Získat plný text

The use of Hints in SQL-Nested query optimization Autor 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…”
Získat plný text

A novel approach for SQL query optimization Autor 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…”
Získat plný text

Performance Analysis of PL/SQL Query Optimization Techniques Autor 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…”
Získat plný text

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

Získat plný text

A Robust Optimization Approach of SQL-to-SPARQL Query Rewriting Autor 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…”
Získat plný text

A JIT Compilation-Based Unified SQL Query Optimization System Autor 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…”
Získat plný text