Search

CN-115543997-B - Terminal server, data processing system and method

CN115543997BCN 115543997 BCN115543997 BCN 115543997BCN-115543997-B

Abstract

A terminal server, a data processing system and a method are characterized in that a result report is generated from a plurality of data front-end devices in a workshop. The data processing system comprises a terminal server and a plurality of data front-end devices. The data front-end equipment stores the database and at least one form. The terminal server is provided with a communication unit, a storage unit and a processing unit, wherein the communication unit is connected with the data front-end equipment through a network, the processing unit executes a data program stored in the storage unit, the processing unit executes the data program of the storage unit to select at least one target database from the databases according to a target database selection requirement, select a selected form from forms of the target databases according to the form selection requirement, acquire an associated project structure from the target databases according to the selected form, acquire a plurality of project information from the target databases according to the associated project structure, and output the project information as a result report.

Inventors

  • FENG TAIBIN

Assignees

  • 上饶市立景创新科技有限公司

Dates

Publication Date
20260512
Application Date
20220902

Claims (11)

  1. 1. A terminal server for connecting to a plurality of data head-end devices, each of the data head-end devices comprising a database, the terminal server comprising: the communication unit is connected with the database of the data front-end equipment; a storage unit for storing a data program, and A processing unit electrically connected to the communication unit and the storage unit, the processing unit executing the data program to Selecting a plurality of target databases from the databases according to a target database selection requirement; selecting a selected form from the target database according to a form selection requirement; Acquiring an associated project structure from the target database according to the selected form; The processing unit selects at least one target field from the selected forms, the processing unit selects corresponding forms from other target databases according to the target fields, the selected forms are called corresponding forms, the processing unit regards field items in the target fields as a temporary storage item key group, the processing unit traverses all the temporary storage item key groups of the selected forms and the corresponding forms and outputs the temporary storage item key group as an associated item structure, the associated item structure records field items of all the target fields, and the field items in the associated item structure are non-repeated, and And acquiring a plurality of items of information from the target database according to the associated item structure, and outputting the items of information as a result report.
  2. 2. The terminal server of claim 1, wherein the data headend is a shop floor, a personal computer, or a workstation.
  3. 3. The terminal server according to claim 1, further comprising an input unit, wherein the processing unit is electrically connected to the input unit, and the input unit receives the target library selection request or the form selection request.
  4. 4. The terminal server according to claim 1, wherein the processing unit performs a key value analysis procedure on the selected form and the corresponding form according to the associated item structure, the key value analysis procedure obtains a temporary item key set from the selected form and the corresponding form, and the processing unit traverses the selected form and the corresponding form according to the temporary item key set to obtain the item information.
  5. 5. A data processing system, the data processing system comprising: A plurality of data head-end devices, the data head-end devices storing a database, the database including at least one form, and A terminal server having a communication unit, a storage unit and a processing unit, wherein the processing unit is electrically connected to the communication unit and the processing unit, the communication unit is connected to the data front-end equipment and the database in a network, the processing unit executes a data program stored in the storage unit, the processing unit receives a target library selection request and a form selection request, and the processing unit executes the data program to Selecting a plurality of target databases from the databases according to the target database selection requirements; selecting a selected form from the forms of the target database according to the form selection requirement; Acquiring an associated project structure from the target database according to the selected form; The processing unit selects at least one target field from the selected forms, the processing unit selects corresponding forms from other target databases according to the target fields, the selected forms are called corresponding forms, the processing unit regards field items in the target fields as a temporary storage item key group, the processing unit traverses all the temporary storage item key groups of the selected forms and the corresponding forms and outputs the temporary storage item key group as an associated item structure, the associated item structure records field items of all the target fields, and the field items in the associated item structure are non-repeated, and And acquiring a plurality of items of information from the target database according to the associated item structure, and outputting the items of information as a result report.
  6. 6. The data processing system of claim 5, wherein the processing unit performs a key value analysis procedure on the selected form and the corresponding form according to the associated item structure, the key value analysis procedure obtains a temporary item key set from the selected form and the corresponding form, and the processing unit traverses the selected form and the corresponding form according to the temporary item key set to obtain the item information.
  7. 7. The data processing system of claim 5, wherein the processing unit further generates a graphical interface when executing the data program, the graphical interface receiving the target library selection request or the form selection request.
  8. 8. A data processing method, characterized in that the data processing method comprises: The terminal server is connected with data front-end equipment and comprises a processing unit; the terminal server selects a plurality of target databases from a database according to a target database selection requirement; the terminal server selects a selected form from the target database according to a form selection requirement; the terminal server acquires an associated project structure from the target database according to the selected form; selecting at least one target column from the selected form; the processing unit selects corresponding forms from other target databases according to the target columns, the selected forms are called corresponding forms, and the processing unit regards column items in the target columns as a temporary storage item key group; the processing unit traverses all the temporary storage item key groups of the selected forms and the corresponding forms and outputs the temporary storage item key groups as the associated item structure, the associated item structure records all the field items of the target field, and the field items in the associated item structure are non-repeated; the terminal server obtaining a plurality of item information from the target database according to the associated item structure, and The terminal server outputs the project information as a result report.
  9. 9. The data processing method of claim 8, wherein the step of selecting at least one target database from the databases at the terminal server according to the target database selection requirement comprises: the terminal server obtaining a connection path of the target database, and And the terminal server acquires the target database according to the connection path.
  10. 10. The data processing method of claim 9, wherein the step of obtaining the item information from the target database at the terminal server according to the associated item structure comprises: and the terminal server respectively performs a key value analysis program on the selected form and the corresponding form according to the associated project structure, and is used for obtaining the project information.
  11. 11. The data processing method of claim 9, wherein the step of outputting the item information as the result report at the terminal server comprises: And the terminal server writes the item information of the selected form and the item information of the corresponding form into the result report in sequence according to the associated item structure.

