Design database using XML and evaluate queries.

It is a simple xml demo using altova.M5X6SH23V6Q9
You can download the altova trial version here
http://www.altova.com/download-trial/
When you download you wll get the key for trial version on your mail id.
Steps:
1)

2)

3)

4)

5)

6)

7)

 

 8)

 9)

 10)

 11)

The different queries you can evaluate!
Queries

1)
xquery version “1.0”;

{
for $i in doc (“sample.xml”)//clg_tuple
where $i/ cid
{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}

2)
xquery version “1.0”;

{
for $i in doc (“sample.xml”)//clg_tuple
where $i/ cid=3
return

{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}

3)
xquery version “1.0”;

{
for $i in doc (“sample.xml”)//clg_tuple
where $i/ cid>3
return

{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}

4)
xquery version “1.0”;

{
for $i in doc (“sample.xml”)//clg_tuple
where $i/ addr=”wagholi”
return

{
$i/cid
}
{
$i/cname
}
{
$i/addr
}

}

Advertisements