TWM613557U - Integration device for external data - Google Patents

Abstract

The present model provides an integrated device for externally received data, which is installed in a computer and includes: a database, an acquisition module, a comparison module, and a tabulation module. The database stores internal previous period data and internal current period data. The internal previous period data and internal current period data respectively have multiple internal previous period fields and multiple internal current period fields. The internal current period fields include all internal previous period fields. . The capture module captures external data to obtain and output multiple external data fields. The comparison module compares the external data field with the internal current field, and compares the internal current field with the internal previous field to output edit marks or delete marks for each internal current field. The tabulation module receives the internal current field and the corresponding edit mark and delete mark to output the internal table.

Description

Integration device for external data

The invention relates to an integration device for externally received data, in particular to an integrated device that can output an internal alignment table with better readability according to the editing status of the externally received data in the current period.

In addition to the public format fields, data from outside the system may contain various other fields, which cannot be predicted in advance. Therefore, when a large amount of external data is introduced at the same time, it takes a lot of time and manpower to organize the data, and it may also cause errors in data integration due to human judgment errors.

Therefore, how to automatically receive and efficiently align external data containing various other fields without excessively restricting the format of external data, and quickly output alignment that can be interpreted by the system according to various external data Format data has become a problem to be solved in the technical field.

In order to solve the above-mentioned problems, the embodiment of the present invention provides an integrated device for externally received data, which can be installed in a computer or various mobile devices. After the external data is received by the external data integration device, the external data field of the external data is further compared with the internal current field and internal previous field stored in the database, so as to add for each internal current field. Note the mark. The integration device for externally received data can output various internal forms with better readability according to the marks corresponding to each internal current field.

Specifically, an embodiment of the present invention provides an integrated device for externally received data, which is installed in a computer or a mobile device, and includes: a database, an acquisition module, a comparison module, and a tabulation module. The above database is used to store internal previous period data and internal current period data. The above internal previous period data has multiple internal previous period fields, and the above internal current period data has multiple internal current period fields. The internal current period fields include All internal pre-columns. The above-mentioned capture module is used to capture external data from the user to obtain and output multiple external data fields of the external data. The above comparison module is used to communicate with the acquisition module to receive external data fields, and to communicate with the database to retrieve internal current fields and internal previous fields to compare external data fields with internal current fields. Period field, and compare the internal current period field with the internal previous period field to output edit mark or delete mark for each internal current period field. The above-mentioned tabulation module is used to communicate with the comparison module to receive the internal current field and the corresponding edit mark and delete mark to output the internal table based on the internal current field and the corresponding edit mark and delete mark.

According to an embodiment, the above-mentioned comparison module compares whether any external data field appears in the internal current period field to output edit marks to the corresponding internal current period field respectively.

According to another embodiment, when it is determined that any external data field appears in the internal current field, the above-mentioned comparison module outputs the edit mark according to the external data field that appears in the internal current field. To the corresponding internal current period column.

According to another embodiment, when it is determined that any external data field does not appear in the internal current field, the comparison module adds the external data field that does not appear in the internal current field to the internal current field. In the period field, and corresponding to the newly added internal current period field, the edit marks are output respectively.

According to another embodiment, the above-mentioned comparison module compares whether any updated internal current field without edit mark appears in the internal previous field, and targets each updated internal current field without edit mark. In the period field, output the edit mark or delete mark respectively.

According to another embodiment, when it is determined that any of the updated internal current-period fields appear in the internal previous-period field, the above-mentioned comparison module is for each updated post-update that appears in the internal prior-period field but has no edit mark The internal current fields of, respectively output deletion marks.

According to another embodiment, when it is determined that any of the updated internal current-period fields does not appear in the internal previous-period field, the above-mentioned comparison module is more specific to those that do not appear in the internal prior-period field and have no edit mark. The updated internal current field will output the delete mark respectively.

According to another embodiment, the above-mentioned comparison module further obtains the field change rate corresponding to the current field in the internal current period based on the edit mark and the delete mark, so as to compare the field change rate with the field change threshold value, and determine whether Output internal table.

According to another embodiment, when it is determined that the field change rate is not greater than the field change threshold, the tabulation module outputs an internal table.

