Universal API table query method

A table query and table field technology, applied in the database field, can solve the problems of frequent query operations, reduce the workload of development and operation and maintenance, and achieve the effect of meeting flexible needs and reducing impact

Inactive Publication Date: 2017-05-24
G CLOUD TECH
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] For database-centric application systems, query operations are the most frequent; while many tasks of development, testing, and integration are also about query operations. At the same time, the business requirements of application systems change dynamically over time, and the corresponding query functions also It will change, and the corresponding development, testing, and integration also need to track and adjust the query requirements, but how can we reduce the impact of business requirements on system program changes and reduce the workload of development and operation and maintenance?

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
  • Universal API table query method
  • Universal API table query method
  • Universal API table query method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, those skilled in the art who do not make substantive inventions in similar method embodiments all belong to the protection scope of the present invention.

[0028] Such as figure 1 As shown, the specific implementation logic of each will be described below.

[0029] 1. Provide API query, input parameter limit maximum number of records per page, offset start mark, sort_dir sorting method, sort_key default corresponding sorting field name, only_static only counts the quantity identification, does not put detailed records, key_names table field name segment list, Support multiple fields, key_value search keywords, sort_dir...

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 relates to the technical field of databases, and in particular to a universal API table query method. The method mainly comprises the following steps of setting a universal API input format, so as to support fuzzy query according to keywords, provide statistical and page separation functions and support sorting according to a certain field; setting a uniform control logic, so as to only count record numbers or feed the record number and a detailed record list back; and packaging universal statistic and query record functions. Through the universal API table query method, the influences caused by the alternation of table structures to the table query are decreased, the efficiencies of development, test and integration are improved, and the flexible requirements, for the table query, of different businesses are satisfied at the same time.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a general API table query method. Background technique [0002] For database-centric application systems, query operations are the most frequent; while many tasks of development, testing, and integration are also about query operations. At the same time, the business requirements of application systems change dynamically over time, and the corresponding query functions also It will change, and the corresponding development, testing, and integration also need to track and adjust the query requirements, but how can we reduce the impact of business requirements on system program changes and reduce the workload of development and operation and maintenance? Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a general API table query method to reduce the impact of table structure changes on table query. [0004] The technic...

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/2282G06F16/2433
Inventor 罗义兵杨松季统凯
Owner G CLOUD TECH
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