A data comparison system and a data integrated method

Data comparison system and data integration method

A Data Comparison System And A Data Integrated Method

The present invention relates to a data comparison system and data integration method, in particular to a data comparison system and data integration method that can greatly save labor costs and reduce application costs, and at the same time, can reduce the fixed data comparison time.<br></br>

With the rapid development of information technology, various methods of data transmission between computer systems have been continuously developed. Among them, the use of hardware transmission interfaces and network interfaces is a common method, and there are some current electronic data circulations. It uses EDI (Electronic Data Interchange) technology.<br></br>EDI transfers a data file between two cooperative units through a value-added network, but both parties still need to write a conversion program to Parse these files. Once the data format changes, both parties need to invest resources (including manpower, material resources, and time). Etc. but not limited to) modify various conversion programs, and the two parties jointly formulate the data exchange format. Of course, this format can be very simple or very complex, but the point is that the exchange format is only understood by both parties. . The content of the EDI file is a general plain text file, but because the meaning of each set of data is agreed by both parties, even a third party cannot fully understand or interpret it. However, EDI can It achieves the effect of real-time data transmission and update, but its investment and establishment cost is much higher than the aforementioned hardware transmission interface and network interface. Therefore, not every enterprise has the ability to set up this EDI, and not all are willing to use this system to cooperate.<br></br>Therefore, companies and intermediary logistics integration vendors or companies need to establish a data comparison system so that companies or intermediary logistics integration vendors or companies can use the data comparison system to report mutually required conditions and requirements. Propose and compare the report of each unit through the data comparison system to see if the report conforms to the format, and then send the report to the unit to be sent after confirming the conformity, so as to achieve the purpose of information transmission; for example, it is generally large-scale production In order to cooperate with international purchases, a logistics company usually sets up a logistics distribution warehouse to configure inventory. A logistics distribution warehouse refers to the customer asking the manufacturer to set up a shipping warehouse near the customer for the customer, and have sufficient inventory , So that customers can quickly supply when they place an order, and the logistics distribution warehouse can be quickly arranged near the factory, and will not be restricted by geographical location and frequently arrange personnel and vehicles, resulting in waste of costs.<br></br>In addition, in order to enable enterprises and factories to know the report data provided by the logistics distribution warehouse at any time, and then understand the inventory status and distribution status, the logistics distribution warehouse and the factory or enterprise need to establish a data circulation method for inventory data, and the current electronic data circulation The EDI (Electronic Data Interchange) technology is used. However, due to the high cost of establishing EDI technology, the inventory data integration method applied by intermediary logistics integration vendors or companies is mainly based on the application of an inventory integration system. the logistics distribution warehouse will be the logistics distribution warehouse of information, arrival and delivery and other related logistics distribution warehouse data compilation to a report, and provide regular reports is aggregated to the distribution of company-owned warehouse management unit, warehouse and distribution The management unit organizes and uploads the report to the inventory integration system. The inventory integration system stores a standard format comparison module, a data receiving module, and an acquisition module. The standard format comparison module has multiple comparison fields. , After the report is sent to the inventory integration system, the comparison field of the standard format comparison module will compare the distribution data of the report one by one. If the distribution data completely matches the comparison field, the data receiving module Send the allocated warehouse data to the capture module to capture valid data from the capture module and send it to the management report for the company's decision-making unit to query.<br></br>If one of the distribution warehouse data fails to meet the comparison field, the distribution warehouse data cannot be sent from the data receiving module to the capture module, resulting in that the distribution warehouse data is not successfully sent, and the logistics The distribution warehouse needs to re-transmit the distribution warehouse data that fully conforms to it, and at the same time, the work of the distribution warehouse management unit is increased and the distribution warehouse management unit needs to be added to cooperate with multiple logistics distribution warehouses, resulting in the inability to use one distribution warehouse management unit Cooperate with multiple logistics distribution warehouses;<br></br>In addition, the distribution warehouse data provided by the logistics distribution warehouse has multiple data, but not all of the data are all the data required by the inventory integration system. For example, a distribution warehouse data has 20 data, but its Not all of the 20 pieces of data are important information for the inventory integration system. Perhaps only 5 of them are necessary for the inventory integration system to know, but the distribution data may be due to non-essential data that does not meet the requirements and cause the entire distribution. The warehouse data cannot be successfully sent, which causes the trouble of re-sending and extra labor cost inspection. Therefore, the conventional technology has the following disadvantages:<br></br>1. High application cost;<br></br>2. Need to spend manpower to repetitively organize;<br></br>3. The data may not be successfully sent due to errors in non-essential data;<br></br>4. It is easy to increase the cost of manpower and working hours.<br></br>Therefore, how to solve the above-mentioned conventional problems and deficiencies is the direction that the inventor of this case and the related manufacturers engaged in this industry urgently want to study and improve.<br></br><br></br>