According to another embodiment, when it is determined that the field change rate is greater than the field change threshold, the capture module confirms whether there is updated external data from the user for the comparison module to compare and update again The external data field of, and corresponding to each internal current field, output edit mark or delete mark.

Combining the technical features of the above embodiments, the following effects can be achieved:

(1) By comparing the external data field with the internal current period field and the internal previous period data respectively, the corresponding or newly added internal current period field can be marked for editing or deletion. Therefore, the embodiment of the present invention can clearly know the editing status of each external data field, without manually confirming the external data field of each external data one by one. Therefore, the embodiment of the present invention can greatly save the time and cost of manual integration of external data and judgment.

(2) Through the editing or deletion of the internal current data, the embodiment of the present invention can output various internal forms according to the needs of the relevant personnel for subsequent use or interpretation by the relevant personnel. Therefore, the embodiment of the present invention can better review the current field, the previous field, and even the fields of each period of the external data, and can effectively save the extra time and cost of manual sorting of the fields.

(3) Calculate the field change rate through the field change formula, edit and delete notes of each internal field in the current period, and further compare the field change rate with the field change threshold value to screen external The degree of change in the data field, and determine whether the internal table can be output or the external data needs to be retrieved again. In other words, the embodiment of the present invention can confirm the degree of change or omission of external data to ensure that each external data has a certain quality before it is made into an internal table.

In view of the above-mentioned problems to be overcome, the embodiment of the present invention develops an integrated device for external data collection, which can be installed in a computer or various mobile devices to quickly or even at any time receive external data from outside the device, and retrieve Get the external data field in the external data. The external data field will be compared with the internal data in the database. The internal data field can include the internal current period field and the internal previous period field, and the internal current period field is composed of all the internal previous period fields. . In other words, as long as the fields that have appeared in the past, they will all appear in the internal current field. Therefore, as long as you compare each external data field with the internal current field, you can know whether each external data field has appeared in the past, or whether it is a new field that needs to be re-displayed in the internal current field. Create a new field.

According to the comparison between different external data fields and internal current data, output the corresponding edit marks or corresponding edit marks for all the internal current fields (even the new internal current fields corresponding to the external data fields) Delete the mark. In this way, the embodiment of the present invention can output various internal tables by editing the mark or deleting the mark for reference and judgment by the relevant personnel. Therefore, the embodiment of the present invention can confirm the source format of the external data, and automatically align the fields according to the format specified in the integrated device before outputting. In addition to saving unnecessary manual processing time and cost, It is more effective to integrate external data in a systematic way and save and build files.

In order to more clearly illustrate the embodiments of the present invention, the following descriptions are supplemented with drawings.

Please refer to FIGS. 1 and 3. FIG. 1 depicts a flow diagram of a method 100 for integrating external data according to an embodiment of the present invention, and FIG. 3 depicts a schematic diagram of external data integration according to an embodiment of the present invention. Schematic diagram of the integrated device 200. In FIG. 3, according to an embodiment, an integrated device 200 for externally receiving data is provided, which can be installed in a computer, a mobile device, or a wearable device in any position. Therefore, the embodiment of the present invention can receive external data at any point in time and at any place, so as to automatically output an internal table that can be aligned with the internal standard format, and allow relevant personnel to interpret according to the internal table.

The integration device 200 for externally receiving data may include a database 220, an acquisition module 210, a comparison module 230, and a tabulation module 240.

The database 220 may store internal previous-period data and internal current-period data including multiple periods. Each internal previous period data can have multiple internal previous period fields, and the internal current period data has multiple internal current period fields. The internal current period field includes all internal previous period fields. The following Table 1 is an example. Table 1 is an example of the internal previous period field and the internal current period field. According to the time sequence received by the integration device 200 for external data, it can be divided into the earliest received internal period 1 field, The internal phase 2 field and internal phase 3 field received later, up to the internal phase 4 field received at the latest (also referred to as the internal previous period field). And integrate all the fields from period 1 to period 4 and integrate them into internal current period fields; that is to say, the internal current period fields will have all the fields that have appeared in the first to fourth periods. And arrange the fields in order.

Table 1 Examples of internal previous-period fields and internal current-period fields Internal history field Internal Phase 1 Column name 1 2 3 Internal Phase 2 Column name 1 2 4 Internal Phase 3 Column name 2 3 5 6 Internal pre-column Internal Phase 4 Column name 1 2 3 4 7 Internal current field name 1 2 3 4 5 6 7 External data field (the 5th period field) name 1 3 8 9

