An overview of query optimization in relational systems

S Chaudhuri - Proceedings of the seventeenth ACM SIGACT …, 1998 - dl.acm.org
1. OBJECTIVE Them has been cxtensivc work in query optimization since the enrly '70s. It is
hard to capture the breadth and depth of this large body of work in a short article. Therefore, I …

Query optimization in database systems

M Jarke, J Koch - ACM Computing surveys (CsUR), 1984 - dl.acm.org
These methods are presented in the framework of a general query evaluation procedure
using the relational calculus representation of queries. In addition, nonstandard query …

[图书][B] Fundamentos de bases de datos

A Silberschatz, HF Korth, S Sudarshan, FS Pérez… - 2002 - academia.edu
• Bases de datos relacionales (Capítulos 4 al 7). El Capítulo 4 se centra en el lenguaje
relacional orientado al usuario de mayor influencia: SQL. El Capítulo 5 cubre otros dos …

R* optimizer validation and performance evaluation for local queries

LF Mackert, GM Lohman - Proceedings of the 1986 ACM SIGMOD …, 1986 - dl.acm.org
Few database query optimizer models have been validated against actual performance.
This paper presents the methodology and results of a thorough validation of the optimizer …

Data allocation in distributed database systems

PMG Apers - ACM Transactions on Database Systems (TODS), 1988 - dl.acm.org
The problem of allocating the data of a database to the sites of a communication network is
investigated. This problem deviates from the well-known file allocation problem in several …

Statistical profile estimation in database systems

MV Mannino, P Chu, T Sager - ACM Computing Surveys (CSUR), 1988 - dl.acm.org
A statistical profile summarizes the instances of a database. It describes aspects such as the
number of tuples, the number of values, the distribution of values, the correlation between …

Query optimization for parallel execution

S Ganguly, W Hasan, R Krishnamurthy - Proceedings of the 1992 ACM …, 1992 - dl.acm.org
The decreasing cost of computing makes it economically viable to reduce the response time
of decision support queries by using parallel execution to exploit inexpensive resources …

Apache hive: From mapreduce to enterprise-grade big data warehousing

J Camacho-Rodríguez, A Chauhan, A Gates… - Proceedings of the …, 2019 - dl.acm.org
Apache Hive is an open-source relational database system for analytic big-data workloads.
In this paper we describe the key innovations on the journey from batch tool to fully fledged …

A PSO and a Tabu search heuristics for the assembly scheduling problem of the two-stage distributed database application

A Allahverdi, FS Al-Anzi - Computers & Operations Research, 2006 - Elsevier
The assembly flowshop scheduling problem has been addressed recently in the literature.
There are many problems that can be modeled as assembly flowshop scheduling problems …

Distributed query processing

CT Yu, CC Chang - ACM computing surveys (CSUR), 1984 - dl.acm.org
In this paper, various techniques for optimizing queries in distributed databases are
presented. Although no attempt is made to cover all proposed algorithms on this topic, quite …