CN112559606A - Conversion method and conversion device for JSON format data - Google Patents
Conversion method and conversion device for JSON format data Download PDFInfo
- Publication number
- CN112559606A CN112559606A CN201910919247.6A CN201910919247A CN112559606A CN 112559606 A CN112559606 A CN 112559606A CN 201910919247 A CN201910919247 A CN 201910919247A CN 112559606 A CN112559606 A CN 112559606A
- Authority
- CN
- China
- Prior art keywords
- node
- format data
- data
- processed
- json format
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 56
- 238000000034 method Methods 0.000 title claims abstract description 47
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000004891 communication Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 12
- 230000008569 process Effects 0.000 description 7
- 238000004590 computer program Methods 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000006835 compression Effects 0.000 description 1
- 238000007906 compression Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a conversion method and a conversion device for JSON format data, and belongs to the technical field of computers. The conversion method for JSON format data comprises the following steps: acquiring JSON format data to be processed; analyzing the JSON format data to be processed to determine the type and information of each node in the JSON format data to be processed; and converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node. Through the technical scheme, the JSON format data to be processed with unknown data structure can be analyzed, the relational data table corresponding to the JSON format data to be processed is generated, and the relational data table can be directly stored in the relational database, so that the subsequent processing and use are facilitated.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a field information processing method and apparatus, a storage medium, and a processor.
Background
JSON (JSON Object Notation) is a data exchange format that is becoming more and more popular because of its simple format, ease of transmission, ease of compression, and lightweight.
For many enterprises, data is stored in a relational database and is converted into JSON format data during data transmission, which inevitably causes the problem of interconversion between the relational data and the JSON format data.
There are many tools available today that can perform serialization and deserialization of JSON formatted data. For deserialization of JSON-formatted data, it is necessary to know a specific object structure in advance to deserialize the data. For JSON format data with unknown data structures, no proper method is available for deserializing the JSON format data.
Disclosure of Invention
An object of the embodiments of the present invention is to provide a conversion method and a conversion device for JSON format data, which are used to solve one or more of the above technical problems.
In order to achieve the above object, an embodiment of the present invention provides a conversion method for JSON format data, where the conversion method includes: acquiring JSON format data to be processed; analyzing the JSON format data to be processed to determine the type and information of each node in the JSON format data to be processed; and converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node.
Optionally, the converting the JSON format data to be processed into the relational data table corresponding to the JSON format data according to the type and information of each node further includes: converting the JSON format data to be processed into second JSON format data according to the type and the information of each node; and converting the JSON format data to be processed into a corresponding relational data table according to the second JSON format data and the data structure of the second JSON format data.
Optionally, the types of the nodes include object nodes, array nodes, and/or value nodes.
Optionally, the analyzing the JSON-format data to be processed to determine the type and information of each node in the JSON-format data to be processed includes: under the condition that the type of the node is determined to be an object node, taking the attribute of the object node and the value corresponding to the attribute as the information of the object node; and under the condition that the type of the node is determined to be the array node, taking the information of each element in the array node as the information of the array node.
Optionally, the converting the JSON format data to be processed into the relational data table corresponding to the JSON format data according to the type and information of each node includes: and splicing the information of the object nodes under the condition that the type of the node is the object node, and performing combined processing on the information of the array nodes under the condition that the type of the node is the array node.
In another aspect, the present invention further provides a conversion apparatus for acquiring JSON format data, the conversion apparatus including: the acquisition module is used for acquiring JSON format data to be processed; the analysis module is used for analyzing the JSON format data to be processed so as to determine the type and information of each node in the JSON format data to be processed; and the conversion module is used for converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node.
Optionally, the conversion module is further configured to perform the following operations: converting the JSON format data to be processed into second JSON format data according to the type and the information of each node; and converting the JSON format data to be processed into a corresponding relational data table according to the second JSON format data and the data structure of the second JSON format data.
Optionally, the conversion module is further configured to perform the following operations to convert the JSON format data to be processed into a relational data table corresponding to the JSON format data: and splicing the information of the object nodes under the condition that the type of the node is the object node, and performing combined processing on the information of the array nodes under the condition that the type of the node is the array node.
In another aspect, the present invention provides a machine-readable storage medium having stored thereon instructions for causing a machine to perform the method for conversion of JSON formatted data as described in any one of the above.
In another aspect, the present invention provides an electronic device comprising at least one processor, and at least one memory connected to the processor, a bus; the processor and the memory complete mutual communication through the bus; the processor is configured to call program instructions in the memory to perform any of the above-described conversion methods for JSON formatted data.
Through the technical scheme, the JSON format data to be processed with unknown data structure can be analyzed, the relational data table corresponding to the JSON format data to be processed is generated, and the relational data table can be directly stored in the relational database, so that the subsequent processing and use are facilitated.
Additional features and advantages of embodiments of the invention will be set forth in the detailed description which follows.
Drawings
The accompanying drawings, which are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the embodiments of the invention without limiting the embodiments of the invention. In the drawings:
fig. 1 shows a schematic flow diagram of a conversion method for JSON-formatted data according to an embodiment of the present invention;
FIG. 2 shows a simplified schematic diagram of JSON formatted data;
FIG. 3 illustrates an exemplary JSON formatted data;
FIG. 4 illustrates a relational data table after conversion of the JSON format data shown in FIG. 3;
FIG. 5 illustrates an exemplary conversion process of JSON formatted data;
fig. 6 shows a block diagram of a conversion apparatus for JSON format data according to an embodiment of the present invention;
fig. 7 shows a block diagram of an electronic device according to an embodiment of the invention.
Detailed Description
The following detailed description of embodiments of the invention refers to the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating embodiments of the invention, are given by way of illustration and explanation only, not limitation.
Fig. 1 is a flowchart illustrating a conversion method for JSON-format data according to an embodiment of the present invention. As shown in fig. 1, an embodiment of the present invention provides a conversion method for JSON format data, where the conversion method may include steps S110 to S130.
In step S110, JSON format data to be processed is acquired.
For the transportation of JSON-formatted data, a certain amount of data (including connection join, grouping, and union between data tables) is usually taken out from a relational database, a conversion method related to converting the data in the database into the JSON-formatted data is adopted, the data can be converted into a certain amount of recognizable objects, after further processing, the JSON is converted into an object group formed by the certain amount of objects to generate the JSON-formatted data, and then the JSON-formatted data is provided to a receiving end through an interface and the like, namely the JSON-formatted data to be processed.
The data structure of JSON format data to be processed, which is mainly related to the technical scheme provided by the embodiment of the invention, is unknown, and no conversion method for the JSON format data with the unknown data structure exists in the existing technical scheme.
In step S120, the JSON-formatted data to be processed is analyzed to determine the type and information of each node in the JSON-formatted data to be processed.
For JSON format data, it can be regarded as a tree structure, and nodes of the tree structure may include the following three types: object nodes, array nodes, and value nodes.
Typically, the value nodes are all leaf nodes of the tree structure.
The parsing process for the JSON formatted data to be processed is now explained for different types of nodes.
When a certain node of the JSON format data to be processed is analyzed and the type of the node is determined to be an object node, the attribute of the object node and the value corresponding to the attribute need to be continuously analyzed, and the attribute and the value corresponding to the attribute are used as the information of the object node.
Optionally, for the object node, the attribute of the object node may also be an object child node, and then the object child node needs to be continuously analyzed to obtain the attribute of the object child node and a value corresponding to the attribute.
Optionally, for the object node, the attribute of the object node may also be an array child node, and then each element in the array child node needs to be analyzed to obtain information of each element.
Further, for the array child node, the element of the array may also be an object child node at a next level, an array child node at a next level, a value byte point at a next level, and the like, and when the element of the array is an object word node at a next level or an array child node at a next level, further analysis needs to be continued on the object child node at a next level, the array child node at a next level, and the like of the array until the value of the attribute is analyzed.
When a certain node of the JSON format data to be processed is analyzed and the type of the node is determined to be an array node, each element in the array node needs to be analyzed, and the information of each element belongs to the information of the array node.
Further, similar to the above, each element in the array node may also be an object child node, an array byte point, or a value child node, and in the case of a child node being a value, no further analysis is needed, and in the case of an object child node or an array child node, further analysis needs to be continued on the object child node, the array child node, and the like until the value of the attribute is analyzed.
For JSON-format data to be processed, the node formation of the tree structure formed by the data is complex, and each node can be continuously divided into a plurality of branch nodes, so that in order to avoid the problem of data loss, the JSON-format data to be processed needs to be analyzed in a recursive manner, that is, the tree structure formed by the JSON-format data to be processed needs to be traversed layer by layer. Considering that the value nodes are all leaf nodes of the tree structure, it can be set that in the case where a value node (i.e., a leaf node) is resolved, the resolution of the branch can be confirmed to be completed.
In step S130, the JSON format data to be processed is converted into a relational data table corresponding to the JSON format data to be processed according to the type and information of each node.
The embodiment of the present invention provides a method capable of converting information of all nodes in JSON format data to be processed into a relational data table for a node type, where the method includes:
under the condition that the type of the node is an object node, the analyzed information comprises the attribute and the value corresponding to the attribute, and the attribute and the value can be respectively used as the column name and the corresponding value of the relational data table, so that the concatenation (concat) operation can be adopted and spliced together;
and under the condition that the type of the node is an array node, the analyzed information of each element is subjected to union (union) operation, and is jointed together to be used as a record of the relational data table.
By the scheme provided by the embodiment of the invention, the JSON format data to be processed with unknown data structure can be analyzed, the relational data table corresponding to the JSON format data to be processed is generated, and the relational data table can be directly stored in the relational database, so that the subsequent processing and use are facilitated.
In some optional embodiments, for JSON-formatted data with an unknown data structure, after the type and information of each node are analyzed, a person skilled in the art can convert the obtained JSON-formatted data into second JSON-formatted data according to actual requirements, and the data structure of the second JSON-formatted data can also be set by himself according to the actual requirements.
FIG. 2 shows a simplified schematic diagram of a JSON format data. In fig. 2, the Tree Node of the JSON-format data includes an Object Node (Object Node), an Array Node (Array Node), and a Value Node (Value Node), and for the Object Node (Object Node), it may include a plurality of attributes (Property), and when converting into the relational data table, it may be sufficient to concatenate (Concat) the Object Node (Object Node), and for the Array Node (Array Node), it may include a plurality of elements (Item), and when converting into the relational data table, it may be sufficient to combine (Union) the Object Node (Object Node).
Fig. 3 provides an exemplary JSON-formatted data, and when the JSON-formatted data is received, the data structure of the JSON-formatted data is unknown, and after the JSON-formatted data is analyzed by the method provided by the embodiment of the present invention, the following contents can be confirmed: the ancestor of the tree structure corresponding to the JSON-formatted data is an array node, the array node has two element child nodes, and each element child node has eleven key-value pairs each composed of an attribute and a value, for example, the first attribute in the first element child node is goodsId, and the corresponding value is 4.
After the JSON-format data shown in fig. 3 is analyzed, the relational data table shown in fig. 4 can be formed by the join operation and the concatenation operation.
Fig. 5 provides a conversion process for a specific JSON format data.
As shown in fig. 5, the JSON format data to be processed acquired at 510 specifically includes: "184" { "id":184, "name": 23ed "," isdeleteds ": false", "role": { "id":10002, "name": "lihao", "p rivilege": can create dash group ": true }," role type ":2}," createTime ": 0001-01-0100: 00" }, { "id":34, "name": alpha-test0413"," isdeleteds ": false", "role": ": 10215," name ": xuzhenjia", "privilege": daateshbeard group ": 5": this invention is processed in JSETtype ": { "heads" [ "id", "name", "isdeleteds", "id (roll)", "name (roll)", "can create dashbone group", "roll type", "createTime" ], "data" [ [184 "," 23ed ", false,10002," advanced user ", true,2,"0001-01-0100:00:00"], [34," alpha-test0413", false,10215," resource administrator ", true,4,"0001-01-0100:00:00"]," columns "{" optional Pairs "[ {" key ": 0", "value" { "name": ":"0"," key ": 0" { "type" { "1 {: result": 1 { "metadata" { "1 {: 1 {" metadata "{" type ":1 {: metadata" }, { "metadata" { "1 {: 1 {" metadata "}, {" metadata "{: 1 {: metadata" }, "value" { "name": "isdeleteds", "key": 2"," dataType ": 3", "column types":62 "," formatting dataType ":0} }, {" key ": 54", "formatting dataType":0}, { "id (roll)" 4"," key ": 3", "dataType": 0"," format dataType ":0}, {" key ": 4", "value": "{" name ": name (name) (roll),", "key": 4"," dataType ": 1", "column types":62 "," format "type": 0 { "5": 5 "{" type ": 5": metadata ": 5": metadata "{" type ": 5": metadata ": 5": metadata ": 5" { "metadata": 5 ": metadata" }, "value" { "name": createTime "," key ": 7", "dataType": 2"," column types ": 62", "format dataType":0} } }.
In the converted JSON format data shown in 530, headers are used to represent headers of the relational data table, values of headers attributes are tuples, elements in the tuples are information of the headers, data are used to represent data of the relational data table, values of data attributes are tuples, and elements in the tuples are data of the table.
Further, since the data structure of the JSON formatted data in 530 is known, it can be converted into a relational data table.
Fig. 6 shows a block diagram of a conversion apparatus for JSON format data according to an embodiment of the present invention. As shown in fig. 6, an embodiment of the present invention further provides a conversion apparatus for JSON-format data, where the conversion apparatus for JSON-format data includes: an obtaining module 610, configured to obtain JSON format data to be processed; the analyzing module 620 is configured to analyze the JSON-format data to be processed to determine the type and information of each node in the JSON-format data to be processed; and a conversion module 630, configured to convert the JSON-format data to be processed into a relational data table corresponding to the JSON-format data according to the type and information of each node.
By the technical scheme provided by the embodiment of the invention, the JSON format data to be processed with unknown data structure can be analyzed, the relational data table corresponding to the JSON format data to be processed is generated, and the relational data table can be directly stored in the relational database, so that the subsequent processing and use are facilitated.
In some optional embodiments, the converting module 630, in the process of converting each node of the JSON format data to be processed into the corresponding relational data table according to the type and information of each node, further includes: firstly, converting JSON format data to be processed into second JSON format data according to the type and information of each node, and then converting the second JSON format data into a corresponding relational data table according to a data structure of the second JSON format data at the base of the second JSON format data.
In some optional embodiments, the conversion module 630 is further configured to perform the following operations to convert the JSON format data to be processed into a relational data table corresponding thereto: and splicing the information of the object nodes under the condition that the type of the node is the object node, and performing combined processing on the information of the array nodes under the condition that the type of the node is the array node.
In some optional embodiments, the types of the nodes of the JSON format data to be processed include object nodes, array nodes, and/or value nodes.
In some optional embodiments, when it is determined that a type of a node is an object node, taking an attribute of the object node and a value corresponding to the attribute as information of the object node; and under the condition that the type of a node is determined to be an array node, taking the information of each element in the array node as the information of the array node.
In some optional embodiments, the attribute may also be an array and/or object for the object node, in which case the parsing of the array or object may be continued until the attribute value is resolved.
In some optional embodiments, for an array node, the elements within the array may also be array elements and/or object elements, in which case, the parsing of the array elements or object elements may also need to continue until the attribute values are parsed.
The specific working principle and benefits of the conversion device for JSON-format data provided by the embodiment of the present invention are similar to those of the conversion method for JSON-format data provided by the embodiment of the present invention, and will not be described herein again.
The conversion device for JSON format data comprises a processor and a memory, wherein the acquisition module, the analysis module, the conversion module and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more, and the JSON format data to be processed is converted into a corresponding relational data table by adjusting the kernel parameters.
An embodiment of the present invention provides a storage medium on which a program is stored, which, when executed by a processor, implements the conversion method for JSON-format data.
The embodiment of the invention provides a processor, which is used for running a program, wherein the method for converting JSON format data is executed when the program runs.
As shown in fig. 7, an embodiment of the present invention provides an electronic device, where the electronic device 70 includes at least one processor 701, and at least one memory 702 and a bus 703 that are connected to the processor 701; the processor 701 and the memory 702 complete mutual communication through a bus 703; the processor 701 is used to call program instructions in the memory 702 to perform the above-described conversion method for JSON formatted data. The electronic device herein may be a server, a PC, a PAD, a mobile phone, etc.
The present application further provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device:
a conversion method for JSON format data, the conversion method comprising: acquiring JSON format data to be processed; analyzing the JSON format data to be processed to determine the type and information of each node in the JSON format data to be processed; and converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node.
The step of converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node further comprises the following steps: converting the JSON format data to be processed into second JSON format data according to the type and the information of each node; and converting the JSON format data to be processed into a corresponding relational data table according to the second JSON format data and the data structure of the second JSON format data.
The types of the nodes include object nodes, array nodes, and/or value nodes.
The analyzing the JSON format data to be processed to determine the type and the information of each node in the JSON format data to be processed comprises: under the condition that the type of the node is determined to be an object node, taking the attribute of the object node and the value corresponding to the attribute as the information of the object node; and under the condition that the type of the node is determined to be the array node, taking the information of each element in the array node as the information of the array node.
The step of converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node comprises the following steps: and splicing the information of the object nodes under the condition that the type of the node is the object node, and performing combined processing on the information of the array nodes under the condition that the type of the node is the array node.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a device includes one or more processors (CPUs), memory, and a bus. The device may also include input/output interfaces, network interfaces, and the like.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip. The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A conversion method for JSON format data, characterized in that the conversion method comprises:
acquiring JSON format data to be processed;
analyzing the JSON format data to be processed to determine the type and information of each node in the JSON format data to be processed; and
and converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node.
2. The conversion method according to claim 1, wherein the converting the JSON-formatted data to be processed into the relational data table corresponding thereto according to the type and information of each node further comprises:
converting the JSON format data to be processed into second JSON format data according to the type and the information of each node; and
and converting the JSON format data to be processed into a corresponding relational data table according to the second JSON format data and the data structure of the second JSON format data.
3. The conversion method according to claim 1, wherein the type of the node includes an object node, an array node, and/or a value node.
4. The conversion method according to claim 3, wherein the parsing the to-be-processed JSON-formatted data to determine the type and information of each node in the to-be-processed JSON-formatted data comprises:
under the condition that the type of the node is determined to be an object node, taking the attribute of the object node and the value corresponding to the attribute as the information of the object node;
and under the condition that the type of the node is determined to be the array node, taking the information of each element in the array node as the information of the array node.
5. The conversion method according to claim 1, wherein the converting the JSON-formatted data to be processed into the relational data table corresponding thereto according to the type and information of each node comprises:
and splicing the information of the object nodes under the condition that the type of the node is the object node, and performing combined processing on the information of the array nodes under the condition that the type of the node is the array node.
6. A conversion apparatus for acquiring JSON format data, the conversion apparatus comprising:
the acquisition module is used for acquiring JSON format data to be processed;
the analysis module is used for analyzing the JSON format data to be processed so as to determine the type and information of each node in the JSON format data to be processed; and
and the conversion module is used for converting the JSON format data to be processed into a corresponding relational data table according to the type and the information of each node.
7. The conversion apparatus of claim 6, wherein the conversion module is further configured to:
converting the JSON format data to be processed into second JSON format data according to the type and the information of each node; and
and converting the JSON format data to be processed into a corresponding relational data table according to the second JSON format data and the data structure of the second JSON format data.
8. The conversion device according to claim 6, wherein the conversion module is further configured to perform the following operations to convert the JSON-formatted data to be processed into a relational data table corresponding thereto:
and splicing the information of the object nodes under the condition that the type of the node is the object node, and performing combined processing on the information of the array nodes under the condition that the type of the node is the array node.
9. A machine-readable storage medium having stored thereon instructions for causing a machine to perform the method for conversion of JSON-formatted data of any one of claims 1 to 5 herein above.
10. An electronic device, comprising at least one processor, and at least one memory connected to the processor, a bus;
the processor and the memory complete mutual communication through the bus;
the processor is configured to call program instructions in the memory to perform the conversion method for JSON formatted data of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910919247.6A CN112559606A (en) | 2019-09-26 | 2019-09-26 | Conversion method and conversion device for JSON format data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910919247.6A CN112559606A (en) | 2019-09-26 | 2019-09-26 | Conversion method and conversion device for JSON format data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112559606A true CN112559606A (en) | 2021-03-26 |
Family
ID=75030352
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910919247.6A Pending CN112559606A (en) | 2019-09-26 | 2019-09-26 | Conversion method and conversion device for JSON format data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112559606A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114429806A (en) * | 2021-12-31 | 2022-05-03 | 医渡云（北京）技术有限公司 | Medical data testing method and device, storage medium and equipment |
| CN114741393A (en) * | 2022-04-19 | 2022-07-12 | 四川大学 | Material genetic engineering data conversion and retrieval method |
| WO2023038891A1 (en) * | 2021-09-08 | 2023-03-16 | Schlumberger Technology Corporation | Generic rules engine |
| CN116522871A (en) * | 2023-07-05 | 2023-08-01 | 鹏城实验室 | Data format conversion method, device, equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404665A (en) * | 2015-11-12 | 2016-03-16 | 南威软件股份有限公司 | JSON format data query management system |
| CN106934011A (en) * | 2017-03-09 | 2017-07-07 | 济南浪潮高新科技投资发展有限公司 | A kind of structuring analysis method and device of JSON data |
| CN108009282A (en) * | 2017-12-22 | 2018-05-08 | 武汉楚鼎信息技术有限公司 | A kind of json data are synchronized to the method and system device of relevant database |
| CN109299068A (en) * | 2018-08-31 | 2019-02-01 | 安徽四创电子股份有限公司 | From relevant database to the data flow migration method of HBase database |
| US20190102389A1 (en) * | 2017-10-04 | 2019-04-04 | Dell Products Lp | Storing and processing json documents in a sql database table |
-
2019
- 2019-09-26 CN CN201910919247.6A patent/CN112559606A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404665A (en) * | 2015-11-12 | 2016-03-16 | 南威软件股份有限公司 | JSON format data query management system |
| CN106934011A (en) * | 2017-03-09 | 2017-07-07 | 济南浪潮高新科技投资发展有限公司 | A kind of structuring analysis method and device of JSON data |
| US20190102389A1 (en) * | 2017-10-04 | 2019-04-04 | Dell Products Lp | Storing and processing json documents in a sql database table |
| CN108009282A (en) * | 2017-12-22 | 2018-05-08 | 武汉楚鼎信息技术有限公司 | A kind of json data are synchronized to the method and system device of relevant database |
| CN109299068A (en) * | 2018-08-31 | 2019-02-01 | 安徽四创电子股份有限公司 | From relevant database to the data flow migration method of HBase database |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023038891A1 (en) * | 2021-09-08 | 2023-03-16 | Schlumberger Technology Corporation | Generic rules engine |
| CN114429806A (en) * | 2021-12-31 | 2022-05-03 | 医渡云（北京）技术有限公司 | Medical data testing method and device, storage medium and equipment |
| CN114741393A (en) * | 2022-04-19 | 2022-07-12 | 四川大学 | Material genetic engineering data conversion and retrieval method |
| CN114741393B (en) * | 2022-04-19 | 2023-04-28 | 四川大学 | Material genetic engineering data conversion and retrieval method |
| CN116522871A (en) * | 2023-07-05 | 2023-08-01 | 鹏城实验室 | Data format conversion method, device, equipment and storage medium |
| CN116522871B (en) * | 2023-07-05 | 2024-01-09 | 鹏城实验室 | Data format conversion method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112559606A (en) | Conversion method and conversion device for JSON format data | |
| CN106656536B (en) | Method and equipment for processing service calling information | |
| CN106202235B (en) | Data processing method and device | |
| JP5298117B2 (en) | Data merging in distributed computing | |
| CN109241101B (en) | Database query optimization method and device and computer equipment | |
| CN107229619B (en) | Method and device for counting and displaying calling condition of internet service link | |
| CN107122296B (en) | Method and apparatus for data assertion for test interface | |
| TWI662426B (en) | Method and device for distributed stream data processing | |
| WO2018045753A1 (en) | Method and device for distributed graph computation | |
| CN110162512B (en) | Log retrieval method, device and storage medium | |
| CN111506621B (en) | Data statistical method and device | |
| CN108599973B (en) | Log association method, device and equipment | |
| CN110955714B (en) | Method and device for converting unstructured text into structured text | |
| CN111443901B (en) | Java reflection-based service expansion method and device | |
| CN112860730A (en) | SQL statement processing method and device, electronic equipment and readable storage medium | |
| CN114490641A (en) | Industrial Internet data sharing method, equipment and medium | |
| CN113868698A (en) | File desensitization method and equipment | |
| CN114297204A (en) | Data storage and retrieval method and device for heterogeneous data source | |
| CN112883088B (en) | Data processing method, device, equipment and storage medium | |
| CN112541001A (en) | Data query method, device, storage medium and equipment | |
| CN112491943A (en) | Data request method, device, storage medium and electronic equipment | |
| CN110019357B (en) | Database query script generation method and device | |
| CN112579676A (en) | Data processing method and device between heterogeneous systems, storage medium and equipment | |
| CN108241624B (en) | Query script generation method and device | |
| CN115658680A (en) | Data storage method, data query method and related device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |