Data Studio

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

View PDF

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
Click to enlarge

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
Click to enlarge

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.