Overview

DMS supports unified management of multiple databases including relational databases such as MySQL, SQL Server, PostgreSQL, PolarDB, OceanBase, Oracle and etc., data warehouse related databases such as AnalyticDB, ClickHouse and other OLAP databases, and NoSQL databases such as MongoDB, Tair (Redis® OSS-Compatible) and others. It is a comprehensive data management service covering data management, structure management, user authorization, security auditing, trend analysis, and data tracing. DMS provides an easy-to-use portal for the centralized management of databases and servers to ensure more secure data, more efficient management and clearer data value.

Benefits

Secure Data Communication It helps hundreds of thousands of users manage a large number of database instances and provides security guarantees such as cloud account authorization and auditing. Support for Multiple Data Sources Unified support for multiple relational databases, OLAP databases, and NoSQL databases. Efficient R&D Provides a graphical interface for data management. Allows you to reuse SQL statements and save SQL windows. Visualized Data Analysis Supports data backtracking analysis for MySQL, PolarDB-MySQL database types for a specified period of time.

Features

Convenient Data Management Operations

Visualized viewing and editing of data and table structure through a GUI. Easy Table Management You can edit tables using an Excel-like interface. No SQL coding is required to do CRUD (create, retrieve, update, delete) operations or perform analytical tasks. Visualized Table Restructuring The GUI is used to design table structure fields, indexes, extension properties and other content visually, and to submit and execute operations in one click. Table structure comparison can easily realize the consistency comparison of table structures between the source database and the target database, and can obtain difference scripts. Table structure synchronization and database cloning allow you to easily compare table structure consistency between the source database and the target database. You can synchronize the table structure to the target database with one click. Frequently Used SQL Statements SQL statements frequently used can be saved to DMS for reuse when managing other databases. SQL Window Recovery The SQL window you are working on is automatically saved in real time. The page can be restored to the SQL window with SQL statements you are editing before if refreshing or closing by mistake , so that you can continue to edit your code. Data Import and Export Easy import and export of database-level and table-level data, supporting SQL scripts and CSV file formats.

Visualized Management of Metadata

Efficient management of metadata. Document Generation Easily generate all table structures in the database with one click, brow online, and export to Word, Excel, PDF and other file formats. Table Creation SQL and Table Structures Export Export table creation statements of relational and OLAP databases as needed, which can be used to quickly create or build new environments. Export table structure dictionary information of relational and OLAP databases to Excel files as needed for project internal archiving. Metadata Information Viewing & Retrieval Support databases and tables global searching and detailed attributes viewing such as table fields and indexes in the database.

Data Security (exclusive to the Security Collaboration control mode)

Secure data access for enterprises in all aspects. Unified Authorization Management DMS supports multi-dimensional on-demand authorization of databases, tables, and fields. Enterprise employees no longer have access to database by account and passwords. Controllable Data Retrieval Fully support on-demand control of the number of rows returned for each query, the total number of rows queried per day, the total number of queries per day, the timeout for single query, and the maximum table size scanned in a single query. Intelligent Data Desensitization Support field naming and table data scanning for data classification definition, combined with field permissions for limited access control of sensitive data. Support the configuration of different desensitization algorithms for fields, effectively shielding key information. Precise Operational Audits Accurate logging of people, time, modules, behaviors, all aspects of the operation, which can be audited by the administrator at any time. Customizable Security Rules Each database instance can be customized with different security specifications, feasible syntax types, and different operations corresponding to different approval processes.

Change Stability (exclusive to the Security Collaboration control mode)

Guarantees the smooth implementation of every change of the enterprise in an all-round way to avoid database performance fluctuation. Intelligent SQL Risk Audit Before the code is tested, SQL text and XML files can be submitted for review to identify SQL injection, non-indexed SQL, and SQL that does not meet the writing specifications, so as to avoid production failures caused by such SQL. Reliable Data and Structural Changes Perform full access risk identification and control before, during, and after changes to avoid database performance jitter caused by changes. Provide unlocked table change ability for large amounts of MySQL data and large table structures to avoid locking tables during changes that affect business. Accurate Data Rollback Fully support binlog parsing and batch export of rollback scripts for MySQL-type databases, which can help enterprises quickly repair abnormal data.

Efficient Research and Development (exclusive to the Security Collaboration control mode)

Comprehensively improve R&D efficiency of enterprises and reduce the costs. Efficient R & D Process Support the definition of various operation specifications and trial processes at the instance level to ensure data security without losing R & D efficiency. For example, the operations in the test environment is exempted from review while strict approval is required in the production environment. Global Database Management Support unified management of multiple sources of databases, including cloud databases, ECS self-built databases, local IDC self-built databases, competitor cloud databases, and competitor cloud server self-built databases. Fully support relational databases, OLAP databases, NoSQL databases and other types of databases. Convenient Cross-instance Query Real-time association analysis of heterogeneous online databases can be easily completed through a single SQL statement. Currently, MySQL, AnalyticDB for MySQL, PolarDB, SQL Server, PostgreSQL, and Tair (Redis® OSS-Compatible) are supported. Easy-to-use Data Analysis Support the scheduling and periodic scheduling management of SQL task nodes to facilitate the deployment and use of periodic tasks. Typical scenarios are data archiving, data migration to analytical databases, the periodic analysis in the analytical database generating reports such as daily, weekly and monthly reports and writing back to the online database to provide online services, etc.