Sign In

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

OceanBase Developer Center

V4.1.0Community Edition

Document Overview
What's New
- What's new
Overview
- What is ODC?
- Benefits
- Architecture
- Features
- Limits
Quick Start
- Overview
- Install ODC
- Log on to ODC with an account
- Create a private connection
Tutorials
- Tips on the SQL Console
- Create a connection
- Export data
- Import data
- Debug a stored procedure
- View the performance of an SQL statement
User Guide (Web ODC)
- Log on to ODC
  - Log on to ODC with an account
  - Change the password
- ODC homepage
- Connect to a database
  - Create a private connection
  - Manage private connections
- Public resource management
  - Overview
  - Quick start
  - Resource permissions
    - Manage public connections
    - Manage resource groups
    - Manage roles
    - Manage users
    - Automatic authorization rules
  - Task process management
  - Manage operation records
  - Data desensitization management
  - System settings
- Use the workspace
  - Overview
  - SQL window
  - Anonymous block window
  - Command-line window
  - Stored scripts
  - Snippet
- Use tools
  - Data export and import
    - Overview
    - Export and import formats
    - Batch export and import
    - Single table export and import
  - Data mocking
  - Partitioning plan
  - Database changes
  - Shadow table synchronization
  - SQL plan
- Recycle bin
- View operation records
- Task management
  - Overview
  - Import tasks
  - Export tasks
  - Data mocking tasks
  - Database change tasks
  - Partitioning plan task
  - Permission application tasks
  - Shadow table synchronization tasks
  - SQL plan task
- Session management
- Database objects
  - Table objects
    - Create a table
    - Create a table
    - Table list
    - Manage table attributes
    - Manage table data
  - View objects
    - Overview
    - Create a view
    - Manage views
  - Function objects
    - Overview
    - Create a function
    - Manage functions
  - Stored procedure objects
    - Overview
    - Create a stored procedure
    - Manage stored procedures
  - Sequence objects
    - Overview
    - Create a sequence
    - Manage sequences
  - Package objects
    - Overview
    - Create a program package
    - Manage program packages
  - Trigger objects
    - Overview
    - Create a trigger
    - Manage triggers
  - Type objects
    - Overview
    - Create a type
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
- Help center
User Guide (Client ODC)
- Install ODC
- ODC homepage
- Connect to a database
  - Create a private connection
  - Manage connections
- Use the workspace
  - Overview
  - SQL window
  - Anonymous block window
  - Command-line window
  - Stored scripts
  - Snippet
- Use tools
  - Data export and import
    - Overview
    - Export and import formats
    - Batch export and import
    - Single table export and import
  - Data mocking
  - Asynchronous execution
  - Shadow table synchronization
- Recycle bin
- View operation records
- Task management
  - Overview
  - Import tasks
  - Export tasks
  - Data mocking tasks
  - Database Change
  - Shadow table synchronization tasks
- Session management
- Database objects
  - Table objects
    - Overview
    - Create a table
    - Table list
    - Manage table attributes
    - Manage table data
  - View objects
    - Overview
    - Create a view
    - Manage views
  - Function objects
    - Overview
    - Create a function
    - Manage functions
  - Stored procedure objects
    - Overview
    - Create a stored procedure
    - Manage stored procedures
  - Sequence objects
    - Overview
    - Create a sequence
    - Manage sequences
  - Package objects
    - Overview
    - Create a program package
    - Manage program packages
  - Trigger objects
    - Overview
    - Create a trigger
    - Manage triggers
  - Type objects
    - Overview
    - Create a type
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
- Help center
Deployment Guide
- Deployment overview
- Preparations before deployment
- Deploy a single ODC node
  - Deployment process
  - Load and run an ODC image
- Deploy ODC in high availability mode
  - Deployment process
  - Load and run an ODC image
  - Deploy SSL certificate
  - Deploy the NGINX proxy
  - Configure certificate trust
- Deployment verification
Upgrade Guide
- Overview
- Preparations before upgrade
- Upgrade single-node ODC
  - Upgrade process
  - Stop ODC of the earlier version
  - Load and run an ODC image
- Upgrade high-availability
  - Upgrade process
  - Stop ODC of the earlier version
  - Load and run an ODC image
  - Upgrade NGINX image
- Upgrade verification
- Rollback after upgrade failed
FAQ

Download PDF

Document Feedback

Architecture

Last Updated：2026-04-13 06:45:38 Updated

share

share

The architecture of OceanBase Developer Center (ODC) consists of three parts:

Basic features
Core features
Advanced features

The following figure shows the architecture of ODC.

Basic features

User Management: This feature provides services such as account creation, system logon, and password modification.
Connection Management: This feature allows you to manage connections to OceanBase Database in MySQL and Oracle modes. You can create, save, copy, and delete database connections.

Core features

Object Management: This feature allows you to follow the instructions to create database objects, such as tables, views, functions, stored procedures, and sequences. This makes OceanBase Database easier to use. In addition, you can edit the online table data that you are currently viewing.
Console: In the console, you can save and edit the content in a SQL window and reuse the scripts that you have saved. You can also format SQL scripts and display structured SQL statements. The SQL editor supports auto-complete when you write SQL statements to save your effort. You can edit and export the result set returned from SQL execution. ODC V2.2.0 and later versions support PL and allow you to format, compile, run, and debug PL objects.

Advanced features

Toolkit: This feature includes session management, recycle bin management, and import and export tools. Session Management: The session management tool enables you to edit database sessions and global properties and terminate specified database sessions. Recycle Bin Management: The recycle bin management tool allows you to empty and restore database objects in the recycle bin. Import and Export: The import and export tools enable you to import or export data of various formats in one or more tables.
SQL Diagnostics: This feature allows you to diagnose SQL execution plans and view resource consumption during SQL execution. It can help you locate problems in SQL scripts.

Previous topic

Next topic