思维导图备注

MatrixOne v1.1 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Schema Design

 Github  来源:MatrixOne 浏览 115 扫码 分享 2024-01-26 12:47:33
  • Overview
  • Create Database
  • Create Table
  • Create View
  • Create Temporary Table
  • Create Secondary Index
  • Data Integrity
当前内容版权归 MatrixOne 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 MatrixOne .
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • MatrixOne v1.1 中文文档
  • MatrixOne v1.1 Documentation
  • MatrixOne v1.0 中文文档
  • MatrixOne v0.8.0 中文文档
  • MatrixOne v0.8.0 Documentation
  • MatrixOne v0.7.0 Documentation
  • MatrixOne v0.7.0 中文文档
  • MatrixOne v0.6.0 Documentation
  • MatrixOne v0.6.0 中文文档
  • MatrixOne v0.5.1 Documentation
  • MatrixOne v0.4 中文文档
  • MatrixOne v0.4 Documentation
  • MatrixOne v0.3 中文文档
  • MatrixOne v0.3 Documentation
  • MatrixOne Documentation
  • Overview
    • MatrixOne Introduction
    • MatrixOne Feature List
    • MatrixOne Feature
      • HTAP
      • Multi-Account
      • Scalability
      • Cost-Effective
      • High Availability
      • MySQL Compatibility
    • MatrixOne Architecture Design
      • Architecture Design Overview
      • Transactional Analytical Engine Architecture
      • Detailed Logservice Architecture
      • Logtail Protocol Architecture
      • Transaction and Lock Mechanisms Architecture
      • Detailed Proxy Architecture
      • Detailed Caching and Hot-Cold Data Separation Architecture
      • Detailed Stream Engine 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
        • AUTO INCREMENT Constraints
    • Write Data
      • 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`
      • Update Data
      • Delete Data
      • Prepared
    • 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
      • Window Function.
    • Account Design
      • Multi-Account Overview
      • 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
      • Gorm CRUD demo
    • Ecological Tools
      • BI Tools
        • Visualizing MatrixOne Data with FineBI
        • Visualizing MatrixOne Reports with Yonghong BI
        • Visual Monitoring of MatrixOne with Superset
      • ETL Tools
        • Writing Data to MatrixOne Using SeaTunnel
        • Writing Data to MatrixOne Using DataX
      • Computing Engine
        • Writing Batch data to MatrixOne Using Spark
        • Writing Real-Time Data to MatrixOne Using Flink
      • Scheduling Tools
        • Connecting MatrixOne with DolphinScheduler
  • Deploying
    • Plan MatrixOne Cluster Topology
      • Cluster Topology Planning Overview
      • 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
      • MatrixOne Backup and Recovery Overview
      • Backup and Recovery Concepts
      • Backup and Restore by using mo-dump
    • 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
    • Migrate data from PostgreSQL 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
    • Security and Permissions Overview
    • Authentication and Authorization
    • Password Management
    • Access Control
      • About MatrixOne Privilege Management
      • Privilege Management Scenario
      • Best Practices
    • User Guide
      • Privileges Management Overview
      • Create accounts, Verify Resource Isolation
      • Use the new account to creates users, roles, grant the privilege
    • Data Transmission Encryption
    • Security Audit
  • 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
      • Date and Time Types
        • Timestamp Initialization
        • YEAR Type
      • JSON Data Type
      • BLOB and TEXT Type
      • ENUM Type
      • UUID Type
      • Fixed-Point Types (Exact Value/) - DECIMAL
    • SQL Statements
      • Type of SQL Statements
      • Data Definition Language
        • CREATE DATABASE
        • CREATE INDEX
        • CREATE TABLE
        • CREATE EXTERNAL TABLE
        • CREATE PUBLICATION
        • CREATE SEQUENCE
        • CREATE STAGE
        • CREATE…FROM…PUBLICATION…
        • CREATE VIEW
        • ALTER TABLE
        • ALTER PUBLICATION
        • ALTER STAGE
        • ALTER VIEW
        • DROP DATABASE
        • DROP INDEX
        • DROP TABLE
        • DROP PUBLICATION
        • DROP SEQUENCE
        • DROP STAGE
        • DROP VIEW
        • TRUNCATE TABLE
      • Data Manipulation Language
        • INSERT
        • INSERT INTO SELECT
        • INSERT ON DUPLICATE KEY UPDATE
        • DELETE
        • UPDATE
        • LOAD DATA
        • REPLACE
        • Information Functions
          • 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 PROCESSLIST
          • SHOW PUBLICATIONS
          • SHOW ROLES
          • SHOW SEQUENCES
          • SHOW STAGE
          • SHOW SUBSCRIPTIONS
          • SHOW VARIABLES
        • SET
          • SET ROLE
        • USE
          • USE DATABASE
        • KILL
        • Prepared Statements
          • 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
            • BINARY
            • CAST
            • CONVERT
          • Comparison Functions and Operators
            • Comparison Functions and Operators Overview
            • >
            • >=
            • <
            • <>,!=
            • <=
            • \=
            • BETWEEN … AND …
            • IN
            • IS
            • IS NOT
            • IS NOT NULL
            • IS NULL
            • ILIKE
            • ISNULL
            • LIKE
            • NOT BETWEEN … AND …
            • NOT IN
            • NOT LIKE
            • COALESCE
          • Flow Control Functions
            • Flow Control Functions Overview
            • CASE WHEN
            • IF
            • IFNULL
            • NULLIF
          • 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(/)
          • HOUR(/)
          • FROM_UNIXTIME
          • MINUTE(/)
          • MONTH(/)
          • SECOND(/)
          • TIME(/)
          • TIMEDIFF(/)
          • TIMESTAMP(/)
          • TIMESTAMPDIFF(/)
          • TO_DATE(/)
          • TO_DAYS(/)
          • TO_SECONDS(/)
          • UNIX_TIMESTAMP
          • UTC_TIMESTAMP(/)
          • WEEK(/)
          • WEEKDAY(/)
          • YEAR(/)
        • Mathematical
          • ABS(/)
          • ACOS(/)
          • ATAN(/)
          • CEIL(/)
          • COS(/)
          • COT(/)
          • EXP(/)
          • FLOOR(/)
          • LN(/)
          • LOG(/)
          • LOG2(/)
          • LOG10(/)
          • PI(/)
          • POWER(/)
          • RAND(/)
          • ROUND(/)
          • SIN(/)
          • SINH(/)
          • TAN(/)
        • String
          • BIN(/)
          • BIT_LENGTH(/)
          • CHAR_LENGTH(/)
          • CONCAT(/)
          • CONCAT_WS(/)
          • EMPTY(/)
          • ENDSWITH(/)
          • FIELD(/)
          • FIND_IN_SET(/)
          • FORMAT(/)
          • HEX(/)
          • INSTR(/)
          • LEFT(/)
          • LENGTH(/)
          • LPAD(/)
          • LTRIM(/)
          • OCT(/)
          • REPEAT(/)
          • 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
          • DENSE_RANK(/)
          • RANK(/)
          • ROW_NUMBER(/)
        • JSON Functions
        • Other Functions
          • SLEEP
          • UUID(/)
        • System OPS Functions
          • CURRENT_ROLE_NAME(/)
          • CURRENT_ROLE(/)
          • CURRENT_USER_NAME(/)
          • CURRENT_USER(/)
          • PURGE_LOG(/)
    • System Paramaters
      • System Parameters Overview
      • Standalone Common Parameters Configuration
      • Distributed Common Parameters Configuration
    • MatrixOne Catalog
    • Privilege Control Types
    • Limitations
      • JDBC supported features list
      • Partitioning supported features list
    • MatrixOne Directory Structure
    • MatrixOne Tools
      • mo_ctl Tool
  • Troubleshooting
    • Slow Queries
    • Common statistic data query
    • Database statistics
    • Error Code
  • FAQs
    • Product FAQs
    • Deployment FAQs
    • SQL FAQs
  • Release Notes
    • Release Timeline
    • v1.1.0
    • v1.0.2
    • v1.0.1
    • v1.0.0
    • v1.0.0-rc2
    • v1.0.0-rc1
    • v0.8.0
    • 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
暂无相关搜索结果！

    本文档使用 BookStack 构建

    展开/收起文章目录

    分享，让知识传承更久远

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    • 普通下载
    • 下载码下载(免登录无限下载)
    你与大神的距离，只差一个APP
    APP下载
    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档
    温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
    下载码方式下载：免费、免登录、无限制。 免费获取下载码

    微信小程序阅读

    BookChat 微信小程序阅读
    您与他人的薪资差距，只差一个随时随地学习的小程序

    书签列表

      阅读记录

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