Relational database systems have dominated the database industry for a quarter century. However, the advent of the Web has led to requirements for storage of new kinds of information in which the order of information is important and data structure can vary over time and from one document to another. These evolving requirements have given rise to Extensible Markup Language (XML) as a widely accepted data format and to XQuery as an emerging standard language for querying XML data sources. A set of extensions to the Structured Query Language (SQL) called SQL/XML enables XML data to be stored in relational databases, taking advantage of the mature infrastructure of relational systems and combining the advantages of SQL and XQuery. However, building a bridge between SQL and XQuery is challenging due to the many syntactic and semantic differences between the two languages. This paper describes how IBM DB2t deals with this challenge and provides users with a flexible system for storing and processing both relational and XML data.
ZusammenfassungIn diesem Artikel geben die Autoren einen Überblick über die neuesten Funktionen der nächsten Version der SQL-Norm (SQL:2003) sowie eine kurze Zusammenfassung der vorhandenen Funktionalität in der aktuell gültigen Norm (SQL:1999) und den früheren Versionen. Zusätzlich wird auf ausgewählte Teile des Standards ausführlicher eingegangen. Abschließend wird kurz auf die Zukunft der SQL-Norm aus Sicht der Autoren eingegangen.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
customersupport@researchsolutions.com
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.