OraGiST: How to Make User-Defined Indexing Become Usable and Useful

Publikation: Beitrag in Buch/Bericht/Sammelwerk/KonferenzbandAufsatz in KonferenzbandForschungPeer-Review

Autoren

  • Carsten Kleiner
  • Udo W. Lipeck
Forschungs-netzwerk anzeigen

Details

OriginalspracheEnglisch
Titel des SammelwerksDatenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz
UntertitelBTW 2003
Herausgeber/-innenGerhard Weikum, Harald Schoning, Erhard Rahm
Herausgeber (Verlag)Gesellschaft fur Informatik (GI)
Seiten324-333
Seitenumfang10
ISBN (elektronisch)3885793555
PublikationsstatusVeröffentlicht - 2003
VeranstaltungDatenbanksysteme für Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz, BTW 2003 - Leipzig, Deutschland
Dauer: 26 Feb. 200328 Feb. 2003

Publikationsreihe

NameLecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)
BandP-26
ISSN (Print)1617-5468

Abstract

In this article we present a concept for simplification of user-defined indexing for user-defined data types in object-relational database systems. The concept is based on a detailed analysis of user-defined indexing in ORDBS on one hand, and features of generalized search trees (GiST) as an extensible indexing framework on the other hand. It defines a minimal interface to be implemented in order to use GiST within ORDBS; this greatly simplifies the process of implementing user-defined indexes. The effectiveness of the approach is illustrated by performance experiments carried out on a prototypical implementation of our concept. For the experiments we have used new specialized spatial data types, that store spatial as well as thematic information within a single attribute. These data types facilitate advanced spatial analysis operators. The experiments show great performance improvements on these operators by using multidimensional user-defined index structures based on R-trees when compared to system-provided indexes.

ASJC Scopus Sachgebiete

Zitieren

OraGiST: How to Make User-Defined Indexing Become Usable and Useful. / Kleiner, Carsten; Lipeck, Udo W.
Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz: BTW 2003. Hrsg. / Gerhard Weikum; Harald Schoning; Erhard Rahm. Gesellschaft fur Informatik (GI), 2003. S. 324-333 (Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI); Band P-26).

Publikation: Beitrag in Buch/Bericht/Sammelwerk/KonferenzbandAufsatz in KonferenzbandForschungPeer-Review

Kleiner, C & Lipeck, UW 2003, OraGiST: How to Make User-Defined Indexing Become Usable and Useful. in G Weikum, H Schoning & E Rahm (Hrsg.), Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz: BTW 2003. Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI), Bd. P-26, Gesellschaft fur Informatik (GI), S. 324-333, Datenbanksysteme für Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz, BTW 2003, Leipzig, Deutschland, 26 Feb. 2003. <https://cs.emis.de/LNI/Proceedings/Proceedings26.html>
Kleiner, C., & Lipeck, U. W. (2003). OraGiST: How to Make User-Defined Indexing Become Usable and Useful. In G. Weikum, H. Schoning, & E. Rahm (Hrsg.), Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz: BTW 2003 (S. 324-333). (Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI); Band P-26). Gesellschaft fur Informatik (GI). https://cs.emis.de/LNI/Proceedings/Proceedings26.html
Kleiner C, Lipeck UW. OraGiST: How to Make User-Defined Indexing Become Usable and Useful. in Weikum G, Schoning H, Rahm E, Hrsg., Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz: BTW 2003. Gesellschaft fur Informatik (GI). 2003. S. 324-333. (Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)).
Kleiner, Carsten ; Lipeck, Udo W. / OraGiST : How to Make User-Defined Indexing Become Usable and Useful. Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz: BTW 2003. Hrsg. / Gerhard Weikum ; Harald Schoning ; Erhard Rahm. Gesellschaft fur Informatik (GI), 2003. S. 324-333 (Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)).
Download
@inproceedings{96b692b8c7ee40f49d21b4f0f23a6523,
title = "OraGiST: How to Make User-Defined Indexing Become Usable and Useful",
abstract = "In this article we present a concept for simplification of user-defined indexing for user-defined data types in object-relational database systems. The concept is based on a detailed analysis of user-defined indexing in ORDBS on one hand, and features of generalized search trees (GiST) as an extensible indexing framework on the other hand. It defines a minimal interface to be implemented in order to use GiST within ORDBS; this greatly simplifies the process of implementing user-defined indexes. The effectiveness of the approach is illustrated by performance experiments carried out on a prototypical implementation of our concept. For the experiments we have used new specialized spatial data types, that store spatial as well as thematic information within a single attribute. These data types facilitate advanced spatial analysis operators. The experiments show great performance improvements on these operators by using multidimensional user-defined index structures based on R-trees when compared to system-provided indexes.",
keywords = "advanced spatial analysis operators, data cartridge, object-relational databases, user-defined datatype, user-defined indexing",
author = "Carsten Kleiner and Lipeck, {Udo W.}",
note = "Publisher Copyright: {\textcopyright} 2003 Gesellschaft fur Informatik (GI). All rights reserved.; Database Systems for Business, Technology and Web. 10th BTW Conference, BTW 2003, BTW 2003 ; Conference date: 26-02-2003 Through 28-02-2003",
year = "2003",
language = "English",
series = "Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)",
publisher = "Gesellschaft fur Informatik (GI)",
pages = "324--333",
editor = "Gerhard Weikum and Harald Schoning and Erhard Rahm",
booktitle = "Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz",
address = "Germany",

}

