Service system for data query

Abstract

The invention discloses a service system for data query, and particularly relates to the technical field of data query, so that the same service can support database query of various database type data sources of different types, and meanwhile, the service is not stopped, namely, SQL query statements can be dynamically modified and newly added in a service execution process; the flexibility of the data query service and the extension support for various database types are greatly enhanced; besides, by comprehensively considering the stability of network signals, the validity of timestamps and the integrity of data transmission, the system can more accurately judge the legality of Token, and the risk of misjudgment caused by a single factor is reduced. Besides, through setting and dynamic adjustment of illegal coefficients, an authentication mechanism can be flexibly optimized according to actual conditions, illegal access and hostile attacks can be effectively prevented in various network environments, and thus reliability and accuracy of data query services are guaranteed.

Description

Technical Field

[0001] The present invention relates to the technical field of data query, and in particular to a service system for data query. Background Art

[0002] A data query service system refers to a software system that can obtain data from various data sources, query and analyze it, and provide the results to users or other systems. The system usually supports multiple database types and can interact with these databases through a unified interface and standardized query language (such as SQL). For example, suppose a data query service system needs to provide a company with data query functions that support multiple database types. At the same time, the system also needs to have the ability to dynamically modify and add SQL query statements during the service execution process. The specific description is as follows: The core goal of the data query service system design is to support database queries for multiple different types of database type data sources. This means that the system can perform data queries regardless of whether it is a relational database (such as MySQL, PostgreSQL) or a non-relational database (such as MongoDB, Cassandra). In addition, the system also needs to have a high degree of flexibility, that is, during the service execution process, it can dynamically modify and add SQL query statements without stopping the service. In this way, not only the flexibility of the system is improved, but also the expansion support for multiple database types is enhanced.

[0003] However, in general data query service systems, a service can often only support database queries for one different type of database type data source, and cannot adapt to the needs of multiple database types. In addition, it cannot support dynamic modification and addition of SQL query statements during service execution, resulting in low flexibility of data query services. Summary of the invention

[0004] The purpose of the present invention is to solve the problem and to propose a service system for data query.

[0005] The present invention provides a service system for data query, the system comprising:

[0006] Information configuration module: used to configure the information required for database connection and configure SQL statements according to the database;

[0007] Database connection module: used to read the configured database information when the system starts, and create a connection pool based on the read database information;

[0008] Execution module: After receiving the data query request, it finds the corresponding database connection pool and SQL statement according to the SQL unique identifier of the request, performs paging query, and returns the query result set and paging result information;

[0009] Authentication and authorization module: used to authenticate the identity of each query request received, and determine the accuracy of the returned query information based on the verification status information.

[0010] Optionally, the database information is configured to provide relevant information for creating a database connection used when executing SQL statements; the relevant information includes a database address, an account, a password, and a name for the database;

[0011] Configure the SQL statement information to be executed in the specified database table, configure the database information primary key, and configure the cache properties of the query result of the statement - whether to cache, and if so, configure the cache cycle.

[0012] Optionally, the database connection module is used to:

[0013] When the system starts, it reads the database configuration information and dynamically creates a database connection pool based on the relevant information - dynamically loads the relevant database driver according to the configured database type, creates a database connection based on the connection parameters of the data, and uses mainstream connection pool technology to create a connection pool to ensure query response efficiency in the case of a large number of accesses.

[0014] Optionally, the execution module is applied to:

[0015] When a data query request is received, the corresponding database connection pool and the corresponding statement are found according to the SQL unique identifier of the request, and the type of database is determined. The paging query is encapsulated according to the paging information in the query parameters, and the executed query data result set and paging result information are returned to the requester.

[0016] Optionally, the authentication and authorization module is applied to:

[0017] Every time a query request is received, the identity of the requester will be verified. The requester must bring a Token each time a request is made. Before the request is made, the Token first calls the authentication interface and passes the relevant verification status information. The authentication interface returns after authentication based on the verification status information. After the query service verifies the legitimacy of the Token, if it determines that the Token is valid, it executes the data query service and returns accurate information, otherwise it returns an error message.

[0018] Optionally, the authentication and authorization module is also used for:

[0019] The verification status information includes a network signal connection instability coefficient, a timestamp invalidity coefficient, and a data incompleteness coefficient;

