THE XML REVOLUTION - TECHNOLOGIES FOR THE FUTURE WEB

XML shredding

With relational processing, the XML document must be stored in a relation.

Mapping from XML to relations is called shredding, which for the recipes could look like:

collection

id description

147 Some recipes used in the XML tutorial.

`id`	`description`
`147`	`Some recipes used in the XML tutorial.`

recipe

id parent title

231 147 Beef Parmesan with Garlic Angel Hair Pasta

237 147 Ricotta Pie

242 147 Linguine Pescadoro

247 147 Zuppa Inglese

253 147 Cailles en Sarcophages

`id`	`parent`	`title`
`231`	`147`	`Beef Parmesan with Garlic Angel Hair Pasta`
`237`	`147`	`Ricotta Pie`
`242`	`147`	`Linguine Pescadoro`
`247`	`147`	`Zuppa Inglese`
`253`	`147`	`Cailles en Sarcophages`

ingredient

id parent name amount unit

411 231 beef cube steak 1.5 pound

462 237 ricotta cheese 3 pound

535 247 egg yolks 4

612 247 pastry

789 612 flour 3 cup

... ... ... ... ...

`id`	`parent`	`name`	`amount`	`unit`
`411`	`231`	`beef cube steak`	`1.5`	`pound`
`462`	`237`	`ricotta cheese`	`3`	`pound`
`535`	`247`	`egg yolks`	`4`
`612`	`247`	`pastry`
`789`	`612`	`flour`	`3`	`cup`
`...`	`...`	`...`	`...`	`...`

preparation

id parent

376 231

... ...

`id`	`parent`
`376`	`231`
`...`	`...`

step

id parent text

423 376 Preheat oven to 350 degrees F (175 degrees C).
... ... ...

`id`	`parent`	`text`
`423`	`376`	`Preheat oven to 350 degrees F (175 degrees C).`
`...`	`...`	`...`

comment

id parent text

... ... ...

`id`	`parent`	`text`
`...`	`...`	`...`

nutrition

id parent calories fat carbohydrates protein alcohol

... ... ... ... ... ... ...

`id`	`parent`	`calories`	`fat`	`carbohydrates`	`protein`	`alcohol`
`...`	`...`	`...`	`...`	`...`	`...`	`...`

In this construction, we have:

one relation for each element type
a unique id for each occurrence of an element
identifications of the parent nodes
the ids of siblings are ordered