JP5215929B2 - Data processing method and data processing system - Google Patents

Description

  In the present invention, there are an application that performs a process for storing data and an application that performs a process that uses data, and the application that performs a process that uses data refers to the data stored by the application that performs a process that accumulates data. The present invention relates to a data processing method and a data processing system.

  In recent years, it has become common to store business data generated by business in companies. Analyzing users in companies contribute to improving productivity, speeding up management strategy, and improving accuracy by collecting, organizing, and analyzing business data. Analysis is a form of usage.

  Conventionally, collection of business data used in analysis work has been performed by weekly or daily batch processing. Batch processing is required for the reasons described below. A server (hereinafter referred to as online business server) that performs processing for accumulating business data (hereinafter referred to as storage processing) and a server that performs processing for analytical work (hereinafter referred to as analytical processing) (hereinafter referred to as analytical business server). .) Generally has a configuration of physically different servers.

  Therefore, a database (hereinafter referred to as an online business DB) that is stored in an application that performs storage processing in an online business server and a database (hereinafter referred to as an analysis processing DB) that is referred to by an application that performs analysis processing in an analytical business server. Is a different configuration.

  Therefore, there is a need for batch processing for collecting business data used in analysis work from the online work DB to the analysis processing DB. The reason why the online business server and the analysis business server are separate servers is to avoid deterioration of the storage processing performance.

  When the analysis application is executed on the online business server, the analysis application uses various resources of the online business server, which compresses the resources used for the storage processing and degrades the processing performance of the storage processing. Since accumulation processing is directly and closely related to actual business, degradation of processing performance is not preferred.

  On the other hand, the speed of management has been increasing year by year. With the increase in management speed, it is beginning to be desired by users who perform analysis work to perform analysis including “just now” work data (Just in Time analysis).

  However, as described above, the batch processing is generally weekly or daily as described above, and the processing for linking the business data of the online business server and the analytical business server is performed at a speed suitable for just-in-time analysis. It is difficult.

  There are also technologies that respond to this changing situation. For example, as a process for linking business data at a speed suitable for just-in-time analysis, “a database creation method by real-time update difference extraction and its information processing apparatus” described in Patent Document 1 can be cited. By using the technology disclosed in Patent Document 1, it is possible to realize cooperation between business data of an online business server and an analysis business server at a speed suitable for just-in-time analysis.

JP 2004-78464 A

  In recent years, the processing capability of computers has improved dramatically due to the evolution of hardware, and the amount of work that can be processed by a server has also increased. For this reason, it is possible to execute the online operation and the analysis operation on the same server, which are separate servers due to deterioration of processing performance.

  In this case, the database that the storage application stores in the online job and the database that the analysis application references in the analysis job can be configured to be the same. In this case, the link between the online job and the business data of the analysis job is just-in-time. It can be realized at a speed suitable for analysis.

  On the other hand, it is also common in recent years for one analysis application to refer to information on a plurality of online business DBs stored by different business applications.

  For example, a yield rate that expresses the efficiency of producing a product in a certain manufacturing process is calculated from the amount of material input and the production amount of the product. However, storage applications having different input amounts of materials and manufactured amounts of products are stored in different online business DBs. For this reason, as a whole system, the analysis application needs to be able to correctly refer to business data stored by a plurality of online businesses.

  Furthermore, in recent years, the types and amounts of business data that can be accumulated have increased, and it has become common to perform various analyses. For this reason, it is not uncommon for multiple types of analysis applications to exist for one business or business data. For example, there are a manufacturing process A and a manufacturing process B, and the manufacturing process B uses the product manufactured in the manufacturing process A as a material, and there is a case where it is desired to grasp the yield rate of each.

  In this case, the storage application 1 and online business DB 1 for storing and managing the material input results for the manufacturing process A, and the storage application for storing and managing the material input results for the manufacturing process B at the same time as the manufacturing results of the manufacturing process A 2 and online business DB 2, a storage application 3 that stores and manages manufacturing results of manufacturing process B, and online business DB 3 exist.

  Further, the analysis application 1 that displays the yield rate of the manufacturing process A using the business data collected from the online business DB 1 and the online business DB 2 and the manufacturing process using the business data collected from the online business DB 2 and the online business DB 3 There is an analysis application 2 that displays the yield rate of B. The analysis application 1 and the analysis application 2 want to correctly refer to business data stored in a plurality of online business DBs having overlapping portions between the plurality of analysis applications.

  However, in the method described in Patent Document 1, although the online business server and the business data of the analytical business server can be linked at a speed suitable for just-in-time analysis, the business data stored in a certain online business DB and It cannot be considered that business data stored in another online business DB is correctly referred to when viewed from the analysis application.

  For example, for an analysis application that calculates the yield rate from the amount of material input and the amount of product manufactured, in a production lot in which a certain material has been input, after the amount of material input in that manufacturing lot has been input, and the amount of production If the yield rate is calculated before is input, the production amount is unreasonably low. This means that business data has not been correctly referenced.

  It can be said that the analysis application can correctly refer to the business information if the analysis application refers to both the above-mentioned numbers for the first time after both the input amount and the production amount of the material of the production lot are input.

  The same problem occurs in the above-described configuration in which the database that is stored by the storage application in the online operation is the same as the database that is referred to by the analysis application in the analysis operation.

  The present invention is an invention for solving the above-mentioned problems, and uses the business data of the online business application and the analytical business application in a duplicate manner among a plurality of analysis applications while linking the business data of the online business application and the analytical business application at a speed suitable for just-in-time analysis. It is an object of the present invention to provide a data processing method and a data processing system capable of correctly referring to business data stored in a plurality of online business DBs having such a portion.

  In order to achieve the above object, the present invention has an online operation and an analysis operation, an accumulation application for storing the operation data in the operation DB, and an analysis for performing an analysis process based on the operation data stored in the operation DB. In a data processing system having an application (for example, a business information analysis support system), business data stored in a business DB reflecting business data of online business is correctly referred to by an analysis application that refers to the business data It is.

  The data processing method according to the present invention is configured by a storage phase in a business DB from a plurality of storage applications and a reference phase from an analysis application. In the storage phase, the update information requested to be stored is analyzed, and when the update information is stored in the business DB, it is defined whether the update information is visible or invisible in response to a reference request from the analysis application ( For example, the determination is made based on the consistency condition definition 1610), the determination result is recorded, and the business data is stored in the business DB based on the update information. In the reference phase, in response to a reference request from the analysis application, it is determined whether each business data stored in the business DB is to be visible or invisible based on a determination result corresponding to the analysis application requested for reference. Present the determined business data to the analysis application.

  According to the present invention, business data is linked between an online business application and an analytical business application at a speed suitable for just-in-time analysis, and stored in a plurality of business DBs having portions that are used redundantly among a plurality of analytical applications. Can be presented as correct business data for each analysis application.

