hi Stuart Fyffe-Collins ,
Ask this question ,i have two purpose :1) i want to know the detail information about indexing mechanisms in tamino. 2) i want to create an index relationship between the derictory file and detail content file, which in order to fast queries, but i am not very clear which index mechanism i should use.
Sorry to tell you that i am a chinese student so that i can’t use the english language freely.
I will describe my question in detail:
In my “book derictory database” design, I want to define two schema to describe the structure of two xml document. one xml document is used to store the book dirctory , another is used to store the book detail information .
The book dirctory instances is like this( you can see the attach ,it may be clear):
<book_directory>
<first_directory>
<first_directory_name>computer book </first_directory_name>
<second_directory>
<second_directory_name> databases </second_directory_name>
<third_directory_leafnode> oracle </third_directory_leafnode>
<third_directory_leafnode> sql server 2000 </third_directory_leafnode>
<third_directory_leafnode> db2 </third_directory_leafnode>
</second_directory>
<second_directory>
<second_directory_name> programe language </second_directory_name>
<third_directory_leafnode> java </third_directory_leafnode>
<third_directory_leafnode> c++ </third_directory_leafnode>
</second_directory>
<second_directory_leafnode> hardware book </second_directory_leafnode>
</first_directory>
<first_directory>
…
</first_directory>
</book_directory>
book detail information instances is like this:
a
…
…
b
…
…
c
…
…
…
e
…
…
f
…
…
…
h
…
…
g
…
…
…
if query is:
_xql=book_directory/second_directory/[second_directory_name=“databases”]
then it will query in the book detail file ,and result book is a,b,c,e,f
if query is :
_xql=book_directory/second_directory/[third_directory_leafnode=“orcale”]
then it will query in the book detail file ,and result book is a,b,c
which type index should i use that can made the query fast.
[/LIST]
[This message was edited by lisa on 29 Apr 2003 at 21:05.]
instance.txt (1.57 KB)
#webMethods#Tamino#API-Management