Introduction to NineData Database DevOps Professional Edition
NineData Database DevOps Professional Edition provides a range of powerful features for small and medium-sized enterprise projects and development teams to support daily development and collaborative requirements, providing support for your projects and business.
Key Features
- Database Change SQL Review: Simply configure SQL development standards and approval processes in advance. Automated process standards will ensure that SQL changes undergo proper review and authorization, intercepting SQL statements that do not conform to standards, reducing the risk of introducing errors.
- Unified Database Management Platform: NineData Database DevOps offers a unified database management platform for you and your team. Regardless of the database you use, you can perform operations in the same interface, eliminating the need to switch tools frequently and saving time learning and adapting to different tools.
- Access Control: Simplify the permission request process, allowing users to easily apply for the permissions they need, effectively avoiding unnecessary permission assignments and reducing security risks. It also supports role-based permission allocation, allowing appropriate permissions to be assigned based on user roles, ensuring that user data access and changes correspond to their responsibilities.
- OnlineDDL Support: Provides NineData's proprietary lock-free table structure change functionality, supporting online DDL changes scenarios that MySQL's native OnlineDDL tool may struggle with. No downtime is required, ensuring business continuity.
- Audit Logs: Provides a 3-month audit log retention period to help you better trace and audit security events, meeting compliance requirements.
- Sensitive Data Protection: Offers sensitive data protection for up to 3 data sources, preventing data leaks and unauthorized access, enhancing data security.
- Data Generation：NineData supports the automatic generation of random data in the database that conforms to specific business scenarios, simulating the actual production environment data situation, and helping users perform functional testing, stress testing, and other verification work without using real data.
- DSQL: NineData DSQL is a way to perform cross-database queries across multiple heterogeneous or homogeneous database systems. You can access multiple databases in a single query, retrieve useful information scattered across different databases, and aggregate this information into a single query result, making it easy to query data across multiple databases, multiple data sources, and even multiple heterogeneous data sources.
- Slow Query Analysis: NineData's slow query analysis is a database optimization tool designed to help developers and database administrators identify queries that impact database performance. It provides optimization suggestions aimed at improving the efficiency and stability of the database.
- SQL Auditing: NineData SQL auditing is used to perform security and efficiency audits on SQL statements before application code is released. It ensures that the SQL statements being released comply with standards and recommends appropriate indexes for SQL statements without indexes, thereby improving the efficiency and accuracy of code releases.
- OnlineDDL Support: Provides NineData's proprietary lock-free table structure change functionality, supporting online DDL change scenarios that MySQL's native OnlineDDL tool may struggle with. No downtime is required, ensuring business continuity.
- Batch Database Changes: NineData's batch database changes feature supports unified modifications and updates to database structures or data. It can simultaneously cover multiple data sources, databases, and tables, ensuring that data sources in distributed environments can complete the same changes at the same time.
- Data Archiving: NineData supports data archiving functionality, allowing you to archive unused data to another database for backup, freeing up storage space in the business database to optimize performance. This feature supports both one-time execution and periodic automatic execution.
- Development Pipeline: The development Pipeline functionality enables multi-environment development process management, facilitating smooth progress of development in each environment, ensuring that all necessary validations, changes, and approvals are completed before code is deployed to the production environment.
- Data Tracking: The NineData data tracking feature is used to track developer's changes or deletions of data or object structures in the database, ensuring data integrity for the business.
Use Cases
- Small and Medium-Sized Enterprise Projects: Small to medium-sized enterprise projects require collaboration between developers and database administrators for database design, complex query writing, and performance optimization.
- Multi-Data Source Management Requirements: In everyday business system development, there is a need to access and manage databases of various environments and types. Database DevOps supports multiple cloud providers such as Alibaba Cloud, Tencent Cloud, Huawei Cloud, Baidu Cloud, AWS, Azure, and various database products like MySQL, SQL Server, ClickHouse, and more.
- Secure Changes: Scenarios that require pre-approval of SQL data changes submitted by enterprise members to ensure the correctness and security of SQL inputs. It also supports managing SQL changes submitted by users through SQL task management, making enterprise data management more secure and efficient.
Professional Edition Feature Overview
| Category | Feature Name | Subfeatures |
|---|---|---|
| Database DevOps | SQL Console | AI Services |
| Database Development Tools | ||
| Execution History | ||
| Visual Result Set Editing | ||
| Visual Table Structure Design | ||
| SQL Specification Pre-check | ||
| Sensitive Columns | ||
| SQL Task | SQL Task Submission and Execution | |
| Task Approval Workflow | ||
| Specification Pre-check | ||
| OnlineDDL | ||
| OnlineDML | ||
| Development Pipeline | ||
| Data Export | Data Export Task Submission and Execution | |
| Task Approval Workflow | ||
| Data Import | Data Import Task Submission and Execution | |
| Task Approval Workflow | ||
| Data Generation | - | |
| DSQL | - | |
| Slow Query | - | |
| SQL Review | - | |
| Batch Data Change in Multiple instances | - | |
| Data Archiving | - | |
| Data Tracking | - | |
| Operation and Monitoring | Configure Alarm Receivers | - |
| Configure Alarm Policies | - | |
| View Alarm History | - | |
| Basic Services | Data Source Management | Add Self-built Data Sources |
| Add Cloud Vendor Data Sources | ||
| Environment Customization | ||
| Gateway Management | Create Gateway | |
| Create Proxy Gateway | ||
| Cloud Vendor Access Credentials | - | |
| Private Network Connection | - | |
| Manage Sensitive Data | - | |
| Standards and Processes | SQL Development Standards | |
| Approval Workflows | ||
| Account Management | Manage Organizations | Create Organization |
| Switch to Organization | ||
| View or Edit Organization Information | ||
| Manage Users | Invite Users | |
| Edit Users | ||
| Remove Users | ||
| Configure User Permissions | ||
| Manage Roles | Add Roles | |
| Edit Roles | ||
| Delete Roles | ||
| Bind Roles | ||
| Configure Role Permissions | ||
| Permission Application and Approval | Apply for Data Source Permissions | |
| Apply for Database Permissions | ||
| Apply for Sensitive Column Permissions | ||
| My Permissions | Manage My Permissions | |
| Audit Logs | View Audit Logs | |
| Message Center | In-Site Messages | Receive In-Site Messages |
| Subscription Management | Configure Message Receipt Methods | |
| AIGC | Intelligent Question and Answer Robot ChatDBA | - |