# US 2013/0159249 A1 · Hybrid data replication > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2013/0159249 A1 - Document ID: US20130159249A1 - Status: Published application - Kind: A1 - Application number: 13/326,892 - Filed: 2011-12-15 - Published: 2013-06-20 - Earliest claimed: 2011-12-15 - Assignees: Sybase, Inc. - Inventors: Rhett Dondi DEWALL; Heping SHANG - Web page: https://patentgrep.com/patent/US20130159249A1 ## CPC - G06F 11/2097: {maintaining the standby controller/processing unit updated (initialisation or re-synchronisation thereof G06F11/1658 and subgroups)} - G06F 11/1662: {the resynchronized component or unit being a persistent storage device (re-synchronization of failed mirror storage G06F11/2082; rebuild or reconstruction of parity RAID storage G06F11/1008)} - G06F 16/2358: {Change logging, detection, and notification (replication G06F16/27)} - G06F 16/2379: {Updates performed during online database operations; commit processing} - G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor - G06F 2201/80: Database-specific techniques - G06F 2201/84: Using snapshots, i.e. a logical point-in-time copy of the data - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract System, method, computer program product embodiments and combinations and sub-combinations thereof for hybrid data replication are described. Aspects include identifying a type of database data replication, the type including a combination of replication approaches, and managing replication based on the identified type, including coordinated switching from one replication approach to another automatically with transactional consistency maintained among source and target databases. ## Claims ### Claim 1 A computer-implemented method for hybrid data replication in a database system environment, the method comprising: identifying a type of database data replication, the type including a combination of replication approaches; and managing replication based on the identified type, including coordinated switching from one replication approach of the combination of replication approaches to another automatically using replication process marker signaling for auto-switching activities to occur during the replication with transactional consistency maintained among source and target databases. ### Claim 2 (depends on 1) The computer-implemented method of claim 1 wherein a type further comprises a combination of log-based followed by non-log-based, complete non-log-based followed by incremental non-log-based, and non-log-based followed by log-based replication. ### Claim 3 (depends on 1) The computer-implemented method of claim 1 wherein managing further comprises managing components for publishers and subscribers, including compensating components. ### Claim 4 (depends on 4) The computer-implemented method of claim 4 further comprising utilizing the compensating components for replication without complete suspension. ### Claim 5 (depends on 1) The computer-implemented method of claim 1 wherein a type is variable among a table of database data, a publisher of database data, and a subscriber of database data. ### Claim 6 (depends on 1) The computer-implemented method of claim 1 wherein a type is variable among tables of a same source database. ### Claim 7 (depends on 6) The computer-implemented method of claim 6 wherein coordinated switching for one table occurs while replication of another table continues uninterrupted. ### Claim 8 (depends on 1) The computer-implemented method of claim 1 wherein managing further comprises managing replication approaches in parallel. ### Claim 9 A system for hybrid data replication in a database system environment, the system comprising: a source database; a target database; and a replication processing system in communication with the source database and target database, the replication processing system configured to identify a type of database data replication, the type including a combination of replication approaches, and configured to manage replication of data from the source database to the target database based on the identified type, including coordinated switching from one replication approach of the combination of replication approaches to another automatically using replication process marker signaling for auto-switching activities to occur during the replication with transactional consistency maintained among the source and target databases. ### Claim 10 (depends on 9) The system of claim 9 wherein a type further comprises a combination of log-based followed by non-log-based, complete non-log-based followed by incremental non-log-based, and non-log-based followed by log-based replication. ### Claim 11 (depends on 9) The system of claim 9 wherein the replication processing system further manages components for publishers and subscribers, including compensating components. ### Claim 12 (depends on 11) The system of claim 11 wherein the replication processing system further utilizes the compensating components for replication without complete suspension. ### Claim 13 (depends on 9) The system of claim 9 wherein a type is variable among a table of database data, a publisher of database data, and a subscriber of database data. ### Claim 14 (depends on 9) The system of claim 9 wherein a type is variable among tables of a same source database. ### Claim 15 (depends on 14) The system of claim 14 wherein coordinated switching for one table occurs while replication of another table continues uninterrupted. ### Claim 16 (depends on 9) The system of claim 9 wherein the replication processing system further manages replication approaches in parallel. ### Claim 17 A computer program product having control logic stored therein embodied within a non-transitory computer readable medium, said control logic enabling a processor to perform hybrid data replication in a database system environment, the control logic comprising: computer readable program code enabling a processor to: identify a type of database data replication, the type including a combination of replication approaches; and manage replication based on the identified type, including coordinated switching from one replication approach of the combination of replication approaches to another automatically using replication process marker signaling for auto-switching activities to occur during the replication with transactional consistency maintained among source and target databases. ### Claim 18 (depends on 17) The computer program product of claim 17 wherein a type further comprises a combination of log-based followed by non-log-based, complete non-log-based followed by incremental non-log-based, and non-log-based followed by log-based replication. ### Claim 19 (depends on 17) The computer program product of claim 17 wherein to manage further comprises managing components for publishers and subscribers, including compensating components. ### Claim 20 (depends on 17) The computer program product of claim 17 wherein a type is variable among a table of database data, a publisher of database data, and a subscriber of database data.