API interface system based on SQL and management method thereof

Abstract

The invention discloses an SQL-based API interface system, which comprises an interface development module, an interface management module, an interface authentication module and an interface monitoring module, and is characterized in that the output end of the interface development module is connected with the input end of the interface management module, and the output end of the interface management module is connected with the input end of the interface authentication module; the output end of the interface authentication module is connected with the input end of the interface monitoring module, and the output end of the interface monitoring module is connected with the input end of the interface management module; the management method comprises the steps of interface development, interface management, interface authentication and interface monitoring. The method has the advantages that various existing data sources are supported, the application scene is expanded, the interface safety is high, and the whole life cycle of the interface is managed.

Description

technical field [0001] The invention relates to the technical field of computer interfaces, in particular to an SQL-based API interface system and a management method thereof. Background technique [0002] API (Application Programming Interface, Application Programming Interface) is some predefined interfaces (such as functions, HTTP interfaces), or refers to the agreement between different components of the software system, which is used to provide applications and developers based on a certain software or hardware. Group routines without having to access the source code, or understand the details of the inner workings. In the data development process, the data is often shared in the form of an API (Application Programming Interface) interface. Usually developing an API interface requires programmers who are familiar with programming languages ​​such as JAVA to read database table data through JDBC and other database drivers, process the data, and return data results in a ...

AI Technical Summary

Problems solved by technology

However, this development method has the following technical shortcomings: 1. For existing applications, the API is defined from the creation of the application, and the processing is repeated, which reduces the processing efficiency; 2. The data source supported by the API can only be a fixed one created by oneself. For big data development, joint query of multiple heterogeneous database data is often required, and the application scenarios are limited; 3. The security control precision and flexibility of the interface are not enough; 4. The interface only goes online regardless of offline The state has not changed, and there is no full life cycle management of the interface

Images