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

A system and method for querying nomenclature and reuse support

A support system and query system technology, applied in the computer field, can solve problems such as repetitive work, low query efficiency, and long query condition setting time

Active Publication Date: 2019-01-15
周宁
View PDF6 Cites 1 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 system and method for querying nomenclature and reuse support
  • A system and method for querying nomenclature and reuse support
  • A system and method for querying nomenclature and reuse support

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 supporting system and a method. The system mainly comprises 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 as follows: 1) establishing the database. 2) selecting the data source name. 3) establishing database table. 4) passing the query name and query parameters. 5) obtaining query setting information correspond to that query name in the database table. 6) the preprocess system preprocesses the query parameter. 7) generating a query condition and an output option according to the name query description information xml, calling a corresponding query service according to the named query type fordata query and returning the correspond column data according to the output option. The invention solves the problems of saving and naming query conditions, the problems of opening parameters based onthe query conditions, the problems of visualization and multiplexing of the named query and the problems of service invocation of the named query.

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