Amazon Athena vs. Apache Lucene

If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

Incentivized

Apache Lucene is a perfect text search implementation where the heap space usage needs to be kept to its minimal. It also enables search based on various search fields and most importantly the search and index process can happen simultaneously. The only scenario where it might be less appropriate would be when the index size grows too big. We have witnessed few scalable issues where the search would take a while when the index size is too large.

Incentivized

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

Incentivized

• We found Apache Lucene to be extremely performant in querying large amounts of data and retrieving the correct files based on the metadata provided.
• The online community offers great support for the product. Even though it is an open source tool, it is not difficult to find help online for it.
• When we were creating a proof of concept application, we found that the software worked just as well, while being run locally on a resource-limited PC.

Incentivized

• Response caching can be improved.
• Data Partitioning is tricky and understanding of the same could be improved.

Incentivized

• User interface for setup and maintenance would be helpful.
• Easier cloud/cluster setup.
• Better, centralized documentation.

Incentivized

Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.

Incentivized

Incentivized

The search and index performance of [Apache] Lucene is excellent and the quality of results is good, if not better. For implementing it with small scale applications it is a no brainer, Lucene is the best and most cost effective solution. Learning curve is not too steep either.

Incentivized

• The query speeds help us make more decisions in a day (speed).
• If you need more horsepower for specific times in the day this option helps scale.
• The security of your environment is well protected too.

Incentivized

• Being an open source project we did not have to pay any licensing fees for using Apache Lucene. It has greatly improved our search functionality in our web apps.

Incentivized