In my current project, we store a large amount of data in a relational database. One of the last key requirements is to enrich the application by adding some advanced search capabilities.
In the project, efficiency is one of the important factors due to the very large tables (10+ million records) with the relationship between parents and children (for example, multi-level parent-child relationships, where I look for all parents with specific children). The search engine should also be able to check these links for hits.
I found several potential engines for stack overflows, however it seems that all of them are designed more for text search than for relational db and are hosted on Linux:
As I understand it, some of them use documents as a search source, but is it possible or effective to create program documents based on my relational data? Since I am not familiar with all of their functions / capabilities, can anyone make some recommendations or suggest some other solution?
To summarize my requirements:
- framework / engine for finding a relational database, including decendants.
- Microsoft SQL Server support
- can be used in .NET applications
- preferably on Windows systems
Can any of the above solve my problem? Do you know the best solution?
Pawel source share