ch10 - 1 Chapter 10: XML 2 Roadmap n Why XML n What is XML...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 Chapter 10: XML 2 Roadmap n Why XML n What is XML n Basic structures of XML data n How to store XML in Oracle n How to define structure of XML data n DTD (not covered) 3 Why XML n A credit bureau provides a credit scoring service. n The company collects personal financial data from credit card companies, banks, ., and store the data in a database Banks, credit card companies 4 Problem of Data Exchange n How to collect data from various banks, credit card companies? n Solution 1: define a text file format with every bank and credit card company. Then write a parser to extract data from text file. n Problem? What if some banks decide to add a column? n Solution 2: data in excel format. Problem solved? 5 Solution: XML n XML (Extensible Markup Language): n A universal format to exchange data between organizations, databases n It is extensible, and there is no need to write your own parser (can use standard tools). n XML is NOT part of relational database, although most commercial database management systems have XML support (later) 6 Benefits of XML n XML is extensible, so each application area can define its own standard format for exchanged data n DTD (Document Type Definition) n XML Schema 7 Benefits of XML n XML is self-contained and in plain text. You do not need a data schema to understand a XML document n Many tools are available for parsing, browsing and querying XML, so it is easy for programs to process XML 8 Roadmap n Why XML n What is XML n Basic structures of XML data n How to store XML in Oracle n How to define structure of XML data n DTD 9 Who Defines XML? n WWW Consortium (W3C) (a committee deciding world wide web standards) n http://www.w3.org n A good resource with tutorial, examples: http://www.w3schools.com/xml/default.asp 10 What Is in XML? n Document written in XML is called XML document (usually with .xml suffix) n Basic structures include: n Tags (like table or column names) n Elements (like tables, rows, or columns), each element has a tag n Attributes (like columns), each attribute has a tag n Text contents of elements and attributes 11 What Is in XML (cont.) n Similar to HTML, but n Tags have semantic meanings n E.g. <course> IS620 </course> n Similar to table or column-names in relational DB n Users can add new tags: similar to create table in relational DB 12 Structure of XML Data n Tag n Label for a section of data, e.g., bank, account, account-number, depositor n Similar to table name n Always in pairs: n Start tag: <tagname> n End tag: </tagname> 13 Structure of XML Data n Element : section of data beginning with...
View Full Document

Page1 / 40

ch10 - 1 Chapter 10: XML 2 Roadmap n Why XML n What is XML...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online