Index selection in relational databases

KY Whang - Foundations of Data Organization, 1987 - Springer
… of selecting a set of indexes that minimizes the transactionprocessing cost in relational
databases. … The index selection problem bas been studied extensively by many researchers. A …

Index selection in relational databases

S Choenni, H Blanken, T Chang - Proceedings of ICCI'93: 5th …, 1993 - ieeexplore.ieee.org
… for index selection to prove the dependency between primary and secondary index selection
We deal with relational databases which are stored on an external paged memory. The …

A knowledge-based approach for index selection in relational databases

YA Feldman, J Reouven - Expert Systems with Applications, 2003 - Elsevier
… We represent a solution to the index-selection problem by a set of indexes defined on the
tables of the application (an empty set is also a possible solution). Solutions are graded by two …

On the selection of secondary indices in relational databases

S Choenni, HM Blanken, T Chang - Data & knowledge engineering, 1993 - Elsevier
… rewrite the data pages (3) Update the relevant indices We concentrate on steps that influence
index selection. The first step of an operation of the workload is always the selection of the …

Physical database design for relational databases

S Finkelstein, M Schkolnick, P Tiberio - ACM Transactions on Database …, 1988 - dl.acm.org
… (The reasons why index selection is difficult are discussed further in Section 2.1.) Database
… We assume the reader is familiar with relational database technology and standard query …

Relational database index selection algorithm

R Boronski, G Bocewicz - … 21st International Conference, CN 2014, Brunów …, 2014 - Springer
indexing in the relational database systems. In contrast to known approaches [1, 2, 4, 6], that
consider indexing … as a group and to try to find good indices for a group as a whole. To the …

Near optimal multiple choice index selection for relational databases

TI Gündem - Computers & Mathematics with Applications, 1999 - Elsevier
… In this paper, we consider the problem of index selection for relational databases in the
presence of multiple candidates with different benefits and storage space requirements. We …

Index selection in relational databases

E Barcucci, A Chiuderi, R Pinzani, MC Verri - … Fundamentals of Database …, 1989 - Springer
… When planning a database, the problem of index selection is of particular interest. In this …
a function that calculates the transactions total cost when an index set is used. Our aim was to …

View indexing in relational databases

N Roussopoulos - ACM Transactions on Database Systems (TODS), 1982 - dl.acm.org
… for databases. Frequently accessed views of databases need to be supported by indexing to
enhance … This paper investigates the problem of selecting an optimal index set of views and …

Index selection on MapReduce relational-databases

F Alsayoud, A Miri - … First International Conference on Big Data …, 2015 - ieeexplore.ieee.org
… an index-selection tool on MapReduce’s relational-database … The proposed tool for optimal
index configuration would help … apply data mining techniques to return the optimal index set. …