DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

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
DescriptionA cloud-native analytic database platform with new technologoy for elastic MPP
Primary database modelRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#291  Overall
#133  Relational DBMS
Current release2.1, January 2023
License infoCommercial or Open Sourcecommercial
Cloud-based only infoOnly available as a cloud serviceyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Server operating systemshosted
Data schemeyes
Typing infopredefined data types such as float or dateyes
Secondary indexesyes
SQL infoSupport of SQLyes
APIs and other access methodsCLI Client
Supported programming languagesJava
Server-side scripts infoStored proceduresuser defined functions
Partitioning methods infoMethods for storing different data on different nodesyes
Replication methods infoMethods for redundantly storing data on multiple nodesyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID
Concurrency infoSupport for concurrent manipulation of datayes
Durability infoSupport for making data persistentyes
User concepts infoAccess controlUser 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

2 August 2023, CSDN

provided by Google News

Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Present your product here