Foundations of visual metaphors for schema display

Many aspects of database systems have been improved by Graphical User Interfaces (GUIs). One area that has not received adequate attention in GUI research is the visual presentation of schemas, despite the increasingly important role that schemas play in database design and operation. Schema visualizations are valuable for viewing and manipulating both the schema and the information captured by it. In this paper, we describe a framework that formalizes the process of visualizing database schemas or any similar structured information. It is based on the concepts of adata model capturing schemas, avisual model capturing visualizations, and avisual metaphor that defines a mapping between the two models. This formal description of the mapping between a schema and its visualization permits straightforward declaration of visual metaphors, and provides criteria to evaluate metaphors as to their ability to correctly visualize a schema. Given a visual metaphor, the framework divides visual information into that which has meaning relative to the data model, that which has meaning to the user but not to the data model, and that which is only aesthetic. This separation permits better use of aesthetic information, resulting in richer visualizations. As a whole, we believe that the formalism provides the foundations on which better schema visualization tools can be built.

[1]  Alberto O. Mendelzon,et al.  GraphLog: a visual formalism for real life recursion , 1990, PODS '90.

[2]  Mark A. Linton,et al.  Interviews: A C++ graphical interface toolkit , 1988 .

[3]  Jürgen Ziegler,et al.  Generating user interfaces from data models and dialogue net specifications , 1993, INTERCHI.

[4]  Jean Vanderdonckt,et al.  Encapsulating knowledge for intelligent automatic interaction objects selection , 1993, INTERCHI.

[5]  Prasun Dewan,et al.  An approach to support automatic generation of user interfaces , 1990, TOPL.

[6]  Miron Livny,et al.  Conceptual Schemas: Multi-faceted Tools for Desktop Scientific Experiment Management , 1992, Int. J. Cooperative Inf. Syst..

[7]  Roger King,et al.  Building reusable data representations with FaceKit , 1992, SGMD.

[8]  ÖzsoyoğluGultekin,et al.  Query processing techniques in the summary-table-by-example database query language , 1989 .

[9]  Michel Kuntz,et al.  Pasta-3's Graphical Query Language: Direct Manipulation, Cooperative Queries, Full Expressive Power , 1989, VLDB.

[10]  Edward Rolf Tufte,et al.  The visual display of quantitative information , 1985 .

[11]  Daniel Bryce,et al.  SNAP: A graphics-based schema manager , 1986, 1986 IEEE Second International Conference on Data Engineering.

[12]  Moshé M. Zloof Query-by-example: the invocation and definition of tables and forms , 1975, VLDB '75.

[13]  Keng Siau,et al.  Visual knowledge query language as a front-end to relational systems , 1991, [1991] Proceedings The Fifteenth Annual International Computer Software & Applications Conference.

[14]  Jan Van den Bussche,et al.  An overview of GOOD , 1992, SGMD.

[15]  Harry K. T. Wong,et al.  GUIDE: Graphical User Interface for Database Exploration , 1982, VLDB.

[16]  Sandra Heiler,et al.  G-WHIZ, a Visual Interface for the Functional Model with Recursion , 1985, VLDB.

[17]  A. Desai Narasimhalu,et al.  Towards a Visual Language for an Object-Oriented Multi-Media Database System , 1989, VDB.

[18]  Ping Luo,et al.  Beyond interface builders: model-based interface tools , 1993, INTERCHI.

[19]  Amihai Motro,et al.  BAROQUE: a browser for relational databases , 1986, TOIS.

[20]  David Maier,et al.  Supporting display generation for complex database objects , 1992, SGMD.

[21]  Eben M. Haber,et al.  Bulletin of the Technical Committee on Data Engineering Special Issue on Scientific Databases Conference and Journal Notices Editorial Board Editor-in-chief Tc Executive Committee Important Membership Message Electronic Enrollment Procedure Alternative Enrollment Procedure the Evolution of the Bulle , 2022 .

[22]  Masahito Hirakawa,et al.  IconicBrowser: An Iconic Retrieval System for Object-Oriented Databases , 1990, J. Vis. Lang. Comput..

[23]  Lilly Koltun,et al.  TUFTE, Envisioning Information , 1991 .