1 is a diagram illustrating an overall configuration of a data processing system according to a first embodiment. It is a figure which shows the example of a business data acquisition screen. It is a figure which shows the example of the table on online business DB. FIG. 6 is a PAD diagram illustrating processing contents of a consistency determination and update execution processing unit according to the first embodiment. It is a figure which shows the example of a consistency condition definition. It is a figure which shows the example of a consistency determination management table | surface. FIG. 6 is a PAD diagram showing processing contents of a consistency consideration table creation processing unit of the first embodiment. It is a figure which shows the example of an analysis application execution result screen. It is a figure which shows the whole structure of the data processing system of Embodiment 2. FIG. FIG. 10 is a PAD diagram illustrating processing contents of a consistency determination and update execution processing unit according to the second embodiment. FIG. 10 is a PAD diagram showing processing contents of a consistency consideration table creation processing unit of Embodiment 2. It is a figure which shows the example of the consistency condition definition B. It is a figure which shows the example of the consistency determination management table. It is a figure which shows the example of the execution result screen of the analysis application. It is a figure which shows the whole structure in case a business application and an analysis application are another computers. It is a figure which shows the data flow about a consistency determination and update execution process, a consistency consideration table preparation process, and the process in an analysis application. It is a figure which shows the process outline | summary of Embodiment 1. It is a figure which shows the process outline | summary of Embodiment 2. FIG.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
(Embodiment 1)
In the first embodiment, there is an application that performs processing for storing data, and an application that performs processing that uses data, and performs processing that uses the data stored by the application that performs processing that stores data. A data processing system in which an application performs data processing as a series of data across DBs will be described.

  In the present embodiment, focusing on a group key that characterizes data as a series of data across DBs, a consistency condition definition including a group key, a reference target, and a judgment condition is defined in advance, and a series of data corresponding to the group key is judged. Whether or not the condition is satisfied is managed by the consistency determination management table, and the data to be presented to the application is selected using the consistency determination management table, and the data is referred to correctly by the application.

  FIG. 1 is a diagram illustrating an overall configuration of a data processing system according to the first embodiment. The data processing system shown in FIG. 1 includes a business A that stores business data in a business table A (1810), a business B that stores business data in a business table B (1820), a business table A (1810), and a business table B. Based on the business data stored in (1820), it is constructed in the business server 1400 that performs the analysis business.

  The business server 1400 includes a display device 1700 for displaying processing results, an input device 1710 for inputting commands and business data, a CPU (Central Processing Unit) 1720 that is a central processing unit for executing processing, processing programs, and various types. A main storage device 1750 such as a RAM (Random Access Memory) for temporarily storing data, a storage medium 1800 such as a hard disk drive for storing business data, and a bus 1740 for connecting them.

  The main storage 1750 includes a system control unit 1440, a business A application 1050, a business B application 1060, an analysis application 1500, a consistency determination and update execution processing unit 1910 (data update processing unit), and a consistency consideration table creation processing unit 1920. Each program of the (data reference processing unit) is read from the storage medium 1800, and a setting storage area 1600 and a work area 1680 are secured.

  In the storage medium 1800, a business table A (1810) that stores business data by the business A application 1050 that has received values and instructions from the input device 1710, and a business table B (1820) that stores business data by the business B application 1060. ) Is stored. The business table A (1810) is, for example, the material use result management table 5100 shown in FIG. 3, and the business table B (1820) is, for example, the manufacturing result management table 5200 shown in FIG.

  The system control unit 1440 activates the business A application 1050 and the business B application 1060 according to the business data acquisition screen display command input from the input device 1710, and the business executed by the business A application 1050 and the business B application 1060. Processing for starting the consistency determination and update execution processing unit 1910 in conjunction with update processing of the table A (1810) and the business table B (1820), business table A (1810) executed by the analysis application 1500, and business table B (1820) includes a process for starting the consistency consideration table creation processing unit 1920 in conjunction with the reference process, and an analysis result screen display process executed by an analysis application execution command input from the input device 1710.

  The business A application 1050 displays a business data acquisition screen on the display device 1700 for business data acquisition screen display processing, and stores business data input from the input device 1710 in the business table A (1810). Has data storage processing.

  Similarly, the business B application 1060 displays a business data acquisition screen on the display device 1700 and displays business data input screen display processing, and business data input from the input device 1710 is stored in the business table B (1820). It has business data storage processing for storing.

  The analysis application 1500 acquires business data stored in the business table A (1810) and the business table B (1820) and executes analysis processing according to an analysis application execution command from the input device 1710, and displays the analysis result on the display device 1700. To display.

  The setting storage area 1600 stores a consistency condition definition 1610 (consistency condition definition information) (see FIG. 5) and a consistency judgment management table 1650 (consistency judgment management information) (see FIG. 6). The consistency condition definition 1610 (see FIG. 5) includes a group key 1620 (grouping information) that characterizes a series of data determined to be correct for the application, and a reference object 1630 that defines an object to be referred to while ensuring consistency. (Reference object information), and a determination condition 1640 (determination condition information) that defines a condition for allowing the application to refer to the business data. The consistency determination management table 1650 (see FIG. 6) includes a key column 1660 for storing group keys and a status column 1670 for storing a consistency determination state that is a visible or invisible state of a reference target corresponding to each group key. Have. The above is the configuration of the present embodiment.

  The data processing system shown in FIG. 1 includes a consistency determination and update execution processing unit 1910 (see FIG. 4), a consistency consideration table creation processing unit 1920 (see FIG. 7), and a consistency condition definition 1610 (see FIG. 5). And a consistency judgment management table 1650 (see FIG. 6).

  The consistency determination and update execution processing unit 1910 receives an update request from the business A application 1050 and the business B application 1060, analyzes the update request, and includes a business table (for example, business table A (1810), Information on business data to be stored in the business table B (1820)) (such as columns to be updated and updated values) is acquired. Then, it is identified whether or not the group data 1620 set in the consistency condition definition 1610 is included in the business data information to be stored in the business table. If the group key 1620 is included, the consistency condition definition is determined. Whether or not the determination condition 1640 set in 1610 is included is determined. If the determination condition 1640 is included, the determination condition 1640 is set by a series of information on the business data to be stored in the business table and the group key 1620. A group of information characterized by the group is acquired to determine whether or not the determination condition 1640 is satisfied. The determination result is stored as the consistency determination state corresponding to the group key of the consistency determination management table 1650, and the business data is stored in the business table based on the business data information (contents) to be stored in the business table. To do. The consistency determination and update execution processing unit 1910 is a processing unit that performs a “storage phase in the business table”.

  The consistency consideration table creation processing unit 1920 acquires a reference request from the analysis application 1500, acquires the consistency determination management table 1650, and corresponds to the group key group and each group key stored in the consistency determination management table 1650. The consistency determination state to be acquired is acquired, and the business data stored in the analysis processing DB is acquired. Then, the group key of each acquired business data is acquired, the consistency determination state corresponding to the group key is acquired, and it is determined whether each business data is visible or invisible according to the acquired consistency determination state. To present to the analysis application. The consistency consideration table creation processing unit 1920 is a processing unit that performs the “reference phase from the analysis application”.

  The consistency condition definition 1610 (see FIG. 5) includes a group key 1620 as an element characterizing a series of data determined to be correct for the application, and a reference object that defines an object to be referred to while ensuring consistency at the time of reference. 1630 and a determination condition 1640 that defines a condition for allowing the application to refer to the business data, and exists for each analysis application.

  The consistency determination management table 1650 (see FIG. 6) includes a key column 1660 for storing group keys and a status column 1670 for storing consistency determination states that are visible or invisible for the reference target corresponding to each group key. Configured and exists for each analysis application.

  The consistency determination and update execution processing unit 1910, the consistency consideration table creation processing unit 1920, the consistency condition definition 1610, and the consistency determination management table 1650 are stored in a storage medium such as a CD-ROM (Compact Disc Read Only Memory). It is assumed that these are recorded and stored in a storage medium such as a magnetic disk, then loaded into the main storage device 1750 and executed. The recording medium may be a medium other than a CD-ROM. Further, the storage medium to which the recording medium is transferred need not be a magnetic disk.

  FIG. 17 is a diagram illustrating an outline of processing according to the first embodiment. The manufacturing worker A registers work information (material use results) using the business A application 1050. Further, the manufacturing worker B registers work information (manufacturing performance information) using the business B application 1060. The consistency determination and update execution processing unit 1910 that has received the work information registration instruction refers to the consistency condition definition 1610 and the material usage record management table 5100 (see FIG. 3A) and the manufacturing record management table 5200 (see FIG. 3). 3 (b))), and the value of the state column for the value of the predetermined key column is registered in the consistency determination management table 1650 (see FIG. 6).

  On the other hand, when the manufacturing work manager requests an analysis result using the analysis application 1500, the consistency consideration table creation processing unit 1920 includes a consistency condition definition 1610, a material usage record management table 5100, a manufacturing record management table 5200, With reference to the sex determination management table 1650, a consistency consideration table 16020 (see FIG. 16) is created. The consistency consideration table 16020 includes a material usage record management table 16030, a manufacturing record management table 16040, etc. that correspond to a predetermined key column and are determined to satisfy the consistency in the consistency determination management table 1650. The analysis application 1500 uses the consistency consideration table 16020 to output the requested analysis result.

