Skip to main content
SpringerLink
Log in

ERX-QL: Querying an Entity-Relationship DB to Obtain XML Documents

  • Conference paper
  • First Online:
Database Programming Languages (DBPL 2001)

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

Included in the following conference series:

Abstract

Perspective scenarios of e-commerce applications, in particular B2B applications, based on the exchange of XML documents open new research issues in the field of information systems and XML data management. In fact, information systems will have to generate XML documents, obtained by querying the underlying DBMS.

This paper informally introduces the ERX-Query Language (ERX-QL), under development as part of ERX Data Management System (developed at University of Bergamo). ERX-QL deals with the problem of formulating declarative queries to extract data from within a database and directly generate XML documents. This way, ERX-QL naturally deals with recursive and nested XML structures. Furthermore, the rich extended ER database provided by the ERX system makes ERX-QL rich and powerful, thus suitable, with minor changes, to be adopted on classical RDBMSs.

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. M. Andries and G. Engels. A hybrid query language for an extended entity-relationship model. Journal of Visual Languages and Computing, 7(3):321–352, 1996.

    Article  Google Scholar 

  2. P. Atzeni and P. P. Chen. Completeness of query languages for the entity-relationship model. In Proceedings of the Second International Conference on the Entity-Relationship Approach (ER’81), Washington, DC, USA, October 12–14, 1981, pages 109–122. North Holland, 1981.

    Google Scholar 

  3. A. C. Bloesch and T. A. Halpin. Conceptual queries using ConQuer-II. In ER’ 97, 16th International Conference on Conceptual Modeling, Los Angeles, California, USA, November 3–5, 1997, Proceedings, volume 1331, pages 113–126. Springer, 1997.

    Google Scholar 

  4. S. Ceri, S. Comai, E. Damiani, P. Fraternali, and L. Tanca. Complex queries in xml-gl. In Proc. ACM SAC 2000 Symposium on Applied Computing, Como, Italy, 2000.

    Google Scholar 

  5. D. D. Chamberlin, J. Robie, and D. Florescu. Quilt: An xml query language for heterogeneous data sources. In Proc. WebDB Workshop, Dallas, Texas (USA), May 2000.

    Google Scholar 

  6. P. P. Chen. The entity-relationship model-toward a unified view of data. TODS, 1(1):9–36, 1976.

    Article  Google Scholar 

  7. A. Deutsch, M. Fernandez, D. Florescu,, A. Levy, and D. Suciu. Xml-ql: A query language for xml. (Tech.Rep. NOTE-xml-ql-19980819), August 1998.

    Google Scholar 

  8. V. M. Markowitz and Y. Raz. A modified relational algebra and its use in an entity-relationship environment. In Proceedings of the 3rd Int. Conf. on Entity-Relationship Approach (ER’83), pages 315–328. North Holland, 1983.

    Google Scholar 

  9. J. McHugh and J. Widom. Query optimization for xml. In Proc. 25th VLDB Conference, Edinburgh, Scotland, September 1999.

    Google Scholar 

  10. Christine Parent, Hélène Rolin, Kokou Yétongnon, and Stefano Spaccapietra. An er calculus for the entity-relationship complex model. In Proceedings of the Eight International Conference on Enity-Relationship Approach, Toronto, Canada, 18–20 October, 1989, pages 361–384. North-Holland, 1989.

    Google Scholar 

  11. G. Psaila and D. Brugali. The ERX data management system. In Proceedings of IC-2001, Second International Conference on Internet Computing, Las Vegas, Nevada, USA, 26–28 June 2001.

    Google Scholar 

  12. J. Robie, J. Lapp, and D. Schach. XML Query Language (XQL). http://www.w3.org/TandS/QL/QL98/pp/xql.html, 1998.

  13. T. R. Rogers and R. G. G. Cattell. Entity-relationship database user interfaces. In Proceedings of the Sixth International Conference on Entity-Relationship Approach, New York, USA, November 9–11, 1987, pages 353–365. North-Holland, 1987.

    Google Scholar 

  14. J. Shammugasundaram, K. Tufte, G. He, C. Zhang, D. DeWitt, and J. Naughton. Relational databases for querying xml documents: Limitations and opportunities. In Proc. 25th VLDB Conference, Edinburgh, Scotland, September 1999.

    Google Scholar 

  15. K. Subieta and M. Missala. Semantics of query languages for the entity-relationship model. In Proceedings of the Fifth International Conference on Entity-Relationship Approach, Dijon, France, November 17–19, 1986, pages 197–216. North-Holland, 1986.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Facoltà di Ingegneria, Università degli Studi di Bergamo, Viale Marconi 5, I-24044, Dalmine, BG, Italy

    Giuseppe Psaila

Authors
  1. Giuseppe Psaila
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Dipartimento di Informatica, Univesità di Pisa, Corso Italia 40, 56125, Pisa, Italy

    Giorgio Ghelli

  2. Department of Computer Science, Concordia University, 1455 De Maisonneuve Blvd. West, Montréal, Québec, Canada, H3G 1M8

    Gösta Grahne

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Psaila, G. (2002). ERX-QL: Querying an Entity-Relationship DB to Obtain XML Documents. In: Ghelli, G., Grahne, G. (eds) Database Programming Languages. DBPL 2001. Lecture Notes in Computer Science, vol 2397. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46093-4_17

Download citation

  • DOI: https://doi.org/10.1007/3-540-46093-4_17

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-44080-2

  • Online ISBN: 978-3-540-46093-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation