[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/