Querying XML – XQuery, SQL/XML and SQL in context
XML version
HTML version
PDF version
SVG versionTrack: Core Technologies, Case Studies, Storing XML
Audience Level: High Level/Technical View
Time: Wednesday, November 17 at 11:00
Keywords: Application Architecture, Content Management, Database, Full-Text, Query Language, Relational Database, Repository, Search, SQL, XML, XQuery
Abstract:
XQuery is gathering momentum as a powerful, flexible, general-purpose query language for searching within and across XML documents and fragments. But on its own, it’s just a query language – it defines a transformation from one XQuery Data Model instance to another.
Relational databases and SQL have been storing, managing and searching the world’s most valuable data for decades. But SQL (before XML extensions) could not leverage the information implicit in the structure of XML.
Many see XQuery and SQL as competitive technologies: this paper describes how XQuery and SQL can be complementary in practical applications, each leveraging the strengths of the other. SQL can extend its query capabilities via XML extensions – SQL/XML and XQuery functions – while XQuery can query SQL databases and repositories. Add a Java API - XQuery API for Java™ (XQJ) - and XQuery and SQL together can meet any application’s query requirements. The paper includes an overview of XML and query technologies, and some practical advice on choosing the right mix of technologies for your application.