The capture module 210 performs step 110 in FIG. 1 to capture external data from the user 300 to obtain and output the external data field of the external data. For example, in Table 1 above, the external data field has fields 1, 3, and 8-9. The comparison module 230 is used to communicate with the capture module 210 to receive external data fields. In addition, the comparison module 230 is also used to communicate with the database 220 to perform step 120 to retrieve the internal current field and internal previous field to compare each internal current field with the external data field. Yes, and compare the internal current field with the internal previous field to output edit marks or delete marks for each internal current field. Among them, the edit mark or delete mark can be any number, symbol, letter or any combination thereof that can be recognized and read by a computer, and there is no limitation here. According to an embodiment, the edit mark or delete mark may be English letters, for example. According to another embodiment, the edit mark may be N, and the deletion mark may be Y, for example.

According to another embodiment, the comparison module 230 executes step 130 to compare whether each external data field has ever appeared in the internal current period field to output edit marks to the internal current period column corresponding to the external data field. Bit. For example, in step 131, when it is determined that any external data field has appeared in the internal current period field, the comparison module 230 is used to perform the comparison based on the external data appearing in the internal current period field. Field, respectively output the edit mark to the corresponding internal current field.

For example, in Table 1 above, the comparison module 230 compares whether fields 1, 3, and 8-9 of the external data field appear in fields 1-7 of the internal current field one by one. , To judge whether to output edit mark or delete mark. More specifically, if the fields 1 and 3 of the external data field appear in the internal current field, the comparison module 230 corresponds to the fields 1 and 3 in the internal current field, and outputs the edit mark (for example, N), organize the following table 2. Among them, after completing the comparison judgment at this stage, you can know that fields 1 and 3 may be "reserved" or "reappearing" fields.

Table 2 Example of internal current field after completing steps 130-131 Internal current field name 1 2 3 4 5 6 7 mark N N External data field (the 5th period field) name 1 3 8 9

Or, for example, perform step 132, when it is determined that any external data field does not appear in the internal current period field, that is, it is determined that there is an external data field that does not appear in each internal period field. In the case of fields, the comparison module 230 is used to add external data fields that do not appear in the internal current period field to the internal current period field to update the internal current period field. Furthermore, the comparison module 230 is further used to output edit marks for the newly added internal current fields respectively. Among them, the module 230 must output the updated internal current field to the database 220 to store the updated internal current field.

For example, in Table 2 above, none of the fields 8-9 of the external data field appear in the internal current period field, then the comparison module 230 is used to add the fields 8-9 to the internal current period In the field, output the edit mark (for example, N) corresponding to the fields 8-9 of the internal current field to update the internal current field, as shown in Table 3 below.

Table 3 Examples of internal current period columns after completing step 132 Internal current field name 1 2 3 4 5 6 7 8 9 mark N N N N External data field (the 5th period field) name 1 3 8 9

For another example, after finishing updating the internal current period field, step 140 is then executed, and the comparison module 230 is used to compare whether the internal current period field without the edit mark appears in the internal previous period field. According to an embodiment, the comparison module 230 is performed in step 141 to target the internal current field that appears in the internal previous field but has no edit mark (that is, the internal previous field exists, but the internal current field Fields whose data has been deleted), respectively output deletion marks. Or according to another embodiment, the comparison module 230 can also be used as step 142 to target the internal current field that does not appear in the internal previous field and does not have an edit mark (that is, the internal previous field has already been marked). Delete, the internal current data is also a deleted field), respectively output the edit mark.

For example, in Table 1 and Table 3 above, the comparison module 230 then compares the fields 2 and 4-7 that are not marked for editing in the internal current field one by one to determine whether the fields 2 and 4-7 are consistent with each other. Appears in the internal pre-column to output edit marks or delete marks. More specifically, compared with the internal previous period field (that is, the internal fourth period field in Table 3), the fields 2, 4, and 7 without edit marks appear in the internal previous period field, then the comparison module 230 outputs a delete mark (for example, Y) corresponding to fields 2, 4, and 7, as shown in Table 4 below. Among them, after completing the comparison judgment at this stage, you can know that the fields 2, 4, and 7 may be "this time delete" fields.