[24]  Tiziana Catarci,et al.  Visual Query Systems: A Taxonomy , 1991, VDB.

[25]  Gultekin Özsoyoglu,et al.  Query processing techniques in the summary-table-by-example database query language , 1989, TODS.

[26]  Andrew U. Frank,et al.  A Formalization of Metaphors and Image-Schemas in User Interfaces , 1991 .

[27]  Andrew U. Frank,et al.  Towards a Spatial Query Language: User Interface Considerations , 1988, VLDB.

[28]  Richard N. Taylor,et al.  Separations of concerns in the Chiron-1 user interface development and management system , 1993, INTERCHI.

[29]  Eben M. Haber,et al.  Graphical user interfaces for the management of scientific experiments and data , 1992, SGMD.

[30]  Tiziana Catarci,et al.  Iconic and diagrammatic interfaces: an integrated approach , 1991, Proceedings 1991 IEEE Workshop on Visual Languages.

[31]  Lawrence A. Rowe,et al.  The Picasso Application Framework , 1990 .

[32]  Arthur J. Benjamin,et al.  A visual tool for managing relational databases , 1986, 1986 IEEE Second International Conference on Data Engineering.

[33]  James A. Larson,et al.  A Graphical Query Facility for ER Databases , 1985, ER.

[34]  Brad A. Myers,et al.  Marquise: creating complete user interfaces by demonstration , 1993, CHI '93.

[35]  Edward R. Tufte,et al.  Envisioning Information , 1990 .

[36]  Renée J. Miller,et al.  The Use of Information Capacity in Schema Integration and Translation , 1993, VLDB.

[37]  Brad A. Myers INCENSE: A system for displaying data structures , 1983, SIGGRAPH.

[38]  大野 義夫,et al.  Computer Graphics : Principles and Practice, 2nd edition, J.D. Foley, A.van Dam, S.K. Feiner, J.F. Hughes, Addison-Wesley, 1990 , 1991 .

[39]  P. Fayers,et al.  The Visual Display of Quantitative Information , 1990 .

[40]  James D. Foley,et al.  A second generation user interface design environment: the model and the runtime architecture , 1993, INTERCHI.

[41]  Isabel F. Cruz,et al.  DOODLE: a visual language for object-oriented databases , 1992, SIGMOD '92.

[42]  Renée J. Miller,et al.  Schema equivalence in heterogeneous systems: bridging theory and practice , 1994, Inf. Syst..

[43]  Patrick Borras,et al.  Building user interfaces for database applications: the O2 experience , 1992, SGMD.

[44]  Takao Miura A visual data manipulation language for a semantic data model , 1991, [1991] Proceedings The Fifteenth Annual International Computer Software & Applications Conference.

[45]  Andrew U. Frank,et al.  Specifying metaphors algebraically , 1991, SGCH.

[46]  Herman Lam,et al.  A graphical interface for an object-oriented query language , 1990, Proceedings., Fourteenth Annual International Computer Software and Applications Conference.

[47]  James D. Foley,et al.  Providing high-level control and expert assistance in the user interface presentation design , 1993, INTERCHI.

[48]  David Maier,et al.  Displaying Database Objects , 1986, Expert Database Conf..

[49]  Thomas Ertl,et al.  Computer Graphics - Principles and Practice, 3rd Edition , 2014 .

[50]  Narain H. Gehani,et al.  OdeView: the graphical interface to Ode , 1990, SIGMOD '90.

[51]  Roger King,et al.  FaceKit: A Database Interface Design Toolkit , 1989, VLDB.

[52]  Roger King,et al.  Freeform: A User-Adaptable Form Management System , 1987, VLDB.

[53]  Tiziana Catarci,et al.  QBD*: A Graphical Query Language with Recursion , 1989, IEEE Trans. Software Eng..

[54]  Claudia Bauzer Medeiros,et al.  Interactive manipulation of object-oriented views , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[55]  Terry E. Weymouth,et al.  Semantic Queries with Pictures: The VIMSYS Model , 1991, VLDB.

[56]  Michael Stonebraker,et al.  TIMBER: A Sophisticated Relation Browser (Invited Paper) , 1982, VLDB.

[57]  Peter N. Creasy,et al.  ENIAM: A More Complete Conceptual Schema Language , 1989, VLDB.