TWI305884B - A system and method for data processing - Google Patents

Description

1305884

Jt____η 曰Revision 92137fifin V. Invention Description (]) [Technical Fields of Invention] Data ΐ:;:: and a data processing technology, especially between [pre-technology] single 2: = with users The connection between the two, in a timely manner reflects the user's subscription, the user is better enough to understand the extent of his order production and the degree of progress, τ醢4丁1 tJ Pingwang seat of the situation user #垆八丰Ϊ i In the case of production and demand for materials, the ERP system data such as production, procurement and inventory of the single-input--2 ±-stop industry is pre-set in time for the adjustment of Li t χ · · 对 对 到 到 到The system data is read to the user EPR system for reference, which involves the number of data: and transmission and other data processing, so it should provide a solution, seven-turn data processing system. To solve the above problems, Taiwan Intellectual Property Bureau in July 1985, 丨j曰 Princess Eight 251402, Patent No. 72421 is named "Communication System and Method for Network Connection 3" Patent 'This patent provides - Data Processor The data processor can communicate with any data processor through a network connected to a plurality of networks to transmit information. The Taiwan Intellectual Property Office of Yizhong was founded on November 1st, 1988. The name of the patent number is 99054, and the accounting unit is σ = number is the data processing system for allocating assets. 'The patent's selectivity belongs to the allocation of funds between the various internal accounting units of several entities, and the assets are distributed by the data stored in the database. Although the above two patents are related to data processing, =. The questions we raised. Can't solve me [invention]

Page 6 1305884 —-- Case No. 92137060__ Month Day Amendment V. Invention Description (2) The relevant terms involved in this paper are explained as follows: Β 2β: Business-to-business e-commerce. The main object of the present invention is to provide a data processing system that can transmit related data information in a commercial ERP system to a B2B server of an external system according to the PIP data format of R〇settaNet via a network HTTP protocol^ where RosettaNet is The standard for data formats and exchange methods. The specific P IP data format used is: 2A12 3A6 3B2 4A5 4C1 V01. 00.〇〇a V 02. 00. 〇〇 R01. 01.00d R01. 00.00Aa V 0 2. 0 0. 〇〇

Distribute Product Master Distribute Order Status Notify 〇f Advance Shipment Notify Forecastf Forecast Reply Distribute Inventory Report _ The invention discloses a data processing system. The system provides a central server, a plurality of client computers, a configuration and log database, and a corporate database. The central server is connected to a plurality of client computers via a network, and is connected to the enterprise through a database. The ERp database, the Xijiji and the database are connected, and the network is connected to an external system B2B server. The central server is used to read the relevant D from the enterprise ERP database. ^ ^ early data guides the poor news, then converted to

The corresponding PIP specified by RosettaNet is transmitted to the B2B server of the external system, and ^^ Π ^ * ss, before the file is transmitted and after receiving the reply from the external port P, the configuration and log data are recognized. ^ ^ 'T ten rhinoceros write log data' is easy to check S. The parent client computer has a set of έ --- 甩 团 and 1 ^ page interface, can be accessed by the network

1305884 days amendment

