Terminal server, data processing system and method
By connecting to multiple workshop databases via a terminal server, selecting and generating result reports, the problem of data aggregation difficulties caused by the independence of different workshop databases is solved, thus improving data processing efficiency.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- SHANGRAO LUXVISIONS INNOVATION TECH LTD
- Filing Date
- 2022-09-02
- Publication Date
- 2026-05-12
AI Technical Summary
In multi-workshop factories, each workshop has its own independent database and different form configurations, making it difficult for backend personnel to directly aggregate data and extending the operation time.
A terminal server is used to connect to the database of the data front-end device through a communication unit. The processing unit executes data programs, selects target databases and forms, and generates result reports to achieve data integration.
It has enabled the unified aggregation of data from different workshops, reduced the number of steps required for back-end personnel, and improved data processing efficiency.
Smart Images
Figure CN115543997B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to a computer, a data processing system and method, and more particularly to a data processing system and method for a terminal server and a database. Background Technology
[0002] With the advancement of production automation, factories equip each product workshop with a computer (or workstation). These workshop computers not only control the operation of production equipment in the workshop but also record relevant production information and product inspection data.
[0003] As factories expand, many different workshops are deployed within the same factory. Generally, different products have their own functional parameters, setting parameters, or verification results during production (or inspection). Backend personnel obtain production or verification data for specific products from the corresponding workshops and computers via servers.
[0004] Alternatively, the same product may require assembly in different workshops. Each workshop has its own independent database, and the form configurations differ. Therefore, while backend personnel can retrieve forms from various frontend devices, the server cannot directly aggregate these forms into a single report, thus extending the overall processing time. Summary of the Invention
[0005] In view of this, in some embodiments, the terminal server is used to aggregate relevant data from the data front-end device during the product manufacturing process and generate result reports based on the data recorded in each form.
[0006] In some embodiments, the terminal server includes a communication unit, a storage unit, and a processing unit. The communication unit is connected to the database of the data front-end device; the storage unit stores data programs; the processing unit is electrically connected to the communication unit and the storage unit. The processing unit executes the data programs to select at least one target database from the database according to target database selection requirements; selects a selected form from the forms in the target database according to form selection requirements; obtains the associated project structure from the target database based on the selected form; obtains multiple project information entries from the target database based on the associated project structure, and outputs the project information as a result report. The terminal server can obtain the selected forms from data front-end devices in different workshops. The terminal server searches for the associated project structure of other selected forms based on the selected forms. The terminal server generates a result report based on the associated project structure and writes the corresponding project information from each target database into the result report.
[0007] In some embodiments, the processing unit searches for the corresponding form in the target database based on the selected form, selects the target form from the selected form and the corresponding form, and the target form has the most field items. The processing unit obtains the associated item structure based on the target form.
[0008] In some embodiments, the processing unit performs key-value parsing on the selected form and the corresponding form according to the associated project structure. The key-value parsing program obtains temporary project key groups from the selected form and the corresponding form. The processing unit then traverses the selected form and the corresponding form to obtain project information based on the temporary project key groups.
[0009] In some embodiments, the data processing system includes multiple data front-end devices and a terminal server. The data front-end devices store a database, and the database includes at least one form. The terminal server has a communication unit, a storage unit, and a processing unit. The communication unit is network-connected to the data front-end devices. The processing unit executes a data program stored in the storage unit to select at least one target database from the database according to target database selection requirements; select a selected form from the forms in the target database according to form selection requirements; obtain the associated project structure from the target database based on the selected form; obtain multiple project information entries from the target database based on the associated project structure; and output the project information as a result report.
[0010] In some embodiments, when the processing unit executes the data program, it generates a graphical interface that receives a target library selection request or a form selection request.
[0011] In some embodiments, the data processing method includes the following steps: a terminal server is connected to a data front-end device; the terminal server selects at least one target database from the database according to target database selection requirements; the terminal server selects a selected form from the target database according to form selection requirements; the terminal server obtains the associated project structure from the target database according to the selected form; the terminal server obtains multiple project information entries from the target database according to the associated project structure; and the terminal server outputs the project information as a result report.
[0012] In some embodiments, the step of the terminal server selecting at least one target database from the database according to the target database selection requirements includes: the terminal server obtaining the connection path of the target database; and the terminal server obtaining the target database according to the connection path.
[0013] In some embodiments, the step of the terminal server obtaining the associated project structure from the target database based on the selected form includes: the terminal server searching for the corresponding form in the target database based on the selected form; the terminal server selecting the target form from the selected form and the corresponding form, wherein the target form has the most field items.
[0014] In some embodiments, the step of the terminal server obtaining the project information from the target database according to the associated project structure includes: the terminal server performing a key-value parsing program on the selected form and the corresponding form respectively according to the associated project structure; the key-value parsing program obtaining temporary project key groups from the selected form and the corresponding form; and the processing unit traversing the selected form and the corresponding form according to the temporary project key groups to obtain project information.
[0015] The aforementioned terminal server, data processing system, and processing method can be applied to the detection and processing of the same production function for various different products. The terminal server collects and integrates data from the production or detection records of different production machines, and from various products with the same production or detection process. Therefore, back-end personnel do not need to retrieve and aggregate the records of each production machine individually.
[0016] The present invention will be described in detail below with reference to the accompanying drawings and specific embodiments, but this is not intended to limit the present invention. Attached Figure Description
[0017] Figure 1 This is a schematic diagram of a data processing system architecture according to one embodiment.
[0018] Figure 2 This is a schematic diagram of a database and form structure as an example.
[0019] Figure 3 This is a flowchart illustrating a data processing method according to one embodiment.
[0020] Figure 4 This is a schematic diagram illustrating the expansion of a temporary item key group in one embodiment.
[0021] Figure 5 This is a schematic diagram of the associated project structure and result report in one embodiment.
[0022] Figure 6 This is a flowchart illustrating the process of obtaining the structure of associated projects in one embodiment.
[0023] In the attached figures, the following labels are used:
[0024] 100: Data Processing System
[0025] 200: Data front-end equipment
[0026] 210: Database
[0027] 211: Target Database
[0028] 220: Form
[0029] 221: Selected Form
[0030] 241. A, B: Target fields
[0031] 242: Column Items
[0032] 243: Temporary Item Key Group
[0033] 223: Corresponding form
[0034] 300: Terminal Server
[0035] 310: Communication Unit
[0036] 320: Storage Unit
[0037] 321: Data Program
[0038] 322: Results Report
[0039] 323: Related Project Structure
[0040] 330: Input Unit
[0041] 340: Processing Unit
[0042] S310~S360, S610~S640: Steps Detailed Implementation
[0043] Please refer to Figure 1 The diagram shown illustrates the architecture of a data processing system according to one embodiment. The data processing system 100 includes multiple data front-end devices 200 and a terminal server 300. The data front-end devices 200 are network-connected to the terminal server 300. The data front-end devices 200 are used to acquire relevant information about workshop production equipment. The data front-end devices 200 can be, but are not limited to, workshop machines, personal computers, or workstations. The data front-end devices 200 can be connected to the terminal server 300 via a local area network (LAN), the Internet, an industrial Ethernet network, or interconnected via a communication bus.
[0044] The data front-end device 200 has a database 210. The database 210 is not limited to SQL or SQLite. The database 210 has at least one form 220. Each form 220 records attribute fields during product manufacturing or inspection, such as product number, data entry time, serial number, component category, or setting parameters. Each attribute field records at least one field item 242. Field item 242 stores the corresponding value of the data front-end device 200 during product production (or inspection). Please refer to... Figure 2 The diagram shown is a schematic representation of the database 210 and form 220 structure in one embodiment.
[0045] Figure 2 This is a schematic interface for the database 210 program. Figure 2 The left side shows a tree menu of different forms 220, where the gray part represents the selected form 220 (i.e., the selected form 221 mentioned later). Figure 2 The right side displays multiple records from the selected form 220 and related information for each record. Each form 220 has at least one target field 241, which has at least one field item 242. Therefore, the field items 242 of each target field 241 may be completely different, or they may have some identical field items 242. Figure 2 The forms 220, field items 242 and target field 241 are for illustrative purposes only and are not limited to this content, location, path or quantity.
[0046] The terminal server 300 includes a communication unit 310, a storage unit 320, an input unit 330, and a processing unit 340. The processing unit 340 is electrically connected to the communication unit 310, storage unit 320, and input unit 330. The communication unit 310 is network-connected to the data front-end device 200 and receives forms 220 from the data front-end device 200. The storage unit 320 stores the data program 321 and the received forms 220. The input unit 330 receives target library selection requests and form selection requests. The input unit 330 can be, but is not limited to, a human interface device, or a connection program for access. A remote computer network is connected to the terminal server 300, and the user can access the terminal server 300 through connection programs such as remote desktop, command line interface (or terminal), or web service to execute the data program 321. For example, a user can operate the terminal server 300 on-site using a keyboard and mouse. Alternatively, the user can connect to the terminal server 300 via a network connection using a laptop.
[0047] The terminal server 300 receives the target database selection request and form selection request, which are used to select the database 210 and form 220 of the data front-end device 200. For further explanation of the overall operation process, please refer to [link to relevant documentation]. Figure 3 The diagram shown is a flowchart of a data processing method according to one embodiment. The data processing method includes the following steps.
[0048] The terminal server receives the target database selection request and form selection request, which are used to select the database and form for the data front-end device. For further explanation of the overall operation process, please refer to [link to relevant documentation]. Figure 3 The diagram shown is a flowchart illustrating a data processing method according to one embodiment. The data processing method includes the following steps:
[0049] Step S310: The terminal server connects to the data front-end device;
[0050] Step S320: The terminal server selects at least one target database from the database according to the target database selection requirements;
[0051] Step S330: The terminal server selects the desired form from the forms in the target database according to the form selection requirements;
[0052] Step S340: The terminal server retrieves the associated project structure from the target database based on the selected form;
[0053] Step S350: The terminal server retrieves multiple project information entries from the target database based on the associated project structure; and
[0054] Step S360: The terminal server outputs the project information as a result report.
[0055] First, the terminal server 300 connects to the data front-end device 200 and executes the data program 321 to wait for the target library selection request and form selection request. The data program 321 can generate a graphical interface; please refer to [reference needed]. Figure 3 As shown. The graphical interface provides visual options for users to select the database 210 of the data front-end device 200 and the forms 220 of each database 210. The selection tools for the data front-end device 200, database 210, and forms 220 in the graphical interface are used to receive the target database selection request or the form selection request and respond to the processing unit 340. The selection tools can be drop-down menus, checkboxes, radio buttons, or file selectors. The graphical interface obtains the connection path of the target database 211 according to the target database selection request. The processing unit 340 drives the communication unit 310 to connect to the target database 211 via the network according to the connection path and obtains the forms 220 of the target database 211. Furthermore, the graphical interface can also set the output path for result reports.
[0056] After receiving the target database selection request and the form selection request, the terminal server 300 selects the data front-end device 200 and the database 210 according to the target database selection request. The selected database 210 is referred to as the target database 211. The terminal server 300 selects a form 220 from the forms 220 in the target database 211 according to the form selection request; this selected form 220 is referred to as the selected form 221. Figure 1 As shown.
[0057] Processing unit 340 selects at least one attribute field from the selected form 221 and treats the selected attribute field as the target field 241. Please refer to [reference needed]. Figure 2 The processing unit 340 can be from Figure 2 In "Form 1" (i.e., the selected form 221), "Attribute Field _A" is selected as the target field 241. The processing unit 340 treats the field items 242 in the target field 241 as a temporary item key group 243. The processing unit 340 selects the corresponding form 220 from other target databases 211 based on the target field 241, and the selected form 220 is called the corresponding form 223. The selection method of the corresponding form 223 is based on the field items 242 of the target field 241 of the selected form 221, or by using the same target field 241 name. When the field items 242 of the target field 241 of other forms 220 at least contain the field items 242 of the target field 241 of the selected form 221, the processing unit 340 lists this form 220 as the corresponding form 223. Processing unit 340 iterates through the target fields 241 of the selected form 221 and the target fields 241 of the corresponding form 223 according to the temporary item key group 243. Processing unit 340 retrieves field items 242 that are not present in the temporary item key group 243 from the target fields 241 of the corresponding form 223, and adds the newly retrieved field items 242 to the temporary item key group 243. Please refer to [reference needed]. Figure 4 As shown.
[0058] exist Figure 4 The top section contains the preset target field 241 (hereinafter referred to as target field A) and the temporary item key group 243 (corresponding to...). Figure 4 (The dashed box in the text). Temporary item key group 243 is a combination of field item_001, field item_003, field item_005 and field item_007 of target field A. Figure 4 For illustrative purposes only, the names and number of the selected form 221, the corresponding form 223, and the field items 242 are not limited to these. Figure 4In the middle are other target fields 241 (hereinafter referred to as target field B) and their corresponding field items 242 (including field items _001, _002, and _003). Processing unit 340 compares the temporary item key group 243 with the target field B. Processing unit 340 adds field items 242 that do not exist in the temporary item key group 243 to the temporary item key group 243. In other words, processing unit 340 adds field items 242 selected from target field B to the temporary item key group 243 of target field A. After processing unit 340 traverses the selected form 221 and its corresponding form 223, processing unit 340 can obtain the following... Figure 4 The new temporary item key group 243 is shown below. The processing unit 340 will traverse all the temporary item key groups 243 of the selected forms 221 and their corresponding forms 223 and output them as an associated item structure 323. The associated item structure 323 records the field items 242 of all target fields 241, and the field items 242 in the associated item structure 323 are unique.
[0059] Next, processing unit 340 performs a key-value pair parsing procedure on the selected form 221 and the corresponding form 223 according to the associated item structure 323. Processing unit 340 considers the field item 242 of the associated item structure 323 as the primary key. Processing unit 340 reads the target field 241 of the selected form 221 and the corresponding form 223 according to the associated item structure 323. The field item 242 in the target field 241 records its corresponding value or information, which is called the item information (value). Processing unit 340 reads the corresponding field item 242 in the target field 241 according to the associated item structure 323 and obtains the item information recorded in the field item 242, referring to... Figure 5 As shown. Figure 5 The first row of the table is... Figure 4 The associated item structure 323 is obtained by transposing the temporary item key group 243. In other words, the associated item structure 323 is the result of traversing all selected forms 221 and their corresponding forms 223 and then the temporary item key group 243.
[0060] Processing unit 340 can pre-create result report 322 before reading form 220, or it can create result report 322 after completing the associated item structure 323. Processing unit 340 reads item information from the selected form 221 and the corresponding form 223 based on the primary key values contained in the associated item structure 323. Processing unit 340 writes the read item information sequentially into result report 322 according to the order in which the primary key values are set, such as... Figure 5 As shown. In Figure 5 The second row is the corresponding Figure 4 The information for each item in the selected form 221. Similarly, Figure 5 The third row is the corresponding Figure 4 The information for each item in the corresponding form 223. Since the selected form 221 and the corresponding form 223 in Figure 4 each display a single set of records, Figure 5 Only the second and third rows of item information are generated. Generally, the processing unit 340 reads all records of the selected form 221 or the corresponding form 223 sequentially according to the associated item structure 323. The processing unit 340 writes all the read records and item information sequentially (or in batches) into the result report 322. The result report 322 can be a plain text file, an EXCEL file, or a CSV file (Comma-Separated Values file), etc.
[0061] After processing unit 340 completes recording of result report 322, it sends result report 322 to the user source according to the target library selection requirements or form selection requirements. If the user source is a direct access terminal server 300, the terminal server 300 can output result report 322 to a display. If the user source is connected to terminal server 300 via the Internet, terminal server 300 transmits result report 322 to the user source through communication unit 310 and plays result report 322 in the user source's browser.
[0062] In some embodiments, the processing unit 340 can select the associated project structure 323 in the following manner. After obtaining the selected form 221 and the target field 241, the processing unit 340 selects other corresponding forms 223 based on the target field 241. Please cooperate. Figure 6 As shown, obtaining the associated project structure 323 includes the following steps:
[0063] Step S610: The processing unit retrieves the corresponding form from the target database based on the selected form;
[0064] Step S620: The processing unit selects the target form from the selected forms and the corresponding forms, and the target form has the most field items;
[0065] Step S630: The processing unit generates the associated item structure based on the target field of the target form;
[0066] Step S640: The processing unit compares the selected form with the corresponding form according to the associated project structure, and obtains the field items in the associated project structure that are not recorded, until all forms are completed.
[0067] Processing unit 340 selects a target form from the selected forms 221 and the corresponding forms 223, and the target form has the most field items 242. Processing unit 340 compares the number of target fields 241 and field items 242 in the selected forms 221 and the corresponding forms 223. Processing unit 340 compares the number of field items 242 in the target fields 241 of the aforementioned forms 220. Processing unit 340 selects the target field 241 with the most field items 242 from all forms 220, and the form 220 to which it belongs is the target form. Processing unit 340 obtains the associated item structure 323 based on the target field 241 with the most field items.
[0068] Processing unit 340 compares the field items 242 of the selected form 221 and the corresponding form 223 according to the associated item structure 323 of the target form. Processing unit 340 retrieves field items 242 that are not present in the associated item structure 323 from the target field 241 of other forms 220. After traversing the selected form 221 and the corresponding form 223, processing unit 340 obtains the final associated item structure 323. After obtaining the associated item structure 323, processing unit 340 executes steps S350 and S360 to obtain item information from the selected form 221 and the corresponding form 223.
[0069] The terminal server 300, data processing system 100, and processing method described above can be applied to the detection and processing of the same production function for various different products. The terminal server 300 collects and integrates data from the production or detection records of different production machines and various products with the same production or detection process. Therefore, back-end personnel do not need to retrieve and aggregate the records of each production machine individually.
[0070] Of course, the present invention may have other various embodiments. Without departing from the spirit and essence of the present invention, those skilled in the art can make various corresponding changes and modifications according to the present invention, but these corresponding changes and modifications should all fall within the protection scope of the claims of the present invention.
Claims
1. A terminal server, characterized in that... The terminal server is used to connect multiple data front-end devices, each of which includes a database. The terminal server includes: A communication unit is connected to the database of the data front-end device; A storage unit stores a data program; and A processing unit, electrically connected to the communication unit and the storage unit, executes the data program to... Multiple target databases are selected from the database according to a target database selection requirement; Select a candidate form from the target database according to a form selection requirement; Based on the selected form, obtain an associated project structure from the target database; The processing unit selects at least one target field from the selected forms. Based on the target field, the processing unit selects corresponding forms from other target databases. The selected forms are called the corresponding forms. The processing unit treats the field items in the target field as a temporary item key group. The processing unit iterates through all the temporary item key groups of the selected forms and the corresponding forms and outputs them as the associated item structure. The associated item structure records the field items of all the target fields, and the field items in the associated item structure are unique. Based on the associated project structure, multiple project information entries are retrieved from the target database, and the project information is output as a result report.
2. The terminal server as described in claim 1, characterized in that, The data front-end equipment mentioned above can be workshop machines, personal computers, or workstations.
3. The terminal server as described in claim 1, characterized in that, It further includes an input unit, to which the processing unit is electrically connected, and the input unit receives the target library selection request or the form selection request.
4. The terminal server as described in claim 1, characterized in that, The processing unit performs a key-value parsing procedure on the selected form and the corresponding form respectively according to the associated project structure. The key-value parsing procedure obtains a temporary project key group from the selected form and the corresponding form. The processing unit traverses the selected form and the corresponding form according to the temporary project key group to obtain the project information.
5. A data processing system, characterized in that, The data processing system includes: Multiple data front-end devices, each storing a database, wherein the database includes at least one form; and A terminal server includes a communication unit, a storage unit, and a processing unit. The processing unit is electrically connected to the communication unit and the processing unit. The communication unit is network-connected to the data front-end device and the database. The processing unit executes a data program stored in the storage unit. The processing unit receives a target database selection request and a form selection request. The processing unit executes the data program to... Select multiple target databases from the database according to the target database selection requirements; Select a form from the forms in the target database according to the form selection requirements; Based on the selected form, obtain an associated project structure from the target database; The processing unit selects at least one target field from the selected forms. Based on the target field, the processing unit selects corresponding forms from other target databases. The selected forms are called the corresponding forms. The processing unit treats the field items in the target field as a temporary item key group. The processing unit iterates through all the temporary item key groups of the selected forms and the corresponding forms and outputs them as the associated item structure. The associated item structure records the field items of all the target fields, and the field items in the associated item structure are unique. Based on the associated project structure, multiple project information entries are retrieved from the target database, and the project information is output as a result report.
6. The data processing system as described in claim 5, characterized in that, The processing unit performs a key-value parsing procedure on the selected form and the corresponding form respectively according to the associated project structure. The key-value parsing procedure obtains a temporary project key group from the selected form and the corresponding form. The processing unit traverses the selected form and the corresponding form according to the temporary project key group to obtain the project information.
7. The data processing system as described in claim 5, characterized in that, When the processing unit executes the data program, it generates a graphical interface that receives the target library selection request or the form selection request.
8. A data processing method, characterized in that, The data processing method includes: A terminal server is connected to a data front-end device, and the terminal server includes a processing unit; The terminal server selects multiple target databases from a database according to a target database selection requirement; The terminal server selects a form from the target database according to a form selection requirement; The terminal server retrieves an associated project structure from the target database based on the selected form; Select at least one target field from the selected form; The processing unit selects the corresponding form from other target databases according to the target field. The selected form is called the corresponding form. The processing unit regards the field items in the target field as a temporary item key group. The processing unit traverses all the selected forms and the corresponding forms's temporary item key groups and outputs them as the associated item structure. The associated item structure records all the field items of the target fields, and the field items in the associated item structure are unique. The terminal server retrieves multiple project information entries from the target database based on the associated project structure; and The terminal server outputs the project information as a result report.
9. The data processing method as described in claim 8, characterized in that, The step of selecting at least one target database from the database by the terminal server according to the target database selection requirements includes: The terminal server obtains a connection path to the target database; and The terminal server obtains the target database based on the connection path.
10. The data processing method as described in claim 9, characterized in that, The step of retrieving project information from the target database on the terminal server based on the associated project structure includes: The terminal server performs a one-click value parsing process on the selected form and the corresponding form respectively according to the associated project structure to obtain the project information.
11. The data processing method as described in claim 9, characterized in that, The step of outputting the project information as the result report on the terminal server includes: The terminal server sequentially writes the project information of the selected form and the project information of the corresponding form into the result report according to the associated project structure.