GUIDE: Graphical User Interface for Database Exploration.

Harry K. T. Wong, Ivy Kuo: GUIDE: Graphical User Interface for Database Exploration. VLDB 1982: 22-32
  author    = {Harry K. T. Wong and
               Ivy Kuo},
  title     = {GUIDE: Graphical User Interface for Database Exploration},
  booktitle = {Eigth International Conference on Very Large Data Bases, September
               8-10, 1982, Mexico City, Mexico, Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1982},
  isbn      = {0-934613-14-1},
  pages     = {22-32},
  ee        = {db/conf/vldb/WongK82.html},
  crossref  = {DBLP:conf/vldb/82},
  bibsource = {DBLP,}


This paper describes a system which uses graph- ics devices as tools to interface to complex data- bases. The difficulties associated with using query languages for large, complex databases such as some of the statistical databases (e.g., Census data, energy data) are examined, We will describe a system con- taining features such as subject directories, help messages, zooming facilities to the relevant part of the database schema, and partial query formulation with intermediate results.

The system offers a graphics interface to the user. The database schema is displayed as a network of entity and relationship types. Queries can be expressed as traversal paths on this network. Partial queries (called "local queries") can be formulated and represented graphically and database retrieval results of any local query are available at any time. Local queries can be linked together to form larger queries and provide the basis for building queries in a piecemeal fashion. Parts of the schema can be selec- tively made visible or invisible and provide the basis of representing multiple levels of details of the schema.

Copyright © 1982 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 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Printed Edition

Eigth International Conference on Very Large Data Bases, September 8-10, 1982, Mexico City, Mexico, Proceedings. Morgan Kaufmann 1982, ISBN 0-934613-14-1
Contents CiteSeerX Google scholar BibTeX bibliographical record in XML


[Herot 1980]
Christopher F. Herot: Spatial Management of Data. ACM Trans. Database Syst. 5(4): 493-513(1980) CiteSeerX Google scholar BibTeX bibliographical record in XML
[McDonald & Stonebraker 1974]
Nancy H. McDonald, Michael Stonebraker: CUPID - The Friendly Query Language. ACM Pacific 1975: 127-131 CiteSeerX Google scholar BibTeX bibliographical record in XML
[Cattell 1980]
R. G. G. Cattell: An Entity-based Database User Interface. SIGMOD Conference 1980: 144-150 CiteSeerX Google scholar BibTeX bibliographical record in XML
[Zloof 1975]
[Chan & Shoshani 1981]
Paul Chan, Arie Shoshani: SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases. VLDB 1981: 553-563 CiteSeerX Google scholar BibTeX bibliographical record in XML
[Shoshani 1979]
Arie Shoshani: CABLE: A Chain-Based Language for the Entity-Relationship Model. ER 1979: 465-466 CiteSeerX Google scholar BibTeX bibliographical record in XML
[Johnson 1981]
Rowland R. Johnson: Modelling Summary Data. SIGMOD Conference 1981: 93-97 CiteSeerX Google scholar BibTeX bibliographical record in XML
[Smith 1977]
John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) CiteSeerX Google scholar BibTeX bibliographical record in XML
[Chen 1976]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) CiteSeerX Google scholar BibTeX bibliographical record in XML
[Held & Stonebraker 1975]
[Astrahan 1976]
Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson: System R: Relational Approach to Database Management. ACM Trans. Database Syst. 1(2): 97-137(1976) CiteSeerX Google scholar BibTeX bibliographical record in XML
[Benson & Kitous 1977]