Case No. ^ ^7060 years V. Invention Description (3) Record the status of the data in the central server and configuration and the database to complete the data query, modify and query the status of the transmitted data. Enterprise ERP data repository Basic data related to production, such as materials, order status, shipment and inventory data, as well as standards for each PIP data format. The configuration and the log database are used to store the configuration data required by the system and the files in the system running process, which include several data tables, such as the StageTable and (: 01^1舀_?8『8 tables. 3 of them 7 3 bogey 6 & 1316 table for recording? 1? Processing time, data, etc., the table includes the block: name and description ^ where the block description is used to record the corresponding block name use. For the StageTable The name field is described in detail as follows: pipJame, used to record the pjp name, such as 冉 2A12; Document_Content, used to record the XML content of the sending content.

Validate a Result, used to record whether the ριρ data verification passes its value of γ, indicating that the verification is passed, and the value of N ’ indicates that the verification has not passed. The c〇nfi2 Para table is used to record configuration parameters. 'The ordering machine also includes a parameter initialization module = parameter 资: = = alias, 曰 file directory name ((4): i ί private document module, used to generate the name of the Japanese social file, fhai The file is used to record the process... If the PIP name is 2A12, the file name format is pip2M2 w 枓 (yyyMMDDhh ss. log; - data acquisition module, data and corresponding to each basic data PIP data; basic, used to connect enterprise ERP database, configuration and community information 1 connection,: XML format; a block content update module, used / to convert p 1 p data to ---:- two And use 芑 according to the middle of the operation process

Page 8: Material write level, used to specify the file 7=, heart (Log Message); - format conversion input 曰 - body 1305884 --- 92137060 month you $ five, Description of the invention (4) ' ' " ------------- The result of the update is updated and the contents of the corresponding table in the log database; a data verification module for verifying the PI P Whether the data format is correct; a query module is used to query the corresponding interception content in the configuration and log database; - a 1 model, and is used to send the converted data; a block attribute value judgment module The group is used to determine the corresponding interception content in the configuration and log database. The present invention also provides a data processing method. The method comprises the following steps: (a) the central server generates the name of the processing log file; (b) the central feeding device connects the enterprise ERP database and the configuration and the database; (c) the central server from The enterprise E RP database reads the basic data list and obtains the basic data items to be processed; (d) the central server retrieves a basic data; (e) the central server determines whether the basic data already exists; f) the central server generates the ID of the p I p data format file; ( § ) the central server writes the PIP file ID and the PIP name into the configuration and log database; (h) the central server reads the basic The PI P data corresponding to the data; (i) the central server converts the p IP data into an xml format; (j) the central server updates with the converted content

The Document_Content field in the StageTable table; (k) the central server verifies whether the P IP data is correct; (1) the central server determines whether to send the content of the field immediately; (m) the central feeder sends the Field content; (η) The central server updates the Routing_Time (send file time) block in the StageTable. [Embodiment] This embodiment takes the PIP2A1 2 data format corresponding to the information standard RosettaNet as an example.

Page 9 1305884

- Case No. 921, T7f) fiO Five 'Inventions (5) i* Plus: 帛* is not the implementation of the data processing system of the present invention. The central server 1 is connected to the distributed computer through the network 4;;: the terminal computer 3, and also by the 埴 ς, the knife π ^ after the number is used to force the field connection 5 and the enterprise ERp database 7, the log The library 6 is connected. The 0*山+ configuration and the computer 3 are also connected to the Finnish log database 6 by the network 4 disk. The system captures Λ, n A , t , and ηπ 0 „ 0 L . The inverse of the music is connected to the B2r 仞 2 of the external system via the network 4 and the right 1 ^ (such as the fourth) m Yu, the central servo pirate 1 includes a series of function modules, the brother map is small), used to read the US ETA in the enterprise ERP database 7, and converted into an xml file 'transfer to the external system Β 2 Β feeding device 2 soil 1 external system echo reply (Ack Signal) information. User thunder month from 3 for the user to provide query information web interface, used to configure the number of settings, query configuration and log database information, query The status of the issued data. The enterprise ERP tribute library 7 is used to store basic data related to production, such as materials, order status, shipment and inventory data, as well as standards for each PI P data format. The log database 6 is used for storing configuration data required by the system and log files during system operation, and is composed of several tables, such as a StageTable (as shown in the second figure).

Config a Para table (as shown in the third figure). The network may be an intranet (I n t r a n e t ), an internet (I n t e rne t ) or other type of network. The database connection can be an open database connection (ODBC), or a Java database connection (JDBC). Referring to the second figure, it is an explanatory diagram of the field configuration of the StageTabl e table 8 stored in the configuration and the database 6 of the present invention. The S t a g e T a b 1 e Table 8 is used to record the time and data of the p I p process. Table 8

Page 10 1305884 __ Case No. 92137060_ Year Month Day Amendment _ Five 'Invention Description (6) Includes Block: Name 8 0 and Description 81. The description of field 81 records the use of the corresponding name field 80. For the name of the block 8 〇, refer to the second figure as detailed as follows: PIP—Name, used to record the pip name, such as 2Α12; PI P_Key, used to record key data, such as orders, item numbers, etc.; Document—ID , used to record the id of the PIP file;

Document — Content, used to record the XML format of the sent content;

Val idate—Resul t, used to record whether the PIP data verification is passed, and the value is "Y" indicates that the verification value is "N" indicates that the verification has not passed;

