Product Advantages

Product Advantages

  • Secure and Reliable

    GaussDB(DWS) is integrated with Database Security Service (DBSS) to better protect your privacy and data. It isolates networks and allows you to define security group rules for enhanced security. GaussDB(DWS) features HA design and transparent data encryption to ensure system and data reliability.
    GaussDB(DWS) is integrated with Database Security Service (DBSS) to better protect your privacy and data. It isolates networks and allows you to define security group rules for enhanced security. GaussDB(DWS) features HA design and transparent data encryption to ensure system and data reliability.
  • Easy to Use

    A unified console helps you easily manage data warehouses, freeing you to focus on data and services. GaussDB(DWS) is compatible with Oracle, PostgreSQL, and Teradata, giving you more flexibility. You can use the simple database migration tool to seamlessly migrate heterogeneous databases with confidence.
    A unified console helps you easily manage data warehouses, freeing you to focus on data and services. GaussDB(DWS) is compatible with Oracle, PostgreSQL, and Teradata, giving you more flexibility. You can use the simple database migration tool to seamlessly migrate heterogeneous databases with confidence.
  • Efficient

    You can import data into databases in real time, and perform T+0 agile service analysis and decision-making, and correlation analysis on at-scale data within seconds. You can take advantage of a range of enterprise-grade capabilities, including OLAP analysis, statistics analysis, and self-service analysis.
    You can import data into databases in real time, and perform T+0 agile service analysis and decision-making, and correlation analysis on at-scale data within seconds. You can take advantage of a range of enterprise-grade capabilities, including OLAP analysis, statistics analysis, and self-service analysis.
  • Various Import Modes

    GaussDB(DWS) enables you to batch rapidly import data from OBS and MRS. It interworks with DIS, CS, and DLI, allowing you to quickly import streaming data. GaussDB(DWS) uses third-party ETL and CDM for data migration and supports writing data in real time using Copy interfaces driven by JDBC.
    GaussDB(DWS) enables you to batch rapidly import data from OBS and MRS. It interworks with DIS, CS, and DLI, allowing you to quickly import streaming data. GaussDB(DWS) uses third-party ETL and CDM for data migration and supports writing data in real time using Copy interfaces driven by JDBC.

Application Scenarios

  • Data Warehouse Migration

  • ETL + BI Analysis

  • Real-Time Data Analysis

Data Warehouse Migration

Data Warehouse Migration

The data warehouse is an important data analysis system for enterprises. As the service volume grows, performance of self-built data warehouses cannot meet the actual service requirements due to scalability limitations and high costs. As an enterprise-class data warehouse on the cloud, GaussDB(DWS) features high performance, low cost, and easy scalability, meeting requirements of the big data era.

Advantages

Seamless Migration

Provides various migration tools to ensure seamless migration from popular data analysis systems such as Teradata, Oracle, MySQL, SQL Server, PostgreSQL, Greenplum, and Impala.

Compatible with Conventional Data Warehouses

Supports the SQL 2003 standard and stored procedures. It is compatible with most Oracle syntax and data structures, and can be seamlessly interconnected with common BI tools, significantly
reducing migration effort.

High Security and Reliability

Supports data encryption and interconnection with DBSS to ensure data security, and supports automatic full and incremental backup of data to improve data reliability.

ETL + BI Analysis

Enhanced ETL + Real-Time BI Analysis

The data warehouse is the pillar of the BI system and is used for collecting, storing, and analyzing massive volumes of data. It powers business decision analysis for the IoT, finance, education, mobile Internet, and O2O industries.

Advantages

Data Migration

Supports data import in batches in real time from multiple data sources.

High Performance

Cost-effective PB-level data storage and response to correlation analysis of trillions of data records within seconds.

Real-Time

Consolidates service data in real-time and provides actionable insights for operational decision-making.

Real-Time Data Analysis

Real-Time Data Analysis

In the mobile Internet and IoT domains, huge volumes of data must be processed and analyzed in real time to extract the full value of data. GaussDB(DWS) enables rapid data import and querying, thereby accelerating data analysis.