Referenced by

  1. Eben M. Haber, Yannis E. Ioannidis, Miron Livny: OPOSSUM: Desk-Top Schema Management through Customizable Visualization. VLDB 1995: 527-538
  2. Marc Gyssens, Jan Paredaens, Jan Van den Bussche, Dirk Van Gucht: A Graph-Oriented Object Database Model. IEEE Trans. Knowl. Data Eng. 6(4): 572-586(1994)
  3. Lil Mohan, Rangasami L. Kashyap: A Visual Query Language for Graphical Interaction with Schema-Intensive Databases. IEEE Trans. Knowl. Data Eng. 5(5): 843-858(1993)
  4. Alfs T. Berztiss: The Query Language Vizla. IEEE Trans. Knowl. Data Eng. 5(5): 813-825(1993)
  5. Giuseppe Santucci, Carlo Batini, Giuseppe Di Battista: Multilevel Schema Integration. ER 1993: 327-338
  6. Peter Rosengren, Ulf Wingstedt, Marie Bern, Peeter Kool: ER-based Information Retrieval in a Mixed Database Environment. ER 1993: 426-437
  7. Takao Miura: Nesting Quantification in a Visual Data Manipulation Language. ER 1992: 226-242
  8. Gabriella Bono, Paolo Ficorilli: Natural Language Restatement of Queries Expressed in a Graphical Language. ER 1992: 357-374
  9. Annamaria Auddino, Yves Dennebouy, Yann Dupont, Edi Fontana, Stefano Spaccapietra, Zahir Tari: SUPER - Visual Interaction with an Object-Based ER Model. ER 1992: 340-356
  10. K. P. Tan, T. C. Tan, Raymund Y. M. Teo: AUTO-QUIZ: An Automatic ACCESS Statement Generator for QUIZ Query. DASFAA 1991: 347-355
  11. Tiziana Catarci, Giuseppe Santucci: GRASP: A Graphical System for Statistical Databases. SSDBM 1990: 148-162
  12. Marc Gyssens, Jan Paredaens, Dirk Van Gucht: A Graph-Oriented Object Model for Database End-User Interfaces. SIGMOD Conference 1990: 24-33
  13. Rakesh Agrawal, Narain H. Gehani, J. Srinivasan: OdeView: The Graphical Interface to Ode. SIGMOD Conference 1990: 34-43
  14. Kyu-Young Whang, Ashok Malhotra, Gary H. Sockut, Luanne M. Burns: Supporting Universal Quantification in a Two-Dimensional Database Query Language. ICDE 1990: 68-75
  15. Michel Kuntz, Rainer Melchert: Pasta-3's Graphical Query Language: Direct Manipulation, Cooperative Queries, Full Expressive Power. VLDB 1989: 97-105
  16. Michel Kuntz, Rainer Melchert: Ergonomic Schema Design and Browsing with More Semantics in the Pasta-3 Interface for E-R DBMSs. ER 1989: 419-433
  17. Martin Kracker, Erich J. Neuhold: Schema Independent Query Formulation. ER 1989: 387-401
  18. Masahide Ohtomo, Hideto Ikeda: Map-Oriented Visual Language: MOL. DASFAA 1989: 10-17
  19. Erik Malmborg: Design of the User-Interface for an Object-Oriented Statistical Data-Base. SSDBM 1988: 314-326
  20. Alessandro D'Atri, Fabrizio L. Ricci: Interpretation of Statistical Queries to Relational Databases. SSDBM 1988: 246-258
  21. Manoochehr Azmoodeh, Hongbo Du: GQL, A Graphical Query Language for Semantic Databases. SSDBM 1988: 259-277
  22. Tiziana Catarci, Giuseppe Santucci: Query by Diagramm: A Graphic Query System. ER 1988: 291-308
  23. Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987)
  24. T. R. Rogers, R. G. G. Cattell: Entity-Relationship Database User Interfaces. ER 1987: 353-365
  25. Darrell Woelk, Won Kim, Willis Luther: An Object-Oriented Approach to Multimedia Databases. SIGMOD Conference 1986: 311-325
  26. Daniel Bryce, Richard Hull: SNAP: A Graphics-based Schema Manager. ICDE 1986: 151-164
  27. Ramez Elmasri, James A. Larson: A Graphical Query Facility for ER Databases. ER 1985: 236-245
  28. Peter Lyngbæk, Dennis McLeod: A Personal Data Manager. VLDB 1984: 14-25
  29. Roger King, Stephen Melville: Ski: A Semantics-Knowledgeable Interface. VLDB 1984: 30-33
  30. Chaitanya K. Baru, Stanley Y. W. Su: Performance Evaluation of the Statistical Aggregation by Caterogization in the SM3 System. SIGMOD Conference 1984: 77-89
  31. Harry K. T. Wong: Micro and Macro Statistical/Scientific Database Management. ICDE 1984: 104-106
  32. James A. Larson: The Forms Pattern Language. ICDE 1984: 183-192
  33. Gerald A. Wilson, Eric A. Domeshek, Ellen L. Drascher, Jeffrey S. Dean: The Multipurpose Presentation System. VLDB 1983: 56-69
  34. David Beech, J. Samuel Feldman: The Integrated Data Model: A Database Perspective. VLDB 1983: 302-304
  35. Stanley Y. W. Su, Shamkant B. Navathe, Don S. Batory: Logical and Physical Modeling of Statistical Scientific Databases. SSDBM 1983: 251-263
  36. Maurizio Rafanelli, Fabrizio L. Ricci: Proposal of a Logical Model for Statistical Data Base. SSDBM 1983: 264-272
  37. Gultekin Özsoyoglu, Z. Meral Özsoyoglu: Features of a System for Statistical Databases. SSDBM 1983: 9-18
  38. Frank Olken: How Baroque Should a Statistical Database Management System Be? SSDBM 1983: 212-219
  39. Paul Chan, Susan J. Eggers, Fredric C. Gey, Harvard Holmes, Peter Kreps, John McCarthy, Deane Merrill, Frank Olken, Arie Shoshani, Harry K. T. Wong: Statistical Data Management Research at Lawrence Berkeley Laboratory. SSDBM 1983: 273-279
  40. Robert A. Burnett, Paula J. Cowley, James J. Thomas: Management and Display of Data Analysis Environments for Large Data Sets. SSDBM 1983: 22-31
  41. Zhi-Qian Zhang, Alberto O. Mendelzon: A Graphical Query Language for Entity-Relationship Databases. ER 1983: 441-448
  42. Arie Shoshani: Statistical Databases: Characteristics, Problems, and some Solutions. VLDB 1982: 208-222
  43. John L. McCarthy: Metadata Management for Large Statistical Databases. VLDB 1982: 234-243

Copyright © Mon Nov 2 21:17:55 2009 by Michael Ley (