Therefore, in order to effectively solve the above-mentioned problems, the main purpose of the present invention is to provide a data comparison system and data integration method that can greatly save labor costs and reduce application costs.<br></br>Another object of the present invention is to provide a data comparison system and data integration method that can prevent data from being unable to be successfully sent due to errors in unnecessary data.<br></br>Another object of the present invention is to provide a data comparison system and a data integration method that reduces the need to set basic data while importing files.<br></br>Another object of the present invention is to provide a data comparison system and data integration method that can effectively save data records.<br></br>To achieve the above objective, the present invention proposes a data comparison system, which is applied to at least one logistics distribution warehouse to send a report data to a company. The data comparison system includes: a function setting module, a condition setting Module, a data import module, a condition analysis module and a data processing module;<br></br>The function setting module has a basic setting interface, a format setting interface, and a parameter value setting interface. The company side can perform basic function setting and function format setting on its function setting module, and at the same time, parameter values can be set. Format setting<br></br>The condition setting module is connected to the function setting module. The condition setting module allows the company to select and verify report data and define comparison conditions, and the condition setting module has a basic setting block and a report verification Block, a report data correction block, a report column data corresponding block, and a report data expansion block for the company to choose and define;<br></br>The data import module is connected to the condition setting module, and is used to import the report data provided by the logistics distribution warehouse to the condition setting module;<br></br>The condition analysis module links the condition setting module and analyzes whether the report data provided by the logistics distribution warehouse meets the condition setting of the report condition setting module;<br></br>The data processing module is connected to the condition analysis module to receive and process report data that meets the condition setting; therefore, its data comparison system first performs function definition and condition setting, and then compares and analyzes the report data to Automatically feedback the correct corresponding information of the report data, and reduce the steps of setting basic data while importing files, and at the same time avoid the failure of the report data to be successfully sent, thereby saving labor costs and effectively saving data records.<br></br>According to the above-mentioned another object, one implementation of the present invention is to provide a data integration method, which is applied to at least one logistics distribution warehouse to send report data to a company-side data comparison system, the data comparison system has a function setting Module, a condition setting module, a data import module, a condition analysis module, and a data processing module. The method includes the following steps: basic setting, format setting, and parameter value format setting through the function setting module ; Then select the verification report data and define the comparison conditions through the condition setting module; import the report data provided by the logistics distribution warehouse from the data import module; analyze whether the report data meets the report condition setting mode through the condition analysis module Group condition setting; report data that meets the condition setting is sent to the data processing module, and the data processing module imports the report data into a database; and the database output type management report; therefore, its data comparison system Perform function definition and condition setting first, and then compare and analyze the report data to automatically return the correct corresponding information of the report data, and reduce the steps of setting basic data while importing files, and at the same time avoid the report data from being incapable It is successfully sent out, which saves labor costs and effectively saves data records.<br></br>The above-mentioned objects and structural and functional characteristics of the present invention will be described based on the preferred embodiments of the accompanying drawings.<br></br><br></br>