Rou ti ng_T i me, used to record the time when the file is sent; Ack_T i me ' is used to record the time when the central server 1 receives the response from the β 2 B server 2 of the external system; ID, used to record the session ID of B2B. Referring to the third figure, it is an explanatory diagram of the configuration of the block of the Con f i g a Par a table 9 stored in the configuration and log database 6 of the present invention. The Conf ig - Para9 table is used to record configuration parameters, including fields: name 9 〇 and description 9 1 . The description of field 91 records the use of the corresponding name block 9 〇. For the name of the block 9 〇, refer to the third figure as detailed below: DateTimeSty le, used to record the time format. SendStatus is used to indicate whether the data is sent immediately or sent together. The value is "〇" and indicates "send immediately", that is, a basic data format is sent immediately after conversion; other values indicate that it is sent together, that is, all basic data formats are converted. Referring to the fourth figure, it is a functional module diagram of the central server of the present invention. The central server 1 includes a parameter initialization module 丨丨1 for initializing related parameters such as enterprise ERP. Database Alias (TiptopAlias)

1305884 Amendment _ Case No. 92137060 5, invention description (7), configuration and database alias (Loca 1A 1 i as ) and log file directory name (Log directory), etc.; a log file generation module 112, for The name of the PIP handler log file generated in this process. If the name of the PIP is 2 A1 2, the log file generated by the log file generating module 11 2 has the name of ?1?2八12一丫丫7丫11100111111111153.1〇^; a data acquisition module 113, configured to read basic data from the enterprise ERP database 7, and generate PIP data corresponding to each basic data according to each p丨p data format standard; a database connection module 11 4 for connection Enterprise ERP database 7, configuration and log database 6; a log data writing module 1 1 5, used to write the daily data in the running process of the system to the configuration and log the corresponding day stored in the database 6 In the files, a format conversion module 116 is configured to convert the pip data format into an XML file format; a block content update module 丨丨7 is used to update the content generated by the system running process to the configuration and the ambition Correspondence in database 6 Document stageTable table update the corresponding bit Ge, as the content of P p Shu data format corresponding to a basic data converted into XML format file

Content of the Content field; a data verification module 118 for comparing the ριρ data format standard, verifying whether each ριρ data read is correct, and updating the verification result to the Val idate_Resul t field of the StageTable table-- The module 11 9 is used to query the relevant field content in the Stage T ab 1 e table; a sending module 12〇 is used to send the converted file format content conforming to the pip specification to the external system through the HTTP protocol. b 2B server 2 ^ Intercept attribute value judging module 1 2 1 ' is used to judge the field attribute value in the table stored in the configuration and log resource 6; and a reply information receiving module 1 22 ' is used for Receive the reply information of the B2B server 2 of the external system. Referring to the fifth figure, it is an information flow diagram of the present invention. Central Servo 1305884 Amendment --- Case No. 92137060_月日 V. Invention Description (8) Pirate 1 obtains basic data from enterprise ERP database 7 and then converts to

RosettaNet's corresponding PIP-defined xml file format is communicated to the B2B server 2 of the external system via the Ηττρ protocol, and then waits for the reply message from the B2B server 2: Ack Signal, before the file is transmitted and after receiving the Ack Signal The server 1 writes the date data to the configuration and log database 6:

Log data, the user can perform parameter configuration and query data through the client computer 3. Referring to the sixth figure, it is a flowchart of the operation of the data processing of the present invention. First, the parameters are initialized, and the set parameters include the aliases of the two databases and the directory name of the file (Log directory) (step S6〇1). Then, the name of the log file required for the data processing is generated and placed in the above-mentioned directory of the file, such as the processing of the data format ριρ2Α12. The generated log file is named 卩11>2^2_775^leg 1)1)11}1_",1〇§ (step 8 602). Then connect the enterprise ERp database 7 and the configuration and the database 6 (step S603) The basic data list is read from the enterprise ERp database 7 by the data acquisition module 113, and the items of the read basic data are obtained (step s 6〇4), and the data acquisition module 113 is used by the data acquisition module 113. Extracting a basic data to be processed from the read basic data list (step S6〇5), and then determining a value of Vaii^k in the StageTaHe table by the block attribute value judgment module 121, if the value is γ,,, indicating that the basic data has been processed, then returning to step S605 to repeat the process (step S6〇6); otherwise, executing step S607, generating the ID of the Pip file, and writing the (7) to the table D 〇cument an ID field and writing the ριρ name, such as 2A12, to the ρϊρ_nj bit (step S 6 0 8 ). Then, the data acquisition module 3 3 obtains the PIP data format corresponding to the basic number ^ (step S60) 9) 〇 by format conversion module page 13 1305884 _ case number 92137060 _ year and month _ correction five, invention description (9) 116 The PIP data format into an XML file format (step S610), and the contents 117 are updated by the format converting module updates the contents of the field

