article

Free access

Performance comparison of index structures for multi-key retrieval

Author:

Hans-Peter KriegelAuthors Info & Claims

ACM SIGMOD Record, Volume 14, Issue 2

Pages 186 - 196

https://doi.org/10.1145/971697.602284

Published: 01 June 1984 Publication History

PDF eReader

Abstract

In this paper, we report on a performance comparison of four software implemented index structures for multi-key retrieval the inverted file, the grid file and two variants of multidimensional B-trees It turns out that the recently suggested structures multidimensional B-tree and grid file outperform the traditional inverted file

References

[1]

{Car 75} Cárdenas, A F., Analysis and performance of inverted data base structures, Communications of the ACM 18, 5(May 1975), 253 -- 263.

Digital Library

Google Scholar

[2]

{Chr 81} Christodoulakis, S., Estimating Selectivities in Data Bases, PhD Thesis, Department of Computer Science, University of Toronto, also available as Technical Report CSRG-136 (December 1981).

Digital Library

Google Scholar

[3]

{Fl Pu 83} Flajolet, P. and Puech, C., Tree structures for partial match retrieval, Proc 24th Annual Symposium on Foundations of Computer Science, 282 -- 288 (1983)

Google Scholar

[4]

{Gu Kr 80} Guting, H. and Kriegel, H.P., Multidimensional B-trees. An efficient dynamic file structure for exact match queries, Proc. 10th GI Annual Conference, Informatik-Fachberichte 33, 375 -- 388, Springer, Berlin-Heidelberg-New York (1980).

Digital Library

Google Scholar

[5]

{Hi Ni 83} Hinrichs, K. and Nievergelt, J, The grid file: a data structure designed to support proximity queries on spatial objects, in Proc of the 9th Conference on Graphtheoretic Concepts in Computer Science (WG 83), Hanser Publishing Company (1983).

Google Scholar

[6]

{JSBS 83} Joshi, S.M., Sanyal, S., Banerjee, S. and Srikumar, S., Grid files for a relational database management system, Tata Institute of Fundamental Research, Bombay, India

Google Scholar

[7]

{Kri 82 a} Kriegel, H P., Dynamic tree-based index structures for associative retrieval in database systems, Habilitation Thesis, Abteilung Informatik, Universitat Dortmund, also available as Technical Report No. 147, Abteilung Informatik, Universitat Dortmund (1982).

Google Scholar

[8]

{Kri 82 b} Kriegel, H.P., Variants of multidimensional B-trees as dynamic index structures for associative retrieval in database systems, in Proc. of the 8th Conference on Graphtheoretic Concepts in Computer Science (WG 82), 109 -- 128, Hanser Publishing Company (1982).

Google Scholar

[9]

{KAHH 84} Kriegel, H.P., Anhaus, T., Huppe, E. and Hutter, N., Modified multidimensional B-trees: design, implementation and performance comparison, in preparation.

Google Scholar

[10]

{KMD 84} Kriegel, H.P., Mannss, R. and Overmars, M., The inverted file tree machine: efficient multi-key retrieval for VLSI, submitted for publication.

Google Scholar

[11]

{NHS 82} Nievergelt, J., Hinterberger, H. and Sevcik, K.C., The grid file: an adaptable, symmetric multi-key file structure, Report No. 46, Institut fur Informatik, ETH Zurich (revised July 1982), appeared in ACM Transactions on Database Systems Vol. 9, No. 1, 38 -- 71 (1984).

Digital Library

Google Scholar

[12]

{Sc Ou 82} Scheuermann, P. and Ouksel, M., Multidimensional B-trees for associative searching in database systems, Information Systems Vol. 7, No. 2, 123 -- 137 (1982).

Crossref

Google Scholar

Cited By

View all

Shekhar SYang THancock P(2008)An Intelligent Vehicle Highway Information Management SystemComputer-Aided Civil and Infrastructure Engineering10.1111/j.1467-8667.1993.tb00204.x8:3(175-198)Online publication date: 6-Nov-2008
https://doi.org/10.1111/j.1467-8667.1993.tb00204.x
Kriegel HSchiwietz MSchneider RSeeger B(2005)Performance comparison of point and spatial access methodsDesign and Implementation of Large Spatial Databases10.1007/3-540-52208-5_23(89-114)Online publication date: 31-May-2005
https://doi.org/10.1007/3-540-52208-5_23
Egenhofer MGlasgow JGunther OHerring JPeuquet D(1999)Progress in computational methods for representing geographical conceptsInternational Journal of Geographical Information Science10.1080/13658819924101213:8(775-796)Online publication date: Dec-1999
https://doi.org/10.1080/136588199241012
Show More Cited By

Index Terms

