|Publication number||US5995980 A|
|Application number||US 08/685,219|
|Publication date||Nov 30, 1999|
|Filing date||Jul 23, 1996|
|Priority date||Jul 23, 1996|
|Publication number||08685219, 685219, US 5995980 A, US 5995980A, US-A-5995980, US5995980 A, US5995980A|
|Inventors||Jack E. Olson, Thomas G. Price|
|Original Assignee||Olson; Jack E., Price; Thomas G.|
|Export Citation||BiBTeX, EndNote, RefMan|
|Patent Citations (9), Referenced by (187), Classifications (9), Legal Events (12)|
|External Links: USPTO, USPTO Assignment, Espacenet|
The present invention relates to computer databases and, in particular, to a system and method for updating target databases with updates entered in a source database.
Database information is, typically, both created and examined. Some database users create data, while other users may merely examine data. For example, an automatic teller machine ("ATM") typically adds or modifies database data, while a trend analyst seeking marketing profiles or fraud evidence, generally examines data created by others.
Databases are often replicated to reduce contention or access to a primary database or provide stand alone work systems and spaces. Replicated databases provide work fields that allow users and clients to create or inspect data without limiting access by others to a primary database. For clients interested in only specific aspects of the primary database, replicas of particular regions or fragments can be provided to avoid absorbing excess resources. Replicated databases also provide a backup in the event of media failure.
Database consistency becomes an important issue when multiple replicas exist simultaneously with a primary database. The replicas must be updated to predictably reflect changes entered in the primary database.
A variety of techniques have been employed to maintain database consistency. Any update technique should demonstrate reasonable throughput and consume limited resources. Amending replica databases to reflect changes entered in a primary database should not unduly limit either replica or primary database access.
Copy replication has been employed to ensure predictable database consistency. Although resource consumptive, copy replication is useful when extensive record changes have been made. In copy replication, copies of the primary database are mapped into database replicas associated with particular users or clients that seek access to the information of the primary database. A copy of the primary is created and is typically applied to the replica database through the local database management system controlling the local replica database. In accordance with a predetermined schedule, database access is locked and the replica is overwritten with the data of the updated primary. The replica database thus reflects changes entered by other clients and users on a predictable basis. Copy replication typically results in inefficient use of system resources and adversely impacts database availability while consuming significant amounts of processing resources and time. A significant flow of messages is required to implement copy replication and maintained, as well as changed, database records are overwritten during copy replication.
Update replication is another known technique employed to manage database consistency. Update replication is more flexible than copy replication and typically updates only records that change data. It can also be structured to update only records of interest to particular database users or clients.
In one known type of update replication, a log skimmer monitors a transaction record log for data changes. When a change of interest is identified, the change is imposed on the target database through the local database manager. When a client is interested in only periodic, rather than immediate updates, applicable changes are queued in structured query language ("SQL") statements corresponding to a sequence of transactions. The channel between the queue and the application process that specifies the changes is blocked until indicated by the update schedule. When scheduled, the block is removed and the application program sequentially specifies a transaction and corresponding subject record to the local database manager which, in response, brings the applicable data page of the target database out of storage for processing in a buffer according to the specified transaction.
Once updated, the processed page is over-written into the appropriate area of the target database. This process continues down through the pending queue. If numerous changes are queued, the update process consumes, therefore, significant resources.
Although more precise than copy replication, update replication is a complicated system and employs extra processes not required for copy replication. Update replication also serializes changes and suffers, therefore, from wasted handling overhead and transactions.
The serialized transactions corresponding to queued changes to a particular record do not efficiently express the cumulated impact of the individual transactions on the particular record. For example, numerous queued changes to a particular record could, at the conclusion of the sequence of changes, leave the record unchanged or even deleted. Nevertheless, update replication executes the sequence of operations corresponding to the queued changes despite an unchanged or deleted end result. Consequently, when a record is ultimately unchanged or deleted by a series of changes, the intervening corresponding sequence of individual transactions has wasted system resources.
Multiply queued changes to a particular record are not organized, rather than organized in correspondence with the physical storage organization of the database, further wasting processing effort. A particular page may be brought out of storage and overwritten in the target multiple times during an update because the changes are not organized according to physical storage location.
The multiple queued transactions implicit in update replication consume significant resources. A "transaction" is a unit of work performed by an application program. In one transaction interface technique, as an example of the processing undertaken in database page handling, a transaction log is maintained in nonvolatile storage. Every completed transaction is recorded as a log record including UNDO and REDO components. The UNDO component records a database record before it is changed by a transaction and the REDO component of the log record is a copy of the record after the change has been imposed. Each record update results in the writing of an UNDO and REDO record in the transaction log. Assuming completion of the transaction which updates a particular record, the database manager will copy the requisite page into the work buffer where the recovery process will use the transaction log REDO record to update the record of interest. The local database manager will then write the updated page to the target database. The creation of both REDO and UNDO records allows backward recovery to restore records to their prior state if a transaction is aborted. If a transaction associated with a REDO record aborts, the record data from the UNDO record is logged as a REDO record and is applied to the database page to back-out the original update. The log record can also contain a COMMIT field indicating the successful conclusion of the associated transaction. Consequently, the database manager is significantly burdened if required to implement a lengthy queue of transactions implicit in the queued update replication process.
Consequently, what is needed is an efficient and robust update system that reduces update replication demands on system resources. The update method should also be flexible enough to update specific records and readily adaptable to a variety of organizational or system configurations without undue administrative or maintenance effort.
An object of the present invention is, therefore, to provide a system and method for updating a target database or other data compilation with informational changes entered in a source database or other data compilation.
A further object of this invention is to provide an update system and method that can selectively update records having particular attributes while reducing demands on system resources.
A still further object of this invention is to provide an update system and method that reduces the time required to implement updates and reduces administrative and training burdens on organizations.
The present invention provides a new, high-performance system and method for updating databases or other data compilations with changes entered in a source database or data compilation. The invention is particularly useful in database replication processes, but can be employed to advantage for managing data consistency wherever data changes are made available.
In the present invention, updates are preprocessed to reduce system update demands while increasing update flexibility for remote processing sites. Data update records are captured or collected and extracted into one or more channel or other criterion-specific batches. Transaction boundaries within a batch are collapsed, and the records coalesced into a package comprising a sequence of updates that reflect the cumulated impact of the extracted records. In a preferred embodiment, the batched records are sorted by extracted sort key entries and the package is converted to the physical format of respective targets. The created update package is, therefore, organized and physically formatted in correspondence with the target database. The update package is then directly applied to the target database without resort to the traditional front door processing through the local database manager. The processing typically required in database update replication is, thereby, avoided and the update process significantly streamlined.
The update packages may be moved to targets by variety of methods. The packages can be conveyed across network or Internet connections or between disconnected computers. The packages may be stored in computer readable media such as disks or CD ROMs, for example, from which the packages may be accessed by target systems. The update packages may also be made available through modems to field users or clients to allow flexible update scheduling. The invention results in a high performance, database update system and method that significantly reduces system update burdens while increasing update flexibility and minimizing impacts from failures during updating. Updates are performed in significantly less time with a system and method that requires little administrative oversight and minimal personnel training.
In a preferred embodiment, data management records that change data are captured from the system log and queued in a captured data set for further, criteria-specific, selection and processing. Channel-relevant records that satisfy predetermined criteria are extracted, along with their associated sort key entries into corresponding extract data sets to create extract update batches. Extract update batches are accordingly sorted to create sorted extract update batches organized in correspondence with the storage structure of the target database. The records within each channel-associated and sorted extract data set are combined or eliminated and existing transaction boundaries are collapsed to coalesce the represented data changes into a sequence of updates reflecting the cumulated impact of the extract update batches. The resulting package is converted to native target format allowing the target to be updated without resort to the target database manager. A package description file is generated to track the pre-processing conducted to yield the resulting update packages constructed for each target channel of interest.
In an implementation of a preferred embodiment, a CAPTURE machine captures data management records to create a capture data set made available for further selection. An EXTRACT machine examines the capture data set to select channelrelevant records that satisfy predetermined WHERE clauses. The selected records are written, along with appropriate index sort keys, to corresponding extract data sets. A BUILD machine, which may optionally be included in EXTRACT, coalesces the records to collapse transaction boundaries and eliminate unneeded and superfluous records to construct an update sequence reflecting the cumulated impact of the extracted records. The resulting package is converted to the physical format of the target to generate an update package that can be applied directly to the target, by-passing the database management system. A package description file is prepared to track the pre-processing conducted to yield the resulting update package. The CAPTURE, EXTRACT, and BUILD machines are comprised of software instructions stored in a computer and executed by a computer. In a preferred embodiment, an apply machine applies the constituent DELETES, UPDATES, and INSERTS of a typical update package to the target in a rational order and executes appropriate index changes.
The present invention preprocesses updates intended for reflection in target data files and databases. Changed records are collected or captured, index components are sorted, and the batch cumulated and reconfigured in target physical format and applied as a single update transaction package. Consequently, update replication burdens are minimized while update flexibility and convenience are increased.
The invention may be embodied as instructions in computer readable media such as tapes, disks, and CD ROMs, for example. The invention is applicable wherever database availability is valued and consistency between source and target databases is desired. The present invention is particularly helpful in systems having limited resources for update processing, and can find ready employment in large systems as an adjunct to already existing update systems. By preparing a package embodied in a computer readable magnetic medium reflecting available updates, the present invention also offers individual satellite or remote clients or units update scheduling flexibility to update when convenient.
The provided invention is particularly suited for systems in which only some of the many records in large databases are to be changed or examined between updates. For example, the historical records of large, comprehensive health plan databases are regularly modified in only a percentage of the many constituent records and, typically, are usually examined only in fragmentary or regional form. Price changes in product databases, manufacturing error pattern analyses systems, and bank customer marketing or fraud targeting systems are a few of the many more readily recognized uses for the present invention.
FIG. 1 is a block diagram of an exemplar system in which the present invention is employed to advantage.
FIG. 2 is a block diagram of a preferred implementation of the update system of the present invention as employed in the system of FIG. 1.
FIG. 3 is a flow chart illustrating the steps performed in a preferred implementation of the present invention employed to create an update package directly applicable to a target database.
FIG. 4 is flow chart indicating the steps performed by the CAPTURE machine employed by the update system shown in FIG. 2.
FIG. 5 is a flow chart describing the steps performed by the EXTRACT machine employed by the update system shown in FIG. 2.
FIG. 6 is a flow chart indicating the steps performed by the BUILD machine employed by the update system shown in FIG. 2.
FIG. 7 is a flow chart illustrating the update sequence used to apply the update package to a target database in a preferred implementation of the present invention.
The present invention provides a new, high-performance system and method for updating databases or other data compilations with changes entered in a source database or data compilation. The invention is particularly useful in database replication processes, but can be employed to advantage for managing data consistency wherever data changes are made available.
FIG. 1 is a block diagram illustrating system 10 that employs target and source databases and supports database update processing in accordance with the present invention. As shown in FIG. 1, exemplar system 10 provides source data creation capabilities through data clients 121 and 122, data creation terminals 14, and central computer 11. Data clients 121 and 122 may be single host computers or may be connected to a number of terminals or nodes 14 further identified in FIG. 1 as terminals Tc. Data clients 121 and 122 and user terminals 14 may be personal computers, work stations, modems connected to remote users, automated teller machines or other of a variety of data creating devices. Computer 11 may be any processor-controlled computer adapted to system management. Computer 11 may comprise a type of a machine similar to data clients 121 and 122 or may be a typical mainframe computer.
Computer 11 includes source database manager 16 through which computer 11 manages source database 18. Data changes or updates entered from data clients 121 and 122 or terminals 14 are reflected in source database 18 and recorded in log 20. Log 20 may record recent or aged record changes.
Complete or fragmentary replicas of source database 18 are provided to local target databases 221 -22n for use. By user clients 241 -24n and terminals 26. When more than one of user clients 241 -24n and terminals 26 share a local database, access is directed under the control of respective local database managers 28. Local logs 29 store transaction records relevant to their respective local databases.
As indicated in FIG. 1, target databases 221 -22n are updated in system 10 with update packages 301 -30n, respectively. Each of update packages 301 -30n is adapted and created by update system 32 for direct application through apply machine 31 to the corresponding target database 221 -22n. Apply machine 31 is comprised of software instructions stored in a computer or computer memory and executed by a computer. Update system 32 is comprised of software machines CAPTURE, EXTRACT, and BUILD. The software machines CAPTURE, EXTRACT, and BUILD are comprised of software instructions stored in a computer and executed by a computer such as computer 11, for example. Although update system 32 is is comprised of software machines stored and executed by a computer, for clarity of the present exposition, update system 32 is given its own reference block 32 in FIG. 1. Those skilled in the art will recognize that machines CAPTURE, EXTRACT, and BUILD may be stored and executed in different computers.
In the embodiment depicted in FIG. 1, update system 32 is employed to update target databases 221 -22n with record changes or updates entered in source database 18, but those skilled in the art will recognize that update system 32 may be logically positioned to provide update services in either direction. Update system 32 is adaptable to provide update processing appropriate for any of a variety of source and target databases or data compilations wherever data or records require updating.
FIG. 2 is a block diagram of update system 32 as employed in the system of FIG. 1. With reference to FIG. 2, CAPTURE machine 34 locates source database table channel data 35 to determine channels to be updated and examines updated records from log 20 to select appropriate data management records for deposit in buffer space identified as capture data set queue 36. CAPTURE machine 34 may, in alternative embodiments, capture changes from sources other than log 20. For example, changes could be captured directly from clients 12, and 122 without resort to log examination, as represented in FIG. 1 by path 21 between client 122 and update system 32.
With continuing reference to FIG. 2, EXTRACT machine 38 is initialized with channel definitions and predetermined user parameters and a separate output extract data set queue 401 -40n is opened for each database source channel. EXTRACT machine 38 will typically open in buffer storage, multiple extract data set queues 401 -40n to individually correspond to multiple channels having update data. The records deposited in capture data set queue 36 by CAPTURE machine 34 are evaluated by EXTRACT machine 38 to determine whether particular channel and WHERE statement criteria are satisfied. EXTRACT machine 38 extracts an appropriate sort key for the index components of each of the records selected from capture data set queue 36 and writes the keys along with the selected record into the corresponding extract data set queue 401 -40n creating individual extract update batches 391 -39n that correspond to the channels of interest.
When EXTRACT machine 38 has created an extract update batch for each database channel of interest, BUILD machine 42 sorts the extract update batch according to the index keys created by EXTRACT machine 38. Sorting adapts the extract update batch to the organizational structure of the target database. BUILD machine 42 collapses transaction boundaries of the extract update batch and coalesces the records into a sequence of updates expressing the cumulated impact of the extract update batch to create one of the reduced-transaction update packages 301 -30n corresponding to the extract update batches 391 -39n in each of extract data set queues 401 -40n BUILD machine 42 may, alternatively, be considered a part of EXTRACT machine 38, but it is more convenient to articulate BUILD as a separate machine dedicated to create update packages 301 -30n from the extract update batches 391 -39n in extract data set queues 401 -40n, respectively.
In a preferred embodiment, BUILD machine 42 converts the coalesced update packages into the physical format of the particular target database to create a single transaction update package adapted to the physical formatting of the respective target database. In other implementations of the present invention, pre-processing by cumulating records still achieves processing economy even though the package may be applied through the local database manager. Single-transaction update packages in target format eliminate, however, update processing through respective local database managers and avoids, therefore, the attendant locking and logging during the update process. Formatted, single-transaction update packages are, consequently, preferred.
If system 10 services targets of various formats, such as ORACLEİ, IBMİ, and SYBASEİ databases for example, BUILD machine 42 constructs more than one update package from the extract update batches 391 -39n in each of the extract data set queues 401 -40n. In a preferred embodiment, therefore, for the extract update batch 391 -39n in each extract data set queue 401 -40n, there will be at least one corresponding update package 301 -30n, and, if a variety of target formats are serviced, BUILD machine 42 will construct an update package in each target format, from the extract update batches 391 -39n in extract data set queues 401 -40n. FIG. 2 illustrates the creation of more than one formatted update package for the extract update batch 391 in extract data set queue 401 by indicating update packages 301IB and 301SY representing exemplar IBMİ and SYBASEİ format update packages, respectively, both of which are generated from the extract update batch 391 stored in extract data set queue 401 by BUILD machine 42.
FIG. 3 is a flow chart illustrating the steps performed in a preferred implementation of the present invention employed to create an update package directly applicable to a target database. As shown in step 44, a series of records within a particular time of interest are collected or captured and stored in an allocated record queue. From the collected records, those records relevant to a selected channel of interest are extracted to create an extract update batch stored in an allocated extract queue as indicated in step 45. In step 46, sort key entries are extracted and the batch is sorted. In step 47, transaction boundaries of the extract update batch are collapsed to create an update package. The package is converted to the physical format of the target database in step 48 to create an update package that can be applied to the target database by direct modification of the physical storage of the target.
FIG. 4 is flow chart indicating the steps performed by CAPTURE machine 34 in a preferred implementation of the present invention. CAPTURE machine 34 orients itself to the system environment and conducts a number of operations to initialize in step 50. During step 50 CAPTURE machine 34 locates database channels by reading DB2 tables, for example. Any applicable compression dictionaries and edit and field processes are loaded, the log records are located by reading the boot strap data set (BSDS) and a restart facility is acquired and a check for conflicts is conducted as part of the initialization indicated by step 50. In step 51, a capture data set, such as capture data set queue 36 depicted in FIG. 2, is opened as a repository for captured records and a header is written to define the space used for CAPTURE 34 output.
In step 52, CAPTURE 34 finds and opens the log data set of log 20 and, using the BSDS, the desired starting place is found in the log data set and the first subject record is read. In step 54, CAPTURE machine 34 determines if the subject record is spanned, and if so, all the record segments are gathered in step 56. The record is evaluated for type in step 58, and if the record is of a type that changes or adds data (i.e. data management type) the record is evaluated for relevance to a channel of current interest in step 60. If the record does not change or add data, CAPTURE 34 returns to step 52 where the next log record is read.
If the record is relevant to a channel of interest, CAPTURE 34 determines in step 62 if the record is a BEGIN or END transaction and either queues a COMMIT, as indicated in step 64, or adds the record to the in-flight table as shown in step 66. For users interested in transaction consistency, the in-flight table will be later checked by EXTRACT machine 38. If the record is not relevant, CAPTURE machine 34 returns to step 52 to read the next record. In step 68, the surviving subject record is queued and CAPTURE machine 34 determines if a next record is to be read in step 70 and either stops as indicated by step 72, or returns to step 52 to read the next record. At the end of the process shown in FIG. 4, CAPTURE machine 34 has opened and populated a capture data set queue 36 for use by EXTRACT machine 38.
FIG. 5 is a flow chart illustrating the steps performed by EXTRACT machine 38 to collect extract update batches 391 -39n from the records available in the capture data set queue 36. EXTRACT machine 38 initializes in step 80 by getting user defined channel definitions such as restrictions and source tables, for example, from the database tables. The character conversion table is read and user parameters for extraction are determined, and, as indicated in optional step 81, the in-flight table is read.
In step 82, the capture data set is opened to read the records queued by CAPTURE machine 34, and in step 84, an extract data set is opened for each channel of interest. EXTRACT machine 38 reads the first subject record from capture data set queue 36 as indicated by step 86. For users interested in transaction consistency, step 88 indicates that EXTRACT machine 38 can, if requested or required by the user of update system 32, evaluate the in-flight status of the subject record. If in-flight status is checked, records that indicate COMMIT are passed to the channel-relevance determination in step 90, while records that indicate a begin transaction are dropped by EXTRACT machine 38 which returns to step 86 to acquire the next subject record from capture data set queue 36.
If transaction consistency is not requested or required, EXTRACT machine 38 determines channel-relevance in step 90 without checking an in-flight table. Those records found to be relevant are evaluated against criterion-determining. WHERE clauses in step 92. In step 94, sort key entries for components of the record are created. The sort keys will be used to reorder the components of the statements of the update package by database page, minimizing update package application time. The record and corresponding sort keys are written to the appropriate extract data set queue 401-40 n, and, if the queued record concluded the capture data set, EXTRACT machine 38 stops as shown in step 99. If the capture data set includes another record for potential extraction, EXTRACT 38 machine returns to step 86 to read the next subject record. At the end of the process shown in FIG. 4, EXTRACT machine 38 has opened and populated each of extract data set queues 401 -40n with corresponding extract update batches 391 -39n for use by BUILD machine 42.
The execution steps performed by BUILD machine 42 are illustrated in the flow chart shown in FIG. 6. BUILD machine 42 initializes in step 100 by reading channel definitions from, for example, DB2 tables. The collating sequence table indicating sort ordering is also read during step 100 and any needed character conversion tables are read. In step 102, BUILD machine 42 sorts a selected extract update batch, such as extract update batch 391, for example, prepared by EXTRACT machine 38. Extract update batch 391 is sorted according to the indexing and storage strategy of the target database.
In step 104, the records from extract update batch 391 are coalesced to combine or eliminate superfluous records into a package comprising a sequence of updates expressing the cumulated impact of the records of the extract data set. For example, if extract update batch 391 includes a series of updates to a particular record, and the updates are followed by a DELETE, BUILD machine 42 will collapse the series of updates and DELETE into a single DELETE and eliminate the prior updates. In step 106, the sequence of updates are converted to the physical format of the target. If multiple targets are to be updated, an update package is prepared in each of the target formats. In a preferred embodiment, format conversion of INSERT records comprises building a target formatted row image of the record. Format conversion for DELETE records comprises placing in the package the primary key of the record to be deleted in target format and format conversion for UPDATE records comprises including in the package the primary key and a set of columns to be changed and new value of target format. In step 108, a package description file is prepared to describe the process taken to yield the update package and, in step 110, BUILD machine 42 either concludes its work or returns to step 102 to read and sort the next extract update batch.
Once prepared, an update package 301 -30n is applied to the respective target database 221 -22n through apply machine 31 in, preferably, one transaction. Because the update packages 301 -30n are in target native physical format, they can be applied directly to the physical storage of the respective target databases without resort to the corresponding local database managers 28. Consequently, significant resources are conserved, and time consumed during updating is correspondingly reduced. Within an update package, the DELETES, UPDATES, and INSERTS may themselves be imposed in particular order to provide further improvement.
FIG. 7 indicates a preferred processing order of the constituent operations of an update package as executed by apply machine 31 earlier depicted in FIG. 1. With reference to FIG. 7, apply machine 31 preferably processes DELETES first as shown in step 120. This may free room in a unit storage area or page. The index is used to find the keys for the row to be deleted and a pointer is applied to the record which is then deleted. UPDATES are then applied as shown in step 122. With an update, a record may get longer and if there is not enough room on the page, an overflow marker must be processed. UPDATES are processed by looking up the primary key of the row to be updated and finding the pointer to the record and updating. In step 124, apply machine 31 processes the INSERTS last using the appropriate row image.
It should be apparent to those having skill in the art that the invention may be embodied in a variety of forms without departing from its essential characteristics or its spirit. Iterations of invention embodiments may be employed, for example, to provide bi-directional updating. The described embodiments are illustrative and not to be considered restrictive and the scope of the invention is, therefore, to be indicated by the following claims.
|Cited Patent||Filing date||Publication date||Applicant||Title|
|US4631673 *||Jan 22, 1985||Dec 23, 1986||International Business Machines Corporation||Method for refreshing multicolumn tables in a relational data base using minimal information|
|US4714992 *||Nov 26, 1985||Dec 22, 1987||International Business Machines Corporation||Communication for version management in a distributed information service|
|US4714995 *||Sep 13, 1985||Dec 22, 1987||Trw Inc.||Computer integration system|
|US4809170 *||Apr 22, 1987||Feb 28, 1989||Apollo Computer, Inc.||Computer device for aiding in the development of software system|
|US5357629 *||Sep 16, 1991||Oct 18, 1994||Pitney Bowes Inc.||System for recording structured read only data table revisions and forming a directory to the latest revisions of table elements|
|US5600832 *||Dec 7, 1994||Feb 4, 1997||International Business Machines Corporation||Variant domains and variant maps in a versioned database management system|
|US5649195 *||May 22, 1995||Jul 15, 1997||International Business Machines Corporation||Systems and methods for synchronizing databases in a receive-only network|
|US5737601 *||Jan 16, 1997||Apr 7, 1998||Oracle Corporation||Method and apparatus for peer-to-peer data replication including handling exceptional occurrences|
|US5819251 *||Feb 6, 1996||Oct 6, 1998||Oracle Corporation||System and apparatus for storage retrieval and analysis of relational and non-relational data|
|Citing Patent||Filing date||Publication date||Applicant||Title|
|US6202149||Sep 30, 1998||Mar 13, 2001||Ncr Corporation||Automated application fail-over for coordinating applications with DBMS availability|
|US6249786 *||Mar 21, 1997||Jun 19, 2001||Rolf Wadewitz||Data-conversion method|
|US6253213 *||Feb 22, 1999||Jun 26, 2001||International Business Machines Corporation||Method and system for automatically maintaining data consistency across various databases|
|US6263433 *||Sep 30, 1998||Jul 17, 2001||Ncr Corporation||Provision of continuous database service and scalable query performance using active redundant copies|
|US6339787 *||Nov 17, 1999||Jan 15, 2002||Stampede Technologies, Inc.||Apparatus and method for increasing speed in a network file/object oriented server/client system|
|US6505200 *||Jul 6, 2000||Jan 7, 2003||International Business Machines Corporation||Application-independent data synchronization technique|
|US6529904||May 28, 1999||Mar 4, 2003||Oracle Corp.||Deployment of snapshots with parameterized data description language strings|
|US6532479||May 28, 1999||Mar 11, 2003||Oracle Corp.||Data replication for front office automation|
|US6622152 *||May 9, 2000||Sep 16, 2003||International Business Machines Corporation||Remote log based replication solution|
|US6684372||Mar 15, 2002||Jan 27, 2004||Sun Microsystems, Inc.||Method, system and computer product to translate electronic schematic files between computer aided design platforms|
|US6697804||Nov 14, 2002||Feb 24, 2004||Oracle International Corp.||Deploying plurality of sanpshots storing parameterized data description language strings with substitutable parameter causes database object to instantiated|
|US6738801 *||Dec 30, 1999||May 18, 2004||Fujitsu Limited||Master server facilitating communication between slave servers in incompatible data formats, and method for upgrading slave servers|
|US6769074 *||May 21, 2001||Jul 27, 2004||Lumigent Technologies, Inc.||System and method for transaction-selective rollback reconstruction of database objects|
|US6792540||May 28, 1999||Sep 14, 2004||Oracle International Corporation||Data replication security|
|US6799190||Apr 11, 2002||Sep 28, 2004||Intellisync Corporation||Synchronizing databases|
|US6847384 *||Apr 1, 1999||Jan 25, 2005||Autodesk, Inc.||Translating objects between software applications which employ different data formats|
|US6847971 *||May 28, 1999||Jan 25, 2005||Oracle International Corporation||Lightweight data replication|
|US6850958 *||Nov 16, 2001||Feb 1, 2005||Fujitsu Limited||Backup system, backup method, database apparatus, and backup apparatus|
|US6877159 *||Jul 27, 2000||Apr 5, 2005||International Business Machines Corporation||Apparatus and method for maintaining object associations in an object oriented environment|
|US6889333 *||Nov 1, 2001||May 3, 2005||Microsoft Corporation||System and method for replicating data in a distributed system|
|US6904426 *||Sep 13, 2002||Jun 7, 2005||International Business Machines Corporation||Method, computer program product, and system for the generation of transaction screen displays from a hierarchical database management log utilizing a batch terminal simulator|
|US6938045||Jan 18, 2002||Aug 30, 2005||Seiko Epson Corporation||Image server synchronization|
|US6973464||Jul 16, 2002||Dec 6, 2005||Novell, Inc.||Intelligent replication method|
|US7016890 *||Dec 20, 2000||Mar 21, 2006||Hitachi, Ltd.||Database system, method for forming replica of database, and computer-readable recording medium that records database replica forming program|
|US7024429||Jan 31, 2002||Apr 4, 2006||Nextpage,Inc.||Data replication based upon a non-destructive data model|
|US7039661 *||Dec 29, 2003||May 2, 2006||Veritas Operating Corporation||Coordinated dirty block tracking|
|US7076481||Mar 24, 2003||Jul 11, 2006||Bmc Software, Inc.||Method and apparatus for logically reconstructing incomplete records|
|US7111019 *||Nov 5, 1999||Sep 19, 2006||Hitachi, Ltd.||Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system|
|US7130874||Mar 12, 2002||Oct 31, 2006||International Business Machines Corporation||Method, system, and program for maintaining data in a distributed computing environment for processing transaction requests|
|US7130974||Oct 2, 2003||Oct 31, 2006||Hitachi, Ltd.||Multi-site remote-copy system|
|US7130975||Feb 23, 2004||Oct 31, 2006||Hitachi, Ltd.||Data processing system|
|US7143254||Jan 19, 2006||Nov 28, 2006||Hitachi, Ltd.||Remote copy system|
|US7152079||Aug 27, 2003||Dec 19, 2006||Hitachi, Ltd.||Data replication among storage systems|
|US7159088||Sep 30, 2004||Jan 2, 2007||Hitachi, Ltd.||Storage system and data processing system|
|US7162689||May 28, 1999||Jan 9, 2007||Oracle International Corporation||Schema evolution in replication|
|US7167877||Nov 1, 2002||Jan 23, 2007||Verisign, Inc.||Method and system for updating a remote database|
|US7216209||Jan 28, 2004||May 8, 2007||Hitachi, Ltd.||Data processing system having a plurality of storage systems|
|US7219201||Dec 30, 2003||May 15, 2007||Hitachi, Ltd.||Remote storage disk control device and method for controlling the same|
|US7228398||Apr 28, 2006||Jun 5, 2007||Hitachi, Ltd.||Multi-site remote-copy system|
|US7251650||Aug 25, 2003||Jul 31, 2007||International Business Machines Corporation||Method, system, and article of manufacture for processing updates to insert operations|
|US7277900||Feb 10, 2003||Oct 2, 2007||Oracle International Corporation||Method and mechanism for rolling back a transaction on a row of data|
|US7287040||Feb 4, 2004||Oct 23, 2007||American Express Travel Related Services Company, Inc.||Test strategy system and method for accounts held direct at-fund|
|US7293005||Jan 26, 2004||Nov 6, 2007||International Business Machines Corporation||Pipelined architecture for global analysis and index building|
|US7296126||Jun 23, 2006||Nov 13, 2007||Hitachi, Ltd.||Storage system and data processing system|
|US7299230 *||Aug 2, 2002||Nov 20, 2007||Siebel Systems, Inc.||Method, apparatus and system for transforming, converting and processing messages between multiple systems|
|US7313663||Mar 2, 2007||Dec 25, 2007||Hitachi, Ltd.||Storage system and data processing system|
|US7328373||Oct 10, 2006||Feb 5, 2008||Hitachi, Ltd.||Data processing system|
|US7346633||Jun 10, 2004||Mar 18, 2008||Sybase, Inc.||System providing methodology for replication subscription resolution|
|US7366713||Apr 17, 2003||Apr 29, 2008||Oracle International Corporation||Extensible rules engine in a database management system|
|US7370044||Nov 19, 2001||May 6, 2008||Equifax, Inc.||System and method for managing and updating information relating to economic entities|
|US7386715||Feb 1, 2005||Jun 10, 2008||Microsoft Corporation||System and method for replicating data in a distributed system|
|US7424467||Jan 26, 2004||Sep 9, 2008||International Business Machines Corporation||Architecture for an indexer with fixed width sort and variable width sort|
|US7426559 *||May 9, 2002||Sep 16, 2008||International Business Machines Corporation||Method for sequential coordination of external database application events with asynchronous internal database events|
|US7447855||Oct 17, 2006||Nov 4, 2008||Hitachi, Ltd.||Data processing method providing remote copy in a system having first, second, and third storage systems|
|US7461064||Sep 24, 2004||Dec 2, 2008||International Buiness Machines Corporation||Method for searching documents for ranges of numeric values|
|US7461226||Apr 26, 2007||Dec 2, 2008||Hitachi, Ltd.||Multi-site remote-copy system|
|US7490113||Aug 27, 2003||Feb 10, 2009||International Business Machines Corporation||Database log capture that publishes transactions to multiple targets to handle unavailable targets by separating the publishing of subscriptions and subsequently recombining the publishing|
|US7499913||Jan 26, 2004||Mar 3, 2009||International Business Machines Corporation||Method for handling anchor text|
|US7499953||Apr 23, 2004||Mar 3, 2009||Oracle International Corporation||Online recovery of user tables using flashback table|
|US7506068||Aug 2, 2002||Mar 17, 2009||Siebel Systems, Inc.||Method, apparatus and system for transforming, converting and processing messages between multiple systems|
|US7529901||Oct 9, 2007||May 5, 2009||Hitachi, Ltd.||Storage system and data processing system|
|US7562102 *||May 31, 2005||Jul 14, 2009||Progress Software Corporation||Extensible handling of new or modified data within an independent distributed database system|
|US7565379 *||May 30, 2003||Jul 21, 2009||Edwina Lu||Preventing change cycling using rules and redo tags in a redo log|
|US7567975||Mar 16, 2005||Jul 28, 2009||Oracle International Corporation||Incremental evaluation of complex event-condition-action rules in a database system|
|US7587435||Nov 10, 2006||Sep 8, 2009||Sybase, Inc.||Replication system with methodology for replicating database sequences|
|US7600021 *||Apr 3, 2002||Oct 6, 2009||Microsoft Corporation||Delta replication of source files and packages across networked resources|
|US7600149 *||Sep 20, 2005||Oct 6, 2009||International Business Machines Corporation||Failure transparency for update applications under single-master configuration|
|US7606841||May 2, 2006||Oct 20, 2009||Symantec Operating Corporation||Coordinated dirty block tracking|
|US7613741||May 29, 2003||Nov 3, 2009||Oracle International Corporation||Utilizing rules in a distributed information sharing system|
|US7617254||Aug 5, 2003||Nov 10, 2009||Oracle International Corporation||Method and mechanism for relational access of recovery logs in a database system|
|US7673107||Jul 3, 2007||Mar 2, 2010||Hitachi, Ltd.||Storage system and storage control device|
|US7685049 *||Jun 26, 2002||Mar 23, 2010||Trading Technologies International Inc.||System and method for coalescing market data at a client device|
|US7725445||Nov 17, 2004||May 25, 2010||Hitachi, Ltd.||Data replication among storage systems|
|US7730538||Jun 2, 2006||Jun 1, 2010||Microsoft Corporation||Combining virus checking and replication filtration|
|US7742962||May 2, 2006||Jun 22, 2010||Trading Technologies International Inc.||System and method for coalescing market data at a client device|
|US7743060||Aug 6, 2007||Jun 22, 2010||International Business Machines Corporation||Architecture for an indexer|
|US7761406||Mar 16, 2005||Jul 20, 2010||International Business Machines Corporation||Regenerating data integration functions for transfer from a data integration platform|
|US7769896 *||Sep 26, 2002||Aug 3, 2010||Siebel Systems, Inc.||Method, apparatus and system for dispatching messages within a system|
|US7783626||Aug 17, 2007||Aug 24, 2010||International Business Machines Corporation||Pipelined architecture for global analysis and index building|
|US7801849||Aug 16, 2007||Sep 21, 2010||American Express Travel Related Services Company, Inc.||Test strategy system and method for accounts held direct at-fund|
|US7802137||Dec 14, 2007||Sep 21, 2010||Hitachi, Ltd.||Journaling system switching to another logical volume to store subsequently received update history|
|US7809777||Jul 1, 2005||Oct 5, 2010||Qnx Software Systems Gmbh & Co. Kg||File system having deferred verification of data integrity|
|US7814142||Feb 24, 2005||Oct 12, 2010||International Business Machines Corporation||User interface service for a services oriented architecture in a data integration platform|
|US7814470||Feb 24, 2005||Oct 12, 2010||International Business Machines Corporation||Multiple service bindings for a real time data integration service|
|US7870110||Feb 27, 2008||Jan 11, 2011||International Business Machines Corporation||Method and system for generating a transaction-bound sequence of records in a relational database table|
|US7873683 *||Jun 9, 2006||Jan 18, 2011||Qnx Software Systems Gmbh & Co. Kg||File system having transaction record coalescing|
|US7908276||Mar 13, 2007||Mar 15, 2011||Qnx Software Systems Gmbh & Co. Kg||Filesystem having a filename cache|
|US7937368||May 17, 2006||May 3, 2011||Oracle International Corporation||Method and mechanism for identifying transaction on a row of data|
|US7953707 *||Apr 15, 2008||May 31, 2011||International Business Machines Corporation||System and program product for sequential coordination of external database application events with asynchronous internal database events|
|US7970803||Jul 1, 2005||Jun 28, 2011||Qnx Software Systems Gmbh & Co. Kg||Optimized startup verification of file system integrity|
|US7979546 *||Apr 15, 2008||Jul 12, 2011||International Business Machines Corporation||Method, system, and program product for sequential coordination of external database application events with asynchronous internal database events|
|US7987190||Dec 3, 2010||Jul 26, 2011||Qnx Software Systems Gmbh & Co. Kg||Filesystem having a filename cache|
|US7991745||Dec 24, 2008||Aug 2, 2011||International Business Machines Corporation||Database log capture that publishes transactions to multiple targets to handle unavailable targets by separating the publishing of subscriptions and subsequently recombining the publishing|
|US8005802||May 30, 2003||Aug 23, 2011||Oracle International Corporation||Partial evaluation of rule sets|
|US8037020||Aug 12, 2010||Oct 11, 2011||American Express Travel Related Services Company, Inc.||Test strategy system and method for accounts held direct at-fund|
|US8041760||Feb 24, 2005||Oct 18, 2011||International Business Machines Corporation||Service oriented architecture for a loading function in a data integration platform|
|US8051114||Dec 1, 2010||Nov 1, 2011||Qnx Software Systems Limited||Optimized startup verification of file system integrity|
|US8060553||Feb 24, 2005||Nov 15, 2011||International Business Machines Corporation||Service oriented architecture for a transformation function in a data integration platform|
|US8074036||Oct 7, 2008||Dec 6, 2011||Hitachi, Ltd.||Data processing system having first, second and third storage systems that are arranged to be changeable between a first status and a second status in response to a predetermined condition at the first storage system|
|US8099385||Oct 16, 2008||Jan 17, 2012||International Business Machines Corporation||System and article of manufacture for maintaining data in a distributed computing environment for processing transaction requests|
|US8117154||Sep 13, 2010||Feb 14, 2012||Gravic, Inc.||Method for ensuring replication when system resources are limited|
|US8121978||Sep 11, 2003||Feb 21, 2012||Sybase, Inc.||Database system providing improved methods for data replication|
|US8122178||Jun 10, 2011||Feb 21, 2012||Qnx Software Systems Limited||Filesystem having a filename cache|
|US8135671||Mar 8, 2007||Mar 13, 2012||Hitachi, Ltd.||Data replication among storage systems|
|US8140565||Jan 20, 2009||Mar 20, 2012||International Business Machines Corporation||Autonomic information management system (IMS) mainframe database pointer error diagnostic data extraction|
|US8234471||Sep 30, 2009||Jul 31, 2012||Hitachi, Ltd.||Remote copy method and remote copy system|
|US8239344||Mar 8, 2007||Aug 7, 2012||Hitachi, Ltd.||Data replication among storage systems|
|US8250029||Jan 4, 2012||Aug 21, 2012||Gravie, Inc.||Method for ensuring replication from a change queue of a source database to a target database when transaction load exceeds data path by spawning a new transaction path between the change queue and the target database|
|US8271498||Aug 12, 2008||Sep 18, 2012||International Business Machines Corporation||Searching documents for ranges of numeric values|
|US8285724||Dec 3, 2008||Oct 9, 2012||International Business Machines Corporation||System and program for handling anchor text|
|US8296304||Jan 26, 2004||Oct 23, 2012||International Business Machines Corporation||Method, system, and program for handling redirects in a search engine|
|US8301546||May 17, 2011||Oct 30, 2012||Trading Technologies International, Inc.||System and method for providing market updates in an electronic trading environment|
|US8307109||Aug 24, 2004||Nov 6, 2012||International Business Machines Corporation||Methods and systems for real time integration services|
|US8341134 *||Dec 10, 2010||Dec 25, 2012||International Business Machines Corporation||Asynchronous deletion of a range of messages processed by a parallel database replication apply process|
|US8346759||Aug 6, 2008||Jan 1, 2013||International Business Machines Corporation||Searching documents for ranges of numeric values|
|US8352425||Mar 14, 2008||Jan 8, 2013||International Business Machines Corporation||Parallel apply processing in data replication with preservation of transaction integrity and source ordering of dependent updates|
|US8365193||Aug 12, 2004||Jan 29, 2013||Oracle International Corporation||Recoverable asynchronous message driven processing in a multi-node system|
|US8392387||Apr 2, 2012||Mar 5, 2013||International Business Machines Corporation||Asynchronous deletion of a range of messages processed by a parallel database replication apply process|
|US8412752||Nov 29, 2010||Apr 2, 2013||Qnx Software Systems Limited||File system having transaction record coalescing|
|US8417693||Jul 14, 2005||Apr 9, 2013||International Business Machines Corporation||Enforcing native access control to indexed documents|
|US8423373||Dec 18, 2009||Apr 16, 2013||Trading Technologies International, Inc.||System and method for coalescing market data at a client device|
|US8458127||Dec 28, 2007||Jun 4, 2013||Blue Coat Systems, Inc.||Application data synchronization|
|US8458530||Sep 21, 2010||Jun 4, 2013||Oracle International Corporation||Continuous system health indicator for managing computer system alerts|
|US8495319||Oct 31, 2011||Jul 23, 2013||Hitachi, Ltd.||Data processing system providing remote copy in a system having first, second and third storage systems and establishing first, second and third copy pairs|
|US8527478||Dec 20, 2010||Sep 3, 2013||Google Inc.||Handling bulk and incremental updates while maintaining consistency|
|US8538913||Sep 7, 2011||Sep 17, 2013||American Express Travel Related Services Company, Inc.||Test strategy system and method for accounts held direct at-fund|
|US8566284||Jul 20, 2012||Oct 22, 2013||Hitachi, Ltd.||Data replication among storage systems|
|US8566503||Mar 13, 2007||Oct 22, 2013||Qnx Software Systems Limited||Multimedia filesystem having unified representation of content on diverse multimedia devices|
|US8583541||Apr 19, 2012||Nov 12, 2013||Trading Technologies International, Inc.||System and method for providing market updates in an electronic trading environment|
|US8620862 *||Sep 13, 2010||Dec 31, 2013||Gravic, Inc.||Method for ensuring referential integrity in replication engines by serializing base level change queue data|
|US8630988||Dec 10, 2008||Jan 14, 2014||Verisign, Inc.||System and method for processing DNS queries|
|US8650169||Feb 10, 2003||Feb 11, 2014||Oracle International Corporation||Method and mechanism for identifying transaction on a row of data|
|US8655888||Dec 22, 2011||Feb 18, 2014||International Business Machines Corporation||Searching documents for ranges of numeric values|
|US8667029||Aug 30, 2011||Mar 4, 2014||Qnx Software Systems Limited||Optimized startup verification of file system integrity|
|US8688634||Feb 27, 2004||Apr 1, 2014||International Business Machines Corporation||Asynchronous peer-to-peer data replication|
|US8762257||Mar 13, 2013||Jun 24, 2014||Trading Technologies International, Inc||System and method for coalescing market data at a client device|
|US8832038||Mar 2, 2009||Sep 9, 2014||Oracle International Corporation||Online recovery of user tables using flashback table|
|US8868484||Jul 8, 2010||Oct 21, 2014||Oracle International Corporation||Efficiently updating rows in a data warehouse|
|US8918356||Nov 6, 2007||Dec 23, 2014||Siebel Systems, Inc||Method, apparatus and machine-readable medium for transforming, converting and processing messages between multiple systems|
|US8943025||Oct 21, 2013||Jan 27, 2015||Hitachi, Ltd.||Data replication among storage systems|
|US8959125||Jul 1, 2005||Feb 17, 2015||226008 Ontario Inc.||File system having inverted hierarchical structure|
|US9020887||Feb 8, 2005||Apr 28, 2015||Proofpoint, Inc.||Managing the status of documents in a distributed storage system|
|US9027025||Apr 17, 2007||May 5, 2015||Oracle International Corporation||Real-time database exception monitoring tool using instance eviction data|
|US9058305||Jun 28, 2012||Jun 16, 2015||Hitachi, Ltd.||Remote copy method and remote copy system|
|US20010005849 *||Feb 2, 2001||Jun 28, 2001||Puma Technology, Inc.||Synchronization of databases using filters|
|US20020007363 *||May 21, 2001||Jan 17, 2002||Lev Vaitzblit||System and method for transaction-selective rollback reconstruction of database objects|
|US20040098425 *||Sep 11, 2003||May 20, 2004||Sybase, Inc.||Database System Providing Improved Methods For Data Replication|
|US20040124892 *||Oct 7, 2003||Jul 1, 2004||Impinj, Inc., A Delaware Corporation||Use of analog-valued floating-gate transistors to match the electrical characteristics of interleaved and pipelined circuits|
|US20050038968 *||Oct 2, 2003||Feb 17, 2005||Takashige Iwamura||Multi-site remote-copy system|
|US20050049945 *||Aug 27, 2003||Mar 3, 2005||International Business Machines Corporation||Database log capture program that publishes transactions to multiple targets to handle unavailable targets by separating the publishing of subscriptions and subsequently recombining the publishing|
|US20050050083 *||Aug 25, 2003||Mar 3, 2005||International Business Machines Corporation||Method, system, and article of manufacture for processing updates to insert operations|
|US20050055523 *||Feb 23, 2004||Mar 10, 2005||Hitachi, Ltd.||Data processing system|
|US20050086193 *||Feb 4, 2004||Apr 21, 2005||American Express Travel Related Services Company, Inc.||Test strategy system and method for accounts held direct at-fund|
|US20050109695 *||Sep 30, 2004||May 26, 2005||Laurent Olivier||Autotrofic sulfur denitration chamber and calcium reactor|
|US20050114285 *||Nov 7, 2002||May 26, 2005||Cincotta Frank A.||Data replication system and method|
|US20050138048 *||Apr 12, 2004||Jun 23, 2005||Ki Sung Jin||XML database duplicating apparatus for copying XML document to remote server without loss of structure and attribute information of XML document and method thereof|
|US20050144538 *||Feb 1, 2005||Jun 30, 2005||Microsoft Corporation||System and method for replicating data in a distributed system|
|US20050165718 *||Jan 26, 2004||Jul 28, 2005||Fontoura Marcus F.||Pipelined architecture for global analysis and index building|
|US20050165781 *||Jan 26, 2004||Jul 28, 2005||Reiner Kraft||Method, system, and program for handling anchor text|
|US20050165800 *||Jan 26, 2004||Jul 28, 2005||Fontoura Marcus F.||Method, system, and program for handling redirects in a search engine|
|US20050165838 *||Jan 26, 2004||Jul 28, 2005||Fontoura Marcus F.||Architecture for an indexer|
|US20050193024 *||Feb 27, 2004||Sep 1, 2005||Beyer Kevin S.||Asynchronous peer-to-peer data replication|
|US20050222996 *||Mar 30, 2004||Oct 6, 2005||Oracle International Corporation||Managing event-condition-action rules in a database system|
|US20050223109 *||Feb 24, 2005||Oct 6, 2005||Ascential Software Corporation||Data integration through a services oriented architecture|
|US20050234969 *||Feb 24, 2005||Oct 20, 2005||Ascential Software Corporation||Services oriented architecture for handling metadata in a data integration platform|
|US20050235274 *||Feb 24, 2005||Oct 20, 2005||Ascential Software Corporation||Real time data integration for inventory management|
|US20050240354 *||Feb 24, 2005||Oct 27, 2005||Ascential Software Corporation||Service oriented architecture for an extract function in a data integration platform|
|US20050240633 *||Apr 23, 2004||Oct 27, 2005||Oracle International Corporation||Online recovery of user tables using flashback table|
|US20050251533 *||Mar 16, 2005||Nov 10, 2005||Ascential Software Corporation||Migrating data integration processes through use of externalized metadata representations|
|US20050262188 *||Feb 24, 2005||Nov 24, 2005||Ascential Software Corporation||Multiple service bindings for a real time data integration service|
|US20050262189 *||Feb 24, 2005||Nov 24, 2005||Ascential Software Corporation||Server-side application programming interface for a real time data integration service|
|US20050262192 *||Feb 24, 2005||Nov 24, 2005||Ascential Software Corporation||Service oriented architecture for a transformation function in a data integration platform|
|US20050262194 *||Feb 24, 2005||Nov 24, 2005||Ascential Software Corporation||User interface service for a services oriented architecture in a data integration platform|
|US20060031647 *||Sep 30, 2004||Feb 9, 2006||Hitachi, Ltd.||Storage system and data processing system|
|US20070185869 *||Mar 15, 2007||Aug 9, 2007||Alean Kirnak||Database networks including advanced replication schemes|
|US20100332448 *||Sep 13, 2010||Dec 30, 2010||Gravic, Inc.||Method for ensuring referential integrity in replication engines by resolving lock conflicts|
|US20120150829 *||Jun 14, 2012||International Business Machines Corporation||Asynchronous Deletion of a Range of Messages Processed by a Parallel Database Replication Apply Process|
|CN1610902B||Nov 1, 2002||May 5, 2010||弗里塞恩公司||Method and system for updating a remote database|
|CN102158550A *||Mar 3, 2011||Aug 17, 2011||河南电力试验研究院||IEC61850-based power quality transient data transmission method|
|CN102158550B||Mar 3, 2011||Apr 10, 2013||河南电力试验研究院||IEC61850-based power quality transient data transmission method|
|EP1172753A2 *||Jul 13, 2001||Jan 16, 2002||Kelvin Ackford||Method for optimising pharmatheutical prescribing|
|EP1180741A2 *||Aug 14, 2001||Feb 20, 2002||Rohm And Haas Company||Flexible system and method for standardizing communications and decision-making across multiple business processes|
|EP1494120A2||Apr 16, 2004||Jan 5, 2005||Hitachi, Ltd.||Data mirroring system using journal data|
|EP2724266A1 *||Jun 22, 2012||Apr 30, 2014||Alibaba Group Holding Limited||Extracting incremental data|
|WO2001061484A2 *||Feb 16, 2001||Aug 23, 2001||Xsides Corp||Method and system for controlling a complementary user interface on a display surface|
|WO2003038654A1 *||Nov 1, 2002||May 8, 2003||Verisign Inc||Method and system for updating a remote database|
|WO2003044697A1 *||Nov 7, 2002||May 30, 2003||Paralleldb Inc||Data replication system and method|
|U.S. Classification||1/1, 707/999.201, 707/999.202, 707/999.01|
|Cooperative Classification||G06F17/30578, Y10S707/99953, Y10S707/99952|
|Jul 23, 1996||AS||Assignment|
Owner name: PEREGRINE BRIDGE TRANSFER CORPORATION, TEXAS
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:OLSON, JACK E.;PRICE, THOMAS G.;REEL/FRAME:008155/0256
Effective date: 19960723
|Apr 3, 2000||AS||Assignment|
|Jun 29, 2000||AS||Assignment|
|Oct 16, 2000||AS||Assignment|
|Dec 5, 2000||AS||Assignment|
|Jun 18, 2003||REMI||Maintenance fee reminder mailed|
|Oct 28, 2003||SULP||Surcharge for late payment|
|Oct 28, 2003||FPAY||Fee payment|
Year of fee payment: 4
|Dec 26, 2005||AS||Assignment|
|Jun 18, 2007||REMI||Maintenance fee reminder mailed|
|Nov 30, 2007||LAPS||Lapse for failure to pay maintenance fees|
|Jan 22, 2008||FP||Expired due to failure to pay maintenance fee|
Effective date: 20071130