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.
CN102867064AActive Publication Date: 2013-01-09YONYOU NETWORK TECH
5 Cites 15 Cited by

Patent Information

Authority / Receiving Office
CN ยท China
Current Assignee / Owner
YONYOU NETWORK TECH
Publication Date
2013-01-09

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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