Indexing Set-Valued Attributes with a Multi-level Extendible Hashing Scheme

We present an access method for set-valued attributes that is based on a multi-level extendible hashing scheme. This scheme avoids exponential directory growth for skewed data and thus generates a much smaller number of subqueries for query sets (so far fast-growing directories have prohibited hash-based index structures for set-valued retrieval). We demonstrate the advantages of our scheme over regular extendible hashing both analytically and experimentally. We also implemented a prototype and briefly summarize the results of our experimental evaluation.

[1]  Ronald Fagin,et al.  Extendible hashing—a fast access method for dynamic files , 1979, ACM Trans. Database Syst..

[2]  Yannis Manolopoulos,et al.  Improved Methods for Signature-Tree Construction , 2000, Comput. J..

[3]  Michael Stonebraker,et al.  Object-Relational DBMSs: The Next Great Wave , 1995 .

[4]  David Maier,et al.  Indexing in an Object-Oriented DBMS , 1986, OODBS.

[5]  Hiroyuki Kitagawa,et al.  Evaluation of signature files as set access facilities in OODBs , 1993, SIGMOD '93.

[6]  Uwe Deppisch,et al.  S-tree: a dynamic balanced signature index for office retrieval , 1986, SIGIR '86.

[7]  Joseph M. Hellerstein,et al.  THE RD-TREE: AN INDEX STRUCTURE FOR SETS , 1997 .

[8]  Ian H. Witten,et al.  Managing gigabytes 2nd edition , 1999 .

[9]  Yannis Manolopoulos,et al.  Hierarchical Bitmap Index: An Efficient and Scalable Indexing Technique for Set-Valued Attributes , 2003, ADBIS.

[10]  이영식 Communication 으로서의 영어교육 , 1986 .

[11]  Sven Helmer,et al.  A Robust Scheme for Multilevel Extendible Hashing , 2003, ISCIS.

[12]  David Thomas,et al.  The Art in Computer Programming , 2001 .

[13]  Guido Moerkotte,et al.  Access Support Relations: An Indexing Method for Object Bases , 1992, Inf. Syst..

[14]  Panayiotis Bozanis,et al.  Signature-based structures for objects with set-valued attributes , 2002, Inf. Syst..

[15]  Christos Faloutsos,et al.  Signature files: an access method for documents and its analytical performance evaluation , 1984, TOIS.

[16]  S. Griffis EDITOR , 1997, Journal of Navigation.

[17]  Elisa Bertino,et al.  Indexing Techniques for Queries on Nested Objects , 1989, IEEE Trans. Knowl. Data Eng..

[18]  J. E. Ash,et al.  Communication, Storage and Retrieval of Chemical Information , 1985 .

[19]  Donald E. Knuth,et al.  Sorting and Searching , 1973 .

[20]  David Jordan,et al.  The Object Database Standard: ODMG 2.0 , 1997 .

[21]  Kotagiri Ramamohanarao,et al.  Inverted files versus signature files for text indexing , 1998, TODS.

[22]  Martin Will,et al.  Fully Automated Structure Elucidation - A Spectroscopist's Dream Comes True , 1996, J. Chem. Inf. Comput. Sci..

[23]  Donald E. Knuth,et al.  The art of computer programming: sorting and searching (volume 3) , 1973 .

[24]  Jiawei Han,et al.  Join Index Hierarchies for Supporting Efficient Navigations in Object-Oriented Databases , 1994, VLDB.

[25]  Donald E. Knuth,et al.  The Art of Computer Programming: Volume 3: Sorting and Searching , 1998 .

[26]  Sea Ling,et al.  Describing Web Service Architectures through Design-by-Contract , 2003, ISCIS.

[27]  Per-Åke Larson,et al.  Linear Hashing with Partial Expansions , 1980, VLDB.

[28]  Sven Helmer,et al.  A performance study of four index structures for set-valued attributes of low cardinality , 2003, The VLDB Journal.