Article

XML and relational database management systems: the inside story

Authors:

Don Chamberlin,

Daniela FlorescuAuthors Info & Claims

SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Pages 945 - 947

https://doi.org/10.1145/1066157.1066298

Published: 14 June 2005 Publication History

Abstract

As XML has evolved from a document markup language to a widely-used format for exchange of structured and semistructured data, managing large amounts of XML data has become increasingly important. A number of companies, including both established database vendors and startups, have recently announced new XML database systems or new XML functionality integrated into existing database systems. This tutorial will provide an insight into how XML functionality fits into relational database management systems as seen by three major relational vendors: IBM, Microsoft and Oracle.

References

[1]

Extensible Business Reporting Language. See http://www.xbrl.org/home.

[2]

Health Level 7 XML Special Interest Group (R. H. Dolin and P. V. Biron, editors). Using XML as a Supplementary Messaging Syntax for HL7 Version 2.3.1. See http://www.hl7.org/special/committees/sgml/hl7v231xmlFIN AL.zip.

[3]

W3C XML Protocol Working Group (M. Gudgin et al, editors). SOAP Version 1.2 Part 1: Messaging Framework. See http://www.w3.org/TR/soap 12.

[4]

E. Christensen et al. Web Services Definition Language (WSDL) 1.1. W3C Note. See http://www.w3.org/TR/wsdl.

[5]

World Wide Web Consortium (W3C). See http://www.w3.org.

[6]

T. Bray et al. Extensible Markup Language (XML) 1.0. W3C Recommendation. See http://www.w3.org/REC-xml.

[7]

W3C Schema Working Group (H. Thompson et al, editors). XML Schema, Parts 0, 1, and 2. See http://www.w3.org/TR/xmlschema-0,-1, and -2.

[8]

W3C XSL and Linking Working Groups (J. Clark and S. DeRose, editors). XML Path Language (XPath) Version 1.0. See http://www.w3.org/TR/xpath.

[9]

W3C Query and XSL Working Groups (A. Berglund et al, editors). XML Path Language (XPath) Version 2.0. See http://www.w3.org/TR/xpath20.

[10]

W3C XSL Working Group (J. Clark, editor). XSL Transformations (XSLT) Version 1.0. See http://www.w3.org/TR/xslt.

[11]

W3C XSL Working Group (M. Kay, editor). XSL Transformations (XSLT) Version 2.0. See http://www.w3.org/TR/xslt20.

[12]

W3C Query Working Group (S. Boag et al, editors). XQuery 1.0: An XML Query Language. See http://www.w3.org/TR/xquery.

[13]

International Organization for Standardization (ISO). Information Technology---Database Language SQL---Part 14: XML-Related Specifications (SQL/XML). Standard No. ISO/IEC 9075:2003. Available from American National Standards Institute, New York.

[14]

W3C XML Core Working Group (J. Cowan and R. Tobin, editors). XML Information Set. See http://www.w3.org/TR/xml-infoset.

[15]

W3C Query and XSL Working Groups (M. Fernandez et al, editors). XQuery 1.0 and XPath 2.0 Data Model. See http://www.w3.org/TR/xpath-datamodel.

[16]

W3C Query and XSL Working Groups (D. Draper et al, editors). XQuery 1.0 and XPath 2.0 Formal Semantics. See http://www.w3.org/TR/xquery-semantics.

[17]

W3C Query Working Group (D. Chamberlin and J. Robie, editors). XQuery Update Facility Requirements. See http://www.w3.org/TR/xquery-update-requirements.

[18]

W3C Query and XSL Working Groups (S. Amer-Yahia et al, editors.).XQuery 1.0 and XPath 2.0 Full-Text. See http://www.w3.org/TR/xquery-full-text.

[19]

W3C Query and XSL Working Groups (S. Amer-Yahia and P. Case, editors). XQuery 1.0 and XPath 2.0 Full-Text Use Cases. See http://www.w3.org/TR/xquery-full-text-use-cases.

Cited By

Nassiri HMachkour MHachimi M(2018)One query to retrieve XML and Relational DataProcedia Computer Science10.1016/j.procs.2018.07.201134(340-345)Online publication date: 2018
https://doi.org/10.1016/j.procs.2018.07.201
Nassiri HMachkour MHachimi M(2017)Integrating XML and Relational DataProcedia Computer Science10.1016/j.procs.2017.06.107110(422-427)Online publication date: 2017
https://doi.org/10.1016/j.procs.2017.06.107
Brodsky AShao GKrishnamoorthy MNarayanan AMenascé DAk R(2016)Analysis and optimization based on reusable knowledge base of process performance modelsThe International Journal of Advanced Manufacturing Technology10.1007/s00170-016-8761-788:1-4(337-357)Online publication date: 23-Apr-2016
https://doi.org/10.1007/s00170-016-8761-7
Show More Cited By

