Beginning XML Databases, Wrox Beginning Guides, Gavin Powell, Book

Product Details

Pub. Date: November 2006
Publisher: Wiley, John & Sons, Incorporated
Format: Paperback, 504pp
Sales Rank: 153,150

Synopsis

Supported by all major database systems, XML provides an easy, standardized method of transferring data between databases and to and from the Web, independent of the software in use
Offers database programmers and data-driven Web developers detailed guidance on how to understand and work with XML as data
Numerous hands-on, step-by-step examples help readers learn to simplify database work using XML
Shows how to use XML to exchange data between multiple databases either internally or with external customers and partners
Covers XML in popular databases including Oracle Database, SQL Server, and brief coverage of DB2 Database
Covers basic syntax for XML, the XML DOM, and XSL – with an emphasis on database use, and native XML databases
Additional topics covered include Native XML databases, XPath, XQuery, XLink, XPointer, DTDs, XML Schemas, among others

More Reviews and Recommendations

Biography

Gavin Powell has a BSc. in Computer Science, along with numerous professional accreditations and skills. He has had a lot of practice with things like XML, Oracle, Ingres, and MSAccess, as well as a multitude of application development languages and platforms. He has almost 20 years of contracting, consulting, and hands-on educating experience—in both software development and database administration roles. He has lived, studied, and worked on three different continents, and is now scratching a living as a writer, musician, and family man. He can be contacted at creativemusician@bellsouth.net or info@oracledbaexpert.com.

Customer Reviews

Reader Rating:

Be the first to write a review!

From the Publisher

Supported by all major database systems, XML provides an easy, standardized method of transferring data between databases and to and from the Web, independent of the software in use
Offers database programmers and data-driven Web developers detailed guidance on how to understand and work with XML as data
Numerous hands-on, step-by-step examples help readers learn to simplify database work using XML
Shows how to use XML to exchange data between multiple databases either internally or with external customers and partners
Covers XML in popular databases including Oracle Database, SQL Server, and brief coverage of DB2 Database
Covers basic syntax for XML, the XML DOM, and XSL – with an emphasis on database use, and native XML databases
Additional topics covered include Native XML databases, XPath, XQuery, XLink, XPointer, DTDs, XML Schemas, among others

Product Details

Pub. Date: November 2006
Publisher: Wiley, John & Sons, Incorporated
Format: Paperback, 504pp
Sales Rank: 153,150

Table of Contents
Read a Sample Chapter

Read a Sample Chapter

Beginning XML Databases

By Gavin Powell

John Wiley & Sons

Copyright © 2007 John Wiley & Sons, Ltd
All right reserved.
ISBN: 978-0-471-79120-1

Chapter One

What Is XML?

This chapter provides a brief summary of what XML is. The abbreviation "XML" refers to eXtensible Markup Language, which means that XML is extensible or changeable. HTML (Hypertext Markup Language), on the contrary, is a non-extensible language and is the default language that sits behind many of the web pages in your web browser, along with numerous other languages.

HTML does not allow changes to web pages. HTML web pages are effectively frozen in time when they are built and cannot be changed when viewed in a browser.

Internet Explorer and Netscape are browsers used for viewing websites on the Internet.

XML, on the other hand, allows generation of web pages on the fly. XML allows storage of changeable data into web pages that can be altered at any time besides runtime. XML pages can also be tailored in look, feel, and content, and they can be tailored to any specific user looking at a web page at any point in time.

In this chapter you learn:

What XML is

What XSL is

The differences between XML and HTML

Basic XML syntax

The basics of the XML DOM

Details about different browsers and XML

The basics ofthe DTD (Document Type Definition)

How to construct an XML document

Reserved characters in XML

How to ignore the XML parser

What XML namespaces are

How to handle XML for multiple languages

Let's begin by comparing XML with HTML, the Hypertext Markup Language.

Comparing HTML and XML

XML can, in some respects, be considered an extensible form of HTML. This is because HTML is restrictive in terms of the tags it is allowed to use. In the following sample HTML document, all tags, such as , are predefined:

This is a simple HMTL page

Once more unto the breach, dear friends, once more; or close the wall up with our English dead. In peace there's nothing so becomes a man as modest stillness and humility; but when th' blast of war blows in our ears, then imitate the action of the tiger: stiffen the sinews, summon up the blood, disguise fair nature with hard-favour'd rage; then lend the eye a terrible aspect.

Cry 'Havoc !' and let slip the dogs of war, that this foul deed shall smell above the earth with carrion men, groaning for burial.

Figure 1-1 shows the execution of this script in a browser. You can see in the figure that none of the tags appear in the browser, only the text between the tags. In the preceding sample HTML page code, the tags are all predefined and enclosed within angle brackets (< ... >). An HTML document will always begin with the tag and end with the corresponding closing tag . Other tags shown in the above script are , , <BODY>, and . The tag is used for paragraphs. Unlike HTML, XML is extensible and thus is capable of being extended or modified by changing or adding features. XML can have tags of its own created (customized) that are unique to every XML document created. An XML document when embedded into an HTML page needs the predefined tag that an HTML page does, such as <HTML> and , but XML can also make up its own tags as it goes along. An important restriction with respect to the construction of XML documents that is not strictly applied in HTML code is that all tags must be contained within other tags. The root node tag is the only exception. Examine the previous HTML coding example and you will see that in the source code the first paragraph does not have a terminating tag (using the / or forward slash character). HTML does not care about this. XML does! What Is XML Capable Of? So, XML is not limited to a predefined set of tags as HTML is, but allows the creation of customized tags. The advantages of using XML could loosely be stated as follows: Flexibility with data: Any information can be placed into an XML page. The XML page becomes the data rather than the definitional container for data, as shown in Figure 1-1. Web page integration: This becomes easier because building those web pages becomes more generic. Web pages are data driven (based on content in the web page) rather than relying on the definition of the tags (programming language-driven) and where the tags are placed. Open standards: XML is completely flexible. No single software company can control and define what tags are created, what each tag means, and where in a document tags should appear. XML is a little like a completely generic programming language. Enhanced scalability and compression: When sending web pages over the Internet, XML pages can contain just data. All the coded programming tags required for HTML are not needed. Irrelevant order of data: The order in which data appears in an XML page is unimportant because it is data. Data can have things applied to it at the client site (in a browser) to change it, if you use something like eXtensible Style Sheets (XSL). What Is XSL? XSL is a formatting language that applies templating to consistent data repetitions inside XML documents. For example, an XML page containing a listing of clients and their addresses could be formatted into a nice looking table field using an XSL style sheet that showed each different client on a single row in the table, as shown in Figure 1-2. The HTML equivalent of XSL is cascading style sheets (CSS). Creating and Displaying a Simple XML Document Following is a sample XML document. The only required predefined tag is on the first line, which describes that the version of the XML parser used is version 1.0: <?xmlversion="1.0"?> <WeatherForecast date="2/1/2004"> <city> <name>Frankfurt</name> <temperature> <min>43</min> <max>52</max> </temperature> </city> <city> <name>London</name> <temperature> <min>31</min> <max>45</max> </temperature> </city> <city> <name>Paris</name> <temperature> <min>620</min> <max>74</max> </temperature> </city> </WeatherForecast> A parser is a program that analyzes and verifies the syntax of the coding of a programming language. An XML- capable browser parses XML code to ensure that is syntactically correct. As already mentioned, one parser function is to ensure that all starting and ending tags exist, and that there is no interlocking of XML tags within the document. Interlocking implies that a new tag of the same type, such as <city>, cannot be started, until the ending tag of the previous city (</city>), has been found. In a browser, the XML document looks as shown in Figure 1-3. The callouts in Figure 1-3 show that in addition to being flexible for a web pages programmer, XML is even flexible to the end user. End users are unlikely to see an XML document in this raw state, but Figure 1-3 helps to demonstrate the flexibility of XML. The primary purpose of HTML is for display of data. XML is intended to describe data. XML is the data and thus describes itself. When HTML pages contain data, they must be explicitly generated. For every web page weather report written in HTML, a new HTML page must be created. This includes both the weather report data and all HTML tags. When regenerating an XML-based weather report, only the data is regenerated. Any templates using something like XSL remain the same. And those templates are probably only downloaded once. The result is that XML occupies less network bandwidth and involves less processing power. XML is also a very capable medium for bulk data transfers that are platform and database independent. This is because XML is a universal standard. In short, XML does not do as much processing as HTML does. XML is structure applied to data. Effectively XML complements HTML rather than replaces it. XML was built to store and exchange data; HTML is designed to display data. XSL, on the other hand, is designed to format data. Try It Out Creating a Simple XML Document The data shown below represents three regions containing six countries: Africa Zambia Africa Zimbabwe Asia Burma Burma Australasia Australia Caribbean Bahamas Caribbean Barbados Here, you are going to create a single hierarchy XML document. The example shown in Figure 1-3, and its preceding matching XML data, gives you an example to base this task on. Create the XML document as follows: 1. Use an appropriate editor to create the XML document text file (Notepad in Windows). 2. Create the XML tag: <?xml version="1.0"?> 3. Create the root tag first. The data is divided up as countries listed within continents (regions). Countries are contained within regions. There are multiple regions so there has to be a tag, which is a parent tag of the multiple regions. If there was a single region there could be a single <region> tag as the root node. So create a root node such as <regions>, indicating multiple regions. The XML document now looks something like this: <?xml version="1.0"?> <regions> </regions> 4. Now add each region in as a child of the <regions> tag. It should look something like this: <?xml version="1.0"?> <regions> <region>Africa</region> <region>Asia</region> <region>Australasia</region> <region>Caribbean</region> </regions> 5. Next you can add the individual countries into their respective regions by creating individual <country> tags: <?xml version="1.0"?> <regions> <region>Africa</region> <country>Zambia</country> <country>Zimbabwe</country> <region>Asia</region> <country>Burma</country> <region>Australasia</region> <country>Australia</country> <region>Caribbean</region> <country>Bahamas</country> <country>Barbados</country> </regions> 6. When executed in a browser, the result will look as shown in Figure 1-4. How It Works You opened a text editor and created an XML document file. The XML document begins with the XML tag, identifying the version of XML is use. Next you added the root node called <regions>. All XML documents must have a single root node. Next you added four <region> nodes representing four regions into the root node. Next you added countries into the four different regions. Last, you viewed the XML document in your browser. Embedding XML in HTML Pages (Data Islands) XML documents can also be displayed in a browser using an XML data island. An XML data island is an XML document (with its data) directly or indirectly embedded inside an HTML page. An XML document can be embedded inline inside an HTML page using the HTML <XML> tag. It can also be referenced with an HTML SRC attribute. This first example uses the XML tag to embed XML document data within an HTML page: <HTML><BODY> <XML ID="xmlParts"> <?xml version="1.0" ?> <parts> <part> <partnumber>X12334-125</partnumber> <description>Oil Filter</description> <quantity>$24.99</quantity> </part> <part> <partnumber>X44562-001</partnumber> <description>Brake Hose</description> <quantity>$22.45</quantity> </part> <part> <partnumber>Y00023-12A</partnumber> <description>Transmission</description> <quantity>$8000.00</quantity> </part> </parts> </XML> <TABLE DATASRC=#xmlParts> <TR> <TD><DIV DATAFLD="partnumber"></DIV></TD> <TD><DIV DATAFLD="$text"></DIV></TD> </TR> </TABLE> </BODY></HTML> HTML and XML tags can have attributes or descriptive values. In the HTML code <IMG SRC= "image.jpg" BORDER="1"> the tag is an <IMG> or image tag for referencing an image. The SRC attribute tells the HTML <IMG> tag where to find the image, and the BORDER tag tells HTML to put a "1" pixel wide border around the image. The second example allows a reference to a separate XML file using the SRC attribute of the XML tag. The XML source file is stored externally to the HTML page. In this case, the parts.xml file is stored in the operating system and not stored within the HTML file as in the previous example: <HTML><BODY> <XML ID="xmlParts" SRC="parts.xml"></XML> <TABLE DATASRC=#xmlParts> <TR><TD><DIV DATAFLD="partnumber"></DIV></TD> <TD><DIV DATAFLD="$text"></DIV></TD> </TR> </TABLE> </BODY></HTML> Both of these examples look as the screen does in Figure 1-5. There are always different ways to do things. Try It Out XML Data Islands The XML document that follows represents the three regions and six countries created in the Try It Out exercise presented earlier in this chapter: <?xml version="1.0"?> <regions> <region>Africa</region> <country>Zambia</country> <country>Zimbabwe</country> <region>Asia</region> <country>Burma</country> <region>Australasia</region> <country>Australia</country> <region>Caribbean</region> <country>Bahamas</country> <country>Barbados</country> </regions> Here we will create a simple HTML page, containing the preceding XML document as a data island. Assume that the XML document is called countries.xml. Don't worry about a full path name. The example shown in Figure 1-5 and its preceding matching XML data island HTML pages give you an example to base this task on. Create the HTML page as follows: 1. Use an appropriate editor to create a text file. 2. Begin by creating the <HTML> tags for the start and end of the HTML page: <HTML> </HTML> 3. You could add a <HEAD> tag, allowing inclusion of a title into the browser. Begin by creating the <HTML> tags for the start and end of the HTML page: <HTML> <HEAD><TITLE>Regions and Countries

