Automatic data storage method, system and device based on XML, and storage medium

Abstract

The invention provides an automatic data storage method, system and device based on XML, and a storage medium. The method comprises the following steps: obtaining business data from a business libraryin real time, and generating XML data according to the business data; judging whether the data type of each child node in the XML data meets a preset type condition or not, and analyzing the child nodes meeting the type condition; comparing the node structure of the XML data obtained by analysis with the structure of a database table to be stored, and adjusting the database table according to thecomparison result to ensure the correctness and integrity of the data of each sub-node of the XML in the database table structure; and filling the XML data obtained by analysis into the adjusted database table. The automatic data storage method provided by the invention meets the requirements of effectiveness, accuracy, integrity and convenience of model training, index calculation or statisticsand the like in the current real-time business for data.

Description

technical field [0001] The present invention relates to the field of computer technology, and more specifically, to an XML-based automatic data storage method, system, device and storage medium. Background technique [0002] XML (Extensible Markup Language, Extensible Markup Language) is widely used in the fields of network services, databases and file processing. XML has the characteristics of complete separation of document content and structure, strong interoperability, unified standardization, support for multiple encodings, and good scalability. [0003] In the current business, more than one million real-time business data occurs every day, and all data is stored in an encrypted manner. However, even if the encrypted data is decrypted and all variable data is stored in XML, it is not convenient for data modeling, derivative calculation, and other real-time scenarios to use the data. [0004] According to the traditional method, the upstream business notifies the down...

AI Technical Summary

Problems solved by technology

[0005] On the one hand, there may be heterogeneous data in the upstream XML data structure, and some variables may cause statistical omissions, delayed or inaccurate notifications due to human factors, resulting in data errors and missing data.

[0006] On the other hand, the real-time performance, completeness and accuracy of data may be affected during code modification, and each modification will cost developers time and energy to manually maintain and modify the code to meet business needs

Images