• English

      • Overview

      Data modeling is a key part of database design. It analyzes and abstracts real-world data and the relationships between it, then describes those relationships as a data model for an information system. NocoBase is data-model driven and provides the following capabilities.

      Connect data from different sources

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

      Data source types

      NocoBase provides the Data Source Manager to manage data sources and their collections. The manager provides the interface for managing all data sources; it does not connect to a source by itself. Use it together with the applicable data-source plugin.

      Supported data sources include:

      Data source management

      Data-modeling tools

      A simple collection management interface lets you create different data models (collections) or connect existing ones.

      Collection management

      An ER-diagram-like visual interface helps extract entities and their relationships from user and business requirements. It gives you a direct way to describe the data model and understand the main data entities in a system and how they are connected.

      Visual data modeling

      Create different collection types

      CollectionDescription
      General collectionIncludes commonly used system fields.
      Calendar collectionCreates event collections for calendars.
      Comment collectionStores comments or feedback on data.
      Tree collectionStores hierarchical data. Currently it supports the adjacency-list design.
      File collectionManages file storage.
      Connect a database viewConnects an existing database view.
      SQL collectionPresents an SQL query result in a structured form; it is not a real database table.
      Connect external dataConnects remote data tables through database FDW technology.

      Collection types

      For more information, see Collections.

      Rich field types

      NocoBase provides a range of field types for different business data and interface requirements.

      Field types

      For more information, see Collection fields.