TWM643151U - Data format conversion system - Google Patents

Abstract

A data format conversion system includes a transceiver, a storage medium and a processor. The storage medium stores a plurality of modules and a database. The processor accesses and executes an input module, an obtain module, a format conversion module, a storage module and a database stored in the storage medium. The input module is used for a user to input commands to execute operations, and store information corresponding to the commands in a first data format to the database, wherein the first data format includes at least one tag. The obtain module obtains information corresponding to the commands according to the commands. The format conversion module converts the information from the first data format to a second data format according to at least one tag, wherein the second data format includes at least one tag. The storage module is used to store the information converted into the second data format into the database.

Description

Data Format Conversion System

The present invention relates to a format conversion system, and in particular to a data format conversion system.

Bank clerks often need to use Robotic Process Automation (RPA) to go to different websites to query various information by inputting various instructions or requests during operation. .

Traditional terminal systems will automatically store query instructions, query results, and even the identity of the queryer when performing operations such as queries. With the frequent application of terminal system-RPA, the demand for data storage years and disk space requirements It is increasing day by day. Traditional terminal systems usually use the CLOB data format to store data such as query commands and query results. This method of storing data in the CLOB data format is relatively large in the case of storing the same information, even if the data is compressed and stored. , still occupies a lot of storage space, which not only causes the abuse of the storage disk space, but also consumes the storage disk.

This new creation provides a data format conversion system that can realize mutual conversion between JSON and XML data formats.

A data format conversion system created by the invention includes a transceiver, a storage medium and a processor. The storage medium is used for storing multiple modules and databases. The processor is coupled to the storage medium and the transceiver. The processor accesses and executes the input module, capture module, format conversion module, storage module and database stored in the storage medium. The input module is electrically connected to the database, and the input module is used for the user to input instructions to perform operations, and stores information corresponding to the instructions in the database in a first data format, wherein the first data format includes at least one label . The retrieval module is electrically connected with the database, and is used to retrieve information corresponding to the instruction according to the instruction. The format conversion module is electrically connected with the capture module, and is used for converting information from a first data format to a second data format according to at least one tag, wherein the second data format includes at least one tag. The storage module is electrically connected with the format conversion module and the database respectively, and is used for storing the information converted into the second data format into the database.

In an embodiment of the present invention, in the above-mentioned data format conversion system, the first data format is XML (Extensible Markup Language) data format, and the second data format is JSON (JavaScript Object Notation) data format.

In an embodiment of the present invention, in the above-mentioned data format conversion system, the first data format is JSON (JavaScript Object Notation) data format, and the second data format is XML (Extensible Markup Language) data format.

In an embodiment of the new creation, the above-mentioned data format conversion system, wherein the modules further include a login module, which are respectively electrically connected to the input module and the database for users to log into the data format conversion system , and save the user's identity information to the database.

In an embodiment of the new creation, in the above-mentioned data format conversion system, the command is a query command, and the information corresponding to the command includes at least the user's identity information, the query command, and the query result information queried according to the query command. In an embodiment of the new creation, in the above-mentioned data format conversion system, the operation of converting the information from the first data format to the second data format by the format conversion module according to at least one tag further includes: the format conversion module according to The at least one tag divides the information into a plurality of sub-information, and moves the sub-information to the area corresponding to the at least one tag in the second data format.

Based on the above, this new creation provides a data format conversion system, which can realize mutual conversion between JSON and XML data formats, and can convert the same data into lightweight JSON format to transmit data, and can also convert JSON format data according to requirements The data converted into XML format is stored in the database to provide data reusability, and the storage space is small to reduce the consumption of the storage disk.

In order to make the above-mentioned features and advantages of the present disclosure more comprehensible, the following specific embodiments are described in detail together with the accompanying drawings.

FIG. 1 is a schematic diagram of a data format conversion system according to an embodiment of the invention.

Referring to FIG. 1 , a data format conversion system 10 according to an embodiment of the present disclosure includes a processor 110 , a storage medium 120 and a transceiver 130 .

The transceiver 130 transmits and receives signals in a wireless or wired manner. The transceiver 130 may also perform operations such as low noise amplification, impedance matching, frequency mixing, up or down frequency conversion, filtering, amplification, and the like.

The storage medium 120 is used to store various software, data and various program codes required for the operation of the data format conversion system 10 . The storage medium 120 is, for example, any type of fixed or removable random access memory (random access memory, RAM), read-only memory (read-only memory, ROM), flash memory (flash memory) , hard disk drive (hard disk drive, HDD), solid state drive (solid state drive, SSD) or similar components or a combination of the above components, and are used to store multiple modules or various application programs executable by the processor 110 . In one embodiment, the storage medium 120 can store the login module 1201 , the input module 1202 , the retrieval module 1203 , the format conversion module 1204 , the storage module 1205 and the database 1206 .

The login module 1201, the input module 1202, the capture module 1203, the format conversion module 1204, and the storage module 1205 can be implemented through one of software, firmware, hardware circuits or any combination thereof, and this The disclosure does not limit the implementation of the login module 1201 , the input module 1202 , the capture module 1203 , the format conversion module 1204 , and the storage module 1205 .

The processor 110 is, for example, a central processing unit (central processing unit, CPU), or other programmable general purpose or special purpose micro control unit (micro control unit, MCU), microprocessor (microprocessor), digital signal processing Digital Signal Processor (DSP), Programmable Controller, Application Specific Integrated Circuit (ASIC), Graphics Processing Unit (GPU), Image Signal Processor (ISP) ), image processing unit (image processing unit, IPU), arithmetic logic unit (arithmetic logic unit, ALU), complex programmable logic device (complex programmable logic device, CPLD), field programmable logic gate array (field programmable gate array , FPGA) or other similar components or combinations of the above components. The processor 110 can be coupled to the storage medium 120 and the transceiver 130, and access and execute various application programs stored in the storage medium 120 and the login module 1201, the input module 1202, and the capture module stored in the storage medium 120. group 1203 , format conversion module 1204 , storage module 1205 and database 1206 .

Wherein, the login module 1201 is electrically connected with the input module 1202 and the database 1206 respectively, and is used for the user to log into the data format conversion system 10 and store the user's identity information in the database 1206 .

The input module 1202 is electrically connected to the database 1206, and the input module 1202 is used for the user to input instructions to perform operations, and stores information corresponding to the instructions in the database 1206 in a first data format, wherein the first data format Include at least one tag. In one embodiment, the label 201 may be EMPLOYEES or USER, and the invention is not limited thereto. In one embodiment, users can use Robotic Process Automation (RPA) to go to different websites to query various information by entering various instructions, for example, when opening an account for a customer, they need to query the customer's compilation or the latest identity information and other information .

The retrieval module 1203 is electrically connected to the database 1206 for retrieving information corresponding to the instruction according to the instruction. In one embodiment, the command is a query command, and the information corresponding to the command may include the user's identity information, the query command, and query result information queried according to the query command. The new creation is not limited to this.

The format converting module 1204 is electrically connected with the capturing module 1203, and is used for converting information from a first data format to a second data format according to at least one tag, wherein the second data format includes at least one tag. In one embodiment, the label 201 may be EMPLOYEES or USER, and the invention is not limited thereto. Specifically, the format conversion module 1204 divides the information into a plurality of sub-information according to at least one tag, and moves the sub-information to the area corresponding to the at least one tag in the second data format.

The storage module 1205 is electrically connected to the format conversion module 1204 and the database 1206 respectively, and is used for storing the information converted into the second data format into the database 1206 . In one embodiment, the first data format is XML (Extensible Markup Language) data format, and the second data format is JSON (JavaScript Object Notation) data format. In another embodiment, the first data format is JSON (JavaScript Object Notation) data format, and the second data format is XML (Extensible Markup Language) data format. The new creation is not limited to this.

FIG. 2 is a flowchart of a data format conversion method according to an embodiment of the invention.

Please refer to FIG. 2 , in step 201 , the user logs into the data format conversion system 10 and stores the user's identity information in the database 1206 .

In step 202, the user inputs an instruction through the input module 1202 to execute an operation, and stores information corresponding to the instruction in a first data format to the database 1206, wherein the first data format includes at least one tag.

In step 203, the retrieval module 1203 retrieves information corresponding to the instruction from the database 1206 according to the instruction.

In step 204, the format converting module 1204 converts the information from the first data format into a second data format according to at least one tag, wherein the second data format includes at least one tag. Specifically, the format conversion module 1204 divides the information into a plurality of sub-information according to the tags, and moves the sub-information to the regions corresponding to the tags in the second data format.

In step 205 , the information converted into the second data format is stored in the database 1206 via the storage module 1205 .

The following describes how the data format conversion system 10 performs data format conversion with reference to the first to second embodiments in FIGS. 3 and 4 .

FIG. 3 is a schematic diagram of data format conversion according to a first embodiment of the invention.

Please refer to FIG. 3 , which is a first embodiment of converting data in XML format into data in JSON format by the data format conversion system 10 .

The label 201 is EMPLOYEES, and the label 202 is USER. For example, the data format conversion system 10 moves the sub-information in the XML format in the area 203 to the area 204 corresponding to the label 202 according to the label 202, and so on to move other areas. The sub-information of XML format data is converted into JSON format data.

FIG. 4 is a schematic diagram of data format conversion according to a second embodiment of the invention.

Please refer to FIG. 4 , which is a first embodiment of converting data in XML format into data in JSON format by the data format conversion system 10 .

The label 201 is EMPLOYEES, and the label 202 is USER. For example, the data format conversion system 10 moves the sub-information in the XML format in the area 203 to the area 204 corresponding to the label 202 according to the label 202, and so on to move other areas. The sub-information of XML format data is converted into JSON format data.

Conversely, the user can also convert the data in JSON format to XML format data according to the requirement, so as to store the data. The data format conversion system 10 moves the sub-information in the JSON format in the area 204 to the area 203 corresponding to the tag 202 according to the label 202, and moves the sub-information in other areas by analogy, thereby converting the data in the JSON format into XML format material.

In the above-mentioned embodiment, since the data volume of the JSON format data storing the same information is small, the space occupied by the storage disk is also small, which saves the space of the storage disk. Compared with data in lightweight JSON format, data in XML format is easier to store.

Based on the above, this new creation provides a data format conversion system, which can realize mutual conversion between JSON and XML data formats, and can convert the same data into lightweight JSON format to transmit data, and can also convert JSON format data according to requirements The data converted into XML format is stored in the database to provide data reusability, and the storage space is small to reduce the consumption of the storage disk.

Although the present disclosure has been disclosed above with embodiments, it is not intended to limit the present disclosure. Anyone with ordinary knowledge in the technical field may make some changes and modifications without departing from the spirit and scope of the present disclosure. The scope of protection of this disclosure should be defined by the scope of the appended patent application.

10: Data format conversion system 110: Processor 120: storage media 130: Transceiver 1201: Login module 1202: input module 1203: Capture module 1204: format conversion module 1205: storage module 1206: database 201, 202: label 203, 204: area S201, S202, S203, S204, S205: steps

FIG. 1 is a schematic diagram of a data format conversion system according to an embodiment of the invention. FIG. 2 is a flowchart of a data format conversion method according to an embodiment of the invention. FIG. 3 is a schematic diagram of data format conversion according to a first embodiment of the invention. FIG. 4 is a schematic diagram of data format conversion according to a second embodiment of the invention.

10: Data format conversion system

110: Processor

120: storage media

130: Transceiver

1201: Login module

1202: input module

1203: Capture module

1204: format conversion module

1205: storage module

1206: database

Claims (6)

A data format conversion system, comprising: transceiver; storage media for storing multiple modules and databases; and A processor, coupled to the storage medium and the transceiver, the processor accesses and executes the modules and the database stored in the storage medium, and the modules include: The input module is electrically connected with the database, and the input module is used for the user to input an instruction to perform an operation, and store the information corresponding to the instruction into the database in a first data format, wherein the first The data format includes at least one tag; a retrieval module, electrically connected to the database, for retrieving the information corresponding to the instruction according to the instruction; a format conversion module, electrically connected to the capture module, for converting the information from the first data format to a second data format according to the at least one tag, wherein the second data format includes the at least one tag; as well as The storage module is electrically connected with the format conversion module and the database respectively, and is used for storing the information converted into the second data format into the database. The data format conversion system as described in claim 1, wherein the first data format is XML (Extensible Markup Language) data format, and the second data format is JSON (JavaScript Object Notation) data format. The data format conversion system as described in claim 1, wherein the first data format is JSON (JavaScript Object Notation) data format, and the second data format is XML (Extensible Markup Language) data format. The data format conversion system as described in Claim 1, wherein the modules further include: The login module is electrically connected with the input module and the database respectively, and is used for the user to log into the data format conversion system and store the user's identity information in the database. The data format conversion system as described in Claim 4, wherein the command is a query command, and the information corresponding to the command at least includes the identity information of the user, the query command, and query result information queried according to the query command. The data format conversion system as described in Claim 1, wherein the operation of the format conversion module to convert the information from the first data format to the second data format according to the at least one tag further includes: The format conversion module divides the information into a plurality of sub-information according to the at least one tag, and moves the sub-information to the area corresponding to the at least one tag in the second data format.

Images