The above-mentioned objects and structural and functional characteristics of the present invention will be described based on the preferred embodiments of the accompanying drawings.<br></br>The present invention provides a data comparison system. Please refer to Figures 1, 2 and 3A to 3D, which are a block diagram and a window interface diagram of the data comparison system 10 of a preferred embodiment of the present invention. The data comparison The system 10 includes: a function setting module 20, a condition setting module 30, a data import module 40, a condition analysis module 50, and a data processing module 60; as shown in Figure 2, the functions The setting module 20 includes a basic setting interface 21, a format setting interface 22, and a parameter value setting interface 23. The basic setting interface 21 has a menu block 24, and the menu block 24 includes a report validation (Validity) option 241 , A report data modification (Modification) option 242, a report column data mapping (Mapping) option 243, and a report data extension (Extension) option 244, for the selection of the function type, and can be set through the function format and parameters respectively Value format setting Set the function definition and parameter value format, and set the menu options through the drop-down menu respectively.<br></br>Wherein, the condition setting module 30 is connected to the function setting module 20, as shown in Figure 3A, and the condition setting module 30 has a basic setting (Hub) block 31 and a report verification (Validity) block 32. A report data modification (Modification) block 33, a report field data mapping (Mapping) block 34, and a report data extension (Extension) block 35, each of which corresponds to the basic setting interface 21 Options in the menu block 24; and the basic setting block 31 can be used to set the basic data of the rule and the valid data range to set the code of the application object and the type of report data, such as arrival/delivery/arrival, delivery, At the same time, you can set the range settings such as the start row position, end row position, start column position, and end column position; and the report verification block can set the type of analysis, the coordinate position of the analysis condition, the key of the analysis, and the analysis , And then set the conditions for multiple identification of report data.<br></br>As shown in Figure 3B, the report data correction block can set the type of analysis, the position of the number of lines of the analysis condition, the key to be analyzed and the degree of analysis, and then set the conditions for multiple identification of report data; as in 3C As shown in the figure, the corresponding block of the report field data can set the conditions of the type of analysis, the field name of the system and the position of the number of rows, and then set the conditions for multiple identification of the report data and compare them with the report data; and As shown in Figure 3C, the report data expansion block can set the type of analysis, the key fields and return fields for the report data to provide integration, and then set the conditions for multiple identification of the report data; so its condition setting mode The group 30 can choose to verify the report data and perform the comparison conditions described in the definition.<br></br>Wherein, the data import module 40 links the condition setting module 30, and imports the report data provided by the application object to the condition setting module 30, and the condition analysis module 50 is also connected The condition setting module 30 further analyzes whether the report data provided by the application object meets the condition setting of the condition setting module 30, and its data processing module 60 is connected to the condition analysis module 50 to receive and process the conditions set Report data.<br></br>Please refer to Figure 4, which is a block diagram of the data comparison system 10 of the preferred embodiment of the present invention. In this embodiment, the data comparison system 10 is applied to a company 102 for understanding at least The logistics status and inventory status of a logistics distribution warehouse 101, and the company side 102 provides the data comparison system 10 to the logistics distribution warehouse 101 to transmit at least one report data and perform data comparison. The warehouse 101 provides the report data to the company side 102, the company side 102 sends the report data to the data comparison system 10, and the data comparison system 10 sets the function code, name and function through the function setting module 20 Type, and set the function format and parameter value format at the same time, and the data comparison system 10 uses the condition setting module 30 to set the basic data of the rule and the valid data range, and set the condition of the identification report and retrieve the report. Then, the condition analysis module 50 analyzes whether the report data meets the condition setting of the condition setting module 30 one by one according to the condition analysis module 50, so as to transfer the report data of the meeting condition setting module 30 to the data processing module 60 Receive and process the conditions set by the report data and the actions to be processed individually, and send the report data that meets the condition setting module 30 to a database 70, and the database 70 produces type management reports for the company The terminal 102 can learn the data status of the logistics distribution warehouse through the type management report, and the data comparison system 10 further includes a record query module 80, which can query the relevant historical records of the logistics distribution warehouse 102, including logistics Basic data such as distribution warehouse information, customer information, report type, and import information can also be queried during and after importing the original file data and system effective data; among them, the report data sent by logistics distribution warehouse 101 is Take an inventory data to the company 102 as an example. The company 102 uses the function setting module 20 to perform basic settings, format settings, and parameter value formats for the inventory data, and the condition setting module 30 selects and verifies the inventory data and performs definition comparisons. , And then import the inventory report provided by its logistics distribution warehouse 101 to the condition setting module 30 through the data import module 40, and then the condition analysis module 50 compares its inventory report with the condition setting module 30. Analyze whether its inventory report meets the condition setting of the condition setting module 30. After the comparison is confirmed, the data processing module 60 receives the inventory report that meets the condition setting, so that the company 102 can use the data comparison system 10Understand the inventory status of logistics distribution warehouses and achieve savings at the same timeThe effect of labor cost and application cost reduction.<br></br>As shown in Figure 5, it is a schematic flow chart of the data integration method using the data comparison system of the present invention. The data integration method includes the following steps:<br></br>(Sp1): Function setting via function setting module;<br></br>(Sp2): The condition setting module selects the verification report data and defines the comparison conditions;<br></br>(Sp3): Import the report data provided by the logistics distribution warehouse from the data import module;<br></br>(Sp4): Analyze whether the report data meets the condition setting of the report condition setting module through the condition analysis module<br></br>(Sp5): The report data that meets the condition setting is sent to the data processing module, and the data processing module imports the report data into a database;<br></br>(Sp6): Database output type management report.<br></br>In summary, the advantages of the present invention over the prior art are as follows:<br></br>1. The condition analysis module 50 of the data comparison system 10 can be executed one by one through the data processing module 60 according to the conditions set every time, and can automatically return all the correct corresponding information of the report data, so that the user does not need to Re-importing the file again eliminates the need to routinely set basic data, which greatly saves time and labor costs.<br></br>2. During the analysis process, the condition analysis module 50 can correspond to the report data through the field coordinate values used by the condition setting module 30 or by fuzzy comparison of keywords, and complete the analysis through the condition analysis module 50 , In order to avoid the failure of correct comparison due to the change of language system or the behavior of slightly manually modifying the field name, and thus achieve the effect of saving labor cost and time comparison cost.<br></br>3. The data comparison system 10 does not need to use a physical file as a standard format. It only needs to define and retrieve valid field data, so as to avoid the trouble of being unable to send due to the slight difference between the report data and the physical file format.<br></br>4. Through the function setting module 20 and the condition setting module 30 in conjunction with the data processing module 30, the comparison conditions can be expanded and defined to adapt to various types of report data.<br></br>According to the above description, it is only a preferred embodiment of the present invention, but the characteristics of the present invention are not limited to this. Anyone familiar with the art can easily think of changes or modifications in the field of the present invention. All should be covered in the following patent application scope of the present invention.<br></br><br></br>

