Help Center > > Developer Guide> Welcome> Reading Guide

Reading Guide

Updated at:Aug 27, 2020 GMT+08:00

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

  • Service Overview: Describes the features, functions, and application scenarios of GaussDB(DWS).
  • Getting Started: The "Getting Started" section of GaussDB(DWS) 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.

GaussDB(DWS), during the development of the database application, provides the following table to help you find wanted information.

If you want to...

Query Suggestions

Quickly get started with GaussDB(DWS).

First, follow the steps in Data Warehouse Service Getting Started to quickly deploy a cluster, connect to a database, and try some queries.

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 Database Developer Guide.

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

Product Architecture describes the architecture of GaussDB(DWS).

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

Create databases, tables, users, and other database objects.

Before You Start is a brief introduction to SQL basics.

SQL Reference contains the SQL commands and functions of GaussDB(DWS) and the syntax and examples of other SQL elements.

Learning the Tutorial: Tuning Table Design describes key summaries and suggestions related to table design, such as selecting a storage model, distribution mode, and distribution column.

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 Tuning. Successful performance optimization depends more on database administrators' experience and judgment than on instructions and explanation. However, Query Performance Tuning 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 topics on database security. Reading Guide

Monitor and optimize system performance.

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

You should also learn from Management Guide about how to use the GaussDB(DWS) management console to check the system status and monitor metrics.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel