Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Apache AsterixDB

By Apache AsterixDB · asterixdb.apache.org

  • Free plan
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted

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

Apache AsterixDB

Free

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.