ACM SIGMOD Anthology VLDB dblp.uni-trier.de

A Signature Access Method for the Starburst Database System.

Walter W. Chang, Hans-Jörg Schek: A Signature Access Method for the Starburst Database System. VLDB 1989: 145-153
@inproceedings{DBLP:conf/vldb/ChangS89,
  author    = {Walter W. Chang and
               Hans-J{\"o}rg Schek},
  editor    = {Peter M. G. Apers and
               Gio Wiederhold},
  title     = {A Signature Access Method for the Starburst Database System},
  booktitle = {Proceedings of the Fifteenth International Conference on Very
               Large Data Bases, August 22-25, 1989, Amsterdam, The Netherlands},
  publisher = {Morgan Kaufmann},
  year      = {1989},
  isbn      = {1-55860-101-5},
  pages     = {145-153},
  ee        = {db/conf/vldb/ChangS89.html},
  crossref  = {DBLP:conf/vldb/89},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

This paper describes a new signature generation method for constructing multi-level signature files to support both relational queries which contain multiple conjunctive (AND) predicates and generic document text queries. We describe the major problems with traditional multi-level signature files andthen describe how to build multi-level signature files using a new composite method of parent signature generation. Performance of this signature generation scheme improves as more key fields areprovided in the query. A combinatorial error problem common to all multi-level signature structures isidentified and addressed. We show how a signature access method can provide query support for a large number of fields in a relation for which no index exists and can dramatically reduce the number of relation tuples that must be accessed during a normal scan. If one or more fields of the relation contain long field data such as text, thesame signature mechanism can also provide query support for text search predicates.

Copyright © 1989 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Printed Edition

Peter M. G. Apers, Gio Wiederhold (Eds.): Proceedings of the Fifteenth International Conference on Very Large Data Bases, August 22-25, 1989, Amsterdam, The Netherlands. Morgan Kaufmann 1989, ISBN 1-55860-101-5
CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

References

[Bayer77]
Rudolf Bayer, Mario Schkolnick: Concurrency of Operations on B-Trees. Acta Inf. 9: 1-21(1977) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Carter80]
Larry Carter, Mark N. Wegman: Universal Classes of Hash Functions (Extended Abstract). STOC 1977: 106-112 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Christodoulakis84]
Stavros Christodoulakis, Christos Faloutsos: Design Considerations for a Message File Server. IEEE Trans. Software Eng. 10(2): 201-210(1984) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Dadam83]
...
[Deppisch86]
Uwe Deppisch: S-Tree: A Dynamic Balanced Signature Index for Office Retrieval. SIGIR 1986: 77-87 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Faloutsos85a]
Christos Faloutsos: Signature files: Design and Performance Comparison of Some Signature Extraction Methods. SIGMOD Conference 1985: 63-82 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Faloutsos85b]
Christos Faloutsos, Stavros Christodoulakis: Design of a Signature File Method that Accounts for Non-Uniform Occurrence and Query Frequencies. VLDB 1985: 165-170 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Faloutsos87]
Christos Faloutsos, Stavros Christodoulakis: Optimal Signature Extraction and Information Loss. ACM Trans. Database Syst. 12(3): 395-428(1987) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Haas88]
...
[Harrison71]
...
[Korth82]
...
[Lehman89]
Tobin J. Lehman, Bruce G. Lindsay: The Starburst Long Field Manager. VLDB 1989: 375-383 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Lindsay87]
Bruce G. Lindsay, John McPherson, Hamid Pirahesh: A Data Management Extension Architecture. SIGMOD Conference 1987: 220-226 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Lohman88]
Guy M. Lohman: Grammar-like Functional Rules for Representing Query Optimization Alternatives. SIGMOD Conference 1988: 18-27 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Mohan89]
...
[Pfaltz80]
John L. Pfaltz, William J. Berman, Edgar M. Cagley: Partial-Match Retrieval Using Indexed Descriptor Files. Commun. ACM 23(9): 522-528(1980) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Prabhakar83]
...
[Roberts79]
...
[Sacks-Davies83]
Ron Sacks-Davis, Kotagiri Ramamohanarao: A two level superimposed coding scheme for partial match retrieval. Inf. Syst. 8(4): 273-289(1983) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Sacks-Davies87]
Ron Sacks-Davis, Alan J. Kent, Kotagiri Ramamohanarao: Multikey Access Methods Based on Superimposed Coding Techniques. ACM Trans. Database Syst. 12(4): 655-696(1987) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Schek78]
...
[Schwarz86]
Peter M. Schwarz, Walter Chang, Johann Christoph Freytag, Guy M. Lohman, John McPherson, C. Mohan, Hamid Pirahesh: Extensibility in the Starburst Database System. OODBS 1986: 85-92 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Severance76]
Dennis G. Severance, Guy M. Lohman: Differential Files: Their Application to the Maintenance of Large Data Bases (Abstract). SIGMOD Conference 1976: 43 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Stonebraker80]
Michael Stonebraker: Retrospection on a Database System. ACM Trans. Database Syst. 5(2): 225-240(1980) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Wilms88]
Paul F. Wilms, Peter M. Schwarz, Hans-Jörg Schek, Laura M. Haas: Incorporating Data Types in an Extensible Database Architecture. JCDKB 1988: 180-192 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

Copyright © Tue Mar 16 02:22:00 2010 by Michael Ley (ley@uni-trier.de)