Advantages

Real-Time Import of Streaming Data

Data from IoT and Internet applications can be written into GaussDB(DWS) in real time after being processed by the stream computing and AI services.

Real-Time Monitoring and Prediction

Device monitoring, control, optimization, supply, self-diagnosis, and self-healing based on data analysis and prediction.

Converged AI Analysis

Supports correlation analysis on results of image and text data analysis (by AI services) and other service data.

Functions

Functions

  • High Reliability

    Provides a range of features to improve the reliability of data warehouse clusters.
    Provides a range of features to improve the reliability of data warehouse clusters.
  • PB-Level High-Performance

    Provides high-performance data warehouses dedicated for enterprises.
    Provides high-performance data warehouses dedicated for enterprises.
  • Openness and Compatibility

    Supports comprehensive SQL capabilities and ensures seamless application migration.
    Supports comprehensive SQL capabilities and ensures seamless application migration.
  • Monitoring and Audit

    Controls service usage and status.
    Controls service usage and status.
  • Built-in redundancy at the instance and data level prevents single points of failure (SPOFs), adding robustness to the service mix.
    Built-in redundancy at the instance and data level prevents single points of failure (SPOFs), adding robustness to the service mix.
  • Provides multiple data replicas and supports manual data backup to OBS.
    Provides multiple data replicas and supports manual data backup to OBS.
  • Automatically isolates faulty nodes, uses the replica to recover data, and supports node replacement.
    Automatically isolates faulty nodes, uses the replica to recover data, and supports node replacement.
  • Automatic incremental backup ensures data reliability at zero cost.
    Automatic incremental backup ensures data reliability at zero cost.
  • Uses a MPP-based computing framework, and supports hybrid row-column storage and vectorized executors, as well as SQL 03 analysis functions.
    Uses a MPP-based computing framework, and supports hybrid row-column storage and vectorized executors, as well as SQL 03 analysis functions.
  • Adopts in-memory computing, MPP and SMP technologies, and LLVM, improving performance by 2-10 times.
    Adopts in-memory computing, MPP and SMP technologies, and LLVM, improving performance by 2-10 times.
  • Optimizes the communication between large-scale clusters based on telecommunication technologies, improving data transmission efficiency between compute nodes.
    Optimizes the communication between large-scale clusters based on telecommunication technologies, improving data transmission efficiency between compute nodes.
  • Cost-based optimizer generates an execution plan based on cluster scale and data volume for optimal efficiency.
    Cost-based optimizer generates an execution plan based on cluster scale and data volume for optimal efficiency.
  • Supports SQL 92 and SQL 2003 standards, complete transaction processing capabilities, and stored procedures.
    Supports SQL 92 and SQL 2003 standards, complete transaction processing capabilities, and stored procedures.
  • Compatible with the PostgreSQL ecosystem and supports interconnection with mainstream database ETL and BI tools provided by third-party vendors.
    Compatible with the PostgreSQL ecosystem and supports interconnection with mainstream database ETL and BI tools provided by third-party vendors.
  • One-click schema migration tool and SQL code conversion for heterogeneous databases like Oracle and MySQL.
    One-click schema migration tool and SQL code conversion for heterogeneous databases like Oracle and MySQL.
  • Compatible with Oracle, PostgreSQL, and Teradata.
    Compatible with Oracle, PostgreSQL, and Teradata.
  • Integrates with CTS, enabling you to audit all operations performed on the GaussDB(DWS) management console, and API calls.
    Integrates with CTS, enabling you to audit all operations performed on the GaussDB(DWS) management console, and API calls.
  • Integrates with Cloud Eye, enabling you to monitor compute nodes and databases in the cluster.
    Integrates with Cloud Eye, enabling you to monitor compute nodes and databases in the cluster.
  • Records all SQL operations, involving connection attempts, queries, and database changes.
    Records all SQL operations, involving connection attempts, queries, and database changes.

Register to Try Popular Products for Free

Register Now