ApsaraDB for OceanBase:What is ODC?

No.

Window

Description

1

Workspace

You can click the workspace menu to switch between your team and individual workspaces.

• Team Workspace: provides unified control rules for multiple projects and members to ensure efficient team collaboration and secure data source changes.

• Individual Workspace: allows you to flexibly manage and change data sources without configuring complex control rules.

  

2

Workbench

You can conveniently view and access the following resource information in this window as needed:

• Overview of Scheduled Jobs: displays the number and status of the following types of periodic tasks executed in the last 7 days: Data Archiving, Data Cleanup, Partitioning Plan, and SQL Plan. You can quickly access the list of periodic tasks of a specific type by clicking the number of enabled tasks of that type.

• Quick Start: You can click For Admins or For Developers to view different quick start manuals and links to corresponding procedures.

• Recently Accessed Databases: displays basic information about recently accessed databases. You can click the name of a database or project to quickly access the target, or click the import or export button in the actions column to open the task window. For more information, see Export schemas and data.

• About Us: displays the download link for the latest ODC version and its release notes. You can share your suggestions by clicking the feedback link here or joining the DingTalk group to provide feedback on your experience with ODC.

• Best Practices: provides best practices for common ODC scenarios and issues to help you quickly get started and improve development and O&M efficiency.

3

Projects

With project administrator permissions, you can create projects and configure their members and databases. A project contains four types of resources: databases, tickets, members, and sensitive data. It serves as the smallest unit of collaboration. Tickets are the primary means of collaboration within a project, while sensitive data is the focus of data desensitization strategies.

4

Tickets

You can submit a ticket to perform operations such as importing, exporting, mocking, and archiving data, modifying a database, implementing lock-free schema changes, and managing SQL plans. You can also review the created tickets.

5

Data Sources

ODC allows you to connect to OceanBase Database to edit and manage data sources, including database objects and resources.

6

Users

With the ODC system administrator role, you can create and edit users and assign roles to grant them permissions for resource management and system operations. You can also configure automatic authorization rules to automatically grant specific roles or permissions to users that meet the specified conditions.

7

Security

In this window, you can perform the following operations:

• Manage SQL check and window specifications for different environments.

• Configure risk identification rules to match approval processes for different risky operations.

• View built-in data desensitization algorithms.

• View the operation records of all users.

  

8

SQL Console

You can quickly navigate to the SQL development window.

9

Settings

On the homepage of ODC, click Settings in the lower-left corner to set the database, editor, appearance, and account.

10

Help

In the lower-left corner of the ODC homepage, you can click Help to view tutorial documents for common operations in ODC, new features in the current version, and frequently asked questions.

Click the document you want to view on this tab. The introduction and link to the document are displayed in a dialog box. You can click the link to view the document.

11

Me

You can edit personal settings and view operation records in this window.

No.

Window

Description

1

Workspace

You can click the workspace menu to switch between your team and individual workspaces.

• Team Workspace: provides unified control rules for multiple projects and members to ensure efficient team collaboration and secure data source changes.

• Individual Workspace: allows you to flexibly manage and change data sources without configuring complex control rules.

  

2

Database

You can create and manage database objects in databases of the data source or project. You can view database objects by group.

3

Script

You can save edited scripts in the SQL Window and Anonymous Block Window and manage the saved scripts on the Script tab. You can also manage snippets on the Code Snippet tab.

4

Ticket

You can submit a ticket to perform operations such as importing, exporting, mocking, and archiving data, modifying a database, implementing lock-free schema changes, and managing SQL plans. You can also review the created tickets.

5

O&M Management

• Session Management: You can manage all sessions of the data source.

• Global Variables: You can query and modify all variables of databases connected to the current data source.

• Recycle Bin: You can query and restore deleted database objects.

  

6

SQL Window

1. SQL editing area: You can edit and execute SQL statements in this area.

2. Record tab: You can view the execution records of each SQL statement in the current connection.

3. Logs tab: You can view the execution records of the current SQL window.

4. Results tab: You can view the execution result of the current SQL statement.

7

Anonymous Block Window

You can compile, run, and debug PL objects and anonymous blocks.