[0020] The calculation method of the network signal connection instability coefficient is:

[0021] Get the actual network signal value corresponding to different times in a fixed time interval each time a query request is received, and mark the actual network signal value as H 实 k , k represents the number of moments, k = 1, 2, 3, 4, ..., u, u is a positive integer;

[0022] Calculate the actual network signal value at different times within a fixed time interval and mark it as H 实 k The standard deviation is calibrated as R, and the calculation formula of the standard deviation R is:

[0023]

[0024] in, is the average value of the actual network signal value corresponding to different times within a fixed time interval, and the expression obtained is:

[0025] By calculating the average value H of the actual network signal value corresponding to different times within a fixed time interval 实 k The standard deviation R of the network signal connection instability coefficient Faz is obtained, and the expression obtained is: Faz=R.

[0026] Optionally, the authentication and authorization module is also used for:

[0027] The calculation method of the timestamp validity coefficient is:

[0028] Get the corresponding Token each time a query request is received, and mark the Token as Y l , l represents the number of Tokens, l = 1, 2, 3, 4, ..., h, h is the total number of Tokens and is a positive integer;

[0029] Mark invalid tokens as Y d , d represents the number of invalid tokens, d = 1, 2, 3, 4, ..., r, r is the number of invalid tokens;

[0030] According to Y l and Y d The timestamp invalid coefficient Dlx is obtained, and the calculation formula is: Dlx=ln(r / h+1).

[0031] Optionally, the authentication and authorization module is also used for:

[0032] The calculation method of the data incompleteness coefficient is:

[0033] Get the actual received data corresponding to each query request received, and mark the received data as M 接 e , e represents the number of data actually received, e=1, 2, 3, 4, ..., p, p is an integer;

[0034] Get the actual uploaded data corresponding to each query request received, and mark the uploaded data as M 上 c , c represents the number of data actually uploaded, c = 1, 2, 3, 4, ..., s, s is a positive integer;

[0035] According to M 接 e and M 上 c The data incompleteness coefficient Ekx is obtained, and the calculation formula is: Ekx=(sp).

[0036] Optionally, the authentication and authorization module is also used for:

[0037] The illegal coefficient can be obtained based on the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient, which can be achieved through the following formula:

[0038]

[0039] Where Qkgd is the illegal coefficient, Faz, Dlx and Ekx represent the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient respectively, a1, a2 and a3 are the proportional coefficients of the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient respectively, and a1, a2 and a3 are all greater than 0;

[0040] Compare the illegal coefficient with the illegal coefficient threshold. When the illegal coefficient is not less than the preset illegal coefficient threshold, it means that the legality of the Token authenticated by the authentication interface according to the verification status information is invalid. At this time, if the Token is judged to be invalid, the data query service is executed and an error message is returned.

[0041] When the illegal coefficient is less than the preset illegal coefficient threshold, it means that the authentication interface is valid according to the verification status information. If the Token is judged to be valid, the data query service is executed and the correct information is returned.

[0042] Beneficial effects of the present invention:

[0043] The present invention proposes a service system for data query, which enables the same service to support database query of multiple different types of database data sources, and supports dynamic modification and addition of SQL query statements without stopping the service, that is, during the service execution process, which greatly enhances the flexibility of data query services and the expansion support for multiple database types; in addition, by comprehensively considering the stability of network signals, the validity of timestamps and the integrity of data transmission, the system can more accurately judge the legitimacy of tokens and reduce the risk of misjudgment caused by a single factor. In addition, the setting and dynamic adjustment of illegal coefficients can flexibly optimize the authentication mechanism according to actual conditions, ensuring that illegal access and malicious attacks can be effectively prevented in various network environments, thereby ensuring the reliability and accuracy of data query services. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] The present invention will be further described below in conjunction with the accompanying drawings.

[0045] Figure 1 A framework diagram of a service system for data query provided by the present invention. DETAILED DESCRIPTION

[0046] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0047] Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in the field without making any creative work shall fall within the scope of protection of the present invention.

[0048] The embodiment of the present invention provides a service system for data query. Figure 1 , Figure 1 A framework diagram of a service system for data query provided by an embodiment of the present invention. The system includes:

[0049] Information configuration module: used to configure the information required for database connection and configure SQL statements according to the database;