The Document_ID block of the StageTable table (step S611). Further, the data verification module 1 18 verifies whether the PIP data conforms to the specification based on the configuration and the PIP data format standard stored in the log repository 6 (step S612). If the rule is met, the verification result is "Y", otherwise "N", and the verification result is updated to the StageTable table Validate_Result block (step S613). Next, the query module 1 19 queries the Validate_Result field of the stageTable table (step S614); if the query result is "N", indicating that no verification succeeds, then the flow goes to step S6〇5 to continue processing the next basic data, if If the query result is "γ ", the verification is successful, and the query module 119 continues to query (: 〇11|18一?3]^ in the table with 11 (131^1:115 field) to judge the Whether the content of the block is "0 " (step S6丨5). If the content is not "〇", it means that the PIP data is not sent immediately, and is sent together with other data, the flow proceeds to step S6. 〇5 continues to process the next basic data, if it is "〇", it means that the PIP data is sent immediately, and the sending module 12 transmits the pip data to the external system 2 (step S616), and Update R〇uting in the StageTable by blocking content update module 117 —

The Time block, that is, the time to send the file is updated (step S61 7). The final flow proceeds to step S60 5 to continue processing the next basic data. ^ Referring to the seventh figure, the operation flow chart H after receiving the reply information of the external system by the data processing system of the present invention receives the reply information of the B2B server 2 of the external system by the reply information receiving module 122 (step $701) ), then initialize the parameters: database alias and log file directory name (Log directory ^ (step S7〇2). Then generate the L〇g text of this process

1305884

V. Description of the invention (ίο) The name of the part and the written directory 'where the Log file is written to the directory: _ directory\Ack (step S7G3), and then the configuration and date $database 6 (step s 704), and determine whether to connect Success (step S7〇5), if the connection fails, it is recorded in the log file and exits, otherwise it is updated at the current time to call the content of the Ack-Time block in the table (step S7〇6), and in the StageTable D〇Curaent_iD Field Content Update c〇nversaU〇n ID ° According to the above description, it is only a preferred embodiment of the present invention, and has achieved a wide range of use effects, and others are completed without departing from the spirit of the present invention. Equivalent changes or modifications are intended to be included in the scope of the claims below.

修正 Correction 1305884 _92137060 Schematic description of the diagram [Simple description of the diagram] / The first diagram is the hardware architecture diagram of the data processing system of the present invention. The second figure is an explanatory diagram of the field configuration of the StaSeTable stored in the configuration of the present invention and the Suntech database. The third figure is an explanatory diagram of the field configuration of Conf ig_ P a r a stored in the configuration and log database of the present invention. The fourth figure is a functional module diagram of the central server of the present invention. The fifth picture is the information flow diagram of the present invention. The sixth figure is a flow chart of the operation of the data processing of the present invention. The seventh figure is a flow chart of the operation of the data processing system of the present invention after receiving the reply information of the external system. [Main component symbol description] Central server i B2B server 〇 3 4 5 6 7 111 112 113 114 115 User computer network connection configuration and log database Enterprise ERP database parameter initialization module day 志 文件 file generation module Data acquisition module database connection module

1305884 _Case No. 92137060_Day and Month Day Correction Mode Simple Description Format Conversion Module 116 Block Content Update Module 117 Data Verification Module 118 Query Module 119 Transmit Module 120 Field Attribute Value Judgment Module 121 Reply Information Receive Module 122

Page 17

Claims (1)

Case No. 92371060 1305884 Six patent application scope/榷 data processing system, which can realize data exchange and query work outside the system ^ system includes a central server, connected through the network and the computer 'where: the central server of the terminal, The utility model is linked with an enterprise ERp database, a matching database, and an enterprise ERP database for storing and producing a basic number of international information standards RosettaNet PIP data format; the configuration and log database is used for The configuration data required by the storage system, the log file during the running of the system, and the plurality of data tables; the central server includes: a data acquisition module, configured to read basic data to be processed from the enterprise ERp database a list and each ριρ data corresponding to each basic data; a format conversion module for converting each basic data into a corresponding X I file format specified by the ping taNe t; a transmitting module for transmitting Standard pip data; a log data writing module for writing various information appearing during data processing Pieces. 2. For the data processing system described in item 1 of the patent application, the user computer in the bean is used to implement the query of the status of the transmitted data. 3. A data processing method, which can realize data exchange and query function, the method provides a central server, a plurality of client computers connected through a network, and the central server is still connected - the enterprise ERp database, one Configuration and Log Database 'This method includes the following steps. 1305884 _ Case No. 92371060_ Year Month _ Correction _ VI. Applying for the patent scope The central server performs initialization operation; The central server obtains a basic data; The central server is from the enterprise The ERP database reads the P IP data corresponding to the basic data; the central server converts the P IP data into an XML file format; and the central server sends the XML format file. 4. The data processing method of claim 3, wherein the initializing operation further comprises the steps of: initializing parameters; generating a log file name for the current processing. 5. The data processing method of claim 4, wherein the initialization parameter refers to an initialization of the enterprise E RP database, a configuration, and an alias of the database. 6. The data processing method described in claim 3, wherein the basic data refers to data such as materials, order status, shipments, and inventory related to the production of the enterprise. 7. The data processing method of claim 3, wherein obtaining a basic data further comprises the steps of: connecting the enterprise ERP database, the configuration, and the log database. 8. The data processing method of claim 3, wherein the method further comprises the steps of: receiving the reply information and recording the date data. 9. The data processing method of claim 8, wherein the method further comprises the steps of: 1305884 _ Case No. 92371060_年月日日__ VI. The patent server receives the reply information from the central server; the central server generates the log file name; the connection configuration and the log database; records the time when the reply information is received to the above-mentioned Log file. 1 0. The data processing method of claim 9, wherein the connection configuration and the log database further comprise the steps of: determining whether the connection is successful; if not, writing the information to the log file and exiting. Page 20 81 80 81305884 Year of the Month (3⁄4正: Stage Table Name Pip-Name Description PIP name, such as 2A12 Pip-Key Document ID key data, such as p〇, item number PIP file ID Document Content Validate Result Routing—Time pip data verification passed No Send content xml format Ack Time Conversation ID sent left ^ time received Ack Signal Figure 9 90 Config_Para 91 Description Time format Name DateTimeStyle The third picture 1305884 on the day and the more cut # Figure 6 <2> 1305884 Amendment SS92I37060, Chinese invention summary (invention name: data processing system and method) This central configuration and reading for the above-mentioned information is a function of the information department: Ming f exposed a kind of data processing system and method. The system provides benefits, multiple client computers, an enterprise ERp library, and a daily repository. The central server includes a data acquisition two, and uses K if various conversion modules for converting the above data. The cow ceremony type, a sending module, is used for transmitting the changed file through the HTTP protocol; The module is used to write log data to the configuration and library for later query. The system completed 9 can transfer the relevant materials, inventory and other data in the enterprise E R P system to the B2B server through the network according to the standard Rose ttaNet PIP data format. Five '(1), the representative figure of this case is: the first - 叟 - diagram (2), the representative symbol of the representative figure of this case is a simple description: Central server 1 parameter initialization module 111 曰 文件 file generation module 112 A system for data processing is disclosed. This system includes a host, a plurality of client computers, a enterprise ERP database and a config&log database. The host includes a module of getting data for reading and taking data, a module of switching format For switching the data into stated file format , a module of sending for sending the file switched via HTTP protocol, a Correction correction 113 114 115 1 16 117 118 119 120 121 122 Data acquisition module database connection module data writing module format conversion module blocking content update module data verification module query module sending module block Bit attribute value judgment module reply information receiving module 5, English invention summary (invention name: A System and Method for Data Processing) module of reading-in log message for writing the log message to log file.According to RosettaNet of PIP format , the system can send the data of the ERP system to B2B host of exterior system. A method for data processing is disclosed. Page 3 1305884 _ Case No. 92371060_年月月日 Revision 6. Designated representative map