[go: up one dir, main page]

WO2001080094A3 - A system for integrating diverse databases and maintaining their consistency - Google Patents

A system for integrating diverse databases and maintaining their consistency Download PDF

Info

Publication number
WO2001080094A3
WO2001080094A3 PCT/US2001/012352 US0112352W WO0180094A3 WO 2001080094 A3 WO2001080094 A3 WO 2001080094A3 US 0112352 W US0112352 W US 0112352W WO 0180094 A3 WO0180094 A3 WO 0180094A3
Authority
WO
WIPO (PCT)
Prior art keywords
target database
databases
queue
database
request
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.)
Ceased
Application number
PCT/US2001/012352
Other languages
French (fr)
Other versions
WO2001080094A2 (en
Inventor
Joann J Ordille
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Avaya Technology LLC
Original Assignee
Avaya Technology LLC
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 Avaya Technology LLC filed Critical Avaya Technology LLC
Priority to US09/979,197 priority Critical patent/US7660830B2/en
Priority to CA002398426A priority patent/CA2398426A1/en
Priority to AU2001257062A priority patent/AU2001257062A1/en
Priority to EP01930534A priority patent/EP1405210A2/en
Publication of WO2001080094A2 publication Critical patent/WO2001080094A2/en
Anticipated expiration legal-status Critical
Publication of WO2001080094A3 publication Critical patent/WO2001080094A3/en
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computer Security & Cryptography (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

An arrangement maintains consistency among satellite databases and an integrated database that is the union of the satellite databases with a controller that fetches update requests from a queue and applies each fetched request to all of the databases, in sequence, ending with the integrated database. In applying a modification request to a target database, a filter is used that comprises two components. The first component processes the modification request submitted by the queue to a modification request that is appropriate for the schema of the target database and that is based on the data that is already present in the target database. When appropriate, the first component also creates an update request that is sent to the queue, to achieve transitive closure. The second component communicates with the target database, using the API and protocols of the target database.
PCT/US2001/012352 2000-04-17 2001-04-10 A system for integrating diverse databases and maintaining their consistency Ceased WO2001080094A2 (en)

Priority Applications (4)

Application Number Priority Date Filing Date Title
US09/979,197 US7660830B2 (en) 2000-04-17 2001-04-10 System for integrating diverse database and maintaining their consistency
CA002398426A CA2398426A1 (en) 2000-04-17 2001-04-10 A system for integrating diverse databases and maintaining their consistency
AU2001257062A AU2001257062A1 (en) 2000-04-17 2001-04-10 A system for integrating diverse databases and maintaining their consistency
EP01930534A EP1405210A2 (en) 2000-04-17 2001-04-10 A system for integrating diverse databases and maintaining their consistency

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US19787800P 2000-04-17 2000-04-17
US60/197,878 2000-04-17

Publications (2)

Publication Number Publication Date
WO2001080094A2 WO2001080094A2 (en) 2001-10-25
WO2001080094A3 true WO2001080094A3 (en) 2004-01-29

Family

ID=22731104

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2001/012352 Ceased WO2001080094A2 (en) 2000-04-17 2001-04-10 A system for integrating diverse databases and maintaining their consistency

Country Status (4)

Country Link
EP (1) EP1405210A2 (en)
AU (1) AU2001257062A1 (en)
CA (1) CA2398426A1 (en)
WO (1) WO2001080094A2 (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7567653B1 (en) 2005-03-22 2009-07-28 Avaya Inc. Method by which call centers can vector inbound TTY calls automatically to TTY-enabled resources
US8856182B2 (en) 2008-01-25 2014-10-07 Avaya Inc. Report database dependency tracing through business intelligence metadata
US8938063B1 (en) 2006-09-07 2015-01-20 Avaya Inc. Contact center service monitoring and correcting
US9025761B2 (en) 2003-09-26 2015-05-05 Avaya Inc. Method and apparatus for assessing the status of work waiting for service
US9516069B2 (en) 2009-11-17 2016-12-06 Avaya Inc. Packet headers as a trigger for automatic activation of special-purpose softphone applications

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2446723A (en) * 2005-10-06 2008-08-20 Avaya Tech Llc Database data extensions
US7752230B2 (en) * 2005-10-06 2010-07-06 Avaya Inc. Data extensibility using external database tables
CN116257550B (en) * 2022-12-27 2025-11-11 上海申雪供应链管理有限公司 Data processing method, device, equipment and medium

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0877323A2 (en) * 1997-05-09 1998-11-11 AT&T Corp. Apparatus and method for maintaining integrated data consistency across multiple databases

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0877323A2 (en) * 1997-05-09 1998-11-11 AT&T Corp. Apparatus and method for maintaining integrated data consistency across multiple databases

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
FREIRE J ET AL: "MetaComm: a meta-directory for telecommunications", DATA ENGINEERING, 2000. PROCEEDINGS. 16TH INTERNATIONAL CONFERENCE ON SAN DIEGO, CA, USA 29 FEB.-3 MARCH 2000, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, US, PAGE(S) 211-219, ISBN: 0-7695-0506-6, XP010378714 *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9025761B2 (en) 2003-09-26 2015-05-05 Avaya Inc. Method and apparatus for assessing the status of work waiting for service
US7567653B1 (en) 2005-03-22 2009-07-28 Avaya Inc. Method by which call centers can vector inbound TTY calls automatically to TTY-enabled resources
US8938063B1 (en) 2006-09-07 2015-01-20 Avaya Inc. Contact center service monitoring and correcting
US8856182B2 (en) 2008-01-25 2014-10-07 Avaya Inc. Report database dependency tracing through business intelligence metadata
US9516069B2 (en) 2009-11-17 2016-12-06 Avaya Inc. Packet headers as a trigger for automatic activation of special-purpose softphone applications

Also Published As

Publication number Publication date
CA2398426A1 (en) 2001-10-25
EP1405210A2 (en) 2004-04-07
WO2001080094A2 (en) 2001-10-25
AU2001257062A1 (en) 2001-10-30

Similar Documents

Publication Publication Date Title
WO2004059428A3 (en) Environment integrity assured transactions
CA2134616A1 (en) Method and system for management of component connections
EP0774720A3 (en) Computer apparatus and method for merging a sequential plurality of delta streams
WO2002093319A3 (en) Methods and apparatus for enterprise application integration
WO2004068367A3 (en) Session-return enabling stateful web applications
WO2004064481A3 (en) System and method for mobile data update
WO2001091033A3 (en) Security architecture for integration of enterprise information system with j2ee platform
WO2002093420A3 (en) Method for managing distributed savepoints across multiple dbms's within a distributed transaction
WO1997038388A3 (en) Method of integrating schemas of distributed heterogeneous databases
WO2004059443A3 (en) Mobile data and software update system and method
WO2005089349A3 (en) Method and apparatus for partial updating of client interfaces
WO2002054236A3 (en) A system and method for data synchronization between remote devices
WO2002019652A3 (en) System and method for transmitting and retrieving data via a distributed persistence framework
WO2002101592A3 (en) Database access bridge system and process
WO2005074408A3 (en) Remote system administration using command line environment
WO2003098374A3 (en) Rendering a first media type content on a browser
WO2003093943A3 (en) Systems and methods for application view transactions
WO2003030031A3 (en) Mechanism for mapping xml schemas to object-relational database systems
WO2001009721A3 (en) A system, method and article of manufacture for providing an interface between a first server and a second server.
WO2005048043A3 (en) Method and system for user control of secondary content displayed on a computing device
WO2002073986A3 (en) Updating of presence information in an instant messaging service
WO2002084522A3 (en) Data loading from a remote data source
WO2001080094A3 (en) A system for integrating diverse databases and maintaining their consistency
WO2003088000A3 (en) Method for the standardization and syndication of business transactions
BR0213296A (en) system and method for maintaining a video image on a wireless communication device

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 CR CU CZ DE DK DM DZ 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 NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA 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 ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

WWE Wipo information: entry into national phase

Ref document number: 09979197

Country of ref document: US

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: 2001930534

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 2398426

Country of ref document: CA

WWP Wipo information: published in national office

Ref document number: 2001930534

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: JP