US20200159850A1 - Data replication conflict processing after structural changes to a database - Google Patents

Data replication conflict processing after structural changes to a database Download PDF

Info

Publication number
US20200159850A1
US20200159850A1 US16/193,776 US201816193776A US2020159850A1 US 20200159850 A1 US20200159850 A1 US 20200159850A1 US 201816193776 A US201816193776 A US 201816193776A US 2020159850 A1 US2020159850 A1 US 2020159850A1
Authority
US
United States
Prior art keywords
database
change
data
conflict
database record
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
US16/193,776
Other versions
US11204940B2 (en
Inventor
Gregg A. Upton
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
International Business Machines Corp
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 International Business Machines Corp filed Critical International Business Machines Corp
Priority to US16/193,776 priority Critical patent/US11204940B2/en
Publication of US20200159850A1 publication Critical patent/US20200159850A1/en
Application granted granted Critical
Publication of US11204940B2 publication Critical patent/US11204940B2/en
Active legal-status Critical Current
Adjusted expiration legal-status Critical

Links

Images

Classifications

    • G06F17/30575
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • G06F17/30371

Definitions

  • Example non-relational database systems include the IBM Information Management System (IMS) and the IBM Virtual Storage Access Method (VSAM), both offered by International Business Machines Corporation, Armonk, N.Y., USA.
  • IMS IBM Information Management System
  • VSAM IBM Virtual Storage Access Method
  • Operational system requirements typically mandate near-continuous availability, however the rate of change to stay competitive and/or compliant can necessitate relatively frequent changes to the databases/files where the operational data is stored.
  • the data stores tend to be extremely large due to the scale of these operations. Consequently, when there is a need or desire to change these databases, for instance to add additional information, the process can take time and render the applications that access this data temporarily inoperable.
  • applications that access/update IMS data typically have visibility to all of the data in an IMS database record (a “segment” in IMS terminology).
  • applications that access/update VSAM data see the entire contents of the database record (“record” in VSAM terminology) stored in the file.
  • the database/file is usually unloaded, updated, and then reloaded after the database/file has been updated. The reload may be done using a custom application that formats the new data, or possibly a vendor-supplied utility, depending on the change being made.
  • Changes other than or in addition to changing the size of an existing segment can be made in the case of an IMS database.
  • An example change may be to add new child segment(s) to the database. It is also possible to delete an existing segment and/or change existing parent child relationships.
  • the method identifies a structural change made to a database record of a database at a target site.
  • the method recognizes, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site.
  • the method also performs conflict processing.
  • the conflict processing includes applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site.
  • a computer system includes a memory and a processor in communication with the memory.
  • the computer system is configured to perform a method.
  • the method identifies a structural change made to a database record of a database at a target site.
  • the method recognizes, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site.
  • the method also performs conflict processing.
  • the conflict processing includes applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site.
  • a computer program product including a computer readable storage medium readable by a processing circuit and storing instructions for execution by the processing circuit is provided for performing a method.
  • the method identifies a structural change made to a database record of a database at a target site.
  • the method recognizes, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site.
  • the method also performs conflict processing.
  • the conflict processing includes applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site.
  • the database is a non-relational database. This has an advantage in that it provides a way to gracefully handle cases where structural changes are made to records of the non-relational database, without significant downtime or critical data replication errors.
  • the structural change can include a change in a length of the database record, for instance to increase the length of the record.
  • Supporting such a structural change has an advantage in that database records can be increased (or decreased) in length as desired, and the resulting data replication conflicts are handled automatically.
  • the replication operation is (i) an insert of the change data or (ii) an update, using the change data, of current data image data of the database record.
  • the process also includes unloading the database, performing the structural change to the database record, and reloading the database.
  • the identifying the structural change can be performed based on reloading the database.
  • the process can also include providing an indication of the structural change in metadata about the database, where the identifying the structural change is based on the provided indication. This has an advantage in that identifying when structural changes occurred enables the conflict processing to be called accordingly.
  • Applying the modification(s) can include, for instance, applying custom formatting to the change data to produce a result, and the process can write the result into the structurally-change database record.
  • Applying custom formatting has an advantage in that it enables the conflict to be resolved by properly formatting the change data for the implemented database change at the target, thereby resolving the conflict.
  • FIG. 1 depicts an example environment to incorporate and use aspects described herein;
  • FIG. 2 depicts an example process for data replication conflict processing after a structural change to a database record, in accordance with aspects described herein;
  • FIG. 3 depicts example conflict processing, in accordance with aspects described herein;
  • FIG. 4 depicts one example of a computer system and associated devices to incorporate and/or use aspects described herein;
  • FIG. 5 depicts a cloud computing environment according to embodiments described herein.
  • FIG. 6 depicts abstraction model layers according to embodiments described herein.
  • Described herein are approaches for conflict processing, for instance to resolve conflicts arising during a data replication process to replicate database changes from a source to a target.
  • approaches for conflict processing for instance to resolve conflicts arising during a data replication process to replicate database changes from a source to a target.
  • Conflict processing in accordance with aspects described herein can support replication processes even after structural changes have been made to database records at the target receiving the replication changes. This is the case even though the changes to be replicated from the source were made against records having a different (i.e. pre-structural change) record structure.
  • Example database/file change processing is performed by a data replication solution operating in an active/standby environment.
  • An active/standby deployment that utilizes software data replication during the transition process to the stand-in/standby site and upon return to the main/active site can reduce application unavailability time and make the change process less risky.
  • the main site databases can be upgraded. Once the upgrade is complete, and during the transition of operations back to the main site, the application workload-provided changes made to the database at the standby site are integrated with the new layout of the target database, for instance using a custom-developed conflict handling exit implemented by the organization and supported by the data replication software.
  • FIG. 1 depicts an example environment to incorporate and use aspects described herein.
  • the environment 100 is a site transition replication environment, in which a main site 102 and stand-in (or “standby”) site 104 are located remote from each other and are in communication across one or more networks, represented by the double-sided arrow between the two sites in FIG. 1 .
  • the main site 102 includes an IMS subsystem 104 for IMS database 106 , i.e. a non-relational database having database records (“segments”) 108 a , 108 b that are stored within the database container/structure 106 .
  • IMS database 106 i.e. a non-relational database having database records (“segments”) 108 a , 108 b that are stored within the database container/structure 106 .
  • Main site server 109 is a server (hardware and/or software) that executes data replication (DR) software to replicate changes made to the main site database records over to the stand-in site and vice versa.
  • DR software can support ‘conflict exit’ processing, in which processing is called to resolve an apparent conflict during an apply process to apply changes made to one site database to a database at another site.
  • Stand-in site 104 also includes an IMS subsystem 110 for IMS database 112 having segments 114 a , 114 b that are stored within the database container/structure 112 .
  • Stand-in site server 116 is a server (hardware and/or software) that executes data replication (DR) software used in the replication of changes made to the main site database records over to the stand-in site and vice versa.
  • DR data replication
  • Workload distributor 120 is responsible for distributing workload (for instance workload of applications) to the sites 102 , 104 .
  • Main site 102 is termed as such since it is the main site to which workload is directed.
  • Workload can effect desired deletions, inserts, and changes/updates to data in the database.
  • applications may not directly access the database ( 106 ) but rather use, e.g., IMS API calls that are routed through the IMS software 104 that is responsible for updating the actual database 106 . Changes applied to the database 106 at the main site can be replicated to the stand-in site in case of a failover or other situation.
  • incoming workload is typically routed to the main site 102 where the IMS replication source server 103 is running.
  • source database 106 As changes are made to source database 106 , they are replicated via servers 109 and 116 to the stand-in site 104 , where the changes are applied to the target database 112 .
  • the source and target IMS databases are initially structurally identical. However, it may be desired to upgrade the main IMS database 106 to make structural changes thereto.
  • the stand-in site 104 stands-in for the main 102 while the change(s) are made to the main site database. Thus, a transition to the stand-in site is effected, the main site is upgraded, and then a transition is made back to the main site.
  • the first is on the transition to the standby site 104 .
  • the applications driving the workload are quiesced at the main site 102 and, once the latest updates are replicated to the standby site 104 , the applications become available again with traffic now being routed (by the workflow distributor 120 ) to the standby site 104 .
  • the second application outage is on the transition back to the main site 102 .
  • Data replication has applied changes, made at the standby site 104 , to the upgraded database(s) at the main site 102 , and the applications are again quiesced, this time at the standby site.
  • the workload distributor After quiescing and once the latest changes made at the standby site 104 are replicated back to the main site 102 , the workload distributor again routes traffic to the main site 102 .
  • Conflict processing such as a “conflict exit” can be called in the data replication process to resolve inconsistencies found between the source and target databases during change apply processing.
  • a conflict exit is called only when there is a difference/inconsistency detected for a specific change operation.
  • custom conflict processing is provided and used in cases where structural changes are made to database records at a target (e.g. main) site that is to receive updates from a source (e.g. stand-in) site having the initial structure of the database records.
  • the conflict processing can modify segment/file contents of changes made at a source (e.g. a standby) site to match upgraded database/files layout at a target (e.g. the main) site.
  • the custom processing can be applied assuming that the data replication product supports the use of conflict processing to resolve inconsistencies found between the source and target databases during the apply process and allows the source/target database/files layouts to be different.
  • the conflict processing is enabled (e.g. ‘installed’)
  • the conflict processing can be called to resolve the ‘inconsistency’ for any operation to apply a change to a database record that has been structurally changed at the target.
  • the ‘source’ can refer to the standby site to which workload had been temporarily routed and therefore data inserts, updates, etc. are being made to the database at the source, though changes could flow from any desired source site.
  • the target refers in example presented herein to the main site away from which the workload has been temporarily redirected to the standby site, though changes could flow to any desired target site.
  • Database record(s) at the target (main site) undergo desired structural change(s).
  • An example structural change is a change in the size of a database record (e.g. IMS segment and/or VSAM record), for instance to increase the size of the database record. After the structural change(s) are made, the workload is again to be directed to the main site.
  • Structural changes made to the application database/files in examples described herein include increasing the length of a segment/record.
  • aspects enable more radical changes, such data reformatting, to be supported in situations where the data replication product allows the conflict exit to be called on the relevant change operations, e.g., insert operations.
  • the main site systems can be taken offline once the workload has transferred to the standby site.
  • the database (and any applicable application) upgrade process can begin at the main site. This process can take as long as necessary, with the main site systems being brought back up once the upgrade process is complete.
  • catch-up processing can begin.
  • the changes that were made at the standby site (the “source”) via workload requests start to flow to the main site (the “target”) via the DR processing.
  • conflict processing receives control at the appropriate times, for instance when during a change operation a mismatch is detected between the structure of the change data (from the source) and the database record at the target.
  • the conflict processing performs the appropriate structural transformation(s), etc. on the change data in order to for that data to be stored into the upgraded main site databases/files (database records).
  • an expectation is that replication runs long enough to take the changes made at the source/standby site (to database records with the initial structural format) and apply them using a custom conflict exit to the database at the target/main site, and more specifically to database records that were changed from the initial structural format to the new structural format.
  • the organization can cease allowing changes to be made at the source site, e.g. by quiescing the applications submitting workload requests.
  • operations are resumed (the applications are no longer quiesced) and the workload is routed to the target site with the upgraded database. After this, replication (from source to target) can be stopped, if desired.
  • traffic is being routed to the source site until replication is caught up.
  • the site may be disabled temporarily while the last changes are applied at the target/main site. Once that occurs, the target/main site is brought back up in the sense that a transition is made back to the target site and traffic is again routed to the target site having the structurally-changed database records, for instance of a new record length.
  • the target/main site contains all the changes that occurred when the unload/reload was performed at the main site, and the business continues to operate with a relatively limited outage. In some situations, the organization may not have even announced the site transition, and any end users who experienced slow response time may have been inconvenienced only in that they had to retry/resubmit their request if the site did not respond immediately to their initial request.
  • structural change(s) are made to database records at the target site.
  • the database at the target can be unloaded, the structural change(s) is/are made to database records of the unloaded database by an administrator or automatically, then the database is reloaded.
  • Metadata describing properties of that database can indicate/identify that a structural change has been made.
  • the metadata about the database can be refreshed/reloaded, for example, after the upgrade, such that the new version of the metadata provides an indication of the new structure and/or the structural change. This can be used to identify the structural change(s) actually made, for instance that a record was expanded in length from 80 bytes to 160 bytes.
  • the replication software can use this metadata to identify the structural change.
  • the process can identify the difference in the metadata between the source and target, and therefore identify the structural change.
  • the replication software can, for instance, query the metadata about database record(s) and discover that the source record structure and target record structure are not the same, and this can be used to trigger conflict processing, for instance a call to a conflict exit as described herein, at the target site.
  • the main site version of the database/file and the standby version of the database/file being upgraded are consistent, and the only conflicts that are detected are due to the database record upgrade process at the main site, since those databases/files are offline and not then being updated by the workload-producing applications.
  • This allows the organization to develop custom logic for the databases/files being upgraded that allows the changes made at the standby site to be properly reintegrated at the main site.
  • the conflict exit or other conflict processing can be configured for the replication software by setting configuration parameter(s), for instance one that identifies the name of the conflict exit and another to activate detecting and calling the exit when there are metadata conflicts, e.g. when the length of the source record is different from the length of the target record.
  • code for execution to perform the conflict processing is copied (installed) into a library to which the apply software, which may be part of the data replication software, has access, so that is can be loaded and called when appropriate.
  • aspects can install, with a data replication process at the target site, a call to the conflict processing that is to be invoked based on recognizing the conflict in a replication operation.
  • Recognition of the conflict can be based on recognizing an inconsistency between a structure (such as a length) of the change data flowing from the source and the structurally-changed database record at the target.
  • the standby site can be taken offline once workload transitions back to the main site.
  • the structural changes made at the target site can also be made to the standby version of the database/files (database records) to harmonize the structure of the database at the source with that of the upgraded target.
  • a transition operation between the two sites may not be possible without potentially massive data loss.
  • this exposure can be mitigated using any desired approach.
  • One such approach is to use a combination of flash copy back-ups and disk mirroring to reduce downtime in case of a disaster or major operational mistake during the upgrade process.
  • a third site, system, logical partition, the system at the main site itself, and/or an alternative volume at the standby site can be spawned and populated with the newest version of the database (from the main site) as a disaster recovery option.
  • Specific classes of conflicts that may exist between a source/target object in a replication operation between a source and target object in a replication environment include:
  • the target is where the conflict exit resides, meaning the conflict exit processing can be performed at the target where the updated database having the structurally-changed database records resides.
  • the source is where the original database/file resides.
  • the application workload can be executing at the standby site using the original database/file definitions, the main site may be operational though application workload is not running at the main site, and the database/files have gone through their upgrade process.
  • the main site applications may be, or have been, modified to access the new versions of the database/file (i.e. the structurally changed database records), the application environment (IMS/CICS) may have been updated to reference/use the upgraded database/file, including the data replication product, and the data replication product is executing at both sites with replication possible from the standby site to the main site.
  • aspects can support the relatively common type of structural change of increasing the maximum length of a segment or record, though a size change to decrease the maximum length of a segment or record is also possible.
  • the way a length change is handled may be different depending upon whether the existing layout has a fixed or variable length and whether, as part of the upgrade process, data formatting is required for the updated applications to function properly.
  • An initial assumption is that the data replication software is aware of the segment/record length differences between the source and target, which in some embodiments is the signal/trigger for the apply process to call the conflict exit.
  • the new data (the change data received from the source) is to be formatted with something.
  • the applications have been designed to deal with new data that contains spaces or binary zeros, as one possibility.
  • Another possibility is that, as part of the upgrade, the new data has custom formatting applied to it.
  • An example structural change is an increase in the size of the segment/record from 80 bytes to 160 bytes, and the new data is to be formatted with custom values.
  • the conflict exit is driven, as the before image (at 80 bytes) and after image (at 160 bytes) cannot possibly match as indicated by the differences in the length of the data between the source and the target definitions.
  • the conflict exit in these situations can identify what the apply process is to perform. Options include, as examples, a ‘force apply’ (update the target database), ignore the change, or stop replication.
  • the conflict exit can contain logic for any custom code to transform the older (source) data into the new format.
  • modification(s) can be applied to the change data that the source site has or will send to the target site. Applying the modification(s) can include applying custom formatting to the change data to produce a result that is written into the structurally-changed database record. In this type of example where modification(s) are made, the exit requests a force operation.
  • the conflict exit can be called when there is a difference/inconsistency detected and recognized for a specific operation, such as an update or insert operation.
  • a structural change made to the database record of the database at a target site is identified.
  • example ‘database records’ are “segments” of an IMS database or “records” of a VSAM database.
  • a structural change can include a change in a length of the database record, for instance to increase its length. Recognizing that a conflict is present can include recognizing a difference in length between the change data and the database record that has been structurally changed as part of a database upgrade.
  • a call to the conflict processing can be signaled based on recognizing that structural change when a replication operation (e.g.
  • the conflict processing is called to resolve the ‘inconsistency’ for these operation(s) against a database record that has been structurally changed.
  • the conflict exit can be driven based on observing a difference (conflict) in the metadata for the database record between the source and target, e.g. the record length is 80 bytes at the source and 160 bytes at the target. Therefore, in some instances, the particular structural change can be inferred based on what is indicated by the metadata.
  • the conflict exit is called, e.g. based on detecting a metadata conflict in performing a replication operation, because the source and target record links are different.
  • the conflict exit can confirm that the first 80 bytes of the target match the source, and allow the delete to proceed.
  • the same confirmation process can occur except then the conflict exit moves the last 80 bytes of the “new” target data into the target after image buffer.
  • the 80-byte data is received from the source by the target and written in the first 80 bytes of the after image buffer, which is actually to be 160 bytes based on the structural change to the database record at the target from 80 to 160 bytes.
  • the last 80 bytes of the target ‘before image’ (the 160-byte data of the structurally changed database record) are then written into the last 80 byes of the target after image buffer.
  • the ‘upsert’ operation can then be requested. This is one example of applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site.
  • a realistic assumption is that the conflict exit has access to the source before and after images, the current data image at the target, and can update the contents of the after image before it is applied to the target database/file.
  • the conflict exit is to be called when a source insert operation is detected for an object that has been upgraded and the replication software is to be able to detect when it has an insert with only 80 bytes of data, yet the target definition says it should be 160 bytes. How the replication software decides to indicate this condition to the conflict exit may be implementation defined. When informed that the object lengths are inconsistent for an insert operation, the conflict exit can identify the object and perform any required data formatting before returning control and informing the apply logic to go ahead and insert the data at the target. Conflict processing could therefore be called relatively frequently.
  • the data replication software may not initially consider inconsistencies in length between the source and target as a reason to drive the conflict exit. So, while it may be possible to detect that there exists an inconsistency, it may be likely (but not a requirement) that the data replication product supports some method for an administrator, or a conflict exit, to indicate that the conflict exit should be called for insert operations when there are inconsistencies between the source/target databases/files.
  • Variable length segments/records may have similar behavior or requirements depending on the change and how the applications deal with variable length objects. If the upgrade just increases the maximum size of the segment/record and does not perform any preformatting, then there may be no need for a conflict exit to be involved since the source/target should be consistent. However, if the minimum length is increased and is now larger than the actual size of the source, then the conflict exit may be driven for delete/update operations because the source/target will not match structurally, and driven for inserts with the behavior described above.
  • delete and update operations can drive the conflict exit, and, for updates, the conflict exit can integrate the source data with the preformatted target data using the larger target segment/record length for the update operation.
  • the database/file does not require any structural changes, the application has enough space available and just wants or needs to reuse or recondition the data. For delete and update operations, differences due to the reconditioning could be detected and the exit could re-condition the standby data for update operations before requesting the update operation proceed.
  • the replication software is to become aware that the conflict exit is to be called for at least certain kinds of insert operations. This can be accomplished, as one example, by allowing the conflict exit to request this form of processing or by the replication software supporting a configuration parameter or command requesting this form of special processing. Given the custom nature of the conflict exit and the length of time is may be deployed, using a “call exit on insert” indicator may be all that is required, as opposed to an explicit identification of the objects that require this special processing. However, flexibility in this solution may be implementation-dependent. The above approach could also satisfy other use cases described above where the replication does not detect that there are inconsistencies between the source/target, or whether the difference (inconsistencies) may not warrant calling the conflict exit to resolve.
  • FIG. 2 depicts an example process for data replication conflict processing after a structural change to a database record, in accordance with aspects described herein.
  • the process is performed by one or more computer systems, such as those described herein, which may include one or more computer systems of a target site and/or one or more other computer systems.
  • the process is performed by a computer system running data replication software at the target site to facilitate data replication from the source site to the target site.
  • the process installs (registers and/or configures) ( 202 ), in or with a data replication process at a target site, a call to conflict processing.
  • the call is to be invoked during replication processing based on recognizing certain conflicts in replication operations.
  • the process identifies ( 204 ) a structural change made to a database record of a database at the target site, and recognizes ( 206 ), based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site.
  • the change data is source after image data, for instance, sent from the source site to the target site.
  • Example replication operations include insert, update, and delete operations.
  • the recognizing can be based on recognizing an inconsistency between a structure of the change data and the structurally-changed database record, for instance.
  • the process signals ( 208 ) a call to the conflict processing based on recognizing the change.
  • the process continues by performing ( 210 ) the conflict processing, for instance by way of executing code of a called conflict exit. Performing the conflict processing can generate a result, which the process of FIG. 2 writes ( 212 ) into the structurally-changed database record.
  • the process of FIG. 2 has an advantage in that it provides approaches to reduce application unavailability when making database/file structural changes, by utilizing a software replication conflict exit deployed in an active/standby configuration.
  • the database is a non-relational database, and the process advantageously provides a way to gracefully handle cases where structural changes are made to records of the non-relational database, without significant downtime or critical data replication errors.
  • the database record is or includes a segment of the database (e.g. an IMS segment) or a VSAM record.
  • the structural change is, for instance, a change in a length of the database record, such as an increase in the length of the record.
  • Supporting such a structural change has an advantage in that database records can be increased (or decreased) in length as desired, and the resulting data replication conflicts are handled automatically.
  • Recognizing the conflict ( 206 of FIG. 2 ) can include recognizing a difference in length between the change data and the database record, and the signaling ( 208 ) can be performed based on recognizing that difference in length.
  • the replication operation is (i) an insert of the change data or (ii) an update, using the change data, of current data image data of the database record.
  • the process also includes unloading the database, performing the structural change to the database record (and potentially many other records), and reloading the database.
  • the identifying the structural change can be performed based on reloading the database and on resulting metadata about the changed database.
  • the process can also include providing an indication of the structural change in metadata about the database, where the identifying the structural change is based on the provided indication. This has an advantage in that identifying when structural changes occurred enables the conflict processing to be called accordingly.
  • FIG. 3 depicts example conflict processing, in accordance with aspects described herein.
  • the process can be performed by one or more computer systems, such as those described herein, which may include one or more computer systems of a target site and/or one or more other computer systems.
  • the process is performed by the computer system(s) that performs the process of FIG. 2 .
  • the conflict processing may be a configured ‘conflict exit’ of data replication software.
  • the conflict processing obtains ( 302 ) the change data passed from the source and applies ( 304 ) one or more modifications to the change data to comport with the structural change made to the database record of the database at the target site. Applying the one or more modifications can include, for instance, applying custom formatting to the change data to produce a result. Applying custom formatting has an advantage in that it enables the conflict to be resolved by properly formatting the change data for the implemented database change at the target, thereby resolving the conflict.
  • the conflict processing makes the changes to produce an output/result.
  • the process provides ( 306 ) the result to the apply process, for instance writes it to a buffer, sends, or otherwise makes it available/accessible to the apply processing of the replication processing.
  • the process signals/triggers ( 308 ) the apply process. In some examples, this is merely the conflict processing breaking/returning back to the calling process, perhaps passing an appropriate return value. In some examples, there is a flag or other signal issued by the signaling ( 308 ). When the apply processing resumes, it can apply the result of the conflict processing to the target image.
  • FIG. 4 depicts one example of such a computer system and associated devices to incorporate and/or use aspects described herein.
  • a computer system may also be referred to herein as a data processing device/system, computing device/system/node, or simply a computer.
  • the computer system may be based on one or more of various system architectures and/or instruction set architectures, such as those offered by International Business Machines Corporation (Armonk, N.Y., USA), Intel Corporation (Santa Clara, Calif., USA) or ARM Holdings plc (Cambridge, England, United Kingdom), as examples.
  • FIG. 4 shows a computer system 400 in communication with external device(s) 412 .
  • Computer system 400 includes one or more processor(s) 402 , for instance central processing unit(s) (CPUs).
  • a processor can include functional components used in the execution of instructions, such as functional components to fetch program instructions from locations such as cache or main memory, decode program instructions, and execute program instructions, access memory for instruction execution, and write results of the executed instructions.
  • a processor 402 can also include register(s) to be used by one or more of the functional components.
  • Computer system 400 also includes memory 404 , input/output (I/O) devices 408 , and I/O interfaces 410 , which may be coupled to processor(s) 402 and each other via one or more buses and/or other connections.
  • I/O input/output
  • Bus connections represent one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures.
  • bus architectures include the Industry Standard Architecture (ISA), the Micro Channel Architecture (MCA), the Enhanced ISA (EISA), the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI).
  • Memory 404 can be or include main or system memory (e.g. Random Access Memory) used in the execution of program instructions, storage device(s) such as hard drive(s), flash media, or optical media as examples, and/or cache memory, as examples.
  • Memory 404 can include, for instance, a cache, such as a shared cache, which may be coupled to local caches (examples include L1 cache, L2 cache, etc.) of processor(s) 402 .
  • memory 404 may be or include at least one computer program product having a set (e.g., at least one) of program modules, instructions, code or the like that is/are configured to carry out functions of embodiments described herein when executed by one or more processors.
  • Memory 404 can store an operating system 405 and other computer programs 406 , such as one or more computer programs/applications that execute to perform aspects described herein.
  • programs/applications can include computer readable program instructions that may be configured to carry out functions of embodiments of aspects described herein.
  • I/O devices 408 include but are not limited to microphones, speakers, Global Positioning System (GPS) devices, cameras, lights, accelerometers, gyroscopes, magnetometers, sensor devices configured to sense light, proximity, heart rate, body and/or ambient temperature, blood pressure, and/or skin resistance, and activity monitors.
  • GPS Global Positioning System
  • An I/O device may be incorporated into the computer system as shown, though in some embodiments an I/O device may be regarded as an external device ( 412 ) coupled to the computer system through one or more I/O interfaces 410 .
  • Computer system 400 may communicate with one or more external devices 412 via one or more I/O interfaces 410 .
  • Example external devices include a keyboard, a pointing device, a display, and/or any other devices that enable a user to interact with computer system 400 .
  • Other example external devices include any device that enables computer system 400 to communicate with one or more other computing systems or peripheral devices such as a printer.
  • a network interface/adapter is an example I/O interface that enables computer system 400 to communicate with one or more networks, such as a local area network (LAN), a general wide area network (WAN), and/or a public network (e.g., the Internet), providing communication with other computing devices or systems, storage devices, or the like.
  • LAN local area network
  • WAN wide area network
  • public network e.g., the Internet
  • Ethernet-based (such as Wi-Fi) interfaces and Bluetooth® adapters are just examples of the currently available types of network adapters used in computer systems (BLUETOOTH is a registered trademark of Bluetooth SIG, Inc., Kirkland, Wash., U.S.A.).
  • the communication between I/O interfaces 410 and external devices 412 can occur across wired and/or wireless communications link(s) 411 , such as Ethernet-based wired or wireless connections.
  • Example wireless connections include cellular, Wi-Fi, Bluetooth®, proximity-based, near-field, or other types of wireless connections. More generally, communications link(s) 411 may be any appropriate wireless and/or wired communication link(s) for communicating data.
  • Particular external device(s) 412 may include one or more data storage devices, which may store one or more programs, one or more computer readable program instructions, and/or data, etc.
  • Computer system 400 may include and/or be coupled to and in communication with (e.g. as an external device of the computer system) removable/non-removable, volatile/non-volatile computer system storage media.
  • a non-removable, non-volatile magnetic media typically called a “hard drive”
  • a magnetic disk drive for reading from and writing to a removable, non-volatile magnetic disk (e.g., a “floppy disk”)
  • an optical disk drive for reading from or writing to a removable, non-volatile optical disk, such as a CD-ROM, DVD-ROM or other optical media.
  • Computer system 400 may be operational with numerous other general purpose or special purpose computing system environments or configurations.
  • Computer system 400 may take any of various forms, well-known examples of which include, but are not limited to, personal computer (PC) system(s), server computer system(s), such as messaging server(s), thin client(s), thick client(s), workstation(s), laptop(s), handheld device(s), mobile device(s)/computer(s) such as smartphone(s), tablet(s), and wearable device(s), multiprocessor system(s), microprocessor-based system(s), telephony device(s), network appliance(s) (such as edge appliance(s)), virtualization device(s), storage controller(s), set top box(es), programmable consumer electronic(s), network PC(s), minicomputer system(s), mainframe computer system(s), and distributed cloud computing environment(s) that include any of the above systems or devices, and the like.
  • PC personal computer
  • server computer system(s) such as messaging server(s), thin client(s), thick client(s),
  • Cloud computing is a model of service delivery for enabling convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, network bandwidth, servers, processing, memory, storage, applications, virtual machines, and services) that can be rapidly provisioned and released with minimal management effort or interaction with a provider of the service.
  • This cloud model may include at least five characteristics, at least three service models, and at least four deployment models.
  • On-demand self-service a cloud consumer can unilaterally provision computing capabilities, such as server time and network storage, as needed automatically without requiring human interaction with the service's provider.
  • Resource pooling the provider's computing resources are pooled to serve multiple consumers using a multi-tenant model, with different physical and virtual resources dynamically assigned and reassigned according to demand. There is a sense of location independence in that the consumer generally has no control or knowledge over the exact location of the provided resources but may be able to specify location at a higher level of abstraction (e.g., country, state, or datacenter).
  • Rapid elasticity capabilities can be rapidly and elastically provisioned, in some cases automatically, to quickly scale out and rapidly released to quickly scale in. To the consumer, the capabilities available for provisioning often appear to be unlimited and can be purchased in any quantity at any time.
  • Measured service cloud systems automatically control and optimize resource use by leveraging a metering capability at some level of abstraction appropriate to the type of service (e.g., storage, processing, bandwidth, and active user accounts). Resource usage can be monitored, controlled, and reported, providing transparency for both the provider and consumer of the utilized service.
  • level of abstraction appropriate to the type of service (e.g., storage, processing, bandwidth, and active user accounts).
  • SaaS Software as a Service: the capability provided to the consumer is to use the provider's applications running on a cloud infrastructure.
  • the applications are accessible from various client devices through a thin client interface such as a web browser (e.g., web-based e-mail).
  • a web browser e.g., web-based e-mail
  • the consumer does not manage or control the underlying cloud infrastructure including network, servers, operating systems, storage, or even individual application capabilities, with the possible exception of limited user-specific application configuration settings.
  • PaaS Platform as a Service
  • the consumer does not manage or control the underlying cloud infrastructure including networks, servers, operating systems, or storage, but has control over the deployed applications and possibly application hosting environment configurations.
  • IaaS Infrastructure as a Service
  • the consumer does not manage or control the underlying cloud infrastructure but has control over operating systems, storage, deployed applications, and possibly limited control of select networking components (e.g., host firewalls).
  • Private cloud the cloud infrastructure is operated solely for an organization. It may be managed by the organization or a third party and may exist on-premises or off-premises.
  • Public cloud the cloud infrastructure is made available to the general public or a large industry group and is owned by an organization selling cloud services.
  • Hybrid cloud the cloud infrastructure is a composition of two or more clouds (private, community, or public) that remain unique entities but are bound together by standardized or proprietary technology that enables data and application portability (e.g., cloud bursting for load-balancing between clouds).
  • a cloud computing environment is service oriented with a focus on statelessness, low coupling, modularity, and semantic interoperability.
  • An infrastructure that includes a network of interconnected nodes.
  • cloud computing environment 50 includes one or more cloud computing nodes 10 with which local computing devices used by cloud consumers, such as, for example, personal digital assistant (PDA) or cellular telephone 54 A, desktop computer 54 B, laptop computer 54 C, and/or automobile computer system 54 N may communicate.
  • Nodes 10 may communicate with one another. They may be grouped (not shown) physically or virtually, in one or more networks, such as Private, Community, Public, or Hybrid clouds as described hereinabove, or a combination thereof.
  • This allows cloud computing environment 50 to offer infrastructure, platforms and/or software as services for which a cloud consumer does not need to maintain resources on a local computing device.
  • computing devices 54 A-N shown in FIG. 5 are intended to be illustrative only and that computing nodes 10 and cloud computing environment 50 can communicate with any type of computerized device over any type of network and/or network addressable connection (e.g., using a web browser).
  • FIG. 6 a set of functional abstraction layers provided by cloud computing environment 50 ( FIG. 5 ) is shown. It should be understood in advance that the components, layers, and functions shown in FIG. 6 are intended to be illustrative only and embodiments of the invention are not limited thereto. As depicted, the following layers and corresponding functions are provided:
  • Hardware and software layer 60 includes hardware and software components.
  • hardware components include: mainframes 61 ; RISC (Reduced Instruction Set Computer) architecture based servers 62 ; servers 63 ; blade servers 64 ; storage devices 65 ; and networks and networking components 66 .
  • software components include network application server software 67 and database software 68 .
  • Virtualization layer 70 provides an abstraction layer from which the following examples of virtual entities may be provided: virtual servers 71 ; virtual storage 72 ; virtual networks 73 , including virtual private networks; virtual applications and operating systems 74 ; and virtual clients 75 .
  • management layer 80 may provide the functions described below.
  • Resource provisioning 81 provides dynamic procurement of computing resources and other resources that are utilized to perform tasks within the cloud computing environment.
  • Metering and Pricing 82 provide cost tracking as resources are utilized within the cloud computing environment, and billing or invoicing for consumption of these resources. In one example, these resources may include application software licenses.
  • Security provides identity verification for cloud consumers and tasks, as well as protection for data and other resources.
  • User portal 83 provides access to the cloud computing environment for consumers and system administrators.
  • Service level management 84 provides cloud computing resource allocation and management such that required service levels are met.
  • Service Level Agreement (SLA) planning and fulfillment 85 provide pre-arrangement for, and procurement of, cloud computing resources for which a future requirement is anticipated in accordance with an SLA.
  • SLA Service Level Agreement
  • Workloads layer 90 provides examples of functionality for which the cloud computing environment may be utilized. Examples of workloads and functions which may be provided from this layer include: mapping and navigation 91 ; software development and lifecycle management 92 ; virtual classroom education delivery 93 ; data analytics processing 94 ; transaction processing 95 ; and conflict processing 96 .
  • the present invention may be a system, a method, and/or a computer program product at any possible technical detail level of integration
  • the computer program product may include a computer readable storage medium (or media) having computer readable program instructions thereon for causing a processor to carry out aspects of the present invention
  • the computer readable storage medium can be a tangible device that can retain and store instructions for use by an instruction execution device.
  • the computer readable storage medium may be, for example, but is not limited to, an electronic storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing.
  • a non-exhaustive list of more specific examples of the computer readable storage medium includes the following: a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), a static random access memory (SRAM), a portable compact disc read-only memory (CD-ROM), a digital versatile disk (DVD), a memory stick, a floppy disk, a mechanically encoded device such as punch-cards or raised structures in a groove having instructions recorded thereon, and any suitable combination of the foregoing.
  • RAM random access memory
  • ROM read-only memory
  • EPROM or Flash memory erasable programmable read-only memory
  • SRAM static random access memory
  • CD-ROM compact disc read-only memory
  • DVD digital versatile disk
  • memory stick a floppy disk
  • a mechanically encoded device such as punch-cards or raised structures in a groove having instructions recorded thereon
  • a computer readable storage medium is not to be construed as being transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission media (e.g., light pulses passing through a fiber-optic cable), or electrical signals transmitted through a wire.
  • Computer readable program instructions described herein can be downloaded to respective computing/processing devices from a computer readable storage medium or to an external computer or external storage device via a network, for example, the Internet, a local area network, a wide area network and/or a wireless network.
  • the network may comprise copper transmission cables, optical transmission fibers, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers.
  • a network adapter card or network interface in each computing/processing device receives computer readable program instructions from the network and forwards the computer readable program instructions for storage in a computer readable storage medium within the respective computing/processing device.
  • Computer readable program instructions for carrying out operations of the present invention may be assembler instructions, instruction-set-architecture (ISA) instructions, machine instructions, machine dependent instructions, microcode, firmware instructions, state-setting data, configuration data for integrated circuitry, or either source code or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C++, or the like, and procedural programming languages, such as the “C” programming language or similar programming languages.
  • the computer readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server.
  • the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet Service Provider).
  • electronic circuitry including, for example, programmable logic circuitry, field-programmable gate arrays (FPGA), or programmable logic arrays (PLA) may execute the computer readable program instructions by utilizing state information of the computer readable program instructions to personalize the electronic circuitry, in order to perform aspects of the present invention.
  • These computer readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks.
  • These computer readable program instructions may also be stored in a computer readable storage medium that can direct a computer, a programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer readable storage medium having instructions stored therein comprises an article of manufacture including instructions which implement aspects of the function/act specified in the flowchart and/or block diagram block or blocks.
  • the computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process, such that the instructions which execute on the computer, other programmable apparatus, or other device implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
  • each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s).
  • the functions noted in the blocks may occur out of the order noted in the Figures.
  • two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved.
  • one or more aspects may be provided, offered, deployed, managed, serviced, etc. by a service provider who offers management of customer environments.
  • the service provider can create, maintain, support, etc. computer code and/or a computer infrastructure that performs one or more aspects for one or more customers.
  • the service provider may receive payment from the customer under a subscription and/or fee agreement, as examples. Additionally or alternatively, the service provider may receive payment from the sale of advertising content to one or more third parties.
  • an application may be deployed for performing one or more embodiments.
  • the deploying of an application comprises providing computer infrastructure operable to perform one or more embodiments.
  • a computing infrastructure may be deployed comprising integrating computer readable code into a computing system, in which the code in combination with the computing system is capable of performing one or more embodiments.
  • a process for integrating computing infrastructure comprising integrating computer readable code into a computer system
  • the computer system comprises a computer readable medium, in which the computer medium comprises one or more embodiments.
  • the code in combination with the computer system is capable of performing one or more embodiments.

