Skip to content

Database Pattern Design Overview

This article provides a brief overview of the database schema of MatrixOne Intelligence. This overview mainly introduces the terms related to the MatrixOne Intelligence database and subsequent data reading and writing examples.

Key Terms - Database Patterns

Database Schema (Schema): Thedatabase schema mentioned in this article is equivalent to logical object database, and is the same as MySQL, without distinction.

Database

MatrixOne Intelligence Database or MatrixOne Intelligence Database, is a collection of tables.

You can use SHOW DATABASES; to view the default databases included in MatrixOne Intelligence. You can also create a new database using CREATE DATABASE database_name;.

Table

MatrixOne Intelligence refers to a table or Table, a database that belongs to MatrixOne Intelligence.

The table contains rows of data. Each value in each row of data belongs to a specific column. Each column only allows data values ​​of a single data type.

Index

An index is a data structure that is used to quickly find data in a database table. It can be regarded as a directory that contains pointers to rows of data in a table, allowing queries to locate data that meets certain conditions more quickly.

Commonly used index types in databases include primary key index, secondary index, etc. Among them, a unique index is used to ensure the uniqueness of a specific column or column combination, a normal index is used to improve query performance, and a full-text index is used to conduct full-text search in text data.

There are two common types of indexes, namely:

  • Primary Key: Primary Key Index, that is, the index that identifies the primary key column, which is used to uniquely identify each row of data in the table.
  • Secondary Index: Secondary Index, which is an index identified on non-primary keys. Secondary Index is also called non-clustered index, used to improve query performance and accelerate data retrieval.

Other objects

MatrixOne Intelligence supports some objects at the same level as table:

  • View: A view is a virtual table whose structure is defined by the SELECT statement when creating the view. MatrixOne Intelligence does not support materialized views.
  • Temporary table: Temporary tables are tables whose data is not persisted.

Access Control

MatrixOne Intelligence supports user- or role-based access control. You can grant users permission to view, modify, or delete data objects and data patterns through roles or direct points to users.

For more information, see Access Control in MatrixOne Intelligence.