4. Add the body section for the HTML page by enclosing it between the tags:

Regions and Countries

5. Now add the tag into the body of the HTML page, which references the externally stored XML document:

Regions and Countries

6. Add a table field ( tag) to the HTML page. The table field references the tag, by the ID attribute, as shown in the code that follows. The SRC in the tag allows direct access from the HTML page to XML tags as stored in the countries.xml file. In other words, the countries.xml file is referenced from the HTML page as a referenced data island:
Regions and Countries

7. The result will look as shown in Figure 1-6, when executed in a browser.

How It Works

You created an HTML page that referenced an XML document from the HTML page as a data island. The data island is referenced from the HTML page, to the XML document, using the XML tag as defined in the HTML page. Data is scrolled through in the HTML page using an HTML table field, using the DATASRC attribute of the HTML tag.
(Continues...)

Excerpted from Beginning XML Databases by Gavin Powell Copyright © 2007 by John Wiley & Sons, Ltd. Excerpted by permission.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.
Related Subjects
Database Management
Computer Programming
Internet & World Wide Web
More by This Author
loading...
Related EssentiaLists
loading...
Fans of this Book
loading...
Search Related Categories
Nonfiction
Database design
XML (Document markup language)

Popular Categories:

Fiction Books

Children�s Books

eBook Store

