Building hypertext interfaces to existing relational databases

  • Ath. Papadopoulos
  • M. Vaitis
  • D. Christodoulakis
Relational and Extended Relational Approaches
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1134)


This paper presents a methodology for constructing hypertext views over existing relational databases. First, the database semantics are extracted in the form of an EER schema, using database reverse engineering techniques. Then, the EER schema is used for the definition of the node and link types of hypertext views. This two-stage approach has the benefit that the hypertext designer considers only a conceptual model of the database. Moreover, the instances of node and link types are dynamically computed; no data replication takes place. An experimental set of tools that support the methodology has been developed and used in a realistic case study.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    T. Barsalou, N. Siambela, A. M. Keller and G. Wiedelhold, “Updating Relational Databases through Object-Based Views”, ACM SIGMOD Conf. 1991, p. 248–257.Google Scholar
  2. [2]
    M. Castellanos, F. Saltor and M. Garcia-Solaco, “Semantically enrichment relational databases into an object-oriented semantic model”, Proc. of DEXA '94, Springer-Verlag LCNS 856, p. 125–134.Google Scholar
  3. [3]
    R. H.L. Chiang, T. M. Barron and V. C. Storey, “Reverse engineering of relational databases: Extraction of an EER model from a relational database”, Data & Knowledge Engineering 12, 1994, p. 107–142.Google Scholar
  4. [4]
    R. H.L. Chiang, “A Knowledge-based system for performing reverse engineering of relational databases”, Decision Support Systems 13, 1995, p. 295–312.CrossRefGoogle Scholar
  5. [5]
    O. Drori, “Information Reduction Model in Hypertext Virtual Node”, ACM SIGLINK Newsletter 4(3), December 1995, p. 10.Google Scholar
  6. [6]
    R. Elmasri and S.B. Navathe, “Fundamentals of database systems”, Benjamin/Cummings, Menlo Park, CA, 1994.Google Scholar
  7. [7]
    C. Fahrner and G. Vossen, “A Survey of database design transformations based on the Entity-Relationship model”, Data & Knowledge Engineering 15, 1995, p. 213–250.Google Scholar
  8. [8]
    G. Falquet, J. Guyot and I. Prince, “Generating Hypertext Views on Databases”, CUI Technical Report No 101, University of Geneva, 1995.Google Scholar
  9. [9]
    M. Frank, “Database and the Internet”, DBMS Magazine 8(13), December 1995.Google Scholar
  10. [10]
    F. Garzoto, P. Paolini and D. Schwabe, “HDM: A Model-Based Approach to Hypertext Application Design”, ACM Trans. on Information Systems 11(1), January 1993, p. 1–26.CrossRefGoogle Scholar
  11. [11]
    F. Halasz, “Reflections on Notecards: Seven Issues for the Next Generation of Hypermedia Systems”, CACM, 31(7), July 1988, p. 836–852.Google Scholar
  12. [12]
    F. Halasz and M. Schwartz, “The Dexter Hypertext Reference Model”, CACM 37(2), February 1994, p. 30–39.Google Scholar
  13. [13]
    Y. Hara and R. A. Botafogo, “Hypermedia Databases: A Specification and Formal Language”, Proc. of DEXA '94, Springer-Verlag LCNS 856, p. 520–530.Google Scholar
  14. [14]
    A. Hatzimanikatis, A. Papadopoulos and D. Christodoulakis, “Implementing Open Hypermedia Services on Top of the Postgres Extended Relational Database Management System”, Proc. of DEXA '94, Springer-Verlag LCNS 856, p. 531–539.Google Scholar
  15. [15]
    T. Isakowitz, E. A. Stohr and P. Balasubramanian, “RMM: A Methodology for Structured Hypermedia Design”, CACM 38(9), August 1995, p. 34–44.Google Scholar
  16. [16]
    V. M. Markowitz and J. A. Makowsky, “Identifying Extended Entity-Relationship Objects Structures in Relational Schemas”, IEEE Trans. on Software Engineering 16(8), August 1990, p. 777–790.CrossRefGoogle Scholar
  17. [17]
    C. Ramananthan, “Providing Object-Oriented access to a Relational Database”, in Proceedings of the 32nd Annual Southeast Conf., Tuscalosa, Alabama, March 1994, p. 162–165, ACM Press.Google Scholar
  18. [18]
    W. J. Premerlani and M. R. Blaha, “An approach for reverse engineering of relational databases”, CACM 37(5), May 1994, p. 42–49.Google Scholar
  19. [19]
    D. Schwabe and G. Rossi, “Building Hypermedia Applications as Navigational Views of Information Models”, 28th Hawaii Int. Conf. on System Sciences, January 1995.Google Scholar
  20. [20]
    T. J. Teorey, G. Wei, D. L. Bolton and J. A. Koenig, “ER Model Clustering as an Aid for User Communication and Documentation in Database Design”, CACM 32(8), August 1989, p. 975–987.Google Scholar
  21. [21]
    F. W. Tompa, “A Data Model for Flexible Hypertext Database Systems”, ACM Trans. on Information Systems 7(1), January 1989, p. 85–100.CrossRefGoogle Scholar
  22. [22]
    C. Varela and C. Hays, “Providing Data on the Web: From Examples to Programs”, Second International Conference on the World Wide Web, Chicago, October 1994.Google Scholar
  23. [23]
    C. Varela, “Zelig: Schema-Based Generation of Soft WWW Database Applications”, First Int. Conf. on the World Wide Web, Geneva, Switzerland, May 1994.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1996

Authors and Affiliations

  • Ath. Papadopoulos
    • 1
    • 2
  • M. Vaitis
    • 1
    • 2
  • D. Christodoulakis
    • 1
    • 2
  1. 1.Dept. of Computer Engineering and InformaticsUniv. of PatrasGreece
  2. 2.Computer Technology InstitutePatrasGreece

Personalised recommendations