Re: [bdbxml] metadata queries

Hi Mark,

These are very open ended questions, and are probably best answered by 
reading some of the documentation for DB XML.

Introduction to Berkeley DB XML:
http://www.sleepycat.com/xmldocs/intro_xml/BerkeleyDBXML-Intro.pdf

Getting Started Guide:
http://www.sleepycat.com/xmldocs/gsg_xml/cxx/index.html

C++ API Documentation:
http://www.sleepycat.com/xmldocs/api_cxx/frame.html

DB XML also implements XQuery as it's query language. There are lots of 
articles onthe internet about how to use XQuery, but here are some to 
get you going:

http://www.w3.org/XML/Query/#other

John Snelson

Mark Robert Salamon wrote:
> I had two questions related to metadata-based queries.  first, what 
> operators are available?  I'm sure that the =, >, etc. queries are 
> available.  Are any of the following SQL-like operators available (or 
> their equivalent), and can someone show me an example of each:
>  
>     between
>  
>     is null
>  
>     is not null
>  
>     in(a,b,c...)
>  
>     substring()/like -- and any wildcard or regex characters
>  
> Second, how do you combine multiple queries together (metadata or 
> regular ones), and can you provide examples.  For example, if I want to 
> look for documents with metadata author='jsmith' and date-created > 
> 2005-01-01, how would I do that?  similar if i'm combining metadata and 
> regular queries at once.  in other words, are the AND and OR operators 
> available for querying metadata and xml data and what is the syntax like.
>  
> Thanks!


-- 
John Snelson, Berkeley DB XML Engineer
Sleepycat Software, Inc
http://www.sleepycat.com

Contracted to Sleepycat through Parthenon Computing Ltd
http://blog.parthcomp.com/dbxml


------------------------------------------
To remove yourself from this list, send an
email to [email protected]