International Business Machines Corporation

Xing Jun Zhou

Mai Zeng

Wei Liu

Cheng Fang Wang

Hong Li

Wei Song

Xin Dong

Ming Qiao Shang Guan

Jing Cheng

Si Bin Fan

Wen Liu

Liang Xu

Xiangmin Zhang

Wei H Liu

Xiao Chen Huang

Jiong Fan

Jing B J Ren

Kang Yong Ying

In computer methods and systems for operating a database management system using a catalog table collection module each table in the database management system is cataloged. Multiple tables are automatically dispatched into multiple consistency groups by collecting real-time statistics using a real time statistics module. Workload profile data of the database management system is generated using a workload profile collection module, and an optimized multiple consistency group definition for the database management system is generated using a transaction splitting analysis module.

Automatic dispatch of multiple tables into consistency groups within an active-active solution

Embodiments of the invention are directed to data replication in an active-active databases having a source site and a target site. Aspects include creating a subscription activation message in a capture address space, the subscription activation message having a timestamp after a latest committed timestamp of the active-active databases and transmitting the subscription activation message to a subscription activation module of the target site of the active-active databases. Based on a determination that one or more tables associated with the subscription activation message are inactive, aspects also include repairing the one or more tables. Based on a determination that all tables associated with the subscription activation message are active, aspects include initiate replication of the capture address space from the source site to the target site with a timestamp of the latest committed timestamp.

Data replication in an active-active databases

A worm gear-worm retractor for an implanted tongue retraction device is provided. The retractor of the present invention includes a control switch capable of adjusting a retraction force of a pull line, a pull line fixing device capable of fixing the pull line, and a casing. The control switch and the pull line fixing device are mounted in the casing, and the control switch is a worm gear-worm structure formed by a worm and a worm gear. Because the control switch adopts the worm gear-worm structure, by rotating the worm, the worm gear can be driven, so that the pull line fixing device connected to the worm gear rotates, thereby tensioning or loosening the pull line to adjust the retraction force of the pull line fixing device. The retractor has advantages of a compact structure, a small size and convenient adjustment.

Turbine-worm traction device applied to implanted tongue traction device

In an embodiment, a computer-implemented method comprises deploying a dual-active database on a first active database site and a second active database site. The first active database site comprises a first group of disks including a first sub-group of disks and a second sub-group of disks respectively corresponding to a third sub-group of disks and a fourth sub-group of disks included in a second group of disks in the second active database site. The method further comprises storing a first set of database logs on the first sub-group of disks while a second set of database logs is being written on the second sub-group of disks. Contents of the second set of database logs are consistent with contents of the first set of database logs and function as a duplication of the first set of database logs.

Dual-active database for data protection

A computing system includes a first storage unit at a first computing site. The first storage unit stores units of work data and data synchronously replicated from a first server cluster of a second computing site. The system further includes a second server cluster at the first computing site, the second server cluster is a proxy node of the first server cluster. The system further includes a second storage unit at the first computing site, the second storage unit stores the units of work data and data from the first storage unit asynchronously into the second storage unit. The system further includes a third server cluster at the first computing site, the third server cluster processes the units of work data asynchronously replicated into the second storage unit.

Zero-data loss recovery for active-active sites configurations

Growing community of inventors

Shanghai, China

Xing Jun Zhou