473,320 Members | 1,926 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,320 software developers and data experts.

Options for generic full-text search without using database-specific full-text engine?


What options are available for doing full-text searches of database
data without using a database-specific full-text engine?

The only option I've found is Google's Search Appliance but it's an
expensive hardware solution and we prefer a software solution.

In the past I've used development languages that had OEM Verity
support which was wonderful but as far as I can tell the only
out-of-the-box search available in ASP.NET is Index Server which
indexes only documents, not database content. I also didn't see
anything available retail from Verity.

DotLucene also seems to be only for documents, although I'm sure we
could write some middleware to extract database data and serve it up
to DotLucene as a document (which is basically what Google's appliance
does). We could to the same thing using Index Server, it's just a lot
of hassle.

Other options?

The reason we're looking for a database-agnostic approach is the
application is currently written for Sybase but we're hoping to switch
it to MSSQL in the future and also would ideally like to be able to
reuse this module with our Oracle based applications.

Thanks,

Sam

Nov 19 '05 #1
2 919
Sam,

Why not abstract out what you need the database to do, and then write a
general framework around that? Basically, have an interface which will
perform the search, or call to the database (in the implementation). Then,
when you migrate, you don't have to change your code, you just have to
substitute the implementation of that interface to something MSSQL specific.

This way, you can write the part of the engine which will take the
results from the database and then send them off to whatever application you
need.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Samuel R. Neff" <in**********@newsgroup.nospam> wrote in message
news:te********************************@4ax.com...

What options are available for doing full-text searches of database
data without using a database-specific full-text engine?

The only option I've found is Google's Search Appliance but it's an
expensive hardware solution and we prefer a software solution.

In the past I've used development languages that had OEM Verity
support which was wonderful but as far as I can tell the only
out-of-the-box search available in ASP.NET is Index Server which
indexes only documents, not database content. I also didn't see
anything available retail from Verity.

DotLucene also seems to be only for documents, although I'm sure we
could write some middleware to extract database data and serve it up
to DotLucene as a document (which is basically what Google's appliance
does). We could to the same thing using Index Server, it's just a lot
of hassle.

Other options?

The reason we're looking for a database-agnostic approach is the
application is currently written for Sybase but we're hoping to switch
it to MSSQL in the future and also would ideally like to be able to
reuse this module with our Oracle based applications.

Thanks,

Sam

Nov 19 '05 #2
Have you considered storing your text seperately from the database in .txt
files? The file naming convention could be based on the primary key ID of
the record that would normally contain the text column. Once done, you
choice of search indexing methods is more flexible.
"Samuel R. Neff" <in**********@newsgroup.nospam> wrote in message
news:te********************************@4ax.com...

What options are available for doing full-text searches of database
data without using a database-specific full-text engine?

The only option I've found is Google's Search Appliance but it's an
expensive hardware solution and we prefer a software solution.

In the past I've used development languages that had OEM Verity
support which was wonderful but as far as I can tell the only
out-of-the-box search available in ASP.NET is Index Server which
indexes only documents, not database content. I also didn't see
anything available retail from Verity.

DotLucene also seems to be only for documents, although I'm sure we
could write some middleware to extract database data and serve it up
to DotLucene as a document (which is basically what Google's appliance
does). We could to the same thing using Index Server, it's just a lot
of hassle.

Other options?

The reason we're looking for a database-agnostic approach is the
application is currently written for Sybase but we're hoping to switch
it to MSSQL in the future and also would ideally like to be able to
reuse this module with our Oracle based applications.

Thanks,

Sam

Nov 19 '05 #3

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

Similar topics

49
by: Steven Bethard | last post by:
I promised I'd put together a PEP for a 'generic object' data type for Python 2.5 that allows one to replace __getitem__ style access with dotted-attribute style access (without declaring another...
17
by: John Bentley | last post by:
John Bentley: INTRO The phrase "decimal number" within a programming context is ambiguous. It could refer to the decimal datatype or the related but separate concept of a generic decimal number....
17
by: Andreas Huber | last post by:
What follows is a discussion of my experience with .NET generics & the ..NET framework (as implemented in the Visual Studio 2005 Beta 1), which leads to questions as to why certain things are the...
4
by: Cool Guy | last post by:
I don't understand the third paragraph under the heading 'Generic type instantiations' on <http://msdn.microsoft.com/vcsharp/2005/overview/language/generics/>: | The .NET Common Language Runtime...
1
by: INeedADip | last post by:
I am trying to use the following generic (reflection) class as the ICamparer parameter for a generic list..but I get the error: "Unable to cast object of type 'GenericComparer' to type...
0
by: Wiktor Zychla [C# MVP] | last post by:
We do have generic classes, methods and delegates. My question is: what reason prevents us from having generic properties and indexers? // impossible public List<T> GetList<T> { get { ... }
9
by: mps | last post by:
I want to define a class that has a generic parameter that is itself a generic class. For example, if I have a generic IQueue<Tinterface, and class A wants to make use of a generic class that...
3
by: Boris | last post by:
I have a class which should like this ideally: generic <typename T> public ref class ManagedClass { T ^managedMember; UnmanagedClass<U*unmanagedMember; }; I actually would like to specify...
9
by: tadmill | last post by:
Is it possible to pass a generic parameter of the same class to to its constructor, where the "T" type passed in the constructor is different than the "T" type of the instanced class? ie, ...
2
by: ADN | last post by:
Hi, I have a method which calls my service factory: class person { public int ID { get; set: } public string Name {get; set;} } IList<Personmypeople = __serviceFactory.Fetch(new Person())
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.