DBMS > PieCloudDB

PieCloudDB System Properties

Please select another system to compare it with PieCloudDB.

Our visitors often compare PieCloudDB with Snowflake, ClickHouse and Pinecone.

Editorial information provided by DB-Engines

Name

Description

A cloud-native analytic database platform with new technologoy for elastic MPP

Primary database model

Relational DBMS

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	0.31
Rank	#291	Overall
	#133	Relational DBMS

Website

www.openpie.com

Developer

OpenPie

Current release

2.1, January 2023

License

Commercial or Open Source

commercial

Cloud-based only

Only available as a cloud service

yes

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Server operating systems

hosted

Data scheme

yes

Typing

predefined data types such as float or date

yes

Secondary indexes

yes

SQL

Support of SQL

yes

APIs and other access methods

CLI Client
JDBC
ODBC

Supported programming languages

Java
PL/SQL
Python
R

Server-side scripts

Stored procedures

user defined functions

Triggers

Partitioning methods

Methods for storing different data on different nodes

yes

Replication methods

Methods for redundantly storing data on multiple nodes

yes

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Foreign keys

Referential integrity

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Concurrency

Support for concurrent manipulation of data

yes

Durability

Support for making data persistent

yes

User concepts

Access control

User Roles and pluggable authentication with full SQL Standard

More information provided by the system vendor

Specific characteristics

PieCloudDB, OpenPie's flagship product, is a cutting-edge cloud-native data warehouse. It delivers elastic, highly available, and fully adaptable distributed HTAP database capabilities.

PieCloudDB serves as a pioneering example for the next generation of data computing infrastructure. With deployment options including community, serverless, and self-hosted, it supports private, public, and hybrid cloud environments.

Leveraging its next-gen eMPP cloud-native architecture with separated storage and computation, PieCloudDB offers extreme elasticity on storage and computation nodes independently. Its pay-as-you-go payment model enables flexible scaling.

By utilizing TDE technology and end-to-end encryption, PieCloudDB ensures unbreakable security levels, safeguarding user data. Supporting full SQL compliance and distributed ACID transactions, PieCloudDB enables high elasticity and real-time analytics through its advanced storage architecture called JANM, efficient cache design, and robust metadata management capabilities.

Empowering businesses towards sustainability, PieCloudDB facilitates digital transformation for enterprises.

Competitive advantages

Extreme Elastic: PieCloudDB utilizes a cutting-edge eMPP cloud-native architecture for elastic scalability and intelligent distributed computing.

Unbreakable Security: PieCloudDB offers real-time encryption of data storage, incorporates security technologies such as TDE and offers comprehensive security and authorization management on database and table levels.

Transaction Capacibilities: PieCloudDB supports ACID properties and support for transaction isolation levels such as Read Committed and Repeatable Read.

Cost Efficiency: The storage and compute separation architecture supports independent scaling for users, enabling pay-as-you-go flexibility, and achieves a high compression ratio through data encoding and compression.

High Performance:

multi-level caching
Support for SIMD instruction sets
cloud-native distributed optimizer

Muilti-Cloud: Support for bare metal servers, virtualization, and container environments, seamlessly integrating with public clouds, private clouds, and hybrid cloud environments.

Real-Time HTAP: With one single data warehouse, PieCloudDB can handle HTAP mixed loads with one set of high-performance parallel execution engines.

Cloud Native Management Platform:

Visual management interface
Web SQL Client
Cluster and Database Management
Role and User management

Multi-Tenancy: PieCloudDB supports managing platform users and mapping them to database users, allowing data access with a single set of user credentials.

High SQL Compatibility :

Highly compatible with SQL standards
Supports Various Functionalities (window functions, aggregations, cubes, etc.;)

In-Database Machine Learning:

Supervised Learning
Unsupervised Learning
Graph Processing
Time Series Analysis etc.

Typical application scenarios

PieCloudDB is ideal for Data mining applications that require extreme scalability and high performance.

Common Use Cases Include:

Statistical Report（Business Intelligence Report, Financial Statistical Report, Operational Analysis Report, Order Statistics Report，etc）
AD Hoc Inquiry（Order Details data query, vehicle search data query, passenger trip data query, settlement list data query, etc）
Real-time Analysis（real-time risk control, service real-time Kanban, etc）
Advertising Marketing（user portrait, precise recommendation, etc）
Machine Learning（Deep Learning, Data Probe, Data Science and Engineering, etc）
Combined with Large Language Models（Vector Database, Text-to-SQL, Knowledge Retrieval, Automatic Report Generation, Intelligent Question Answering, etc）

Key customers

Sail-Cloud
China Shipbuilding Group Haizhou System
Soochow Securities
etc.,

Licensing and pricing models

PieCloudDB Community Edition: Community License, Free Download, Self-Hosted Deployment；

PieCloudDB Enterprise Edition: Commercial License, Self-Hosted Deployment；

PieCloudDB Serverless Edition: Pay-as-you-go Cloud Service, Public Cloud Deployment

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources

Recent citations in the news

云上Index：看「简墨」如何为云原生打造全新索引
2 August 2023, blog.csdn.net

provided by Google News

Share this page