Audience
Anyone searching for a solution to manage their OLTP and operational analytics for Apache Hadoop
About Apache Phoenix
Apache Phoenix enables OLTP and operational analytics in Hadoop for low-latency applications by combining the best of both worlds. The power of standard SQL and JDBC APIs with full ACID transaction capabilities and the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. Apache Phoenix is fully integrated with other Hadoop products such as Spark, Hive, Pig, Flume, and Map Reduce. Become the trusted data platform for OLTP and operational analytics for Hadoop through well-defined, industry-standard APIs. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds for small queries, or seconds for tens of millions of rows.
Other Popular Alternatives & Related Software
Apache Trafodion
Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop. Full-functioned ANSI SQL language support. JDBC/ODBC connectivity for Linux/Windows clients. Distributed ACID transaction protection across multiple statements, tables, and rows. Performance improvements for OLTP workloads with compile-time and run-time optimizations. Support for large data sets using a parallel-aware query optimizer. Reuse existing SQL skills and improve developer productivity. Distributed ACID transactions guarantee data consistency across multiple rows and tables. Interoperability with existing tools and applications. Hadoop and Linux distribution neutral. Easy to add to your existing Hadoop infrastructure.
Learn more
HugeGraph
HugeGraph is a fast-speed and highly-scalable graph database. Billions of vertices and edges can be easily stored into and queried from HugeGraph due to its excellent OLTP ability. As compliance to Apache TinkerPop 3 framework, various complicated graph queries can be accomplished through Gremlin (a powerful graph traversal language). Among its features, it provides compliance to Apache TinkerPop 3, supporting Gremlin. Schema Metadata Management, including VertexLabel, EdgeLabel, PropertyKey and IndexLabel. Multi-type Indexes, supporting exact query, range query and complex conditions combination query. Plug-in Backend Store Driver Framework, supporting RocksDB, Cassandra, ScyllaDB, HBase and MySQL now and easy to add other backend store driver if needed. Integration with Hadoop/Spark. HugeGraph relies on the TinkerPop framework, we refer to the storage structure of Titan and the schema definition of DataStax.
Learn more
InterBase
Ultrafast, scalable, embeddable SQL database with commercial-grade data security, disaster recovery, and change synchronization. Cross-platform, zero-install, embedded database as a direct-access library. Cross-platform, zero-install, embedded database with database-level and column-level AES and DES encryption. Concurrent applications/client access to the database on Windows with database-level and column-level AES and DES encryption. Ultrafast, scalable, SQL server database for Windows and Linux with commercial-grade data security, disaster recovery and change synchronization. Attacks on databases and loss of data can be costly and lead to loss of customers’ trust (and business), regulatory action, and heavy fines. InterBase provides over-the-wire and at-rest encryption, separate security login, and role-based user security. InterBase maintains full on-disk encryption while adding negligible overhead to database speed and performance.
Learn more
CUBRID
CUBRID is a relational DBMS optimized for online transaction processing (OLTP) that complies with ANSI SQL standards and provides MVCC support, High-Availability (HA) capabilities, and GUI-based tools for DB management/migration. It also provides Oracle/MySQL compatibility and supports a variety of interfaces, including JDBC.
CUBRID provides ease of installation and native GUI-based administration tools for developers' convenience. Multi-threaded, multi-server architecture, native broker middleware, cost-based optimizer, and intensive caching techniques for your OLTP services. Very accurate predictable automatic fail-over built-in technology, based on the CUBRID Heartbeat native engine core. Multi-volume support, automatic volume expansion, and unlimited number and size of databases/ tables/indexes.
Learn more
Pricing
Starting Price:
Free
Free Version:
Free Version available.
Company Information
Apache Software Foundation
phoenix.apache.org
Videos and Screen Captures
Other Useful Business Software
Go From AI Idea to AI App Fast
Access Gemini 3 and 200+ models. Build chatbots, agents, or custom models with built-in monitoring and scaling.
Product Details
Platforms Supported
Windows
Mac
Linux
Training
Documentation
Support
Online
