Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Apache Phoenix provides low-latency OLTP and operational analytics on Hadoop by merging the advantages of traditional SQL with the flexibility of NoSQL. It utilizes HBase as its underlying storage, offering full ACID transaction support alongside late-bound, schema-on-read capabilities. Fully compatible with other Hadoop ecosystem tools such as Spark, Hive, Pig, Flume, and MapReduce, it establishes itself as a reliable data platform for OLTP and operational analytics through well-defined, industry-standard APIs. When a SQL query is executed, Apache Phoenix converts it into a series of HBase scans, managing these scans to deliver standard JDBC result sets seamlessly. The framework's direct interaction with the HBase API, along with the implementation of coprocessors and custom filters, enables performance metrics that can reach milliseconds for simple queries and seconds for larger datasets containing tens of millions of rows. This efficiency positions Apache Phoenix as a formidable choice for businesses looking to enhance their data processing capabilities in a Big Data environment.
Description
Provides the full range of features found in on-premises Informix deployments, but with reduced cost, complexity, and risk associated with infrastructure management. The IBM® Informix® on Cloud solution delivers an Informix database hosted on IBM Cloud®, allowing customers to enjoy the extensive capabilities of an on-premises setup while minimizing the challenges of infrastructure upkeep. With Informix on Cloud, users benefit from a high-performance engine that seamlessly combines time series, spatial, NoSQL, and SQL data, along with convenient access via MQTT, REST, and MongoDB APIs. This offering not only simplifies and accelerates cloud deployments but also harnesses the superior performance of the Informix engine, which is designed to integrate diverse data types effortlessly. By leveraging flexible hosting options and adaptable software licensing, businesses can lower their infrastructure maintenance costs and streamline operational complexity, all while selecting the size that best fits their specific requirements, backed by continuous support. This makes Informix on Cloud an ideal choice for organizations looking to modernize their data management strategies without the traditional burdens of self-hosting.
API Access
Has API
Yes
API Access
Has API
Yes
Integrations
3forge
Yes
Amazon EMR
Yes
Apache Flume
Yes
Apache HBase
Yes
Apache Hive
Yes
Apache Spark
Yes
COZYROC SSIS+ Suite
No
Data Sentinel
Yes
Hadoop
Yes
IBM Informix
No
Integrations
3forge
No
Amazon EMR
No
Apache Flume
No
Apache HBase
No
Apache Hive
No
Apache Spark
No
COZYROC SSIS+ Suite
Yes
Data Sentinel
No
Hadoop
No
IBM Informix
Yes
Pricing Details
Free
Free Trial
No
Free Version
Yes
Pricing Details
$1,250 per instance
Free Trial
No
Free Version
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
Yes
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
Yes
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
Yes
Vendor Details
Company Name
Apache Software Foundation
Website
phoenix.apache.org
Vendor Details
Company Name
IBM
Founded
1911
Country
United States
Website
www.ibm.com/cloud/informix
Product Features
Relational Database
ACID Compliance
No
Data Failure Recovery
No
Multi-Platform
No
Referential Integrity
No
SQL DDL Support
No
SQL DML Support
No
System Catalog
No
Unicode Support
No
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No
Relational Database
ACID Compliance
No
Data Failure Recovery
No
Multi-Platform
No
Referential Integrity
No
SQL DDL Support
No
SQL DML Support
No
System Catalog
No
Unicode Support
No