Landscapes

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

Abstract

Data replication conflict processing after structural changes to a database is provided by a method that includes identifying a structural change made to a database record of a database at a target site, recognizing, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site, and performing conflict processing, the conflict processing including applying one or more modifications to the change data to comport with the structural change made to the database record of the database at the target site.

Description

    STATEMENT REGARDING PRIOR DISCLOSURES BY THE INVENTOR OR A JOINT INVENTOR
  • The following disclosure(s) are submitted under 35 U.S.C. 102(b)(1)(A):
  • Gregg Upton, “Setting up and managing a site transition replication environment”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetranovu.html (first published Jan. 31, 2018);
  • Gregg Upton, “Phase I—Transitions to the stand-in site”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetrans1.html (first published Jan. 31, 2018);
  • Gregg Upton, “Phase II—Main site upgrade”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetrans2.html (first published Jan. 31, 2018);
  • Gregg Upton, “Phase III—Starting the transition back to the main site”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetrans3.html (first published Jan. 31, 2018);
  • Gregg Upton, “Phase IV—Main site activation”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetrans4.html (first published Jan. 31, 2018);
  • Gregg Upton, “Phase V—Upgrading the stand-in site”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetrans5.html (first published Jan. 31, 2018);
  • Gregg Upton, “Resilience during the upgrade process”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoisitetrans6.html (first published Jan. 31, 2018);
  • Gregg Upton, “Types of structural changes supported by IMS Replication”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoistructchgovu.html (first published Jan. 31, 2018);
  • Gregg Upton, “Adding leaf segments”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoiaddleafhtml (first published Jan. 31, 2018);
  • Gregg Upton, “Increasing the length of an existing segment”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoigrowsegment.html (first published Jan. 31, 2018);
  • Gregg Upton, “Deleting segments from the hierarchy”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoidelsegment.html (first published Jan. 31, 2018);
  • Gregg Upton, “Configuring the target server to support structural changes”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoicfgtgtstructchg.html (first published Jan. 31, 2018);
  • Gregg Upton, “Change management sample exit”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.overview.doc/topics/iiyitoichgmgsampleexit.html (first published Jan. 31, 2018);
  • Gregg Upton, “Release notes for IBM InfoSphere® Data Replication for IMS for z/OS, Version 11.3”, IBM Knowledge Center, available at https://www.ibm.com/support/knowledgecenter/SS4T2J_11.3.0/com.ibm.swg.im.iis.clz.i msr.rel.info.doc/topics/iiyrni2irelnotes_v11r3.html (first published Jan. 31, 2018).
  • BACKGROUND
  • Large corporations run significant portions of their systems on ecosystems that store data to various types of databases, such as relational and non-relational databases. Example non-relational database systems include the IBM Information Management System (IMS) and the IBM Virtual Storage Access Method (VSAM), both offered by International Business Machines Corporation, Armonk, N.Y., USA. Operational system requirements typically mandate near-continuous availability, however the rate of change to stay competitive and/or compliant can necessitate relatively frequent changes to the databases/files where the operational data is stored. The data stores tend to be extremely large due to the scale of these operations. Consequently, when there is a need or desire to change these databases, for instance to add additional information, the process can take time and render the applications that access this data temporarily inoperable.
  • Unlike with relational database architectures, applications that access/update IMS data typically have visibility to all of the data in an IMS database record (a “segment” in IMS terminology). Similarly, applications that access/update VSAM data see the entire contents of the database record (“record” in VSAM terminology) stored in the file. In order to add more data to an existing IMS segment or VSAM record, i.e. to increase the length of the segment/record, the database/file is usually unloaded, updated, and then reloaded after the database/file has been updated. The reload may be done using a custom application that formats the new data, or possibly a vendor-supplied utility, depending on the change being made.
  • Changes other than or in addition to changing the size of an existing segment can be made in the case of an IMS database. An example change may be to add new child segment(s) to the database. It is also possible to delete an existing segment and/or change existing parent child relationships.
  • The applications that access this data cannot operate when the database/file is being unloaded, changed, and reloaded. This operation can take a considerable amount of time depending on the size of the database/file being changed. Generally, enterprise applications have a zero down-time goal, though that is not always achieved. There are more realistically short periods of scheduled down-time that can range from a few minutes to an hour or two. The (negative) extent of the impact to the business is directly proportional to the amount of time that the application is unavailable. A desire to provide almost continuous availability makes the database/file change process inherently risky since there are multiple operations that are to be executed in a proper sequence for this process to be successful.
  • SUMMARY
  • Shortcomings of the prior art are overcome and additional advantages are provided through the provision of a computer-implemented method. The method identifies a structural change made to a database record of a database at a target site. The method recognizes, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site. The method also performs conflict processing. The conflict processing includes applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site. This process has an advantage in that it provides approaches to reduce application unavailability when making database/file structural changes, by utilizing a software replication conflict exit deployed in an active/standby configuration.
  • Further, a computer system is provided that includes a memory and a processor in communication with the memory. The computer system is configured to perform a method. The method identifies a structural change made to a database record of a database at a target site. The method recognizes, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site. The method also performs conflict processing. The conflict processing includes applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site.
  • Yet further, a computer program product including a computer readable storage medium readable by a processing circuit and storing instructions for execution by the processing circuit is provided for performing a method. The method identifies a structural change made to a database record of a database at a target site. The method recognizes, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site. The method also performs conflict processing. The conflict processing includes applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site.
  • Additional features and advantages are realized through the concepts described herein.
  • In some embodiments, the database is a non-relational database. This has an advantage in that it provides a way to gracefully handle cases where structural changes are made to records of the non-relational database, without significant downtime or critical data replication errors.
  • The structural change can include a change in a length of the database record, for instance to increase the length of the record. Supporting such a structural change has an advantage in that database records can be increased (or decreased) in length as desired, and the resulting data replication conflicts are handled automatically.
  • In embodiments, the replication operation is (i) an insert of the change data or (ii) an update, using the change data, of current data image data of the database record. This has an advantage in that both inserts and updates are handled by the process, to enable these types of data replication operations despite the structural change to the target.
  • In particular examples, the process also includes unloading the database, performing the structural change to the database record, and reloading the database. The identifying the structural change can be performed based on reloading the database. Thus, the process can also include providing an indication of the structural change in metadata about the database, where the identifying the structural change is based on the provided indication. This has an advantage in that identifying when structural changes occurred enables the conflict processing to be called accordingly.
  • Applying the modification(s) can include, for instance, applying custom formatting to the change data to produce a result, and the process can write the result into the structurally-change database record. Applying custom formatting has an advantage in that it enables the conflict to be resolved by properly formatting the change data for the implemented database change at the target, thereby resolving the conflict.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • Aspects described herein are particularly pointed out and distinctly claimed as examples in the claims at the conclusion of the specification. The foregoing and other objects, features, and advantages of the invention are apparent from the following detailed description taken in conjunction with the accompanying drawings in which:
  • FIG. 1 depicts an example environment to incorporate and use aspects described herein;
  • FIG. 2 depicts an example process for data replication conflict processing after a structural change to a database record, in accordance with aspects described herein;
  • FIG. 3 depicts example conflict processing, in accordance with aspects described herein;
  • FIG. 4 depicts one example of a computer system and associated devices to incorporate and/or use aspects described herein;
  • FIG. 5 depicts a cloud computing environment according to embodiments described herein; and
  • FIG. 6 depicts abstraction model layers according to embodiments described herein.
  • DETAILED DESCRIPTION
  • Described herein are approaches for conflict processing, for instance to resolve conflicts arising during a data replication process to replicate database changes from a source to a target. Although examples are presented with reference to, and using terminology of, the IMS and VSAM database systems offered by International Business Machines Corporation, aspects are equally applicable to other database systems.
  • Conflict processing (implemented by a ‘conflict exit’ for example) in accordance with aspects described herein can support replication processes even after structural changes have been made to database records at the target receiving the replication changes. This is the case even though the changes to be replicated from the source were made against records having a different (i.e. pre-structural change) record structure. Example database/file change processing is performed by a data replication solution operating in an active/standby environment.
  • An active/standby deployment that utilizes software data replication during the transition process to the stand-in/standby site and upon return to the main/active site can reduce application unavailability time and make the change process less risky. After operations have completed the transition to the standby site, the main site databases can be upgraded. Once the upgrade is complete, and during the transition of operations back to the main site, the application workload-provided changes made to the database at the standby site are integrated with the new layout of the target database, for instance using a custom-developed conflict handling exit implemented by the organization and supported by the data replication software.
  • FIG. 1 depicts an example environment to incorporate and use aspects described herein. The environment 100 is a site transition replication environment, in which a main site 102 and stand-in (or “standby”) site 104 are located remote from each other and are in communication across one or more networks, represented by the double-sided arrow between the two sites in FIG. 1. The main site 102 includes an IMS subsystem 104 for IMS database 106, i.e. a non-relational database having database records (“segments”) 108 a, 108 b that are stored within the database container/structure 106. Main site server 109 is a server (hardware and/or software) that executes data replication (DR) software to replicate changes made to the main site database records over to the stand-in site and vice versa. DR software can support ‘conflict exit’ processing, in which processing is called to resolve an apparent conflict during an apply process to apply changes made to one site database to a database at another site.
  • Stand-in site 104 also includes an IMS subsystem 110 for IMS database 112 having segments 114 a, 114 b that are stored within the database container/structure 112. Stand-in site server 116 is a server (hardware and/or software) that executes data replication (DR) software used in the replication of changes made to the main site database records over to the stand-in site and vice versa.
  • Workload distributor 120 is responsible for distributing workload (for instance workload of applications) to the sites 102, 104. Main site 102 is termed as such since it is the main site to which workload is directed. Workload can effect desired deletions, inserts, and changes/updates to data in the database. In an IMS environment such as this, applications may not directly access the database (106) but rather use, e.g., IMS API calls that are routed through the IMS software 104 that is responsible for updating the actual database 106. Changes applied to the database 106 at the main site can be replicated to the stand-in site in case of a failover or other situation. Thus, incoming workload is typically routed to the main site 102 where the IMS replication source server 103 is running. As changes are made to source database 106, they are replicated via servers 109 and 116 to the stand-in site 104, where the changes are applied to the target database 112. During regular, ongoing workload handling, the source and target IMS databases are initially structurally identical. However, it may be desired to upgrade the main IMS database 106 to make structural changes thereto. In this situation, the stand-in site 104 stands-in for the main 102 while the change(s) are made to the main site database. Thus, a transition to the stand-in site is effected, the main site is upgraded, and then a transition is made back to the main site.
  • In this scenario, there are two brief application outages. The first is on the transition to the standby site 104. The applications driving the workload are quiesced at the main site 102 and, once the latest updates are replicated to the standby site 104, the applications become available again with traffic now being routed (by the workflow distributor 120) to the standby site 104.
  • The second application outage is on the transition back to the main site 102. Data replication has applied changes, made at the standby site 104, to the upgraded database(s) at the main site 102, and the applications are again quiesced, this time at the standby site. After quiescing and once the latest changes made at the standby site 104 are replicated back to the main site 102, the workload distributor again routes traffic to the main site 102.
  • Conflict processing, such as a “conflict exit”, can be called in the data replication process to resolve inconsistencies found between the source and target databases during change apply processing. In some examples, a conflict exit is called only when there is a difference/inconsistency detected for a specific change operation.
  • In accordance with aspects described herein, custom conflict processing is provided and used in cases where structural changes are made to database records at a target (e.g. main) site that is to receive updates from a source (e.g. stand-in) site having the initial structure of the database records. The conflict processing can modify segment/file contents of changes made at a source (e.g. a standby) site to match upgraded database/files layout at a target (e.g. the main) site. The custom processing can be applied assuming that the data replication product supports the use of conflict processing to resolve inconsistencies found between the source and target databases during the apply process and allows the source/target database/files layouts to be different. When the conflict processing is enabled (e.g. ‘installed’), the conflict processing can be called to resolve the ‘inconsistency’ for any operation to apply a change to a database record that has been structurally changed at the target.
  • Thus, described aspects use a conflict exit in situations where the source database record structure is different from the target database record structure as reflected by the change data passed from the source to the target. The ‘source’ can refer to the standby site to which workload had been temporarily routed and therefore data inserts, updates, etc. are being made to the database at the source, though changes could flow from any desired source site. The target refers in example presented herein to the main site away from which the workload has been temporarily redirected to the standby site, though changes could flow to any desired target site. Database record(s) at the target (main site) undergo desired structural change(s). An example structural change is a change in the size of a database record (e.g. IMS segment and/or VSAM record), for instance to increase the size of the database record. After the structural change(s) are made, the workload is again to be directed to the main site.
  • Structural changes made to the application database/files in examples described herein include increasing the length of a segment/record. However, aspects enable more radical changes, such data reformatting, to be supported in situations where the data replication product allows the conflict exit to be called on the relevant change operations, e.g., insert operations.
  • With these approaches, the main site systems can be taken offline once the workload has transferred to the standby site. At that point, the database (and any applicable application) upgrade process can begin at the main site. This process can take as long as necessary, with the main site systems being brought back up once the upgrade process is complete. At that point, catch-up processing can begin. The changes that were made at the standby site (the “source”) via workload requests start to flow to the main site (the “target”) via the DR processing. At the target/main site, conflict processing receives control at the appropriate times, for instance when during a change operation a mismatch is detected between the structure of the change data (from the source) and the database record at the target. The conflict processing performs the appropriate structural transformation(s), etc. on the change data in order to for that data to be stored into the upgraded main site databases/files (database records).
  • In particular embodiments, an expectation is that replication runs long enough to take the changes made at the source/standby site (to database records with the initial structural format) and apply them using a custom conflict exit to the database at the target/main site, and more specifically to database records that were changed from the initial structural format to the new structural format. Once the latency of the changes being applied is relatively small, say a second or two, then the organization can cease allowing changes to be made at the source site, e.g. by quiescing the applications submitting workload requests. Once the final changes have been replicated to the target site, operations are resumed (the applications are no longer quiesced) and the workload is routed to the target site with the upgraded database. After this, replication (from source to target) can be stopped, if desired.
  • From an application, client, or web site perspective in these scenarios, traffic is being routed to the source site until replication is caught up. The site may be disabled temporarily while the last changes are applied at the target/main site. Once that occurs, the target/main site is brought back up in the sense that a transition is made back to the target site and traffic is again routed to the target site having the structurally-changed database records, for instance of a new record length. The target/main site contains all the changes that occurred when the unload/reload was performed at the main site, and the business continues to operate with a relatively limited outage. In some situations, the organization may not have even announced the site transition, and any end users who experienced slow response time may have been inconvenienced only in that they had to retry/resubmit their request if the site did not respond immediately to their initial request.
  • Thus, in particular embodiments with application0 workload operating against a backup/standby (e.g. the “source”) site, structural change(s) are made to database records at the target site. As part of this, the database at the target can be unloaded, the structural change(s) is/are made to database records of the unloaded database by an administrator or automatically, then the database is reloaded. Metadata describing properties of that database can indicate/identify that a structural change has been made. The metadata about the database can be refreshed/reloaded, for example, after the upgrade, such that the new version of the metadata provides an indication of the new structure and/or the structural change. This can be used to identify the structural change(s) actually made, for instance that a record was expanded in length from 80 bytes to 160 bytes. The replication software can use this metadata to identify the structural change. When the replication software starts the transition back to the main (target) site, the process can identify the difference in the metadata between the source and target, and therefore identify the structural change. The replication software can, for instance, query the metadata about database record(s) and discover that the source record structure and target record structure are not the same, and this can be used to trigger conflict processing, for instance a call to a conflict exit as described herein, at the target site.
  • In some scenarios, the main site version of the database/file and the standby version of the database/file being upgraded are consistent, and the only conflicts that are detected are due to the database record upgrade process at the main site, since those databases/files are offline and not then being updated by the workload-producing applications. This allows the organization to develop custom logic for the databases/files being upgraded that allows the changes made at the standby site to be properly reintegrated at the main site.
  • The conflict exit or other conflict processing can be configured for the replication software by setting configuration parameter(s), for instance one that identifies the name of the conflict exit and another to activate detecting and calling the exit when there are metadata conflicts, e.g. when the length of the source record is different from the length of the target record. In some examples, code for execution to perform the conflict processing is copied (installed) into a library to which the apply software, which may be part of the data replication software, has access, so that is can be loaded and called when appropriate. Thus, aspects can install, with a data replication process at the target site, a call to the conflict processing that is to be invoked based on recognizing the conflict in a replication operation. Recognition of the conflict can be based on recognizing an inconsistency between a structure (such as a length) of the change data flowing from the source and the structurally-changed database record at the target.
  • In cases of an active/standby environment, the standby site can be taken offline once workload transitions back to the main site. At that point, the structural changes made at the target site can also be made to the standby version of the database/files (database records) to harmonize the structure of the database at the source with that of the upgraded target.
  • During the period of time when the database/files have different layouts between the two sites, a transition operation between the two sites may not be possible without potentially massive data loss. However, this exposure can be mitigated using any desired approach. One such approach is to use a combination of flash copy back-ups and disk mirroring to reduce downtime in case of a disaster or major operational mistake during the upgrade process. In an example, a third site, system, logical partition, the system at the main site itself, and/or an alternative volume at the standby site, can be spawned and populated with the newest version of the database (from the main site) as a disaster recovery option.
  • Specific classes of conflicts that may exist between a source/target object in a replication operation between a source and target object in a replication environment include:
  • (a) For an insert operation, the object already exists at the target. In traditional “upsert” processing, the object at the target would be updated with the insert contents from the source.
  • (b) For an update operation, the object does not exist at the target. In traditional “upsert” processing, an object would be inserted at the target using the source's ‘after image’ data.
  • (c) For a delete or update operation, there is a mismatch between the contents of the source before image and what exists at the target (i.e. “before image mismatches”). In traditional “upsert” processing, the object would be deleted or updated with the source after image contents; in other words, it would ignore the fact that the discrepancy exists.
  • A major restructuring of the database/file database records may result in occurrences of (a) and (b) above, though the impact that these kinds of changes have on existing application logic may be drastic. Consequently, a relatively common scenario of conflict processing as described herein may be case (c)—before image mismatches. It is noted that mere expansion/contraction of a database record from one length (number of bytes) to a different length (number of bytes) itself constitutes a structural change to the database record, even if the useful/relevant data of the database record remains the same. Even if a customer phone number stored in an 80-byte record remains the same when the record is expanded to 160 bytes, this is a discrepancy that change processing will identify; the source after image data is 160 bytes which does not match the 80-byte record at the target.
  • From a terminology perspective, the target is where the conflict exit resides, meaning the conflict exit processing can be performed at the target where the updated database having the structurally-changed database records resides. The source is where the original database/file resides. At the time of the use of the conflict exit, the application workload can be executing at the standby site using the original database/file definitions, the main site may be operational though application workload is not running at the main site, and the database/files have gone through their upgrade process. At that point, the main site applications may be, or have been, modified to access the new versions of the database/file (i.e. the structurally changed database records), the application environment (IMS/CICS) may have been updated to reference/use the upgraded database/file, including the data replication product, and the data replication product is executing at both sites with replication possible from the standby site to the main site.
  • Aspects can support the relatively common type of structural change of increasing the maximum length of a segment or record, though a size change to decrease the maximum length of a segment or record is also possible. The way a length change is handled may be different depending upon whether the existing layout has a fixed or variable length and whether, as part of the upgrade process, data formatting is required for the updated applications to function properly. An initial assumption is that the data replication software is aware of the segment/record length differences between the source and target, which in some embodiments is the signal/trigger for the apply process to call the conflict exit.
  • Taking the case where the size of a fixed layout is increased, because the storage used by one of these segments/records is the same size as part of the upgrade process, the new data (the change data received from the source) is to be formatted with something. Often the applications have been designed to deal with new data that contains spaces or binary zeros, as one possibility. Another possibility is that, as part of the upgrade, the new data has custom formatting applied to it.
  • An example structural change is an increase in the size of the segment/record from 80 bytes to 160 bytes, and the new data is to be formatted with custom values. For delete and update operations, the conflict exit is driven, as the before image (at 80 bytes) and after image (at 160 bytes) cannot possibly match as indicated by the differences in the length of the data between the source and the target definitions. The conflict exit in these situations can identify what the apply process is to perform. Options include, as examples, a ‘force apply’ (update the target database), ignore the change, or stop replication. The conflict exit can contain logic for any custom code to transform the older (source) data into the new format. Thus, modification(s) can be applied to the change data that the source site has or will send to the target site. Applying the modification(s) can include applying custom formatting to the change data to produce a result that is written into the structurally-changed database record. In this type of example where modification(s) are made, the exit requests a force operation.
  • As described above, the conflict exit can be called when there is a difference/inconsistency detected and recognized for a specific operation, such as an update or insert operation. A structural change made to the database record of the database at a target site is identified. As noted, example ‘database records’ are “segments” of an IMS database or “records” of a VSAM database. A structural change can include a change in a length of the database record, for instance to increase its length. Recognizing that a conflict is present can include recognizing a difference in length between the change data and the database record that has been structurally changed as part of a database upgrade. A call to the conflict processing can be signaled based on recognizing that structural change when a replication operation (e.g. delete target data record, insert change data to target data record, update image data of target data record with change data) is to be performed. The conflict processing is called to resolve the ‘inconsistency’ for these operation(s) against a database record that has been structurally changed. As noted, the conflict exit can be driven based on observing a difference (conflict) in the metadata for the database record between the source and target, e.g. the record length is 80 bytes at the source and 160 bytes at the target. Therefore, in some instances, the particular structural change can be inferred based on what is indicated by the metadata.
  • The conflict exit is called, e.g. based on detecting a metadata conflict in performing a replication operation, because the source and target record links are different. For a delete operation using the example above where the length is expanded from 80 bytes to 160 bytes, the conflict exit can confirm that the first 80 bytes of the target match the source, and allow the delete to proceed. For an update, the same confirmation process can occur except then the conflict exit moves the last 80 bytes of the “new” target data into the target after image buffer. In other words, the 80-byte data is received from the source by the target and written in the first 80 bytes of the after image buffer, which is actually to be 160 bytes based on the structural change to the database record at the target from 80 to 160 bytes. The last 80 bytes of the target ‘before image’ (the 160-byte data of the structurally changed database record) are then written into the last 80 byes of the target after image buffer. The ‘upsert’ operation can then be requested. This is one example of applying modification(s) to the change data to comport with the structural change made to the database record of the database at the target site. A realistic assumption is that the conflict exit has access to the source before and after images, the current data image at the target, and can update the contents of the after image before it is applied to the target database/file.
  • In this situation, the conflict exit is to be called when a source insert operation is detected for an object that has been upgraded and the replication software is to be able to detect when it has an insert with only 80 bytes of data, yet the target definition says it should be 160 bytes. How the replication software decides to indicate this condition to the conflict exit may be implementation defined. When informed that the object lengths are inconsistent for an insert operation, the conflict exit can identify the object and perform any required data formatting before returning control and informing the apply logic to go ahead and insert the data at the target. Conflict processing could therefore be called relatively frequently.
  • The data replication software may not initially consider inconsistencies in length between the source and target as a reason to drive the conflict exit. So, while it may be possible to detect that there exists an inconsistency, it may be likely (but not a requirement) that the data replication product supports some method for an administrator, or a conflict exit, to indicate that the conflict exit should be called for insert operations when there are inconsistencies between the source/target databases/files.
  • Variable length segments/records may have similar behavior or requirements depending on the change and how the applications deal with variable length objects. If the upgrade just increases the maximum size of the segment/record and does not perform any preformatting, then there may be no need for a conflict exit to be involved since the source/target should be consistent. However, if the minimum length is increased and is now larger than the actual size of the source, then the conflict exit may be driven for delete/update operations because the source/target will not match structurally, and driven for inserts with the behavior described above. Likewise, if an organization decides to pre-format the new data (at the main site as part of the upgrade), then delete and update operations can drive the conflict exit, and, for updates, the conflict exit can integrate the source data with the preformatted target data using the larger target segment/record length for the update operation.
  • In the case of an insert operation where the actual segment/record size is greater than or equal to the minimum segment/record length but the application has preformatted new data, this condition may not be detected by the replication software. From an exit perspective, the processing to be done for insert operations may be similar to that described above for fixed length segments. Assuming that the maximum segment/record length has been increased, the replication software can treat this the same way it does for fixed length segments/records since the maximum (or minimum) length between the source and target are inconsistent.
  • Potentially, the database/file does not require any structural changes, the application has enough space available and just wants or needs to reuse or recondition the data. For delete and update operations, differences due to the reconditioning could be detected and the exit could re-condition the standby data for update operations before requesting the update operation proceed.
  • To support this kind of use case, the replication software is to become aware that the conflict exit is to be called for at least certain kinds of insert operations. This can be accomplished, as one example, by allowing the conflict exit to request this form of processing or by the replication software supporting a configuration parameter or command requesting this form of special processing. Given the custom nature of the conflict exit and the length of time is may be deployed, using a “call exit on insert” indicator may be all that is required, as opposed to an explicit identification of the objects that require this special processing. However, flexibility in this solution may be implementation-dependent. The above approach could also satisfy other use cases described above where the replication does not detect that there are inconsistencies between the source/target, or whether the difference (inconsistencies) may not warrant calling the conflict exit to resolve.
  • FIG. 2 depicts an example process for data replication conflict processing after a structural change to a database record, in accordance with aspects described herein. In some examples, the process is performed by one or more computer systems, such as those described herein, which may include one or more computer systems of a target site and/or one or more other computer systems. In particular examples, the process is performed by a computer system running data replication software at the target site to facilitate data replication from the source site to the target site.
  • The process installs (registers and/or configures) (202), in or with a data replication process at a target site, a call to conflict processing. The call is to be invoked during replication processing based on recognizing certain conflicts in replication operations.
  • The process identifies (204) a structural change made to a database record of a database at the target site, and recognizes (206), based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site. The change data is source after image data, for instance, sent from the source site to the target site. Example replication operations include insert, update, and delete operations. The recognizing can be based on recognizing an inconsistency between a structure of the change data and the structurally-changed database record, for instance.
  • The process signals (208) a call to the conflict processing based on recognizing the change. The process continues by performing (210) the conflict processing, for instance by way of executing code of a called conflict exit. Performing the conflict processing can generate a result, which the process of FIG. 2 writes (212) into the structurally-changed database record.
  • The process of FIG. 2 has an advantage in that it provides approaches to reduce application unavailability when making database/file structural changes, by utilizing a software replication conflict exit deployed in an active/standby configuration.
  • In some examples, the database is a non-relational database, and the process advantageously provides a way to gracefully handle cases where structural changes are made to records of the non-relational database, without significant downtime or critical data replication errors. In particular examples, the database record is or includes a segment of the database (e.g. an IMS segment) or a VSAM record.
  • The structural change is, for instance, a change in a length of the database record, such as an increase in the length of the record. Supporting such a structural change has an advantage in that database records can be increased (or decreased) in length as desired, and the resulting data replication conflicts are handled automatically. Recognizing the conflict (206 of FIG. 2) can include recognizing a difference in length between the change data and the database record, and the signaling (208) can be performed based on recognizing that difference in length.
  • In embodiments, the replication operation is (i) an insert of the change data or (ii) an update, using the change data, of current data image data of the database record. This has an advantage in that both inserts and updates are handled by the process, to enable these types of data replication operations despite the structural change to the target.
  • In particular examples, the process also includes unloading the database, performing the structural change to the database record (and potentially many other records), and reloading the database. The identifying the structural change can be performed based on reloading the database and on resulting metadata about the changed database. Thus, the process can also include providing an indication of the structural change in metadata about the database, where the identifying the structural change is based on the provided indication. This has an advantage in that identifying when structural changes occurred enables the conflict processing to be called accordingly.
  • FIG. 3 depicts example conflict processing, in accordance with aspects described herein. The process can be performed by one or more computer systems, such as those described herein, which may include one or more computer systems of a target site and/or one or more other computer systems. In particular examples, the process is performed by the computer system(s) that performs the process of FIG. 2. The conflict processing may be a configured ‘conflict exit’ of data replication software.
  • The conflict processing obtains (302) the change data passed from the source and applies (304) one or more modifications to the change data to comport with the structural change made to the database record of the database at the target site. Applying the one or more modifications can include, for instance, applying custom formatting to the change data to produce a result. Applying custom formatting has an advantage in that it enables the conflict to be resolved by properly formatting the change data for the implemented database change at the target, thereby resolving the conflict. The conflict processing makes the changes to produce an output/result. The process provides (306) the result to the apply process, for instance writes it to a buffer, sends, or otherwise makes it available/accessible to the apply processing of the replication processing. Then the process signals/triggers (308) the apply process. In some examples, this is merely the conflict processing breaking/returning back to the calling process, perhaps passing an appropriate return value. In some examples, there is a flag or other signal issued by the signaling (308). When the apply processing resumes, it can apply the result of the conflict processing to the target image.
  • Although various examples are provided, variations are possible without departing from a spirit of the claimed aspects.
  • Processes described herein may be performed singly or collectively by one or more computer systems, such as one or more data replication servers at a site, as an example. FIG. 4 depicts one example of such a computer system and associated devices to incorporate and/or use aspects described herein. A computer system may also be referred to herein as a data processing device/system, computing device/system/node, or simply a computer. The computer system may be based on one or more of various system architectures and/or instruction set architectures, such as those offered by International Business Machines Corporation (Armonk, N.Y., USA), Intel Corporation (Santa Clara, Calif., USA) or ARM Holdings plc (Cambridge, England, United Kingdom), as examples.
  • FIG. 4 shows a computer system 400 in communication with external device(s) 412. Computer system 400 includes one or more processor(s) 402, for instance central processing unit(s) (CPUs). A processor can include functional components used in the execution of instructions, such as functional components to fetch program instructions from locations such as cache or main memory, decode program instructions, and execute program instructions, access memory for instruction execution, and write results of the executed instructions. A processor 402 can also include register(s) to be used by one or more of the functional components. Computer system 400 also includes memory 404, input/output (I/O) devices 408, and I/O interfaces 410, which may be coupled to processor(s) 402 and each other via one or more buses and/or other connections. Bus connections represent one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, and not limitation, such architectures include the Industry Standard Architecture (ISA), the Micro Channel Architecture (MCA), the Enhanced ISA (EISA), the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI).
  • Memory 404 can be or include main or system memory (e.g. Random Access Memory) used in the execution of program instructions, storage device(s) such as hard drive(s), flash media, or optical media as examples, and/or cache memory, as examples. Memory 404 can include, for instance, a cache, such as a shared cache, which may be coupled to local caches (examples include L1 cache, L2 cache, etc.) of processor(s) 402. Additionally, memory 404 may be or include at least one computer program product having a set (e.g., at least one) of program modules, instructions, code or the like that is/are configured to carry out functions of embodiments described herein when executed by one or more processors.
  • Memory 404 can store an operating system 405 and other computer programs 406, such as one or more computer programs/applications that execute to perform aspects described herein. Specifically, programs/applications can include computer readable program instructions that may be configured to carry out functions of embodiments of aspects described herein.
  • Examples of I/O devices 408 include but are not limited to microphones, speakers, Global Positioning System (GPS) devices, cameras, lights, accelerometers, gyroscopes, magnetometers, sensor devices configured to sense light, proximity, heart rate, body and/or ambient temperature, blood pressure, and/or skin resistance, and activity monitors. An I/O device may be incorporated into the computer system as shown, though in some embodiments an I/O device may be regarded as an external device (412) coupled to the computer system through one or more I/O interfaces 410.
  • Computer system 400 may communicate with one or more external devices 412 via one or more I/O interfaces 410. Example external devices include a keyboard, a pointing device, a display, and/or any other devices that enable a user to interact with computer system 400. Other example external devices include any device that enables computer system 400 to communicate with one or more other computing systems or peripheral devices such as a printer. A network interface/adapter is an example I/O interface that enables computer system 400 to communicate with one or more networks, such as a local area network (LAN), a general wide area network (WAN), and/or a public network (e.g., the Internet), providing communication with other computing devices or systems, storage devices, or the like. Ethernet-based (such as Wi-Fi) interfaces and Bluetooth® adapters are just examples of the currently available types of network adapters used in computer systems (BLUETOOTH is a registered trademark of Bluetooth SIG, Inc., Kirkland, Wash., U.S.A.).
  • The communication between I/O interfaces 410 and external devices 412 can occur across wired and/or wireless communications link(s) 411, such as Ethernet-based wired or wireless connections. Example wireless connections include cellular, Wi-Fi, Bluetooth®, proximity-based, near-field, or other types of wireless connections. More generally, communications link(s) 411 may be any appropriate wireless and/or wired communication link(s) for communicating data.
  • Particular external device(s) 412 may include one or more data storage devices, which may store one or more programs, one or more computer readable program instructions, and/or data, etc. Computer system 400 may include and/or be coupled to and in communication with (e.g. as an external device of the computer system) removable/non-removable, volatile/non-volatile computer system storage media. For example, it may include and/or be coupled to a non-removable, non-volatile magnetic media (typically called a “hard drive”), a magnetic disk drive for reading from and writing to a removable, non-volatile magnetic disk (e.g., a “floppy disk”), and/or an optical disk drive for reading from or writing to a removable, non-volatile optical disk, such as a CD-ROM, DVD-ROM or other optical media.
  • Computer system 400 may be operational with numerous other general purpose or special purpose computing system environments or configurations. Computer system 400 may take any of various forms, well-known examples of which include, but are not limited to, personal computer (PC) system(s), server computer system(s), such as messaging server(s), thin client(s), thick client(s), workstation(s), laptop(s), handheld device(s), mobile device(s)/computer(s) such as smartphone(s), tablet(s), and wearable device(s), multiprocessor system(s), microprocessor-based system(s), telephony device(s), network appliance(s) (such as edge appliance(s)), virtualization device(s), storage controller(s), set top box(es), programmable consumer electronic(s), network PC(s), minicomputer system(s), mainframe computer system(s), and distributed cloud computing environment(s) that include any of the above systems or devices, and the like.
  • It is to be understood that although this disclosure includes a detailed description on cloud computing, implementation of the teachings recited herein are not limited to a cloud computing environment. Rather, embodiments of the present invention are capable of being implemented in conjunction with any other type of computing environment now known or later developed.
  • Cloud computing is a model of service delivery for enabling convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, network bandwidth, servers, processing, memory, storage, applications, virtual machines, and services) that can be rapidly provisioned and released with minimal management effort or interaction with a provider of the service. This cloud model may include at least five characteristics, at least three service models, and at least four deployment models.
  • Characteristics are as follows:
  • On-demand self-service: a cloud consumer can unilaterally provision computing capabilities, such as server time and network storage, as needed automatically without requiring human interaction with the service's provider.
  • Broad network access: capabilities are available over a network and accessed through standard mechanisms that promote use by heterogeneous thin or thick client platforms (e.g., mobile phones, laptops, and PDAs).
  • Resource pooling: the provider's computing resources are pooled to serve multiple consumers using a multi-tenant model, with different physical and virtual resources dynamically assigned and reassigned according to demand. There is a sense of location independence in that the consumer generally has no control or knowledge over the exact location of the provided resources but may be able to specify location at a higher level of abstraction (e.g., country, state, or datacenter).
  • Rapid elasticity: capabilities can be rapidly and elastically provisioned, in some cases automatically, to quickly scale out and rapidly released to quickly scale in. To the consumer, the capabilities available for provisioning often appear to be unlimited and can be purchased in any quantity at any time.
  • Measured service: cloud systems automatically control and optimize resource use by leveraging a metering capability at some level of abstraction appropriate to the type of service (e.g., storage, processing, bandwidth, and active user accounts). Resource usage can be monitored, controlled, and reported, providing transparency for both the provider and consumer of the utilized service.
  • Service Models are as follows:
  • Software as a Service (SaaS): the capability provided to the consumer is to use the provider's applications running on a cloud infrastructure. The applications are accessible from various client devices through a thin client interface such as a web browser (e.g., web-based e-mail). The consumer does not manage or control the underlying cloud infrastructure including network, servers, operating systems, storage, or even individual application capabilities, with the possible exception of limited user-specific application configuration settings.
  • Platform as a Service (PaaS): the capability provided to the consumer is to deploy onto the cloud infrastructure consumer-created or acquired applications created using programming languages and tools supported by the provider. The consumer does not manage or control the underlying cloud infrastructure including networks, servers, operating systems, or storage, but has control over the deployed applications and possibly application hosting environment configurations.
  • Infrastructure as a Service (IaaS): the capability provided to the consumer is to provision processing, storage, networks, and other fundamental computing resources where the consumer is able to deploy and run arbitrary software, which can include operating systems and applications. The consumer does not manage or control the underlying cloud infrastructure but has control over operating systems, storage, deployed applications, and possibly limited control of select networking components (e.g., host firewalls).
  • Deployment Models are as follows:
  • Private cloud: the cloud infrastructure is operated solely for an organization. It may be managed by the organization or a third party and may exist on-premises or off-premises.
  • Community cloud: the cloud infrastructure is shared by several organizations and supports a specific community that has shared concerns (e.g., mission, security requirements, policy, and compliance considerations). It may be managed by the organizations or a third party and may exist on-premises or off-premises.
  • Public cloud: the cloud infrastructure is made available to the general public or a large industry group and is owned by an organization selling cloud services.
  • Hybrid cloud: the cloud infrastructure is a composition of two or more clouds (private, community, or public) that remain unique entities but are bound together by standardized or proprietary technology that enables data and application portability (e.g., cloud bursting for load-balancing between clouds).
  • A cloud computing environment is service oriented with a focus on statelessness, low coupling, modularity, and semantic interoperability. At the heart of cloud computing is an infrastructure that includes a network of interconnected nodes.
  • Referring now to FIG. 5, illustrative cloud computing environment 50 is depicted. As shown, cloud computing environment 50 includes one or more cloud computing nodes 10 with which local computing devices used by cloud consumers, such as, for example, personal digital assistant (PDA) or cellular telephone 54A, desktop computer 54B, laptop computer 54C, and/or automobile computer system 54N may communicate. Nodes 10 may communicate with one another. They may be grouped (not shown) physically or virtually, in one or more networks, such as Private, Community, Public, or Hybrid clouds as described hereinabove, or a combination thereof. This allows cloud computing environment 50 to offer infrastructure, platforms and/or software as services for which a cloud consumer does not need to maintain resources on a local computing device. It is understood that the types of computing devices 54A-N shown in FIG. 5 are intended to be illustrative only and that computing nodes 10 and cloud computing environment 50 can communicate with any type of computerized device over any type of network and/or network addressable connection (e.g., using a web browser).
  • Referring now to FIG. 6, a set of functional abstraction layers provided by cloud computing environment 50 (FIG. 5) is shown. It should be understood in advance that the components, layers, and functions shown in FIG. 6 are intended to be illustrative only and embodiments of the invention are not limited thereto. As depicted, the following layers and corresponding functions are provided:
  • Hardware and software layer 60 includes hardware and software components. Examples of hardware components include: mainframes 61; RISC (Reduced Instruction Set Computer) architecture based servers 62; servers 63; blade servers 64; storage devices 65; and networks and networking components 66. In some embodiments, software components include network application server software 67 and database software 68.
  • Virtualization layer 70 provides an abstraction layer from which the following examples of virtual entities may be provided: virtual servers 71; virtual storage 72; virtual networks 73, including virtual private networks; virtual applications and operating systems 74; and virtual clients 75.
  • In one example, management layer 80 may provide the functions described below. Resource provisioning 81 provides dynamic procurement of computing resources and other resources that are utilized to perform tasks within the cloud computing environment. Metering and Pricing 82 provide cost tracking as resources are utilized within the cloud computing environment, and billing or invoicing for consumption of these resources. In one example, these resources may include application software licenses. Security provides identity verification for cloud consumers and tasks, as well as protection for data and other resources. User portal 83 provides access to the cloud computing environment for consumers and system administrators. Service level management 84 provides cloud computing resource allocation and management such that required service levels are met. Service Level Agreement (SLA) planning and fulfillment 85 provide pre-arrangement for, and procurement of, cloud computing resources for which a future requirement is anticipated in accordance with an SLA.
  • Workloads layer 90 provides examples of functionality for which the cloud computing environment may be utilized. Examples of workloads and functions which may be provided from this layer include: mapping and navigation 91; software development and lifecycle management 92; virtual classroom education delivery 93; data analytics processing 94; transaction processing 95; and conflict processing 96.
  • The present invention may be a system, a method, and/or a computer program product at any possible technical detail level of integration. The computer program product may include a computer readable storage medium (or media) having computer readable program instructions thereon for causing a processor to carry out aspects of the present invention.
  • The computer readable storage medium can be a tangible device that can retain and store instructions for use by an instruction execution device. The computer readable storage medium may be, for example, but is not limited to, an electronic storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing. A non-exhaustive list of more specific examples of the computer readable storage medium includes the following: a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), a static random access memory (SRAM), a portable compact disc read-only memory (CD-ROM), a digital versatile disk (DVD), a memory stick, a floppy disk, a mechanically encoded device such as punch-cards or raised structures in a groove having instructions recorded thereon, and any suitable combination of the foregoing. A computer readable storage medium, as used herein, is not to be construed as being transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission media (e.g., light pulses passing through a fiber-optic cable), or electrical signals transmitted through a wire.
  • Computer readable program instructions described herein can be downloaded to respective computing/processing devices from a computer readable storage medium or to an external computer or external storage device via a network, for example, the Internet, a local area network, a wide area network and/or a wireless network. The network may comprise copper transmission cables, optical transmission fibers, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. A network adapter card or network interface in each computing/processing device receives computer readable program instructions from the network and forwards the computer readable program instructions for storage in a computer readable storage medium within the respective computing/processing device.
  • Computer readable program instructions for carrying out operations of the present invention may be assembler instructions, instruction-set-architecture (ISA) instructions, machine instructions, machine dependent instructions, microcode, firmware instructions, state-setting data, configuration data for integrated circuitry, or either source code or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C++, or the like, and procedural programming languages, such as the “C” programming language or similar programming languages. The computer readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet Service Provider). In some embodiments, electronic circuitry including, for example, programmable logic circuitry, field-programmable gate arrays (FPGA), or programmable logic arrays (PLA) may execute the computer readable program instructions by utilizing state information of the computer readable program instructions to personalize the electronic circuitry, in order to perform aspects of the present invention.
  • Aspects of the present invention are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer readable program instructions.
  • These computer readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer readable program instructions may also be stored in a computer readable storage medium that can direct a computer, a programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer readable storage medium having instructions stored therein comprises an article of manufacture including instructions which implement aspects of the function/act specified in the flowchart and/or block diagram block or blocks.
  • The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process, such that the instructions which execute on the computer, other programmable apparatus, or other device implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
  • The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the blocks may occur out of the order noted in the Figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems that perform the specified functions or acts or carry out combinations of special purpose hardware and computer instructions.
  • In addition to the above, one or more aspects may be provided, offered, deployed, managed, serviced, etc. by a service provider who offers management of customer environments. For instance, the service provider can create, maintain, support, etc. computer code and/or a computer infrastructure that performs one or more aspects for one or more customers. In return, the service provider may receive payment from the customer under a subscription and/or fee agreement, as examples. Additionally or alternatively, the service provider may receive payment from the sale of advertising content to one or more third parties.
  • In one aspect, an application may be deployed for performing one or more embodiments. As one example, the deploying of an application comprises providing computer infrastructure operable to perform one or more embodiments.
  • As a further aspect, a computing infrastructure may be deployed comprising integrating computer readable code into a computing system, in which the code in combination with the computing system is capable of performing one or more embodiments.
  • As yet a further aspect, a process for integrating computing infrastructure comprising integrating computer readable code into a computer system may be provided. The computer system comprises a computer readable medium, in which the computer medium comprises one or more embodiments. The code in combination with the computer system is capable of performing one or more embodiments.
  • Although various embodiments are described above, these are only examples. For example, computing environments of other architectures can be used to incorporate and use one or more embodiments.
  • The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting. As used herein, the singular forms “a”, “an” and “the” are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms “comprises” and/or “comprising”, when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components and/or groups thereof.
  • The corresponding structures, materials, acts, and equivalents of all means or step plus function elements in the claims below, if any, are intended to include any structure, material, or act for performing the function in combination with other claimed elements as specifically claimed. The description of one or more embodiments has been presented for purposes of illustration and description, but is not intended to be exhaustive or limited to in the form disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art. The embodiment was chosen and described in order to best explain various aspects and the practical application, and to enable others of ordinary skill in the art to understand various embodiments with various modifications as are suited to the particular use contemplated.

