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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s