Should I Choose Public Cloud GaussDB(DWS) or RDS?
Both allow you to run traditional relational databases on the cloud and offload database management tasks. RDS databases are useful for OLTP, reporting, and analysis, but are less capable of handling read operations of a large amount of data (complex read-only queries). GaussDB(DWS) uses multiple nodes and optimization methods like column-based storage, vectorized executors, and distributed frameworks to handle OLAP tasks. This reduces the analysis and reporting workload for large data sets by a significant amount compared to traditional databases.
You can scale out a GaussDB(DWS) cluster to address complex data and queries, or to handle overwhelming analysis and report workloads that affect OLTP performance.
The following table compares OLTP with OLAP.
Feature | OLTP | OLAP |
|---|---|---|
Users | Operation personnel and junior managers | Decision-making personnel and senior managers |
Functionality | Daily operations | Analysis and decision-making |
Design | Application-oriented | Subject-oriented |
Data | Latest, detailed, two-dimensional, and separated | Historical, integrated, multidimensional, unified |
Access | Reads/Writes dozens of records. | Reads millions of records. |
Scope of Work | Simple read/write operations | Complex queries |
Database size | Hundreds of GB | TB to PB |