Data Management:Overview

Data service flowchart

Design philosophy

• The data service feature is a module of DMS. You can use this feature to create API operations and access the data that is managed by DMS. You can also apply the security control features that are used for SQL execution in the SQLConsole, such as permission control and data de-identification, to these API operations.
• The data service feature is developed based on a serverless architecture. This feature frees you from the concern about the infrastructure of the runtime environment, such as servers and networks. You need to focus only on how to create API operations and define data query logic. This avoids operations and maintenance (O&M) overheads that are generated by using traditional architectures.
• The data service feature is fully integrated with API Gateway. You can use this feature to publish API operations to API Gateway. This way, you can use all the features that are provided by API Gateway, such as API permission control, IP address-based access control, throttling, metering and billing, and SDKs. Before you use the data service feature, you must activate API Gateway.

Scenarios

• Minimize data exposure: Assume that you need to export data to external environments. In this case, API operations can be called to export the data of a specific row or column to external environments. To export the data of the specific row, specify filter conditions in SQL statements. To export the data of the specific column, specify the fields that allow queries. Compared with data export of a whole table, this minimizes data exposure and ensures data security.
• Connect visualization tools to databases: API operations can be called to connect most of the visualization tools to databases. You can call an API operation to connect a visualization tool to your database, instead of using a username and a password. This method is easy to implement and avoids account exposure.
• Sell API operations in the Alibaba Cloud Marketplace: If you want to provide paid or free data for other users, publish an API operation to the Alibaba Cloud Marketplace.
• Provide processed data for applications: After data is processed and summarized by using the data warehouse development feature of DMS, API operations can be created and provided for applications to read the processed data from DMS to meet business needs. To modify the logic of data reading, you need only to modify the query logic of the required API operation without the need to republish the application.