Hereinafter, the processing content of FIG. 17 will be described in detail.
The processing of this embodiment is roughly divided into (A0) a storage phase in the business table and (B0) a reference phase from the analysis application. First, the storage phase in the business table will be described, and then the reference phase from the analysis application will be described.

(A0: Storage phase in business table)
First, the storage phase in the business table will be described.
In the storage phase in the business table, first, (A1) business data acquisition screen display processing by the business A application 1050 and business B application 1060 is performed, and then (A2) by the business A application 1050 and business B application 1060. The business data storage process is performed, and (A3) consistency determination and update execution processing unit 1910 performs consistency determination and update processing. Hereinafter, each process will be described.

(A1: Business data acquisition screen display process)
In the business data acquisition screen display process, first, the system control unit 1440 activates the business A application 1050 or the business B application 1060 by a business data acquisition screen display command input from the input device 1710, and the business data acquisition screen display process. To start. Next, in the business data acquisition screen display process, the business A application 1050 or the business B application 1060 displays a business data acquisition screen on the display device 1700. A screen example of the business data acquisition screen will be described with reference to FIG.

FIG. 2 is a diagram illustrating an example of a business data acquisition screen. 2A shows a material usage record input screen 2000, and FIG. 2B shows a manufacturing record input screen 2100.
FIG. 3 is a diagram illustrating an example of a table on the online business DB. 3A shows a material usage record management table 5100, and FIG. 3B shows a manufacturing record management table 5200.

  A material use record input screen 2000 shown in FIG. 2A is a work data acquisition screen for inputting the work data stored in the material use record management table 5100 shown in FIG. The material usage record input screen 2000 includes a form 2010 for inputting a production number, a form 2020 for inputting a material use record, and a submit button 2030 for instructing an opportunity to store the input value. The form 2010 for inputting the production number and the form 2020 for inputting the material usage record can be input business data using the input device 1710. The submit button 2030 can be pressed using the input device 1710 only when values are entered in the form 2010 for entering the manufacturing number and the form 2020 for entering the material usage record.

  When the submit button 2030 is pressed, a business data storage command is sent to the system control unit 1440, and the value input to the form 2010 for inputting the manufacturing number is input to the form 2020 for inputting the material usage record as the manufacturing number. The input value is requested to be stored in the business table A (1810) as a material usage record corresponding to the manufacturing number.

For example, the form 2010 for inputting the production number is set to “001”, the form 2020 for inputting the material usage record is set to “50”, the submit button 2030 is pressed,
When the form 2010 for inputting the production number is set to “002”, the form 2020 for inputting the material use record is set to “50”, and the submit button 2030 is pressed, the business table A (1810) displays the material use shown in FIG. The status shown in the result management table 5100 is obtained.

  A manufacturing result input screen 2100 shown in FIG. 2B is a business data acquisition screen for inputting business data stored in the manufacturing result management table 5200 shown in FIG. The manufacturing result input screen 2100 includes a form 2110 for inputting a manufacturing number, a form 2120 for inputting a manufacturing result, and a submit button 2130 for instructing an opportunity to store the input value. The form 2110 for entering the production number and the form 2120 for entering the production record can be input business data using the input device 1710.

  The submit button 2130 can be pressed using the input device 1710 only when values are entered in the form 2110 for entering the production number and the form 2120 for entering the production record. When the submit button 2130 is pressed, a business data storage command is sent to the system control unit 1440, and the business B application 1060 via the system control unit 1440 receives the value entered in the form 2110 for entering the serial number. A value input to the form 2120 for inputting a manufacturing result as a number is stored in the business table B (1820) as a manufacturing result corresponding to the manufacturing number.

  For example, when the form 2110 for entering the manufacturing number is set to “001”, the form 2120 for inputting the manufacturing result is set to “40”, and the submit button 2130 is pressed, the business table B (1820) displays the manufacturing result shown in FIG. The state shown in the management table 5200 is obtained.

  In addition, in FIG. 2, the material usage record input screen 2000 was demonstrated using the example displayed on a web browser. However, this is an example, and it may be a dedicated client or an interface other than that.

  Next, examples of tables on the business DB shown in FIG. 1 as the business table A (1810) and the business table B (1820) will be described with reference to FIG.

  The material usage record management table 5100 shown in FIG. 3A has a production number 5110 and a material use record 5120. Specifically, the material use record corresponding to the production number “001” is “50”, and the material use record corresponding to the production number “002” is “50”. In the present embodiment, the business table A (1810) is defined as the material usage record management table 5100, and will be described below.

  The manufacturing performance management table 5200 illustrated in FIG. 3B includes a manufacturing number 5210 and a manufacturing performance 5220. Specifically, the production record corresponding to the production number “001” is “40”. Further, it indicates that the manufacturing record corresponding to the manufacturing number “002” is not input. In the present embodiment, the business table B (1820) is defined as the manufacturing performance management table 5200, and will be described below.

In the present embodiment, the business data storage area is the business DB, but the business data storage area may not be a database. The business data storage format is a table format such as business table A (1810) and business table B (1820), but the business data storage format may not be a table format. Furthermore, although the contents of the stored business data have been described in the material usage record management table 5100, the manufacturing record management table 5200, etc., other contents may be used.
The above is an explanation of an example of a table on the business DB.

(A2: Business data storage processing)
In the business data storage process, first, the system control unit 1440 activates the business A application 1050 and starts the business data storage process by a business data storage command input from the input device 1710 to the business data acquisition screen.

  The business A application 1050 makes a storage request for business data input from the input device 1710 to a table on the business DB (in this embodiment, business table A (1810), business table B (1820)). Similarly, the system control unit 1440 activates the business B application 1060 in response to a business data storage command input from the input device 1710 to the business data acquisition screen, and starts business data storage processing.

  The business B application 1060 makes a storage request for the business data input from the input device 1710 to a table on the business DB (the business table A (1810) and the business table B (1820) in this embodiment). This completes the description of the business data storage process.

(A3: Consistency determination and update processing)
FIG. 4 is a PAD showing processing contents of the consistency determination and update execution processing unit of the first embodiment. In FIG. 4, the consistency determination process and the update process performed by the consistency determination and update execution processing unit 1910 will be described. Note that PAD is an abbreviation for Problem Analysis Diagram.
FIG. 5 is a diagram illustrating an example of the consistency condition definition. FIG. 5A shows an example of the consistency condition definition 1610, and FIG. 5B specifically shows the material use result management table 5100 and the manufacturing result management table 5200 shown in FIG. An example is shown.
FIG. 6 is a diagram illustrating an example of the consistency determination management table. FIG. 6 shows an example of the consistency determination management table 1650 shown in FIG. Processing of the consistency determination and update execution processing unit 1910 will be described with reference to FIGS. 4, 5, and 6. The main subject of the processing is the CPU 1720, but for convenience, each program will be described as the main subject.

  In the consistency determination and update execution processing unit 1910, first, the system control unit 1440 receives a storage request to the table on the business DB of the business A application 1050 or the business B application 1060, thereby determining consistency. The update execution processing unit 1910 is activated to start consistency determination and update processing.

  Next, the consistency determination and update execution processing unit 1910 acquires the requested update request and performs an update request reception process for storing it in the work area 1680 (step S3120). Then, from the update request stored in the work area 1680, the update target column and the update target value that is included in the update request are acquired, and the update target column and the update target value are stored in the work area 1680. Processing is performed (step S3130).

  Next, a consistency condition definition acquisition process is performed to acquire the consistency condition definition 1610 (see FIG. 5) from the setting storage area 1600 and extract the group key 1620 and the determination condition 1640 from the acquired consistency condition definition 1610 ( Step S3210).

  An example of the consistency condition definition 1610 will be described with reference to FIG. The consistency condition definition 1610 shown in FIG. 5A includes a group key 1620 as an element characterizing a series of pieces of data determined to be correct for an application, and a reference object that defines an object to be referred to while ensuring consistency. 1630 and a determination condition 1640 that defines a condition for allowing an application to refer to the business data. The group key 1620 is defined by the column name of the table on the business DB described in FIG.

  For example, the group key 8210 has a form of “manufacturing number of material usage record management table, manufacturing number of manufacturing record management table”. Here, the group key 8210 indicates that the production number in a row in the material usage record management table 5100 shown in FIG. 3A and the row in the production record management table 5200 having the same production number shown in FIG. It is defined as belonging to one group.

  Specifically, the line indicating the production number “001” and the material use record “50” in the material use record management table 5100 and the line indicating the manufacture number “001” and the manufacture record “40” in the manufacture record management table 5200 are It is defined as belonging to one group.

  The reference object 1630 is defined by the column name of the table on the online business DB described in FIG. For example, the reference object 8220 has a form of “manufacturing number and material usage record in material usage record management table, manufacturing number and manufacturing record in manufacturing record management table”. The reference object 8220 is referred to while ensuring consistency. The manufacturing number 5110 and the material usage record 5120 of the material use record management table 5100 shown in FIG. 3A and the manufacture record shown in FIG. It is defined that the manufacturing number 5210 and the manufacturing result 5220 in the management table 5200 are included.

  The determination condition 1640 is defined by specifying the state of the analysis processing DB. For example, the determination condition 8230 is in the form of “there is a material usage record and a manufacturing record corresponding to the same group key”. In this case, when considering the table on the business DB in FIG. 3, there are a group A having a production number “001” as a group key and a group B having “002” as a group key. In Group A, since the material use record “50” and the manufacture record “40” exist, it can be seen that the determination condition 1640 is satisfied. On the other hand, since the group B has only the material usage record “50” and the manufacturing record value does not exist, it can be seen that the determination condition 1640 is not satisfied.

  The consistency condition definition 1610a shown in FIG. 5B is an explanatory diagram of processing based on the consistency condition definition 1610 described in FIG. Based on the group key 8210, the group key 1620 acquires a production number from the material usage record management table and the manufacture record management table, and sets it as the group key N. Specifically, the group key “001” and the group key “002” are acquired from the material usage record management table and the manufacturing record management table described in FIG.

  Based on the reference object 8220, the reference object 1630 acquires the material use record L and the manufacture record M that are paired with the production number corresponding to the group key N from the material use record management table and the manufacture record management table. Specifically, from the material use record management table and the manufacture record management table described with reference to FIG. 3, the material use record “50”, the manufacture record “40”, and the group key “002” which are paired with the group key “001”. The material usage record “50” to be paired with “is acquired.

The determination condition 1640 is determined based on the determination condition 8230 by using an expression [“Group key N material use record L” ∩ “Group key N manufacture record M”]. In the example of the description, for the group key “001”, both the material usage record “50” and the manufacturing record “40” exist, and thus the above equation holds. For the group key “002”, only the material usage record “50” exists, so the above formula does not hold.
This completes the description of the example of the consistency condition definition 1610.

  Returning to the description of FIG. 4, next, a key inclusion determination process for identifying whether or not the column corresponding to the extracted group key 1620 is included in the update target column stored in the work area 1680 is performed (Step S1). S3220). Furthermore, when it is determined in step S3220 (key inclusion determination processing) that the column corresponding to the group key 1620 is included in the update target column (step S3220, including the key), the update target stored in the work area 1680 is stored. A determination target content determination process for identifying whether or not a column related to the extracted determination condition 1640 is included in the column is performed (step S3230).

  If it is determined in step S 3230 (determination target inclusion determination process) that the update target column includes a column related to the determination condition 1640 (step S 3230, including the determination condition), it is stored in the work area 1680. The column update target value corresponding to the group key 1620 is acquired as a group key value, and the business data stored in the business DB table (business table A (1810), business table B (1820)) is grouped by the group key. Then, a group corresponding to the group key value is acquired, and consistency determination processing for determining whether or not the acquired determination condition 1640 is satisfied is performed on the acquired group information (step S3240).

  If it is determined in step S3240 (consistency determination processing) that the update target column satisfies the determination condition 1640 (step S3240, determination condition is satisfied), the consistency determination management table 1650 (see FIG. 6). If the group key value already exists in the key column, the status column corresponding to the existing group key value is set to “True”, and if the group key value does not exist, a new row is generated, and the key column The consistency judgment management table update process A is executed for setting the group key value to “True” for the status column corresponding to the group key value (step S3250).

  On the other hand, if it is determined in the consistency determination processing 3240 that the update target column does not satisfy the determination condition 1640 (step S3240, the determination condition is not satisfied), the group key is added to the key column of the consistency determination management table 1650. If the value already exists, the state column corresponding to the already existing group key value is set to “False”, and if the group key value does not exist, a new row is generated, and the key column is changed to the group key value. Consistency determination management table update processing B is performed in which the status column corresponding to the group key value is set to “False” (step S3260). Note that the results of the update processing in steps S3250 and S3260 are registered in the consistency determination management table 1650 shown in FIG. 6 as already described. An example of the consistency determination management table 1650 will be described with reference to FIG.

