Overview

Data modeling is a key step in database design. It involves analyzing and abstracting real-world data and the relationships between it. This process reveals the internal connections between data and formalizes them as a data model, providing the foundation for an information system's database structure. NocoBase is a data-model-driven platform with the following capabilities.

Connect data from many sources

NocoBase data sources can be common databases, API (SDK) platforms, and files.

NocoBase provides the Data source management plugin to manage data sources and their collections. It provides the management interface for all data sources, but does not connect a data source by itself; use it with the corresponding data-source plugins. Supported data sources include:

• Main data source: The NocoBase main database. It supports relational databases such as MySQL, PostgreSQL, and MariaDB
• KingbaseES: Uses KingbaseES as a data source. It can be used as a main or external database
• External MySQL: Uses an external MySQL database as a data source
• External MariaDB: Uses an external MariaDB database as a data source
• External PostgreSQL: Uses an external PostgreSQL database as a data source
• External MSSQL: Uses an external MSSQL (SQL Server) database as a data source
• External Oracle: Uses an external Oracle database as a data source

Data-modeling tools

A simple collection management interface: Create different models (collections) or connect existing models (collections).

An ER-diagram-like visual interface: Extract entities and their relationships from user and business needs. It provides an intuitive way to describe data models so that you can understand the main data entities in the system and their connections more clearly.

Create different collection types

Collection	Description
General collection	Includes common system fields.
Calendar collection	Creates event collections for calendar-related data.
Comment collection	Stores comments or feedback about data.
Tree collection	A hierarchical collection that currently supports the adjacency-list model only.
File collection	Manages file storage.
SQL collection	Does not create an actual database table. It presents SQL query results in a structured way.
Connect a database view	Connects an existing database view.
Expression collection	Used for dynamic expression scenarios in workflows.
Connect external data	Connects remote data tables through database FDW technology.

For more information, see Collections.

Rich field types

For more information, see Fields.