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.
Popular Alternatives
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
Google Cloud SQL
Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with fully managed MySQL, PostgreSQL and SQL Server databases. Ensure business continuity with reliable and secure services backed by 24/7 SRE team. Data encryption at rest and in transit. Private connectivity with Virtual Private Cloud and user-controlled network access with firewall protection. Compliant with SSAE 16, ISO 27001, PCI DSS, and HIPAA. Scale your instances effortlessly with a single API call whether you start with simple testing or you need a highly available database in production. Standard connection drivers and built-in migration tools allow you to create and connect to your first database in just a few minutes.
Learn more
SAP HANA
SAP HANA in-memory database is for transactional and analytical workloads with any data type — on a single data copy. It breaks down the transactional and analytical silos in organizations, for quick decision-making, on premise and in the cloud. Innovate without boundaries on a database management system, where you can develop intelligent and live solutions for quick decision-making on a single data copy. And with advanced analytics, you can support next-generation transactional processing. Build data solutions with cloud-native scalability, speed, and performance. With the SAP HANA Cloud database, you can gain trusted, business-ready information from a single solution, while enabling security, privacy, and anonymization with proven enterprise reliability. An intelligent enterprise runs on insight from data – and more than ever, this insight must be delivered in real time.
Learn more
Pricing
Starting Price:
Free
Free Version:
Free Version available.
Company Information
Apache Software Foundation
phoenix.apache.org
Videos and Screen Captures
You Might Also Like
Never Get Blocked Again | Enterprise Web Scraping
Get unrestricted access to public web data with our ethically-sourced proxy network. Automated session management and advanced unblocking handle the hard parts. Scale from 1 to 1M requests with zero blocks. Built for developers with ready-to-use APIs, serverless functions, and complete documentation. Used by 20,000+ companies including Fortune 500s. SOC2 and GDPR compliant.
Product Details
Platforms Supported
Windows
Mac
Linux
Training
Documentation
Support
Online