• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Welcome
  5. Reading Guide

Reading Guide

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

  • 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 Best 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 Getting Started in the Data Warehouse Service User Guide 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 this 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 product details 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.

Best Practices of Table Design briefly introduces the key summaries and suggestions related to table design, such as selecting storage models, distribution modes, and distribution columns.

Learn how to design tables to achieve the best 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.

Best Practices of 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 Views describes the system catalogs and views where you can query the database status and monitor the query content and process.

You should also learn from User Guide about how to use the DWS management console to check the system status, monitor metrics, and to back up and restore clusters.