Side by side
Amazon Athena vs Ontop
Both stand on query engine software. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Athena offers several ways to submit SQL queries and supports a broad set of data formats and connectors. Account for scanned-data pricing and separate storage, catalog, and related service charges when estimating use.
Visit Amazon AthenaChoose Ontop if you need an open source way to expose relational databases as virtual knowledge graphs and query them with SPARQL. Its database driver setup and generic JDBC caveats may be a concern for configurations without a documented dialect-specific connector; users needing lenses in Protégé will also need another editing approach.
Visit OntopThe facts
| Amazon Athena | Ontop | |
|---|---|---|
| Free plan | No | Yes |
| Open source | Not published | Not published |
| Runs on | API, Web | API, Linux, Mac, Self-hosted, Web, Windows |
| Lowest paid plan | See the plans | Not published |
| Plans published | 3 | None |
| Maker | Not published | Not published |
| Website | aws.amazon.com | ontop-vkg.org |
| On query engine software | #17 of 28 | #13 of 28 |
Amazon Athena: what it does well
- Runs interactive SQL queries on S3 data
- Supports CSV, JSON, ORC, Avro, and Parquet
- Queries can invoke SageMaker models
- Workgroups can set limits and track costs
What to know first
- No free plan
- S3 and other service charges may apply separately
- SQL query pricing is based on data scanned
Ontop: what it does well
- Keeps graph data in the source databases.
- Translates SPARQL queries into SQL for relational sources.
- Supports RDFS, OWL 2 QL, R2RML, and Ontop mappings.
- Works with a broad list of documented databases and federators.
- Apache 2.0 licensed and open source.
What to know first
- The Protégé plugin does not support lenses.
- Database JDBC drivers must be downloaded and placed in Ontop’s jdbc directory.
- Generic JDBC may not handle every database setup or SPARQL query correctly.
Alternatives to Amazon Athena Alternatives to Ontop The whole list