Description

Terminal server, data processing system and method Technical Field The present invention relates to a computer, a data processing system and a method thereof, and more particularly, to a data processing system and a method thereof for a terminal server and a database. Background As production automation steps, the factory will configure a computer (or workstation) for each product plant. The plant computer, in addition to controlling the operation of the production equipment in the plant, also records information about the production or data for checking the product. As the size of a plant expands, many different workshops are deployed in the same plant. Generally, different products have respective functional parameters, setting parameters or verification results in production (or inspection). And the back-end personnel acquire data information of production or verification of the specified product from the corresponding workshops and computers through the server. Or require assembly processes in different workshops for the same product. The databases of each plant are independent for different plants, and the configuration of the forms of each database is also different. Therefore, although the back-end personnel can acquire the forms from the data front-end equipment, the server cannot directly collect the forms into the same report, and the whole operation time is further prolonged. Disclosure of Invention Accordingly, in some embodiments, the terminal server is configured to collect related data of the data front-end device during the production process of the product, and generate a result report according to the data recorded by each form. In some embodiments, the terminal server includes a communication unit, a storage unit, and a processing unit. The communication unit is connected with the database of the data front-end equipment, the storage unit stores a data program, the processing unit is electrically connected with the communication unit and the storage unit, the processing unit executes the data program to select at least one target database from the databases according to the target database selection requirement, select a selected form from the forms of the target databases according to the form selection requirement, acquire an associated project structure from the selected form to the target databases, acquire a plurality of project information from the target databases according to the associated project structure, and output the project information as a result report. The terminal server may obtain the selected form from the data head-end equipment of the different workshops. The terminal server searches the associated item structure for other selected forms according to the selected form. The terminal server generates a result report according to the associated project structure, and writes the corresponding project information of each target database into the result report. In some embodiments, the processing unit searches a corresponding form from the target database according to the selected form, the processing unit selects a target form from the selected form and the corresponding form, the target form has the most column items, and the processing unit obtains the associated item structure according to the target form. In some embodiments, the processing unit performs a key value analysis procedure on the selected form and the corresponding form according to the associated item structure, the key value analysis procedure obtains a temporary item key set from the selected form and the corresponding form, and the processing unit traverses the selected form and the corresponding form according to the temporary item key set to obtain item information. In some embodiments, a data processing system includes a plurality of data head-end devices and a terminal server. The data front-end stores a database, and the database includes at least one form. The terminal server is provided with a communication unit, a storage unit and a processing unit, wherein the communication unit is connected with the data front-end equipment through a network, the processing unit executes a data program stored in the storage unit, the processing unit executes the data program of the storage unit to select at least one target database from the databases according to a target database selection requirement, select a selected form from forms of the target databases according to the form selection requirement, acquire an associated project structure from the target databases according to the selected form, acquire a plurality of project information from the target databases according to the associated project structure, and output the project information as a result report. In some embodiments, the processing unit further generates a graphical interface when executing the data program, the graphical interface receiving a target library selection request or a form selection request. In some embodiments, the data