Table 4 Examples of internal current period columns after completing step 141 Internal pre-column Internal Phase 4 Column name 1 2 3 4 7 Internal current field name 1 2 3 4 5 6 7 8 9 Label N Y N Y Y N N External data field (the 5th period field) name 1 3 8 9

For another example, compared with the internal pre-period field (ie the internal fourth-period field in Table 3), the fields 5 and 6 without edit marks do not appear in the internal pre-period field, then compare the module 230 outputs edit marks (for example, N) corresponding to fields 5 and 6, as shown in Table 5 below. Among them, after completing the comparison judgment at this stage, you can know that the fields 2, 4, and 7 may be "this time delete" fields.

Table 5 Example of internal current field after completing step 142 Internal pre-column Internal Phase 4 Column name 1 2 3 4 7 Internal current field name 1 2 3 4 5 6 7 8 9 Label N Y N Y N N Y N N External data field (the 5th period field) name 1 3 8 9

Then, perform step 150, the comparison module 230 confirms whether all the external data fields have been compared, and whether all the updated internal current fields have been compared, and have their respective edit annotations or Delete the label. When there are still uncompleted external data fields or updated internal current-period fields, return to step 130 until all external data fields or updated internal current-period fields have been compared. Correct.

When all the external data fields or the updated internal current field have been compared, the tabulation module 240 can perform step 170, communicate with the comparison module 230, and receive the internal current field and The corresponding edit mark and delete mark are used to output the internal table to the user 300 and save the internal table to the database 220 based on the internal current field and the corresponding edit mark and delete mark. The internal table can be the table shown in the following examples, and it is not limited here, and it can be determined according to the needs of the user 300 or other related personnel.

For example, based on the data in Table 1 above, an example of an internal table can be a collation table of edit marks and delete marks for each internal period column, as shown in Table 5 below.

Table 5 An example of an internal table: a collated table for editing marks and deleting marks name 1 2 3 4 5 6 7 8 9 Internal Phase 1 Column N N N N N N N N N Internal Phase 2 Column N N Y N N N N N N Internal Phase 3 Column Y N N Y N N N N N Internal Phase 4 Column N N N N Y Y N N N Internal Phase 5 Column N Y N Y N N Y N N

Or, for example, based on the data in Table 1 above, an example of an internal table can be to fill in the value corresponding to each field in each period field, as shown in Table 6 below.

Table 6 Example of internal table: the actual value of each internal period field name 1 2 3 4 5 6 7 8 9 Internal Phase 1 Column 0.1 0.2 0.1 N/A N/A N/A N/A N/A N/A Internal Phase 2 Column 0.1 0.1 N/A 0.3 N/A N/A N/A N/A N/A Internal Phase 3 Column N/A 0.4 0.5 N/A 0.1 0.1 N/A N/A N/A Internal Phase 4 Column 0.1 0.5 0.6 0.7 N/A N/A 0.3 N/A N/A Internal Phase 5 Column 0.1 N/A 0.3 N/A N/A N/A N/A 0.8 0.9 Marking of the 5th period field N Y N Y N N Y N N

Or, for example, based on the data in Table 1 above, an example of an internal table can be to select and display specific fields only, and fill in the values corresponding to the specific fields in the internal period fields. For example, in Table 7 below, only the fields 1, 3, and 8-9 covered by the field for the latest external data reception (that is, the field for the internal period 5) are selected.

Table 7 An example of an internal table: the actual value of a specific field of each internal period field name 1 3 8 9 Internal Phase 1 Column 0.1 0.1 N/A N/A Internal Phase 2 Column 0.1 N/A N/A N/A Internal Phase 3 Column N/A 0.5 N/A N/A Internal Phase 4 Column 0.1 0.6 N/A N/A Internal Phase 5 Column 0.1 0.3 0.8 0.9

Or, for example, based on the data in Table 1 above, the example of the internal table can be to fill in the value corresponding to each field of each period in the internal field, and use color blocks to reflect the changes in the field of each period, sorted as follows Table 8. Among them, light gray indicates the new field in the current period, darker gray indicates the change from the previous edit mark to the current deletion mark (for example, from N to Y), and dark gray indicates the previous deletion mark Change to the current editing status (for example, change from Y to N).

