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

When temporary results meet intermediate index: An optimization technique of procedural SQL query processing Autor Rahman, Md Arif, Hashmi, Syed Jalaluddin, Gnanajothy, Kethsiya, Lee, Young-Koo

“…In modern data-intensive applications, optimizing procedural SQL queries in imperative programs is challenging because of inefficient access to intermediate results that are stored in temporary memory…”
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

SLQ: Lightweight-Detection LLM-Generation SQL SelfOptimization Framework Autor Zhu Tianyou, Qi Yaru, Jiang Kongchen, Sang Yanting, Yang Chao

“… To address this, we propose SLQ, a two-stage intelligent SQL optimization framework. First, a lightweight stacked-LSTM module pinpoints problematic statements…”
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

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

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

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

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

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

External optimization of SQL-query under conditions of databases structural uncertainty Autor Zagirnyak, M., Kostenko, P.

“… The method of automatic external SQL-query optimization is described. The method is based on the principle of building a local model of controlled process…”
Získat plný text

SQL Query Optimization Methods of Relational Database System Autor Dandan Li, Lu Han, Yi Ding

“…Oracle provides several options to aid performance, such as partitioning large tables, using materialized views, storing plan outlines, and many others. This…”
Získat plný text

Responsive Portfolio Website Using React for Research Paper Retrieval Autor V, Sandhiya, S, Jothilakshmi, Baraneedharan, P.

“… The proposed solution employs smart indexing algorithms and query optimization to incorporate a structured SQL database with an efficient React-based frontend…”
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

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

Získat plný text

Optimising SQL Queries Using Genetic Improvement Autor Callan, James, Petke, Justyna

“…Structured Query Language (SQL) queries are ubiquitous in modern software engineering…”
Získat plný text

US Patent Issued to Teradata US on March 20 for "Performing SQL Query Optimization by Simplifying Sub-Expressions" (California, Washington Inventors)

Získat plný text