Data processing system and method
First Claim
1. A data processing system, comprising:
- an online transactional processing system for receiving of reporting data from a set of reporting points of work centers of a production line for producing a product, wherein the production line is logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the online transactional processing system comprising;
a) a database for storing the reporting data, b) first processing means for generating a first table comprising aggregated quantities of intermediate products at the exit points on the basis of the reporting data stored in the database, c) first storage means for storing the first table, a server computer comprising;
a) second storage means for storing a second table comprising value increments per shop area, b) second processing means for calculating a total value of the work in process by means of the first and second tables, c) means for transferring the first table from the first storage means of the online transactional processing system to the second processing means of the server computer.
3 Assignments
0 Petitions
Accused Products
Abstract
The data processing system has an online transactional processing (OLTP) system for receiving of reporting data from work centers of a production line. The production line is logically divided into shop areas. At the exits of each shop area where an intermediate product is completed one reporting point serves as exit point in order to report the completion of an intermediate production step. This data is stored in the OLTP system and retrieved at a later point of time in order to generate a table containing aggregated intermediate product quantities per shop area. This table is transferred to a financial data server for calculation of the value of work in progress.
-
Citations
15 Claims
-
1. A data processing system, comprising:
-
an online transactional processing system for receiving of reporting data from a set of reporting points of work centers of a production line for producing a product, wherein the production line is logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the online transactional processing system comprising;
a) a database for storing the reporting data, b) first processing means for generating a first table comprising aggregated quantities of intermediate products at the exit points on the basis of the reporting data stored in the database, c) first storage means for storing the first table, a server computer comprising;
a) second storage means for storing a second table comprising value increments per shop area, b) second processing means for calculating a total value of the work in process by means of the first and second tables, c) means for transferring the first table from the first storage means of the online transactional processing system to the second processing means of the server computer. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer program product for calculating of a value of work in progress comprising:
-
a first set of instructions for execution by a first processor of an online transactional processing system for receiving of reporting data from a set of reporting points of work centers of a production line for producing a product, the production line being logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the reporting data being stored in a database, the first set of instructions operable to generate a first table comprising aggregated quantities of intermediate products at the exit points on the basis of the reporting data stored in the database and for storing of the first table in first storage means of the online transactional processing system, and a second set of instructions for execution by a second processor of a server computer coupled to the online transactional processing system, the server computer having second storage means for storing a second table comprising value increments per shop area, the second set of instructions operable to calculate a total value of the work in process by means of the first and second tables. - View Dependent Claims (10, 11, 12)
-
-
13. A method of calculating of a value of work in progress on the basis of reporting data received from a set of reporting points of work centers of a production line for producing a product, the production line being logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the method comprising the steps of:
-
receiving of the reporting data by an online transactional processing system, storing of the reporting data in a database of the online transactional processing system, generating a first table comprising aggregated quantities of intermediate products and aggregated scrap quantities reported from the exit points on the basis of the reporting data stored in the database, storing the first table in first storage means of the online transactional processing system, transferring of the first table from the first storage means to a server computer, the server computer having second storage means for storing a second table comprising value increments per shop area, calculating a total value of the work in progress by means of the first and second tables by the server computer. - View Dependent Claims (14, 15)
-
Specification