Claims (20)

What is claimed is:
1. A computer-implemented method comprising:
identifying a structural change made to a database record of a database at a target site;
recognizing, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site; and
performing conflict processing, the conflict processing comprising:
applying one or more modifications to the change data to comport with the structural change made to the database record of the database at the target site.
2. The method of claim 1, wherein the database is a non-relational database.
3. The method of claim 2, wherein the structural change comprises a change in a length of the database record, wherein the recognizing the conflict comprises recognizing a difference in length between the change data and the database record, wherein the method further comprises signaling a call to the conflict processing based on the recognizing the difference in length.
4. The method of claim 3, wherein the structural change comprises a change in a length of the database record to increase the length of the database record.
5. The method of claim 3, wherein the database record comprises a segment of the database.
6. The method of claim 1, wherein the applying the one or more modifications comprises applying custom formatting to the change data to produce a result, and wherein the method further comprises writing the result into the structurally-changed database record.
7. The method of claim 1, wherein the replication operation is selected from the group consisting of: (i) an insert of the change data, and (ii) an update, using the change data, of current data image data of the database record.
8. The method of claim 1, further comprising installing, with a data replication process at the target site, a call to the conflict processing, the call to be invoked based on recognizing the conflict in the replication operation, the recognized being based further on recognizing an inconsistency between a structure of the change data and the structurally-changed database record.
9. The method of claim 1, further comprising providing an indication of the structural change in metadata about the database, wherein the identifying the structural change is based on the provided indication.
10. The method of claim 1, further comprising unloading the database, performing the structural change to the database record, and reloading the database, wherein the identifying is performed based on reloading the database.
11. A computer system comprising:
a memory; and
a processor in communication with the memory, wherein the computer system is configured to perform a method comprising:
identifying a structural change made to a database record of a database at a target site;
recognizing, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site; and
performing conflict processing, the conflict processing comprising:
applying one or more modifications to the change data to comport with the structural change made to the database record of the database at the target site.
12. The computer system of claim 11, wherein the database is a non-relational database.
13. The computer system of claim 12, wherein the structural change comprises a change in a length of the database record, wherein the recognizing the conflict comprises recognizing a difference in length between the change data and the database record, wherein the method further comprises signaling a call to the conflict processing based on the recognizing the difference in length.
14. The computer system of claim 1, wherein the applying the one or more modifications comprises applying custom formatting to the change data to produce a result, and wherein the method further comprises writing the result into the structurally-changed database record.
15. The computer system of claim 11, wherein the replication operation is selected from the group consisting of: (i) an insert of the change data, and (ii) an update, using the change data, of current data image data of the database record.
16. A computer program product comprising:
a computer readable storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for performing a method comprising:
identifying a structural change made to a database record of a database at a target site;
recognizing, based at least in part on the structural change, a conflict in a replication operation to be performed at the target site to replicate, to the target site, change data from a source site; and
performing conflict processing, the conflict processing comprising:
applying one or more modifications to the change data to comport with the structural change made to the database record of the database at the target site.
17. The computer program product of claim 16, wherein the database is a non-relational database.
18. The computer program product of claim 17, wherein the structural change comprises a change in a length of the database record, wherein the recognizing the conflict comprises recognizing a difference in length between the change data and the database record, wherein the method further comprises signaling a call to the conflict processing based on the recognizing the difference in length.
19. The computer program product of claim 16, wherein the applying the one or more modifications comprises applying custom formatting to the change data to produce a result, and wherein the method further comprises writing the result into the structurally-changed database record.
20. The meth computer program product of claim 16, wherein the replication operation is selected from the group consisting of: (i) an insert of the change data, and (ii) an update, using the change data, of current data image data of the database record.
US16/193,776 2018-11-16 2018-11-16 Data replication conflict processing after structural changes to a database Active 2039-05-16 US11204940B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US16/193,776 US11204940B2 (en) 2018-11-16 2018-11-16 Data replication conflict processing after structural changes to a database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US16/193,776 US11204940B2 (en) 2018-11-16 2018-11-16 Data replication conflict processing after structural changes to a database

Publications (2)

Publication Number Publication Date
US20200159850A1 true US20200159850A1 (en) 2020-05-21
US11204940B2 US11204940B2 (en) 2021-12-21

Family

ID=70726386

Family Applications (1)

Application Number Title Priority Date Filing Date
US16/193,776 Active 2039-05-16 US11204940B2 (en) 2018-11-16 2018-11-16 Data replication conflict processing after structural changes to a database

Country Status (1)

Country Link
US (1) US11204940B2 (en)

Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040122870A1 (en) * 2002-12-24 2004-06-24 Joong-Ki Park Method for data synchronization and update conflict resolution between mobile clients and server in mobile system
US20040139083A1 (en) * 2003-01-09 2004-07-15 International Business Machines Corporation Replication of changed information in a multi-master environment
US6915287B1 (en) * 2001-12-13 2005-07-05 Novell, Inc. System, method and computer program product for migrating data from one database to another database
US20060190497A1 (en) * 2005-02-18 2006-08-24 International Business Machines Corporation Support for schema evolution in a multi-node peer-to-peer replication environment
US20060294120A1 (en) * 2005-06-27 2006-12-28 Peng Li Detecting migration differences of a customized database schema
US7822711B1 (en) * 2003-12-31 2010-10-26 Symantec Operating Corporation Conflict resolution for a distributed file sharing system
US20110173619A1 (en) * 2005-10-11 2011-07-14 Eric Ian Fish Apparatus and method for optimized application of batched data to a database
US20130066832A1 (en) * 2011-09-12 2013-03-14 Microsoft Corporation Application state synchronization
US20140372374A1 (en) * 2013-06-14 2014-12-18 International Business Machines Corporation Difference determination in a database environment
US20140379636A1 (en) * 2013-06-25 2014-12-25 Sap Ag Automated resolution of database dictionary conflicts
US20160179841A1 (en) * 2014-12-19 2016-06-23 Here Global B.V. Versioned Change Propagation
US20170177690A1 (en) * 2015-12-21 2017-06-22 Sap Se Data synchronization error resolution
US20170337254A1 (en) * 2013-10-31 2017-11-23 Microsoft Technology Licensing, Llc Master data management
US20180210891A1 (en) * 2017-01-24 2018-07-26 Microsoft Technology Licensing, Llc Schematized Data Roaming
US20190340166A1 (en) * 2018-05-07 2019-11-07 Microsoft Technology Licensing, Llc Conflict resolution for multi-master distributed databases

