[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML-enabled databases, XQuery APIs

• To: Ken North <kennorth@s...>
• Subject: Re: XML-enabled databases, XQuery APIs
• From: Elliotte Harold <elharo@m...>
• Date: Fri, 15 Apr 2005 05:57:28 -0400
• Cc: xml-dev@l...
• In-reply-to: <003001c54133$ae25d660$1601a8c0@DURANTE>
• References: <003001c54133$ae25d660$1601a8c0@DURANTE>
• User-agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317)

Ken North wrote:

> When you store a document in a text column, it's searchable using SQL queries.
> Those queries use the indexing capabilities of software such as Oracle
> interMedia Text Cartridge, DB2 Text Extender and Microsoft Search service.

Yes, but suppose I want to find all occurrences of the string "Now is 
the time for all good men to come to the aid of their country." XML 
unaware full text search would not normally find "<strong>Now</strong> 
is the time for all good men to come to the aid of their country."

More importantly, if I have XML data then I normally want to use the 
markup to delimit and index the searches. For instance, I might want to 
find all prescriptions of Xanax with a dosage of 5mg, not all 
occurrences of the word "Xanax" somewhere near the text "5mg". If we're 
just storing everything in a CLOB, we might as well be using flat files. 
The markup has meaning. It should be used to inform and optimize the 
queries.

-- 
Elliotte Rusty Harold  elharo@m...
XML in a Nutshell 3rd Edition Just Published!
http://www.cafeconleche.org/books/xian3/
http://www.amazon.com/exec/obidos/ISBN=0596007647/cafeaulaitA/ref=nosim

• Follow-Ups:
  • Re: XML-enabled databases, XQuery APIs
    • From: "Ken North" <kennorth@s...>
  • Re: XML-enabled databases, XQuery APIs
    • From: Ronald Bourret <rpbourret@r...>
  • Re: XML-enabled databases, XQuery APIs
    • From: Robert Koberg <rob@k...>
  • Re: XML-enabled databases, XQuery APIs
    • From: David Lyon <david.lyon@c...>

• References:
  • XML-enabled databases, XQuery APIs
    • From: "Ken North" <kennorth@s...>

• Prev by Date: Re: [ANN] smallx XML Infoset and Pipeline Released (OpenSource)
• Next by Date: Re: XML-enabled databases, XQuery APIs
• Previous by thread: Re: XML-enabled databases, XQuery APIs
• Next by thread: Re: XML-enabled databases, XQuery APIs
• Index(es):
  • Date
  • Thread