Apache Phoenix

Apache Phoenix

Apache Software Foundation

About

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.

About

Oracle Big Data SQL Cloud Service enables organizations to immediately analyze data across Apache Hadoop, NoSQL and Oracle Database leveraging their existing SQL skills, security policies and applications with extreme performance. From simplifying data science efforts to unlocking data lakes, Big Data SQL makes the benefits of Big Data available to the largest group of end users possible. Big Data SQL gives users a single location to catalog and secure data in Hadoop and NoSQL systems, Oracle Database. Seamless metadata integration and queries which join data from Oracle Database with data from Hadoop and NoSQL databases. Utilities and conversion routines support automatic mappings from metadata stored in HCatalog (or the Hive Metastore) to Oracle Tables. Enhanced access parameters give administrators the flexibility to control column mapping and data access behavior. Multiple cluster support enables one Oracle Database to query multiple Hadoop clusters and/or NoSQL systems.

About

Oracle database products offer customers cost-optimized and high-performance versions of Oracle Database, the world's leading converged, multi-model database management system, as well as in-memory, NoSQL, and MySQL databases. Oracle Autonomous Database, available on-premises via Oracle Cloud@Customer or in the Oracle Cloud Infrastructure, enables customers to simplify relational database environments and reduce management workloads. Oracle Autonomous Database eliminates the complexity of operating and securing Oracle Database while giving customers the highest levels of performance, scalability, and availability. Oracle Database can be deployed on-premises when customers have data residency and network latency concerns. Customers with applications that are dependent on specific Oracle database versions have complete control over the versions they run and when those versions change.

About

Enjoy the highest performance and unlimited possibilities when working with PostgreSQL. PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster, and cleaner PostgreSQL database applications without deploying any additional libraries. PgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client. PgDAC allows developers to optimize their database applications and harness the full capabilities of PostgreSQL.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Anyone searching for a solution to manage their OLTP and operational analytics for Apache Hadoop

Audience

Organizations and enterprises looking for a solution to analyze data and unlock data lakes

Audience

Application Developers looking for a Database Management solution

Audience

Programmers seeking a solution to develop lightweight, faster, and cleaner PostgreSQL database applications

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Free Version
Free Trial

Pricing

No information available.
Free Version
Free Trial

Pricing

No information available.
Free Version
Free Trial

Pricing

$199.95 per year
Free Version
Free Trial

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

Apache Software Foundation
phoenix.apache.org

Company Information

Oracle
Founded: 1977
United States
www.oracle.com/big-data/big-data-sql/

Company Information

Oracle
Founded: 1977
United States
www.oracle.com/database/

Company Information

Devart
Founded: 1997
Czech Republic
www.devart.com/pgdac/

Alternatives

Alternatives

Alternatives

Alternatives

Apache Trafodion

Apache Trafodion

Apache Software Foundation
Apache Sentry

Apache Sentry

Apache Software Foundation
Amazon RDS

Amazon RDS

Amazon
EMS DB Extract

EMS DB Extract

EMS Software
Apache Spark

Apache Spark

Apache Software Foundation
Redis

Redis

Redis Labs
PostgreSQL

PostgreSQL

PostgreSQL Global Development Group

Categories

Categories

Categories

Categories

Database Features

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

NoSQL Database Features

Auto-sharding
Automatic Database Replication
Data Model Flexibility
Deployment Flexibility
Dynamic Schemas
Integrated Caching
Multi-Model
Performance Management
Security Management

Relational Database Features

ACID Compliance
Data Failure Recovery
Multi-Platform
Referential Integrity
SQL DDL Support
SQL DML Support
System Catalog
Unicode Support

Integrations

ALFRED Claims Automation
Apache HBase
Azure Disk Storage
Azure Marketplace
B2Metric
CorralData
Docker
Insight PISO Manager
MODLR
Microsoft Intelligent Data Platform
NXLog
New Relic
OpenText Server Backup
Oracle Database Backup Cloud Service
PolarDB
Predator Virtual CNC
SQL
TROCCO
Trino
WebSmart

Integrations

ALFRED Claims Automation
Apache HBase
Azure Disk Storage
Azure Marketplace
B2Metric
CorralData
Docker
Insight PISO Manager
MODLR
Microsoft Intelligent Data Platform
NXLog
New Relic
OpenText Server Backup
Oracle Database Backup Cloud Service
PolarDB
Predator Virtual CNC
SQL
TROCCO
Trino
WebSmart

Integrations

ALFRED Claims Automation
Apache HBase
Azure Disk Storage
Azure Marketplace
B2Metric
CorralData
Docker
Insight PISO Manager
MODLR
Microsoft Intelligent Data Platform
NXLog
New Relic
OpenText Server Backup
Oracle Database Backup Cloud Service
PolarDB
Predator Virtual CNC
SQL
TROCCO
Trino
WebSmart

Integrations

ALFRED Claims Automation
Apache HBase
Azure Disk Storage
Azure Marketplace
B2Metric
CorralData
Docker
Insight PISO Manager
MODLR
Microsoft Intelligent Data Platform
NXLog
New Relic
OpenText Server Backup
Oracle Database Backup Cloud Service
PolarDB
Predator Virtual CNC
SQL
TROCCO
Trino
WebSmart
Claim Apache Phoenix and update features and information
Claim Apache Phoenix and update features and information
Claim Oracle Big Data SQL Cloud Service and update features and information
Claim Oracle Big Data SQL Cloud Service and update features and information
Claim Oracle Database and update features and information
Claim Oracle Database and update features and information
Claim PostgreSQL Data Access Components and update features and information
Claim PostgreSQL Data Access Components and update features and information