[SOLVED] database XML Documents

XML Documents

XML Documents

Miao Qiao

SEAT
Massey University

1

XML: Schema Definition Language

Well-formed XML: adheres to basic structural requirements.
Valid XML: adheres to content-specific specification.

Two Schema Definition Languages for XML:
Document Type Definition (DTD)
XML Schema Definition (XSD)

2

XML: Schema Definition, Schema, and Instance Document

XML Schema: the most widely used schema standard. XML schema
is developed and maintained by W3C, and is designed to define a
broad range of document structures.

URL: http://www.w3.org/2001/XMLSchema
XML Schema Definition: an XML document that defines an XML
vocabulary.

Instance Document: the document to be validated when apply XML
schema to a specific XML document.

3

http://www.w3.org/2001/XMLSchema

XML Schema and DTD

XML schema is more powerful than DTD.

XML Schema DTD
Document language XML Extended Backus Naur Form (EBNF)
Standard multiple standard single standard
Supported data type 44(19 primitives + 25 derived) 10
Mixed content easy to develop difficult to develop
Namespace completely supported only namespace prefix are supported
Entities no yes
Supported Keys global/typed keys only global keys

4

XML: Namespace

Purpose: to avoid duplicated tag names in merging XML files.
Method: prepend each tag with a Unique Resource Identifier (URI).
Namespace: define an abbreviation for URIs

An instance document with namespace:

A First Course in Database Systems

Jeffrey
Ullman

Jennifer
Widom

5

XSD: Start a Schema File

By convention, the namespace prefix, typically xsd or xs, is assigned
to the XML Schema namespace to identify elements and attributes
that belong to the XML Schema vocabulary.

The usual form of an Schema document is:

content

6

XSD: an Example

See documents Bookstore-XSD.xml and Bookstore.xsd.

7

XSD: Element Type

Simple type: an XML element that can contain only text no
attributes / subelements.

Complex type: an XML element that contains subelements or
attributes.

8

XSD: Define a Simple Type Element

Define a simple type element:

An instance of Last_Name:
Ullman

Common built-in types:
xsd:string
xsd:decimal
xsd:integer
xsd:boolean
xsd:date
xsd:time

Their instances are all texts.

9

XSD: Built-in Data Type https://www.w3.org/TR/xmlschema-2/

10

https://www.w3.org/TR/xmlschema-2/

XSD: Define a Complex Type

Define a complex type called BookType:

Declaration

Define an element of the complex type:

Or define the element directly:

Declaration

11

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

12

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

12

XSD: Define an Attribute

Define an attribute:

Define an instance with the attribute:

13

XSD: Attribute Use Indicators

Use indicator: the requirement on the appearance of an attribute.

Use is one of the following three values:
required: the attribute must always appear with the element.
optional (default): the use of the attribute is optional with the
element.

prohibited: the attribute cannot be used with the element.

Example:

See documents Bookstore.xsd and Bookstore-XSD.xml.

14

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

A complex-typed element can have any combination of the three above:
1 Empty element: contain only attributes.
2 Basic text + attributes
3 Nested child elements
4 Nested child elements + attributes
5 Mixed: Nested child elements + attributes + basic text

15

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

A complex-typed element can have any combination of the three above:
1 Empty element: contain only attributes.
2 Basic text + attributes
3 Nested child elements
4 Nested child elements + attributes
5 Mixed: Nested child elements + attributes + basic text

15

XSD: Define a Empty Element

Define an empty element of Book:

Define an instance of Book:

16

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

A complex-typed element can have any combination of the three above:
1 Empty element: contain only attributes.
2 Basic text + attributes
3 Nested child elements
4 Nested child elements + attributes
5 Mixed: Nested child elements + attributes + basic text

17

XSD: Define an Basic Text with Attributes
Define an element of Book:

Define an instance of Book:

A First Course in Database Systems

18

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

A complex-typed element can have any combination of the three above:
1 Empty element: contain only attributes.
2 Basic text + attributes
3 Nested child elements
4 Nested child elements + attributes
5 Mixed: Nested child elements + attributes + basic text

19

XSD:Define an Element with Nested Child Elements

Define an element of Author:

Define an instance of Author:

Jeffrey
Ullman

20

XSD: Order Indicators for Nested Child Elements

Order indicators: to specify the order of the appearances of the child
elements.

All: the child elements can appear in any order, and that each child
element must occur only once.

Choice: either one child element or another can occur.
Sequence: the child elements must appear in a specific order.

See documents Bookstore.xsd and Bookstore-XSD.xml.
21

XSD: Occurrence Indicators for Nested Child Elements

Occurrence indicator: to define how often an element can occur.

The default value for both maxOccurs and minOccurs is 1.

See documents Bookstore.xsd and Bookstore-XSD.xml.

22

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

A complex-typed element can have any combination of the three above:
1 Empty element: contain only attributes.
2 Basic text + attributes
3 Nested child elements
4 Nested child elements + attributes
5 Mixed: Nested child elements + attributes + basic text

23

XSD: Define an Element with Child Elements + Attributes

Define an element Book with both child elements and attributes:

See documents Bookstore.xsd and Bookstore-XSD.xml for an instance.
24

XSD: Contents of a Complex Type

Contents of a complex type:
Attribute
Basic text
Nested child element

A complex-typed element can have any combination of the three above:
1 Empty element: contain only attributes.
2 Basic text + attributes
3 Nested child elements
4 Nested child elements + attributes
5 Mixed: Nested child elements + attributes + basic text

25

XSD: Define a Mixed Element
Define a mixed element by setting its complextype attribute mixed=true.

An instance of letter:

Dear Mr. John Smith.
Your order 1032

26

XSD: Keys and Foreign Keys
Specify an attribute (ISBN) of an element (Book) is a key:

Specify an attribute (book) of an element (Book/Remark/BookRef) is a
foreign key of key BookKey defined above:

See documents Bookstore-key.xsd and Bookstore-XSD-key.xml.

27

XSD: Keys and Foreign Keys
Specify an attribute (ISBN) of an element (Book) is a key:

Specify an attribute (book) of an element (Book/Remark/BookRef) is a
foreign key of key BookKey defined above:

See documents Bookstore-key.xsd and Bookstore-XSD-key.xml.

27

XSD: Keys and Foreign Keys
Specify an attribute (ISBN) of an element (Book) is a key:

Specify an attribute (book) of an element (Book/Remark/BookRef) is a
foreign key of key BookKey defined above:

See documents Bookstore-key.xsd and Bookstore-XSD-key.xml.
27

References

W3Cschool:
https://www.w3schools.com/xml/schema_intro.asp

W3Crecommendation:
https://www.w3.org/TR/xmlschema-1/
https://www.w3.org/TR/xmlschema-2/

Chapter 10, Database System Concepts (Fifth Edition), A.
Silberschatz, H. F. Korth, S. Sudarshan.

Introduction to Databases, Stanford University.

28

https://www.w3schools.com/xml/schema_intro.asp
https://www.w3.org/TR/xmlschema-1/
https://www.w3.org/TR/xmlschema-2/