Results 1  10
of
10
DB2 Advisor: An optimizer smart enough to recommend its own indexes
 In ICDE
, 2000
"... This paper introduces the concept of letting an RDBMS Optimizer optimize its own environment. In our project, we have used the DB2 Optimizer to tackle the index selection problem, a variation of the knapack problem. This paper will discuss our implementation of index recommendation, the user interfa ..."
Abstract

Cited by 79 (5 self)
 Add to MetaCart
This paper introduces the concept of letting an RDBMS Optimizer optimize its own environment. In our project, we have used the DB2 Optimizer to tackle the index selection problem, a variation of the knapack problem. This paper will discuss our implementation of index recommendation, the user interface, and provide measurements on the quality of the recommended indexes. 1.
Physical Database Design Decision Algorithms and Concurrent Reorganization for Parallel Database Systems
, 1997
"... Stringent performance requirements in DB applications have led to the use of parallelism for database processing. To allow the database system to take advantage of the performance of parallel sharednothing systems, the physical DB design must be appropriate for the DB structure and the workload. We ..."
Abstract

Cited by 10 (1 self)
 Add to MetaCart
Stringent performance requirements in DB applications have led to the use of parallelism for database processing. To allow the database system to take advantage of the performance of parallel sharednothing systems, the physical DB design must be appropriate for the DB structure and the workload. We develop decision algorithms that will select a good physical DB design both when the DB is first loaded into the system (static decision) and while the DB is being used by the workload (dynamic decision). Our decision algorithms take the database structure, workload, and system characteristics as inputs. The static (or initial) physical DB design decision algorithm involves: • selecting a partitioning attribute for each relation that determines how the relation is fragmented across the nodes (allowing for high I/O bandwidth); • selecting indexes on the relation attributes to allow faster accesses compared to sequential file scans; • selecting the attributes by which to cluster a relation in order to take advantage of the prefetching and caching involved in I/O access; • grouping of relations to allow DB operations (joins) on relation pairs to be executed locally
On the Selection of Secondary Indices in Relational Databases
, 1993
"... An important problem in the physical design of databases is the selection of secondary indices. In general, this problem can not be solved in an optimal way due to the complexity of the selection process. Often use is made of heuristics such as the wellknown ADD and DROP algorithms. In this paper i ..."
Abstract

Cited by 10 (1 self)
 Add to MetaCart
An important problem in the physical design of databases is the selection of secondary indices. In general, this problem can not be solved in an optimal way due to the complexity of the selection process. Often use is made of heuristics such as the wellknown ADD and DROP algorithms. In this paper it will be shown that frequently used cost functions can be classified as super or submodular functions. For these functions several mathematical properties have been derived which reduce the complexity of the index selection problem. These properties will be used to develop a tool for physical database design and also give a mathematical foundation for the success of the beforementioned ADD and DROP algorithms. Keywords: Physical database design, Secondary index selection, ADD and DROP algorithms, Supermodular functions, Submodular functions. 1 Introduction Physical database design is an important step in designing databases and aims to generate efficient storage structures for the data....
A Genetic Algorithm for the Index Selection Problem
 In Applications of Evolutionary Computing
, 2003
"... This paper considers the problem of minimizing the response time for a given database workload by a proper choice of indexes. This problem is NPhard and known in the literature as the Index Selection Problem (ISP). ..."
Abstract

Cited by 7 (0 self)
 Add to MetaCart
This paper considers the problem of minimizing the response time for a given database workload by a proper choice of indexes. This problem is NPhard and known in the literature as the Index Selection Problem (ISP).
Separating Lifted OddHole Inequalities to Solve the Index Selection Problem
 Discrete Applied Mathematics
, 1998
"... The Index Selection Problem (ISP) is a phase of fundamental importance in the physical design of databases, calling for a set of indexes to be built in a database so as to minimize the overall execution time for a given database workload. The problem is a generalization of the wellknown Uncapacitat ..."
Abstract

Cited by 5 (0 self)
 Add to MetaCart
The Index Selection Problem (ISP) is a phase of fundamental importance in the physical design of databases, calling for a set of indexes to be built in a database so as to minimize the overall execution time for a given database workload. The problem is a generalization of the wellknown Uncapacitated Facility Location Problem (UFLP). In [6], we formulate ISP as a set packing problem, showing that our mathematical model contains all the clique inequalities, and describe a branchandcut algorithm based on the separation of oddhole inequalities. In this paper, we describe an effective exact separation procedure for a suitablydefined family of lifted oddhole inequalities, obtained by applying a ChvátalGomory derivation to the clique inequalities. Our analysis goes in the direction of determining a new class of inequalities over which ecient separation is possible, rather than introducing new classes of (facetde ning) inequalities that later turn out to be difficult to separate. Our separation procedure is embedded within our branchandcut algorithm for the exact solution of ISP. Computational results on two different classes of instances are given, showing the e ectiveness of the new approach. We also test our algorithm on UFLP instances both taken from the literature and randomly generated.
Index Selection in Relational Databases
 Proc. International Conference on Computing and Information