The consistency determination management table 1650 shown in FIG. 6 includes a key column 1660 for storing group keys,
It has a state column 1670 for storing a consistency judgment state in which a state of being reflected or invisible corresponding to each group key is expressed as “True” and “False”.

FIG. 6 shows a state according to the description of the consistency condition definition 1610 using FIG. In other words, the row 6210 in which the key column 1660 is “001” and the status column 1670 is “True” is a row for storing information on the group A in which the serial number is “001” as the group key. . Further, a row 6220 in which the key column 1660 is “002” and the status column 1670 is “False” is a row for storing information on the group B in which the manufacturing number that is the group key is “002”. .
The above is an example of the consistency determination management table 1650.

Returning to the description of FIG. 4, finally, the consistency determination and update execution processing unit 1910 determines the update target column and update target value stored in the work area 1680, based on the table (task table A (1810), An update execution process for updating the business table B (1820)) is performed (step S3320), and the series of processes ends.
This is the end of the description of the storage phase in the business table.

(B0: Reference phase from analysis application)
Next, the reference phase from the analysis application will be described. In the reference phase from the analysis application, first, (B1) analysis application execution processing is performed by the analysis application 1500 (see FIG. 1), and then (B2) consistency consideration table creation processing unit 1920 performs the consistency consideration table. Creation processing is executed. Hereinafter, each process will be described.

(B1: Analysis application execution processing)
In the analysis application execution process, first, in response to an analysis application execution command from the input device 1710, the system control unit 1440 activates the analysis application 1500 and starts the analysis application execution process.

  Next, the analysis application 1500 transmits a consistency consideration table presentation command regarding the application to the system control unit 1440, and waits for and receives the result of the consistency consideration table presentation command. Then, the analysis processing implemented in the analysis application is performed based on the received consistency consideration table 16020, and finally the analysis result display processing for displaying the analysis application execution result screen (see FIG. 8) on the display device 1700 is performed. carry out. Details of FIG. 8 will be described later. It should be noted that the analysis application execution processing may be largely changed in order of processing by the analysis application.

(B2: Consistency consideration table creation process)
FIG. 7 is a PAD diagram showing the processing contents of the consistency consideration table creation processing unit of the first embodiment. In FIG. 7, the consistency consideration table creation processing by the consistency consideration table creation processing unit 1920 will be described. In the consistency consideration table creation processing unit 1920, first, the consistency consideration table presentation processing is started by a consistency consideration table creation command received by the system control unit 1440.

  The consistency consideration table creation processing unit 1920 acquires a consistency consideration table creation command (reference data transmission request), and performs a request reception process of storing it in the work area 1680 (step S4010). Next, the consistency condition definition 1610 (see FIG. 5) is acquired, and the consistency condition definition acquisition process for acquiring the group key 1620 is performed (step S4030). And the consistency determination state acquisition process which acquires the consistency determination management table 1650 (refer FIG. 6) is implemented (step S4040). Further, business data acquisition processing (table data acquisition processing) for acquiring business data stored in the table requested by the application is performed (step S4050).

  First, after generating an empty consistency consideration table 16020 (see FIG. 16) in the work area 1680, the consistency determination state application process (step S4060) is performed and analyzed on all of the acquired business data. Business data repetitive processing (repeated for each row of the table data) for adding the business data determined to be shown to the application to the consistency consideration table 16020 is performed (step S4055).

  The consistency determination state application process S4060 will be specifically described. First, the column value corresponding to the group key 1620 (see FIG. 5) is acquired as the group key value from the business data to be processed. Next, the value of the status column 1670 corresponding to the group key value equal to the group key value acquired with reference to the key column 1660 of the consistency determination management table 1650 (see FIG. 6) is acquired. If there is no key column equal to the group key value in the acquired consistency determination management table 1650, the consistency determination state of the value in the status column 1670 is regarded as having acquired “False”. If the consistency determination state of the acquired status column 1670 is “True”, it is determined that the information should be shown to the analysis application, and the processing target business data is added to the consistency consideration table 16020 in the work area 1680. . If it is “False”, it is not added.

Returning to FIG. 7, finally, the consistency consideration table transmission process for transmitting the consistency consideration table 16020 generated in the work area 1680 to the partner (for example, the analysis application 1500) that issued the consistency consideration table presentation command. Is implemented (step S4070).
This completes the description of the consistency consideration table creation process.

  FIG. 8 is a diagram illustrating an example of the analysis application execution result screen. A processing example of the analysis application 1500 and an example of an execution result screen will be described with reference to FIG. The yield rate analysis result screen 7100 shown in FIG. 8 is an analysis for calculating and displaying the yield rate based on the business data stored in the material usage result management table 5100 and the business data stored in the manufacturing result management table 5200. It is an application execution result screen.

  The yield rate analysis result screen 7100 includes a label 7110 indicating that the numerical value to be displayed is a yield rate, and a yield rate 7120 obtained as an analysis result. The material usage record management table 5100 and the manufacture record management table 5200, which are tables on the work DB (work table A (1810), work table B (1820)), are in the state shown in FIG. When the management table 1650 is in the state shown in FIG. 6, correct business data is presented to the analysis application due to the effect of the present embodiment, and the state shown in FIG. 8 is obtained.

  This is a value obtained by multiplying the yield rate by dividing the sum of the production amount of the product by the sum of the input amount of the material by 100, and from the row 6210 of the consistency judgment management table 1650 of FIG. The business data of the group with the key “001” is visible (True), and the business data with the group key “002” in the row 6220 is invisible (False). It is obtained by acquiring the material usage record 5120 “50” of the row where the production number 5110 of the 5100 is “001” and the production record 5220 “40” of the row where the production number 5210 of the production record management table 5200 is “001”. It is correct because the value is “40 ÷ 50 × 100 = 80”.

  If all the business data stored in the material usage record management table 5100 and the manufacturing record management table 5200 is used for the yield rate calculation without considering the information of the consistency determination management table 1650, “40 ÷ (50 + 50)” × 100 = 40 ”, the yield rate 7120 is displayed as 40%, and an inaccurate analysis result is displayed.

  In FIG. 8, the analysis application execution result screen has been described using an example displayed on a web browser. However, this is an example, and it may be a dedicated client or an interface other than that.

