Apache AsterixDB
Apache AsterixDB is a free, open-source Big Data Management System for ingesting, storing, indexing, querying and analyzing data.
What Apache AsterixDB is
Apache AsterixDB is a free, open-source Big Data Management System for ingesting, storing, indexing, querying and analyzing data. Its Asterix Data Model extends JSON with object-database ideas, while SQL++ and AQL provide declarative query languages for semistructured data. Storage uses partitioned LSM-based native systems, with B+ tree, R-tree and inverted keyword secondary indexes. External datasets can be queried without loading all their data into AsterixDB; built-in adapters cover HDFS and local filesystems. Data feeds support continuous ingestion from sources including Twitter, RSS and sockets. The HTTP query API accepts SQL++ statements and can deliver results immediately, later or asynchronously. Deployment is self-hosted, with installation options using NCService, Ansible and Amazon Web Services. The project describes basic transactional concurrency and recovery capabilities and identifies web data warehousing and social data storage and analysis as suitable uses. Its Hyracks parallel runtime query engine has been scale-tested on up to 1000+ cores and 500+ disks. The open-source plan is free.
Good
- Free and open source
- Queries external data without loading it all
- Supports continuous data feeds
- Offers SQL++ HTTP query access
- Includes several secondary index types
Watch out
- Requires self-hosted deployment
- AWS instructions list Linux for instances
Who it suits
AsterixDB is suited to teams building web data warehouses or analyzing social data. It may fit projects that need semistructured data queries, external data access and self-hosted deployment.
Verdict
Apache AsterixDB brings storage, querying and ingestion tools together for semistructured data systems. Its self-hosted deployment and documented data model make it most relevant to teams prepared to manage their own setup.
Plans and prices
From Apache AsterixDB's own pricing page, checked 9 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Apache AsterixDB | Free | Open source Big Data Management System · self-managed cluster |
The facts
Each one read from Apache AsterixDB's own pages, with the date it was checked.
What it does
- Audience
- The documentation says AsterixDB is well suited to web data warehousing and social data storage and analysis.checked 9 Oct 2026
- AWS requirements
- The AWS installation instructions list Linux and macOS as supported client operating systems and Linux for AWS instances.checked 9 Oct 2026
- Data model
- Its semistructured Asterix Data Model extends JSON with object database ideas.checked 9 Oct 2026
- Deployment
- The documentation provides installation options using NCService, Ansible, and Amazon Web Services.checked 9 Oct 2026
- External data
- External datasets can be queried without loading all data into AsterixDB, with built-in adapters for HDFS and local filesystems.checked 9 Oct 2026
- HTTP API
- The HTTP query API accepts SQL++ statements and supports immediate, deferred, and asynchronous result delivery.checked 9 Oct 2026
- Purpose
- Apache AsterixDB is a scalable, open source Big Data Management System for ingesting, storing, indexing, querying, and analyzing data.checked 9 Oct 2026
- Query languages
- The documentation describes SQL++ and AQL as declarative query languages for semistructured data.checked 9 Oct 2026
- Scale
- The project documentation says its Hyracks parallel runtime query engine has been scale-tested on up to 1000+ cores and 500+ disks.checked 9 Oct 2026
- Storage and indexes
- AsterixDB uses partitioned LSM-based native storage and supports B+ tree, R-tree, and inverted keyword secondary indexes.checked 9 Oct 2026
- Streaming ingestion
- Data feeds can continuously ingest external data, and built-in adapters include Twitter, RSS, and socket sources.checked 9 Oct 2026
- Support
- The project directs users to its users mailing list for AsterixDB questions and also lists an IRC channel where developers may be contacted.checked 9 Oct 2026
- Transactions
- The documentation describes basic transactional concurrency and recovery capabilities akin to those of a NoSQL store.checked 9 Oct 2026
The company
- Founded
- 2009checked 28 Sep 2026
Alternatives to Apache AsterixDB
- 1
JayDB
Free planOpen sourceAndroidiOSWebAPI8.4Free plan - 2
Firestore
Free planAndroidiOSWebAPI8.1$0.03 usage-based - 3
RethinkDB
Free planOpen sourceWebAPILinuxmacOS7.4Free plan - 4
restdb.io
Free planAndroidiOSWebAPI7.2From $19 a month - 5
Amazon DocumentDB
WebAPI7.1 - 6
UnQLite
Free planAPILinuxmacOSSelf-hosted7.0From $15,000 a year