Professional XML Databases by Michael Brundage

Product Description

: In this book, we look at how to integrate XML into your current relational data source strategies. With the increasing amount of data stored in relational databases, and the importance of XML as a format for marking up data - whether it be for storage, display, interchange, or processing - you need to have command of four key skills: understanding how to structure, process, access, and store your data.

By introducing guidelines for how to model your XML documents in relational databases and how to model relational database information as XML, we will establish structures that enable quick and efficient access, and make our data more flexible. We then look at the developer's XML toolbox, discussing associated technologies and strategies that will help us in describing, processing, and manipulating data. We also discuss common techniques for data access, data warehousing, transmission, and marshalling and presentation, giving working examples in every chapter.

Whether you are using XML for storage, as an interchange format, or for display, this book looks at some of the key issues you should be aware of when structuring, processing, accessing, and storing your documents.
Product Details
Amazon Sales Rank: #722608 in Books
Published on: 2000-01-15
Number of items: 1
Binding: Paperback
1005 pages
Editorial Reviews

Amazon.com
In addition to being a tutorial for learning how to use XML as an effective way to represent and transmit data across the Web, Professional XML Databases also covers how to work with XML in the current generation of Microsoft tools, like Internet Explorer and SQL Server 2000. For any developer or manager who works with databases on the Windows platform, this book shows how you can delve into XML today for real projects.

With endorsements from virtually every major vendor (including Microsoft), XML looks to be a compelling standard for sharing corporate data between organizations. Professional XML Databases examines how to integrate XML into your organization's database infrastructure. Early sections concentrate on the rules and strategies for designing effective XML documents (DTDs) that mimic traditional tables (including links between tables). By providing almost a dozen rules on how to do this correctly, the book assures that you'll learn not only the basics of XML syntax but also the correct way to create DTDs that are efficient, easy to maintain, and readable across your business. (Further sections reverse this process and show you how to create database tables based on XML.)

Subsequent sections cover many of the standards and APIs in today's XML, from XML Schemas, the XML W3C Document Object Model (DOM), and the Simple API for XML (SAX), to related standards like XSLT, XPath, and XPointer. A number of books cover these APIs, but this one provides a unique focus by examining Microsoft tools and their support for XML. This means there is coverage of Microsoft ADO (and ADO+, now called ADO.NET) for querying databases and packaging the results as XML. Sections on SQL Server 2000 highlight ways to use XML in this product, both as results and through XML views.

Closing sections explore options for working with XML for data warehousing and transmitting data efficiently across organizations. Sections on Java and the DB Prism (an open-source XML framework) help give this book a perspective that extends beyond the Microsoft platform.

For any database developer or designer who needs to architect XML documents in order to share data in real projects, this advanced treatise on the right way to define and use XML will prove highly valuable. For anyone who uses SQL Server 2000, this book also points the way toward using XML standards in actual shipping products on the Microsoft platform. --Richard Dragan

Topics covered:
Hints for effective XML document design (including XML for text and XML for databases)
Designing XML for existing database tables
Creating database tables from XML
Standards guidelines for XML used within (and between) organizations
XML Schemas
The XML W3C Document Object Model (DOM)
Using the Simple API for XML (SAX)
XSLT
XPath used with style sheets and templates
Resource linking with XLink
Overview of additional emerging XML-based standards (including XBase, XInclude, XHTML, and XForms)
The XML Query language
Converting between flat file databases and XML
Introduction to Microsoft ADO, ADO+ (ADO.NET), and XML
Storing and retrieving XML in SQL Server 2000 (including OPENXML and XML views)
Tutorial for JDBC programming
JDBC used with XML
Data warehousing
Data transmission with XML
The Simple Object Access Protocol (SOAP)
Marshalling and presentation with XML (including a WML example for generating wireless content)
Sample case studies for SQL Server 2000 showing XML techniques
DB Prism (an open-source dynamic XML framework)
XML and database primers
References for XML datatypes and SAX

Book Info
A text for programmers and analysts familiar with XML and relational databases, focusing on the development and implementation of XML databases. Looks at key issues in structuring, formatting, accessing, and storing documents, also discussing techniques for data transmission, marshalling, and presentation. Softcover.

From the Publisher
This book has been selected by the editors of Wrox Press to be part of the Wroxbase website.

While this book will discuss some conceptual issues, its focus is on development and implementation. This is a book for programmers and analysts who are already famaliar with both XML and relational databases.
Customer Reviews

Book Rocks!!
this is very well written book. the material presented in this book are exhaustive and gets you good insight on how xml would be used with dbms. the chapters 2,3 and 4 are very informatiove as they list ou tthe steps required for converting db table to xml and vice versa.