Medical Books

Business Books

Used Books

Cookbooks

Learning Toys

B&N Services

About B&N

Investor Relations

Barnes & Noble, Inc

Careers at BN.com

Affiliate Network

Corporate,
Government & Libraries

Publisher & Author Guidelines

Deferred Billing

B&N Membership

Bulk Order Discounts

B&N Bookfairs

Shipping & Delivery

About Fast&Free Delivery

About Shipping

Shipping Rates

Store Returns

Quick Help

Customer Service

Order Status

Easy Returns

All Help Topics

Site Map

Terms of Use, Copyright, and Privacy Policy

© 1997-2009 Barnesandnoble.com llc

Beginning XML Databases by Gavin Powell

BUY IT NEW

BUY IT USED

Customers who bought this also bought

Product Details

Synopsis

Biography

Customer Reviews

From the Publisher

Product Details

Table of Contents

Read a Sample Chapter

Beginning XML Databases

John Wiley & Sons

Chapter One

Related Subjects

More by This Author

Related EssentiaLists

Fans of this Book

Search Related Categories

Popular Categories:

B&N Services

Shipping & Delivery

Quick Help

Beginning XML Databases by Gavin Powell

BUY IT NEW

BUY IT USED

Customers who bought this also bought

Product Details

Synopsis

Biography

Customer Reviews

From the Publisher

Product Details

Table of Contents

Read a Sample Chapter

Beginning XML Databases

John Wiley & Sons

Chapter One

Related Subjects

More by This Author

Related EssentiaListsuiAction=GetRelatedListsByEanFromProductPage&page=List&pageType=list&ean=9780471791201&productCode=BK&maxCount=5&threshold=10

Fans of this BookuiAction=GetProfileBlurbsWithEANinFavorites&page=UserProfile&pageType=profile&eanInput=9780471791201

Search Related Categories

Popular Categories:

B&N Services

Shipping & Delivery

Quick Help

Related EssentiaLists

Fans of this Book