Table 8 Example of internal table: the actual value and color block reflection of each internal period field name 1 2 3 4 5 6 7 8 9 Internal Phase 1 Column 0.1 0.2 0.1 Internal Phase 2 Column 0.1 0.1 0.3 Internal Phase 3 Column 0.4 0.5 0.1 0.1 Internal Phase 4 Column 0.1 0.5 0.6 0.7 0.3 Internal Phase 5 Column 0.1 0.3 0.8 0.9

In addition, according to an embodiment, please refer to FIG. 2 and FIG. 3. FIG. 2 is a flowchart of the method for determining the field change in the method for integrating external data according to an embodiment of the present invention. The comparison module 230 can, as in step 160, be further used to obtain the field change rate corresponding to the current field in the internal field according to the edit mark and delete mark, so as to perform step 170 to compare the field change rate with the field change threshold value , And determine whether to output the internal current field for the tabulation module 240 to create and output the internal table. For example, in steps 171-172, when it is determined that the rate of change of the field is not greater than the threshold of field change, the tabulation module 240 outputs an internal table. Or, for example, perform step 173, when it is determined that the field change rate is greater than the field change threshold, the capture module 210 confirms whether there is updated external data from the user 300 for the comparison module 230 to compare again The updated external data field corresponds to each internal current field, and outputs the edit mark or delete mark. Wherein, in step 174, when the user 300 has updated the external data, the comparison module 230 returns to step 130 to compare the updated external data field again; or, in step 174, when the user When 300 does not update the external data, the operation will stop and no internal table will be output.

(式1) The following formula 1 and the external data field of Table 1 are taken as examples. The comparison module 230 can calculate the field change rate of the external data field of Table 1 according to the following formula 1. Among them, the denominator in the following formula 1 is "total number of columns" refers to the total number of columns in the updated internal current period field (for example, the internal fifth period field), and the numerator in the following formula 1 is "change "Number of fields" refers to the number of changed fields in the updated internal current period field (e.g. internal period 5 field) compared to the internal previous period field (e.g. internal period 4 field). The edit mark of is changed to the number of fields of the current period's deletion mark (for example, from N to Y), and the number of fields from the previous period's deletion mark to the current period (for example, from Y to N).

(Formula 1)

Take Table 5 above as an example, the total number of columns in the internal period 5 column is 9 columns, then the "total number of columns" in the above formula 1 is 9. And the column of the internal period 5 changed from the edit mark of the previous period to the deletion mark of the current period (for example, from N to Y). The field includes fields 2, 4, and 7, and the number of fields is 3; The field of the 5 period field changed from the deletion mark of the previous period to the edit mark of the current period (for example, from Y to N) includes fields 5 and 6, and the number of fields is 2 columns. In other words, the number of variable columns in the internal period 5 column is 5, so the "number of variable columns" in the above formula 1 is 5. Based on this, calculated according to the above formula 1, the "column change rate" of the internal period 5 column is 55.6% (=5/9).

Based on the field change threshold that can be set by the user 300 or other related personnel to, for example, 50% (not limited here), it can be seen that the "field change rate" (55.6%) of the internal period 5 field is greater than Threshold for field change (50%). At this time, the capture module 210 confirms whether there is external data from the user 300 to adjust to the updated internal current field, and the comparison module 230 determines whether it is not greater than the change threshold according to the For the tabulation module 240 to output the internal table. The example of the internal table can be analogized to the above, so I won't repeat it here.

Or, if based on the field change threshold value that can be set by the user 300 or other related personnel to, for example, 80% (not limited here), the "field change rate" (55.6%) of the internal 5th period field can be known. ) Is not greater than the field change threshold (80%). At this time, the tabulation module 240 outputs the internal table. The example of the internal table can be analogized to the above, so I won't repeat it here.

Based on the above, the embodiment of the present invention automatically compares with the external data field through the internal current period field containing all the internal fields for each period, and adds the edit mark or delete mark corresponding to each internal current period field. . As a result, the embodiment of the present invention can quickly and effectively integrate the external data of each period, and can output various internal tables in a preset internal format according to the needs of users for subsequent judgments . Therefore, the embodiment of the present invention can effectively organize a large amount of cumbersome external data, and can automatically output various organized and more readable internal forms according to requirements, saving the time and cost required for manual collation in the past. And successfully avoided small, but important and hard-to-detect errors caused by human error.

