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

Method for importing change column data into database

A data import and database technology, applied in the field of communication and information, can solve problems such as error-prone, time-consuming and labor-intensive, and heavy workload, and achieve the effect of strong practicability, wide application range, and saving workload and working time

Active Publication Date: 2017-03-22
INSPUR COMMON SOFTWARE
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If such information is imported into the information system, users often need to sort it into fixed columns first, which is time-consuming, laborious, and error-prone, especially when there are many data rows, the workload is huge
[0003] Based on this, a method for importing variable column data into the database is now provided, aiming to help solve the problem of converting variable column data from data sources such as Excel to the database system

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 importing change column data into database
  • Method for importing change column data into database
  • Method for importing change column data into database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0028] As shown in the accompanying drawings, the present invention provides a method for importing variable column data into a database, which is also applicable to the situation of importing non-changing column data, and aims to help information systems quickly convert data from data sources such as Excel to database systems In order to facilitate the collation and use of these data in the information system. The main feature of this method is to identify the column properties of data sources such as Excel, classify and set the corresponding rules and data conversion rules between columns and database columns; when data is imported, determine which column the data is stored in the database according to the column corresponding rules, and according to the data conversion rules Determine the value of data storage; when storing, the data is read...

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 discloses a method for importing change column data into a database. The specific implementation process is as follows: firstly, recognizing a column attribute of a data source, and setting corresponding rules and data conversion rules of a data source column and a database column in a classification way; performing data importing, importing a change column into the database, determining which column of the database that the data are stored according to a column correspondence rule, and determining values of data storage according to the data conversion rules; and finally, when storing, the data are read and saved by blocks, meanwhile, recording error information, and prompting once after saving, thereby facilitating users to correct multiple errors at a time. Compared with the prior art, the method for importing the change column data into the database provided by the invention uses the setting method to convert data of an Excel and other data sources into a database system, which effectively saves the workload and working time of data entry personnel, and rapidly and effectively imports complex data into a business system; and besides, the practicability is strong, the scope of application is wide, and the method has a very good popularization and application value.

Description

technical field [0001] The invention relates to the technical field of communication information, in particular to a method for importing variable column data into a database. Background technique [0002] With the popularization of information system applications, a lot of user data needs to be imported into the background database. For the convenience of filling, the customer will use the variable column method to fill in the data. As shown in a certain table: the first two columns are subject numbers and subject names, such as 5011 Total Development Cost, 5011-01 Land Acquisition and Demolition Compensation; each subsequent column is changing multi-title classification information, such as super high-rise, high-rise For residences and small high-rise buildings, the multiple titles are divided into amount, construction unit, saleable unit, etc. If such information is imported into the information system, users often need to sort it into fixed columns first, which is time...

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
CPCG06F16/258
Inventor 李洪营薛军利聂明李焕伟李伟杨帅邵长恩胡灵祎薛鹏陶述斌
Owner INSPUR COMMON SOFTWARE
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