Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Actian Ingres is a highly dependable SQL-standard transactional database known for its exceptional reliability and performance. Now, it has evolved into a hybrid database that seamlessly integrates transactional and analytical processing, boasting the remarkable X100 analytics engine. By supporting both row-based and columnar storage formats, Ingres enables organizations to conduct transaction processing and operational analytics within a single platform efficiently. This solution is recognized as the most reliable transactional database in the industry, offering a low total cost of ownership alongside round-the-clock global support and outstanding customer satisfaction. With a solid history of success, it underpins thousands of enterprises that manage billions of transactions across years of updates and migrations, ensuring that businesses can rely on it for their critical operations. Its continuous innovation and commitment to excellence solidify its position as a leader in the database market.
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.
API Access
Has API
No
API Access
Has API
Yes
Integrations
Python
Yes
SQL
Yes
3forge
No
Amazon EKS
Yes
Amazon Web Services (AWS)
Yes
Apache Flume
No
Apache HBase
No
Azure Kubernetes Service (AKS)
Yes
Data Sentinel
No
Google Cloud Platform
Yes
Integrations
Python
Yes
SQL
Yes
3forge
Yes
Amazon EKS
No
Amazon Web Services (AWS)
No
Apache Flume
Yes
Apache HBase
Yes
Azure Kubernetes Service (AKS)
No
Data Sentinel
Yes
Google Cloud Platform
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
Free
Free Trial
No
Free Version
Yes
Deployment
Web-Based
Yes
On-Premises
Yes
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
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
Customer Support
Business Hours
Yes
Live Rep (24/7)
Yes
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
Actian
Founded
1980
Country
United States
Website
www.actian.com/databases/ingres/
Vendor Details
Company Name
Apache Software Foundation
Website
phoenix.apache.org
Product Features
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