Taco, mySQL has native regex capabilities: http://www.mysql.com/doc/en/Regexp.html
I'm pretty sure postGres has as well, but don't quote me on that one. (As well as half a dozen more i'm not aware of) MSSQL, and Oracle, don't. (Oracle can do interesting 'sounds like' comparisons...) However Oracle has totolly kick butt XML handling capabilities (handle both Xpath and XSL transformation on the database server). HTH Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Taco Fleur <[EMAIL PROTECTED]>: > Mark, > > Just wanting to pull some more info out of you regarding what you said > "a database with good XML (Xpath, XSL) capabilities, or at the very least > regex capabilities." > > When you say "regex capabilities" can you tell me which dbms has native regex > capabilities? > I know MS SQL doesn't, the only way I found to get around that was by using a > VB object within a SP. > > Taco > > -----Original Message----- > From: Mark M [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 December 2003 8:41 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: XML Searching > > > Taco, > > I will make the assumption that all these XML documents are writen as files? > > As far as I am aware, you COULD verity index them, you might get some funky > search results. > > If you are dealing with large amounts of XML documents you should look into > storing them into > a database with good XML (Xpath, XSL) capabilities, or at the very least > regex capabilities. > > Having 1000 .xml files is generally not an efficient way of storing this > data. > > That should allow you to search through large amounts of XML data with more > ease. > > Mark > ------------------------------------------------------------------ > [EMAIL PROTECTED] > ICQ: 3094740 > Safe From Bees > [ www.safefrombees.com ] > > > Quoting Taco Fleur <[EMAIL PROTECTED]>: > > > Is there such a thing as indexing XML documents and searching? Sort of > like > > the Verity of coldfusion. > > I am aware of XPath but that means opening up every document before > > searching. > > > > I'd like them to be indexed and then query the collection with XPath or > > similiar. > > > > Hope it makes sense? > > > > Example; > > > > I have 1000 documents that have the elements > > > > <author>Who ever</author> > > <category>What ever</category> > > > > Index these 1000 documents, and then search the collection for all docs > that > > are in category "What ever" or by Author "Who ever" > > > > PS. I know the DTD is missing from the sample ;-)) > > > > Taco Fleur > > 07 3535 5072 > > Tell me and I will forget > > Show me and I will remember > > Teach me and I will learn > > > > > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > > > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > http://www.mxdu.com/ + 24-25 February, 2004 > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
