JSON format data query management system

A technology for formatting data and managing systems, applied in the computer field, can solve the problems of guaranteed system stability, inability to query clients from clients, and huge transformation workload, so as to avoid workload and improve query efficiency.

Active Publication Date: 2016-03-16
LINEWELL SOFTWARE
View PDF5 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 ser

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • JSON format data query management system
  • JSON format data query management system
  • JSON format data query management system

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0020] The embodiment of the present invention provides a query management system for data in JSON format, which is used to improve the query efficiency for querying data in JSON format.

[0021] In order to make the purpose, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the following The described embodiments are only some, but not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art fall within the protection scope of the present invention.

[0022] The terms "comprising" and "having" and any variations thereof in the description and claims of the present invention and the above drawings are intended to cover a non-exclusive inclu...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/258
Inventor 黄智珍高稳仁
Owner LINEWELL SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap