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

3.1 Data Search Overview

This section explains the basic approach to searching for XML documents stored in Shunsaku.

• A search expression is used to search for particular XML documents stored in Shunsaku.
• A sort expression is used to change the sequence in which XML documents are returned.
• A return expression is used to decide which elements will be aggregated or extracted from the XML documents that are found by a search.
• A group key that is a key used when performing aggregation to group XML documents that match specified search conditions is selected when aggregation is to be performed. The group key is specified in the sort expression.

The following diagram illustrates the process used to search for XML documents stored in Shunsaku.

[Figure 3-1 Overview of the Search Process for XML Documents Stored in Shunsaku]

Refer to Appendix B Format of Search, Return and Sort Expressions for more information on search expressions, return expressions and sort expressions.

 

The explanations in the following sections use a 'Business Trip Report' as an example. Assume that the following XML document exists:

Sample Document

<doc>
  <employee eno= "Employee number" position = "Position" >    Employee information
    <name>Employee name</name>
    <department sno= "Section number" >Section name</department>
    <phone>Extension</phone>
    <email>address</email>
  </employee>
  <basic date= "Trip date" expense= "Trip expenses" >    Basic information
    <classification code= "Classification code" >Classification</classification>
  </basic>
  <detail>                                       Details
    <destination area= "Trip area">Trip destination</destination>
    <purpose>Trip purpose</purpose>
    <train>Traveling expenses</train>
    <taxi>Taxi fares</taxi>
    <hotel>Accommodation costs</hotel>
    <comment>Comments</comment>
  </detail>
  <reportE>Trip report</reportE>            Trip report
</doc>
<doc>
   :
   :