Database data import method

Abstract

The invention discloses a database data import method, which comprises the following steps: S1, uploading a data file comprising mobile phone number data, reading a first row of a data file column asheader information, and matching the header information with the data storage column to obtain fields according to the data storage column provided in a database; s2, putting forward a batch import data request for a plurality of pieces of data obtained after field matching, executing and assembling the batch import data request into an SQL statement for merging processing, and carrying out importprocessing on data corresponding to the batch import data request subjected to merging processing; and S3, executing the import processing, judging whether the mobile phone numbers included in the batch import data request exist in the database data or not, if the mobile phone numbers included in the batch import data request exist in the database data, updating the corresponding data of the database, and if the mobile phone numbers included in the batch import data request do not exist in the database data, generating and adding the corresponding data included in the batch import data request by the database.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database data import method. Background technique [0002] With the increasingly fierce market competition, customer information of various enterprises is becoming more and more important. With the wide application of information technology in enterprises, enterprises generally accumulate a large amount of customer information data. How to update these data in time to make correct decisions is of great significance to enterprises. [0003] Data warehouse is a technology that emerges to support enterprise decision-making. Its purpose is to integrate all data within the enterprise into a large warehouse, which is convenient for users to query, analyze, and generate reports. The data in the data warehouse comes from different business databases, and the data is organized according to the subject. Since the data warehouse can reasonably organize a large amount of historic...

AI Technical Summary

Problems solved by technology

In the data submission stage, there is a certain delay and concurrency limit for updating metadata, which affects the concurrency and success rate of data import.

It can be seen that there is a large delay in the batch processing operation of the data imported into the database system of the existing data warehouse, and there are problems such as relying on the high concurrency support of the metadata database system

[0005] Moreover, at present, in view of the process of importing a large amount of customer information into the database in the market, the customer import process is slow; the import file format is single, and generally only supports CSV format import

Images