Search relevance from XML docs (XQuery?) vs MySQL

Posted by Marius on Stack Overflow See other posts from Stack Overflow or by Marius
Published on 2010-04-15T11:36:47Z Indexed on 2010/04/15 13:03 UTC
Read the original article Hit count: 245

Filed under:

xquery

|

search-engine

|

Xml

|

speed

|

relevance

Hello there,

I have a website where documents are saved in xml documents, all with the same structure.

I need a search engine where I am able to choose documents with the highest relevance according to the key words given by a searching user.

I thought it could (?) be a good idea to have one using XQuery rather than having the information stored twice (in XML docs + mysql database) and querying the mysql database for relevance searches.

Is XQuery any good for this, and how, and what speed can I expect on +1000 documents of about 7kb each.

Thank you for your time.

Kind regards

© Stack Overflow or respective owner

Related posts about xquery

Bind a Java Collection to xQuery sequence from xQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
declare function Error:toString($this as javaObject) as xs:string external; the previous binds a return String() to xs:string. is it possible to return a collection and bind it to an xQuery Sequence, say the following declare function Error:toList($this as javaObject) as squenceType external; so… >>> More
XQuery - problem with recursive function

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, Im new on this project and am going to write, what i thought was a simple thing. A recursive function that writes nested xml elements in x levels (denoted by a variable). So far I have come up with this, but keeps getting a compile error. Please note that i have to generate new xml , not query… >>> More
Ten Problems with XQuery and the SQL/XML Standard

as seen on Internet.com - Search for 'Internet.com'
XQuery and SQL/XML standard are processors for XML. SQL/XML was designed to try to match the capabilities of XQuery as closely as possible and XQuery was designed not only to support XML, but also to support relational processing. Read on to learn why this may have a negative influence on their capabilities… >>> More
How can I remove duplicate nodes in XQuery?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an XML document I generate on the fly, and I need a function to eliminate any duplicate nodes from it. My function looks like: declare function local:start2() { let $data := local:scan_books() return <books>{$data}</books> }; Sample output is: <books> <book> … >>> More
XQuery method question, trying to sum values read from xml

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm pretty new to XQuery and I'm trying to write an example function that I can't get to work. I want to read an xml file, parse out the "time" values, sum them as they're read and return the sum. This is trivial and I'm looking to build more functionality into it but I'd like to get this working… >>> More

Related posts about search-engine

Search Engine Optimisation - Google Replaces Yahoo As T-Mobile's Default Search Engine

as seen on Ezine Articles - Search for 'Ezine Articles'
Competition has been stoked in the mobile search engine optimisation (SEO) sector with the announcement that Google is to replace Yahoo as T-Mobile's default engine. While T-Mobile USA has replaced Yahoo with Google as its default search on mobile phones such as RIM BlackBerrys, some Yahoo-based services… >>> More
Search Engine Optimization - The Importance of Page Optimization in Search Engine Optimization

as seen on Ezine Articles - Search for 'Ezine Articles'
In order for your website to rank well, your internal linking structure is critical to your success. This is covered some of the theory for this in various articles and blogs about Page Structure of a website, which said how you should map out the physical linking structure, but in this guide I will… >>> More
How to Improve Search Engine Ranking by On-Page Search Engine Optimization

as seen on Ezine Articles - Search for 'Ezine Articles'
There are two types of search engine optimization (SEO) techniques: on-page and off-page SEO. With on-page SEO, you have full control of all the techniques and methods you can use on your own sites. With off-page SEO, you will try some techniques to get other site owners to refer to your site which… >>> More
Search Engine Optimization For Great Search Engine Placement!

as seen on Ezine Articles - Search for 'Ezine Articles'
Do you do enough search engine optimization to get the search engine placement that you want for the keywords that you want to rank for? If not then read on and I will give you information that you need to know to start getting those rankings that you want, and start receiving traffic! There are a… >>> More
Search Engine Optimization - Use of META Tag in Search Engine Marketing

as seen on Ezine Articles - Search for 'Ezine Articles'
Want your WEBPAGE to land in the 1st PAGES of Google and Yahoo search engines? Then, make use of this powerful META TAG in your webpage/s, and you will have the result you have been aching for ages. >>> More