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

Download PDF

Document Feedback

Architecture

Last Updated：2023-09-05 07:40:36 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