Experiences with SUPER, a Database Visual Environment

  • Annamaria Auddino
  • Eric Amiel
  • Bharat Bhargava
Conference paper


We present our experiences with building SUPER, a database environment based on a structurally object-oriented entity-relationship data model, called ERC+. SUPER is designed to be a semantically rich user-friendly front-end to existing relational or object-oriented database systems. We focus on the functionalities of visual direct manipulation interfaces of SUPER, in particular the schema and the query editors. We motivate and advocate the use of object-oriented toolboxes both to support the multi-threaded event-based dialogue of direct manipulation graphical interfaces and the implementation of data models.


Entity Type Database Schema Direct Manipulation Query Formulation Graphical Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    A. Albano, L. Alfò, S. Coluccini, R. Orsini: “An Overview of Sidereus, a Graphical Database Schema Editor for Galileo”, in Advances in Database Technology - EDBT ‘88, J. W. Schmidt, S. Ceri, M. Missikof eds., pp. 567–571, Springer-Verlag, 1988Google Scholar
  2. [2]
    E. Amiel: “Object-Oriented Programming for Data Model Implementation”, in Data Management - Current Trends, N. Prakash ed., pp. 223–243, Tata McGraw-Hill, 1990Google Scholar
  3. [3]
    A. Auddino, Y. Dennebouy, Y. Dupont, E. Fontana, S. Spaccapietra, Z. Tari: “SUPER: A Comprehensive Approach to DBMS Visual User Interfaces”, to appear in Proc. of the 2nd Working Conference on Visual Database Systems, Budapest, 1991Google Scholar
  4. [4]
    D. S. Batory et al.: “GENESIS: An Extensible Database Management System”, IEEE Transactions on Software Engineering, vol. 14, no. 11, pp. 1711–1730, November 1988CrossRefGoogle Scholar
  5. [5]
    D. Bryce, R. Hull: “SNAP, a Graphics-Based Schema Manager”, in Proc. of the 2nd IEEE Int’l Conf. on Data Engineering, pp. 151–164, Los Angeles, 1986Google Scholar
  6. [6]
    M. Carey et al.: “The Architecture of the EXODUS Extensible DBMS”, in Proc. Int’l Workshop on Object-Oriented Database Systems, pp. 52–65, 1986Google Scholar
  7. [7]
    T. Catarci, G. Santucci: “Query by Diagram: A Graphic Query System”, in Proceedings of the 7th Int’I Conf. on Entity-Relationship Approach, on. 157–174, Rome, 1988Google Scholar
  8. [8]
    E. Chan, F. Lochovsky: “A Graphical Database Design Aid Using the Entity-Relationship Model”, in Entity-Relationship Approach to Systems Analysis and Design, pp. 259–310, North-Holland, 1980Google Scholar
  9. [9]
    P. P. Chen: “The Entity-Relationship Model - Towards a Unified View of Data”, ACM Transactions on Database Systems, vol. 1, no. 1, pp. 936, March 1976CrossRefGoogle Scholar
  10. [10]
    J. Coutaz: “Architecture Models for Interactive Software: Failures and Trends”, in Proc. of the IFIP WG 2.7 Conference Engineering for Human-Computer Interaction, Napa Valley, 1989Google Scholar
  11. [11]
    B. Czejdo, R. Elmasri, D. W. Embley, M. Rusinkiewicz: “A Graphical Data Manipulation Language for an Extended Entity-Relationship Model”, IEEE Computer, vol. 23, no. 3, pp. 26–36, March 1990CrossRefGoogle Scholar
  12. [12]
    K. R. Dittrich: “Object-Oriented Database Systems”, in Entity-Relationship Approach - Ten Years of Experience in Information Modeling, S. Spaccapietra ed., pp. 51–66, North-Holland, 1987Google Scholar
  13. [13]
    R. A. Elmasri, J. A. Larson: “A Graphical Query Facility for ER Databases”, in Entity-Relationship Approach - The Use of ER Concept in Knowledge Representation, P. P. Chen ed., pp. 236–245, North-Holland, 1985Google Scholar
  14. [14]
    K. J. Goldman, S. A. Goldman, P. C. Kanellakis, S. B. Zdonik: “ISIS, Interface for a Semantic Information System”, in Proc. of ACM SIGMOD ‘85, Intl Conf. on Management of Data, pp. 328–342, Austin, 1985Google Scholar
  15. [15]
    I. P. Groette, E. G. Nilsson: “SICON, an Iconic Presentation Module for an E-R Database”, in Proc. of the 7th Int’l ‘Conf. on Entity-Relationship Approach, pp. 137–155, Rome, 1988Google Scholar
  16. [16]
    M. Kuntz, R. Melchert: “Pasta-3’s Graphical Query Language: Direct Manipulation, Cooperative Queries, Full Expressive Power”, in Proc. of the 15th Intl Conf. on Very Large Data Bases, pp. 97–105, Amsterdam, 1989Google Scholar
  17. [17]
    M. Kuntz, R. Melchert: “Ergonomic Schema Design and Browsing with More Semantics in the Pasta-3 Interface for E-R DBMSs”, in Entity-Relationship Approach to Database Design and Querying, F. Lochovsky ed., North-Holland, 1990Google Scholar
  18. [18]
    M. A. Linton, J. M. Vlissides, P. R. Calder: “Composing User Interfaces with InterViews”, IEEE Computer, vol. 22, no. 2, pp. 8–22, February 1989CrossRefGoogle Scholar
  19. [19]
    B. Liskov, J. Guttag: Abstraction and Specification in Program Development, MIT Press/Mc Graw Hill, 1986Google Scholar
  20. [20]
    P. H. Loy: “A Comparison of Object-Oriented and Structured Development Methods”, ACM SIGSOFT, January 1990Google Scholar
  21. [21]
    C. Parent, S. Spaccapietra: “An Algebra for a General Entity-Relationship Model”, IEEE Transactions on Software Engineering, vol. 11, no. 7, pp. 634–643, July 1985CrossRefGoogle Scholar
  22. [22]
    C. Parent, S. Spaccapietra: “About Complex Entities, Complex Objects and Object-Oriented Data Models”, in Information Systems Concepts - An In-depth Analysis, E. D. Falkenberg, P. Lindgreen eds., pp. 347360, North-Holland, 1989Google Scholar
  23. [23]
    C. Parent, H. Rolin, K. Yétongnon, S. Spaccapietra: “An ER Calculus for the Entity-Relationship Complex Model”, in Entity-Relationship Approach to Database Design and Querying, F. Lochovsky ed., North-Holland, 1990Google Scholar
  24. [24]
    D. Reiner et al.: “A Database Designer’s Workbench”, in Entity-Relationship Approach - Ten Years of Experience in Information Modeling, S. Spaccapietra ed., pp. 347–360, North-Holland, 1987Google Scholar
  25. [25]
    T. R. Rogers, R. G. G. Cattell: “Entity-Relationship Database User Interfaces”, in Proc. of the 6th Intl Conf. on Entity-Relationship Approach, pp. 323–335, New York, 1987Google Scholar
  26. [26]
    P. Schwarz et al.: “Extensibility in the Starburst Database System”, in Proc. Intl Workshop on Object-Oriented Database Systems, pp. 85–93, 1986Google Scholar
  27. [27]
    B. Shneiderman: “Direct Manipulation: A Step Beyond Programming Languages”, IEEE Computer, vol. 16, no. 8, pp. 57–69, August 1983CrossRefGoogle Scholar
  28. [28]
    S. Spaccapietra, C. Parent, K. Yétongnon, M. S. Abaidi: “Generalizations: A Formal and Flexible Approach”, in Management of Data, N. Prakash ed., pp. 100–117, Tata McGraw-Hill, 1989Google Scholar
  29. [29]
    S. Spaccapietra, C. Parent: “View Integration: A Step Forward in Solving Structural Conflicts”, to appear in IEEE Transactions on Knowledge and Data Engineering, 1991Google Scholar
  30. [30]
    H. K. T. Wong, I. Kuo: “GUIDE: Graphic User Interface for Database Exploration”, in Proc. of the 8th Intl Conf. on Very Large Databases, pp. 22–32, Mexico City, 1982Google Scholar
  31. [31]
    Z. Q. Zhang, A. O. Mendelzon: “A Graphical Query Language for Entity-Relationship Databases”, in Entity-Relationship Approach to Software Engineering, Davis et al. eds., pp. 441–448, North-Holland, 1983Google Scholar

Copyright information

© Springer-Verlag Wien 1991

Authors and Affiliations

  • Annamaria Auddino
    • 1
  • Eric Amiel
    • 2
  • Bharat Bhargava
    • 3
  1. 1.DI, Laboratoire de Bases de DonnéesEcole Polytechnique FédéraleLausanneSwitzerland
  2. 2.INRIA RocquencourtLe Chesnay CedexFrance
  3. 3.Department of Computer SciencePurdue UniversityWest LafayetteUSA

Personalised recommendations