The present invention is disclosed in the preferred embodiments in this text. However, anyone familiar with the technical field should understand that the above-mentioned embodiments are only used to describe the present invention and are not intended to limit the scope of the patent rights claimed by the present invention. Any changes or substitutions that are equal or equivalent to the above-mentioned embodiments should be interpreted as being covered by the spirit or scope of the present invention. Therefore, the scope of protection of this new model shall be subject to the scope of the following patent applications.

100: Integration method of external data 110-170, 131-132, 141-142, 161-165: steps 200: Integrated device for receiving data 210: Capture module 220: database 230: comparison module 240: Tabulation module 300: User

In order to make the above and other objectives, features, advantages and embodiments of the present invention more comprehensible, the description of the attached drawings is as follows: FIG. 1 is a schematic flowchart of a method for integrating external data according to an embodiment of the present invention. FIG. 2 is a schematic flowchart of a method for determining a column change in a method for integrating external data according to an embodiment of the present invention. FIG. 3 is a schematic diagram of an external data integration device according to an embodiment of the present invention.

200: Integrated device for receiving data

210: Capture module

220: database

230: comparison module

240: Tabulation module

300: User

Claims (10)

An integrated device for external data, installed in a computer or mobile device, which includes: A database that stores an internal previous period data and an internal current period data. The internal previous period data has a plurality of internal previous period fields, and the internal current period data has a plurality of internal current period fields, among which the internal current period columns Bits include all the internal previous fields; A retrieving module, retrieving external data from a user to obtain and output a plurality of external data fields of the external data; A comparison module, which is communicatively connected to the capture module, receives the external data fields, and is communicatively connected to the database to capture the internal current fields and the internal previous fields for comparison The external data fields and the internal current fields are compared with the internal current fields and the internal previous fields to output an edit mark or delete for each of the internal current fields. Mark; and A tabulation module, which is communicatively connected to the comparison module, receives the internal current fields and the corresponding edit marks and the delete marks, according to the internal current fields and the corresponding edits Mark and these delete marks, output an internal table. The integrated device according to claim 1, wherein: The comparison module compares whether any of the external data fields appear in the internal current period fields, so as to respectively output the edit mark to the corresponding internal current period fields. The integrated device according to claim 2, wherein: When it is judged that any of the external data fields appear in the internal current period fields, the comparison module outputs the respective external data fields according to the external data fields appearing in the internal current period fields. Edit the mark to the corresponding internal current field. The integrated device according to claim 3, wherein: When it is determined that any of the external data fields do not appear in the internal current period fields, the comparison module adds the external data fields that do not appear in the internal current period fields to the In these internal current-period fields, corresponding to the newly-added internal current-period fields, the edit mark is output respectively. The integrated device according to claim 4, wherein: The comparison module compares whether any of the updated internal current fields without the edit mark appears in the internal previous fields, and for the updated internal fields without the edit mark In the current field, output the edit mark or the delete mark respectively. The integrated device according to claim 5, wherein: When it is judged that the internal current field after any update appears in the internal previous field, the comparison module is for each update that appears in the internal previous field but does not have the edit mark The following internal current fields output the delete mark respectively. The integrated device according to claim 5, wherein: When it is judged that any of the updated internal current fields does not appear in the internal previous fields, the comparison module is more aimed at those that do not appear in the internal previous fields and do not have the edit marks The internal current fields after each update output the delete mark respectively. The integrated device according to claim 1, wherein: The comparison module obtains the rate of change of one of the fields corresponding to the current period based on the edit marks and the delete marks, so as to compare the rate of change of the field with the threshold value of a field change, and Determine whether to output the internal table. The integrated device according to claim 6, wherein: When it is judged that the change rate of the field is not greater than the change threshold of the field, the tabulation module outputs the internal table. The integrated device according to claim 6, wherein: When it is judged that the field change rate is greater than the field change threshold, the capture module confirms whether there is the updated external data from the user, so that the comparison module can compare the updated external data again External data fields, and corresponding to these internal current fields, output the edit mark or the delete mark.

Images