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
2  2197 
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.co m
"Samuel R. Neff" <in**********@n ewsgroup.nospam > wrote in message
news:te******** *************** *********@4ax.c om...
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
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**********@n ewsgroup.nospam > wrote in message
news:te******** *************** *********@4ax.c om...
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 class). Any
comments would be appreciated!
Thanks!
Steve
----------------------------------------------------------------------
|
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. "Decimal Number" sometimes serves to distinguish Base 10
numbers, eg "15", from Base 2 numbers, Eg "1111". At other times "Decimal
Number" serves to differentiate a number from an integer. For the rest of this
post I shall only use either...
|
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 way they
are.
***** Summary & Questions *****
In a nutshell, the current .NET generics & .NET framework make it
sometimes difficult or even impossible to write truly generic code.
For example, it seems to be impossible to write a truly generic
|
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 creates a specialized copy of the
| native code for each generic type instantiation with a value type,
| but shares a single copy of the native code for all reference
| types (since, at the native code level, references are just
| pointers with...
|
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
'System.Collections.Generic.IComparer `1'
My code looks like the following:
List<AccountDB.Queue> oList = getAllQueuesFunction();
oList.Sort(New GenericComparer("QueueName"));
| | |
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
{
...
}
|
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 implements IQueue<Tfor
all types T (so it can make use of queues of various object types
internally). As useful as this is, it doesn't seem possible. The natural (but
illegal) notation would be something like
class A<QueueClasswhere QueueClass :...
|
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 the type U depending on the type T. As
|
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,
public class SomeList<T>
{
public SomeList(SomeList<TthisSomeList)
|
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())
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