XML and relational database management systems: the inside story
1. Applied computing
  1. Document management and text processing
2. Information systems
  1. Data management systems

Recommendations

Efficient and scalable xml data processing using relational database systems
Converting Relational Database into XML Document
DEXA '01: Proceedings of the 12th International Workshop on Database and Expert Systems Applications

Abstract: XML (eXtensible Markup Language) has emerged and is gradually accepted as the standard for data interchange in the Internet world. XML databases are packaged by the key Relational Database Vendors in the market as the extender or cartridge to ...
XML and relational database management systems: inside Microsoft® SQL Server™ 2005
SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Microsoft® SQL Server™ has a long history of XML support dating back to 1999. While first concentrating on enabling the transport of relational data via XML with the SQL Server 2000 release, SQL Server 2005 now additionally provides native XML storage ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data

June 2005

990 pages

ISBN:1595930604

DOI:10.1145/1066157

Conference Chair:
Fatma Ozcan
IBM Almaden Research Center

Copyright © 2005 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 14 June 2005

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGMOD/PODS05

Sponsor:

SIGMOD/PODS05: International Conference on Management of Data and Symposium on Principles Database and Systems

June 14 - 16, 2005

Maryland, Baltimore

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

28
Total Citations
View Citations
1,927
Total Downloads

Downloads (Last 12 months)5
Downloads (Last 6 weeks)1

Reflects downloads up to 03 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Nassiri HMachkour MHachimi M(2018)One query to retrieve XML and Relational DataProcedia Computer Science10.1016/j.procs.2018.07.201134(340-345)Online publication date: 2018
https://doi.org/10.1016/j.procs.2018.07.201
Nassiri HMachkour MHachimi M(2017)Integrating XML and Relational DataProcedia Computer Science10.1016/j.procs.2017.06.107110(422-427)Online publication date: 2017
https://doi.org/10.1016/j.procs.2017.06.107
Brodsky AShao GKrishnamoorthy MNarayanan AMenascé DAk R(2016)Analysis and optimization based on reusable knowledge base of process performance modelsThe International Journal of Advanced Manufacturing Technology10.1007/s00170-016-8761-788:1-4(337-357)Online publication date: 23-Apr-2016
https://doi.org/10.1007/s00170-016-8761-7
Hufnagel JVogel-Heuser B(2015)Data integration in manufacturing industry: Model-based integration of data distributed from ERP to PLC2015 IEEE 13th International Conference on Industrial Informatics (INDIN)10.1109/INDIN.2015.7281747(275-281)Online publication date: Jul-2015
https://doi.org/10.1109/INDIN.2015.7281747
Brodsky AShao GKrishnamoorthy MNarayanan AMenasce DAk R(2015)Analysis and optimization in smart manufacturing based on a reusable knowledge base for process performance modelsProceedings of the 2015 IEEE International Conference on Big Data (Big Data)10.1109/BigData.2015.7363902(1418-1427)Online publication date: 29-Oct-2015
https://dl.acm.org/doi/10.1109/BigData.2015.7363902
Moilanen KNiemi TNäppilä TKuru M(2015)A visual XML dataspace approach for satisfying ad hoc information needsJournal of the Association for Information Science and Technology10.1002/asi.2332666:11(2304-2320)Online publication date: 1-Nov-2015
https://dl.acm.org/doi/10.1002/asi.23326
Chen LBernstein PCarlin PFilipovic DRys MShamgunov NTerwilliger JTodic MTomasevic STomic D(2014)Mapping XML to a Wide Sparse TableIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2012.22126:6(1400-1414)Online publication date: 1-Jun-2014
https://dl.acm.org/doi/10.1109/TKDE.2012.221
Brodsky AKrishnamoorthy MMenasce DShao GRachuri S(2014)Toward smart manufacturing using decision analytics2014 IEEE International Conference on Big Data (Big Data)10.1109/BigData.2014.7004330(967-977)Online publication date: Oct-2014
https://doi.org/10.1109/BigData.2014.7004330
Marcjan RSiwik L(2014)The Concept of Transformation of XML Documents into Quasi-Relational ModelBeyond Databases, Architectures, and Structures10.1007/978-3-319-06932-6_55(569-580)Online publication date: 2014
https://doi.org/10.1007/978-3-319-06932-6_55
Näppilä TNiemi T(2012)An approach for developing a schemaless XML dataspace profiling systemJournal of Information Science10.1177/016555151243753238:3(234-257)Online publication date: 18-Apr-2012
https://doi.org/10.1177/0165551512437532
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten