Supercharge Your Innovation With Domain-Expert AI Agents!

A method and system for operating database based on json statement

A database and statement technology, applied in the database field, can solve the problems of low SQL statement efficiency, time-consuming and laborious debugging process, high error rate, etc., and achieve the effect of improving development work, work efficiency and product quality

Active Publication Date: 2021-03-26
AEROSPACE INFORMATION
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the database operation process of software development, software developers need to frequently write SQL statements, but manually writing SQL statements has disadvantages such as low efficiency, high error rate, and time-consuming and laborious debugging process.

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
  • A method and system for operating database based on json statement
  • A method and system for operating database based on json statement
  • A method and system for operating database based on json statement

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] In this embodiment, it is necessary to pre-establish JSON (JavaScript Object Notation) and database table corresponding expression rules as JSON description rules, use the description rules to describe the database table relationship diagram, and use the description rules to describe data requests; the database table relationship The graph can be obtained directly based on the database, or based on other third-party tools.

[0040] In this embodiment, a description rule is used to describe the relationship diagram of the database table, which is specifically as follows: The description rule defined in this embodiment can be understood as the relationship between the structure defined in JSON and the database table. An expression established. figure 2 Give an example database table relationship diagram, for figure 2 The relational diagram of the database table, the corresponding description rules between JSON and the database table are established in advance, and the ...

Embodiment 2

[0116] This embodiment provides a system for operating databases based on JSON statements, and its specific implementation structure is as follows image 3 As shown, specifically, the following modules may be included: a first description module 31, a second description module 32, and an operation module 33; wherein,

[0117] The first description module 31: it is used to create an expression for querying the table relationship of the SQL statement according to the database table relationship diagram described by the JSON description rule and according to the data request described by the JSON description rule;

[0118] The second description module 32: it is used for creating the expression of the screening condition of the table relationship of the query SQL statement according to the data request described by the JSON description rule and the expression of the table relationship;

[0119] Operation module 33: it is used to generate SQL statements to operate the database acc...

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 embodiment of the invention provides a method and a system based on a JSON (JavaScript Object Notation) statement operation database. The method comprises the steps of creating an expression of a table relation for inquiring an SQL (Structured Query Language) statement according to a database table relation graph described by use of a JSON description rule and a data request described by use of the JSON description rule; creating the expression of a screening condition of the table relation for inquiring the SQL statement according to the data request described by use of the JSON description rule and the expression of the table relation; and generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition. The method for generating and inquiring the SQL statement is a good way, and the zero code is realized in the writing process of inquiring the SQL statement under ideal conditions; the database project-based development work with complicated business logic can be greatly improved; and the working efficiency and the product quality are improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and system for operating a database based on JSON statements. Background technique [0002] In the database operation process of software development, software developers need to frequently write SQL statements, but manually writing SQL statements has disadvantages such as low efficiency, high error rate, and time-consuming and laborious debugging process. In order to improve this situation, there are currently some related software on the market, such as Navicat, etc., but this kind of software still stays at the user level, and generates the desired SQL statement through dialogue with the user. Then the developer can copy and paste the generated SQL into a specific program, and then perform operations such as assignment of conditions. The method provided by this patent is completely separated from manual intervention, and runs synchronously with the main program. Th...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F16/242
CPCG06F16/21G06F16/2433
Inventor 冯尔斌
Owner AEROSPACE INFORMATION
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com