WO2005088474A1 - Service for verifying consistency of replicated data - Google Patents
Service for verifying consistency of replicated data Download PDFInfo
- Publication number
- WO2005088474A1 WO2005088474A1 PCT/CH2004/000159 CH2004000159W WO2005088474A1 WO 2005088474 A1 WO2005088474 A1 WO 2005088474A1 CH 2004000159 W CH2004000159 W CH 2004000159W WO 2005088474 A1 WO2005088474 A1 WO 2005088474A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- consistency
- attributes
- entity
- attribute
- service
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/273—Asynchronous replication or reconciliation
Definitions
- the invention relates to the field of utility automation.
- It relates to a method for ensuring consistency of entities stored in data sets of a multitude of different IT systems used for operating utility automation assets.
- integration applications are being developed.
- One example is the access to data and exchange of data between the participating applications as shown in Fig. 1.
- CMMS such as SAP PM
- GIS such as ESRI
- Adapting attributes such as e.g. operational limits for an asset, which are contained and maintained in the data sets of the different systems, becomes even more difficult.
- the inventive method allows validating consistency of attributes of an entity with common attributes in more than one of the participating applications and restoring consistency if any of the attributes of an entity is found to be inconsistent.
- the attribute consistency service is called either before a functionality is triggered, used by applications such as navigation (e.g. navigate to the transformer from SCADA to CMMS), or continuously, to check and ensure the consistency on the relations stored in the external data store.
- the consistency of data stored in various IT systems can be ensured prior to attempting to access it.
- the feedback given to the calling application allows that application to offer a certain service or functionality only if the required data is consistently available. Errors by calling a service or functionality that would require access to data that is not available or that is inconsistent are therefore avoided.
- the attribute consistency service can be used for several applications, such as navigation or data access.
- the number of participating applications is not limited. Adding additional IT systems to the attribute consistency service only requires extending the reference model stored in the attribute consistency service reference database.
- Fig. 1 shows an exemplary data flow between integrated IT systems
- Fig. 2 shows the reference modeling of a 'real world object'
- Fig. 3 shows the setup of the attribute consistency service system
- Fig. 4 shows a detailed block diagram of the functionality of the inventive attribute consistency service system of Fig.3. Detailed Description of Preferred Embodiments
- a service which knows about the relationships of the attributes of an entity and knows about the access to the individual entity data stores of the participating IT systems applications allows external applications, such as navigation or data access to perform a consistency check before a functionality is triggered, or the consistency is alternatively checked continuously on the relations stored in the external data store.
- an adapter manages the specifics to communicate against the application and hide access to the application APIs towards this service.
- the adapter provides functionality to 1) retrieve the attribute value from the participating applications and to 2) write an attribute value to a participating application.
- Any external application using data access functionality can use the attribute consistency service to update and synchronize attribute value for an entity.
- the application can access the relations of an entity, which are stored in an entity reference database.
- the entity reference contains the names of the entity in the participating applications as well as an identifier for the entity reference (e.g. CIM:XXX).
- the Attribute consistency server reads the attached attributes for CIM:XXX from an attribute reference database. This contains the entity reference CIM:XXX, the attribute reference A which is common to the entity CIM:XXX in all participating applications, the according update function or update service description (e.g. servicel .wsdl) needed to update that particular attribute, a flag for setting an automatic or user driven synchronization and the names of the attribute in the participating applications.
- the attribute consistency service can check the consistency of the attributes of the entity in the different IT systems by comparing the values of the attributes from the participating applications and initiate the update process if necessary.
- a service function gets invoked to determine a master attribute value (MAV) with the attribute values being the function parameters.
- MAV master attribute value
- the service function can be freely defined during engineering phase or be chosen dynamically depending on the current situation of the modeled entities (e.g. Median function, definition of a master application whose attribute value overwrites the other applications attribute values etc).
- a predefined Replication flag (YES/NO) indicated if the user or an external overwriting confirmation application should confirm the synchronisation process.
- the result of the service function the MAV is then written to the defined attributes of the applications.
- the inventive system comprises an attribute consistency service with an input buffer, output means and communication means to communicate with the adapters of the various IT systems.
- An external application registers at the consistency service to be notified on consistency feedback. This calling application can place an entity for which the consistency must be ensured in the buffer, and will get notified as soon as the entity has been processed by the service.
- a batch application can place a set of entities, or relationships, as defined in the external data store, into the buffer for cyclic checks. No callbacks from the service are triggered. Instead, inconsistent data sets are logged by the service in order to include those in a re-engineering process.
- the attribute consistency service fulfills the following functionality (see Fig. 4):
- the adapters of the IT systems are initialized.
- entities from different source applications are grouped into a reference container during the engineering phase.
- the entities carry meta-information, such as its local identifier in order to access the entity in the local application, and an application identifier which allows the consistency service to direct any requests related to that entity to the correct adapter.
- the adapter of the IT system to be checked is initialized. Then the communication to the source application is checked by sending a service request (e.g. ping the machine the application is residing on, with defined return values: system: UP, entity: EXISTS) to the source applications. If the communication is not properly working, all entities of that particular application are marked as unknown.
- a service request e.g. ping the machine the application is residing on, with defined return values: system: UP, entity: EXISTS
- the entity for which the consistency of its attributes needs to be ensured is pinged by sending out a signal as described above. If the entity does exist and a return signal is sent back accordingly, the attributes are read from the different IT systems. The attributes read from the different applications are compared amongst each other. If the values are consistent, an OK can be loaded into the output means of the attribute consistency service. The calling application gets the OK and knows that the requested entity is available with all its attributes being consistent according to the reference entity.
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2004800424643A CN1926543A (en) | 2004-03-17 | 2004-03-17 | Service for checking copying data consistency |
US10/592,865 US20090210453A1 (en) | 2004-03-17 | 2004-03-17 | Service for verifying consistency of replicated data |
PCT/CH2004/000159 WO2005088474A1 (en) | 2004-03-17 | 2004-03-17 | Service for verifying consistency of replicated data |
EP04721100A EP1725951A1 (en) | 2004-03-17 | 2004-03-17 | Service for verifying consistency of replicated data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/CH2004/000159 WO2005088474A1 (en) | 2004-03-17 | 2004-03-17 | Service for verifying consistency of replicated data |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2005088474A1 true WO2005088474A1 (en) | 2005-09-22 |
Family
ID=34957066
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/CH2004/000159 WO2005088474A1 (en) | 2004-03-17 | 2004-03-17 | Service for verifying consistency of replicated data |
Country Status (4)
Country | Link |
---|---|
US (1) | US20090210453A1 (en) |
EP (1) | EP1725951A1 (en) |
CN (1) | CN1926543A (en) |
WO (1) | WO2005088474A1 (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100401294C (en) * | 2005-09-30 | 2008-07-09 | 南京大学 | Checkig method for protecting integrality of outline based on products of information technology of relational database |
CN100407199C (en) * | 2005-09-30 | 2008-07-30 | 南京大学 | Lookup method of protecting consistency of contour based on information technology products of relational database |
CN103581231A (en) * | 2012-07-25 | 2014-02-12 | 腾讯科技(北京)有限公司 | UGC primary standby data synchronization method and system thereof |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1926541A (en) * | 2004-03-17 | 2007-03-07 | Abb研究有限公司 | Device and method for data consistency checking |
JP4457240B2 (en) * | 2007-05-09 | 2010-04-28 | フェリカネットワークス株式会社 | Data management system, management server, data management method, and program |
CN105069159A (en) * | 2015-08-26 | 2015-11-18 | 浪潮通用软件有限公司 | Extensible data consistency check tool |
US11057208B2 (en) * | 2016-08-22 | 2021-07-06 | Rakuten, Inc. | Management system, management device, management method, program, and non-transitory computer-readable information recording medium |
US11899632B1 (en) | 2017-04-28 | 2024-02-13 | Verato, Inc. | System and method for secure linking and matching of data elements across independent data systems |
CN108804464A (en) * | 2017-05-03 | 2018-11-13 | 中兴通讯股份有限公司 | Data consistency detection, device, distributed data base and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20010047279A1 (en) * | 2000-04-13 | 2001-11-29 | Gargone Peter Sebastian | Automating high-level business functions in a generic manner |
US6556539B1 (en) * | 1996-02-22 | 2003-04-29 | Mci Communications Corporation | Selector switch control using priority table |
US20040044730A1 (en) * | 2002-09-03 | 2004-03-04 | Holger Gockel | Dynamic access of data |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5864851A (en) * | 1997-04-14 | 1999-01-26 | Lucent Technologies Inc. | Method and system for managing replicated data with enhanced consistency and concurrency |
US7249170B2 (en) * | 2000-12-06 | 2007-07-24 | Intelliden | System and method for configuration, management and monitoring of network resources |
US7103884B2 (en) * | 2002-03-27 | 2006-09-05 | Lucent Technologies Inc. | Method for maintaining consistency and performing recovery in a replicated data storage system |
US8438238B2 (en) * | 2002-10-16 | 2013-05-07 | Sap Ag | Master data access |
US20040128313A1 (en) * | 2002-12-13 | 2004-07-01 | Whyman Wynne J. | Database system for outdoor property management and maintenance |
US7346071B2 (en) * | 2003-01-13 | 2008-03-18 | Bareis Bernard F | Broadband multi-drop local network, interface and method for multimedia access |
WO2004090684A2 (en) * | 2003-03-31 | 2004-10-21 | System Management Arts, Inc. | Method and apparatus for multi-realm system modeling |
CN1926541A (en) * | 2004-03-17 | 2007-03-07 | Abb研究有限公司 | Device and method for data consistency checking |
-
2004
- 2004-03-17 US US10/592,865 patent/US20090210453A1/en not_active Abandoned
- 2004-03-17 CN CNA2004800424643A patent/CN1926543A/en active Pending
- 2004-03-17 WO PCT/CH2004/000159 patent/WO2005088474A1/en active Application Filing
- 2004-03-17 EP EP04721100A patent/EP1725951A1/en not_active Withdrawn
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6556539B1 (en) * | 1996-02-22 | 2003-04-29 | Mci Communications Corporation | Selector switch control using priority table |
US20010047279A1 (en) * | 2000-04-13 | 2001-11-29 | Gargone Peter Sebastian | Automating high-level business functions in a generic manner |
US20040044730A1 (en) * | 2002-09-03 | 2004-03-04 | Holger Gockel | Dynamic access of data |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100401294C (en) * | 2005-09-30 | 2008-07-09 | 南京大学 | Checkig method for protecting integrality of outline based on products of information technology of relational database |
CN100407199C (en) * | 2005-09-30 | 2008-07-30 | 南京大学 | Lookup method of protecting consistency of contour based on information technology products of relational database |
CN103581231A (en) * | 2012-07-25 | 2014-02-12 | 腾讯科技(北京)有限公司 | UGC primary standby data synchronization method and system thereof |
CN103581231B (en) * | 2012-07-25 | 2019-03-12 | 腾讯科技(北京)有限公司 | UGC master/slave data synchronous method and its system |
Also Published As
Publication number | Publication date |
---|---|
US20090210453A1 (en) | 2009-08-20 |
CN1926543A (en) | 2007-03-07 |
EP1725951A1 (en) | 2006-11-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20070276970A1 (en) | Data Consistency Validation | |
CN1656468B (en) | Method, apparatus and system for synchronizing data storage modes in different data memories | |
JP3887564B2 (en) | Integrated database combination system | |
US20200089666A1 (en) | Secure data isolation in a multi-tenant historization system | |
US7738503B2 (en) | Multi-way, peer-to-peer synchronization | |
US7493518B2 (en) | System and method of managing events on multiple problem ticketing system | |
US7783591B2 (en) | Coordinated data conversion systems and methods | |
KR101574816B1 (en) | Asynchronous replication | |
CN107209704A (en) | Detect the write-in lost | |
US9304996B2 (en) | Dynamic data access and storage | |
US10726042B2 (en) | Replication control using eventually consistent meta-data | |
US20160294651A1 (en) | Method, apparatus, and computer program product for monitoring an electronic data exchange | |
CN109906597A (en) | To with data set that restricted data set and untethered system are stored and fetched from cloud network | |
CN113220633B (en) | Unified file coding management method and system | |
KR20140141467A (en) | Live upgrade | |
WO2003009170A1 (en) | Content transfer | |
US20090210453A1 (en) | Service for verifying consistency of replicated data | |
CN111737227A (en) | Data modification method and system | |
CN110908955B (en) | Management system of IO device description file | |
US11016756B1 (en) | Application repository protocol for disparate entity applications | |
US20220391368A1 (en) | Cryptography system for using associated values stored in different locations to encode and decode data | |
US11321193B2 (en) | Database restoration across cloud environments | |
CN103069382A (en) | Migrating artifacts between service-oriented architecture repositories | |
US20120011164A1 (en) | Life cycle based data coordination | |
CN111045928A (en) | Interface data testing method, device, terminal and storage medium |
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): BW GH GM KE LS MW MZ 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 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 | ||
WWE | Wipo information: entry into national phase |
Ref document number: 2004721100 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 200480042464.3 Country of ref document: CN Ref document number: 3342/CHENP/2006 Country of ref document: IN |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: DE |
|
WWP | Wipo information: published in national office |
Ref document number: 2004721100 Country of ref document: EP |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: 2004721100 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 10592865 Country of ref document: US |