Index Selection in Relational Databases

R.S. Choenni; Henk Blanken; S.C. Chang

doi:10.1109/ICCI.1993.315323

Index Selection in Relational Databases

R.S. Choenni
, Henk Blanken
, S.C. Chang

Databases (Former)

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › Academic › peer-review

32 Citations (Scopus)

443 Downloads (Pure)

Abstract

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

Original language	Undefined
Title of host publication	Proceedings of the 5th International Conference on Computing and Information (ICCI 1993)
Place of Publication	Washington, DC, USA
Publisher	IEEE
Pages	491-496
Number of pages	6
ISBN (Print)	0-8186-4212-2
DOIs	https://doi.org/10.1109/ICCI.1993.315323
Publication status	Published - May 1993
Event	5th International Conference on Computing and Information (ICCI 1993) - Sudbury, Ont., Canada Duration: 27 May 1993 → 29 May 1993

Publication series

Name
Publisher	IEEE

Conference

Conference	5th International Conference on Computing and Information (ICCI 1993)
Period	27/05/93 → 29/05/93
Other	27-29 May 1993

Keywords

IR-19316
METIS-119839
EWI-7199

Access to Document

10.1109/ICCI.1993.315323

Cite this

@inproceedings{edd406f1ceaf49efadc1c552050a1e95,

title = "Index Selection in Relational Databases",

abstract = "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",

keywords = "IR-19316, METIS-119839, EWI-7199",

author = "R.S. Choenni and Henk Blanken and S.C. Chang",

note = "Imported from EWI/DB PMS [db-utwente:inpr:0000003133]; 5th International Conference on Computing and Information (ICCI 1993) ; Conference date: 27-05-1993 Through 29-05-1993",

year = "1993",

month = may,

doi = "10.1109/ICCI.1993.315323",

language = "Undefined",

isbn = "0-8186-4212-2",

publisher = "IEEE",

pages = "491--496",

booktitle = "Proceedings of the 5th International Conference on Computing and Information (ICCI 1993)",

address = "United States",

}

TY - GEN

T1 - Index Selection in Relational Databases

AU - Choenni, R.S.

AU - Blanken, Henk

AU - Chang, S.C.

N1 - Imported from EWI/DB PMS [db-utwente:inpr:0000003133]

PY - 1993/5

Y1 - 1993/5

N2 - 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

AB - 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

KW - IR-19316

KW - METIS-119839

KW - EWI-7199

U2 - 10.1109/ICCI.1993.315323

DO - 10.1109/ICCI.1993.315323

M3 - Conference contribution

SN - 0-8186-4212-2

SP - 491

EP - 496

BT - Proceedings of the 5th International Conference on Computing and Information (ICCI 1993)

PB - IEEE

CY - Washington, DC, USA

T2 - 5th International Conference on Computing and Information (ICCI 1993)

Y2 - 27 May 1993 through 29 May 1993

ER -