Performance comparison of index structures for multi-key retrieval
1. Information systems
  1. Information retrieval
    1. Document representation
2. Mathematics of computing
  1. Discrete mathematics
    1. Graph theory
      1. Trees

Index terms have been assigned to the content through auto-classification.

Recommendations

Performance comparison of index structures for multi-key retrieval
SIGMOD '84: Proceedings of the 1984 ACM SIGMOD international conference on Management of data

In this paper, we report on a performance comparison of four software implemented index structures for multi-key retrieval the inverted file, the grid file and two variants of multidimensional B-trees It turns out that the recently suggested structures ...
Comparison between the zeroth-order Randić index and the sum-connectivity index

The zeroth-order Randić index and the sum-connectivity index are very popular topological indices in mathematical chemistry. These two indices are based on vertex degrees of graphs and attracted a lot of attention in recent years. Recently Li and Li (...
Comparison between the Szeged index and the eccentric connectivity index

Let S z ( G ) and c ( G ) be the Szeged index and the eccentric connectivity index of a graph G , respectively. In this paper we obtain a lower bound on S z ( T ) - c ( T ) by double counting on some matrix and characterize the extremal graphs. From ...

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 14, Issue 2

June 1984

333 pages

ISSN:0163-5808

DOI:10.1145/971697

Issue’s Table of Contents

SIGMOD '84: Proceedings of the 1984 ACM SIGMOD international conference on Management of data
June 1984
339 pages
ISBN:0897911288
DOI:10.1145/602259
Conference Chair:
Diane Smith
Computer Corporation of America
,
Program Chair:
Beatrice Yormark
Yormark Enterprises, Inc., Alexandria, VA

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1984

Published in SIGMOD Volume 14, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

26
Total Citations
View Citations
561
Total Downloads

Downloads (Last 12 months)19
Downloads (Last 6 weeks)5

Reflects downloads up to 10 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Shekhar SYang THancock P(2008)An Intelligent Vehicle Highway Information Management SystemComputer-Aided Civil and Infrastructure Engineering10.1111/j.1467-8667.1993.tb00204.x8:3(175-198)Online publication date: 6-Nov-2008
https://doi.org/10.1111/j.1467-8667.1993.tb00204.x
Kriegel HSchiwietz MSchneider RSeeger B(2005)Performance comparison of point and spatial access methodsDesign and Implementation of Large Spatial Databases10.1007/3-540-52208-5_23(89-114)Online publication date: 31-May-2005
https://doi.org/10.1007/3-540-52208-5_23
Egenhofer MGlasgow JGunther OHerring JPeuquet D(1999)Progress in computational methods for representing geographical conceptsInternational Journal of Geographical Information Science10.1080/13658819924101213:8(775-796)Online publication date: Dec-1999
https://doi.org/10.1080/136588199241012
Segev AGunadhi H(1993)Efficient Indexing Methods for Temporal RelationsIEEE Transactions on Knowledge and Data Engineering10.1109/69.2242005:3(496-509)Online publication date: 1-Jun-1993
https://dl.acm.org/doi/10.1109/69.224200
Iyengar SRao NKashyap RVaishnavi V(1988)Multidimensional Data Structures: Review and OutlookAdvances in Computers Volume 2710.1016/S0065-2458(08)60257-0(69-119)Online publication date: 1988
https://doi.org/10.1016/S0065-2458(08)60257-0
Härder T(1987)Realisierung von operationalen SchnittstellenDatenbank-Handbuch10.1007/978-3-642-95388-0_3(163-335)Online publication date: 1987
https://doi.org/10.1007/978-3-642-95388-0_3
Hinrichs K(1985)Implementation of the grid file: Design concepts and experienceBIT10.1007/BF0193613725:4(569-592)Online publication date: 1-Dec-1985
https://dl.acm.org/doi/10.1007/BF01936137
Härder TReuter A(1985)Architektur von Datenbanksystemen füt Non-Standard-AnwendungenDatenbank-Systeme für Büro, Technik und Wissenschaft10.1007/978-3-642-70284-6_21(253-286)Online publication date: 1985
https://doi.org/10.1007/978-3-642-70284-6_21
Gayoso-Cabada JRodríguez-Cerezo DSierra J(2017)Browsing Digital Collections with Reconfigurable Faceted ThesauriComplexity in Information Systems Development10.1007/978-3-319-52593-8_5(69-86)Online publication date: 19-Apr-2017
https://doi.org/10.1007/978-3-319-52593-8_5
Kriegel HSeeger B(2005)Multidimensional order preserving linear hashing with partial expansionsICDT '8610.1007/3-540-17187-8_38(203-220)Online publication date: 2-Jun-2005
https://doi.org/10.1007/3-540-17187-8_38
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Index Terms

Recommendations