[0050] Database connection module: used to read the configured database information when the system starts, and create a connection pool based on the read database information;

[0051] Execution module: After receiving the data query request, it finds the corresponding database connection pool and SQL statement according to the SQL unique identifier of the request, performs paging query, and returns the query result set and paging result information;

[0052] Authentication and authorization module: used to authenticate the identity of each query request received, and determine the accuracy of the returned query information based on the verification status information.

[0053] In one embodiment, the information configuration module is used to:

[0054] Configure the database information, which is used to provide relevant information for creating a database connection when executing SQL statements; the relevant information includes the database address, account, password, and name;

[0055] Configure the SQL statement information to be executed in the specified database table, configure the database information primary key, and configure the cache properties of the query result of the statement - whether to cache, and if so, configure the cache cycle.

[0056] It should be noted that the SQL statements must be written in accordance with the requirements of this system on the basis of complying with relevant database specifications to ensure that they can be executed normally by the system. The primary key of the database information is the ID in the first step configuration table. If caching is used, the unit of the cache cycle can be minutes or other units, without specific limitations.

[0057] In one embodiment, the database connection module is used to:

[0058] When the system starts, it reads the database configuration information and dynamically creates a database connection pool based on the relevant information - dynamically loads the relevant database driver according to the configured database type, creates a database connection based on the connection parameters of the data, and uses mainstream connection pool technology to create a connection pool to ensure query response efficiency in the case of a large number of accesses.

[0059] In one embodiment, the execution module is used to:

[0060] When a data query request is received, the corresponding database connection pool and the corresponding statement are found according to the SQL unique identifier of the request, and the type of database is determined. The paging query is encapsulated according to the paging information in the query parameters, and the executed query data result set and paging result information are returned to the requester.

[0061] In one embodiment, the authentication and authorization module is applied to:

[0062] Every time a query request is received, the identity of the requester will be verified. The requester must bring a Token each time a request is made. Before the request is made, the Token first calls the authentication interface and passes the relevant verification status information. The authentication interface returns after authentication based on the verification status information. After the query service verifies the legitimacy of the Token, if it determines that the Token is valid, it executes the data query service and returns accurate information, otherwise it returns an error message.

[0063] It should be noted that this system is developed based on Java language, with built-in support for multiple database drivers such as Mysql, SQLServer, Oracle, etc., which enables dynamic configuration of database query statements, supports statistics on the number of data query result sets and returns detailed result set data for paging details, and the number of pages per page can also be dynamically specified. In order to prevent illegal access and malicious attacks, this system also supports authentication of the legitimacy of access requests, and the authentication encryption algorithm is secondary encryption based on MD5.

[0064] The main system features are as follows:

[0065] 1. Support for multiple database drivers.

[0066] 2. Based on the storage capacity of the database table, it supports dynamic configuration of database query statements.

[0067] 3. Query statements can be configured with various forms of query conditions according to the rules of this system, including but not limited to: =, >, <, in, >=, <=, and support dynamic query condition parameters, that is, specify the query condition value during execution.

[0068] 4. Pagination processing of query results.

[0069] 5. Access legality certification.

[0070] In one implementation, through the above method, the same service can support database queries of multiple different types of database data sources, while supporting dynamic modification and addition of SQL query statements without stopping the service - that is, during the service execution, it greatly enhances the flexibility of the data query service and the expansion support for multiple database types.

[0071] In one embodiment, the authentication and authorization module is also used to:

[0072] The verification status information includes a network signal connection instability coefficient, a timestamp invalidity coefficient, and a data incompleteness coefficient;

[0073] The calculation method of the network signal connection instability coefficient is:

[0074] Get the actual network signal value corresponding to different times in a fixed time interval each time a query request is received, and mark the actual network signal value as H 实 k , k represents the number of moments, k = 1, 2, 3, 4, ..., u, u is a positive integer;

[0075] Calculate the actual network signal value at different times within a fixed time interval and mark it as H 实 k The standard deviation is calibrated as R, and the calculation formula of the standard deviation R is:

[0076]

[0077] in, is the average value of the actual network signal value corresponding to different times within a fixed time interval, and the expression obtained is:

[0078] By calculating the average value H of the actual network signal value corresponding to different times within a fixed time interval 实 k The standard deviation R of the network signal connection instability coefficient Faz is obtained, and the expression obtained is: Faz=R.

[0079] It should be noted that each time a query request is received, the actual network signal values ​​corresponding to different moments within a fixed time interval can be directly obtained from a monitoring system in the system; other methods may also be used, which are not specifically limited;

[0080] It should be noted that when the network signal connection instability coefficient is greater, the legitimacy of the token authenticated by the authentication interface is less legitimate. At this time, if the token is judged to be invalid, the data query service is executed and an error message is returned. The reason is:

[0081] Impact of network fluctuations: The greater the network signal connection instability coefficient, the more violent the network signal fluctuations within a fixed time interval. This may lead to the risk of data loss or tampering during the Token generation and transmission process, thus affecting the integrity and legitimacy of the Token.

[0082] Data consistency issues: Unstable network connections may cause inconsistencies in the token during transmission. For example, different data packets of the same request may arrive at the server at different times, causing the server to be unable to correctly assemble and verify the token.

[0083] Risk of replay attacks: When the network signal is unstable, attackers may take advantage of network delays or packet loss to launch replay attacks, that is, repeatedly send previously intercepted tokens. In this case, the server cannot effectively distinguish between legitimate requests and replay attacks, increasing security risks.

[0084] Timeout problem: Token authentication usually contains timestamp and validity period information. When the network is unstable, the transmission of the token may be delayed, causing the token to expire when it reaches the server, or the server to mistakenly believe that the token has expired.

[0085] Therefore, when the network signal connection is unstable, in order to ensure the security of the system and the accuracy of data query, the system will determine that the token may be invalid and return an error message instead of executing the data query service. This design can effectively prevent security issues caused by network fluctuations and ensure the reliability of data query services.

[0086] In one embodiment, the authentication and authorization module is also used to:

[0087] The calculation method of the timestamp validity coefficient is:

[0088] Get the corresponding Token each time a query request is received, and mark the Token as Y l , l represents the number of Tokens, l = 1, 2, 3, 4, ..., h, h is the total number of Tokens and is a positive integer;

[0089] Mark invalid tokens as Y d , d represents the number of invalid tokens, d = 1, 2, 3, 4, ..., r, r is the number of invalid tokens;

[0090] According to Y l and Y d The timestamp invalid coefficient Dlx is obtained, and the calculation formula is: Dlx=lm(r / h+1).

[0091] It should be noted that each time a query request is received, the corresponding Token can be obtained directly from the monitoring system in the system; it can also be obtained in other ways, which are not limited to the specific ones;

[0092] It should be noted that when the timestamp invalid coefficient is larger, the legitimacy of the Token authenticated by the authentication interface is less legitimate. At this time, if the Token is judged to be invalid, the data query service is executed and an error message is returned. The reason is:

[0093] Token expiration risk: The larger the timestamp invalid coefficient is, the more tokens have expired or are out of the valid time range. This means that these tokens have exceeded their validity period during transmission or use, which may increase the risk of illegal access or data tampering.

[0094] Reduced authentication accuracy: A high timestamp invalid coefficient indicates that a large proportion of the tokens received by the system are invalid. This may be due to time synchronization issues, clock drift, or defects in the token generation mechanism, making it difficult for the system to accurately authenticate the legitimacy of the request.

[0095] Increased likelihood of replay attacks: The higher the proportion of invalid tokens, the more vulnerable the system is to replay attacks. Attackers may use expired tokens to repeatedly send requests in an attempt to bypass security checks and create system security vulnerabilities.

[0096] Reduced system trust: Frequent invalid tokens will cause the system to reduce its trust in all tokens received, which in turn affects the stability and security of the entire authentication system.

[0097] Therefore, in order to ensure the security of the system and the accuracy of data query, when the timestamp invalidity coefficient is large, the system will determine that the token may be invalid and return an error message instead of executing the data query service. This design can effectively prevent security risks caused by token expiration or time synchronization problems and ensure the reliability of data query services.

[0098] In one embodiment, the authentication and authorization module is also used to:

[0099] The calculation method of the data incompleteness coefficient is:

[0100] Get the actual received data corresponding to each query request received, and mark the received data as M 接 e , e represents the number of data actually received, e=1, 2, 3, 4, ..., p, p is an integer;

[0101] Get the actual uploaded data corresponding to each query request received, and mark the uploaded data as M 上 c , c represents the number of data actually uploaded, c = 1, 2, 3, 4, ..., s, s is a positive integer;

[0102] According to M 接 e and M 上 c The data incompleteness coefficient Ekx is obtained, and the calculation formula is: Ekx=(sp).

[0103] It should be noted that each time a query request is received, the corresponding actually received data and the corresponding actually uploaded data can be directly obtained from the monitoring system in the system; other methods may also be used, which are not specifically limited;

[0104] It should be noted that when the data incompleteness coefficient is larger, it means that the legitimacy of the token authenticated by the authentication interface is less legitimate. At this time, if the token is judged to be invalid, the data query service is executed and an error message is returned. The reason is:

[0105] Data loss risk: The larger the data incompleteness coefficient, the more data was lost or damaged during the transmission process. In this case, there is a significant difference between the received data and the uploaded data, which may lead to misjudgment during the authentication process.

[0106] Increased possibility of data tampering: A high data incompleteness coefficient may be due to data tampering or interception during transmission. Attackers may insert malicious data or delete key data during data transmission, affecting the system's judgment of the legitimacy of the token.

[0107] Decreased authentication accuracy: When the data incompleteness coefficient is high, the difference between the actual data received by the system and the uploaded data increases, making it difficult for the system to accurately match and verify the legitimacy of the Token.

[0108] Reduced system trust: Frequent occurrence of incomplete data will lead to a decrease in the system's trust in all data received, which in turn affects the stability and security of the entire authentication system.

[0109] Therefore, in order to ensure the security of the system and the accuracy of data query, when the data incompleteness coefficient is large, the system will determine that the token may be invalid and return an error message instead of executing the data query service. This design can effectively prevent security risks caused by data loss or tampering and ensure the reliability of data query services.

[0110] In one embodiment, the authentication and authorization module is also used to:

[0111] The illegal coefficient can be obtained based on the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient, which can be achieved through the following formula:

[0112]

[0113] Where Qkgd is the illegal coefficient, Faz, Dlx and Ekx represent the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient respectively, a1, a2 and a3 are the proportional coefficients of the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient respectively, and a1, a2 and a3 are all greater than 0;

[0114] Compare the illegal coefficient with the illegal coefficient threshold. When the illegal coefficient is not less than the preset illegal coefficient threshold, it means that the legality of the Token authenticated by the authentication interface according to the verification status information is invalid. At this time, if the Token is judged to be invalid, the data query service is executed and an error message is returned.

[0115] When the illegal coefficient is less than the preset illegal coefficient threshold, it means that the authentication interface is valid according to the verification status information. If the Token is judged to be valid, the data query service is executed and the correct information is returned.

[0116] It should be noted that the above method helps to enhance the security and stability of the system. By comprehensively considering the stability of the network signal, the validity of the timestamp and the integrity of the data transmission, the system can more accurately judge the legitimacy of the token and reduce the risk of misjudgment caused by a single factor. In addition, the setting and dynamic adjustment of the illegal coefficient can flexibly optimize the authentication mechanism according to the actual situation, ensuring that illegal access and malicious attacks can be effectively prevented in various network environments, thereby ensuring the reliability and accuracy of data query services.

[0117] The above is a detailed description of an embodiment of the present invention, but the content is only a preferred embodiment of the present invention and cannot be considered to limit the scope of implementation of the present invention. All equivalent changes and improvements made within the scope of the present invention should still fall within the scope of the patent coverage of the present invention.

Claims

1. A service system for data query, characterized in that: The system comprises: Information configuration module: used to configure the information required for database connection and configure SQL statements according to the database; Database connection module: used to read the configured database information when the system starts, and create a connection pool based on the read database information; Execution module: After receiving the data query request, it finds the corresponding database connection pool and SQL statement according to the SQL unique identifier of the request, performs paging query, and returns the query result set and paging result information; Authentication and authorization module: used to authenticate the identity of each query request received, and determine the accuracy of the returned query information based on the verification status information.

2. A service system for data query according to claim 1, characterized in that: The information configuration module is used for: Configure the database information, which is used to provide relevant information for creating a database connection when executing SQL statements; the relevant information includes the database address, account, password, and name; Configure the SQL statement information to be executed in the specified database table, configure the database information primary key, and configure the cache properties of the query result of the statement - whether to cache, and if so, configure the cache cycle.

