Skip to main content
This feature is exclusive to Premium Data reports. The Isolation Database is an “extended database” designed specifically for customers who have enabled YiDA’s Premium Data Workbench (Premium Data analysis capability). Its purpose is to synchronize the form physical column lists and their instance data in real time from the original dedicated database to this Isolation Database for apps under an organization that have been upgraded to the Isolation Database (apps must have dedicated storage and physical column capabilities enabled beforehand). It then serves as the primary data source for data queries and analysis in that App Space, reducing query pressure on the original dedicated database and easing the performance impact on YiDA’s original dedicated storage business.

​
Application Scenarios

The Data Isolation Database suits the following situations:
  • Premium Data analysis needs: When an organization needs to run complex queries and data analysis, the Isolation Database improves efficiency and performance.
  • Large-scale data processing: For apps with large data volumes, the Isolation Database effectively distributes query pressure and prevents overloading the original database.
  • Optimized user experience: By offloading query and analysis tasks to the Isolation Database, users get a faster response speed when accessing apps in the original database.

​
Feature Description

  1. The Isolation Database is currently exclusive to customers who have enabled the Premium Data Workbench (Premium Data analysis capability).
  2. Apps can be upgraded with Isolation Database capabilities only after the Isolation Database configuration is completed under the organization’s dedicated storage.
  3. Upgrading an app to Isolation Database capabilities is similar to physical columns; both require migration of existing data, which takes some time.
  4. There are 3 places where an app can be upgraded to the Isolation Database:
(1) Select the Isolation Database when creating an app.(2) Use the upgrade option under App Settings.(3) When entering the Premium Data Workbench for the first time, tips for upgrading to the Isolation Database will appear.
  1. Organization Isolation Databases currently support PostgreSQL and MySQL.

​
FAQ

  • Q: Data migration time — How long does it take to upgrade an app to the Isolation Database? A: Upgrading to the Isolation Database involves migration of existing data, and the exact time depends on the data volume. Plan ahead and reserve sufficient time for the migration.
  • Q: Database instance switching — How do I modify the database connection string, type, or name? A: You can modify this information through the automatic migration switching feature. Note that each switch triggers a migration of existing data, so assess the required time in advance.
  • Q: Username and password modification — How do I modify the database username and password? A: Direct modification of the username and password is not currently supported. If needed, create a new database name in the database instance, modify only the database name and account password, and then trigger an automatic migration switch. If modification is absolutely necessary, contact YiDA technical support.
  • Q: Performance impact — Does the Isolation Database affect system performance? A: The Isolation Database is mainly intended to reduce query pressure on the original dedicated database and, in theory, will not negatively impact overall system performance. On the contrary, it helps improve system stability and response speed.