No details on NATIVE XML DBs???
Interesting that you basically ignore native XML DBs. They are the definitive choice in most XML Document Centric environments. While RDBs remain quite strong in XML Data Centric models, they must resort to BLOBs or risk an order of magnitude of sluggishness compared to native XML DBs, such as our GoXML DB. Even with BLOBs, you cannot create a new document from multiple existing documents because of the columnar structure. The lack of a full table of contents when your title is 'Professional XML Databases' is disappointing...

Concerned XML Enthusiast

Good overview of new XML and database trends
I read through this book at more of an advanced developer level, so I'm going to treat it from that level.

The chapter on XQuery was great; it answered many of my questions concisely. There is very little information on the web about XQuery outside the W3.org site, so I was surprised to find such high quality information in a book.

XPath is also a newer API that is covered well in this book, giving you enough information to get your project going.

If you're planning to do any kind of development with XML coming in or going out of a relational database, this is an excellent book to buy. I also recommend Professional XML from Wrox and O'Reilly's XML in a nutshell.

Professional XML Databases by Michael Brundage

Product Description

: In this book, we look at how to integrate XML into your current relational data source strategies. With the increasing amount of data stored in relational databases, and the importance of XML as a format for marking up data - whether it be for storage, display, interchange, or processing - you need to have command of four key skills: understanding how to structure, process, access, and store your data.

By introducing guidelines for how to model your XML documents in relational databases and how to model relational database information as XML, we will establish structures that enable quick and efficient access, and make our data more flexible. We then look at the developer's XML toolbox, discussing associated technologies and strategies that will help us in describing, processing, and manipulating data. We also discuss common techniques for data access, data warehousing, transmission, and marshalling and presentation, giving working examples in every chapter.

Whether you are using XML for storage, as an interchange format, or for display, this book looks at some of the key issues you should be aware of when structuring, processing, accessing, and storing your documents.
Product Details
Amazon Sales Rank: #722608 in Books
Published on: 2000-01-15
Number of items: 1
Binding: Paperback
1005 pages
Editorial Reviews

Amazon.com
In addition to being a tutorial for learning how to use XML as an effective way to represent and transmit data across the Web, Professional XML Databases also covers how to work with XML in the current generation of Microsoft tools, like Internet Explorer and SQL Server 2000. For any developer or manager who works with databases on the Windows platform, this book shows how you can delve into XML today for real projects.

With endorsements from virtually every major vendor (including Microsoft), XML looks to be a compelling standard for sharing corporate data between organizations. Professional XML Databases examines how to integrate XML into your organization's database infrastructure. Early sections concentrate on the rules and strategies for designing effective XML documents (DTDs) that mimic traditional tables (including links between tables). By providing almost a dozen rules on how to do this correctly, the book assures that you'll learn not only the basics of XML syntax but also the correct way to create DTDs that are efficient, easy to maintain, and readable across your business. (Further sections reverse this process and show you how to create database tables based on XML.)

Subsequent sections cover many of the standards and APIs in today's XML, from XML Schemas, the XML W3C Document Object Model (DOM), and the Simple API for XML (SAX), to related standards like XSLT, XPath, and XPointer. A number of books cover these APIs, but this one provides a unique focus by examining Microsoft tools and their support for XML. This means there is coverage of Microsoft ADO (and ADO+, now called ADO.NET) for querying databases and packaging the results as XML. Sections on SQL Server 2000 highlight ways to use XML in this product, both as results and through XML views.

Closing sections explore options for working with XML for data warehousing and transmitting data efficiently across organizations. Sections on Java and the DB Prism (an open-source XML framework) help give this book a perspective that extends beyond the Microsoft platform.

For any database developer or designer who needs to architect XML documents in order to share data in real projects, this advanced treatise on the right way to define and use XML will prove highly valuable. For anyone who uses SQL Server 2000, this book also points the way toward using XML standards in actual shipping products on the Microsoft platform. --Richard Dragan

Topics covered:
Hints for effective XML document design (including XML for text and XML for databases)
Designing XML for existing database tables
Creating database tables from XML
Standards guidelines for XML used within (and between) organizations
XML Schemas
The XML W3C Document Object Model (DOM)
Using the Simple API for XML (SAX)
XSLT
XPath used with style sheets and templates
Resource linking with XLink
Overview of additional emerging XML-based standards (including XBase, XInclude, XHTML, and XForms)
The XML Query language
Converting between flat file databases and XML
Introduction to Microsoft ADO, ADO+ (ADO.NET), and XML
Storing and retrieving XML in SQL Server 2000 (including OPENXML and XML views)
Tutorial for JDBC programming
JDBC used with XML
Data warehousing
Data transmission with XML
The Simple Object Access Protocol (SOAP)
Marshalling and presentation with XML (including a WML example for generating wireless content)
Sample case studies for SQL Server 2000 showing XML techniques
DB Prism (an open-source dynamic XML framework)
XML and database primers
References for XML datatypes and SAX

