Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A query naming and multiplexing support system and method

A query system and support system technology, applied in the field of query naming and multiplexing support systems, can solve problems such as low query efficiency, long query condition setting time, and non-reusable queries

Active Publication Date: 2021-09-07
周宁
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Query is a high-frequency operation widely used in information systems. Relying on the existing technology and system, it takes a long time to set the query conditions, and each query needs to reset the query conditions, resulting in low query efficiency, poor usability, and query cannot Reuse, duplication of work phenomenon is more serious

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 query naming and multiplexing support system and method
  • A query naming and multiplexing support system and method
  • A query naming and multiplexing support system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0158] see Figure 1 to Figure 7 A query naming and multiplexing support system mainly includes a computer memory, a PC display screen, a database, a preprocessing system, a multiplexing query system, a visual multiplexing query interface, and a query result display interface.

[0159] The computer memory stores the data of the database, the multiplexing query system, the visual multiplexing query interface and the query result display interface.

[0160] The PC display screen displays a visual multiplexing query interface, a query saving interface and a query result display interface of the multiplexing query system.

[0161] The preprocessing system preprocesses the queries of the visual multiplexing query interface, the multiplexing query system and the query result display interface.

[0162] The multiplexing query system mainly includes a query saving interface and a query encapsulation database.

[0163] The query saving interface mainly includes a query name editing mod...

Embodiment 2

[0279] A method for using query naming and multiplexing support system mainly includes the following steps:

[0280] 1) Establish a database, and write the data in the database into the computer memory.

[0281] 2) The data source selection module selects the data source name, thereby linking the database or data service corresponding to the data source name.

[0282] 3) Create a database table. The database table mainly saves the data of the named query condition and output option in xml format.

[0283] The database table management creates query statements.

[0284] The header of the database table mainly includes field name, field name type, whether the field name is empty, and Chinese description.

[0285] 4) The visualized multiplexing query interface invokes the named query visualized interface, and transmits the query name and query parameters to the named query visualized interface.

[0286] 5) The named query visualization interface obtains the query setting info...

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 query naming and multiplexing support system and method. The system mainly includes a computer memory, a PC display screen, a database, a multiplexing query system, a visual multiplexing query interface and a query result display interface. The main steps of the method are: 1) Establishing a database. 2) Select the data source name. 3) Create a database table. 4) Pass the query name and query parameters. 5) Obtain query setting information corresponding to the query name in the database table. 6) The preprocessing system preprocesses the query parameters. 7) Generate query conditions and output options according to the named query description information xml, and call the corresponding query service according to the named query type to perform data query and return the corresponding column data according to the output options. The invention solves the problems of saving and naming query conditions, opening parameters based on query conditions, visual multiplexing of named queries and providing service calls for named queries.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a query naming and multiplexing support system and method. Background technique [0002] Query is a high-frequency operation widely used in information systems. Relying on the existing technology and system, it takes a long time to set the query conditions, and each query needs to reset the query conditions, resulting in low query efficiency, poor usability, and query cannot Reuse, duplication of work phenomenon is more serious. Contents of the invention [0003] The purpose of the present invention is to solve the problems existing in the prior art. [0004] The technical scheme adopted for realizing the purpose of the present invention is such: [0005] A query naming and multiplexing support system mainly includes a computer memory, a PC display screen, a database, a preprocessing system, a multiplexing query system, a visual multiplexing query interface, and a query res...

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/242
Inventor 周宁
Owner 周宁
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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