The data flow of the consistency determination and update execution process, the consistency consideration table creation process, and the process in the analysis application will be further described with reference to FIG.
FIG. 16 is a diagram illustrating a data flow regarding consistency determination and update execution processing, consistency consideration table creation processing, and processing in an analysis application. In the description, a material usage record management table 5100 (see FIG. 3A) storing data input from the job A application 1050 and a manufacturing record management table 5200 storing data input from the job B application 1060 (FIG. 3). (B) is defined as a base table 16010 stored in the storage medium 1800.

  First, the consistency determination and update execution processing unit 1910 performs the consistency determination management table 1650 (FIG. 6) based on the data of the base table 16010 stored in the storage medium 1800 by the consistency determination and update execution processing shown in FIG. Reference). In this example, the group key 001 is “True”, and the group key 002 is “False”.

  Next, the consistency consideration table creation processing unit 1920 generates a consistency consideration table 16020 based on the consistency judgment management table 1650 by the consistency consideration table creation process shown in FIG. In this example, the consistency consideration table 16020 includes a material usage record management table 16030 that considers consistency and a manufacturing record management table 16040 that considers consistency. The material usage record management table 16030 in consideration of consistency has only data relating to the group key 001, and the production record management table 16040 in consideration of consistency similarly has only data relating to the group key 001.

  Then, the analysis application 1500 generates an analysis application execution result screen based on the consistency consideration table 16020. In this example, the sum 50 of the values stored in the material use result management table 16030 in consideration of consistency and the values stored in the manufacture result column in the manufacture result management table 16040 in consideration of consistency are shown. Yield rate calculation (40 ÷ 50 × 100 = 80) is performed from the sum total 40, and a yield rate analysis result screen 7100 is generated.

  In this embodiment, the data created in the storage phase in the business DB is created by the consistency consideration table creation process and the analysis application execution process, and the business data stored by a plurality of online jobs is regarded as the correct business data for the analysis application. Can present.

  In this embodiment, there are a process for storing data and a process for using data. The process for storing data refers to the stored data, and the process using the data refers to a series of data across DBs. Data processing including a group key characterizing as a unit is performed.

  According to the data processing system for data processing shown in the present embodiment, the online business application and the analytical business application cooperate with the business data at a speed suitable for just-in-time analysis, and present the correct business data for the analytical application. The effect can be demonstrated.

