WO2005059667A1 - Industrial control system and data processing method therefore - Google Patents

Industrial control system and data processing method therefore Download PDF

Info

Publication number
WO2005059667A1
WO2005059667A1 PCT/EP2004/013334 EP2004013334W WO2005059667A1 WO 2005059667 A1 WO2005059667 A1 WO 2005059667A1 EP 2004013334 W EP2004013334 W EP 2004013334W WO 2005059667 A1 WO2005059667 A1 WO 2005059667A1
Authority
WO
WIPO (PCT)
Prior art keywords
computer system
control data
data
database
network
Prior art date
Application number
PCT/EP2004/013334
Other languages
French (fr)
Other versions
WO2005059667A8 (en
Inventor
Achim Clemens
Ralf KÜHNER
Tim Gaiser
Manfred Metz
Markus Klein
Original Assignee
Sap Ag
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Sap Ag filed Critical Sap Ag
Priority to EP04803255A priority Critical patent/EP1697893B1/en
Publication of WO2005059667A1 publication Critical patent/WO2005059667A1/en
Publication of WO2005059667A8 publication Critical patent/WO2005059667A8/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B2219/00Program-control systems
    • G05B2219/30Nc systems
    • G05B2219/31From computer integrated manufacturing till monitoring
    • G05B2219/31205Remote transmission of measured values from site, local to host
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching

Definitions

  • the present invention relates to the field of industrial control systems, and more particularly to data processing methods in industrial control systems.
  • controllers operate elaborate industrial equipment in accordance with a stored control program.
  • the program causes the controller to examine the state of the controlled machinery by evaluating signals from one or more sensing devices (e.g., temperature or pressure sensors), and to operate the machinery (e.g., by energizing or de-energizing operative components) based on a procedural framework, the sensor signals and, if necessary, more complex processing.
  • the "inputs" to a particular controller can extend beyond the sensed state of the equipment the controller directly operates to include, for example, its environment, the state of related machinery or the state of its controllers.
  • Control requirements become even more complex when different aspects of the same overall process are assigned to remotely situated equipment. Such configurations often require reliable, high-bandwidth, and real-time serial communication links to provide the necessary interconnection and handle data transfer among controllers and the sensors relevant to their operation.
  • process operation is monitored, at least intermittently, by supervisory personnel by means of one or more central management stations.
  • Each station samples the status of controllers (and their associated sensors) selected by the operator and presents the data in some meaningful format.
  • the management station may or may not be located on the same site as the monitored equipment; frequently, one central station has access to multiple sites (whether or not these perform related processes). Accordingly, communication linkage can be vital even in traditional industrial environments where process equipment is physically proximate, since at least some supervisory personnel may not be.
  • controller processors and related computers are arranged as a computer network.
  • a network basically, is a collection of interconnected computers that use some consistent protocol to communicate with one another. Typically, the network is organized such that any computer may communicate with any other network computer.
  • the communication protocol provides a mechanism by which messages can be decomposed and routed to a destination computer identified by some form of address.
  • Such an industrial control system typically is interconnected by means of a field bus having real-time capability, such as PROFIBUS or real-time Ethernet.
  • a field bus having real-time capability, such as PROFIBUS or real-time Ethernet.
  • Such bus systems have real-time capability in order to guarantee maximum latency times for transmission of control data between the various components of the industrial control system.
  • the present invention provides for a data processing method for use in an industrial control system.
  • a computer system of the industrial control system receives control data from various automation components, such as controllers, sensors, actuators and/or data entry terminals.
  • the automation components and the computer system are coupled by means of a network, such as a realtime field bus.
  • the computer system has a database for storing of the control data.
  • the database is queried in order to determine a sub-set of the control data.
  • Control data of the sub-set is aggregated and transmitted to an external computer system over another network for offline processing of the aggregated control data.
  • the database query is performed when the load of the real-time network is low.
  • a database query can be triggered by a component that monitors network load.
  • the database query is triggered at predefined points of time. This has the advantage that the real-time capability of the computer system is not negatively influenced by query and the transmission of the control data to the external computer system.
  • control data is expressive of a quantity of a valuation unit.
  • a valuation unit can be any entity that is used or occurs in the production process and that has a financial value, such as a product unit or a work unit.
  • each valuation unit is identified by means of a unique identifier.
  • the aggregation of the control data is performed based on pre-defined similarity criteria of the valuation units. The similarity criteria determine the level of granularity that is required for the later off-line processing by the external computer system.
  • various types of household appliances are produced in a factory, such as refrigerators of various sizes.
  • the level of granularity that is of interest for the off-line processing may be the size of the refrigerators, whereas the colours of the refrigerators are of no interest.
  • the amount of refrigerators of a given size that are reported from the automation components are aggregated and transmitted to the external computer system.
  • the unique identifiers that are used to designate the valuation units have a hierarchical structure.
  • a pre-defined portion of the unique identifiers is used to define clusters of the valuation units for the purpose of aggregating the respective control data. For example all valuation units that have an identical sequence of leading bit positions of their unique identifiers are considered to be similar for the purpose of aggregating the respective control data.
  • the off-line computer system performs a financial valuation of the aggregated control data.
  • the off-line computer system calculates a monetary value for similar valuation units that have been reported from the industrial control system. These monetary values are entered as postings in a ledger, such as for the purpose of book keeping, financial evaluation and/or financial reporting.
  • the aggregated control data is transmitted from the industrial control system to the external computer system by means of a document.
  • a document Preferably SAP's exchange infrastructure (XI) is used for this purpose.
  • XI SAP's exchange infrastructure
  • other types of self- descriptive documents can be used, such as mark-up language documents, e.g. hypertext mark up language (HTML) or extended mark up language (XML) documents.
  • mark-up language documents e.g. hypertext mark up language (HTML) or extended mark up language (XML) documents.
  • Figure 1 is a block diagram of a preferred embodiment of an industrial control system of the invention
  • FIG. 2 is a flow diagram of a preferred embodiment of a data processing method of the invention
  • FIG. 3 is a block diagram illustrating usage of the exchange infrastructure (XI) for transmission of aggregated control data
  • FIG. 4 is a block diagram of a further preferred embodiment of an industrial control system of the invention.
  • FIG. 5 is a flow diagram of a further preferred embodiment of a data processing method of the invention.
  • Figure 6 is an embodiment of a window for a user's selection of an aggregation level.
  • Figure 1 shows industrial control system 100 that controls a manufacturing process.
  • Industrial control system 100 has various automation components 102, such as sensors, actuators, intelligent drives, controllers, etc.
  • Further industrial control system 100 has computer system 104 that provides a control functionality.
  • Network 106 interconnects the automation components 102 and computer system 104.
  • Computer system 104 receives various control data 108 from automation components 102.
  • Control data 108 may include measurement values, such as speed, temperature, humidity, or logical information regarding the state of an automation component 102.
  • Further control data 108 includes messages that indicate quantities of valuation units.
  • valuation unit may include a product unit or a product sub-unit, a component or other kind of material that is used for the ongoing production as well as a work unit, such as manufacturing service provided by a human and/or a machine.
  • Each type of valuation unit is identified by a unique identifier that is transmitted as part of the control data 108 to computer system 104.
  • Computer system 104 has program component 110 for providing a manufacturing control functionality on the basis of the control data 108 that is received by computer system 104. Further computer system 104 has online database 112 for storage of at least some of the control data 108 that contains data concerning the valuation units.
  • Program component 114 serves to perform a predefined database query in order to determine a sub-set of the control data that is stored in on-line database 112. Such a database query is triggered by program component 116.
  • Program component 116 can be implemented as a timer that has a pre-defined timer value. When the timer expires program component 116 triggers program component 114 to execute the database query.
  • program component 116 monitors the present load situation of network 106 and/or the present data processing load of computer system 104. When the actual load is below a threshold value this indicates that computer system 104 has sufficient unused capacity in order to perform the database query without negatively impacting the real-time capability of program component 110.
  • Program component 118 serves to aggregate control data that has been extracted from online database 112 as a result of the query that has been performed by program component 114. For example program component 118 aggregates control data of similar valuation units.
  • Further computer system 104 has interface 120 for transmitting of aggregated data 122 via network 124 to off-line computer system 126.
  • network 106 of industrial control system 100 as well as program component 110 and online database 112 have real-time capabilities. In other words maximum latency times for transmitting, storing, processing and responding to control data 108 that is received by computer system 104 via network 106 need to be guaranteed under all circumstances in order to ensure proper functioning of industrial control system 100.
  • Computer system 126 has off-line database 128 for storage of aggregated data 122. This can have the purpose of documentation of the ongoing process, such as for the purpose of product liability documentation, and/or other reporting purposes.
  • control data 108 is reported from the automation components 102 to computer system 104.
  • refrigerators of various colours and sizes are produced in the production process, e.g. red, blue, and white refrigerators having capacities of 150 litres, 170 litres and 230 litres.
  • red, blue, and white refrigerators having capacities of 150 litres, 170 litres and 230 litres.
  • valuation only the number of refrigerators of a certain size irrespective of colour is of interest.
  • Program component 114 has corresponding predefined database queries for determining control data relating to refrigerators having 150 litres, 170 litres and 230 litres capacity respectively, irrespective of colour.
  • Program component 116 has a timer that is programmed to trigger program component 114 one hour after the stop of the production.
  • Program component 114 executes its queries in order to extract a sub-set of control data relating to refrigerators that have been produced during the day having 150 litres capacity and separate sub-sets of the control data relating to such refrigerators having 170 litres and 230 litres capacity, respectively.
  • Program component 118 aggregates control data of the respective sub-sets. This results in aggregated control data indicating the quantity of 150 litres refrigerators, 170 litre refrigerators and 230 litre refrigerators that have been produced during the day. These aggregated data are transmitted from interface 120 via network 124 to offline computer system 126.
  • Data processing component 130 valuates the aggregated data 122. For example data processing component 130 determines the accumulated values of 150 litres, 170 litres, and 230 litre refrigerators that have been produced during the day on the basis of aggregated data 122 and predefined refrigerator costs that do not depend on the refrigerators colour. The resulting values are posted in off-line database 128 that has the role of an electronic ledger.
  • FIG. 2 shows a corresponding flow diagram.
  • control data received from the automation components of the industrial control system is stored in the on-line database during the ongoing production.
  • control data that is of interest for reporting to external computer system is retrieved from the on-line database (step 202).
  • This data is aggregated in step 204 and then transmitted to the off-line computer system in step 206.
  • the aggregated data is stored on a database of the offline computer system in step 208.
  • This method has the advantage that the computer system of the industrial control system is not burdened with the reporting of data to the external computer system or only to an extend which does not jeopardise the real-time capability of the industrial control systems computer system. Further, this limits the amount of data that needs to be transmitted over network 124 as only aggregated data having a level of granularity that corresponds to the needs of the external computer system is transmitted. This has the further beneficial consequence that the loading of the external computer system is also minimised in terms of both storage and data processing requirements.
  • Figure 3 illustrates the message flow from computer system 104 to offline computer system 126 using SAP's exchange infrastructure (XI).
  • XI SAP's exchange infrastructure
  • computer system 104 takes the role of the sending component.
  • Program component 118 takes the role of a sending application whereas interface 120 is realised by means of an outbound proxy.
  • computer system 126 takes the role of a receiving component system; data processing component 130 takes the role of a receiving application and interface 132 is realised as an inbound proxy.
  • program component 118 calls the outbound proxy of interface 120. This causes the generation of a message 134 as a XML document.
  • the message 134 includes a header 136 that contains information about the sender, and the outbound interface and a body 138 that contains the outbound document, i.e. aggregated data 122.
  • integration server 142 uses a routing framework 140 to determine the receiver and the inbound interface according to the routing rules 144 of a routing model directly 146 contained within an integration directory 148.
  • the header 136 of the message 134 is modified to contain the receiver and the inbound interface. Then, using a mapping framework 150 that communicates with a mapping directory 152, the message
  • the body 138 of the message 134 contains the document converted to the inbound format, i.e. the structure that the receiver understands.
  • the physical address of the receiver is determined using the data of the system landscape directory and by communicating with a service directory 154. The determination of the technical addressing information is performed by physical address resolution framework 156 on this basis. That information is added to the header 136 of the message 134 and the message is sent to the receiving computer system 126.
  • integration server 142 and integration directory 148 provide a transport layer for transmitting of message 134 from the program component 118, i.e. the sending application, to the data processing component 130, i.e. the receiving application.
  • XI XI-XI
  • various receiving computer systems can be coupled to computer system 104 without a need to change computer system 104 and its data formats. This is especially important to maintain computer system's 104 real-time capabilities irrespective of the needs of the external receiving computer system.
  • Figure 4 shows industrial control system 400 that controls a manufacturing process for the mass production of certain kinds of products, such as a product 458 which is shown in figure 4 by way of an example.
  • the product 458 has an assigned identification code for identification of the product 458 within industrial control system 400 and / or for global identification.
  • the product 458 carries the identification code as a bar code label 460, as a radio frequency identification (RFID) tag or by other machine readable means.
  • RFID radio frequency identification
  • the industrial control system 400 has various automation components 402 which control machines for the production of the product 458. At least some of the automation components 402 have readers 462, such as bar code readers or RFID readers, for reading the identification code from the product 458 when it travels along the manufacturing line.
  • readers 462 such as bar code readers or RFID readers
  • a field bus 406 connects the automation components 402 to a computer system 404.
  • the computer system 404 has real time or at least near real time capabilities. It includes a program component 410 for providing a manufacturing control functionality, such as the provision of various proportional (P), proportional integral (PI) and / or proportional integral differential (PID) controllers for the control of the automation components 402.
  • P proportional
  • PI proportional integral
  • PID proportional integral differential
  • the computer system 404 has online database 412 for storage of manufacturing events. Manufacturing events are reported from the automation components 402 via the field bus 406 and are stored in the online database 412 for later reference. For example, when the product 458 reaches one of the automation components 402 as it travels along the manufacturing line the automation component 402 reads the bar code label 406 of the product 458 and performs a manufacturing step on the product 458.
  • the automation component 402 generates a message 464 that contains the identification code of the product 458 and a code that describes the manufacturing event, e.g. the manufacturing step that has been performed on the product 458.
  • the message 464 is transmitted via the field bus 406 and is received by the computer system 404.
  • the computer system 404 stores the content of the message 464 in online database 412.
  • the computer system 466 is coupled to the online database 412 via a network 468.
  • the computer system 466 can be an offline computer system that does not have real time or near real time capabilities.
  • the computer system 466 serves for extraction and aggregation of data from the online database 412.
  • the computer system 466 has storage 470 for storage of customising data that specifies the timing of the extractions to be performed and / or the aggregation level.
  • the program component 414 of the computer system 466 serves to perform a pre-defined database query of online database 412 in order to determine a sub-set of the data that is of interest for the aggregation. Such a database query can be triggered by the program component 416 that implements a timer.
  • the response that is returned from the online database 412 is processed by the program component 418 that aggregates the data.
  • the industrial control system 400 serves for the manufacturing control of various manufacturing lines for the production of various kinds of products, such as washing machines, dish washers and other household applicances products.
  • the customising data stored in the storage 470 can specify 'washing machines' or special types of washing machines as the aggregation level and 'daily' for the timing of the data extraction and aggregation.
  • the program component 416 triggers the program component 414 daily e.g. after the final shift of a working day, in accordance with the customising data.
  • the program component 414 generates a query 472 which is sent via the network 468 to the online database 412.
  • the online database 412 responds with a hit list 474 that contains the manufacturing event data that matches the query 472.
  • the query 472 contains a search string that specifies 'washing machines' or special kinds of washing machines.
  • the hit list 474 contains the data stored in the online database that concerns 'washing machines'.
  • the product type is encoded in the identification codes in order to facilitate the generation of the query 472 and the execution of the query by the online database 412.
  • the data contained in the hit list 474 is processed by the program component 418 in order to perform the aggregation.
  • the aggregation is performed by counting the number of 'washing machines' or special kinds of washing machines that have been produced during the working day.
  • a computer system 426 is coupled to the computer system 466 via a network 424.
  • the network 424 can be identical to network 468 or it can be another network, such as a company's intranet or the Internet.
  • the computer system 426 does not need to have real time or near real time capabilities.
  • the computer system 426 has an offline database 428 for storage of aggregated data 422 that is generated by the program component 418 and transmitted via the network 424 to the computer system 426. Further, the computer system 426 has a data processing component 430 for analysis of the aggregated data 422 stored in the offline database 428.
  • the computer system 426 has a user interface 476 for a user's selection of an aggregation level and / or of the timing of the data extraction and aggregation. This user selection can be an alternative to the customising data or it can complement the customising data stored in the offline computer system 466.
  • a command 478 is generated by the computer system 426 and sent to the computer system 466 via the network 424.
  • the data contained in the command 478 is stored in the storage 470 as customising data in order to control the program components 414, 416 and 418 as described above.
  • FIG. 5 shows a corresponding flow chart.
  • an aggregation level and / or data extraction and aggregation timing is selected. This can be done by entering corresponding customising data into the computer system 466 or by making a corresponding entry by means of the user interface 476 of the computer system 426 (cf. figure 4). If the entry of the selection is performed by means of the user interface 476 a control command is generated in step 502 which is transmitted to the computer system that performs the data extraction and aggregation (cf. command 478 of figure 4).
  • step 504 the online database that contains the manufacturing data is queried in accordance with the selected aggregation level (step 504).
  • step 506 the data that is returned by the online database is aggregated in accordance with the selected aggregation level and in step 508 the aggregated data is returned for storage in an offline database and / or for viewing by a user and / or for further data analysis.
  • Figure 6 shows an example of a window 600 that is generated by the user interface 476 for a user's entry of a selection of the aggregation level and / or data extraction and aggregation timing.
  • the window 600 has a number of pulldown menus 602, 604, 606, ... in order to facilitate a user's entry of a selection of an aggregation level.
  • the pull-down menu contains all product categories that are produced in the manufacturing lines controlled by the industrial control system.
  • Product categories may include various categories of household appliances, such as washing machines, dish washers, ...
  • Pull-down menu 604 serves for specification of a product type. For example, the user may first select the product category using the pull-down menu 602. In the next step the user can select the product type by means of the pull-down menu 604.
  • the pull-down menu 604 contains all product types of the selected product category.
  • the user can select the product colour using the pull-down menu 606.
  • the pull-down menu 606 shows all colours and their colour codes that are used in the manufacturing.
  • each identification code has a code portion that encodes the product category, a code portion that encodes the product type and a code portion that carries the colour code.
  • the query can contain a combination of the code portions that are selected using the window 600.
  • the window 600 can contain a pull-down menu 608 for selection of a data extraction time.
  • the pull-down menu 608 may contain certain points of time, time intervals or events for a user's selection as a trigger point for performance of the data extraction and aggregation.

Abstract

The present invention relates to a data processing method comprising: - receiving of control data (108), e.g. the number of pieces produced, from automation components (102) of an industrial control system (100) by a first computer system (104), the first computer system being coupled to the automation components by means of a first network (106), - storing of at least some of the control data in a first database (112) by the first computer system, - performing a database query of the first database for determination of a sub-set of the control data, - aggregation of the control data of the sub-set, - transmission of the aggregated control data (122) to a second computer system (126) over a second network (124). The second computer system performs for instance an off-line financial valuation. With this method, database queries do not negatively impact the real-time manufacturing control tasks carried out by the first computer system.

Description

INDUSTRIAL CONTROL SYSTEM AND DATA PROCESSING METHOD THEREFORE
Description
Field of the invention
The present invention relates to the field of industrial control systems, and more particularly to data processing methods in industrial control systems.
Background and prior art
Sophisticated industrial processes, such as oil refining, automobile assembly or power generation, require the cooperative execution of numerous interdependent tasks by many different pieces of equipment. The enormous complexity of ensuring proper task sequencing and management, which requires not only procedural logic but constant monitoring of equipment states to organize and distribute operations and detect malfunction, has resulted in the widespread adoption of programmable controllers.
These controllers operate elaborate industrial equipment in accordance with a stored control program. When executed, the program causes the controller to examine the state of the controlled machinery by evaluating signals from one or more sensing devices (e.g., temperature or pressure sensors), and to operate the machinery (e.g., by energizing or de-energizing operative components) based on a procedural framework, the sensor signals and, if necessary, more complex processing. The "inputs" to a particular controller can extend beyond the sensed state of the equipment the controller directly operates to include, for example, its environment, the state of related machinery or the state of its controllers.
Control requirements become even more complex when different aspects of the same overall process are assigned to remotely situated equipment. Such configurations often require reliable, high-bandwidth, and real-time serial communication links to provide the necessary interconnection and handle data transfer among controllers and the sensors relevant to their operation.
Ordinarily, process operation is monitored, at least intermittently, by supervisory personnel by means of one or more central management stations. Each station samples the status of controllers (and their associated sensors) selected by the operator and presents the data in some meaningful format. The management station may or may not be located on the same site as the monitored equipment; frequently, one central station has access to multiple sites (whether or not these perform related processes). Accordingly, communication linkage can be vital even in traditional industrial environments where process equipment is physically proximate, since at least some supervisory personnel may not be.
To facilitate the necessary communication, the controller processors and related computers (such as monitoring stations) are arranged as a computer network. A network, basically, is a collection of interconnected computers that use some consistent protocol to communicate with one another. Typically, the network is organized such that any computer may communicate with any other network computer. The communication protocol provides a mechanism by which messages can be decomposed and routed to a destination computer identified by some form of address.
Typically the various components of such an industrial control system are interconnected by means of a field bus having real-time capability, such as PROFIBUS or real-time Ethernet. Such bus systems have real-time capability in order to guarantee maximum latency times for transmission of control data between the various components of the industrial control system.
US Pat. Nos. 5,805,442 6,484,0621 B2; 5,461 ,570; 5,301 ,120; 6,321 , 272B1 and EP1204042A1 ; EP138507082; FR2765364; FR2814252 show examples for such prior art industrial control systems.
Summary of the invention
The present invention provides for a data processing method for use in an industrial control system. A computer system of the industrial control system receives control data from various automation components, such as controllers, sensors, actuators and/or data entry terminals. The automation components and the computer system are coupled by means of a network, such as a realtime field bus.
The computer system has a database for storing of the control data. The database is queried in order to determine a sub-set of the control data. Control data of the sub-set is aggregated and transmitted to an external computer system over another network for offline processing of the aggregated control data.
Preferably the database query is performed when the load of the real-time network is low. A database query can be triggered by a component that monitors network load. Alternatively the database query is triggered at predefined points of time. This has the advantage that the real-time capability of the computer system is not negatively influenced by query and the transmission of the control data to the external computer system.
Further this has the advantage that the amount of data that is transmitted from the computer system of the industrial control system to the external computer system is reduced. As a further consequence the storage and data processing capacity requirements for the external computer system are also reduced as the external computer system does not receive the raw control data but aggregated control data for further offline processing. In accordance with a preferred embodiment of the invention the control data is expressive of a quantity of a valuation unit. A valuation unit can be any entity that is used or occurs in the production process and that has a financial value, such as a product unit or a work unit. Preferably each valuation unit is identified by means of a unique identifier. The aggregation of the control data is performed based on pre-defined similarity criteria of the valuation units. The similarity criteria determine the level of granularity that is required for the later off-line processing by the external computer system.
For example, various types of household appliances are produced in a factory, such as refrigerators of various sizes. In this example the level of granularity that is of interest for the off-line processing may be the size of the refrigerators, whereas the colours of the refrigerators are of no interest. Hence the amount of refrigerators of a given size that are reported from the automation components are aggregated and transmitted to the external computer system.
In accordance with a preferred embodiment of the invention the unique identifiers that are used to designate the valuation units have a hierarchical structure. In this instance a pre-defined portion of the unique identifiers is used to define clusters of the valuation units for the purpose of aggregating the respective control data. For example all valuation units that have an identical sequence of leading bit positions of their unique identifiers are considered to be similar for the purpose of aggregating the respective control data.
In accordance with a further preferred embodiment of the invention the off-line computer system performs a financial valuation of the aggregated control data. In other words, the off-line computer system calculates a monetary value for similar valuation units that have been reported from the industrial control system. These monetary values are entered as postings in a ledger, such as for the purpose of book keeping, financial evaluation and/or financial reporting.
In accordance with a further preferred embodiment of the invention, the aggregated control data is transmitted from the industrial control system to the external computer system by means of a document. Preferably SAP's exchange infrastructure (XI) is used for this purpose. Alternatively, other types of self- descriptive documents can be used, such as mark-up language documents, e.g. hypertext mark up language (HTML) or extended mark up language (XML) documents.
Brief description of the drawings
In the following preferred embodiments of the invention will be described in greater detail by way of example only with reference to the drawings in which:
Figure 1 is a block diagram of a preferred embodiment of an industrial control system of the invention,
Figure 2 is a flow diagram of a preferred embodiment of a data processing method of the invention,
Figure 3 is a block diagram illustrating usage of the exchange infrastructure (XI) for transmission of aggregated control data,
Figure 4 is a block diagram of a further preferred embodiment of an industrial control system of the invention,
Figure 5 is a flow diagram of a further preferred embodiment of a data processing method of the invention,
Figure 6 is an embodiment of a window for a user's selection of an aggregation level.
Detailed description
Figure 1 shows industrial control system 100 that controls a manufacturing process. Industrial control system 100 has various automation components 102, such as sensors, actuators, intelligent drives, controllers, etc. Further industrial control system 100 has computer system 104 that provides a control functionality. Network 106 interconnects the automation components 102 and computer system 104. Computer system 104 receives various control data 108 from automation components 102. Control data 108 may include measurement values, such as speed, temperature, humidity, or logical information regarding the state of an automation component 102. Further control data 108 includes messages that indicate quantities of valuation units.
The term "valuation unit" may include a product unit or a product sub-unit, a component or other kind of material that is used for the ongoing production as well as a work unit, such as manufacturing service provided by a human and/or a machine. Each type of valuation unit is identified by a unique identifier that is transmitted as part of the control data 108 to computer system 104.
Computer system 104 has program component 110 for providing a manufacturing control functionality on the basis of the control data 108 that is received by computer system 104. Further computer system 104 has online database 112 for storage of at least some of the control data 108 that contains data concerning the valuation units.
Program component 114 serves to perform a predefined database query in order to determine a sub-set of the control data that is stored in on-line database 112. Such a database query is triggered by program component 116. Program component 116 can be implemented as a timer that has a pre-defined timer value. When the timer expires program component 116 triggers program component 114 to execute the database query. Alternatively program component 116 monitors the present load situation of network 106 and/or the present data processing load of computer system 104. When the actual load is below a threshold value this indicates that computer system 104 has sufficient unused capacity in order to perform the database query without negatively impacting the real-time capability of program component 110.
Program component 118 serves to aggregate control data that has been extracted from online database 112 as a result of the query that has been performed by program component 114. For example program component 118 aggregates control data of similar valuation units.
Further computer system 104 has interface 120 for transmitting of aggregated data 122 via network 124 to off-line computer system 126.
It is important to note that network 106 of industrial control system 100 as well as program component 110 and online database 112 have real-time capabilities. In other words maximum latency times for transmitting, storing, processing and responding to control data 108 that is received by computer system 104 via network 106 need to be guaranteed under all circumstances in order to ensure proper functioning of industrial control system 100.
In contrast network 124 and computer system 126 do not need to have such real-time capabilities as computer system 126 is not directly involved in the ongoing process control. Computer system 126 has off-line database 128 for storage of aggregated data 122. This can have the purpose of documentation of the ongoing process, such as for the purpose of product liability documentation, and/or other reporting purposes.
In operation, control data 108 is reported from the automation components 102 to computer system 104. For the purpose of explanation it is assumed that refrigerators of various colours and sizes are produced in the production process, e.g. red, blue, and white refrigerators having capacities of 150 litres, 170 litres and 230 litres. For the purpose of valuation only the number of refrigerators of a certain size irrespective of colour is of interest.
Program component 114 has corresponding predefined database queries for determining control data relating to refrigerators having 150 litres, 170 litres and 230 litres capacity respectively, irrespective of colour.
In the example considered here the production of the refrigerators is interrupted during the night. Program component 116 has a timer that is programmed to trigger program component 114 one hour after the stop of the production. Program component 114 executes its queries in order to extract a sub-set of control data relating to refrigerators that have been produced during the day having 150 litres capacity and separate sub-sets of the control data relating to such refrigerators having 170 litres and 230 litres capacity, respectively.
Program component 118 aggregates control data of the respective sub-sets. This results in aggregated control data indicating the quantity of 150 litres refrigerators, 170 litre refrigerators and 230 litre refrigerators that have been produced during the day. These aggregated data are transmitted from interface 120 via network 124 to offline computer system 126.
Data processing component 130 valuates the aggregated data 122. For example data processing component 130 determines the accumulated values of 150 litres, 170 litres, and 230 litre refrigerators that have been produced during the day on the basis of aggregated data 122 and predefined refrigerator costs that do not depend on the refrigerators colour. The resulting values are posted in off-line database 128 that has the role of an electronic ledger.
Figure 2 shows a corresponding flow diagram. In step 200 control data received from the automation components of the industrial control system is stored in the on-line database during the ongoing production. When the network load of the real-time network of the industrial control system is low or zero, such as when the production process is interrupted during the night, control data that is of interest for reporting to external computer system is retrieved from the on-line database (step 202). This data is aggregated in step 204 and then transmitted to the off-line computer system in step 206. The aggregated data is stored on a database of the offline computer system in step 208.
This method has the advantage that the computer system of the industrial control system is not burdened with the reporting of data to the external computer system or only to an extend which does not jeopardise the real-time capability of the industrial control systems computer system. Further, this limits the amount of data that needs to be transmitted over network 124 as only aggregated data having a level of granularity that corresponds to the needs of the external computer system is transmitted. This has the further beneficial consequence that the loading of the external computer system is also minimised in terms of both storage and data processing requirements.
Figure 3 illustrates the message flow from computer system 104 to offline computer system 126 using SAP's exchange infrastructure (XI). In the XI framework computer system 104 takes the role of the sending component. Program component 118 takes the role of a sending application whereas interface 120 is realised by means of an outbound proxy.
Likewise computer system 126 takes the role of a receiving component system; data processing component 130 takes the role of a receiving application and interface 132 is realised as an inbound proxy. Initially, program component 118 calls the outbound proxy of interface 120. This causes the generation of a message 134 as a XML document.
The message 134 includes a header 136 that contains information about the sender, and the outbound interface and a body 138 that contains the outbound document, i.e. aggregated data 122. Using a routing framework 140, integration server 142 then determines the receiver and the inbound interface according to the routing rules 144 of a routing model directly 146 contained within an integration directory 148.
After this determination the header 136 of the message 134 is modified to contain the receiver and the inbound interface. Then, using a mapping framework 150 that communicates with a mapping directory 152, the message
134 is transformed from the senders format and values into the receivers format and values. After this transformation, the body 138 of the message 134 contains the document converted to the inbound format, i.e. the structure that the receiver understands. Finally, the physical address of the receiver is determined using the data of the system landscape directory and by communicating with a service directory 154. The determination of the technical addressing information is performed by physical address resolution framework 156 on this basis. That information is added to the header 136 of the message 134 and the message is sent to the receiving computer system 126. In essence integration server 142 and integration directory 148 provide a transport layer for transmitting of message 134 from the program component 118, i.e. the sending application, to the data processing component 130, i.e. the receiving application.
The usage of XI has the advantage that various receiving computer systems can be coupled to computer system 104 without a need to change computer system 104 and its data formats. This is especially important to maintain computer system's 104 real-time capabilities irrespective of the needs of the external receiving computer system.
Figure 4 shows industrial control system 400 that controls a manufacturing process for the mass production of certain kinds of products, such as a product 458 which is shown in figure 4 by way of an example. The product 458 has an assigned identification code for identification of the product 458 within industrial control system 400 and / or for global identification. The product 458 carries the identification code as a bar code label 460, as a radio frequency identification (RFID) tag or by other machine readable means.
The industrial control system 400 has various automation components 402 which control machines for the production of the product 458. At least some of the automation components 402 have readers 462, such as bar code readers or RFID readers, for reading the identification code from the product 458 when it travels along the manufacturing line.
A field bus 406 connects the automation components 402 to a computer system 404. The computer system 404 has real time or at least near real time capabilities. It includes a program component 410 for providing a manufacturing control functionality, such as the provision of various proportional (P), proportional integral (PI) and / or proportional integral differential (PID) controllers for the control of the automation components 402.
Further, the computer system 404 has online database 412 for storage of manufacturing events. Manufacturing events are reported from the automation components 402 via the field bus 406 and are stored in the online database 412 for later reference. For example, when the product 458 reaches one of the automation components 402 as it travels along the manufacturing line the automation component 402 reads the bar code label 406 of the product 458 and performs a manufacturing step on the product 458.
The automation component 402 generates a message 464 that contains the identification code of the product 458 and a code that describes the manufacturing event, e.g. the manufacturing step that has been performed on the product 458. The message 464 is transmitted via the field bus 406 and is received by the computer system 404. The computer system 404 stores the content of the message 464 in online database 412.
The computer system 466 is coupled to the online database 412 via a network 468. The computer system 466 can be an offline computer system that does not have real time or near real time capabilities. The computer system 466 serves for extraction and aggregation of data from the online database 412.
In the embodiment considered here the computer system 466 has storage 470 for storage of customising data that specifies the timing of the extractions to be performed and / or the aggregation level. The program component 414 of the computer system 466 serves to perform a pre-defined database query of online database 412 in order to determine a sub-set of the data that is of interest for the aggregation. Such a database query can be triggered by the program component 416 that implements a timer. The response that is returned from the online database 412 is processed by the program component 418 that aggregates the data.
For example, the industrial control system 400 serves for the manufacturing control of various manufacturing lines for the production of various kinds of products, such as washing machines, dish washers and other household applicances products. For example, the customising data stored in the storage 470 can specify 'washing machines' or special types of washing machines as the aggregation level and 'daily' for the timing of the data extraction and aggregation.
Hence, the program component 416 triggers the program component 414 daily e.g. after the final shift of a working day, in accordance with the customising data. In response the program component 414 generates a query 472 which is sent via the network 468 to the online database 412.
The online database 412 responds with a hit list 474 that contains the manufacturing event data that matches the query 472. In the example considered here the query 472 contains a search string that specifies 'washing machines' or special kinds of washing machines. The hit list 474 contains the data stored in the online database that concerns 'washing machines'. Preferably, the product type is encoded in the identification codes in order to facilitate the generation of the query 472 and the execution of the query by the online database 412.
The data contained in the hit list 474 is processed by the program component 418 in order to perform the aggregation. In the example considered here the aggregation is performed by counting the number of 'washing machines' or special kinds of washing machines that have been produced during the working day.
A computer system 426 is coupled to the computer system 466 via a network 424. The network 424 can be identical to network 468 or it can be another network, such as a company's intranet or the Internet.
As computer system 466 the computer system 426 does not need to have real time or near real time capabilities.
The computer system 426 has an offline database 428 for storage of aggregated data 422 that is generated by the program component 418 and transmitted via the network 424 to the computer system 426. Further, the computer system 426 has a data processing component 430 for analysis of the aggregated data 422 stored in the offline database 428. The computer system 426 has a user interface 476 for a user's selection of an aggregation level and / or of the timing of the data extraction and aggregation. This user selection can be an alternative to the customising data or it can complement the customising data stored in the offline computer system 466.
In response to a user's entry of a selection of the aggregation level and / or data extraction and aggregation timing, a command 478 is generated by the computer system 426 and sent to the computer system 466 via the network 424. The data contained in the command 478 is stored in the storage 470 as customising data in order to control the program components 414, 416 and 418 as described above.
Figure 5 shows a corresponding flow chart. In step 500 an aggregation level and / or data extraction and aggregation timing is selected. This can be done by entering corresponding customising data into the computer system 466 or by making a corresponding entry by means of the user interface 476 of the computer system 426 (cf. figure 4). If the entry of the selection is performed by means of the user interface 476 a control command is generated in step 502 which is transmitted to the computer system that performs the data extraction and aggregation (cf. command 478 of figure 4).
In step 504 the online database that contains the manufacturing data is queried in accordance with the selected aggregation level (step 504). In step 506 the data that is returned by the online database is aggregated in accordance with the selected aggregation level and in step 508 the aggregated data is returned for storage in an offline database and / or for viewing by a user and / or for further data analysis.
Figure 6 shows an example of a window 600 that is generated by the user interface 476 for a user's entry of a selection of the aggregation level and / or data extraction and aggregation timing. The window 600 has a number of pulldown menus 602, 604, 606, ... in order to facilitate a user's entry of a selection of an aggregation level. For example, the pull-down menu contains all product categories that are produced in the manufacturing lines controlled by the industrial control system. Product categories may include various categories of household appliances, such as washing machines, dish washers, ...
Pull-down menu 604 serves for specification of a product type. For example, the user may first select the product category using the pull-down menu 602. In the next step the user can select the product type by means of the pull-down menu 604. The pull-down menu 604 contains all product types of the selected product category. In addition or alternatively the user can select the product colour using the pull-down menu 606. The pull-down menu 606 shows all colours and their colour codes that are used in the manufacturing.
Preferably the pull-down menus 602, 604, 606, ... correspond to the structure of the product identification codes used for identification of the products. For example, each identification code has a code portion that encodes the product category, a code portion that encodes the product type and a code portion that carries the colour code. This facilitates generation of the query (cf. query 472 of figure 4), especially if the code portions are used as database keys. The query can contain a combination of the code portions that are selected using the window 600.
In addition, the window 600 can contain a pull-down menu 608 for selection of a data extraction time. For example, the pull-down menu 608 may contain certain points of time, time intervals or events for a user's selection as a trigger point for performance of the data extraction and aggregation. List of Reference Numerals
100 industrial control system
102 automation components
104 computer system
106 network
108 control data
110 program component
112 online database
114 program component
116 program component
118 program component
120 interface
122 aggregated data
124 network
126 computer system
128 off-line database
130 data processing component
132 interface
134 message
136 header
138 body
140 routing framework
142 integration server
144 routing rules
146 routing module directory
148 integrator directory
150 mapping framework
152 mapping directory
154 service directory
156 resolution framework 400 industrial control system
402 automation component
404 computer system
406 field bus
412 online database
414 program component
416 program component
418 program component
422 aggregated data
424 network
426 computer system
428 off-line database
430 data processing component
462 reader
464 message
466 computer system
468 network
470 storage
472 query
474 hit list
476 user interface
478 command
458 products
460 bar code label
600 window
602 pull-down menu
604 pull-down menu
606 pull-down menu
608 pull-down menu

Claims

C L A I M S
1. A data processing method comprising: - receiving of control data (108) from automation components (102) of an industrial control system (100) by a first computer system (104), the first computer system being coupled to the automation components by means of a first network (106),
- storing of at least some of the control data in a first database (112) by the first computer system,
- performing a database query of the first database for determination of a sub-set of the control data,
- aggregation of the control data of the sub-set,
- transmission of the aggregated control data (122) to a second computer system (126) over a second network (124).
2. The data processing method of claim 1 , wherein the control data has a unique identifier of a valuation unit.
3. The method of claim 2, wherein the valuation unit is a product unit or a work unit.
4. The method of claim 1 , 2 or 3, wherein the control data comprises data expressive of a quantity of a valuation unit.
5. The method of any one of any of the preceding claims 1 to 4, wherein the aggregation is performed by aggregation of quantities of similar valuation units.
6. The method of claim 5, wherein similar valuation units are identified based on pre-defined similarity criteria.
7. The method of any one of the preceding claims 1 to 6, wherein the database query is performed when a load of the first network is low.
8. The method of any one of the preceding claims 1 to 7, wherein the database query is performed periodically.
9. The method of any one of the preceding claims 1 to 8, wherein a database query is performed when a pre-programmed timer (116) expires.
10. The method of any one of preceding claims 1 to 9, wherein the first network has real-time capabilities.
11. The method of any one of the preceding claims 1 to 10, wherein the first network is a field bus.
12. The method of any one of the preceding claims 1 to 11 , wherein the second network is an internet protocol (IP)- type network.
13. The method of any one of the preceding claims 1 to 12, further comprising generating a document (122) containing the aggregated control data, wherein the transmission of the control data is performed by transmitting of the document.
14. The method of claim 13, wherein the document is an exchange infrastructure (XI) type document.
15. The method of claim 13, wherein the document is a mark-up language document, such as a hyper text mark-up language (HTML) or extended mark-up language (XML) document.
16. The method of any one of the preceding claims 1 to 15, wherein the second computer is coupled to a second database (128) for storage of the aggregated control data.
17. The method of claim 16, further comprising performing a data processing step by the second computer system for financial valuation of the aggregated control data, wherein the second database is a ledger.
18. A computer program product comprising instructions for: - receiving of control data (108) from automation components (102) of an industrial control system (100) by a first computer system (104), the first computer system being coupled to the automation components by means of a first network (106),
- storing of at least some of the control data in a first database (112) by the first computer system,
- performing a database query of the first database for determination of a sub-set of the control data,
- aggregation of the control data of the sub-set,
- transmission of the aggregated control data (122) to a second computer system (126) over a second network (124).
19. The computer program product of claim 18, wherein the aggregation is performed by aggregation of quantities of similar valuation units.
20. The computer program product of claim 18 or 19, wherein the database query is performed when a load of the first network is low.
21. The computer program product of claim 18, 19 or 20, wherein the first network has real-time capabilities.
22. A computer system for controlling a manufacturing process, the computer system comprising: means (104) for receiving of control data (108) from automation components (108) via a first network (106), a first database (112) for storing at least some of the control data, means (114) for performing a database query for determination of a sub-set of the control data stored in the first database, means (118) for aggregation of control data of the sub-set, - means (120) for transmission of the aggregate control data to an offline computer system.
23. The computer system of claim 22, further comprising means (116) for initiating the database query when a load of the first network is low.
24. The computer system of claim 22 or 23, further comprising control means (110) having real-time capability.
25. The computer system of claim 22, 23 or 24, the first network being a field bus.
26. An industrial control system comprising: a plurality of automation components (102), - a first computer system (104), a real-time network for coupling of the automation components to the first computer system (106), an online database (112) for storing at least some of the control data (108) that are received by the first computer system from the automation components via the real-time network, means (114) for performing a database query for determination of a sub-set of the control data stored in the first database when a load of the real-time network is low, means (118) for aggregation of control data of the sub-set, means (120) for transmission of the aggregated control data to a second computer system via a non-real-time network (124) for offline processing of the aggregated control data by the second computer system.
27. A data processing system comprising an online database (412) for storage of manufacturing data sets (464) each manufacturing data set containing a product identification code, an offline computer system (466) having means (414, 416, 417) for extracting data from the online database and aggregation means (418) for aggregation of a hit list (474) returned from the online database.
28. The data processing system of claim 27, the product identification code having a plurality of code portions, the means for extracting the data being adapted to generate a query that contains one or more of the code portions in order to specify the manufacturing data of interest.
29. The data processing system of claim 28, further comprising a user interface (476), the user interface being adapted to generate a window (600) containing a number of menus (602, 604, 606, ...) for a user's selection of one or more of the code portions.
30. A business method comprising online collection of manufacturing data (464), storage of the manufacturing data in a database (412), extraction and aggregation of a sub-set (474) of the manufacturing data from the database, transmission of the aggregated manufacturing data to an offline computer system (426) for offline analysis of the aggregated data.
PCT/EP2004/013334 2003-12-09 2004-11-24 Industrial control system and data processing method therefore WO2005059667A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
EP04803255A EP1697893B1 (en) 2003-12-09 2004-11-24 Industrial control system and data processing method therefore

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
EP03028318.8 2003-12-09
EP03028318A EP1542105B1 (en) 2003-12-09 2003-12-09 Industrial control system and data processing method therefor

Publications (2)

Publication Number Publication Date
WO2005059667A1 true WO2005059667A1 (en) 2005-06-30
WO2005059667A8 WO2005059667A8 (en) 2005-09-01

Family

ID=34486164

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/EP2004/013334 WO2005059667A1 (en) 2003-12-09 2004-11-24 Industrial control system and data processing method therefore

Country Status (5)

Country Link
US (1) US7603361B2 (en)
EP (2) EP1542105B1 (en)
AT (1) ATE475949T1 (en)
DE (1) DE60333570D1 (en)
WO (1) WO2005059667A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2007101131A2 (en) * 2006-02-23 2007-09-07 Rockwell Automation Technologies, Inc. Electronic token to provide sequential event control and monitoring

Families Citing this family (34)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7330473B1 (en) 2002-04-12 2008-02-12 Rockwell Automation Technologies, Inc. System and methodology providing network data exchange between industrial control components
US7539724B1 (en) 2002-06-04 2009-05-26 Rockwell Automation Technologies, Inc. Instant messaging for event notification and exchanging data in an industrial controller environment
US7512906B1 (en) 2002-06-04 2009-03-31 Rockwell Automation Technologies, Inc. System and methodology providing adaptive interface in an industrial controller environment
US9565275B2 (en) 2012-02-09 2017-02-07 Rockwell Automation Technologies, Inc. Transformation of industrial data into useful cloud information
US7606890B1 (en) 2002-06-04 2009-10-20 Rockwell Automation Technologies, Inc. System and methodology providing namespace and protocol management in an industrial controller environment
US7151966B1 (en) 2002-06-04 2006-12-19 Rockwell Automation Technologies, Inc. System and methodology providing open interface and distributed processing in an industrial controller environment
US7339476B2 (en) * 2004-11-10 2008-03-04 Rockwell Automation Technologies, Inc. Systems and methods that integrate radio frequency identification (RFID) technology with industrial controllers
US7551081B2 (en) 2004-11-10 2009-06-23 Rockwell Automation Technologies, Inc. Systems and methods that integrate radio frequency identification (RFID) technology with agent-based control systems
US7388491B2 (en) 2005-07-20 2008-06-17 Rockwell Automation Technologies, Inc. Mobile RFID reader with integrated location awareness for material tracking and management
US7764191B2 (en) 2005-07-26 2010-07-27 Rockwell Automation Technologies, Inc. RFID tag data affecting automation controller with internal database
US8260948B2 (en) 2005-08-10 2012-09-04 Rockwell Automation Technologies, Inc. Enhanced controller utilizing RFID technology
US7510110B2 (en) 2005-09-08 2009-03-31 Rockwell Automation Technologies, Inc. RFID architecture in an industrial controller environment
US7931197B2 (en) 2005-09-20 2011-04-26 Rockwell Automation Technologies, Inc. RFID-based product manufacturing and lifecycle management
US7446662B1 (en) 2005-09-26 2008-11-04 Rockwell Automation Technologies, Inc. Intelligent RFID tag for magnetic field mapping
US8025227B2 (en) 2005-09-30 2011-09-27 Rockwell Automation Technologies, Inc. Access to distributed databases via pointer stored in RFID tag
US7711735B2 (en) * 2007-05-15 2010-05-04 Microsoft Corporation User segment suggestion for online advertising
US9767495B2 (en) * 2008-12-19 2017-09-19 Sap Se Different sales and planning product options
US20100161366A1 (en) * 2008-12-19 2010-06-24 Achim Clemens Product requirement specification in production model
WO2012080995A1 (en) * 2010-12-13 2012-06-21 Ricky Gondosubroto Web-based data acquisition system and method
US9477936B2 (en) 2012-02-09 2016-10-25 Rockwell Automation Technologies, Inc. Cloud-based operator interface for industrial automation
CN102981498B (en) * 2012-11-22 2014-08-13 北京广利核系统工程有限公司 Independent test link for distributed control system (DCS) field control station system diagnosis
US9703902B2 (en) 2013-05-09 2017-07-11 Rockwell Automation Technologies, Inc. Using cloud-based data for industrial simulation
US9989958B2 (en) 2013-05-09 2018-06-05 Rockwell Automation Technologies, Inc. Using cloud-based data for virtualization of an industrial automation environment
US10026049B2 (en) 2013-05-09 2018-07-17 Rockwell Automation Technologies, Inc. Risk assessment for industrial systems using big data
US9786197B2 (en) 2013-05-09 2017-10-10 Rockwell Automation Technologies, Inc. Using cloud-based data to facilitate enhancing performance in connection with an industrial automation system
US9438648B2 (en) 2013-05-09 2016-09-06 Rockwell Automation Technologies, Inc. Industrial data analytics in a cloud platform
US9709978B2 (en) 2013-05-09 2017-07-18 Rockwell Automation Technologies, Inc. Using cloud-based data for virtualization of an industrial automation environment with information overlays
US9600805B2 (en) 2013-06-25 2017-03-21 Sap Se Presenting information on a mobile communication device
US11513477B2 (en) 2015-03-16 2022-11-29 Rockwell Automation Technologies, Inc. Cloud-based industrial controller
US11042131B2 (en) 2015-03-16 2021-06-22 Rockwell Automation Technologies, Inc. Backup of an industrial automation plant in the cloud
US10496061B2 (en) 2015-03-16 2019-12-03 Rockwell Automation Technologies, Inc. Modeling of an industrial automation environment in the cloud
US11243505B2 (en) 2015-03-16 2022-02-08 Rockwell Automation Technologies, Inc. Cloud-based analytics for industrial automation
US20180107191A1 (en) 2015-04-17 2018-04-19 Tulip Interfaces, Inc. Monitoring tool usage
WO2019006590A1 (en) * 2017-07-03 2019-01-10 深圳配天智能技术研究院有限公司 Communication method for industrial control system, and industrial control system

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5301120A (en) * 1991-07-23 1994-04-05 Nissei Plastic Industrial Co., Ltd. Method of collecting data of a group of injection molding machines
US5461570A (en) * 1994-06-10 1995-10-24 Johnson & Johnson Vision Products, Inc. Computer system for quality control correlations
FR2765364A1 (en) * 1997-06-26 1998-12-31 Air Liquide REMOTE MONITORING INSTALLATION OF A PARK OF HETEROGENEOUS EQUIPMENT OF INDUSTRIAL PRODUCTION
US5964656A (en) * 1998-05-19 1999-10-12 Meat Processing Service Corp. Inc. Radio frequency identification device and method of use
US6321272B1 (en) * 1997-09-10 2001-11-20 Schneider Automation, Inc. Apparatus for controlling internetwork communications
FR2814252A1 (en) * 2000-09-15 2002-03-22 Avensy Ingenierie IMPROVED COMPUTER-AIDED PRODUCTION MONITORING SYSTEM
EP1204042A1 (en) * 2000-11-06 2002-05-08 Ricoh Company, Ltd. Method, device and computer program for image processing, and image forming device
US20030158795A1 (en) * 2001-12-28 2003-08-21 Kimberly-Clark Worldwide, Inc. Quality management and intelligent manufacturing with labels and smart tags in event-based product manufacturing
EP1385070A2 (en) * 2002-07-24 2004-01-28 KUKA Roboter GmbH Method and device for controlling a plant

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4408291A (en) * 1979-06-15 1983-10-04 M. Wile & Company, Inc. Point-of-manufacture data acquisition system
US5537590A (en) * 1993-08-05 1996-07-16 Amado; Armando Apparatus for applying analysis rules to data sets in a relational database to generate a database of diagnostic records linked to the data sets
US6256624B1 (en) * 1998-08-17 2001-07-03 Qwest Communications International, Inc. Computing system for operating report production facilities
US7054919B2 (en) * 2001-06-15 2006-05-30 Ei3 Corporation System and method for providing virtual online engineering of a production environment
US6839713B1 (en) * 2001-07-12 2005-01-04 Advanced Micro Devices, Inc. System and software for database structure in semiconductor manufacturing and method thereof
US6868439B2 (en) * 2002-04-04 2005-03-15 Hewlett-Packard Development Company, L.P. System and method for supervising use of shared storage by multiple caching servers physically connected through a switching router to said shared storage via a robust high speed connection
US7792797B2 (en) * 2002-12-24 2010-09-07 International Business Machines Corporation Fail over resource manager access in a content management system
US20050065839A1 (en) * 2003-09-22 2005-03-24 Debra Benson Methods, systems and computer program products for generating an aggregate report to provide a certification of controls associated with a data set

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5301120A (en) * 1991-07-23 1994-04-05 Nissei Plastic Industrial Co., Ltd. Method of collecting data of a group of injection molding machines
US5461570A (en) * 1994-06-10 1995-10-24 Johnson & Johnson Vision Products, Inc. Computer system for quality control correlations
FR2765364A1 (en) * 1997-06-26 1998-12-31 Air Liquide REMOTE MONITORING INSTALLATION OF A PARK OF HETEROGENEOUS EQUIPMENT OF INDUSTRIAL PRODUCTION
US6321272B1 (en) * 1997-09-10 2001-11-20 Schneider Automation, Inc. Apparatus for controlling internetwork communications
US5964656A (en) * 1998-05-19 1999-10-12 Meat Processing Service Corp. Inc. Radio frequency identification device and method of use
FR2814252A1 (en) * 2000-09-15 2002-03-22 Avensy Ingenierie IMPROVED COMPUTER-AIDED PRODUCTION MONITORING SYSTEM
EP1204042A1 (en) * 2000-11-06 2002-05-08 Ricoh Company, Ltd. Method, device and computer program for image processing, and image forming device
US20030158795A1 (en) * 2001-12-28 2003-08-21 Kimberly-Clark Worldwide, Inc. Quality management and intelligent manufacturing with labels and smart tags in event-based product manufacturing
EP1385070A2 (en) * 2002-07-24 2004-01-28 KUKA Roboter GmbH Method and device for controlling a plant

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2007101131A2 (en) * 2006-02-23 2007-09-07 Rockwell Automation Technologies, Inc. Electronic token to provide sequential event control and monitoring
WO2007101131A3 (en) * 2006-02-23 2008-01-17 Rockwell Automation Tech Inc Electronic token to provide sequential event control and monitoring
US7616095B2 (en) 2006-02-23 2009-11-10 Rockwell Automation Technologies, Inc. Electronic token to provide sequential event control and monitoring

Also Published As

Publication number Publication date
EP1697893B1 (en) 2012-07-04
DE60333570D1 (en) 2010-09-09
ATE475949T1 (en) 2010-08-15
US20050125441A1 (en) 2005-06-09
WO2005059667A8 (en) 2005-09-01
US7603361B2 (en) 2009-10-13
EP1697893A1 (en) 2006-09-06
EP1542105A1 (en) 2005-06-15
EP1542105B1 (en) 2010-07-28

Similar Documents

Publication Publication Date Title
EP1697893B1 (en) Industrial control system and data processing method therefore
US11675344B2 (en) Systems and methods for maintaining equipment in an industrial automation environment
EP2045684B1 (en) Contextualization for historians in industrial systems
EP1880253B1 (en) Distributed database in an industrial automation environment
EP0965897B1 (en) Field device management system
CN101351752B (en) Method for monitoring installations by means of a field bus used in process automation technology
JP5156074B2 (en) Interface module for use with MODBUS device network and Fieldbus device network
EP1643325B1 (en) Directory structure in distributed data driven architecture environment
CN104954242A (en) Unified data ingestion adapter for migration of industrial data to a cloud platform
CN110971666A (en) Internet of things management system and communication method thereof
CN104635686A (en) Targeted resource allocation
JP2004511845A (en) PLC executed by an integrated web server
CN101408767A (en) Correlation of non-times series events in industrial systems
Coito et al. A novel framework for intelligent automation
CN101135894A (en) Built-in rotating machinery operation monitoring protecting equipment and setting method thereof
CN108139746A (en) The device and method in general manner setting, being monitored and controlled the field device of facility
CN110291242A (en) Utilize the production information computing system and its method of needle-bit sensor signal
CN101923320B (en) For storing the system and method for the data from industrial control unit (ICU)
US7254521B2 (en) System and method for condition-based maintenance
CN101963804A (en) Management-control integrated flexible assembly line for mechanical products
EP3958079A1 (en) Inter-plant communication
JP6898280B2 (en) Knowledge creation system
Tang et al. Development of upper computer software based on OPC UA technology
KR20220056936A (en) Apparatus and method for acquiring data
Shin Trend of process automation and factory automation

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GM KE LS MW MZ NA SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LU MC NL PL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
CFP Corrected version of a pamphlet front page
CR1 Correction of entry in section i

Free format text: IN PCT GAZETTE 26/2005 UNDER (72, 75) REPLACE "ACHIM, CLEMENS" BY "CLEMENS, ACHIM"

WWE Wipo information: entry into national phase

Ref document number: 2004803255

Country of ref document: EP

DPEN Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed from 20040101)
WWP Wipo information: published in national office

Ref document number: 2004803255

Country of ref document: EP