OceanBase Database

SQL - V4.0.0Enterprise Edition

Overview
- Overview
- System architecture
- Compatibility with MySQL
- Compatibility with Oracle
  - Overview
  - SQL data types
  - Built-in functions
  - System views
- Limits
Get Started
- Quick start with OceanBase Database
- Hands on for OceanBase SQL
  - Usage notes
  - Basic SQL operations (MySQL mode)
  - Basic SQL operations (Oracle mode)
- Build applications (MySQL Mode)
  - Connect Python applications to OceanBase Database
  - Connect Java applications to OceanBase Database
  - Connect C applications to OceanBase Database
- Build applications(Oracle Mode)
  - Connect Python applications to OceanBase Database
  - Connect Java applications to OceanBase Database
  - Connect C applications to OceanBase Database
- Experience OceanBase advanced features
  - Experience scalable OLTP
    - Run the TPC-C benchmark in OceanBase Database
    - Experience the hot row update capability of OceanBase Database
  - Experience operational OLAP
  - Experience parallel import and data compression
  - Experience the multitenancy feature
Develop
- Develop (MySQL Mode)
  - Connect to Oceanbase Database with client
    - Overview
    - Connect to an OceanBase Database tenant by using a MySQL client
    - Connect to an OceanBase Database tenant by using OBClient
    - Connect to OceanBase Database by using ODC
    - Java application
      - OceanBase Connector/J
      - Java APIs
      - Connect Java applications to OceanBase Database
    - C application
      - OceanBase Connector/C
      - C API functions
      - Connect C applications to OceanBase Database
    - Python applications
    - SpringBoot connection example
    - SpringBatch connection example
    - Example of Database connection pool configuration
      - Overview of database connection pool configuration
      - Example of configuring a Tomcat connection pool
      - Example of configuring a C3P0 connection pool
      - Example of configuring a Proxool connection pool
      - Example of configuring a HiKariCP connection pool
      - Example of configuring a DBCP connection pool
      - CommonPool configuration example
      - Example of configuring a JDBC connection pool
    - SpringJDBC connection example
    - SpringJPA connection example
    - Hibernate connection example
    - MyBatis connection example
  - Create and manage database objects
    - About DDL statements
    - View the currently connected database
    - Change the password of a user
    - Data type
      - General data types
      - Unsupported data types
    - Create and manage tables
      - About tables
      - Create a table
      - About auto-increment columns
      - About types of column constraints
      - About table structure modification
      - About table clearing
      - About table dropping
      - Flash back a dropped table
      - About table privileges
    - Create and manage partition tables
      - About partitioned tables
      - Create a partitioned table
      - Manage a partitioned table
      - Create a subpartitioned table
      - Manage a subpartitioned table
      - Partition routing
      - Indexes on partitioned tables
      - Suggestions on using partitioned tables
    - Create and manage indexes
      - About indexes
      - Create an index
      - Drop an index
    - Create and manage views
      - About views
      - Create a view
      - Modify a view
      - Delete a view
    - Create and manage sequences
      - About sequences
      - Create a sequence
      - Modify a sequence
      - Delete a sequence
    - Create and manage triggers
      - About triggers
      - Create a trigger
      - Delete a trigger
  - Query
    - About queries
    - Single-table queries
    - Conditional queries
    - ORDER BY queries
    - GROUP BY queries
    - Use the LIMIT clause in queries
    - Query data from multiple tables
      - About multi-table join queries
      - INNER JOIN queries
      - OUTER JOIN queries
      - Subqueries
    - Use operators and functions in a query
      - Use arithmetic operators in queries
      - Use numerical functions in queries
      - Use string connectors in queries
      - Use string functions in queries
      - Use datetime functions in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use NULL-related functions in queries
      - Use the CASE conditional operator in queries
      - Use the SELECT FOR UPDATE statement to lock query results
    - Execution plan
      - View an execution plan
      - Understand an execution plan
    - Use SQL hints in queries
    - Variables of query timeout
  - DML statements and transactions
    - DML statement
      - About DML statements
      - About the INSERT statement
      - UPDATE statements
      - About the DELETE statement
      - About the REPLACE INTO statement
    - Transactions
      - About transaction control statements
      - Start a transaction
      - Transaction savepoints
      - Commit a transaction
      - Roll back a transaction
      - About transaction timeout
  - Common errors and solutions
    - About error codes
    - Database connection error
    - About timeout
      - Idle session timeout
      - Transaction timeout errors
    - About user
      - Locked user
      - Incorrect user password
    - About table
      - Table already exists
      - Table does not exist
      - Invalid use of NULL value
    - About constraint
      - Unique key conflict
      - Foreign key conflict
    - About SQL commands
      - Data truncation
