Application Data Storage Architecture Description

The application data of Mingdao includes modules such as worksheets, workflows, roles and permissions and so on. For application data storage, Mingdao chooses MongoDB, relying on its flexible storage structure (Bson), which greatly facilitates storage and retrieval performance.

The data of each module is stored in a separate database (it can also be deployed as a separate database cluster for each database, View more details in Multi-Cluster Storage). In addition to the separate database, the application structure data of the same module (non-worksheet) are logically isolated (based on the application id). Each worksheet in the application is a corresponding database table at the physical level. Based on the visual field definition capability of the worksheet, drag and drop to dynamically adjust the database table structure. At the same time, the physical isolation of each table makes it more convenient to add necessary field indexes to improve the retrieval performance.