Download

TY - GEN

T1 - OraGiST

T2 - Database Systems for Business, Technology and Web. 10th BTW Conference, BTW 2003

AU - Kleiner, Carsten

AU - Lipeck, Udo W.

N1 - Publisher Copyright: © 2003 Gesellschaft fur Informatik (GI). All rights reserved.

PY - 2003

Y1 - 2003

N2 - In this article we present a concept for simplification of user-defined indexing for user-defined data types in object-relational database systems. The concept is based on a detailed analysis of user-defined indexing in ORDBS on one hand, and features of generalized search trees (GiST) as an extensible indexing framework on the other hand. It defines a minimal interface to be implemented in order to use GiST within ORDBS; this greatly simplifies the process of implementing user-defined indexes. The effectiveness of the approach is illustrated by performance experiments carried out on a prototypical implementation of our concept. For the experiments we have used new specialized spatial data types, that store spatial as well as thematic information within a single attribute. These data types facilitate advanced spatial analysis operators. The experiments show great performance improvements on these operators by using multidimensional user-defined index structures based on R-trees when compared to system-provided indexes.

AB - In this article we present a concept for simplification of user-defined indexing for user-defined data types in object-relational database systems. The concept is based on a detailed analysis of user-defined indexing in ORDBS on one hand, and features of generalized search trees (GiST) as an extensible indexing framework on the other hand. It defines a minimal interface to be implemented in order to use GiST within ORDBS; this greatly simplifies the process of implementing user-defined indexes. The effectiveness of the approach is illustrated by performance experiments carried out on a prototypical implementation of our concept. For the experiments we have used new specialized spatial data types, that store spatial as well as thematic information within a single attribute. These data types facilitate advanced spatial analysis operators. The experiments show great performance improvements on these operators by using multidimensional user-defined index structures based on R-trees when compared to system-provided indexes.

KW - advanced spatial analysis operators

KW - data cartridge

KW - object-relational databases

KW - user-defined datatype

KW - user-defined indexing

UR - http://www.scopus.com/inward/record.url?scp=26844523852&partnerID=8YFLogxK

M3 - Conference contribution

AN - SCOPUS:26844523852

T3 - Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)

SP - 324

EP - 333

BT - Datenbanksysteme fur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz

A2 - Weikum, Gerhard

A2 - Schoning, Harald

A2 - Rahm, Erhard

PB - Gesellschaft fur Informatik (GI)

Y2 - 26 February 2003 through 28 February 2003

ER -