Skip to main content
SpringerLink
Log in

Building hypertext interfaces to existing relational databases

  • Relational and Extended Relational Approaches
  • Conference paper
  • First Online:
Book cover Database and Expert Systems Applications (DEXA 1996)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1134))

Included in the following conference series:

Abstract

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.

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

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. 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. 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. R. H.L. Chiang, “A Knowledge-based system for performing reverse engineering of relational databases”, Decision Support Systems 13, 1995, p. 295–312.

    Article  Google Scholar 

  5. O. Drori, “Information Reduction Model in Hypertext Virtual Node”, ACM SIGLINK Newsletter 4(3), December 1995, p. 10.

    Google Scholar 

  6. R. Elmasri and S.B. Navathe, “Fundamentals of database systems”, Benjamin/Cummings, Menlo Park, CA, 1994.

    Google Scholar 

  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. G. Falquet, J. Guyot and I. Prince, “Generating Hypertext Views on Databases”, CUI Technical Report No 101, University of Geneva, 1995.

    Google Scholar 

  9. M. Frank, “Database and the Internet”, DBMS Magazine 8(13), December 1995.

    Google Scholar 

  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.

    Article  Google Scholar 

  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. F. Halasz and M. Schwartz, “The Dexter Hypertext Reference Model”, CACM 37(2), February 1994, p. 30–39.

    Google Scholar 

  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. 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. 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. 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.

    Article  Google Scholar 

  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. 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. 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. 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. F. W. Tompa, “A Data Model for Flexible Hypertext Database Systems”, ACM Trans. on Information Systems 7(1), January 1989, p. 85–100.

    Article  Google Scholar 

  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. 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 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Engineering and Informatics, Univ. of Patras, Greece

    Ath. Papadopoulos, M. Vaitis & D. Christodoulakis

  2. Computer Technology Institute, Patras, Greece

    Ath. Papadopoulos, M. Vaitis & D. Christodoulakis

Authors
  1. Ath. Papadopoulos
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. M. Vaitis
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. D. Christodoulakis
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Roland R. Wagner Helmut Thoma

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Papadopoulos, A., Vaitis, M., Christodoulakis, D. (1996). Building hypertext interfaces to existing relational databases. In: Wagner, R.R., Thoma, H. (eds) Database and Expert Systems Applications. DEXA 1996. Lecture Notes in Computer Science, vol 1134. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0034688

Download citation

  • DOI: https://doi.org/10.1007/BFb0034688

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-61656-6

  • Online ISBN: 978-3-540-70651-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation