GUIDE: Graphical User Interface for Database Exploration.

@inproceedings{DBLP:conf/vldb/WongK82,
  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, http://dblp.uni-trier.de}
}

Abstract

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

• Download PDF file (www.vldb.org, Darmstadt, Germany)
• Download PDF file (www.acm.org, New York, USA)

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/vldb7588 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

Printed Edition

References

[Herot 1980]

Christopher F. Herot: Spatial Management of Data. ACM Trans. Database Syst. 5(4): 493-513(1980) BibTeX

[McDonald & Stonebraker 1974]

Nancy H. McDonald, Michael Stonebraker: CUPID - The Friendly Query Language. ACM Pacific 1975: 127-131 BibTeX

[Cattell 1980]

R. G. G. Cattell: An Entity-based Database User Interface. SIGMOD Conference 1980: 144-150 BibTeX

[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 BibTeX

[Shoshani 1979]

Arie Shoshani: CABLE: A Chain-Based Language for the Entity-Relationship Model. ER 1979: 465-466 BibTeX

[Johnson 1981]

Rowland R. Johnson: Modelling Summary Data. SIGMOD Conference 1981: 93-97 BibTeX

[Smith 1977]

John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX

[Chen 1976]

Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX

[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) BibTeX

[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