SE515459C2 - Method for synchronizing a host database and a remote database - Google Patents

Method for synchronizing a host database and a remote database

Info

Publication number
SE515459C2
SE515459C2 SE9900457A SE9900457A SE515459C2 SE 515459 C2 SE515459 C2 SE 515459C2 SE 9900457 A SE9900457 A SE 9900457A SE 9900457 A SE9900457 A SE 9900457A SE 515459 C2 SE515459 C2 SE 515459C2
Authority
SE
Sweden
Prior art keywords
database
host
log
remote
remote database
Prior art date
Application number
SE9900457A
Other languages
Swedish (sv)
Other versions
SE9900457D0 (en
SE9900457L (en
Inventor
Joergen Birkler
Lars Novak
Patrik Olsson
Original Assignee
Ericsson Telefon Ab L M
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 Ericsson Telefon Ab L M filed Critical Ericsson Telefon Ab L M
Priority to SE9900457A priority Critical patent/SE515459C2/en
Publication of SE9900457D0 publication Critical patent/SE9900457D0/en
Priority to US09/499,348 priority patent/US6466951B1/en
Priority to JP2000598946A priority patent/JP4558945B2/en
Priority to BR0008125-6A priority patent/BR0008125A/en
Priority to EP00908174A priority patent/EP1206745A1/en
Priority to KR1020017009417A priority patent/KR100626894B1/en
Priority to PL00349804A priority patent/PL349804A1/en
Priority to AU29545/00A priority patent/AU762743C/en
Priority to CNB008035288A priority patent/CN1147812C/en
Priority to PCT/SE2000/000253 priority patent/WO2000048096A1/en
Priority to MYPI20000455A priority patent/MY120375A/en
Priority to ARP000100588A priority patent/AR022568A1/en
Publication of SE9900457L publication Critical patent/SE9900457L/en
Publication of SE515459C2 publication Critical patent/SE515459C2/en
Priority to HK02106324.2A priority patent/HK1044835B/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/40—Data acquisition and logging
    • 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
    • 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
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Computing Systems (AREA)
  • Computer Hardware Design (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Calculators And Similar Devices (AREA)
  • Multi Processors (AREA)

Abstract

A database system has at least two hose databases (204, 214) in respective host processing apparatuses (200, 210). A remote database (224) is provided in a remote processing apparatus (220). The host databases and the remote database store a plurality of database items. A synchronization engine (206, 216) is provided in each host processing apparatus for synchronizing its host database with the remote database. A first log file (227) contains entries, that represent changes made to the remote database (224), including additions and modifications of items in the remote database as well as deletions of items from the remote database in order to increase its free storage space available for storing new items. A second log file (229) contains entries, that represent deletions from the remote database upon respective deletions in either of the host databases (204, 214). The synchronization engine (206, 216) deletes items in its host database in accordance with the entries in the second log file but not in the first log file.

Description

N ß Halvlángsam synk Synkmotor Förändringslogg Snabb synk 515 459 Synkmotorn läser samtliga dokument frán fjärranordningen och jämför dem med elementen i värddatabasen. Ele- ment, som inte påträffas, kommer att läggas till fjärranordningen eller värddatabasen. N ß Semi-slow sync Sync engine Change log Fast sync 515 459 The sync engine reads all documents from the remote device and compares them with the elements in the host database. Elements that are not found will be added to the remote device or host database.

Mjukvara, som utför synkroniseringen.Software that performs the synchronization.

En logg, där förändringar i fjärr- databasen lagras. Förändringsloggen kan ha fast storlek; gamla föränd- ringar avlägsnas frän förändrings- loggen, då nya tillförs densamma.A log, where changes in the remote database are stored. The change log can have a fixed size; old changes are removed from the change log, as new ones are added to it.

Detta kallas för en FIFO-logg ("FIRST IN FIRST OUT").This is called a FIFO log ("FIRST IN FIRST OUT").

Varje post i förändringsloggen har en händelse (tillägg, borttagning eller ändring), UID för ifrågavarande data- baspost samt ett förändringsräknar- värde.Each entry in the change log has an event (addition, deletion or change), UID for the database entry in question and a change counter value.

Förändringsloggen kan hämtas av synk- motorn beroende pá en förändrings- räknare. Detta gör det möjligt för synkmotorn att hämta endast sådana förändringar, som den är intresserad av.The change log can be retrieved by the sync engine depending on a change counter. This allows the sink motor to retrieve only those changes of which it is interested.

Förändringsloggen betraktas som full, om fjärrdataanordningen inte kan skapa en giltig förändringslogg för begärd förändringsräknare.The change log is considered full, if the remote data device cannot create a valid change log for the requested change counter.

Förändringsloggen benämns ofta "den vanliga förändringsloggen" i detta dokument.The change log is often referred to as the "regular change log" in this document.

Om förändringsloggen innehåller alla förändringar sedan den senaste syn- ken, behöver endast påverkade poster W U Förändringsräknare u ... = « . | - | n i databasen jämföras och överföras mellan anordningen och synkmotorn, vilket gör synkroniseringsförfarandet väsentligt snabbare. Om detta är möj- ligt, kallas detta för en snabb synk.If the change log contains all changes since the last sync, only affected items need W U Change counter u ... = «. | - | n in the database is compared and transferred between the device and the sync engine, which makes the synchronization process significantly faster. If this is possible, this is called a fast sync.

En räknare, som räknas upp för varje förändring (tillägg, ändring och borttagning) i databasen. Föränd- ringsräknaren lagras i loggen och sparas i synkmotorn efter synk.A calculator, which is listed for each change (addition, change and deletion) in the database. The change counter is stored in the log and saved in the sync engine after sync.

Problem Det finns två situationer, där en synkmotor tar bort element från fjärrdatabasen: 1.Problem There are two situations where a sync engine removes elements from the remote database: 1.

Synkmotorn tar bort element från fjärrdatabasen för att göra plats för andra element. Detta kan exempel- vis göras för att tillhandahålla ett glidande fönster för en kalender.The sync engine removes elements from the remote database to make room for other elements. This can be done, for example, to provide a sliding window for a calendar.

När element tas bort från värddatabasen, tar synk- motorn bort dessa element från fjärrdatabasen.When elements are removed from the host database, the sync engine removes these elements from the remote database.

I följande exempel synkroniseras fjärrdatabasen med tvâ värddatabaser.The following example synchronizes the remote database with two host databases.

Se FIG 2 för detaljer.See FIG 2 for details.

Synkmotor 1 påbörjar en synkronisering med fjärr- anordningen.Sync motor 1 starts a synchronization with the remote device.

Synkmotor 1 tar bort ett element från fjärrdatabasen för att göra plats för andra element.Sync engine 1 removes one element from the remote database to make room for other elements.

U 515 459 4 3. Eftersom ett element togs bort från fjärrdatabasen, skapar fjärranordningen en borttagningspost i sin förändringslogg för det borttagna elementet.U 515 459 4 3. Since an element was deleted from the remote database, the remote device creates a deletion record in its change log for the deleted element.

Synkmotor l avslutar synkroniseringen.Sync motor l terminates the synchronization.

Synkmotor 2 påbörjar en synkronisering med fjärr- anordningen. 6. Synkmotor 2 tittar i fjärranordningens förändrings- logg och ser, att ett element har tagits bort. 7. Synkmotor 2 tar bort detta element från värddatabasen 2. 8. Synkmotor 2 avslutar synkroniseringen.Sync motor 2 starts a synchronization with the remote device. 6. Sync motor 2 looks in the change log of the remote device and sees that an element has been removed. 7. Sync motor 2 deletes this element from the host database 2. 8. Sync motor 2 terminates the synchronization.

I steg 7 skulle elementet inte ha tagits bort från värddatabasen 2, eftersom synkmotor 1 endast tagit bort elementet från fjärranordningen för att göra plats för andra element.In step 7, the element would not have been removed from the host database 2, since the sink engine 1 only removed the element from the remote device to make room for other elements.

Det finns en risk att element oavsiktligt tas bort från en värddatabas, när en fjärranordning synkroniseras med mer än en värd.There is a risk that elements are inadvertently removed from a host database when a remote device is synchronized with more than one host.

Lösning Det ovan beskrivna problemet kan lösas genom att: «0 introducera begreppet mjuka borttagningar och hårda borttagningar. 0 introducera två kommandon, ett för mjuka borttag- ningar och ett för hårda borttagningar. 0 introducera en hårdborttagningslogg för att hålla reda på element, som har tagits bort genom hård bort- tagning. 0 kombinera den vanliga förändringsloggen och hàrdbort- tagningsloggen till en kombinerad förändringslogg pà lämpligt sätt, när synkmotorn begär förändrings- loggen.Solution The problem described above can be solved by: «0 introducing the concept of soft removals and hard removers. 0 introduce two commands, one for soft removals and one for hard removals. 0 Introduce a hard removal log to keep track of elements that have been removed by hard removal. Combine the standard change log and the hard delete log into a combined change log in an appropriate way, when the sync engine requests the change log.

Mjuk borttagning används av synkmotorn för att ta bort element i fjärranordningen och göra plats för andra element.Soft removal is used by the sink motor to remove elements in the remote device and make room for other elements.

W U 515 459 Hård borttagning används av synkmotorn för att ta bort sådana element från fjärranordningen, som har tagits bort från värddatabasen. Hårda borttagningar kommer att sprida sig som hårda borttagningar till andra värdar, som fjärranordningen synkroniseras med.W U 515 459 Hard delete is used by the sink engine to remove such elements from the remote device that have been removed from the host database. Hard removals will spread as hard removals to other hosts, with which the remote device is synchronized.

Synkmotorn skall använda två olika komandon, då hårda borttagningar och mjuka borttagningar utförs för fjärrdatabasen.The sync engine should use two different commands, as hard deletions and soft deletions are performed for the remote database.

En separat logg, hårdborttagningalogg, måste finnas för att hålla reda på element, som har tagits bort genom hård borttagning. Denna logg kan ha fast storlek eller dy- namisk. Den nyaste posten bör finnas i toppen av loggen. Om loggen blir överfull, bör det äldsta elementet i loggen kastas bort. Varje post i borttagningsloggen bör ha samma attribut, som poster i den vanliga förändringsloggen; en händelse (alltid hård borttagning), UID för den borttagna databasposten samt förändringsräknarvärde.A separate log, the hard delete log, must be in place to keep track of elements that have been removed by hard deletion. This log can be fixed size or dynamic. The newest entry should be at the top of the log. If the log becomes overcrowded, the oldest element in the log should be discarded. Each entry in the deletion log should have the same attributes, as entries in the regular change log; an event (always hard delete), UID of the deleted database record and change counter value.

När fjärranordningen tar emot ett mjukt borttagnings- kommando, bör den skapa en post i den vanliga förändrings- loggen. När fjärranordningen tar emot ett hårt borttag- lningskommando, bör den skapa en post i hàrdborttagnings- loggen.When the remote device receives a soft delete command, it should create an entry in the regular change log. When the remote device receives a hard delete command, it should create an entry in the hard delete log.

Det är möjligt för synkmotorn att ta emot föränd- ringsloggen från fjärranordningen. Denna förändringslogg kommer att utgöra en kombinerad förändringslogg, som inne- håller poster från den vanliga förändringsloggen och hàrd- borttagningsloggen.It is possible for the sync motor to receive the change log from the remote device. This change log will be a combined change log, which contains entries from the regular change log and hard drive log.

Det kommer att finnas två typer av kombinerade för- ändringsloggar: W U | u § . . n . « . « - . _ « I I . . = | | » ~ . . » . .n FIG 3 visar detta närmare.There will be two types of combined change logs: W U | and §. . n. «. «-. _ «I I. . = | | »~. . ». Fig. 3 shows this in more detail.

Den kombinerade förändringsloggen, typ 1, innehåller poster från såväl den vanliga förändringsloggen som hård- borttagningsloggen. Posterna bör listas, så att de nyaste posterna finns i toppen av loggen.The combined change log, type 1, contains entries from both the regular change log and the hard delete log. The records should be listed so that the newest records are at the top of the log.

Den kombinerade förändringsloggen, typ 2, innehåller poster från hårdborttagningsloggen och ett "U"-tecken, som indikerar att den vanliga förändringsloggen är full. Pos- terna från hårdborttagningsloggen bör listas, så att de ny- aste posterna finns i toppen av loggen.The combined change log, type 2, contains entries from the hard delete log and a "U" sign, which indicates that the regular change log is full. The entries from the hard delete log should be listed, so that the latest entries are at the top of the log.

De två typerna av kombinerade förändringsloggar bör användas enligt följande tabell: Ej full Ej full Typ l Ej full Full Typ 2 Full Ej full Typ 2 Full Full Typ 2 Lägg märke till, att även om hårdborttagningsloggen Istället re- turneras så många poster som möjligt från hårdborttagnings- är full, så returneras inte något "U"-tecken. loggen. Syftet med detta är att säkerställa, att så många hårda borttagningar som möjligt hanteras av synkmotorn. l0 515 459 7 Synkmotorn hanterar de två typerna av kombinerade förändringsloggar pá olika sätt: 0 Typ 1: Synkmotorn bör hantera posterna i den kombine- rade förândringsloggen på vanligt vis. 0 Typ 2: Synkmotorn bör hantera posterna i den kombine- rade förändringsloggen pà normalt vis och därefter övergå till att genomföra en halvlángsam synk.The two types of combined change logs should be used according to the following table: Not full Not full Type l Not full Full Type 2 Full Not full Type 2 Full Full Type 2 Note that even if the hard drive log is returned, as many records as possible are returned from hard delete is full, no "U" character is returned. log. The purpose of this is to ensure that as many hard removals as possible are handled by the sink motor. l0 515 459 7 The sync engine handles the two types of combined change logs in different ways: 0 Type 1: The sync engine should handle the entries in the combined change log in the usual way. Type 2: The sync engine should handle the entries in the combined change log in the normal way and then proceed to perform a half-slow sync.

Fördelar med uppfinningen Uppfinningen eliminerar risken att element oavsikt- ligt tas bort, då en fjârranordning synkroniseras med mer än en värd.Advantages of the invention The invention eliminates the risk of elements being inadvertently removed when a remote device is synchronized with more than one host.

Claims (1)

N Ü 515 459 8 PATENTKRAVN Ü 515 459 8 PATENTKRAV 1. Metod för att synkronisera en värddatabas och en fjärrdatabas, kännetecknad av att ett första borttagningskommando tillhandahàlles för borttagning av element lagrade i fjärrdatabasen, när nämnda fjärrdatabas är full, , ett andra borttagningskommando tillhandahâlles för borttagning av sådana element från fjärrdatabasen, vilka har tagits bort från värddatabasen, en första loggfil underhålls för att hålla reda pà element, som hör samman med nämnda första borttagnings- kommando, samt en andra loggfil underhålls för att hålla reda på element, vilka hör samman med nämnda andra borttagnings- kommando.Method for synchronizing a host database and a remote database, characterized in that a first deletion command is provided for deleting elements stored in the remote database, when said remote database is full, a second deletion command is provided for deleting such elements from the remote database which have been deleted from the host database, a first log file is maintained to keep track of elements associated with said first delete command, and a second log file is maintained to keep track of elements associated with said second delete command.
SE9900457A 1999-02-10 1999-02-10 Method for synchronizing a host database and a remote database SE515459C2 (en)

Priority Applications (13)

Application Number Priority Date Filing Date Title
SE9900457A SE515459C2 (en) 1999-02-10 1999-02-10 Method for synchronizing a host database and a remote database
US09/499,348 US6466951B1 (en) 1999-02-10 2000-02-08 Data base synchronizing system with at least two host databases and a remote database
PCT/SE2000/000253 WO2000048096A1 (en) 1999-02-10 2000-02-09 A database system having at least two host databases and a remote database, and a method of synchronizing such databases
PL00349804A PL349804A1 (en) 1999-02-10 2000-02-09 A database system having at least two host databases and a remote database, and a method of synchronizing such databases
BR0008125-6A BR0008125A (en) 1999-02-10 2000-02-09 Database system, and method of synchronizing at least two host databases and a remote database
EP00908174A EP1206745A1 (en) 1999-02-10 2000-02-09 A database system having at least two host databases and a remote database, and a method of synchronizing such databases
KR1020017009417A KR100626894B1 (en) 1999-02-10 2000-02-09 Database systems with two or more host databases and remote databases, and how to synchronize those databases
JP2000598946A JP4558945B2 (en) 1999-02-10 2000-02-09 Database system having at least two host databases and a remote database and method for synchronizing such databases
AU29545/00A AU762743C (en) 1999-02-10 2000-02-09 A database system having at least two host databases and a remote database, and a method of synchronizing such databases
CNB008035288A CN1147812C (en) 1999-02-10 2000-02-09 Database system having at least two host databases and one remote database and method of synchronizing such databases
MYPI20000455A MY120375A (en) 1999-02-10 2000-02-10 A database system having at least two host databases and a remote database, and a method of synchronizing such databases
ARP000100588A AR022568A1 (en) 1999-02-10 2000-02-10 A DATABASE SYSTEM THAT HAS AT LEAST TWO HOST DATABASES AND A REMOTE DATABASE, AND A METHOD FOR SYNCHRONIZING SUCH DATABASES
HK02106324.2A HK1044835B (en) 1999-02-10 2002-08-27 A database system having at least two host databases and a remote database, and a method of synchronizing such databases

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
SE9900457A SE515459C2 (en) 1999-02-10 1999-02-10 Method for synchronizing a host database and a remote database

Publications (3)

Publication Number Publication Date
SE9900457D0 SE9900457D0 (en) 1999-02-10
SE9900457L SE9900457L (en) 2000-08-11
SE515459C2 true SE515459C2 (en) 2001-08-06

Family

ID=20414430

Family Applications (1)

Application Number Title Priority Date Filing Date
SE9900457A SE515459C2 (en) 1999-02-10 1999-02-10 Method for synchronizing a host database and a remote database

Country Status (13)

Country Link
US (1) US6466951B1 (en)
EP (1) EP1206745A1 (en)
JP (1) JP4558945B2 (en)
KR (1) KR100626894B1 (en)
CN (1) CN1147812C (en)
AR (1) AR022568A1 (en)
AU (1) AU762743C (en)
BR (1) BR0008125A (en)
HK (1) HK1044835B (en)
MY (1) MY120375A (en)
PL (1) PL349804A1 (en)
SE (1) SE515459C2 (en)
WO (1) WO2000048096A1 (en)

Families Citing this family (91)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6654908B1 (en) * 2000-04-29 2003-11-25 Hewlett-Packard Development Company, L.P. Method for and system producing shared usage of intercommunication fabric error logging registers in a multiprocessor environment
US6990533B1 (en) * 2000-05-23 2006-01-24 Palm Source, Inc. Method and system for device bootstrapping via server synchronization
US6666377B1 (en) 2000-07-18 2003-12-23 Scott C. Harris Bar code data entry device
US6718348B1 (en) * 2000-08-25 2004-04-06 Telefonaktiebolaget Lm Ericsson (Publ) Non-time dependent synchronization of databases
US6611849B1 (en) * 2000-09-29 2003-08-26 Palm Source, Inc. System for synchronizing databases on multiple devices utilizing a home base
US7113963B1 (en) * 2000-11-10 2006-09-26 Palmsource, Inc. Optimized database technique to enable faster data synchronization
US20020069298A1 (en) * 2000-12-01 2002-06-06 Jorgen Birkler Mobile terminal having multiple personal information management functionality
US6829668B2 (en) * 2000-12-28 2004-12-07 Intel Corporation System for finding data related to an example datum on two electronic devices
US6973023B1 (en) * 2000-12-30 2005-12-06 Cisco Technology, Inc. Method for routing information over a network employing centralized control
US20020104011A1 (en) * 2001-02-01 2002-08-01 Bechtel Bwtx Idaho, Llc Systems and methods for employing opportunistic data transfer to create a dynamically mobile data communication system
US7017105B2 (en) 2001-02-02 2006-03-21 Microsoft Corporation Deleting objects from a store of a device
US6985915B2 (en) 2001-02-28 2006-01-10 Kiran Somalwar Application independent write monitoring method for fast backup and synchronization of files
US6847983B2 (en) 2001-02-28 2005-01-25 Kiran Somalwar Application independent write monitoring method for fast backup and synchronization of open files
US20020174225A1 (en) * 2001-05-04 2002-11-21 Smith Mark C. Fractional replication in a directory server
US6813575B2 (en) * 2001-08-31 2004-11-02 Quebec, Inc. Portable computer control for cooking appliances and method of using
KR100520301B1 (en) * 2001-10-13 2005-10-13 한국전자통신연구원 Object-relational database management system and method for deleting class instance for the same
US6540181B1 (en) * 2001-10-15 2003-04-01 Homewell Enterprises Limited Golf bag support apparatus
US7496645B2 (en) * 2001-10-18 2009-02-24 Hewlett-Packard Development Company, L.P. Deployment of business logic software and data content onto network servers
US20030182328A1 (en) * 2001-10-29 2003-09-25 Jules Paquette Apparatus and method for sharing data between multiple, remote sites of a data network
US8516114B2 (en) * 2002-03-29 2013-08-20 International Business Machines Corporation Method and apparatus for content pre-fetching and preparation
US6920486B2 (en) * 2002-05-20 2005-07-19 Nokia Corporation Method and apparatus for enabling synchronizing data in different devices having different capabilities and unmatched data fields
US20030229655A1 (en) * 2002-06-06 2003-12-11 Advanced Barcode Technology, Inc. ClientSync - a synching method between a client computer or computers and server computer supporting one-to-many and many-to-one database synchronization when the network connection between the two is not always available or is a low-speed connection.
US20030229654A1 (en) * 2002-06-10 2003-12-11 Advanced Barcode Technology, Inc. PDASync - a synching method between a PDA (Personal Digital Assistant) client or clients and a host computer supporting one-to-many and many-to-one database synchronization
CN100568228C (en) * 2002-09-03 2009-12-09 Sap股份公司 dynamic access to data
US20040049476A1 (en) * 2002-09-06 2004-03-11 Sai Sanjay K. Efficient data management system
US6976038B2 (en) * 2002-10-17 2005-12-13 International Business Machines Corporation Method and apparatus for real time creation and modification of a change log for multi-server synchronization
JP4393762B2 (en) * 2002-12-19 2010-01-06 株式会社日立製作所 Database processing method and apparatus and processing program therefor
JP4290975B2 (en) * 2002-12-19 2009-07-08 株式会社日立製作所 Database processing method and apparatus, processing program therefor, disaster recovery method and system
EP1443423A1 (en) * 2003-01-28 2004-08-04 Bombardier Transportation (Technology) Germany GmbH Apparatus and method for data replication in a data network
FR2850814A1 (en) * 2003-02-03 2004-08-06 France Telecom SYSTEM AND METHOD FOR SYNCHRONIZING DATA BETWEEN SERVICE PORTALS AND SERVICE ACCESS PLATFORM USING SUCH A SYNCHRONIZATION SYSTEM
US20040158585A1 (en) * 2003-02-06 2004-08-12 Bea Systems, Inc. System and method for manipulating enterprise application deployment descriptors
US20040172333A1 (en) * 2003-02-28 2004-09-02 Siviy George E. Method for purchasing goods and services in business-to-business (B-2-B) transactions
JP4301849B2 (en) * 2003-03-31 2009-07-22 株式会社日立製作所 Information processing method and its execution system, its processing program, disaster recovery method and system, storage device for executing the processing, and its control processing method
US20040193731A1 (en) * 2003-03-31 2004-09-30 Larry Mitchell Universal personal information connector architecture
US8315972B2 (en) * 2003-09-26 2012-11-20 Microsoft Corporation Method for maintaining databases information about multiple instances of an activity generating, updating virtual OLAP cube based on modified star-schema
GB0323780D0 (en) * 2003-10-10 2003-11-12 Ibm A data brokering method and system
US7720801B2 (en) * 2003-12-19 2010-05-18 Netapp, Inc. System and method for supporting asynchronous data replication with very short update intervals
KR100547896B1 (en) * 2004-03-05 2006-01-31 삼성전자주식회사 Data Synchronization System and Data Synchronization Method of Server and Client
JP4452533B2 (en) 2004-03-19 2010-04-21 株式会社日立製作所 System and storage system
WO2005116868A1 (en) * 2004-05-26 2005-12-08 Nokia Corporation Method, system, computer programs and devices for management of media items
US7363327B2 (en) * 2004-05-28 2008-04-22 International Business Machines Corporation Change log handler for synchronizing data sources
CN100336025C (en) * 2004-08-20 2007-09-05 中兴通讯股份有限公司 Method and apparatus for internal memory data base synchronous data
US8290898B2 (en) * 2005-01-13 2012-10-16 Efficient Collaborative Retail Marketing Company Interactive database systems and methods for environments with high concentrations of mobile users
US8131647B2 (en) * 2005-01-19 2012-03-06 Amazon Technologies, Inc. Method and system for providing annotations of a digital work
US9275052B2 (en) 2005-01-19 2016-03-01 Amazon Technologies, Inc. Providing annotations of a digital work
CN100445995C (en) * 2005-03-29 2008-12-24 威盛电子股份有限公司 database synchronization system and method
US7761412B2 (en) * 2005-04-22 2010-07-20 Microsoft Corporation Synchronization move support systems and methods
US9053164B2 (en) * 2005-05-05 2015-06-09 International Business Machines Corporation Method, system, and program product for using analysis views to identify data synchronization problems between databases
WO2007036841A2 (en) * 2005-09-28 2007-04-05 Koninklijke Philips Electronics N.V. Apparatus and method for storing data
US7574460B2 (en) * 2005-12-01 2009-08-11 International Business Machines Corporation Journaling database changes using minimized journal entries that may be output in human-readable form
US7653650B2 (en) * 2005-12-13 2010-01-26 International Business Machines Corporation Apparatus, system, and method for synchronizing change histories in enterprise applications
US8001077B2 (en) * 2005-12-14 2011-08-16 International Business Machines Corporation Distributed method for synchronizing and updating bookmarks on multiple computer devices
US8352449B1 (en) 2006-03-29 2013-01-08 Amazon Technologies, Inc. Reader device content indexing
US8725565B1 (en) 2006-09-29 2014-05-13 Amazon Technologies, Inc. Expedited acquisition of a digital item following a sample presentation of the item
US9672533B1 (en) 2006-09-29 2017-06-06 Amazon Technologies, Inc. Acquisition of an item based on a catalog presentation of items
GB0625643D0 (en) * 2006-12-21 2007-01-31 Symbian Software Ltd Sync field filtering
US7865817B2 (en) 2006-12-29 2011-01-04 Amazon Technologies, Inc. Invariant referencing in digital works
US9552571B2 (en) * 2007-02-02 2017-01-24 Blackberry Limited Electronic device and method of meeting notification
US20080186807A1 (en) * 2007-02-02 2008-08-07 Research In Motion Limited Electronic device and method of controlling an electronic device for calendar event updates
US20080195619A1 (en) * 2007-02-09 2008-08-14 Jain Rohit Rocky Electronic device and method of sharing calendar-event information
US20080195455A1 (en) * 2007-02-09 2008-08-14 Research In Motion Limited Electronic device and method of scheduling calendar events
US7849056B2 (en) * 2007-02-09 2010-12-07 Research In Motion Limited System and method for managing databases associated with respective personal information manager service accounts
US20080191896A1 (en) * 2007-02-09 2008-08-14 Jain Rohit Rocky Electronic device and method of adding parties to a calendar event
US7751807B2 (en) 2007-02-12 2010-07-06 Oomble, Inc. Method and system for a hosted mobile management service architecture
US8024400B2 (en) 2007-09-26 2011-09-20 Oomble, Inc. Method and system for transferring content from the web to mobile devices
US9665529B1 (en) 2007-03-29 2017-05-30 Amazon Technologies, Inc. Relative progress and event indicators
US7716224B2 (en) 2007-03-29 2010-05-11 Amazon Technologies, Inc. Search and indexing on a user device
US8965807B1 (en) 2007-05-21 2015-02-24 Amazon Technologies, Inc. Selecting and providing items in a media consumption system
US8423889B1 (en) 2008-06-05 2013-04-16 Amazon Technologies, Inc. Device specific presentation control for electronic book reader devices
US8073813B2 (en) * 2008-06-06 2011-12-06 Apple Inc. Refresh and filter anchors
US9087032B1 (en) 2009-01-26 2015-07-21 Amazon Technologies, Inc. Aggregation of highlights
US8378979B2 (en) 2009-01-27 2013-02-19 Amazon Technologies, Inc. Electronic device with haptic feedback
US8832584B1 (en) 2009-03-31 2014-09-09 Amazon Technologies, Inc. Questions on highlighted passages
US8692763B1 (en) 2009-09-28 2014-04-08 John T. Kim Last screen rendering for electronic book reader
CN101697169A (en) 2009-10-23 2010-04-21 中兴通讯股份有限公司 Method, device and system for data synchronization between source database and destination database
US8812136B2 (en) * 2009-11-05 2014-08-19 Blackberry Limited Method and apparatus for controlling a location automation system via a calendar database
US9116905B1 (en) * 2010-06-30 2015-08-25 Emc Corporation System and method for cataloging data
US9495322B1 (en) 2010-09-21 2016-11-15 Amazon Technologies, Inc. Cover display
TWI409652B (en) * 2010-12-15 2013-09-21 Simulate the system log data synchronization system
CN102567338A (en) * 2010-12-16 2012-07-11 凌群电脑股份有限公司 A data synchronization system that simulates syslog
US9158741B1 (en) 2011-10-28 2015-10-13 Amazon Technologies, Inc. Indicators for navigating digital works
US8965847B1 (en) * 2011-10-28 2015-02-24 Oxygen Cloud, Inc. Independent synchronization of file data and file metadata
US10631134B2 (en) 2012-11-29 2020-04-21 Red Hat, Inc. Distributing data between mobile services
CN103559198A (en) * 2013-09-27 2014-02-05 杭州意能软件有限公司 Data synchronizing method and equipment
JP6053665B2 (en) * 2013-11-28 2016-12-27 三菱電機株式会社 Cooperation system
CN104023410B (en) * 2014-05-14 2018-09-11 北京奇虎科技有限公司 A kind of method and apparatus of the safe transfer data between wireless terminal
GB2533086A (en) * 2014-12-08 2016-06-15 Ibm Controlling a multi-database system
US10565168B2 (en) 2017-05-02 2020-02-18 Oxygen Cloud, Inc. Independent synchronization with state transformation
US10956406B2 (en) * 2017-06-12 2021-03-23 Palantir Technologies Inc. Propagated deletion of database records and derived data
JP7006013B2 (en) * 2017-08-22 2022-01-24 富士通株式会社 Data provision program, data provision method, and data provision device
CN110851528B (en) * 2019-10-09 2022-09-02 网联清算有限公司 Database synchronization method and device, storage medium and computer equipment

Family Cites Families (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5261094A (en) 1991-04-08 1993-11-09 International Business Machines Corporation Asynchronous replication of data changes by distributed update requests
US5392390A (en) * 1992-04-10 1995-02-21 Intellilink Corp. Method for mapping, translating, and dynamically reconciling data between disparate computer platforms
US5684990A (en) * 1995-01-11 1997-11-04 Puma Technology, Inc. Synchronization of disparate databases
US5729735A (en) 1995-02-08 1998-03-17 Meyering; Samuel C. Remote database file synchronizer
US5966714A (en) * 1995-04-28 1999-10-12 Intel Corporation Method and apparatus for scaling large electronic mail databases for devices with limited storage
US5649195A (en) * 1995-05-22 1997-07-15 International Business Machines Corporation Systems and methods for synchronizing databases in a receive-only network
US5781908A (en) * 1995-12-18 1998-07-14 J.D. Edwards World Source Company File data synchronizer in a distributed data computer network
US5873096A (en) 1997-10-08 1999-02-16 Siebel Systems, Inc. Method of maintaining a network of partially replicated database system
US5790974A (en) 1996-04-29 1998-08-04 Sun Microsystems, Inc. Portable calendaring device having perceptual agent managing calendar entries
US5974238A (en) * 1996-08-07 1999-10-26 Compaq Computer Corporation Automatic data synchronization between a handheld and a host computer using pseudo cache including tags and logical data elements
AU6665998A (en) * 1997-02-26 1998-09-29 Siebel Systems, Inc. Method of determining the visibility to a remote database client of a plurality of database transactions
US5961590A (en) * 1997-04-11 1999-10-05 Roampage, Inc. System and method for synchronizing electronic mail between a client site and a central site
JPH113368A (en) * 1997-06-11 1999-01-06 Nippon Telegr & Teleph Corp <Ntt> Schedule data managing method in distributed environment, its system and storing medium housing schedule data managing program
US6272545B1 (en) * 1997-10-24 2001-08-07 Microsoft Corporation System and method for interaction between one or more desktop computers and one or more mobile devices
US6065018A (en) * 1998-03-04 2000-05-16 International Business Machines Corporation Synchronizing recovery log having time stamp to a remote site for disaster recovery of a primary database having related hierarchial and relational databases
US6226651B1 (en) * 1998-03-27 2001-05-01 International Business Machines Corporation Database disaster remote site recovery

Also Published As

Publication number Publication date
JP4558945B2 (en) 2010-10-06
HK1044835B (en) 2004-12-24
AU762743C (en) 2004-08-12
CN1339134A (en) 2002-03-06
KR20010093282A (en) 2001-10-27
HK1044835A1 (en) 2002-11-01
AR022568A1 (en) 2002-09-04
AU2954500A (en) 2000-08-29
US6466951B1 (en) 2002-10-15
MY120375A (en) 2005-10-31
KR100626894B1 (en) 2006-09-20
BR0008125A (en) 2001-11-06
JP2002536766A (en) 2002-10-29
SE9900457D0 (en) 1999-02-10
PL349804A1 (en) 2002-09-09
WO2000048096A1 (en) 2000-08-17
SE9900457L (en) 2000-08-11
CN1147812C (en) 2004-04-28
WO2000048096A9 (en) 2001-08-09
EP1206745A1 (en) 2002-05-22
AU762743B2 (en) 2003-07-03

Similar Documents

Publication Publication Date Title
SE515459C2 (en) Method for synchronizing a host database and a remote database
US7134041B2 (en) Systems and methods for data backup over a network
US8266114B2 (en) Log structured content addressable deduplicating storage
US6493709B1 (en) Method and apparatus for digitally shredding similar documents within large document sets in a data processing environment
US20060020616A1 (en) Indexing operational logs in a distributed processing system
US9058346B2 (en) Ordered index
EP1267283A3 (en) Selecting data for synchronization
CN1100542A (en) Method for isolation of chinese words from connected chinese text
JPH09506195A (en) Extended attribute file system
CA2218270A1 (en) Text index registration and retrieval method
CN102982067A (en) Traversing data in a repeatable manner
US20100115000A1 (en) Journaling Database Changes Using a Bit Map for Zones Defined in Each Page
US8090925B2 (en) Storing data streams in memory based on upper and lower stream size thresholds
US20110113052A1 (en) Query result iteration for multiple queries
US20080033909A1 (en) Indexing
JP4511047B2 (en) Protocol for synchronizing parallel processors in a mobile communication system
US6640225B1 (en) Search method using an index file and an apparatus therefor
US7039646B2 (en) Method and system for compressing varying-length columns during index high key generation
US8818990B2 (en) Method, apparatus and computer program for retrieving data
KR20040039691A (en) Indexing method of information searching system
US8886656B2 (en) Data processing
JP3081093B2 (en) Index creation method and apparatus and document search apparatus
US7568156B1 (en) Language rendering
US8630984B1 (en) System and method for data extraction from email files
JP2004062475A (en) Index storage method

Legal Events

Date Code Title Description
NUG Patent has lapsed