Search Results - "SQL Query optimization"

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

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

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

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…”
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. However, the…”
Get full text

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

“…The world's latest scenario suggests that the database size will pilling-up epidemically. Due to this, requirement of larger database is eminent. Furthermore,…”
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. PL/SQL statement/Query can be written in…”
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

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

SQL Query Optimization Methods of Relational Database System by 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…”
Get full text

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

“…Digital libraries and research repositories require an efficient retrieval mechanism for author-specific publication data. Conventional SQL queries, such as…”
Get full text

External optimization of SQL-query under conditions of databases structural uncertainty by 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…”
Get full text

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

Get full text

Performance Issues and Query Optimization in Big Multidimensional Data by Kiruthika, Jay, Khaddaj, Souheil

“…SQL queries for big-data and multidimensional data need to be carefully coded to get maximum benefit of optimization and to improve the performance of the…”
Get full text

SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS by Sinickas, Henrikas

“…Fast improvement of information systems causes the increase of data quantity processed by them. Databases are an integral part of information systems that…”
Get full text

Enhancing database performance through SQL optimization, parallel processing and GPU integration by Nuriev, Marat, Zaripova, Rimma, Sinicin, Alexey, Chupaev, Andrey, Shkinderov, Maksim

“…) through the lens of SQL query optimization, parallel processing, and the integration of graphics processing units (GPUs…”
Get full text

Fundamentals of Analytics Engineering by Gligorevic Jovan, Wilde Dumky De, Perafan Juan Manuel, Benninga Lasse, Pereira Taís Laurindo, Granados Lopez Ricardo Angel, Kassapian Fanny

“… After conquering data ingestion and techniques for data quality and scalability, you'll learn about techniques such as data cleaning transformation, data modeling, SQL query optimization and reuse…”
Get full text

Cross-language optimizations in big data systems: a case study of SCOPE by Selakovic, Marija, Barnett, Michael, Musuvathi, Madan, Mytkowicz, Todd

“… SQL query optimization has enjoyed a rich and fruitful history, however, most research and commercial optimization engines treat non-relational code as a black-box and thus are unable to optimize…”
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

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