Algorithm for intelligently converting JSON and XML format data into traditional data table format

Abstract

The invention discloses an algorithm for intelligently converting JSON and XML format data into a traditional data table format, which comprises the following steps: S1, data analysis: carrying out father node name inheritance on data node names when JSON format data is analyzed by a data tree formed by unique node names at the same latitude to obtain abstract key value pairs; S2, data extraction: performing table definition on an abstract data tree obtained by performing data analysis on the JSON format data so as to perform table data many-to-one or many-to-many data ambiguity elimination on a plurality of traditional one-dimensional or two-dimensional table data contained in the data tree; and S3, expansion: carrying out comparison of a data macro replacement practical algorithm on the extracted table data. The algorithm for converting the universal and versatile JSON or XML format data into the traditional data table format is realized, so that the algorithm has the advantages of wide application range and high practicability, and meanwhile, the algorithm instance in the prior art is realized by using the C# language.

Description

technical field [0001] The invention relates to the technical field of Internet industry data interaction formats, in particular to an algorithm for intelligently converting JSON and XML format data into traditional data table formats. Background technique [0002] On February 10, 1998, W3C (World Wide Web Consortium, World Wide Web Consortium) announced the XML 1.0 standard; JSON (JavaScript Object Notation) is a data format that Douglas Crockford began to promote in 2001. It officially became the mainstream data format in 2005-2006. Currently, JSON has become the de facto standard for data interaction formats in the Internet industry. [0003] XML is an enhanced implementation of HTML, and JSON is more powerful, just like its name: JS Object Notation, which can describe almost all JavaScript objects. [0004] However, none of them provide backward compatibility, and there is no reverse conversion definition from XML to HTML; JSON can only be converted into JS objects. ...

AI Technical Summary

Problems solved by technology

[0007] The purpose of the present invention is to provide an algorithm for intelligently converting JSON and XML format data into traditional data table format, aiming to solve the problem that there is no general, all-round algorithm for converting JSON or XML format data into traditional data table format in the prior art And other issues

Images