- Develop (Oracle Mode)
  - Connect to Oceanbase Database with client
    - Overview
    - Connect to an OceanBase tenant by using an Oracle client
    - Connect to an OceanBase Database tenant by using OBClient
    - Connect to OceanBase Database by using ODC
  - Application development
    - Java application
      - OceanBase Connector/J
      - Java APIs
      - Connect Java applications to OceanBase Database
    - Python application
      - OceanBase Connector/J in Python
      - Python APIs
      - Connect Python applications to OceanBase Database
    - 300.c-application-1
      - OceanBase Connector/C
      - OBCI APIs
      - Connect C applications to OceanBase Database
  - Create and manage database objects
    - About DDL statements
    - View the currently connected database
    - Change the password of a user
    - Data type
      - General data types
      - Unsupported data types
    - Create and manage tables
      - About tables
      - Create a table
      - Define an auto-increment column by using the SEQUENCE keyword
      - About types of column constraints
      - About table structure modification
      - About table clearing
      - About table dropping
      - Flash back a dropped table
      - About table privileges
    - Create and manage partition tables
      - About partitioned tables
      - Create a partitioned table
      - Manage a partitioned table
      - Create a subpartitioned table
      - Manage a subpartitioned table
      - Partition routing
      - Indexes on partitioned tables
      - Suggestions on using partitioned tables
    - Create and manage indexes
      - Drop an index
      - About indexes
      - Create an index
    - Create and manage views
      - About views
      - Create a view
      - Modify a view
      - Drop a view
    - Create and manage sequences
      - About sequences
      - Create a sequence
      - Modify a sequence
      - Delete a sequence
    - Create and manage synonyms
      - About synonyms
      - Create a synonym
      - Delete a synonym
    - Create and manage triggers
      - About triggers
      - Create a trigger
      - Modify a trigger
      - Delete a trigger
      - Enable or disable a trigger
  - Query
    - About queries
    - Single-table queries
    - Conditional queries
    - ORDER BY queries
    - GROUP BY queries
    - Use Row_Limiting_Clause in queries
    - Query data from multiple tables
      - About multi-table join queries
      - INNER JOIN queries
      - OUTER JOIN queries
      - Subqueries
    - Use operators and functions in a query
      - Use arithmetic operators in queries
      - Use numerical functions in queries
      - Use string concatenation operators in queries
      - Use string functions in queries
      - Use datetime functions in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use NULL-related functions in queries
      - Use CASE functions in queries
      - Use the SELECT FOR UPDATE statement to lock query results
    - Execution plan
      - View execution plans of queries
      - Understand an execution plan
    - Use SQL hints in queries
    - About query timeout variables
  - DML statements and transactions
    - DML statement
      - About DML statements
      - About the INSERT statement
      - UPDATE statements
      - About the MERGE statement
      - About the DELETE statement
    - Transactions
      - About transaction control statements
      - Start a transaction
      - Transaction savepoints
      - Commit a transaction
      - Roll back a transaction
      - About transaction timeout
  - Common errors and solutions
    - Overview
    - Database connection error
    - About timeout
      - Idle session timeout
      - Transaction timeout errors
    - About user
      - Locked user
      - Incorrect user password
    - About object
      - Object already exists
      - Object does not exist
    - About constraint
      - Unique key conflict
      - Foreign key conflict
    - About sql
      - Data type inconsistency
Deploy
- Overview
- Deployment procedure
- Preparations before deployment
  - Prepare servers
  - Configure servers
  - Prepare installation packages
- HA solution for OceanBase clusters
- Deploy through the CLI
  - Configure the deployment environment
    - Install oat-cli
    - Use oat-cli to configure the deployment environment
    - Configure the clock source
    - Upload installation packages
    - Configure host information
    - Check the environment before deployment
  - Deploy OCP
    - Deployment description
    - Generate a configuration file
    - Start deployment
    - Check after deployment
  - Deploy the OceanBase cluster
    - Deploy a single-replica OceanBase cluster
    - Deploy a three-replica OceanBase cluster
  - Deploy OBProxy
    - Deploy OBProxy through the CLI
  - Create an OceanBase tenant
    - View resources available for a business tenant
    - Create a tenant
    - Verify after deployment
  - Deploy OMS
    - Deployment description
    - Modify the configuration file
    - Start deployment
    - Check after deployment
  - Deploy ODC
    - Deployment description
    - Modify the configuration file
    - Start deployment
    - Check after deployment
Migrate
- Overview
- Migrate data by using SQL scripts
- Migrate data by using MySQLDump
- Migrate data by using DataX
- Migrate data by using OUTFILE statements

Download PDF

OceanBase

OceanBase

OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.

Company

About OceanBase Contact Us Partner

Product

OceanBase Cloud OceanBase Enterprise Quick Start Download Pricing

Resources

Docs Blog White Paper Trust Center

Follow us

© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security

Document Feedback

Prepare installation packages

Last Updated：2023-07-24 09:52:12 Updated

share

share

Before you deploy OceanBase Database, make sure that you have obtained the following packages for subsequent installation and deployment.

The following table describes the recommended images for the component installation packages.

Component	Purpose	Architecture	Recommended version
OceanBase Admin Toolkit (OAT)	To deploy OceanBase Cloud Platform (OCP), OceanBase Migration Service (OMS), and OceanBase Developer Center (ODC)	x86_64	Contact OceanBase Technical Support for the latest oat-cli installation package.
OceanBase Admin Toolkit (OAT)		AArch64	Contact OceanBase Technical Support for the latest oat-cli installation package.
OCP Docker image	To deploy OCP	x86_64	OCP V4.0.0 (x86_64)
OCP Docker image	To deploy OCP	AArch64	OCP V4.0.0 (AArch64)
OBServer Docker image	To deploy OBServer	x86_64	OceanBase Database V4.0.0 (x86_64)
OBServer Docker image	To deploy OBServer	AArch64	OceanBase Database V4.0.0 (AArch64)
OBProxy Docker image	To deploy OBProxy	x86_64	OBProxy V4.0.0 (x86_64)
OBProxy Docker image	To deploy OBProxy	AArch64	OBProxy V4.0.0 (AArch64)
ob_dns Docker image (optional)	To deploy three OCPs	x86_64	OBDNS_x86_20200929_1937 (x86_64)
ob_dns Docker image (optional)	To deploy three OCPs	AArch64	OBDNS_arm_20200929_1620 (AArch64)
OMS Docker image (optional)	To deploy OMS	x86_64	Contact OceanBase Technical Support for the latest OMS installation package.
OMS Docker image (optional)	To deploy OMS	AArch64	Contact OceanBase Technical Support for the latest OMS installation package.
ODC Docker image (optional)	To deploy ODC	x86_64	Contact OceanBase Technical Support for the latest ODC installation package.
ODC Docker image (optional)	To deploy ODC	AArch64	Contact OceanBase Technical Support for the latest ODC installation package.

Previous topic

Configure servers

Next topic

HA solution for OceanBase clusters