Skip to main content

Dedicated Database

What is a Dedicated Database​

A dedicated database is a database instance that isolates all worksheet data within a specific application from other applications. It operates independently from the system default database and is suitable for scenarios requiring data isolation.

A dedicated database reduces resource contention, allowing applications to exclusively use database resources and improving the response time of query and update operations.

Key benefits:

  • Data isolation: Provides independent physical storage for each application
  • Exclusive resources: Applications use dedicated compute resources, reducing contention in the system default database and ensuring overall platform stability
  • Performance improvement: Dedicated resources improve the response time of query and update operations, especially for large datasets or high-frequency operations

Use cases:

  • Data isolation requirements: Provides fully isolated storage environments for applications with strict data separation needs
  • High-load applications: Suitable for applications with frequent query and update operations, ensuring stability under high concurrency
  • Performance-sensitive scenarios: Improves performance for applications requiring fast query and update responses

Deployment Architecture​

As shown above, worksheets in app1, app2, and app3 use a shared database, while worksheets in app4 use a dedicated database. The dedicated database cluster is deployed on separate server resources.

Using a Dedicated Database​

Create a Dedicated Database Instance​

Creating a dedicated database instance requires a separate license key. Before creation, a new MongoDB instance must be deployed (either a standalone instance or a replica set).

Go to Dedicated Resources > Database to create a dedicated database instance for the organization. Enter the required configuration details and perform a connection test. Once the connection is verified, click Create to save.

Store Application Data in a Dedicated Database​

When creating an application, you can choose to store all worksheet data in a dedicated database instance by selecting one of the following options: create from scratch, import from Excel, or import data.

By default, applications use the system default database. To use a dedicated database, manually select the corresponding database instance during creation.