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

Complicated query method based on attributes

A query method and attribute technology, applied in climate sustainability, special data processing applications, instruments, etc., can solve problems such as large storage space, slow query and analysis speed, and inability to accurately query, so as to improve data management efficiency and improve The effect of designing productivity and reducing script complexity

Pending Publication Date: 2017-12-08
DISHANG GROUP CO LTD
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The first method is convenient to save, but it cannot be accurately queried, and it is also difficult to conduct data summary analysis
The second method is slightly more complicated to save, and can be accurately queried and analyzed, but requires a large storage space. At the same time, due to the need to link multiple tables when querying, the performance is very poor, and the query and analysis speed is extremely slow, which is not suitable for large amounts of data. storage and analysis

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0017] A certain fabric has three colors of red (1), yellow (2) and green (4), then Color=1+2+4=7 If you want to search for colors that include red (1) and green (4), first combine the two Then use the & operation of SQL, 5&7=5 means that all the colors to be searched are included in the color attribute value of this fabric. In this way, the query efficiency can be greatly improved and the script complexity can be reduced. After a rough test, in the current data environment (8 million pieces of data), it takes less than 1 second to execute the following query.

[0018] Compared with the prior art, the invention can greatly improve query efficiency, reduce script complexity, improve fabric data management efficiency, and further improve design production efficiency.

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 massive data query management, in particular to a complicated query method based on attributes which is specially applicable to fabric data management and can effectively improve the fabric management efficiency. The method is characterized in that a data storage database is initially built, wherein each attribute corresponds to a field of an integer type; each attribute value is saved as the nth power of 2, and bitwise AND operation is used during query, wherein the query method comprises the steps that attribute values to be searched are summed during query, a retrieval value is obtained by means of & operation of SQL, query is conducted in the storage database through the retrieval value, and a fabric with the attributes to be searched is obtained. By means of the complicated query method based on the attributes, the query efficiency can be greatly improved, script complexity is reduced, the efficiency of fabric data management is improved, and thus the design and production efficiencies are improved.

Description

Technical field: [0001] The invention relates to the technical field of massive data query management, in particular to an attribute-based complex query method that is especially suitable for fabric data management and can effectively improve fabric management efficiency. Background technique: [0002] We often need to save certain entity information in the computer system. An entity may have multiple categories of attributes. For example, for a clothing fabric, in addition to single-value attributes, such as name, price, etc., it may also contain multiple values. Attributes, such as season attributes, fabric pattern attributes, feel attributes, etc. Each attribute corresponds to multiple options. For example, a fabric can be applied to spring and summer at the same time, then its seasonal attribute has two values: spring and summer. When we have a lot of fabric data, such as millions of fabrics, how to save these attributes and quickly find fabrics that meet specific attri...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/244Y02D10/00
Inventor 朱新滨
Owner DISHANG GROUP CO LTD
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