H.1 Searching Data

Interstage Shunsaku Data Manager Application Development Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

Contents Index

Appendix H Sample VB .NET Programs

H.1 Searching Data

Use the APIs provided by Shunsaku to obtain search results by specifying search conditions for the data to be retrieved.

VB .NET can be used to perform the following operations:

Obtain the number of XML documents that match search conditions
Obtain the XML documents that match search conditions in a specified format
Obtain every instance of specific XML documents
Sort and return XML documents that match search conditions
Aggregate and return the values of XML documents that match search conditions

Refer to the .NET API Reference for more information on VB .NET.

This section uses the example of a hotel reservation status search system to explain the search operation.

For the purposes of this explanation, it is assumed that the following XML document exists.

Refer also to Appendix E Notes on XML Documents for more information on XML documents.

Sample Document

<document>
    <base>
        <name>Hotel 1</name>
        <city>Sydney</city>
        <address>Bondi Beach</address>
        <detail>http://xxxxx.com.au</detail>
        <price>350</price>
    </base>
    <information>
        <date>2006/07/18</date>
    </information>
    <note>En-suite bathroom and toilet, two minutes' walk to train station XX</note>
</document>
<document>
    <base>
        <name>Hotel 2</name>
        <city>Sydney</city>
        <address>Bondi Beach</address>
        <detail>http://xxxxx.com.au</detail>
        <price>150</price>
    </base>
    <information>
        <date>2006/07/18</date>
    </information>
    <note>En-suite bathroom and toilet, five minutes' walk to train station XX</note>
</document>
<document>
    <base>
        <name>Hotel 3</name>
        <city>Sydney</city>
        <address>Bondi Beach</address>
        <detail>http://xxxxx.com.au</detail>
        <price>250</price>
    </base>
    <information>
        <date>2006/07/18</date>
    </information>
    <note>En-suite bathroom and toilet, ten minutes' walk to train station XX</note>
</document>
<document>
    <base>
        <name>Hotel 4</name>
        <city>Sydney</city>
        <address>Paddington</address>
        <detail>http://xxxxx.com.au</detail>
        <price>500</price>
    </base>
    <information>
        <date>2006/07/10</date>
    </information>
    <note>En-suite bathroom and toilet, three minutes' walk to train station ZZ </note>
</document>
<document>
    <base>
        <name>Hotel 5</name>
        <city>Sydney</city>
        <address> Paddington</address>
        <detail>http://xxxxx.com.au</detail>
        <price>150</price>
    </base>
    <information>
        <date>2006/07/10</date>
    </information>
    <note>En-suite bathroom and toilet, two minutes' walk to train station ZZ</note>
</document>
<document>
    <base>
        <name>Hotel 6</name>
        <city>Adelaide</city>
        <address> Clearview Adelaide</address>
        <detail>http://xxxxx.com.au</detail>
        <price>300</price>
    </base>
    <information>
        <date>2006/07/18</date>
    </information>
    <note>En-suite bathroom and toilet, two minutes' walk to train station XX</note>
</document>
<document>
    <base>
        <name>Hotel 7</name>
        <city>Adelaide</city>
        <address>Clearview Adelaide</address>
        <detail>http://xxxxx.com.au</detail>
        <price>200</price>
    </base>
    <information>
        <date>2006/07/18</date>
    </information>
    <note>En-suite bathroom and toilet, three minutes' walk to train station XX</note>
</document>
<document>
    <base>
        <name>Hotel 8</name>
        <city>Adelaide</city>
        <address>Clearview Adelaide</address>
        <detail>http://xxxxx.com.au</detail>
        <price>100</price>
    </base>
    <information>
        <date>2006/07/18</date>
    </information>
    <note>En-suite bathroom and toilet, five minutes' walk to train station XX</note>
</document>

H.1.1 Obtaining the Number of XML Documents that Match Search Conditions
H.1.2 Obtaining XML Documents that Match Search Conditions in a Specified Format
H.1.3 Obtain Every Instance of Particular XML Documents
H.1.4 Obtaining XML Documents that Match Search Conditions after they have been Sorted
H.1.5 Aggregating the Values of XML Documents that Match Search Conditions
H.1.6 Setting the Maximum Value of Number of Hits

Contents Index