(Embodiment 2)
In the first embodiment, the case where there is one analysis application has been described. However, there may be a plurality of analysis applications. A case where there are a plurality of analysis applications will be described as a second embodiment.

  FIG. 9 is a diagram illustrating an overall configuration of a data processing system according to the second embodiment. Compared with the first embodiment, the second embodiment includes a consistency determination and update execution processing unit 1910X (see FIG. 10) instead of the consistency determination and update execution processing unit 1910 on the main storage device 1750. Instead of the consistency consideration table creation processing unit 1920, there is a consistency consideration table creation processing unit 1920X (see FIG. 11). In place of the analysis application 1500, there are a plurality of analysis applications, that is, an analysis application A (1500A), an analysis application B (1500B), and an analysis application C (1500C). Furthermore, instead of the consistency condition definition 1610 existing in the setting storage area 1600 on the main storage device 1750, the consistency condition definition A (1610A), the consistency condition definition B (1610B), and the consistency condition definition C (1610C) In addition, the consistency determination management table A (1650A), the consistency determination management table B (1650B), and the consistency determination management table C (1650C) exist instead of the consistency determination management table 1650, and are stored. The difference is that AP-setting correspondence information 9030 (setting correspondence information), which is a new element, exists in area 1600. In addition, the same code | symbol is attached | subjected to the same component of Embodiment 1 and Embodiment 2. FIG. “AP” is an abbreviation for application.

  The AP-setting correspondence information 9030 includes a consistency condition definition list 9040 (consistency condition definition list information) representing all consistency condition definitions existing in the system, and correspondence between each consistency condition definition and consistency judgment management table. A consistency condition definition-management table correspondence table 9050 representing a relationship.

  The consistency condition definition list 9040 is a list of consistency condition definitions 1610 defined in this system. In FIG. 9, consistency condition definition A (1610A), consistency condition definition B (1610B), and consistency condition definition C (1610C) are registered.

  The consistency condition definition-management table correspondence table 9050 is a correspondence table between an analysis application that acquires business data and executes analysis processing, and a consistency condition definition used by the analysis application. In FIG. 9, analysis application A (1500A) -consistency condition definition A (1610A), analysis application B (1500B) -consistency condition definition B (1610B), analysis application C (1500C) -consistency condition definition C ( 1610C) is registered. Accordingly, the analysis application A (1500A) indicates that the consistency condition definition A (1610A) is used as the consistency condition definition.

  FIG. 18 is a diagram illustrating an outline of processing according to the second embodiment. Only differences from the first embodiment shown in FIG. 17 will be described. A plurality of consistency condition definitions A (1610A), consistency condition definition B (1610B), and consistency condition definition C (1610C) registered in the consistency condition definition list 9040 are defined. There are also a plurality of management tables A (1650A), consistency determination management tables B (1650B), and consistency determination management tables C (1650C). The correspondence relationship between the consistency condition definition and the consistency management table is registered in the consistency condition definition-management table correspondence table 9050.

  When the manufacturing operation manager requests an analysis result from a plurality of analysis applications using a predetermined analysis application (for example, analysis application A (1500A)), the consistency consideration table creation processing unit 1920X is specified from the analysis application. Consistency condition definition and consistency judgment management table (for example, consistency condition definition A (1610A), consistency judgment management table A (1650A), material use result management table 5100, manufacturing result management table 5200) The consistency consideration table 16020 (see FIG. 16) is created, and the consistency consideration table 16020 is a consistency judgment management table corresponding to a predetermined key column and associated with the specified consistency condition definition. The material use result management table 16030 and the manufacture result management table 16040 that are determined to satisfy the above are included. Application can output a with consistent consideration table 16020, the requested analysis.

  Among the processing contents of FIG. 18, the consistency determination and update execution processing unit 1910X (see FIG. 10) and the consistency consideration table creation processing unit 1920X (see FIG. 11), which are the changes from the first embodiment, will be described.

  FIG. 10 is a PAD showing the processing contents of the consistency determination and update execution processing unit of the second embodiment. The consistency determination and update execution processing by the consistency determination and update execution processing unit 1910X of the second embodiment will be described with reference to FIG. In the second embodiment shown in FIG. 10, a consistency condition definition acquisition process (step S10010) exists instead of the consistency condition definition acquisition process 3210 of the first embodiment shown in FIG. 4, and is repeated for the number of consistency condition definitions. The difference is that a process (step S10020) is added.

  In the consistency condition definition acquisition process in step S10010, first, the AP-setting correspondence information 9030 is read from the setting storage area 1600, and the consistency condition definition list 9040 is acquired. Next, the consistency condition definition group (for example, consistency condition definition A (1610A), consistency condition definition B (1610B), consistency condition definition C (1610C)) shown in the acquired consistency condition definition list 9040 is obtained. Obtained from the setting storage area 1600. Then, a group key and a determination condition are extracted from each consistency condition definition included in the acquired consistency condition definition group.

  In the iterative process for the number of consistency condition definitions (number) in step S10020, first, one of the consistency condition definitions included in the consistency condition definition group acquired in the consistency condition definition acquisition process 10010 is selected ( Definition selection process), group key and determination condition corresponding to the selected consistency condition definition, and subsequent key inclusion determination process (step S3220), determination target inclusion determination process (step S3230), consistency determination process The group key used in (Step S3240) and the determination condition are defined (determination condition definition process), and the key inclusion determination process (Step S3220) and the determination target inclusion determination process (Step S3230) using the defined group key and determination condition. The consistency determination process (step S3240) is performed (consistency determination process group). Thereafter, the definition selection process, the determination condition definition process, and the consistency determination process group are executed for all the consistency condition definitions included in the consistency condition definition group acquired.

  The analysis application execution processing related to the analysis application A (1500A), the analysis application B (1500B), and the analysis application C (1500C) is the same as that of the analysis application 1500, but the analysis content of the analysis processing is different for each application. .

  In the storage phase in the business DB by the consistency determination and update execution processing unit 1910X, when business data is acquired from a plurality of analysis applications, the consistency determination result related to the stored data is obtained for each analysis application. Can be held in.

  FIG. 11 is a PAD diagram showing the processing contents of the consistency consideration table creation processing unit of the second embodiment. The consistency consideration table creation processing unit 1920X according to the second embodiment will be described with reference to FIG. The second embodiment shown in FIG. 11 is different from the first embodiment shown in FIG. 7 in that an application specifying process (step S11000) is added.

  In the application specifying process 11000 in step S11000, first, information for specifying the application that issued the command is acquired from the consistency consideration table creation command (consistency consideration table presentation command) stored in the work area 1680. Next, the AP-setting correspondence information 9030 is read from the setting storage area 1600, and the consistency condition definition list 9040 and the consistency condition definition-management table correspondence table 9050 are acquired. Furthermore, the consistency condition definition corresponding to the identified application is acquired from the acquired consistency condition definition list 9040 and set as the consistency condition definition acquired in the consistency condition definition acquisition process (step S4030).

  Then, the consistency determination management table corresponding to the identified application is acquired from the acquired consistency condition definition-management table correspondence table 9050 and set as the consistency determination management table acquired in the consistency determination status acquisition process (step S4040). To do.

  The consistency consideration table creation processing unit 1920X allows the reference phase from the analysis application to store the business data stored in the plurality of online business DBs having a portion that is used redundantly among the plurality of analysis applications. Can be presented as correct business data.

  For example, corresponding to the analysis application 1500, the consistency condition definition 1610, and the consistency determination management table 1650 in the first embodiment, the analysis application A (1500A), the consistency condition definition A (1610A), and the consistency determination management table A ( 1650A), and analysis application B (1500B) is an application for displaying the total amount of materials used. FIG. 12 shows consistency condition definition B (1610B) and FIG. 13 shows consistency judgment management table B (1650B).

  FIG. 12 is a diagram illustrating an example of the consistency condition definition B. FIG. 13 is a diagram illustrating an example of the consistency determination management table B. FIG. 14 is a diagram illustrating an example of an execution result screen of the analysis application B. As a result of the analysis application A (1500A), a yield rate analysis result screen 7100 shown in FIG. At this time, the analysis application B (1500B) can be referred to when data in the material usage record management table is registered as in the consistency condition definition B (1610B) shown in FIG. In the consistency judgment management table B (1650B), the data of the production numbers 001 (6210B) and 002 (6220B) are set to True. As a result, 100 (7120B) is displayed in the total usage record 7110B on the material use record totaling screen 7100B shown in FIG. 14 from the material use record 5120 of the material use record management table 5100 shown in FIG.

  The analysis application A (1500A) has an analysis result that does not include the value of the key column value 002, but the analysis application B (1500B) has an analysis result that includes the value of the key column value 002 and is duplicated among a plurality of analysis applications. Thus, business data stored in a plurality of online business DBs having a portion used as the business data can be presented as correct business data for each analysis application.

  As described above, the consistency consideration table creation processing unit 1920X performs processing by switching to an appropriate consistency condition definition and consistency judgment management table for each application that has issued the consistency consideration table presentation command, and is stored in the business DB. Even if there is only one business data entity, only business data groups that are correct for each analysis application can be presented.

  In the above description, the analysis application A (1500A), the analysis application B (1500B), and the analysis application C (1500C) have all been described using an example on the same analysis business server 1400, but each analysis application is a different server. It may be configured to exist on the server and be executed on each server.

  In the first and second embodiments, the business application and the analysis application are executed on the same computer. However, as shown in FIG. 15, the business application and the analysis application are executed on different computers. There may be.

  FIG. 15 is a diagram showing an overall configuration when the business application and the analysis application are different computers. The business A application 1050 in FIG. 1 is executed by the online business server A (1000), the business B application 1060 is executed by the online business server B (1200), and the analysis application 1500 is executed by the analysis business server 1400A. In the analysis business server 1400A, the same components in the business server 1400 in FIG.

  The online business server A (1000) includes a display device 1010 that displays processing results, an input device 1070 that inputs commands and business data, a CPU 1080 that is a central processing unit that executes processing, and the online business server A (1000). A network port 1090 for connecting the network 1300, a main memory 1030 for temporarily storing processing programs and various data, a storage medium 1100 for storing business data, and a bus 1020 for connecting them.

  Each program of the system control unit 1040, the business A application 1050, the update information transmission unit 1160, and the transmission destination server definition 1130 are read from the storage medium 1100 to the main storage device 1030.

  The online business server B (1200) has the same configuration as the online business server A (1000). The online business server A (1000), online business server B (1200), and analysis business server 1400A are connected by a network 1300. The business table A (1810) stored in the storage medium 1800 of the analysis business server 1400A is a copy of the master business table A (1110) stored in the storage medium 1100 of the online business server A (1000). .

  In the online business server A (1000), when the business A application 1050 registers data in the master business table A (1110), the update result is output to the log 1120, and the update information transmission unit 1160 refers to the log 1120. The update information output to the log is transmitted to the server defined in the transmission destination server definition 1130.

  In FIG. 15, it is transmitted to the analysis business server 1400A and received by the update request reception process (step S3120) of the consistency determination and update execution processing unit 1910, and the consistency determination and update execution process described in the first embodiment is executed. .

  The data processing system of this embodiment relates to a business information analysis support system having a storage application that stores business data in a business DB and an analysis application that performs analysis processing based on the business data stored in the business DB. The business data stored in the business DB from the stored application can be correctly referred to by the analysis application that refers to the business data at a speed suitable for just-in-time analysis.

  Data processing of the data processing system according to the present embodiment includes a storage phase (for example, consistency determination and update execution processing) from a plurality of storage applications to a business DB and a reference phase (for example, consistency consideration table) from the analysis application. Creation process).

  In the storage phase from the storage application to the business DB, the update information requested to be stored is analyzed, and when the update information is stored in the business DB, the update information is visible to the reference request from the analysis application (True). ) Or invisible (False) is determined based on the consistency condition definition, the determination result is recorded, and the business data is stored in the business DB based on the update information.

  In the reference phase from the analysis application, first, in response to the reference request from the analysis application, whether to make each business data stored in the business DB visible or invisible based on the determination result corresponding to the analysis application requested for reference. After the determination, only the business data determined to be visible is presented to the analysis application.

  The data processing system according to this embodiment collects element data that is consistent among a plurality of element data for a plurality of applications that use a plurality of element data in a data storage area (for example, the storage medium 1800) in combination. A data processing system provided as reference data, which includes a storage unit (for example, main storage device 1750), a data update processing unit (for example, consistency determination and update execution processing unit 1910X), and a data reference processing unit (for example, matching A consideration table creation processing unit 1920X).

  In the storage unit, for each application, grouping information (for example, a group key 1620) that characterizes a group of element data as a group, reference target information that defines a plurality of element data associated with the grouping information (for example, reference) Object 1630), and consistency condition definition information (for example, consistency condition definition 1610) including determination condition information (for example, determination condition 1640) defining a determination condition for making reference object information referable, Consistency determination management information (for example, consistency determination management table 1650) storing information on whether or not element data included in the group for each grouping information is consistent and can be referred to as a group; Is remembered.

  When the data update processing unit receives a data update request to the data storage area (for example, step S3120), the element data to be updated is specified in the reference target information for the consistency condition definition information for each application. In this case, a series of element data designated as the reference target information is acquired using the grouping information, and it is determined whether or not the series of element data satisfies the condition of the determination condition information (for example, step S3240). The result is updated to the consistency determination management information for each application (for example, step S3250 and step S3260), and the updated element data is stored in the data storage area (step S3320).

  When the data reference processing unit receives a reference data transmission request from the application (for example, step S4010), the data reference processing unit identifies the application that has requested the transmission (for example, step S11000), and the consistency condition definition information and the consistency of the identified application. Sex determination management information is acquired (for example, step S4030, step S4040), and based on the grouping information included in the reference data transmission request from the data storage area, the consistency determination management information is referred to and the determination condition information Element data associated with the grouping information that satisfies the conditions is acquired (for example, step S4055), and is transmitted as reference data to the application (for example, step S4070).

  The determination condition information is characterized in that the presence or absence of one or more specific element data associated with the grouping information is a condition (for example, determination condition 1640B shown in FIG. 12).

  The data processing system further includes setting correspondence information (for example, AP-setting correspondence information 9030) that associates the consistency condition definition information with the consistency determination management information for each application.

  The data processing system further includes consistency condition definition list information (for example, consistency condition definition list 9040) that is list information of consistency condition definition information, and when a data update request to the data storage area is received. (For example, step S3120), the consistency condition definition information registered in the list with reference to the consistency list information is acquired (for example, step S10010), and a data update request is made for the number of the acquired consistency condition definition information. (For example, step S10020).

