The application relates to the technical field of
data processing and
database application, and discloses a data import method and device for
data verification combined with
database rules, which comprises the following steps: establishing the connection of a to-be-imported
data source and a
target database, obtaining
metadata information and a plurality of
database constraint rules; performing format
standardization and
invalid data cleaning on the extracted to-be-imported data; carrying out multi-dimensional
verification based on the database rules, distinguishing the passed and unpassed data and marking the rule violation types; batch importing the qualified data into the
target database, generating a detailed
verification report for the unqualified data to feed back to the user, and supporting the correction of the data for reprocessing. In the application, full-dimensional
verification is realized through deep linkage of database native rules, the
data integrity and import efficiency are guaranteed through standardized preprocessing, batch import and transaction mechanism, the maintenance cost is reduced through accurate feedback and closed-loop
processing, the application is suitable for a plurality of databases and data sources, and the accuracy, reliability and convenience of data import are greatly improved.