Family Cites Families (70)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4751702A (en) 1986-02-10 1988-06-14 International Business Machines Corporation Improving availability of a restartable staged storage data base system that uses logging facilities
US5355477A (en) 1991-12-23 1994-10-11 International Business Machines Corporation Method for updating a block using record-level locks by committing the update if the block has not been updated by another process otherwise spinning
US5530855A (en) 1992-10-13 1996-06-25 International Business Machines Corporation Replicating a database by the sequential application of hierarchically sorted log records
JP3910221B2 (en) * 1993-12-28 2007-04-25 株式会社日立製作所 Object-oriented database management system and method
US5806074A (en) * 1996-03-19 1998-09-08 Oracle Corporation Configurable conflict resolution in a computer implemented distributed database
US5970502A (en) * 1996-04-23 1999-10-19 Nortel Networks Corporation Method and apparatus for synchronizing multiple copies of a database
US6345244B1 (en) * 1998-05-27 2002-02-05 Lionbridge Technologies, Inc. System, method, and product for dynamically aligning translations in a translation-memory system
US6345243B1 (en) * 1998-05-27 2002-02-05 Lionbridge Technologies, Inc. System, method, and product for dynamically propagating translations in a translation-memory system
US6418443B1 (en) * 2000-02-01 2002-07-09 Bmc Software Hot spot analysis of IMS databases
US6615223B1 (en) * 2000-02-29 2003-09-02 Oracle International Corporation Method and system for data replication
US7177866B2 (en) * 2001-03-16 2007-02-13 Gravic, Inc. Asynchronous coordinated commit replication and dual write with replication transmission and locking of target database on updates only
US7965729B2 (en) * 2001-05-23 2011-06-21 Polytechnic University Transferring data such as files
AU2002334721B2 (en) * 2001-09-28 2008-10-23 Oracle International Corporation An index structure to access hierarchical data in a relational database system
US6980988B1 (en) * 2001-10-01 2005-12-27 Oracle International Corporation Method of applying changes to a standby database system
US6879986B1 (en) 2001-10-19 2005-04-12 Neon Enterprise Software, Inc. Space management of an IMS database
US7478170B2 (en) * 2002-03-05 2009-01-13 Sun Microsystems, Inc. Generic infrastructure for converting documents between formats with merge capabilities
US20040044755A1 (en) * 2002-08-27 2004-03-04 Chipman Timothy W. Method and system for a dynamic distributed object-oriented environment wherein object types and structures can change while running
US7290018B2 (en) * 2002-10-23 2007-10-30 Sap Aktiengesellschaft Change-driven replication of data
US8121978B2 (en) * 2002-11-15 2012-02-21 Sybase, Inc. Database system providing improved methods for data replication
US7596573B2 (en) * 2003-06-11 2009-09-29 Oracle International Corporation System and method for automatic data mapping
US8166101B2 (en) * 2003-08-21 2012-04-24 Microsoft Corporation Systems and methods for the implementation of a synchronization schemas for units of information manageable by a hardware/software interface system
US7934012B2 (en) * 2004-03-12 2011-04-26 Sap Ag Automatic translation code generation
US20060136471A1 (en) * 2004-12-17 2006-06-22 International Business Machines Corporation Differential management of database schema changes
EP1708097A1 (en) * 2005-03-31 2006-10-04 Ubs Ag Computer Network System for the Synchronisation of a Second Database with a First Database
US7529780B1 (en) * 2005-12-30 2009-05-05 Google Inc. Conflict management during data object synchronization between client and server
US7539827B2 (en) * 2006-07-19 2009-05-26 Microsoft Corporation Synchronization of change-tracked data store with data store having limited or no change tracking
US7730028B2 (en) * 2006-09-22 2010-06-01 Research In Motion Limited Schema updating for synchronizing databases connected by wireless interface
US20080147704A1 (en) * 2006-12-13 2008-06-19 Godwin Debbie A Systems and methods for propagation of database schema changes
US8027955B2 (en) * 2007-03-19 2011-09-27 Microsoft Corporation Database management using a file to accumulate changes
US9449047B2 (en) * 2007-06-19 2016-09-20 Sybase, Inc. Dynamic modification of schemas in streaming databases
US20090292745A1 (en) * 2008-05-23 2009-11-26 Orbitz Worldwide, L.L.C. Database management system and method
US10853336B2 (en) * 2008-09-29 2020-12-01 Adobe Inc. Tracking database changes
US20100106744A1 (en) * 2008-10-23 2010-04-29 Microsoft Corporation Conflict prevention for peer-to-peer replication
US8239423B2 (en) * 2009-06-30 2012-08-07 Sap Ag System and method for semantic exposure of data stored in a dynamic schema
US8667028B2 (en) * 2009-09-28 2014-03-04 At&T Global Network Services Deutschland Gmbh System and method to determine database schema impact
US20110145187A1 (en) * 2009-12-16 2011-06-16 Sap Ag Conflict framework for guided structure synchronization
US8380659B2 (en) 2010-02-09 2013-02-19 Google Inc. Method and system for efficiently replicating data in non-relational databases
US8341134B2 (en) * 2010-12-10 2012-12-25 International Business Machines Corporation Asynchronous deletion of a range of messages processed by a parallel database replication apply process
US20120158655A1 (en) 2010-12-20 2012-06-21 Microsoft Corporation Non-relational function-based data publication for relational data
US8843440B2 (en) * 2011-01-21 2014-09-23 Microsoft Corporation Synchronizing database projects with partner projects
US9652469B2 (en) * 2011-06-04 2017-05-16 Microsoft Technology Licensing, Llc Clustered file service
US8943104B2 (en) 2011-08-30 2015-01-27 International Business Machines Corporation Dynamic record management for systems utilizing virtual storage access method (VSAM) data sets with a corresponding VSAM control block structure
US8612405B1 (en) * 2011-09-30 2013-12-17 Emc Corporation System and method of dynamic data object upgrades
US9116971B2 (en) * 2012-05-08 2015-08-25 Softframe, Inc. Data synchronization using a composite change clock
KR20150021117A (en) * 2012-06-18 2015-02-27 액티피오 인크. Enhanced data management virtualization system
US9720994B2 (en) * 2012-10-04 2017-08-01 Sap Se Replicated database structural change management
US20150095283A1 (en) * 2013-09-27 2015-04-02 Microsoft Corporation Master schema shared across multiple tenants with dynamic update
US9424290B2 (en) * 2014-03-11 2016-08-23 Wipro Limited System and method for data validation
CN105101196B (en) * 2014-05-06 2018-11-02 阿里巴巴集团控股有限公司 A kind of user account management method and device
US9785693B2 (en) * 2014-06-30 2017-10-10 Microsoft Technology Licensing, Llc Intelligent conflict detection and semantic expression of document edits
US10019536B2 (en) * 2014-07-15 2018-07-10 Oracle International Corporation Snapshot-consistent, in-memory graph instances in a multi-user database
US9807164B2 (en) * 2014-07-25 2017-10-31 Facebook, Inc. Halo based file system replication
US9779073B2 (en) * 2014-07-29 2017-10-03 Microsoft Technology Licensing, Llc Digital document change conflict resolution
WO2016105354A1 (en) * 2014-12-23 2016-06-30 Hewlett Packard Enterprise Development Lp Simulation of a synchronization of records
AU2015375497A1 (en) * 2015-01-09 2017-07-13 Landmark Graphics Corporation Apparatus and methods of data synchronization
US10216819B2 (en) * 2015-03-20 2019-02-26 International Business Machines Corporation Automated identification of complex transformations and generation of subscriptions for data replication
US9953018B2 (en) * 2015-05-01 2018-04-24 Microsoft Technology Licensing, Llc Transfer of content between documents of different storage types
US10803031B1 (en) * 2015-12-30 2020-10-13 Amazon Technologies, Inc. Migrating data between databases
EP3255562A1 (en) * 2016-06-09 2017-12-13 Mastercard International Incorporated Method and systems for monitoring changes for a server system
GB201615748D0 (en) * 2016-09-15 2016-11-02 Gb Gas Holdings Ltd System for importing data into a data repository
GB201615747D0 (en) * 2016-09-15 2016-11-02 Gb Gas Holdings Ltd System for data management in a large scale data repository
MX2019004025A (en) * 2016-10-05 2019-08-05 Walmart Apollo Llc Systems and methods for synchronizing database schema.
US10216820B1 (en) * 2016-12-14 2019-02-26 Gravic, Inc. Method and apparatus for resolving constraint violations in a database replication system
US10754833B2 (en) * 2017-01-26 2020-08-25 Sap Se Combined database migration and structure conversion within maintenance procedures
US10417199B2 (en) * 2017-07-17 2019-09-17 Vmware, Inc. Distributed locks for continuous data processing and schema administration of a database
US10740286B1 (en) * 2017-08-28 2020-08-11 Amazon Technologies, Inc. Migration task validation before data migration
KR101917806B1 (en) * 2017-12-22 2018-11-12 주식회사 웨어밸리 Synchronization Error Detection AND Replication Method of Database Replication System Using SQL Packet Analysis
US10902016B2 (en) * 2018-02-12 2021-01-26 Artem Shamsutdinov Autonomous interdependent repositories
US10664465B2 (en) * 2018-04-03 2020-05-26 Sap Se Database change capture with transaction-consistent order
US10817387B2 (en) * 2018-08-29 2020-10-27 Servicenow, Inc. Auto point in time data restore for instance copy

