Data Admin Service (DAS)

Updated on 2022-12-16 GMT+08:00

View PDF

Description

Data Admin Service (DAS) is a one-stop platform that allows you to manage databases on a web console. It offers database development, O&M, and intelligent diagnosis, making it easy for you to use and maintain databases. The Standard Edition provides a best-in-class experience. You no longer need to install clients locally for a visualized operation experience. Diverse database development functions are available, including data and table structure synchronization, online editing, and intelligent prompts for SQL input.

Version Requirements: The GaussDB(DWS) version must be 8.0.1 or later, and the Agent version must be 8.1.3.101 or later.

DAS provides the following functions for GaussDB(DWS) developers:

Browsing and managing database objects, such as databases, tables, views, stored procedures, sequences, and triggers.
Editing and executing PL/SQL statements
Managing SQL execution records

Technical Principles

Figure 1 Interaction between DAS and GaussDB(DWS)
Click to enlarge

As shown in the preceding figure, DAS uses the B/S structure and communicates with the GaussDB(DWS) database through the JDBC driver.

Figure 2 GaussDB(DWS) entry
Click to enlarge

Figure 3 DAS entry
Click to enlarge

Figure 4 DAS-SQL execution page
Click to enlarge

Figure 5 DAS-database object page
Click to enlarge

**Table 1** Description
No.	Function	Description
1	Managing database objects	Manages database objects such as databases, schemas, tables, columns, constraints, indexes, views, stored procedures, triggers, and sequences.
2	Creating and executing stored procedures/functions	Creates and executes stored procedures/functions
3	SQL editor	SQL statement execution, formatting, execution plan, SQL prompt, and common SQL management
4	Managing SQL execution records	Manages execution records of non-sensitive SQL statements.