Skip to Content
Professional XML
book

Professional XML

by Thiru Thangarathinam, Bill Evjen, Alessandro Vernet, Sam Ferguson, Kent Sharkey, Michael Kay
April 2007
Intermediate to advanced
886 pages
21h 31m
English
Wrox
Content preview from Professional XML

Chapter 11. XML in the Data Tier

Although XML is frequently a part of the data tier—because it stores data—this chapter concentrates on XML and databases. Databases, both relational and native XML, are part of many applications. You must, therefore, often store XML in those databases or retrieve some of the data in XML format. While the conversion of data to XML could be done in an intermediate layer of your application, it is sometimes more efficient to do this work within the database itself. This chapter will look at how you can store and retrieve XML from such common databases as Microsoft SQL Server and Oracle 10g. In addition, this chapter will cover XML databases, and their possible role in your applications.

XML and Databases

Although XML is an excellent format for moving data between platforms, applications, or application tiers, it may not be the best format to use for storing data for your application. As the volume of data increases, so too does the time it takes to search for and manipulate that data. Databases, on the other hand, minimize the query times, even for large data sets. Because of this, you might often combine XML and databases in some applications. This can create mismatches: Data types stored in the database may not be in the same format as XML, and the structure of the two are different. XML tends to be more loosely structured or hierarchical, and relational databases (the most common forms today) are designed around tabular data. Moving data in and out ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

XML: Visual QuickStart Guide, Second Edition

XML: Visual QuickStart Guide, Second Edition

Kevin Howard Goldberg
XML Hacks

XML Hacks

Michael Fitzgerald

Publisher Resources

ISBN: 9780471777779Purchase book