TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Amazon Athena

    Score7.5 out of 10
    N/AAmazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…

    $5

    per TB of Data Scanned

    Azure AI Search

    Score8.9 out of 10
    N/AAzure AI Search (formerly Azure Cognitive Search) is enterprise search as a service, from Microsoft.

    $0.10

    Per Hour

    Pricing
    Amazon AthenaAzure AI Search
    Editions & Modules
    Price per Query
    $5.00
    per TB of Data Scanned
    Basic
    $0.101
    Per Hour
    Standard S1
    $0.336
    Per Hour
    Standard S2
    $1.344
    Per Hour
    Standard S3
    $2.688
    Per Hour
    Offerings
    Pricing Offerings
    Amazon AthenaAzure AI Search
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    Amazon AthenaAzure AI Search
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Amazon Athena and Azure AI Search
    Feature
    Amazon Athena
    8.6
    4 Ratings
    2% above category average
    Azure AI Search
    -
    Ratings
    Automatic software patching8.22 Ratings00 Ratings
    Database scalability9.03 Ratings00 Ratings
    Automated backups7.73 Ratings00 Ratings
    Database security provisions9.22 Ratings00 Ratings
    Monitoring and metrics8.04 Ratings00 Ratings
    Automatic host deployment9.22 Ratings00 Ratings
    Best Alternatives
    Amazon AthenaAzure AI Search
    Small Businesses
    MongoDB Atlas
    Score7.8 out of 10
    Elasticsearch
    Score8.5 out of 10
    Medium-sized Companies
    Azure Database
    Score8.8 out of 10
    Elasticsearch
    Score8.5 out of 10
    Enterprises
    Google Cloud SQL
    Score8.7 out of 10
    Amazon CloudSearch
    Score8.5 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Amazon AthenaAzure AI Search
    Likelihood to Recommend
    10.0
    (4 ratings)
    9.3
    (6 ratings)
    Usability
    10.0
    (1 ratings)
    9.3
    (3 ratings)
    User Testimonials
    Amazon AthenaAzure AI Search
    Likelihood to Recommend
    Amazon AWS
    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
    Read full review
    Microsoft
    It's very useful when used with large file systems, once the models index the files good enough, the suggestions are very impressive and produce grounded answers. Since it can natively work with blob storage the requirement for pre-processing the data is eliminated i.e. the data can be searched in its raw form, this makes Azure AI Search a very powerful tool when used with Azure Stack.
    Incentivized
    Read full review
    Pros
    Amazon AWS
    • Nested Schemas like JSON data structure
    • Ability to adapt the data model to fit your queries better
    • Performance Improvement
    Incentivized
    Read full review
    Microsoft
    • Incredibly robust back-end infrastructure.
    • Streamlined integration into Microsoft's Azure Cloud.
    • From a user standpoint, it lets the customer easily access their data and provide useful search tips.
    Incentivized
    Read full review
    Cons
    Amazon AWS
    • Response caching can be improved.
    • Data Partitioning is tricky and understanding of the same could be improved.
    Incentivized
    Read full review
    Microsoft
    • Like virtually all Azure services, it has first-class treatment for .Net as the developer platform of choice, but largely ignores other options. While there is a first-party Python SDK, there are only community packages for other languages like Ruby and Node. Might be a game of roulette for those to be kept up-to-date. This might make it a non-starter for some teams that don't want to do the work to integrate with the REST API directly.
    • In my opinion, partitions inside of Azure Search don't count as data segregation for customers in a multi-tenant app, so any application where you have many customers with high-security concerns, Azure Search is probably a non-starter.
    • To elaborate on the multi-tenant issue: Azure Search's approach to pricing is pretty steep. While there is a free tier for small applications (50MB of content or less) the first paid tier is about 14x more expensive than the first SQL Database tier that supports full-text search. For many applications, it makes a lot more economic sense to just run some LIKE or CONTAINS queries on columns in a table rather than going with Azure Search.
    Incentivized
    Read full review
    Usability
    Amazon AWS
    Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
    Incentivized
    Read full review
    Microsoft
    I give 10 rating because by using this endpoint and api key only we able to build that chatbot product in a timeline given by our client and also creating the endpoint and keys from the portal is also very easy for Azure AI Search and it doesn't take much time and also scalability is good.
    Read full review
    Alternatives Considered
    Amazon AWS
    Incentivized
    Read full review
    Microsoft
    It is good for me, and I want to rate this product 9/10. I hope they continue to improve and also offer a free plan with more benefits to learn Azure AI Search.
    Incentivized
    Read full review
    Return on Investment
    Amazon AWS
    • 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
    Read full review
    Microsoft
    • When integrated with our existing file system the Azure AI Search helped users tremendously by reducing search times and improve efficacy of intended result.
    • Since Azure AI Search is a PaaS solution, we had very short ideation to go-live timespan, which ended up reflecting in our product performance.
    • A rare but not negligible occurrence was correctness of search being questionable when new data was added to the system. The search returns false positive results.
    Incentivized
    Read full review
    ScreenShots