, 1993
"... Intending to develop a tool which aims to support the physical design of relational databases can not be done without considering the problem of index selection. Generally the problem is split into a primary and secondary index selection problem and the selection is done per table. Whereas much atte ..."
Abstract

Cited by 3 (1 self)
 Add to MetaCart
Intending to develop a tool which aims to support the physical design of relational databases can not be done without considering the problem of index selection. Generally the problem is split into a primary and secondary index selection problem and the selection is done per table. Whereas much attention has been paid on the selection of secondary indices relatively less is known about the selection of a primary index and the relation between them. These are exactly the topics of this paper. 1 Introduction At the University of Twente in cooperation with the G.A.K. a tool is being developed which aims to support the physical design of relational databases [2]. A problem of considerable interest in the physical design of databases is the selection of a good set of indices. Indices can be considered as auxiliary files that allow to retrieve tuples satisfying certain selection predicates without having to examine the whole relation. On the other hand, updating the database causes an index...
A BranchandCut Algorithm for the Index Selection Problem
, 1996
"... The Index Selection Problem (ISP) is a phase of fundamental importance in the physical design of databases, calling for a set of indexes to be built in a database so as to minimize the overall execution time for a given database workload. The problem is a generalization of the wellknown Uncapaci ..."
Abstract

Cited by 2 (0 self)
 Add to MetaCart
The Index Selection Problem (ISP) is a phase of fundamental importance in the physical design of databases, calling for a set of indexes to be built in a database so as to minimize the overall execution time for a given database workload. The problem is a generalization of the wellknown Uncapacitated Facility Location Problem (UFLP). We formulate ISP as a set packing problem, showing that our mathematical model contains all the clique inequalities (whose number is polynomial). The upper bound provided by solving the LP relaxation of this model turns out to be quite bad for some instances. We therefore face the problem of strengthening this relaxation by means of additional valid inequalities. In particular, we describe an effective exact separation procedure for a suitablydefined family of lifted oddhole inequalities, obtained by applying a ChvatalGomory derivation to the clique inequalities. These results are used within a branchandcut algorithm for the exact soluti...
Automatic Configuration for IBM DB2 Universal Database: Compressing years of performance tuning experience into seconds of execution
 University of Leipzig
"... Compressing years of performance tuning experience into seconds of execution ..."
Abstract

Cited by 1 (1 self)
 Add to MetaCart
Compressing years of performance tuning experience into seconds of execution
Algorithms Based on LP Relaxations for Combinatorial Optimization Problems
"... We survey the main results presented in the author's Ph.D Thesis [12], which addresses the use of Linear Programming (LP) relaxations within exact and heuristic algorithms for the solution of some Combinatorial Optimization (CO) problems arising from reallife applications. It is well known that ..."
Abstract

Cited by 1 (0 self)
 Add to MetaCart
We survey the main results presented in the author's Ph.D Thesis [12], which addresses the use of Linear Programming (LP) relaxations within exact and heuristic algorithms for the solution of some Combinatorial Optimization (CO) problems arising from reallife applications. It is well known that CO problems admit several possible Integer LP (ILP) formulations, and the corresponding LP relaxations may provide bounds of quite different quality. In all cases considered in the thesis, the dimension of the formulations used, i.e., the number of constraints and/or variables, is so large to make a blackbox use of an LP solver completely impractical. The main practical application of the work presented in the thesis is the design of the algorithmic part of the crew management system of the Italian railways. In particular, we deal with the effective solution of very large set covering and crew rostering problems. We also present novel methodologies and results which may have some impact in the solution of a wide spectrum of practical problems, and effective exact algorithms for two important realworld CO problems, namely the problem of selecting the indexes to be constructed in a database and the problem of sorting a permutation by the minimum number of reversals, which has application in genome rearrangements.
Index Configurations in ObjectOriented Databases
"... Several indexing techniques have been proposed to accelerate database operations in objectoriented databases. A database operation gives rise to the processing of a path. We address the problem of optimal index configuration for a given logical schema, the workload defined on the schema and some ot ..."
Abstract
 Add to MetaCart
Several indexing techniques have been proposed to accelerate database operations in objectoriented databases. A database operation gives rise to the processing of a path. We address the problem of optimal index configuration for a given logical schema, the workload defined on the schema and some other database characteristics such as the cardinality of a class, page size, etc. As will be shown an optimal index configuration for the workload can be achieved by splitting the paths into subpaths and by indexing each subpath optimal. For the moment we take a limited number of existing indexing techniques into account (simple index, inherited index, nested inheritedindex, multiindex, and multiinherited index) and the possibility of not indexing a (sub)path. However, the principles of the algorithm will remain the same adding more indexing techniques. 1 Introduction Objectoriented data models are based on some fundamentals concepts which will be discussed briefly. A real world entity i...