Book Info
A text for programmers and analysts familiar with XML and relational databases, focusing on the development and implementation of XML databases. Looks at key issues in structuring, formatting, accessing, and storing documents, also discussing techniques for data transmission, marshalling, and presentation. Softcover.

From the Publisher
This book has been selected by the editors of Wrox Press to be part of the Wroxbase website.

While this book will discuss some conceptual issues, its focus is on development and implementation. This is a book for programmers and analysts who are already famaliar with both XML and relational databases.
Customer Reviews

Book Rocks!!
this is very well written book. the material presented in this book are exhaustive and gets you good insight on how xml would be used with dbms. the chapters 2,3 and 4 are very informatiove as they list ou tthe steps required for converting db table to xml and vice versa.

No details on NATIVE XML DBs???
Interesting that you basically ignore native XML DBs. They are the definitive choice in most XML Document Centric environments. While RDBs remain quite strong in XML Data Centric models, they must resort to BLOBs or risk an order of magnitude of sluggishness compared to native XML DBs, such as our GoXML DB. Even with BLOBs, you cannot create a new document from multiple existing documents because of the columnar structure. The lack of a full table of contents when your title is 'Professional XML Databases' is disappointing...

Concerned XML Enthusiast

Good overview of new XML and database trends
I read through this book at more of an advanced developer level, so I'm going to treat it from that level.

The chapter on XQuery was great; it answered many of my questions concisely. There is very little information on the web about XQuery outside the W3.org site, so I was surprised to find such high quality information in a book.

XPath is also a newer API that is covered well in this book, giving you enough information to get your project going.

If you're planning to do any kind of development with XML coming in or going out of a relational database, this is an excellent book to buy. I also recommend Professional XML from Wrox and O'Reilly's XML in a nutshell.

Professional SQL Server 2005 XML (Programmer to Programmer) by Scott Klein

Product Description

Discusses SQL Server 2005 XML from the server and client sides
Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET
Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET
Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices
Product Details
Amazon Sales Rank: #314875 in Books
Published on: 2006-01-11
Number of items: 1
Binding: Paperback
552 pages
Editorial Reviews

Download Description
Discusses SQL Server 2005 XML from the server and client sides Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices

About the Author
Scott Klein is a software developer and architect, and his passion for SQL Server, .NET, and all things XML led him to Greenville, South Carolina, where he currently works as a SQL/.NET developer for CSI, a software solutions company. He has written several articles for TopXML (www.TopXLM.com) and is a frequent speaker at SQL Server and .NET user groups around Greenville and the surrounding areas. When he is not sitting in front of a computer or spending time with his family, he can usually be found aboard his Yamaha at the local motocross track.

Download Description
Discusses SQL Server 2005 XML from the server and client sides Examines using XSLT to render the XML data that is retrieved from SQL Server, particularly for ASP.NET Addresses SQL Server relationship with schemas, SOAP, XML security, and .NET Makes extensive use of examples to solve problems that programmers face on an everyday basis and features Server 2005 XML best practices
Customer Reviews

lazy edition
I didn't read all of it but the code samples in the first 3 chapters has a terrible mismatch with variables names. Some of the chapter's paragraphs are repeating them self.
I got the feeling they get to rush in this edition.
But you should take into account that i'm very pedantic.
Search inside before you make your decision.

examples and rest of book do not correlate.
Just been thru Chapter 1 - what is in the book and the snippets of the code that follow do not correlate. This is just like a developer code, wrote something and threw it across the wall for testing, never matters if the code matches requirements or not.

You Need this Book
If you are considering using XML in SQL Server 2005, this book will pay for itself quickly. The clear examples of creating XML Schema collections, altering them, etc. are very helpful.

The only problem with this book is that SQL Server 2005 does not fully support XML Schemas. Because this book was written using a beta product (I believe) perhaps the author could not have know exactly how the final version would shake out. However, partial support of standards is important to any developer. You often find out only by trial and error what is supported and what isn't. The Wrox web site offers nothing of the kind for this book. So buy this book, but be aware if you are using complex XML Schemas there may be some surprises (e.g., notation not supported).