AsterixDB

AsterixDB is a BDMS (Big Data Management System) with a rich feature set that sets it apart from other Big Data platforms. Its feature set makes it well-suited to modern needs such as web data warehousing and social data storage and analysis. AsterixDB has:

• Data model
  A semistructured NoSQL style data model (ADM) resulting from extending JSON with object database ideas

• Query languages
  Two expressive and declarative query languages (SQL++ and AQL) that support a broad range of queries and analysis over semistructured data

• Scalability
  A parallel runtime query execution engine, Apache Hyracks, that has been scale-tested on up to 1000+ cores and 500+ disks

• Native storage
  Partitioned LSM-based data storage and indexing to support efficient ingestion and management of semistructured data

• External storage
  Support for query access to externally stored data (e.g., data in HDFS) as well as to data stored natively by AsterixDB

• Data types
  A rich set of primitive data types, including spatial and temporal data in addition to integer, floating point, and textual data

• Indexing
  Secondary indexing options that include B+ trees, R trees, and inverted keyword (exact and fuzzy) index types

• Transactions
  Basic transactional (concurrency and recovery) capabilities akin to those of a NoSQL store