The union of XML and relational databases creates a powerful toolwith the ability to transfer information between two completelyunrelated databases. With this book, veteran author Gavin Powellshows you how this confluence of two technologies can simplify yourdatabase work and provide a more standardized way to exchange databetween multiple databases and web sites.
You'll get an in-depth look at specific XML datatypes that areconsidered the most critical alliances between XML and a relationaldatabase. Plus, an introduction to the basics of SQL and numerousXML standards prove to be essential so that you can grasp databasestructure and comprehend how XML is used with the Oracle® andSQL Server relational databases. Throughout the book, valuableexercises and a surfeit of step-by-step examples will help you getan overall understanding of the topics at hand.
What you will learn from this book
- The platform independence capability that comes from usingXML— including independence from database vendors
- The basics of XML, XSL, the XML DOM, and SQL
- XML datatypes and features in Oracle Database and SQLServer
- How to move data anywhere using XML (B2B)
- Ways to read XML documents using XQuery and navigate documentsusing XPath®
- XML, the object data model, native XML databases, and industryapplications of XML
Who this book is for
This book is for anyone—from novice to expert—who isinterested in learning the details of XML and database technologyas applied to both XML and relational database technology, workingtogether.
Wrox Beginning guides are crafted to make learningprogramming languages and technologies easier than you think,providing a structured, tutorial format that will guide you throughall the techniques involved.
“The book can be used as a very good introductory text for students and practitioners eager to acquire knowledge...” (Zentralblatt MATH
, Vol. 1118 2007/20)