OceanBase Database

SQL - V4.0.0

Document overview
Overview
- Overview
- System architecture
- Compatibility with MySQL
- Limits
Get Started
- Quick experience
- Hands on for OceanBase SQL
  - Before you start
  - Basic SQL operations
- Create a sample application
  - Connect to OceanBase Database by using a Python driver
  - Connect to OceanBase Database by using Go MySQL Driver
  - Connect a Java application to OceanBase Database
  - Connect a C application to OceanBase Database
- Experience OceanBase advanced features
  - Experience scalable OLTP
    - Run the TPC-C benchmark test on 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
- Connect to Oceanbase Database with client
  - Overview
  - Connect to OceanBase Database by using a MySQL client
  - Connect to OceanBase Database by using OBClient
  - Connect to OceanBase Database by using ODC
  - Connect Java applications to OceanBase Database
  - Connect to OceanBase Database by using Go MySQL Driver
  - Connect to OceanBase Database by using Unix ODBC
  - C application
    - OceanBase Connector/C
    - C API functions
    - Connect C applications to OceanBase Database
  - Connect Python applications to OceanBase Database
  - SpringBoot connection example
  - SpringBatch connection example
  - SpringJDBC connection example
  - SpringJPA connection example
  - Hibernate connection example
  - MyBatis 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
- 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
- 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
Deploy
- Overview
- On-premises deployment
  - Software and hardware requirements
  - Configuration before deployment
  - Deploy OceanBase Database online
  - Deploy OceanBase Database offline
- Deploy OceanBase Database in a Kubernetes cluster
- High availability deployment
  - Use Alibaba Otter to implement remote active-active disaster recovery
Migrate
- Data Migration Overview
- Migrate data from MySQL Database to OceanBase
  - Use Canal to synchronize MySQL data to OceanBase Database in real time
  - Use DataX to migrate MySQL data to OceanBase Database
  - Use DBCAT to migrate MySQL table schemas to OceanBase Database
  - Migrate MySQL table schemas to OceanBase Database by using mysqldump
  - Migrate MySQL table data to OceanBase Database by using mysqldump
- Use OBDUMPER to export data from or OBLOADER to import data to OceanBase Database
- Migrate data from CSV-file to OceanBase
  - Use DataX to load CSV data files to OceanBase Database
  - Use the LOAD DATA statement to load CSV data files to OceanBase Database
- Migrate data from SQL files to OceanBase Database
- Migrate data and resource units between tables
- Migrate data from OceanBase Database to MySQL
  - Use Canal to synchronize OceanBase Database data to MySQL in real time

Download PDF

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

Document Feedback

Document overview

Last Updated：2023-07-21 09:11:01 Updated

OceanBase is an enterprise-grade open source distributed SQL database. It supports transparent scalability, distributed transaction, multi-tenancy, and is highly compatible with MySQL

Get started	Develop	Migrate
OceanBase Overview	Connect to OceanBase via OBClient	Use Canal to synchronize MySQL data to OceanBase Database in real time
Quick experience	Manage database objects	Use DBCAT to migrate MySQL table schemas to OceanBase Database
Basic SQL operations	Write data	Migrate MySQL table schemas to OceanBase Database by using mysqldump
Connect to OceanBase	Query data	Migrate MySQL table data to OceanBase Database by using mysqldump
Run the TPC-C benchmark test on OceanBase Database	Transaction	Use DataX to migrate MySQL data to OceanBase Database

Next topic

Overview