Skip to main content
Software Engineering

Return to Question

deleted 115 characters in body; added 8 characters in body; edited body
Source Link
Robert Harvey
Robert Harvey
  • 200.7k
  • 55
  • 470
  • 683

Why don't any of the major RDBMS systems like MySQL, SQL Server, Oracle, etc. have good full text indexing support? 

I realize that most databases support full text indexes to some degree, but that they are usually slower, and with a smaller feature set. It seems that every time you want a really good full text index, you have to go outside the database and use something like Lucene/Solr or Sphinx. 

Why isn't the technology in these full text search engines completely integrated into the database engine.? There's lot of problems with keeping the data in another system such as Lucence, including keeping the data up to date, and the inability to join the results with other tables. Is there a specific technological reason why these two technologies can't be integrated? Or is it just laziness on the part of the RDBMS developers, because they have a solution that is "good enough"?

Why don't any of the major RDBMS systems like MySQL, SQL Server, Oracle, etc. have good full text indexing support? I realize that most databases support full text indexes to some degree, but that they are usually slower, and with a smaller feature set. It seems that every time you want a really good full text index, you have to go outside the database and use something like Lucene/Solr or Sphinx. Why isn't the technology in these full text search engines completely integrated into the database engine. There's lot of problems with keeping the data in another system such as Lucence, including keeping the data up to date, and the inability to join the results with other tables. Is there a specific technological reason why these two technologies can't be integrated? Or is it just laziness on the part of the RDBMS developers, because they have a solution that is "good enough"?

Why don't any of the major RDBMS systems like MySQL, SQL Server, Oracle, etc. have good full text indexing support? 

I realize that most databases support full text indexes to some degree, but that they are usually slower, and with a smaller feature set. It seems that every time you want a really good full text index, you have to go outside the database and use something like Lucene/Solr or Sphinx. 

Why isn't the technology in these full text search engines completely integrated into the database engine? There's lot of problems with keeping the data in another system such as Lucence, including keeping the data up to date, and the inability to join the results with other tables. Is there a specific technological reason why these two technologies can't be integrated?

Source Link
Kibbee
Kibbee
  • 609
  • 7
  • 11

Why don't databases have good full text indexes

Why don't any of the major RDBMS systems like MySQL, SQL Server, Oracle, etc. have good full text indexing support? I realize that most databases support full text indexes to some degree, but that they are usually slower, and with a smaller feature set. It seems that every time you want a really good full text index, you have to go outside the database and use something like Lucene/Solr or Sphinx. Why isn't the technology in these full text search engines completely integrated into the database engine. There's lot of problems with keeping the data in another system such as Lucence, including keeping the data up to date, and the inability to join the results with other tables. Is there a specific technological reason why these two technologies can't be integrated? Or is it just laziness on the part of the RDBMS developers, because they have a solution that is "good enough"?