473,322 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Which ms technology for searching xml documents?


Hi,
We have an ASP.NET site,and a data base which contains different types of
XML documents
I would like to ask which technology is best to use for searching XML
documents.
My concern is that a 'simple' search on the XML document can retrieve wrong
results
if the search will ignore the fact that the XML have a schema inside
for example assuming I have simple XML

<FirstName>Julia the Last<FirstName>
<LastName>Adriano<LastName>

Running query to look for 'Last' will also find the LastName 'Tag'
Thanks in advance


Nov 17 '05 #1
3 1139
I would say that XPath is the way to go. That's what it is for, after
all.

On Wed, 1 Jun 2005 11:50:19 +0200, "Julia" <co********@012.net.il>
wrote:

Hi,
We have an ASP.NET site,and a data base which contains different types of
XML documents
I would like to ask which technology is best to use for searching XML
documents.
My concern is that a 'simple' search on the XML document can retrieve wrong
results
if the search will ignore the fact that the XML have a schema inside
for example assuming I have simple XML

<FirstName>Julia the Last<FirstName>
<LastName>Adriano<LastName>

Running query to look for 'Last' will also find the LastName 'Tag'
Thanks in advance


Nov 17 '05 #2
..NET v2 solves this spectacularly by allowing xpath subqueries in TSQL. In
..NET v1.1 and previous though, you have at least two choices a) use an XML
based database to store your documents, or b) retreive each row and check
contents using XmlDocument.Select() or the other classes in the System.Xml
namespace.

"Julia" <co********@012.net.il> wrote in message
news:uU**************@TK2MSFTNGP10.phx.gbl...

Hi,
We have an ASP.NET site,and a data base which contains different types of
XML documents
I would like to ask which technology is best to use for searching XML
documents.
My concern is that a 'simple' search on the XML document can retrieve
wrong
results
if the search will ignore the fact that the XML have a schema inside
for example assuming I have simple XML

<FirstName>Julia the Last<FirstName>
<LastName>Adriano<LastName>

Running query to look for 'Last' will also find the LastName 'Tag'
Thanks in advance

Nov 17 '05 #3
Julia <co********@012.net.il> wrote:
We have an ASP.NET site,and a data base which contains different types of
XML documents
I would like to ask which technology is best to use for searching XML
documents.
My concern is that a 'simple' search on the XML document can retrieve wrong
results
if the search will ignore the fact that the XML have a schema inside
for example assuming I have simple XML

<FirstName>Julia the Last<FirstName>
<LastName>Adriano<LastName>

Running query to look for 'Last' will also find the LastName 'Tag'


Have you tried XPath? That would be my first port of call.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
by: jblazi | last post by:
I should like to search certain characters in a string and when they are found, I want to replace other characters in other strings that are at the same position (for a very simply mastermind game)...
3
by: sal achhala | last post by:
I'm working with java and XML documents in order to search for keywords in a given element name, eg element name 'author' == "jo blogs". The problem is the XML documents are downloaded (this...
6
by: Mike King | last post by:
I have an XML document that I need to be displayed with a specific format/layout. I have been using XML for awhile now, but I'm not familiar with every XML technology out in use. What would be...
16
by: Steven T. Hatton | last post by:
I wanted to take a look at the actual C Programming Language specification which provides the libraries used by C++ in the <c*> Headers. A couple days ago, I found it freely available on the...
0
by: Kenneth P | last post by:
Hi, Visiting Microsofts download and searching for documents I can read that v2.6, 2.7 and 2.8 don´t support Microsoft jet (which I assume means access) and thus leaves me with MDAC 2.5. Is...
2
by: Spencer | last post by:
We have z/OS and DB2 v7. I have various fields on tables that I need to perform searching through using the LIKE operator and wildcards such as %. Currently on our million row plus tables the...
3
by: renjucool | last post by:
hi, i am working electronic document management system store documents word excel adobe in database in binary format in sql server 2005. i want to search the contents from the binary data.I am...
0
by: ASPnewb1 | last post by:
Hello, I'm trying to execute a find command on my Excel obj to find if a value exists in only one column, not the whole worksheet, what I had before that works (if the whole worksheet is...
0
jkmyoung
by: jkmyoung | last post by:
Our department has recently moved to storing word, excel, and pdf documents in sharepoint. However, searching for files within the site remains a problem. Does anyone have a link as to how to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.