Updated at: 2022-08-03 GMT+08:00

Reading Guide

If you are a new GaussDB(DWS) user, you are advised to read the following contents first:

  • Sections describing the features, functions, and application scenarios of GaussDB(DWS).
  • "Getting Started": guides you through creating a data warehouse cluster, creating a database table, uploading data, and testing queries.

If you intend to or are migrating applications from other data warehouses to GaussDB(DWS), you might want to know how GaussDB(DWS) differs from them.

You can find useful information from the following table for GaussDB(DWS) database application development.

If you want to...

Query Suggestions

Quickly get started with GaussDB(DWS).

Deploy a cluster, connect to the database, and perform some queries by following the instructions provided in Getting Started.

When you are ready to construct a database, load data to tables and compile the query content to operate the data in the data warehouse. Then, you can return to the Data Warehouse Service Database Developer Guide.

Understand the internal architecture of a GaussDB(DWS) data warehouse.

To know more about GaussDB(DWS), go to the GaussDB(DWS) home page.

Learn how to design tables to achieve the excellent performance.

Development and Design Proposal introduces the design specifications that should be complied with during the development of database applications. Modeling compliant with these specifications fits the distributed processing architecture of GaussDB(DWS) and provides efficient SQL code.

To facilitate service execution through optimization, you can refer to Query Performance Optimization. Successful performance optimization depends more on database administrators' experience and judgment than on instructions and explanation. However, Query Performance Optimization still tries to systematically illustrate the performance optimization methods for application development personnel and new GaussDB(DWS) database administrators.

Load data.

Data Import describes how to import data to GaussDB(DWS).

Excellent Practices for Data Import provides key points for quick data import.

Manage users, groups, and database security.

Database Security Management covers database security topics.

Monitor and optimize system performance.

System Catalogs and System Views describes the system catalogs where you can query the database status and monitor the query content and process.

You can learn how to check the system running status and monitoring metrics on the GaussDB(DWS) console by referring to Management Guide.