EP1377885A2 - Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlage - Google Patents
Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlageInfo
- Publication number
- EP1377885A2 EP1377885A2 EP02737764A EP02737764A EP1377885A2 EP 1377885 A2 EP1377885 A2 EP 1377885A2 EP 02737764 A EP02737764 A EP 02737764A EP 02737764 A EP02737764 A EP 02737764A EP 1377885 A2 EP1377885 A2 EP 1377885A2
- Authority
- EP
- European Patent Office
- Prior art keywords
- database
- file
- data
- stored
- current reference
- Prior art date
- Legal status (The legal status 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 status listed.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000004590 computer program Methods 0.000 title claims abstract description 6
- 239000003550 marker Substances 0.000 claims description 4
- 230000004048 modification Effects 0.000 abstract description 3
- 238000012986 modification Methods 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 9
- 230000008859 change Effects 0.000 description 7
- 230000006378 damage Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000001174 ascending effect Effects 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
- G05B19/41865—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by job scheduling, process planning, material flow
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/30—Nc systems
- G05B2219/31—From computer integrated manufacturing till monitoring
- G05B2219/31339—From parameters, build processes, select control elements and their connection
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Definitions
- the individual functions are usually implemented by system components that interact with one another, for example by exchanging substances and / or information.
- the technical system is, for example, a power plant
- at least the measuring points - at which data is generated during later operation - the consumers of energy of any kind, in particular electrical energy, the fittings for operating and / or connecting the Plant components and the pipe systems - for example the pipe system - can be configured.
- an engineer entrusted with this usually creates a list in which he enters the components intended for use in the system, together with information, for example, to which function the component belongs and where it is located installed, from where it is fed, where it feeds, what connected load it has, etc
- the projecting engineer must ensure that he always keeps his project planning list up to date. To do this, he must at least always mark the list after the change has been made, e.g. by enter the last modification date. If there are several configuration lists in circulation - which usually occurs in the configuration teams that are often formed today - he has to set up a change service and ensure that all the configuration lists in circulation are updated after a change. Otherwise problems can arise because it is not clear whether a list currently available reflects the current configuration status of the system or not.
- the invention is therefore based on the object of specifying a method, a database system and a computer program product for projecting a technical system which overcome the disadvantages described above, improve project planning and can be used flexibly.
- the object is achieved according to the invention by a method for projecting a technical system with a number of system components with the following steps:
- a specification of each system component is stored as a data record in an electronic database and a working database is formed from the data records.
- the working data stock is marked as the current reference data stock.
- the working database of the database is made available for a callable automatic comparison with the current reference database and when the comparison is called up, those data of the working database that are different from the current reference database are identified and assigned to a second user. Upon request, the working dataset is marked as a new current reference dataset.
- the method according to the invention makes it possible to understand the changes made in the course of the project planning, in that a current database is marked as a reference database by a user request (for example, if the current database is valid and, for example, a prototype of the system) describes), changes made afterwards are saved together with the data records not affected by the change, the work database created in this way is compared with the reference database on the basis of another user request and changes regarding the reference database are marked and, if necessary, displayed and / or saved.
- Change has been made since a last valid database. He can then specifically check the changes, for example, to determine whether they are suitable for achieving a desired success and / or for realizing a new function and / or for the intended removal of an originally planned function, etc. If so, he can mark the changed database as a (new) current reference database by means of a further user request.
- the project planning staff can get an overview of which data stocks were valid at any point in time up to the current time, for example which data stocks a customer received in the form of lists during the course of the project. This makes it particularly easy to see what the changes consisted of in relation to a last valid one
- the reference databases are advantageously stored together with a unique revision level marker.
- the revision level marking is a unique identification feature by means of which the reference data sets can be distinguished from one another, for example by providing the reference data sets with an ascending numerical index in their chronological order.
- the database is a computer with a database program, in particular Microsoft Access.
- Database programs are particularly suitable for collecting and storing data, for example configuration data, in a simple manner and at low cost, and e.g. to prepare for an expression.
- the well-known Microsoft Access database program is characterized in particular by the fact that it is very widespread, can be run on almost any computer, and that its operation is already familiar to a wide range of people.
- database queries with which partial data can be filtered out of the entire database, are particularly easy to implement.
- the comparison of a working database with a reference database is advantageously carried out with the aid of at least one automatically executable database query, in particular a database query generated using the programming language SQL.
- the invention furthermore leads to a database system for project planning of a technical system with a number of system components, whereby a) a specification of each system component can be stored as a data record in a file of the database system, b) changes in the specification of one or more system components can be stored in the file, c) upon a first user request, the file can be saved as a current reference file, and d) the database system is upgraded, upon a second user request, the Automatically compare the file with the current reference file and identify those data in the file that are different from the data in the current reference file.
- the database system is a data processing system with a database program, in particular Microsoft Access.
- the comparison of the file with the current reference file is advantageously carried out using an automatically executable database query, in particular generated using the SQL programming language.
- the invention also leads to a computer program product which is stored on a storage medium and
- FIG a database system according to the invention.
- a database system 5 according to the invention is shown schematically, which is in a data processing system is implemented.
- the specifications 7 of system components of a technical system are recorded using an input mask 12 and stored as data records 10 in a file 15.
- a user of the database system 5 can now prepare the database of the database system 5 with the help of user requests 30, 31 which he inputs into a processing module 20.
- the user can make a first user request 30 to the processing module 20 in order to save the file 10 as the current reference file 25.
- the processing module 20 transmits this request to a query module 35, which then generates and stores a reference file 25.
- the user can initiate an automatic comparison of the file 15 with the current reference file 25 by means of a second user request 31. For this purpose, it transmits the request 31 to the processing module 20, which in turn causes the query module 35 to automatically compare the file 15 with the current reference file 25 and to identify those data in the file 15 which are different from the data in the current reference file 25.
- the query module 35 can, for example, save the comparison result between the file 15 and the file 25 in a file 15 ', the changes being highlighted in the file 15'. ben, for example, highlighted in color.
- the file 15 ′ can be used particularly easily, for example in order to generate a printout of the changes on paper, so that the changes can be seen particularly easily.
- the user can also save the current file 15 as a new current reference file 25 at any time during the configuration by means of a user request 30.
- All of the files 15 and / or files 25 and / or files 15 'which result in the course of the configuration can advantageously be stored in the database system 5, so that the chronological sequence and the respective extent of changes made are particularly easy to understand. It is particularly advantageous if each time a reference file 25 is generated, it is assigned a unique revision level marker.
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- General Factory Administration (AREA)
Abstract
Description
Claims
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
DE10117645 | 2001-04-09 | ||
DE10117645 | 2001-04-09 | ||
PCT/DE2002/001170 WO2002082196A2 (de) | 2001-04-09 | 2002-03-28 | Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlage |
Publications (1)
Publication Number | Publication Date |
---|---|
EP1377885A2 true EP1377885A2 (de) | 2004-01-07 |
Family
ID=7680937
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EP02737764A Withdrawn EP1377885A2 (de) | 2001-04-09 | 2002-03-28 | Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlage |
Country Status (5)
Country | Link |
---|---|
US (1) | US20040172398A1 (de) |
EP (1) | EP1377885A2 (de) |
JP (1) | JP2004526256A (de) |
CN (1) | CN1636173A (de) |
WO (1) | WO2002082196A2 (de) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7809458B2 (en) * | 2008-03-31 | 2010-10-05 | Honda Motor Co., Ltd. | Process control system with ability to exchange data with production line machine controllers |
CN104281561B (zh) * | 2013-07-08 | 2017-11-24 | 华为技术有限公司 | 一种数据恢复的方法及电子设备 |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU6133594A (en) * | 1993-02-08 | 1994-08-29 | Action Technologies, Inc. | Method and apparatus for managing business processes |
EP0793820B1 (de) * | 1994-11-21 | 2000-06-07 | Siemens Aktiengesellschaft | Projektierungsverfahren für die leittechnik einer aus komponenten bestehenden technischen anlage |
DE19640299C1 (de) * | 1996-09-30 | 1998-02-19 | Siemens Ag | Verfahren zur chronologischen Archivierung von Prozeßdaten |
US5884325A (en) * | 1996-10-09 | 1999-03-16 | Oracle Corporation | System for synchronizing shared data between computers |
US6490493B1 (en) * | 1999-01-21 | 2002-12-03 | Rosemount Inc. | Industrial process device management software |
US6256773B1 (en) * | 1999-08-31 | 2001-07-03 | Accenture Llp | System, method and article of manufacture for configuration management in a development architecture framework |
JP2001222436A (ja) * | 1999-12-30 | 2001-08-17 | Internatl Business Mach Corp <Ibm> | リソースの自動化管理をサポートする方法、そのシステム、およびその記録媒体 |
-
2002
- 2002-03-28 JP JP2002580099A patent/JP2004526256A/ja active Pending
- 2002-03-28 US US10/474,374 patent/US20040172398A1/en not_active Abandoned
- 2002-03-28 CN CNA028079620A patent/CN1636173A/zh active Pending
- 2002-03-28 EP EP02737764A patent/EP1377885A2/de not_active Withdrawn
- 2002-03-28 WO PCT/DE2002/001170 patent/WO2002082196A2/de active Application Filing
Non-Patent Citations (1)
Title |
---|
See references of WO02082196A2 * |
Also Published As
Publication number | Publication date |
---|---|
JP2004526256A (ja) | 2004-08-26 |
WO2002082196A2 (de) | 2002-10-17 |
CN1636173A (zh) | 2005-07-06 |
WO2002082196A3 (de) | 2003-05-30 |
US20040172398A1 (en) | 2004-09-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
DE3382808T2 (de) | Datenbankzugriffsverfahren mit einem benutzerfreundlichen Menü | |
DE10308725A1 (de) | System und Verfahren zum Verwalten und zum Austausch von Daten eines technischen Projektes, einer technischen Anlage sowie einzelner Anlagenkomponenten | |
DE10048942A1 (de) | Verfahren und System zur Wartung von Software über ein Netz | |
DE69032689T2 (de) | Rechnersysteme mit einer Prozessdatenbank und Verfahren zur Benutzung in diesen Systemen | |
WO2005033934A2 (de) | Flexibler softwareupdate für automatisierungssysteme über internet | |
DE102007013324A1 (de) | Verfahren zur Erfassung wenigstens eines Bestandteils einer medizintechnischen Anlage sowie zugehörige medizintechnische Anlage | |
DE102018111930A1 (de) | Verfahren zum Bearbeiten eines Softwareprojekts | |
EP1377885A2 (de) | Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlage | |
WO1999017192A1 (de) | Konfigurierungsverfahren für datenverarbeitungsanlagen | |
EP0770946B1 (de) | Verfahren zur automatisierten optimalen Redundanz-Auslegung von Messungen für die Leittechnik in Kraftwerken | |
EP1166215A2 (de) | Verfahren zur automatischen wiedergewinnung von engineeringdaten aus anlagen | |
DE10008245A1 (de) | Verfahren zur Sicherstellung der Kompatibilität und Verfahren zur Datensicherung innerhalb eines mehrere Teilrechnersysteme aufweisenden verteilten Rechnersystems | |
EP1044409B1 (de) | Programmablaufverfahren und verfahren zur erweiterung eines programmkomponentensystems | |
EP1285315A2 (de) | Informationsverarbeitungssystem und verfahren zu dessen betrieb | |
DE19807191A1 (de) | Programmablaufverfahren und Verfahren zur Erweiterung eines Programmkomponentensystems | |
EP1623374A2 (de) | Verfahren zum automatischen erstellen einer ersatzteilliste | |
DE10250644B4 (de) | Austausch und Abgleich von Daten zwischen Applikationen | |
DE102022116086A1 (de) | Verfahren zur Bereitstellung von Programmen für Steuerungseinrichtungen technischer Einrichtungen | |
EP1593036A2 (de) | Verfahren und vorrichtung zum modifizieren von modular aufgebauten nachrichten | |
EP1734441A1 (de) | Automatisierungssystem mit verknüpften Automatisierungsobjekten | |
WO2003015940A1 (de) | Verfahren zum automatischen erzeugen von aktuellen verteilreihenfolgedaten | |
DE3319211A1 (de) | Online-dokumentationsverfahren und -einrichtung | |
EP0521177A1 (de) | Schnittstellensteuerung zur Ansteuerung von Datenbanksystemen | |
WO2005088497A2 (de) | Datenverarbeitungseinrichtung, datenstruktur und verfahren für die auslieferung von finanzinformationen für eine finanzinformationsdatenbank | |
EP3680788A1 (de) | Modellierung von betriebsmitteln |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
17P | Request for examination filed |
Effective date: 20030807 |
|
AK | Designated contracting states |
Kind code of ref document: A2 Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LI LU MC NL PT SE TR |
|
AX | Request for extension of the european patent |
Extension state: AL LT LV MK RO SI |
|
RIN1 | Information on inventor provided before grant (corrected) |
Inventor name: WIBLISHAUSER, ANDREAS Inventor name: HERRMANN, EWALD Inventor name: ALBERT, KLAUS |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: THE APPLICATION IS DEEMED TO BE WITHDRAWN |
|
18D | Application deemed to be withdrawn |
Effective date: 20081001 |