Skip to main content
SpringerLink
Log in

Experiences with SUPER, a Database Visual Environment

  • Conference paper
Database and Expert Systems Applications

Abstract

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.

This work was performed while prof. Bhargava was visiting EPFL

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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, 1988

    Google Scholar 

  2. E. Amiel: “Object-Oriented Programming for Data Model Implementation”, in Data Management - Current Trends, N. Prakash ed., pp. 223–243, Tata McGraw-Hill, 1990

    Google Scholar 

  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, 1991

    Google Scholar 

  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 1988

    Article  Google Scholar 

  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, 1986

    Google Scholar 

  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, 1986

    Google Scholar 

  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, 1988

    Google Scholar 

  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, 1980

    Google Scholar 

  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 1976

    Article  Google Scholar 

  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, 1989

    Google Scholar 

  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 1990

    Article  Google Scholar 

  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, 1987

    Google Scholar 

  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, 1985

    Google Scholar 

  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, 1985

    Google Scholar 

  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, 1988

    Google Scholar 

  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, 1989

    Google Scholar 

  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, 1990

    Google Scholar 

  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 1989

    Article  Google Scholar 

  19. B. Liskov, J. Guttag: Abstraction and Specification in Program Development, MIT Press/Mc Graw Hill, 1986

    Google Scholar 

  20. P. H. Loy: “A Comparison of Object-Oriented and Structured Development Methods”, ACM SIGSOFT, January 1990

    Google Scholar 

  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 1985

    Article  Google Scholar 

  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, 1989

    Google Scholar 

  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, 1990

    Google Scholar 

  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, 1987

    Google Scholar 

  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, 1987

    Google Scholar 

  26. P. Schwarz et al.: “Extensibility in the Starburst Database System”, in Proc. Intl Workshop on Object-Oriented Database Systems, pp. 85–93, 1986

    Google Scholar 

  27. B. Shneiderman: “Direct Manipulation: A Step Beyond Programming Languages”, IEEE Computer, vol. 16, no. 8, pp. 57–69, August 1983

    Article  Google Scholar 

  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, 1989

    Google Scholar 

  29. S. Spaccapietra, C. Parent: “View Integration: A Step Forward in Solving Structural Conflicts”, to appear in IEEE Transactions on Knowledge and Data Engineering, 1991

    Google Scholar 

  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, 1982

    Google Scholar 

  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, 1983

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. DI, Laboratoire de Bases de Données, Ecole Polytechnique Fédérale, Lausanne, Switzerland

    Annamaria Auddino

  2. INRIA Rocquencourt, B.P. 105, Le Chesnay Cedex, France

    Eric Amiel

  3. Department of Computer Science, Purdue University, West Lafayette, USA

    Bharat Bhargava

Authors
  1. Annamaria Auddino
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Eric Amiel
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Bharat Bhargava
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Forschungsinstitut für anwendungsorientierte Wissensverarbeitung (FAW), Ulm, Federal Republic of Germany

    Dimitris Karagiannis (General Conference Chairman) (General Conference Chairman)

Rights and permissions

Reprints and permissions

Copyright information

© 1991 Springer-Verlag Wien

About this paper

Cite this paper

Auddino, A., Amiel, E., Bhargava, B. (1991). Experiences with SUPER, a Database Visual Environment. In: Karagiannis, D. (eds) Database and Expert Systems Applications. Springer, Vienna. https://doi.org/10.1007/978-3-7091-7555-2_29

Download citation

  • DOI: https://doi.org/10.1007/978-3-7091-7555-2_29

  • Publisher Name: Springer, Vienna

  • Print ISBN: 978-3-211-82301-9

  • Online ISBN: 978-3-7091-7555-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation