Method for storing a plurality of numerical value rows into one line

A numerical column and row technology, applied in the field of data storage program technology, can solve problems affecting query efficiency, large storage space, occupation, etc., and achieve the effect of displaying data intuitively
CN101645076AInactive Publication Date: 2010-02-10INSPUR COMMON SOFTWARE
0 Cites 3 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
INSPUR COMMON SOFTWARE
Publication Date
2010-02-10
Estimated Expiration
Not applicable · inactive patent

Smart Images

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

Abstract

The invention provides a method for storing a plurality of numerical value rows into one line, which defines field data structures of the stored numerical value rows as a non-numerical type, i.e. varchar or text and then connects ideographic strings of numerical values by '-' and ',' through program analysis and stores the ideographic strings into a database.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to a computer application technology, which is a data storage program technology, which can improve the retrieval efficiency of computer application programs and reduce the space occupied by databases. Background technique

[0002] Usually, when we design a data structure related to an ordered numeric column, we define the field as a numeric type, such as Numeric, and store data by row, which is represented as multiple records row by row in the database.

[0003] But this will form a large number of data rows in the database, which will affect the query efficiency and occupy a large storage space. Contents of the invention

[0004] The purpose of the present invention is to solve the deficiencies in the prior art, provide a method that can store multiple rows of numerical columns into one row, improve query efficiency, and reduce database storage space.

[0005] The purpose of the present invention is achieved in the following ...

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