Introduction to Database DevOps
NineData's Database DevOps is a cloud-native SQL development toolset that offers comprehensive and efficient enterprise-grade functionalities along with high-level security support. It serves as a perfect replacement for similar products, empowering enterprises with enhanced core database management and maintenance capabilities.
Features Overview
Database DevOps offers robust features such as data asset management, data querying, SQL execution, data editing, data import/export, SQL approval workflows, SQL specification prechecks, approval processes, sensitive data protection, and more. These capabilities enable users to efficiently complete data management tasks across different environments, contributing to enterprise digital transformation.
- Powerful SQL Editor: Supports AI collaboration, intelligent SQL, comprehensive syntax highlighting, auto-completion, object type recognition, error prompts, and more.
- Comprehensive Access Control: Supports role-based access control (RBAC) for managing permissions at various organizational levels and provides customization for individual user permissions.
- All-encompassing Toolset: SQL tasks, development processes, data import/export, data tracking, SQL review, batch database changes, slow query analysis, DSQL federated queries, data archiving, and other capabilities provide end-to-end lifecycle management for databases, making database operations and maintenance more efficient and secure.
- SQL Development Standards: Defines enterprise SQL writing standards with over 200 rules, improving SQL quality, preventing slow SQL queries, and maintaining consistent coding styles to reduce potential errors and performance issues.
- Approval Workflows: Simplifies complex request, decision, and approval steps with standardized approval processes, enhancing overall efficiency while reducing errors and risks. Configurable workflows cater to various customization needs.
- SSO Single Sign-On: Centralizes identity management for enterprise members, streamlining user access and enhancing data security by reducing the risk of password leaks.
- Audit Logs: NineData offers centralized user activity logs and monitoring, allowing enterprises to easily audit user activities, track security events, and take necessary actions.
Version Description
NineData Database DevOps features provide multiple versions aimed at meeting the diverse needs of different user groups, offering a broader range of service options and functionalities.
- : Free for individual users, it provides powerful database management services including AI services, database development tools, visual table structure design, data import/export, etc.
- : Provides advanced database management and development tools for professional users to meet more complex requirements and business scenarios. In addition to all the features of the Personal Edition, the Professional Edition further provides enterprise collaboration features such as SQL specification pre-checks, approval processes, user management, role management, and permission control. Additionally, new features such as OnlineDML, data tracking, development pipeline, data archiving, slow SQL analysis, SQL auditing, and DSQL cross-database querying are also added.
- : Designed for enterprise users, this version offers a comprehensive set of powerful enterprise-level capabilities to meet the demands of enterprise users. Building upon the features of the professional edition, the enterprise edition provides enterprise-level capabilities such as audit logs, SSO (Single Sign-On) login, and more. Additionally, the enterprise edition offers flexible subscription plans to cater to diverse choices for different enterprise scales and needs.
Click to Expand Version Differences Overview
| Category | Function Name | Subfunction | Personal Edition | Professional Edition | Enterprise Edition |
|---|---|---|---|---|---|
| Database DevOps | SQL Console | AI Services | ✔️ | ✔️ | ✔️ |
| Database Development Tool | ✔️ | ✔️ | ✔️ | ||
| Execution History | ✔️ | ✔️ | ✔️ | ||
| Visual Result Set Editing | ✔️ | ✔️ | ✔️ | ||
| Visual Table Structure Design | ✔️ | ✔️ | ✔️ | ||
| SQL Standard Checking | ❌ | ✔️ | ✔️ | ||
| Sensitive Columns | ❌ | ✔️ | ✔️ | ||
| SQL Task | SQL Task Submission and Execution | ✔️ | ✔️ | ✔️ | |
| Task Approval Workflow | ❌ | ✔️ | ✔️ | ||
| Standard Checking | ❌ | ✔️ | ✔️ | ||
| Online DDL | ❌ | ✔️ | ✔️ | ||
| Online DML | ❌ | ✔️ | ✔️ | ||
| Development Pipeline | ❌ | ✔️ | ✔️ | ||
| Data Export | Export Task Submission and Execution | ✔️ | ✔️ | ✔️ | |
| Task Approval Workflow | ❌ | ✔️ | ✔️ | ||
| Data Import | Import Task Submission and Execution | ✔️ | ✔️ | ✔️ | |
| Task Approval Workflow | ❌ | ✔️ | ✔️ | ||
| DSQL | - | ❌ | ✔️ | ✔️ | |
| Slow Query | - | ❌ | ✔️ | ✔️ | |
| Batch Data Change in Multiple Instances | - | ❌ | ✔️ | ✔️ | |
| SQL Review | - | ❌ | ✔️ | ✔️ | |
| Data Archiving | - | ❌ | ✔️ | ✔️ | |
| Data Tracking | - | ❌ | ✔️ | ✔️ | |
| Backup and Restore | Data Backup | Logical Backup | ⭕ | ⭕ | ⭕ |
| Physical Backup | ⭕ | ⭕ | ⭕ | ||
| Data Restore | Restore Logical Backup Data | ⭕ | ⭕ | ⭕ | |
| Restore Physical Backup Data | ⭕ | ⭕ | ⭕ | ||
| Backup Set Data Query | - | ⭕ | ⭕ | ⭕ | |
| Data Replication | Same/Heterogeneous Data Replication | Structure Replication | ⭕ | ⭕ | ⭕ |
| Full Replication | ⭕ | ⭕ | ⭕ | ||
| Incremental Replication | ⭕ | ⭕ | ⭕ | ||
| Database Comparison | Data Comparison | - | ⭕ | ⭕ | ⭕ |
| Structure Comparison | - | ⭕ | ⭕ | ⭕ | |
| Operation and Monitoring | Configure Alert Receivers | - | ✔️ | ✔️ | ✔️ |
| Configure Alert Policies | - | ✔️ | ✔️ | ✔️ | |
| View Alert History | - | ✔️ | ✔️ | ✔️ | |
| Basic Services | Data Source Management | Add Self-built Data Source | ✔️ | ✔️ | ✔️ |
| Add Cloud Vendor Data Source | ✔️ | ✔️ | ✔️ | ||
| Special Data Sources (Oracle, DB2) | ❌ | ❌ | ✔️ | ||
| Environment Customization | ❌ | 5 | 1000 | ||
| Gateway Management | Create Gateway | ✔️ | ✔️ | ✔️ | |
| Create Proxy Gateway | ✔️ | ✔️ | ✔️ | ||
| Cloud Vendor Access Credentials | - | ✔️ | ✔️ | ✔️ | |
| Private Network Connection | - | ✔️ | ✔️ | ✔️ | |
| Manage Sensitive Data | - | ❌ | 3 Data Sources | Unlimited | |
| Standards and Processes | SQL Development Standards | ❌ | ✔️ | ✔️ | |
| Approval Processes | ❌ | ✔️ | ✔️ | ||
| Add New Standard | ❌ | ❌ | ✔️ | ||
| Add New Process | ❌ | ❌ | ✔️ | ||
| Account Management | Manage Organizations | Create Organization | ✔️ | ✔️ | ✔️ |
| Switch to Organization | ✔️ | ✔️ | ✔️ | ||
| View or Edit Organization Information | ❌ | ✔️ | ✔️ | ||
| Data Watermark | ❌ | ❌ | ✔️ | ||
| Single Sign-On (SSO) | ❌ | ❌ | ✔️ | ||
| Manage Users | Invite Users | ❌ | ✔️ | ✔️ | |
| Add New SSO User | ❌ | ❌ | ✔️ | ||
| Edit Users | ❌ | ✔️ | ✔️ | ||
| Remove Users | ❌ | ✔️ | ✔️ | ||
| Configure User Permissions | ❌ | Unlimited | Unlimited | ||
| Manage Roles | Add New Role | ❌ | ✔️ | ✔️ | |
| Edit Roles | ❌ | ✔️ | ✔️ | ||
| Delete Roles | ❌ | ✔️ | ✔️ | ||
| Bind Roles | ❌ | ✔️ | ✔️ | ||
| Configure Role Permissions | ❌ | Unlimited | Unlimited | ||
| Permission Application and Approval | Apply for Data Source Permissions | ❌ | ✔️ | ✔️ | |
| Apply for Database Permissions | ❌ | ✔️ | ✔️ | ||
| Apply for Sensitive Column Permissions | ❌ | ✔️ | ✔️ | ||
| My Permissions | Manage My Permissions | ❌ | ✔️ | ✔️ | |
| Audit Log | View Audit Log | ❌ | 90 Days | 3 Years | |
| Message Center | In-site Messages | Receive In-site Messages | ❌ | ✔️ | ✔️ |
| Subscription Management | Configure Message Delivery Preferences | ❌ | ✔️ | ✔️ | |
| AIGC | ChatDBA | - | ✔️ | ✔️ | ✔️ |
Product Advantages
| Advantages | Description |
|---|---|
| Multi-Data Source Cross-Platform Support |
|
| Convenient Operations | Data source development tools integrate AI services (natural language to SQL, SQL intelligent optimization, heterogeneous database language conversion, AI assistance, etc.), SQL intelligent suggestions, visual table structure design, visual result set editing, and more, simplifying tedious database management tasks and improving work efficiency. |
| Data Security and Privacy | Provides enterprise-level data security and privacy protection. Common data sources use TLS/SSL transport encryption by default to prevent data leaks. It also includes comprehensive audit logs, role and resource authorization systems, SSO single sign-on, and more to ensure data security, prevent data leaks, and unauthorized access. |
| Team Collaboration Capability | Features like specification prechecks and approval workflows enhance teamwork and improve data management standards, providing powerful collaboration capabilities to your team. |
| Rich Functionality | Zero-hassle database management service that allows database object management through a web browser. Supports features such as syntax completion, highlighting, automatic query window saving and recovery, and commonly used SQL saving, enabling developers to perform SQL operations efficiently and accurately. |
| Professional Technical Support | NineData provides timely technical support responses, resolving various technical challenges and questions encountered during the SQL development process. |
Typical Use Cases
| Edition | Use Cases | Description |
|---|---|---|
| Database DevOps Personal Edition | Individual Developers | Designed for individual developers, the free edition provides a user-friendly interface and support for multiple data sources, helping users get started quickly and manage data sources effortlessly. AI conversational queries assist novice developers in writing SQL, lowering the barrier to database use. |
| Scheduled SQL Execution Needs | For users with scheduled SQL execution requirements, SQL tasks can be submitted to execute specific SQL statements automatically at designated times. This is useful for tasks like regularly updating data, generating reports, or executing routine operations. | |
| Database DevOps Professional Edition | Small and Medium-sized Enterprise Projects | Small to medium-sized enterprise projects require collaboration between developers and database administrators for tasks like database design, complex query writing, and performance optimization. |
| Unified Database Management Platform | Enterprise projects often need access to and management of various databases in different environments and types. Database DevOps supports multiple cloud providers (Alibaba Cloud, Tencent Cloud, Huawei Cloud, Baidu Cloud, AWS, Azure, etc.) and various database products (MySQL, SQL Server, ClickHouse, and more). | |
| Secure Changes | For scenarios where SQL data changes submitted by enterprise members require pre-approval to ensure data input compliance and security. Additionally, SQL tasks are supported to manage user-submitted SQL changes, enhancing data management efficiency and security. | |
| Database DevOps Enterprise Edition | Large-scale Application Development | The Enterprise Edition is suitable for large-scale projects and application development, supporting high-performance queries and large-scale data processing with enterprise-level databases (Oracle, DB2). |
| Compliance Requirements and Security Event Tracing | The Enterprise Edition provides a 3-year audit log retention period, facilitating future audits and regulatory reviews, while also extending the timeliness of security event tracing for enterprises. | |
| Unlimited Sensitive Data Protection Across Data Sources | The Enterprise Edition offers unlimited protection for sensitive data across data sources, allowing you to extend sensitive data protection measures to all your business operations. | |
| Custom Specifications and Workflow Requirements | Large enterprises often have diverse business scenarios. The Enterprise Edition provides customizable SQL development standards and approval workflows to meet the diverse needs of various business teams. | |
| SSO Single Sign-On Requirements | The Enterprise Edition introduces SSO single sign-on functionality, supporting LDAP/OpenLDAP systems. This enables enterprises to easily synchronize enterprise personnel information with the NineData platform, simplifying member login methods, enhancing security, and improving efficiency. | |
| Application Integration | Provides console integration entry points, allowing the NineData console to be integrated into other tools, platforms, or applications to meet business customization needs. |