Before You Start¶
Target Readers¶
This document is intended for database designers, application developers, and database administrators, and provides information required for designing, building, querying and maintaining data warehouses.
As a database administrator or application developer, you need to be familiar with:
Knowledge about OSs, which is the basis for everything.
SQL syntax, which is the necessary skill for database operation.
Prerequisites¶
Complete the following tasks before you perform operations described in this document:
Create a GaussDB(DWS) cluster.
Install an SQL client.
Connect the SQL client to the default database of the cluster.
For details about these tasks, see "Quickly Creating a GaussDB(DWS) Cluster and Importing Data for Query" in Getting Started with GaussDB(DWS)..
Reading Guide¶
Read the following contents first if you are new to GaussDB(DWS):
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.
Basic Operation | Query Suggestion |
|---|---|
Quickly getting started with GaussDB(DWS) | Deploy a cluster, connect to the database, and perform some queries by following the instructions provided in "Getting Started" of the Data Warehouse Service (DWS) User Guide. 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) homepage. |
Learn how to design tables to achieve the excellent performance. | GaussDB(DWS) 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 can facilitate SQL execution. To facilitate service execution through optimization, you can refer to Performance Tuning. Successful performance optimization depends more on database administrators' experience and judgment than on instructions and explanation. However, Performance Tuning still tries to systematically illustrate the performance optimization methods for application development personnel and new GaussDB(DWS) database administrators. |
Loading data | Importing Data describes how to import data to GaussDB(DWS). |
Managing users, groups, and database security | GaussDB(DWS) Database Security Management covers database security topics. |
Monitoring and optimizing system performance | GaussDB(DWS) System Catalogs and Views describes the system catalogs where you can query the database status and monitor the query content and process. You should also refer to "Monitoring Clusters" in the Data Warehouse Service (DWS) User Guide to learn how to use the GaussDB (DWS) console to check the system running status and monitoring metrics. |
SQL Syntax Text Conventions¶
To better understand the syntax usage, you can refer to the SQL syntax text conventions described as follows.
Format | Description |
|---|---|
Uppercase characters | Keywords must be in uppercase. |
Lowercase characters | Parameters must be in lowercase. |
[ ] | Items in brackets [] are optional. |
... | Preceding elements can appear repeatedly. |
[ x | y | ... ] | One item is selected from two or more options or no item is selected. |
{ x | y | ... } | One item is selected from two or more options. |
[x | y | ... ] [ ... ] | You can choose either multiple parameters or no parameters. If you choose multiple parameters, simply separate them with spaces. |
[ x | y | ... ] [ ,... ] | You can choose either multiple parameters or no parameters. If you choose multiple parameters, simply separate them with commas (,). |
{ x | y | ... } [ ... ] | You must select at least one parameter. If you select multiple parameters, separate them with spaces. |
{ x | y | ... } [ ,... ] | You must select at least one parameter. If you select multiple parameters, separate them with commas (,). |
Statement¶
When writing documents, the writers of GaussDB(DWS) try their best to provide guidance from the perspective of commercial use, application scenarios, and task completion. Even so, references to PostgreSQL content may still exist in the document. For this type of content, the following PostgreSQL Copyright is applicable:
Postgres-XC is Copyright © 1996-2013 by the PostgreSQL Global Development Group.
PostgreSQL is Copyright © 1996-2013 by the PostgreSQL Global Development Group.
Postgres95 is Copyright © 1994-5 by the Regents of the University of California.
IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS-IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.