Skip to main content
SpringerLink
Log in

Text / relational database management systems: Harmonizing SQL and SGML

  • Conference paper
  • First Online:
Book cover Applications of Databases (ADB 1994)

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

Included in the following conference series:

Abstract

Combined text and relational database support is increasingly recognized as an emerging need of industry, spanning applications requiring text fields as parts of their data (e.g., for customer support) to those augmenting primary text resources by conventional relational data (e.g., for publication control). In this paper, we propose extensions to SQL that provide flexible and efficient access to structured text described by SGML. We also propose an architecture to support a text/relational database management system as a federated database environment, where component databases are accessed via “agents”: SQL agents that translate standard or extended SQL queries into vendorspecific dialects, and text agents that process text sub-queries on full-text search engines.

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. ATA 89-9C SFQL Committee, “Advanced Retrieval Standard —SFQL: Structured Full-text Query Language,” ATA specification 100, Rev 30, Version 2.2, Prerelease C, Air Transport Association, ATA 89-9C.SFQL V2.2/PR-C (October 1991) 84 pp.

    Google Scholar 

  2. A. Biliris, “The Performance of Three Database Storage Structures for Managing Large Objects,” Proc. Sigmod 92, ACM, Sigmod Record, Vol. 21, No. 2 (June 1992) 276–285.

    Article  Google Scholar 

  3. G.E. Blake, M.P. Consens, P. Kilpeläinen, P.-Å. Larson, T. Snider, and F.W. Tompa, “Text extensions to SQL,” internal report, Univ. of Waterloo Centre for the New OED and Text Research, 1994.

    Google Scholar 

  4. V. Christophides, S. Abiteboul, S. Cluet, and M. Scholl, “From Structured Documents to Novel Query Facilities,” To appear in Proc. 13th. ACM SIG-MOD Conf., (May 1994).

    Google Scholar 

  5. C. F. Goldfarb. The SGML Handbook. Oxford University Press, Oxford, 1990.

    MATH  Google Scholar 

  6. G. H. Gonnet and F. W. Tompa, “Mind Your Grammar: a New Approach to Modelling Text,” Very Large Data Bases (VLDB), Vol. 13 (September 1987) pp. 339–346.

    Google Scholar 

  7. International Organization for Standardization, International Standard 8879: Information Processing — Text and Office Systems — Standard Generalized Markup Language (SGML), first edition — 1986-10-15(Ref. No. ISO 8879-1986(E)), 155 pp.

    Google Scholar 

  8. International Organization for Standardization, “Information technology — Database Language SQL 2 Draft Report”, ISO Committee ISO/IEC JTC 1/SC 21, 1990.

    Google Scholar 

  9. P.-Å. Larson, “Relational Access to IMS Databases: Gateway Structure and Join Processing,” Project report, (available from the author), 1989.

    Google Scholar 

  10. P.-Å. Larson, H. AboElFotoh, M. Dionne, and F. Wang, “SQL Access to VAX DBMS Databases: Strategy Generation and Query Execution for Basic SPW Queries,” Project report (available from the first author), 1989.

    Google Scholar 

  11. C. C. Marshall, F. G. Halasz, R. A. Rogers, and W. C. Janssen Jr., “Aquanet: a Hypertext Tool to Hold Your Knowledge in Place,” Proc. 3rd ACM Conf. on Hypertext: Hypertext 91, San Antonio (Dec. 1991) 261–275.

    Google Scholar 

  12. Microsoft Corporation, Microsoft ODBC Application Programmer's Guide, Microsoft Corporation, 1992.

    Google Scholar 

  13. Oracle Corporation, SQL * TextRetrieval Version 2 Technical Overview, Oracle Corporation, 1992. 45 pp.

    Google Scholar 

  14. R. Sacks-Davis, A. Kent, K. Ramamohanarao, J. Thorn, and J. Zobel, “Atlas: a nested relational database system for text applications”, Technical Report CITRI/TR-92-52, Collaborative Information Technology Research, Victoria, Australia, July 1992.

    Google Scholar 

  15. A. Salminen and F.W. Tompa. “PAT Expressions: an algebra for text search,” Papers in Computational Lexicography: COMPLEX '92, Proc. 2nd Int. Conf. on Computational Lexicography (F. Kiefer, G. Kiss, J. Pajzs ed.), Linguistics Inst., Hungarian Academy of Science, Budapest (October 1992), 309–332.

    Google Scholar 

  16. Seybold Publications, “IDI Pursues Document Management,” Report on Publishing Systems, Vol. 21, No. 16, May 1992.

    Google Scholar 

  17. E.S.C. Weiner. “The New OED: Problems in the Computerization of a Dictionary,” University Computing, Vol. 7 (1985) 66–71.

    Google Scholar 

  18. M.M. Zloof. “Query-by-Example: Operations on the Transitive Closure,” IBM Research Report RC 5526, Yorktown Heights, N.Y., 1975.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. UW Centre for the New OED and Text Research, University of Waterloo, N2L 3G1, Waterloo, Ontario, Canada

    G. E. Blake, M. P. Consens, P. Kilpeläinen, P. -Å. Larson, T. Snider & F. W. Tompa

Authors
  1. G. E. Blake
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. M. P. Consens
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. P. Kilpeläinen
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. P. -Å. Larson
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. T. Snider
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. F. W. Tompa
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Witold Litwin Tore Risch

Rights and permissions

Reprints and permissions

Copyright information

© 1994 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Blake, G.E., Consens, M.P., Kilpeläinen, P., Larson, P.Å., Snider, T., Tompa, F.W. (1994). Text / relational database management systems: Harmonizing SQL and SGML. In: Litwin, W., Risch, T. (eds) Applications of Databases. ADB 1994. Lecture Notes in Computer Science, vol 819. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58183-9_54

Download citation

  • DOI: https://doi.org/10.1007/3-540-58183-9_54

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-58183-3

  • Online ISBN: 978-3-540-48473-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation