JSON format data query management system

Abstract

The invention discloses a JSON format data query management system, aiming to improve the efficiency of querying JSON format data. In the system, a communication connection is established between an application client and an application server; a communication connection is established between the application server and a database server; the database server converts a data storage format of a data table in a database according to the JSON format required by the application client, so as to obtain a JSON format data view corresponding to the data table; the application client sends a JSON format data query request to the application server; the application server sends an SQL query statement to the database server; the database server acquires JSON format data displayed by the JSON format data view from the database according to the SQL query statement and sends the JSON format data to the application server; and the application client receives the JSON format data forwarded by the application server, and displays the JSON format data to a user.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a query management system for data in JSON format. Background technique [0002] JSON (English full name: JavaScriptObjectNotation) is a lightweight data exchange format. It is based on a subset of JavaScript (StandardECMA-2623rdEdition-December1999). JSON adopts a completely language-independent text format, but also uses conventions similar to the C language. These features make JSON an ideal data exchange language, which is easy to read and write for humans, and easy for machines to parse and generate. [0003] JSON has the characteristics of small data volume, network transmission block, and convenient conversion. It is currently the main data transmission format for Internet application data transmission. However, the current general-purpose relational database stores all list data, and the client of the front-end application cannot directly query the data format require...

AI Technical Summary

Problems solved by technology

However, the current general-purpose relational database stores all list data, and the client of the front-end application cannot directly query the data format required by the client from the relational database. If you want to modify the existing database to meet the requirements of the above-mentioned clients If the query needs, the underlying database must be replaced with a database that supports JSON data storage. For example, MongoDB, Oracle12c and other databases need to be replaced, and the system transformation workload of the underlying database is relatively large, and the stability of the system cannot be guaranteed. Safeguarded during the renovation

[0004] At present, when a network application needs to obtain data, it usually needs to send the data request condition to the application server in the background, and the application server queries the data from the database server, and the application server integrates the list data returned from the database server into a string in JSON format and then transmits it to the front end For the client side of the application, the existing data query methods are relatively easy to apply to network applications using relational data, but at least there are the following disadvantages: the client side of the front-end application needs to use the application server to complete the assembly of JSON format strings, while When assembling a JSON format string, the application server needs to traverse all the list data queried in the database to synthesize a JSON format string. This traversal step is not time-consuming for queries with a small amount of data in the database, but for query data When the amount of data is large, the traversal of the data often affects the response speed of the entire system, which will greatly reduce the efficiency of querying JSON format strings

Images