Help Center > > Developer Guide> Welcome> Reading Guide

Reading Guide

Updated at: Jul 15, 2020 GMT+08:00

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

  • Service Overview: describes the features, functions, and application scenarios of 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 DWS, you might want to know how DWS differs from them. Learning the Tutorial: Tuning Table Design and Excellent Practices for Data Import list key points for table design and data loading in DWS. During the development of the database application, you can find the corresponding information in the following table.

If you want to...

Query Suggestions

Quickly get started with 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 DWS data warehouse.

Product Architecture describes the architecture of DWS.

To know more about DWS, go to the 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 DWS and the syntax and examples of other SQL elements.

Learning the Tutorial: Tuning Table Design briefly introduces the key summaries and suggestions related to table design, such as selecting storage models, distribution modes, and distribution key.

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 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 DWS database administrators.

Load data.

Data Import describes how to import data to 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.

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 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