MatrixOne v0.8.0 Documentation
首页 白天 夜间 BookChat 小程序 小程序 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Schema Design

来源 MatrixOne 浏览 1 扫码 打印 2026-10-29 07:21:07
    • Overview
    • Create Database
    • Create Table
    • Create View
    • Create Temporary Table
    • Create Secondary Index
    • Data Integrity
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Home
    • Overview
      • MatrixOne Introduction
      • MatrixOne Feature List
      • MatrixOne Feature
        • HTAP
        • Multi-Account
        • Scalability
        • Cost-Effective
        • High Availability
        • MySQL Compatibility
      • MatrixOne Architecture Design
        • Architecture Design Overview
        • Detailed Logservice Architecture
        • Detailed Proxy Architecture
        • Detailed Caching and Hot-Cold Data Separation Architecture
      • What’s New
    • Getting Started
      • Deploy standalone MatrixOne
        • Overview
        • Deploy on macOS
          • Building from source code
          • Using binary package
          • Using Docker
        • Deploy on Linux
          • Building from source code
          • Using binary package
          • Using Docker
      • Basic SQL
    • Developing Guide
      • Connect to MatrixOne
        • Connecting to MatrixOne with Database Client Tool
        • Java connect to MatrixOne
          • Connect MatrixOne with JDBC
          • Connect MatrixOne with Java ORMs
        • Python connect to MatrixOne
        • Connecting to MatrixOne with Golang
        • MatrixOne SSL connection
      • Schema Design
        • Overview
        • Create Database
        • Create Table
        • Create View
        • Create Temporary Table
        • Create Secondary Index
        • Data Integrity
          • Data Integrity Constraints Overview
          • NOT NULL Constraints
          • UNIQUE KEY Constraints
          • PRIMARY KEY Constraints
          • FOREIGN KEY Constraints
      • Import Data
        • Insert
        • Bulk Load
          • Bulk Load Overview
          • Load csv format data
          • Load jsonlines format data
          • Load data from S3
          • Load data by using the `source`
      • Export Data
        • Export data by SELECT INTO
        • Export data by MODUMP
      • Read Data
        • Query Data from a Single Table
        • Multi-table Join Queries
        • Subquery
        • Views
        • Common Table Expression
      • Account Design
        • Publish-Subscribe
      • Transactions
        • General Transaction Overview
        • Transaction by MatrixOne Server
          • Transaction Overview
          • Explicit Transaction
          • Implicit Transaction
          • Pessimistic Transaction
          • Optimistic Transaction
          • Isolation Level
          • MVCC
          • How to use transaction
            • User Guide
            • Scenario
      • Application Developing Tutorials
        • Java CRUD demo
        • SpringBoot and JPA CRUD demo
        • SpringBoot and MyBatis CRUD demo
        • Python CRUD demo
        • SQLAlchemy CRUD demo
        • Golang CRUD demo
    • Deploying
      • Plan MatrixOne Cluster Topology
        • Experience Environment Deployment Plan
        • Minimum Production Environment Deployment Plan
        • Recommended Production Environment Deployment Plan
      • MatrixOne distributed cluster deployment
      • Maintenance
        • Starting and stopping
        • Updating
        • Health check and resource monitoring
        • Scaling
        • Managing CN Groups with Proxy
        • Import data from local Minio to MatrixOne
        • Operator Management
    • Maintenance
      • Backup and Restore
      • Mount Data
        • Mount directory to Docker container
    • Migrating
      • Migrate data to MatrixOne Overview
      • Migrate data from MySQL to MatrixOne
      • Migrate data from SQL Server to MatrixOne
      • Migrate data from SQL Server to MatrixOne
    • Testing
      • Performance Testing
        • SSB Test with MatrixOne
        • TPCH Test with MatrixOne
        • TPCC Test with MatrixOne
      • Testing Tool
        • MO-Tester
        • MO-Tester Specification
    • Performance Tuning
      • SQL Performance Tuning Methods Overview
      • Understanding the Query Execution Plan
        • Query Execution Plan Overview
        • Using EXPLAIN to learn the execution plan
        • Explain Statements Using JOIN
        • Explain Statements Using Subqueries
        • Explain Statements Using Aggregation
        • EXPLAIN Statements Using Views
      • Performance tuning best practices
        • Using Cluster by for performance tuning
        • Scaling CN for better performance
    • Privilege
      • TLS Introduction
      • Password Management
      • What is MatrixOne Privilege Management
        • About MatrixOne Privilege Management
        • Best Practices
      • User Guide
        • Quick Start
          • Create accounts, Verify Resource Isolation
          • Use the new account to creates users, roles, grant the privilege
        • Privileges Management User guide
      • Application Scenario
    • Reference
      • System Variables
        • System Variables Overview
        • System Variables parameters
          • SQL Mode
          • Save query result support
          • Timezone support
          • Lowercase table names support
        • Custom variable
      • SQL Language Structure
        • Keywords
        • Comments
      • Data Types
        • Data Types Overview
        • Data Type Conversion
        • Timestamp Initialization
        • JSON Data Type
        • BLOB and TEXT Type
        • Fixed-Point Types (Exact Value) - DECIMAL
      • SQL Statements
        • Data Definition Language
          • CREATE DATABASE
          • CREATE INDEX
          • CREATE TABLE
          • CREATE EXTERNAL TABLE
          • CREATE PUBLICATION
          • CREATE SEQUENCE
          • CREATE…FROM…PUBLICATION…
          • CREATE VIEW
          • ALTER TABLE
          • ALTER PUBLICATION
          • ALTER VIEW
          • DROP DATABASE
          • DROP INDEX
          • DROP TABLE
          • DROP PUBLICATION
          • DROP SEQUENCE
          • DROP VIEW
          • TRUNCATE TABLE
        • Data Manipulation Language
          • INSERT
          • INSERT INTO SELECT
          • INSERT ON DUPLICATE KEY UPDATE
          • DELETE
          • UPDATE
          • LOAD DATA
          • Information Functions
            • CURRENT_USER()
            • CURRENT_ROLE()
            • LAST_QUERY_ID()
            • LAST_INSERT_ID()
        • Data Query Language
          • SELECT
          • SUBQUERY
            • SUBQUERY Overview
            • Derived Tables
            • Comparisons Using Subqueries
            • SUBQUERY with ANY or SOME
            • SUBQUERY with ALL
            • SUBQUERY with EXISTS
            • SUBQUERY with IN
          • JOIN
            • JOIN Overview
            • INNER JOIN
            • LEFT JOIN
            • RIGHT JOIN
            • FULL JOIN
            • OUTER JOIN
            • NATURAL JOIN
          • With CTE
          • Combining Queries
            • Combining Queries Overview
            • UNION
            • INTERSECT
            • MINUS
        • Data Control Language
          • CREATE ACCOUNT
          • ALTER ACCOUNT
          • CREATE ROLE
          • CREATE USER
          • ALTER USER
          • DROP ACCOUNT
          • DROP USER
          • DROP ROLE
          • GRANT
          • REVOKE
        • Other
          • SHOW
            • SHOW ACCOUNTS
            • SHOW DATABASES
            • SHOW CREATE TABLE
            • SHOW CREATE VIEW
            • SHOW CREATE PUBLICATION
            • SHOW TABLES
            • SHOW INDEX
            • SHOW COLLATION
            • SHOW COLUMNS
            • SHOW FUNCTION STATUS
            • SHOW GRANT
            • SHOW PUBLICATIONS
            • SHOW ROLES
            • SHOW SEQUENCES
            • SHOW SUBSCRIPTIONS
            • SHOW VARIABLES
          • SET
            • SET ROLE
          • USE
            • USE DATABASE
          • KILL
          • Prepared Statements
            • Prepared Statements Overview
            • PREPARE
            • EXECUTE
            • DEALLOCATE
          • Explain
            • EXPLAIN
            • EXPLAIN Output Format
            • Explain Analyze
      • Functions and Operators
        • Operators
          • INTERVAL
          • OPERATORS
            • OPERATORS Overview
            • OPERATORS Precedence
            • Arithmetic Operators
              • Arithmetic Operators Overview
              • %,MOD
              • *
              • +
              • -
              • -
              • /
              • DIV
            • Assignment Operators
              • Assignment Operators Overview
              • \=
            • Bit Functions and Operators
              • Bit Functions and Operators Overview
              • &
              • >>
              • <<
              • ^
              • |
              • ~
            • Cast Functions and Operators
              • Cast Functions and Operators Overview
              • CAST
              • CONVERT
            • Comparison Functions and Operators
              • Comparison Functions and Operators Overview
              • >
              • >=
              • <
              • <>,!=
              • <=
              • \=
              • BETWEEN … AND …
              • IN
              • IS
              • IS NOT
              • IS NOT NULL
              • IS NULL
              • LIKE
              • NOT BETWEEN … AND …
              • NOT LIKE
              • COALESCE
            • Flow Control Functions
              • Flow Control Functions Overview
              • CASE WHEN
              • IF
            • Logical Operators
              • Logical Operators Overview
              • AND,&&
              • NOT,!
              • OR
              • XOR
        • Functions
          • Aggregate Functions
            • ANY_VALUE
            • AVG
            • BIT_AND
            • BIT_OR
            • BIT_XOR
            • COUNT
            • GROUP_CONCAT
            • MAX
            • MEDIAN
            • MIN
            • STDDEV_POP
            • SUM
            • VARIANCE
          • Datetime
            • CURDATE()
            • CURRENT_TIMESTAMP()
            • DATE()
            • DATE_ADD()
            • DATE_FORMAT()
            • DATE_SUB()
            • DATEDIFF()
            • DAY()
            • DAYOFYEAR()
            • EXTRACT()
            • FROM_UNIXTIME
            • MONTH()
            • TIMEDIFF()
            • TIMESTAMP()
            • TO_DATE()
            • UNIX_TIMESTAMP
            • UTC_TIMESTAMP()
            • WEEKDAY()
            • YEAR()
          • Mathematical
            • ABS()
            • ACOS()
            • ATAN()
            • CEIL()
            • COS()
            • COT()
            • EXP()
            • FLOOR()
            • LN()
            • LOG()
            • PI()
            • POWER()
            • RAND()
            • ROUND()
            • SIN()
            • SINH()
            • TAN()
            • UUID()
          • String
            • BIN()
            • BIT_LENGTH()
            • CHAR_LENGTH()
            • CONCAT()
            • CONCAT_WS()
            • EMPTY()
            • ENDSWITH()
            • FIELD()
            • FIND_IN_SET()
            • FORMAT()
            • HEX()
            • INSTR()
            • LEFT()
            • LENGTH()
            • LPAD()
            • LTRIM()
            • OCT()
            • REVERSE()
            • RPAD()
            • RTRIM()
            • SPACE()
            • SPLIT_PART()
            • STARTSWITH()
            • SUBSTRING()
            • SUBSTRING_INDEX()
            • TRIM()
            • Regular Expressions
              • Regular Expressions Overview
              • NOT REGEXP
              • REGEXP_INSTR()
              • REGEXP_LIKE()
              • REGEXP_REPLACE()
              • REGEXP_SUBSTR()
          • Table
            • UNNEST()
          • Window Functions
            • Window Functions Overview
            • DENSE_RANK()
            • RANK()
            • ROW_NUMBER()
          • JSON Functions
          • Other Functions
            • SLEEP
      • System Paramaters
        • Boot Parameters for standalone installation
      • MatrixOne Catalog
      • Privilege Control Types
      • Limitations
        • JDBC supported features list
        • Partitioning supported features list
      • MatrixOne Directory Structure
    • Troubleshooting
      • Slow Queries
      • Common statistic data query
      • Database statistics
      • Audit
      • Error Code
    • FAQs
      • Product FAQs
      • Deployment FAQs
      • SQL FAQs
    • Release Notes
      • Release Timeline
      • v0.7.0
      • v0.6.0
      • v0.5.1
      • v0.5.0
      • v0.4.0
      • v0.3.0
      • v0.2.0
      • v0.1.0
    • Glossary
    • Contribution Guide
      • Make Your First Contribution
      • How to Contribute
        • Types of Contributions
        • Preparation
        • Report an Issue
        • Contribute Code
        • Review a Pull Request
        • Contribute Documentation
        • Make a Design
      • Code Style
        • Code of Conduct
        • Code Comment Style
        • Commit & Pull Request Style
    暂无相关搜索结果！

      本文档使用 WanXiangYunDang 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      微信小程序阅读

      BookChat 微信小程序阅读
      微信扫一扫，知识掌上学

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度