<p>10. . . Data comparison system</p><p>101. . . Logistics distribution warehouse</p><p>20. . . Function setting module</p><p>102. . . Company side</p><p>twenty one. . . Basic setting interface</p><p>twenty two. . . Formatting interface</p><p>twenty three. . . Parameter value setting interface</p><p>twenty four. . . Menu block</p><p>241. . . Report verification options</p><p>242. . . Report data correction options</p><p>243. . . Report field data mapping options</p><p>244. . . Report data expansion options</p><p>30. . . Condition setting module</p><p>31. . . Basic setting block</p><p>32. . . Report verification block</p><p>33. . . Report data correction block</p><p>34. . . Report column data corresponding block</p><p>35. . . Report data expansion block</p><p>40. . . Data Import Module</p><p>50. . . Condition Analysis Module</p><p>60. . . Data processing module</p><p>70. . . database</p><p>80. . . Record query module</p>

Figure 1 is a block diagram of a preferred embodiment of the present invention;

Fig. 2 is a schematic diagram 1 of the window interface of the preferred embodiment of the present invention;

Figure 3A is a second schematic diagram of the window interface of the preferred embodiment of the present invention;

Figure 3B is the third schematic diagram of the window interface of the preferred embodiment of the present invention;

Figure 3C is the fourth schematic diagram of the window interface of the preferred embodiment of the present invention;

Figure 3D is a schematic view five of the window interface of the preferred embodiment of the present invention;

Figure 4 is a block diagram of the preferred embodiment of the present invention;

Figure 5 is a schematic flow diagram of a preferred embodiment of the present invention;