Updated on 2023-03-30 GMT+08:00

Data Studio

Description

Data Studio is a GUI tool that connects to a database to help you execute and debug SQL statements and stored procedures. Data Studio supports basic features of GaussDB(DWS) and provides a GUI for database developers. This improves the efficiency of constructing application programs and simplifies database development.

Data Studio provides the following functions for database developers:

  • Browsing database objects
  • Creating and managing database objects, such as databases, users, tables, and indexes
  • Editing and running PL/SQL statements
  • Importing and exporting table data
  • Debugging SQL statements and stored procedures

Technical Principles

Figure 1 DataStudio component interaction

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

During debugging, two connections are used:

  • JDBC connection, which is used for query.
  • Logical connection, which is used for other debugging operations, such as breakpoint and variable operations.

The database service and debugging service communicate with each other through the shared memory.

Figure 2 Data Studio GUI

No.

Function

Description

1

Managing database objects

Manages database objects such as databases, schemas, tables, columns, constraints, indexes, views, tablespaces, and user roles.

2

SQL editor

Creates, edits, runs, and debugs PL/SQL stored procedures, formats query statements, automatically recommends SQL statements, and fills in templates.

3

Stored procedure debugging

Creates debugging links, uses breakpoints to control the execution of PL/SQL stored procedures, and displays debugging information such as call stacks and variables.

4

console

Views the execution plan and cost. Standard input and output are supported.

5

Query results

Displays, copies, exports, edits, and searches for query results.

For details about how to use Data Studio, see section About Data Studio.