Data Warehouse Service
Data Warehouse Service (DWS) is a real-time, simple, secure, and reliable enterprise-class converged data warehouse service. It is compatible with the standard ANSI SQL 99/2003 and PostgreSQL/Oracle ecosystems, providing state of the art PB-level big data analysis across a variety of industries.
Progressive Knowledge
DWS knowledge for users from beginner level to expert level
01
Understand
DWS architecture, functions, and application scenarios are provided to help you quickly select your desired type to match services. This facilitates easier data analysis.
Service Overview
03
Start
This document demonstrates how to create a data warehouse cluster, connect to a sample database, import sample data from OBS, and query and analyze the data, helping you quickly use DWS.
Getting Started
Initializing Data Disks
05
Excellent Practices
During table design, data import, and query design, comprehensively consider the factors to work out a proper solution. This chapter introduces key principles with necessary examples and usage suggestions.
Excellent Practices
07
Tools
DWS provides several database tools to facilitate database management and data import and export.
Tool Guide
08
APIs
DWS provides Representational State Transfer (REST) APIs. You can make API calls over HTTPS to manage clusters and snapshots. This document details DWS APIs, parameters, examples, and calling methods.
API Reference
09
Databases Monitoring
DMS is provided by GaussDB(DWS) to ensure the fast and stable running of databases. It collects, monitors, and analyzes the disk, network, and OS metric data used by the service database, as well as key performance metric data of cluster running.
Monitoring
Utilities
Workload Analysis
Typical Scenarios
02
Purchase
DWS supports two billing modes: pay-per-use (billed based on the actual duration) and yearly/monthly package (discount obtained by upfront payment).
Billing Mode
Quick Purchase
Billing FAQs
04
Be a Power User
DWS provides an easy-to-use management console, allowing you to quickly create clusters and easily manage data warehouses.
Common Operations
Connecting to a Cluster
O&M and Monitoring
06
Access the Database
The database developer guide is intended for database designers, application developers, and database administrators (DBAs), and provides information required for designing, building, querying, and maintaining data warehouses.
Common Operations
Data Import and Export
Performance Tuning
Resource Load Management
FAQs
Learn more about common issues and solutions.
Typical Cases
Database Connection
Database Performance
-
A DWS Cluster Becomes Read-Only and Is Locked, so Data Cannot be Written to It
-
Slow Response to a Query Statement
-
Forcibly Terminating a Session
-
It Takes a Long Time to Execute SQL Statements That Could be Executed Quickly Before
-
Error LOCK_WAIT_TIMEOUT Is Reported During SQL Execution
-
Memory Cannot be Allocated or Is Temporarily Unavailable
-
Error LOCK_WAIT_TIMEOUT Is Reported When VACUUM FULL Is Executed
-
Table Size Does not Change After VACUUM FULL Is Executed on the Table
Data Import and Export
Database Use
-
How to Change a Database's Default Time Zone When the Database Time Is Different from the System Time
-
Grant The Permission On The Tables to Be Created In The Schema To A Specified User
-
Is a Field Name Case-sensitive?
-
How Many Bytes Does a Chinese Character Occupy?
-
Content of Fields in the SQL Query Result Is Truncated
-
Failed to Delete a Database Because a Session Is Connected to the Database
-
DROP TABLE Fails to Be Executed
Technical Topics
Technologies, expert opinions, and courses