Patent Citations (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6915287B1 (en) * 2001-12-13 2005-07-05 Novell, Inc. System, method and computer program product for migrating data from one database to another database
US20040122870A1 (en) * 2002-12-24 2004-06-24 Joong-Ki Park Method for data synchronization and update conflict resolution between mobile clients and server in mobile system
US20040139083A1 (en) * 2003-01-09 2004-07-15 International Business Machines Corporation Replication of changed information in a multi-master environment
US7822711B1 (en) * 2003-12-31 2010-10-26 Symantec Operating Corporation Conflict resolution for a distributed file sharing system
US20060190497A1 (en) * 2005-02-18 2006-08-24 International Business Machines Corporation Support for schema evolution in a multi-node peer-to-peer replication environment
US7991742B2 (en) * 2005-06-27 2011-08-02 International Business Machines Corporation System for detecting migration differences of a customized database schema
US7496596B2 (en) * 2005-06-27 2009-02-24 International Business Machines Corporation Detecting migration differences of a customized database schema
US20060294120A1 (en) * 2005-06-27 2006-12-28 Peng Li Detecting migration differences of a customized database schema
US20110173619A1 (en) * 2005-10-11 2011-07-14 Eric Ian Fish Apparatus and method for optimized application of batched data to a database
US20130066832A1 (en) * 2011-09-12 2013-03-14 Microsoft Corporation Application state synchronization
US20140372374A1 (en) * 2013-06-14 2014-12-18 International Business Machines Corporation Difference determination in a database environment
US20140379636A1 (en) * 2013-06-25 2014-12-25 Sap Ag Automated resolution of database dictionary conflicts
US20170337254A1 (en) * 2013-10-31 2017-11-23 Microsoft Technology Licensing, Llc Master data management
US20160179841A1 (en) * 2014-12-19 2016-06-23 Here Global B.V. Versioned Change Propagation
US20170177690A1 (en) * 2015-12-21 2017-06-22 Sap Se Data synchronization error resolution
US20180210891A1 (en) * 2017-01-24 2018-07-26 Microsoft Technology Licensing, Llc Schematized Data Roaming
US20190340166A1 (en) * 2018-05-07 2019-11-07 Microsoft Technology Licensing, Llc Conflict resolution for multi-master distributed databases

Also Published As

Publication number Publication date
US11204940B2 (en) 2021-12-21

Similar Documents

Publication Publication Date Title
US10936423B2 (en) Enhanced application write performance
US11347555B2 (en) Integrated system to distribute and execute complex applications
US10379841B2 (en) Facilitating automatic container updating within a container-based environment
US11552955B2 (en) Data security across data residency restriction boundaries
US9667496B2 (en) Configuration updates across peer storage systems
US9898279B2 (en) Optimizing ABAP development as a service
US10048955B2 (en) Accelerating software builds
US11249983B2 (en) Transaction change data forwarding
US10055393B2 (en) Distributed version control of orchestration templates
US11748080B2 (en) Cloud service delivery techniques and systems
WO2022179342A1 (en) Application deployment in computing environment
US11151093B2 (en) Distributed system control for on-demand data access in complex, heterogenous data storage
US10768961B2 (en) Virtual machine seed image replication through parallel deployment
CN113467882A (en) Method and system for deploying containers
WO2022263138A1 (en) Cloning, reinstating, and archiving of an application in a containerized platform
US9092292B2 (en) Shared application binary storage
CN111338751B (en) Cross-pool migration method and device for data in same ceph cluster
US11204940B2 (en) Data replication conflict processing after structural changes to a database
US11841833B2 (en) File reorganization
US11822914B2 (en) Upgrade for relational database dependent application
WO2022053048A1 (en) Ensuring secure provisioning of blockchain infrastructure
US11410082B2 (en) Data loss machine learning model update

Legal Events

Date Code Title Description
FEPP Fee payment procedure

Free format text: ENTITY STATUS SET TO UNDISCOUNTED (ORIGINAL EVENT CODE: BIG.); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

STPP Information on status: patent application and granting procedure in general

Free format text: NON FINAL ACTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: FINAL REJECTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: ADVISORY ACTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: DOCKETED NEW CASE - READY FOR EXAMINATION

STPP Information on status: patent application and granting procedure in general

Free format text: NON FINAL ACTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: RESPONSE TO NON-FINAL OFFICE ACTION ENTERED AND FORWARDED TO EXAMINER

STPP Information on status: patent application and granting procedure in general

Free format text: FINAL REJECTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: RESPONSE AFTER FINAL ACTION FORWARDED TO EXAMINER

STPP Information on status: patent application and granting procedure in general

Free format text: NOTICE OF ALLOWANCE MAILED -- APPLICATION RECEIVED IN OFFICE OF PUBLICATIONS

STPP Information on status: patent application and granting procedure in general

Free format text: PUBLICATIONS -- ISSUE FEE PAYMENT RECEIVED

STPP Information on status: patent application and granting procedure in general

Free format text: PUBLICATIONS -- ISSUE FEE PAYMENT VERIFIED

STCF Information on status: patent grant

Free format text: PATENTED CASE