Skip to main content


This article introduces the terminology encountered during the use of NineData products.


  • AI Intelligence: The natural language query feature integrated into the SQL window allows for quick conversion of short natural language expressions into SQL queries.
  • Approval Process: Used to configure the workflow for approval within an organization, enabling task automation.
  • Audit Logs: Records the "who," "when," "what," and "object" of operations performed in the console. By viewing audit logs, system administrators can track the history of changes made and analyze security events.


  • Cloud vendor access credentials: The cloud host needs to use the Access Key (AK) and Access Key Secret (SK) encryption methods to verify the identity of the sender of a request. AK is used to identify the user, SK is the key used by the user to encrypt the authentication string and the cloud vendor used to verify the authentication string, and the SK must be kept secret.


  • Data Source: In Database DevOps, a data source refers to database instance information, including the database connection string, login authentication information, etc.
  • Dedicated cluster: A service cluster composed of a set of servers provided by the user. The service cluster is mainly responsible for requesting access to the database in the SQL console and SQL tasks. At the same time, it is responsible for performing replication, comparison, backup and restore tasks.


  • Gateway: A database connection service that enables private network access to remote databases. Through the gateway, third-party cloud or local databases can be securely and cost-effectively connected to the NineData platform.


  • Metadata: Metadata is an integral part of the database, which includes database name, database character set, table name, table size, table record row count, table character set, table index, table remarks, field name, field type, field precision, Field remarks, etc., these information are partly saved in the system table of the database. For example, MySQL metadata information is stored inside information_schema tables. The size of the table and the number of rows in the table may not be very accurate, so it is only an order of magnitude reference.


  • Private network connection: Private network connection allows users to access cloud vendor services, third-party services, or self-managed services through the private network in their own VPC. These services are all deployed in the service provider's VPC.
  • Personal Mode: One of the account modes in NineData system. In personal mode, you can seamlessly use the four major module functionalities provided by NineData. Personal mode is suitable for individual developers who need to perform tasks such as database backup, restore, synchronization, comparison, and daily development using the SQL window.
  • Private Network Connection: Private network connection allows users to access cloud service providers, third-party services, or their own published services within their own VPC via a private network. These services are deployed within the service provider's VPC.


  • Regular Account: Users registered through conventional means (phone number or email). Regular accounts can log in to NineData using conventional and SSO methods, supporting all modes (personal mode, organization mode, SSO organization mode). Regular account users are responsible for managing and maintaining the security of their own accounts.


  • SQL Task: Refers to tasks that involve making changes to a database, primarily including DDL (Data Definition Language) and DML (Data Manipulation Language) statements. Due to the nature of modifying a database, SQL tasks require comprehensive security control throughout the entire lifecycle, including submission, approval, execution, and rollback.
  • Sensitive Data: Important data assets within a data source. When marked as sensitive data, it is displayed as asterisks (*) to users without viewing permissions, ensuring the security of important data.
  • SQL Development Standards: Behavioral standards during Database DevOps. User's SQL statements are automatically evaluated for compliance with the standards, and only SQL statements that meet the execution requirements will be approved.
  • SSO: SSO (Single Sign-On) is an authentication technology that allows users to access multiple applications using a single set of credentials, eliminating the need to enter usernames and passwords each time. It reduces the risk of identity information being compromised and improves user experience and convenience.
  • SSO Account: Users created by the system administrator of an SSO organization. They can only log in to NineData using the SSO method. After logging in, they directly enter the corresponding SSO organization and cannot access personal mode or non-SSO organization mode. Since the account information of SSO users is managed by the Identity Provider (IdP), SSO users have higher security.
  • SSO Organization Mode: Identical to organization mode except for the login method.