Side by side
Apache Drill 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.
Apache Drill offers in-place SQL queries across varied data sources, with options for BI tools and custom applications. Check its compatibility requirements first, particularly if you rely on Hadoop 2 or Java 8.
Visit Apache DrillChoose 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
| Apache Drill | Ontop | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | API, Linux, Mac, Self-hosted, Windows | API, Linux, Mac, Self-hosted, Web, Windows |
| Lowest paid plan | Free or on request | Not published |
| Plans published | 1 | None |
| Maker | Not published | Not published |
| Website | drill.apache.org | ontop-vkg.org |
| On query engine software | #3 of 28 | #13 of 28 |
Apache Drill: what it does well
- Queries raw data in place without schema setup
- Supports nested JSON and cross-source joins
- JDBC and ODBC drivers connect listed BI tools
- Runs embedded or across a server cluster
- Free under Apache License 2.0
What to know first
- Official Hadoop 2 and Java 8 support was dropped with Drill 1.22.0
- No free trial is listed
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 Apache Drill Alternatives to Ontop The whole list