What is DCloud Datamart?

A cloud-native data mart solution that helps business and IT teams provide domain-specific data for a team or department.

Ideal for making data-driven decisions faster and more practically.

Datamart Benefits:

Easy integration, smooth collaboration
Advanced analytics, faster decisions
Secure and compliance-ready

Key Features

Fast Columnar Analytic Engine

Column-based storage engine, ideal for analytics because it improves data retrieval and aggregation processing efficiency.

Built on PostgreSQL

DCloud Datamart leverages PostgreSQL as the core database, providing stability, flexibility, and a broad SQL ecosystem.

Load Data from S3

Load data from DObject, Amazon S3, or S3-compatible storage in CSV or Parquet format.

Secure, Encrypted Connections

End-to-end RSA-2048 encryption with SSL to secure data transfer.

Use Cases

Omnichannel Customer Behavior Analysis

Integrate sales, inventory, and promotion data from POS, e-commerce, and warehouse systems. Accelerate sales and inventory insights to optimize marketing strategy and grow revenue.

Unified Production and Supply Chain Dashboard

Load production, inventory, supply chain, and machine data into DCloud Datamart to optimize the supply chain and respond faster to market demand changes - more efficient processes, more agile business.

Improve financial analytics

Load transaction data into DCloud Datamart to build analytics for fraud detection and performance ranking.

Columnar Analytic Engine?

Column-based storage technology designed for fast, efficient, and scalable analytics queries.

Fast

Aggregation queries run in seconds, not minutes or hours - up to 100x faster.

Scalability

Columnar storage engine provides efficient data retrieval and aggregation processing for analytics at scale.

Storage Efficient

DCloud Datamart's columnar analytic engine delivers 2-5x better compression than row-based PostgreSQL.

BI Tools Ready

Designed for fast integration with Metabase, Apache Superset, Power BI, Tableau, and more.

Comparison with Standard PostgreSQL

	PostgreSQL (Row-Based Database)	DCloud Datamart (Columnar Database)
Purpose	Daily Transactions (OLTP)	Analytics Data (OLAP)
Performance	Slow with large data and heavy aggregation	Very fast for analyzing millions of rows
Storage Compression	Less efficient compression because data types vary within a row	More efficient compression with the same data type per column
Query Types	CRUD, transactional	Aggregation, group by, time series
Workloads	Transactional applications (ERP, POS, etc.)	Dashboards, BI reports, business insights