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

Associated field query device and associated field query method

A technology of a query device and a query method, which is applied in the computer field, and can solve problems such as poor efficiency, limited length of database indexes, and inability to create indexes for data columns.

Active Publication Date: 2013-01-09
YONYOU NETWORK TECH
View PDF5 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Related technologies such as using computed columns to query associated fields, but the index length of the database is limited, when the length of the index column exceeds the limit, it will not be possible to create an index for the data column
When the index cannot be effectively used, the database system searches the data through the full table scan, which is inefficient. Obviously, this solution cannot effectively solve the negative impact of too many associated fields on system performance.

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
  • Associated field query device and associated field query method
  • Associated field query device and associated field query method
  • Associated field query device and associated field query method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0032] In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways different from those described here, therefore, the present invention is not limited to the specific embodiments disclosed below limit.

[0033] figure 1 A block diagram of an associated field query device according to an embodiment of the present invention is shown.

[0034] Such as figure 1 As shown, the associated field query device 100 according to the embodiment of the present invention includes: an acquisition unit 102, which acquires associated fields between data tables in a relational database; a calculated column generating ...

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 provides an associated field query device which comprises an acquisition unit, a calculated column generation unit, a digest generation unit and a query unit, wherein the acquisition unit acquires associated fields between data sheets in a relational database; the calculated column generation unit combines the associated fields to form a calculated column; the digest generation unit performs calculation according to the calculated column to obtain a unique message digest; and the query unit creates a calculated column index according to the unique message digest, and queries target data according to the calculated column index. According to the technical scheme of the invention, field quantity of data query can be reduced, field length can be packed, the limitation of data base index key value length and index column quantity is broken through, the index is effectively used, and data query efficiency is improved. The invention also provides an associated field query method.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular, to an associated field query device and an associated field query method. Background technique [0002] With the development of computer technology, the main application of computers has changed from traditional scientific computing to transactional data processing. In the process of transaction processing, complex scientific calculations are not required, but a large amount of data storage, search, and statistics are required, such as teaching management, personnel management, and financial management. This requires the management of a large amount of data, and database technology is currently the most advanced data theorem technology. Any database management system is based on a certain data model. Currently, there are three commonly used data models: hierarchical model, network model and relational model. Correspondingly, databases are also divided into three basic t...

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
Inventor 杨砚
Owner YONYOU NETWORK TECH
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