1050 business A application 1060 business B application 1400 business server 1440 system control unit 1500 analysis application 1600 setting storage area 1610 consistency condition definition (consistency condition definition information)
1620 Group key (grouping information)
1630 Reference object (reference object information)
1640 Judgment conditions (judgment condition information)
1650 consistency judgment management table (consistency judgment management information)
1680 Work area 1700 Display device 1710 Input device 1720 CPU
1740 Bus 1750 Main storage device 1800 Storage medium 1810 Business table A
1820 Business Table B
1910 Consistency determination and update execution processing unit (data update processing unit)
1920 Consistency consideration table creation processing unit (data reference processing unit)
9030 AP-setting correspondence information (setting correspondence information)
9040 Consistency condition definition list (consistency condition definition list information)
9050 Consistency condition definition-management table correspondence table

Claims (9)

By combining multiple element data in the data storage area that stores online business data, collect consistent element data among the multiple element data for applications that perform analysis processing based on the business data A data processing method for a data processing system provided as reference data,
The data processing system includes:
Defined grouping information that characterizes a group of element data as a group, reference object information that defines a plurality of element data associated with the grouping information, and a determination condition for enabling reference to the reference object information Consistency condition definition information including judgment condition information,
Consistency determination management information storing information indicating whether or not element data included in the group for each grouping information is consistent and can be referred to as a group, and
Each time the data update request to the data storage area is received, if the element data to be updated is the element data specified in the reference object information, it is specified in the reference object information using the grouping information to retrieve a set of element data, together with the series of elements data determines whether or not the condition of the determination condition information, and updates the availability of references definitive to the consistency determination management information as the determination result, the update Element data to be stored in the data storage area,
When the reference data transmission request is received from the application, the determination condition information is referred from the data storage area based on the grouping information included in the transmission request with reference to whether or not the consistency determination management information can be referenced. A data processing method, comprising: obtaining element data associated with grouping information that satisfies the above condition and transmitting the element data to the application as the reference data. Element data that is consistent among the plurality of element data for a plurality of applications that execute analysis processing based on the business data by combining a plurality of element data in a data storage area for storing business data of online business Is a data processing method of a data processing system that collects and provides as reference data,
The data processing system, for each application,
Defined grouping information that characterizes a group of element data as a group, reference object information that defines a plurality of element data associated with the grouping information, and a determination condition for enabling reference to the reference object information Consistency condition definition information including judgment condition information,
Consistency determination management information storing information indicating whether or not element data included in the group for each grouping information is consistent and can be referred to as a group, and
Every time receiving the data update request to the data storage area, with respect to the consistency condition definition information for each of the applications, when the element data to be updated is an element data specified in the reference target information, the grouping Information is used to obtain a series of element data specified in the reference target information, determine whether the series of element data satisfies a condition of the determination condition information, and the matching result for each application as a determination result It updates the availability of references definitive sexual determination management information, and stores the element data to be the updated into the data storage area,
When receiving the transmission request for the reference data from the application, it identifies the application that requested the transmission, acquires the consistency condition definition information and the consistency determination management information of the identified application, from the data storage area, Based on the grouping information included in the reference data transmission request, the element data associated with the grouping information satisfying the condition of the determination condition information is obtained by referring to the reference in the consistency determination management information . A data processing method comprising: transmitting the reference data to the application as the reference data. 3. The data processing method according to claim 1, wherein the determination condition information is based on the presence or absence of one or more specific element data associated with the grouping information. The data processing method according to claim 2, wherein the data processing system includes setting correspondence information for associating the consistency condition definition information with the consistency determination management information for each application. The data processing system has consistency condition definition list information which is list information of the consistency condition definition information,
When the data update request to the data storage area is received, the consistency condition definition information registered in the list is acquired with reference to the consistency condition definition list information, and the number of the acquired consistency condition definition information The data processing method according to claim 2, wherein a data update request is processed for minutes. Element data that is consistent among the plurality of element data for a plurality of applications that execute analysis processing based on the business data by combining a plurality of element data in a data storage area for storing business data of online business Is a data processing system that collects and provides as reference data,
The data processing system includes a storage unit, a data update processing unit, and a data reference processing unit,
In the storage unit, for each application,
Defined grouping information that characterizes a group of element data as a group, reference object information that defines a plurality of element data associated with the grouping information, and a determination condition for enabling reference to the reference object information Consistency condition definition information including judgment condition information,
Consistency determination management information storing information indicating whether or not element data included in the group for each grouping information is consistent and can be referred to as a group is stored,
The data update processing unit
Every time receiving the data update request to the data storage area, with respect to the consistency condition definition information for each of the applications, when the element data to be updated is an element data specified in the reference target information, the grouping Information is used to obtain a series of element data specified in the reference target information, determine whether the series of element data satisfies a condition of the determination condition information, and the matching result for each application as a determination result It updates the availability of references definitive sexual determination management information, and stores the element data to be the updated into the data storage area,
The data reference processing unit
When receiving the transmission request for the reference data from the application, the application that made the transmission request is identified, the consistency condition definition information and the consistency determination management information of the identified application are acquired, and the data storage area From the grouping information included in the reference data transmission request, the element data associated with the grouping information that satisfies the condition of the determination condition information with reference to whether or not the consistency determination management information can be referred to The data processing system characterized by acquiring and transmitting as said reference data to the said application. The data processing system according to claim 6 , wherein the determination condition information is a condition based on whether or not there is one or more specific element data associated with the grouping information. Said data processing system further data processing system according to claim 6, characterized in that it comprises a setting association information associating the consistency condition definition information, and the consistency determination management information for each of the applications. The data processing system further includes consistency condition definition list information which is list information of consistency condition definition information,
When the data update request to the data storage area is received, the consistency condition definition information registered in the list is acquired with reference to the consistency condition definition list information, and the number of the acquired consistency condition definition information The data processing system according to claim 6 , wherein a data update request is processed for minutes.

Images