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

Inactive Publication Date: 2010-02-10
INSPUR COMMON SOFTWARE
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[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

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
  • Method for storing a plurality of numerical value rows into one line
  • Method for storing a plurality of numerical value rows into one line

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0016] The method of the present invention is applicable to the storage technology in which multiple rows of numerical columns are stored as a row of records. For example, in the pharmaceutical industry, the box number management of drug batch numbers, in order to prevent cross-selling and batch number tracking, pharmaceutical factories usually need to manage box numbers for a batch of produced drugs. Generally, the box numbers under a batch number are continuous values, 1 , 2, 3 and other ordered values. This requires the establishment of a table to store the information of these box numbers. Most of the software is now in the form of figure 1 The style on the left side of the center is stored by row. This method will form multiple rows of records in the database, which takes up a lot of space, and the query efficiency will be greatly affected, and the interface displayed to the user is not intuitive. The present invention borrows the rich field type definitions of the datab...

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 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.

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

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 王波
Owner INSPUR COMMON SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap