Overview
Cloud Data Warehouse for PostgreSQL (CDWPG) provides a straightforward, rapid, and cost-efficient solution for petabyte-scale data warehousing in the cloud. It seamlessly integrates with the open-source Greenplum data warehouse and operates on the massively parallel processing (MPP) architecture.
Benefits
Elastic Scaling
CDWPG offers flexible and scalable solutions, enabling you to effortlessly add hundreds of nodes and adjust their configurations via the console or API. You have the flexibility to scale compute units, CPU, memory, and storage proportionally to align with your business requirements and growth.
Ease of Use
Manage, monitor, and maintain clusters conveniently through the console, eliminating the need for complex infrastructure operation and maintenance tasks. CDWPG adheres fully to the ANSI 2008 standard for SQL, enabling the creation of enterprise-grade data warehouses using standard SQL.
Seamless Integration
CDWPG facilitates limitless expansion of storage capacity with COS. It collaborates with a diverse range of tools and solutions, enabling rapid data import from numerous sources for aggregation and analysis in the cloud. Compatible sources include traditional relational databases, CKafka, and Oceanus.
Best-in-Class Performance
CDWPG utilizes a distributed MPP framework to scale the storage and computing capabilities. Its hybrid row/column-oriented storage and highly optimized query engine provide an optimal storage solution for businesses, enabling data querying several times faster than traditional data warehouses.
High Security and Reliability
A CDWPG cluster comprises two nodes for redundancy, enabling failover and disaster recovery mechanisms that are seamless to users. Distributed deployment safeguards compute units, servers, and cabinets, ensuring the security of critical data infrastructure. Additionally, your clusters are deployed independently within isolated VPCs to enhance data access security.
Scenarios
Operational Analysis and Decision Making
Massive Log Analysis
Real-Time Insights into User Behaviors
In finance and retail sectors, it’s crucial to aggregate and analyze business data concerning sales, assets, and the supply chain to maintain operational excellence and facilitate precise decision-making.
With CDWPG, you can seamlessly import data from CloudDB, Oracle, and PostgreSQL using sync or ETL tools. This capability empowers you to analyze diverse data from various sources, facilitating informed and strategic business decisions.
In industries such as internet finance, gaming, and O2O, CDWPG offers a cost-effective and efficient analysis of user behaviors, system logs, orders, and other structured or semi-structured data at the petabyte level.
With COS, you can store vast amounts of data without the need to import it into CDWPG. This allows for quick analysis and application of data simply by writing SQL statements.
In the internet and gaming sectors, CDWPG is capable of real-time analysis of user behaviors, optimizing operational strategies, and improving resource management efficiency.
Oceanus is designed to filter, aggregate, and analyze real-time user operation data, seamlessly syncing the results with CDWPG. Leveraging CDWPG’s robust SQL analysis and efficient querying capabilities allows you to remain informed about user behavior trends and promptly adapt operational strategies.
Compute
Edge Computing
Container
Distributed Cloud
Microservice
Serverless
Essential Storage Service
Data Migration
Data Process and Analysis
Relational Database
NoSQL Database
Enterprise Distributed DBMS
Database SaaS Tool
Networking
CDN and Edge platform
Network Security
Data Security
Application Security
Endpoint Security
Business Security
Security Services
Security Management
Domains & Websites
Office Collaboration
Enterprise Applications
Data Analysis
Image Recognition
Face Recognition
Voice Technology
AI Platform Service
Natural Language Processing
Optical Character Recognition
Internet of Things
Message Queue
Middleware
Communication
Interactive Video Services
Stream Services
Media On-Demand
Media Process Services
Media SDK
Cloud Real-time Rendering
Game Services
Game Video Service
Education Services
Blockchain Service
Building Services
Cloud Resource Management
Management and Audit Tools
Developer Tools
Monitor and Operation
Education