3. A service system for data query according to claim 1, characterized in that: The database connection module is used for: When the system starts, it reads the database configuration information and dynamically creates a database connection pool based on the relevant information - dynamically loads the relevant database driver according to the configured database type, creates a database connection based on the connection parameters of the data, and uses mainstream connection pool technology to create a connection pool to ensure query response efficiency in the case of a large number of accesses.

4. A service system for data query according to claim 1, characterized in that: The execution module is used for: When a data query request is received, the corresponding database connection pool and the corresponding statement are found according to the SQL unique identifier of the request, and the type of database is determined. The paging query is encapsulated according to the paging information in the query parameters, and the executed query data result set and paging result information are returned to the requester.

5. A service system for data query according to claim 1, characterized in that: The authentication and authorization module is used for: Every time a query request is received, the identity of the requester will be verified. The requester must bring a Token each time a request is made. Before the request is made, the Token first calls the authentication interface and passes the relevant verification status information. The authentication interface returns after authentication based on the verification status information. After the query service verifies the legitimacy of the Token, if it determines that the Token is valid, it executes the data query service and returns accurate information, otherwise it returns an error message.

6. A service system for data query according to claim 5, characterized in that: The authentication and authorization module is also used for: The verification status information includes a network signal connection instability coefficient, a timestamp invalidity coefficient, and a data incompleteness coefficient; The calculation method of the network signal connection instability coefficient is: Get the actual network signal value corresponding to different times in a fixed time interval each time a query request is received, and mark the actual network signal value as H 实 k , k represents the number of moments, k = 1, 2, 3, 4, ..., u, u is a positive integer; Calculate the actual network signal value at different times within a fixed time interval and mark it as H 实 k The standard deviation is calibrated as R, and the calculation formula of the standard deviation R is: in, is the average value of the actual network signal value corresponding to different times within a fixed time interval, and the expression obtained is: By calculating the average value H of the actual network signal value corresponding to different times within a fixed time interval 实 k The standard deviation R of the network signal connection instability coefficient Faz is obtained, and the expression obtained is: Faz=R.

7. A service system for data query according to claim 6, characterized in that: The authentication and authorization module is also used for: The calculation method of the timestamp validity coefficient is: Get the corresponding Token each time a query request is received, and mark the Token as Y l , l represents the number of Tokens, l = 1, 2, 3, 4, ..., h, h is the total number of Tokens and is a positive integer; Mark invalid tokens as Y d , d represents the number of invalid tokens, d = 1, 2, 3, 4, ..., r, r is the number of invalid tokens; According to Y l and Y d The timestamp invalid coefficient Dlx is obtained, and the calculation formula is: Dlx=ln(r / h+1).

8. A service system for data query according to claim 6, characterized in that: The authentication and authorization module is also used for: The calculation method of the data incompleteness coefficient is: Get the actual received data corresponding to each query request received, and mark the received data as M 接 e , e represents the number of data actually received, e=1, 2, 3, 4, ..., p, p is an integer; Get the actual uploaded data corresponding to each query request received, and mark the uploaded data as M 上 c , c represents the number of data actually uploaded, c = 1, 2, 3, 4, ..., s, s is a positive integer; According to M 接 e and M 上 c The data incompleteness coefficient Ekx is obtained, and the calculation formula is: Ekx=(sp).

9. A service system for data query according to claim 6, characterized in that: The authentication and authorization module is also used for: The illegal coefficient can be obtained based on the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient, which can be achieved through the following formula: Where Qkgd is the illegal coefficient, Faz, Dlx and Ekx represent the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient respectively, a1, a2 and a3 are the proportional coefficients of the network signal connection instability coefficient, timestamp invalid coefficient and data incomplete coefficient respectively, and a1, a2 and a3 are all greater than 0; Compare the illegal coefficient with the illegal coefficient threshold. When the illegal coefficient is not less than the preset illegal coefficient threshold, it means that the legality of the Token authenticated by the authentication interface according to the verification status information is invalid. At this time, if the Token is judged to be invalid, the data query service is executed and an error message is returned. When the illegal coefficient is less than the preset illegal coefficient threshold, it means that the authentication interface is valid according to the verification status information. If the Token is judged to be valid, the data query service is executed and the correct information is returned.

Images