[xquery-talk] question about XQUERY C++ API
Michael Kay
mhk at mhk.me.uk
Thu Jan 12 15:43:23 PST 2006
I should think the performance will be fairly dreadful. Simply parsing each
of the documents, let alone running a query against them, is going to be
very time-consuming.
If you must store the documents as blobs, you should consider doing some
application-level indexing - that is, extract key features of the document
to store in separate columns of the table, and do pre-filtering in SQL using
these attributes to reduce the number of XML documents that you need to
examine.
Can't help you on the C++ side, I'm afraid.
Michael Kay
http://www.saxonica.com/
_____
From: talk-bounces at xquery.com [mailto:talk-bounces at xquery.com] On Behalf Of
Natalia Kory
Sent: 12 January 2006 15:24
To: talk at xquery.com
Subject: [xquery-talk] question about XQUERY C++ API
Hello
We need help from people who are familiar with XML filtering.
We store XML documents as blobs in the database. Since we have to support
Oracle, Sybase and MS SQL we can not use db vendor specific XML
functionality. Each document can be up to 18KB and there could be 100,000
of the documents in the database.
We need to implement filtering in our C++ application for the data stored
in the DB (i.e we need to return to the calling application a subset of the
documents that satisfy filter criteria). We plan to load XML documents into
memory one by one and then use XQUERY to filter out documents that do not
satisfy filter criteria. Can someone help us with the following questions:
1. Is there a C++ API we can use for XQUERY processing?
2. Any idea what performance will be like?
3. Is there a better approach to our problem?
Your help is greatly appreciated
Natalia Kory
Director, Product Center Treasury and Capital Markets
________________________________________________________
Misys Banking Systems
22 Cortlandt St. / 31st Floor / New York, NY 10007
T +1 212-896-3400
natalia.kory at misys.com
www.misys.com
________________________________________________________
----------------------------------------------------------------------------
----------------------------
This email and any attachments have been scanned for known viruses using
multiple scanners.
We believe that this email and any attachments are virus free, however the
recipient must
take full responsibility for virus checking. This email message is intended
for the named
recipient only. It may be privileged and/or confidential. If you are not the
intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose
its contents to any other person. You should contact Misys Banking Systems
so that we can
take appropriate action at no cost to yourself.
www.misys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://xquery.com/pipermail/talk/attachments/20060112/c52c4101/attachment.htm
More information about the talk
mailing list