What's New|V3.4.0|OceanBase Developer Center| docs|Distributed Database

What's New

Last Updated：2023-06-25 03:27:30 Updated

OceanBase Developer Center (ODC) V3.4.0 released in September 2022 provides the following new features: logon verification code, dark theme, data desensitization, application and approval of permissions on public resources, and OAuth 2.0 authorization. The new version optimizes features such as import and export, result set, table object management, and session status labeling.

Updated modules and features

Feature	Module	Description
Verification code mechanism	Account logon	The verification code mechanism is provided on the logon page of web ODC.
GUI updates	ODC homepage	The ODC console supports smooth switch between the default theme and the dark theme. The new dark theme displays content with a reconstructed color scheme to highlight icons. This helps you focus on operations and reduces eye irritation caused by prolonged gaze at a bright light source.
Data desensitization	Data desensitization management Result tab Batch export and import	ODC supports static data desensitization and allows you to enable data desensitization strategies in operations such as data export and result set export. For example, ODC supports built-in desensitization rules for data such as email addresses, bank card numbers, phone numbers, ID card numbers, and names. You can configure desensitization strategies based on the valid range of `database name.table name.field name` specified by the desensitization rules. ODC also allows you to configure custom desensitization rules by using desensitization algorithms such as masking, character replacement, format retaining, hashing, rounding, and null value assignment.
Application and approval of permissions on public resources	Permission application tasks Task process management	A general user can apply to the administrator of the public resource console for the permission to use a public connection. After the user creates a public connection permission application task in the task center, the administrator can approve the task on the Task Process Management page of the public resource console. The user can view the task information and approval status in the task list of the task center.
Import and export	Batch export and import (web ODC) Batch export and import (ODC client)	The import and export settings page is upgraded from configuration on a single page to wizard-based configuration, which provides step-by-step guidance. Whole database export is supported. During partial export, you can select multiple objects to export at a time. In addition, the ODC client no longer limit the size of data to be exported. The exported content can be desensitized based on desensitization strategies. You can configure custom desensitization strategies as needed to ensure data security.
Result sets	Result tab	When you execute multiple SQL statements in an SQL window, if an error is reported for an SQL statement, the problematic row is highlighted, and an alert icon is displayed on the log tab to inform you about the error. For more information, see Logs tab. The display of SQL execution results is optimized. For example, numbers are right-aligned, and other types of data are left-aligned. Built-in adaptive rules based on the data type and length of the field are used. When you edit a result set, you can add a new row beneath the specified row. After you submit an SQL statement for confirmation, the generated SQL statement is formatted for display so that you can view lengthy clauses. When you export the result set of a query, you can desensitize the exported data and specify the number of exported data rows. If you export data in CSV format, the exported CSV file can be opened by Microsoft Excel. If you export data in XLS format, you can specify whether to include the column header and whether to export the SQL statements of the query.
Table objects	Table creation	The procedure of table creation is more interactive. For example, you can drag columns, copy rows, reorder rows, and double-click a cell to edit it. Capabilities for table creation, such as setting virtual columns, expressions, index types, and visibility, and configuration of other attributes of a field, such as the character set, symbol selection, and automatic date update, are migrated from the kernel to the ODC console. The following table creation rules are added based on the table management syntax: 1. If you do not create a column when you create a table, you are prompted that you cannot create the table. 2. A field is automatically generated with the default length based on the field type. 3. An auto-increment column can be reset to a regular column, but not vice versa. 4. Exclusion between column attributes is internally set. For example, no default values can be set for an auto-increment column.
Session status labeling	SQL editing area	If you hover the pointer over the SQL window tab, the window name and execution status are displayed.

Community Edition

Enterprise Edition

What's New

Updated modules and features