What Apache AsterixDB is
Apache AsterixDB is a free, open-source, self-hosted Big Data Management System for ingesting, storing, indexing, querying, and analyzing data. Its Asterix Data Model extends JSON with object-database concepts, while SQL++ and AQL provide declarative query languages for semistructured information. Partitioned LSM-based storage supports B+ tree, R-tree, and inverted-keyword secondary indexes. You can query external datasets without loading everything into AsterixDB, using adapters for HDFS and local filesystems. Data feeds continuously ingest sources such as Twitter, RSS, and sockets. The HTTP query API accepts SQL++ and can deliver results immediately, later, or asynchronously. Installation options include NCService, Ansible, and Amazon Web Services. The Hyracks parallel runtime has been scale-tested on more than 1000 cores and 500 disks. Basic transactional concurrency and recovery are documented. It suits web data warehousing and social-data storage and analysis.
Who it suits
AsterixDB suits teams managing semistructured, web, social, or other large datasets in a self-hosted environment. It is available through APIs, Linux, macOS, and the web.
Good to know, and what to watch
- Free, open-source self-hosted deployment
- Queries external data without full loading
- Continuous feeds support Twitter, RSS, sockets
- Multiple secondary index types
- Asynchronous HTTP query results
- Self-hosted deployment requires setup
- AWS instances require Linux
- Large-scale operation needs substantial infrastructure
Plans
Every plan and priceApache AsterixDB
Open source
The verdict
Apache AsterixDB combines semistructured data modeling, external-data access, streaming feeds, and parallel querying in a self-managed system. Its free open-source model fits organizations that can operate the deployment themselves.
What the maker publishes
- Audience
- The documentation says AsterixDB is well suited to web data warehousing and social data storage and analysis. source
- AWS requirements
- The AWS installation instructions list Linux and macOS as supported client operating systems and Linux for AWS instances. source
- Data model
- Its semistructured Asterix Data Model extends JSON with object database ideas. source
- Deployment
- The documentation provides installation options using NCService, Ansible, and Amazon Web Services. source
- External data
- External datasets can be queried without loading all data into AsterixDB, with built-in adapters for HDFS and local filesystems. source
- Founded
- 2009 source
- HTTP API
- The HTTP query API accepts SQL++ statements and supports immediate, deferred, and asynchronous result delivery. source
- Purpose
- Apache AsterixDB is a scalable, open source Big Data Management System for ingesting, storing, indexing, querying, and analyzing data. source
- Query languages
- The documentation describes SQL++ and AQL as declarative query languages for semistructured data. source
- Scale
- The project documentation says its Hyracks parallel runtime query engine has been scale-tested on up to 1000+ cores and 500+ disks. source
- Storage and indexes
- AsterixDB uses partitioned LSM-based native storage and supports B+ tree, R-tree, and inverted keyword secondary indexes. source
- Streaming ingestion
- Data feeds can continuously ingest external data, and built-in adapters include Twitter, RSS, and socket sources. source
- Support
- The project directs users to its users mailing list for AsterixDB questions and also lists an IRC channel where developers may be contacted. source
- Transactions
- The documentation describes basic transactional concurrency and recovery capabilities akin to those of a NoSQL store. source
Checked against the maker's pages on 9 Oct 2026.