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

A Method of Multiple Query of Database

A query method and database technology, which are applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of complex query statement branches and limited digestion memory, and achieve the effect of reducing the number of branches and improving the operation efficiency.

Active Publication Date: 2018-07-06
AEROSPACE INFORMATION
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, we commonly use the method of querying table data. When the query condition is determined, we can explicitly use SQL statements to realize it. However, when the query condition is a dynamic combination of multiple conditions, the query statement will be broken due to too many branches and the IF statement. The multiple nesting becomes quite complicated, especially under the embedded operating system, the digestion memory is limited

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 of Multiple Query of Database
  • A Method of Multiple Query of Database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The technical solution of the present invention will be clearly and completely described below through specific embodiments. Obviously, the described embodiments are only a part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0016] see figure 1 , figure 1 It is a flowchart of a multi-query method for a database according to an embodiment of the present invention. A multi-query method for a database proposed, comprising the following steps:

[0017] a. Determine whether the value of the query key field corresponding to the second serial number to the last serial number to be queried is the same as the value of the query key field corresponding to the first serial number to be queried, and the judgment result is different The first serial number...

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 multiple query method of a database, which comprises the following steps: a. The values ​​of the query key fields corresponding to the second sequence number to the last sequence number to be queried are judged one by one whether they correspond to the first sequence number to be queried The values ​​of the query key fields are the same, and the judgment result is obtained as the first serial number in at least one consecutive serial number that is different, and the serial number set is obtained; b, for the serial number in the set, use it as the first serial number to be queried, Using the serial number between it and the next serial number in the serial number set as the second serial number to the last serial number to be queried, repeating steps a; c, repeating steps a and b, until the obtained serial number set is an empty set, Obtain the last serial number of the serial number set corresponding to each empty set, that is, obtain the cutting point at which the value of the query key field appears repeatedly.

Description

technical field [0001] The invention relates to the technical field of data query, in particular to a method for data in multiple query tables of a database. Background technique [0002] The ultimate goal of designing a database and creating a database is to use the database. Working with data is the work of SQL (Structured Query Language, SQL for short) data manipulation language. The core of DML (Data Manipulation Language, Data Manipulation Language) is the select (select, here refers to a function commonly used in computer SQL database, used to select objects) command, which is also the only command to query the database. select is the largest and most complex of the SQL commands. Many operations of select are derived from relational algebra and contain many contents of relational algebra. Even in SQLite (SQLite is an open source, embedded relational database, it does not have an independently running process, and coexists with all service applications in the applica...

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): G06F17/30
Inventor 张朝阳聂慧萍张磊高阳余彦陈皓杨森
Owner AEROSPACE INFORMATION
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