WO2004019221A3 - Managing data integrity - Google Patents

Managing data integrity Download PDF

Info

Publication number
WO2004019221A3
WO2004019221A3 PCT/EP2003/008992 EP0308992W WO2004019221A3 WO 2004019221 A3 WO2004019221 A3 WO 2004019221A3 EP 0308992 W EP0308992 W EP 0308992W WO 2004019221 A3 WO2004019221 A3 WO 2004019221A3
Authority
WO
WIPO (PCT)
Prior art keywords
records
management systems
data management
data integrity
managing data
Prior art date
Application number
PCT/EP2003/008992
Other languages
French (fr)
Other versions
WO2004019221A2 (en
Inventor
Martina Goetz
Michael Schmitt
Steffen Lutz
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
Priority claimed from US10/219,929 external-priority patent/US7127475B2/en
Priority claimed from US10/222,757 external-priority patent/US7464097B2/en
Application filed by Sap Ag filed Critical Sap Ag
Priority to AU2003255438A priority Critical patent/AU2003255438A1/en
Priority to EP03792311A priority patent/EP1530765A2/en
Publication of WO2004019221A2 publication Critical patent/WO2004019221A2/en
Publication of WO2004019221A3 publication Critical patent/WO2004019221A3/en

Links

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
    • H04L41/02—Standardisation; Integration
    • H04L41/024—Standardisation; Integration using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
    • 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/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/289—Object oriented databases

Abstract

Techniques are provided to manage the integrity of data stored in two or more data management systems by detecting inconsistencies between the data management systems. The techniques identify missing records in one or more data management systems by comparing the records in the data management systems. For records that exist in two or more data management systems, the techniques identify records that are not identical in the data management systems. A user checkpoint is provided between the identification of missing records and the identification of records that are not identical. The detected inconsistencies also may be corrected.
PCT/EP2003/008992 2002-08-15 2003-08-13 Managing data integrity WO2004019221A2 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
AU2003255438A AU2003255438A1 (en) 2002-08-15 2003-08-13 Managing data integrity
EP03792311A EP1530765A2 (en) 2002-08-15 2003-08-13 Managing data integrity

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US10/219,929 US7127475B2 (en) 2002-08-15 2002-08-15 Managing data integrity
US10/219,929 2002-08-15
US10/222,757 US7464097B2 (en) 2002-08-16 2002-08-16 Managing data integrity using a filter condition
US10/222,757 2002-08-16

Publications (2)

Publication Number Publication Date
WO2004019221A2 WO2004019221A2 (en) 2004-03-04
WO2004019221A3 true WO2004019221A3 (en) 2004-07-01

Family

ID=31949772

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/EP2003/008992 WO2004019221A2 (en) 2002-08-15 2003-08-13 Managing data integrity

Country Status (3)

Country Link
EP (1) EP1530765A2 (en)
AU (1) AU2003255438A1 (en)
WO (1) WO2004019221A2 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1708096A1 (en) * 2005-03-31 2006-10-04 Ubs Ag Computer Network System and Method for the Synchronisation of a Second Database with a First Database
GB2497174A (en) * 2011-11-30 2013-06-05 Tata Consultancy Services Ltd Automating testing of data integrity of a database archive
GB201312776D0 (en) * 2013-07-17 2013-08-28 Qatar Foundation Data integration and cleansing

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5751958A (en) * 1995-06-30 1998-05-12 Peoplesoft, Inc. Allowing inconsistency in a distributed client-server application
US5796999A (en) * 1994-04-15 1998-08-18 International Business Machines Corporation Method and system for selectable consistency level maintenance in a resilent database system
US6304882B1 (en) * 1998-05-05 2001-10-16 Informix Software, Inc. Data replication system and method

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6212529B1 (en) * 1996-11-13 2001-04-03 Puma Technology, Inc. Synchronization of databases using filters
US6125369A (en) * 1997-10-02 2000-09-26 Microsoft Corporation Continuous object sychronization between object stores on different computers
US6351744B1 (en) 1999-05-28 2002-02-26 Unisys Corporation Multi-processor system for database management

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5796999A (en) * 1994-04-15 1998-08-18 International Business Machines Corporation Method and system for selectable consistency level maintenance in a resilent database system
US5751958A (en) * 1995-06-30 1998-05-12 Peoplesoft, Inc. Allowing inconsistency in a distributed client-server application
US6304882B1 (en) * 1998-05-05 2001-10-16 Informix Software, Inc. Data replication system and method

Also Published As

Publication number Publication date
EP1530765A2 (en) 2005-05-18
AU2003255438A1 (en) 2004-03-11
WO2004019221A2 (en) 2004-03-04

Similar Documents

Publication Publication Date Title
WO2006012449A3 (en) Tracking objects modified between backup operations
WO2010048048A3 (en) Configuration management in distributed data systems
CA2343370A1 (en) Root cause analysis in a distributed network management architecture
WO2004034197A3 (en) System and method for managing stored data
WO2006015340A3 (en) Medical records system and method
WO2004027567A3 (en) A method for managing an investment portfolio
WO2005057329A3 (en) Dynamic location of a subordinate user
WO2006073803A3 (en) Backup information management
WO2007021997A3 (en) Snapshot indexing
WO2005048046A3 (en) Systems and methods for assessing the potential for fraud in business transactions
MXPA02000185A (en) Method and system for searching classified advertising.
WO2000058870A3 (en) Handling a request for information provided by a network site
WO2002091232A3 (en) Method, system, and program for querying data in a personal information manager database
WO2005066871A3 (en) Patient information management system and method
WO2005081110A3 (en) System and method for instrumenting a software application
WO2007078645A3 (en) Method and apparatus for cloning filesystems across computing systems
AU2003218578A1 (en) System and methode for monitoring and managing physical assets using a database
WO2005099381A3 (en) Expression and time-based data creation and creator-controlled organization
WO2007028011A3 (en) Automated damage assessment, report, and disposition
WO2006071737A3 (en) System and method for corporate-wide policy management
WO2007038327A3 (en) System and method for event log review
WO2003054694A3 (en) Method and system for attribute management in a namespace
WO2007038275A3 (en) Systems and methods for remote storage of electronic data
WO2003096393A3 (en) Data archive recovery
WO2006020199A3 (en) Asset visibility management system with binding and unbinding of assets

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE 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 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 UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): 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 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: 2003792311

Country of ref document: EP

WWP Wipo information: published in national office

Ref document number: 2003792311

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP