Patents by Inventor James Z. Teng
James Z. Teng has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10482104Abstract: A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.Type: GrantFiled: September 10, 2015Date of Patent: November 19, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
-
Patent number: 10474694Abstract: A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.Type: GrantFiled: February 25, 2015Date of Patent: November 12, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
-
Patent number: 10452629Abstract: Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.Type: GrantFiled: April 7, 2011Date of Patent: October 22, 2019Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, James Z. Teng
-
Patent number: 9875266Abstract: Techniques for restoring point-in-time and transaction consistency across consistency groups between a first and a second independent database management system (DBMS) for a disaster recovery. Several consistency groups (CGs) are defined for replication. For each CG in the first DBMS data changes are transmitted to a second DBMS. A timestamp representing a most recently received commit log record or a heartbeat during periods of inactivity for a CG is stored in a database table at regular intervals. At regular intervals, the timestamp is compared with timestamps for other CGs to identify a common time at which data to be applied to the CGs in the second DBMS have been received into a recoverable data store. The received data is applied to the CGs in the second DBMS up to the common time.Type: GrantFiled: February 27, 2015Date of Patent: January 23, 2018Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
-
Patent number: 9858305Abstract: Techniques for restoring point-in-time and transaction consistency across consistency groups between a first and a second independent database management system (DBMS) for a disaster recovery. Several consistency groups (CGs) are defined for replication. For each CG in the first DBMS data changes are transmitted to a second DBMS. A timestamp representing a most recently received commit log record or a heartbeat during periods of inactivity for a CG is stored in a database table at regular intervals. At regular intervals, the timestamp is compared with timestamps for other CGs to identify a common time at which data to be applied to the CGs in the second DBMS have been received into a recoverable data store. The received data is applied to the CGs in the second DBMS up to the common time.Type: GrantFiled: March 6, 2014Date of Patent: January 2, 2018Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
-
Patent number: 9588996Abstract: Recovering data to a point in time before pending definition changes are materialized in a relational database management system. One or more definition changes to a database schema are received. Original data base schema attributes are saved and maintained as point in time metadata in a catalog table until the one or more definition changes have been materialized. During recovery processing, it is determined for each object being recovered whether the object is being recovered to a point in time prior to which the one or more definition changes were materialized. In response to determining that an object is being recovered to a point in time prior to which the one or more definition changes were materialized, the saved point in time metadata is used for the object in the recovery process.Type: GrantFiled: February 27, 2015Date of Patent: March 7, 2017Assignee: International Business Machines CorporationInventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
-
Patent number: 9588995Abstract: Recovering data to a point in time before pending definition changes are materialized in a relational database management system. One or more definition changes to a database schema are received. Original data base schema attributes are saved as point in time metadata in a catalog table until the one or more definition changes have been materialized. During recovery processing, it is determined for each object being recovered whether the object is being recovered to a point in time prior to which the one or more definition changes were materialized. In response to determining that an object is being recovered to a point in time prior to which the one or more definition changes were materialized, the saved point in time metadata is used for the object in the recovery process.Type: GrantFiled: April 7, 2014Date of Patent: March 7, 2017Assignee: International Business Machines CorporationInventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
-
Publication number: 20160246865Abstract: A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.Type: ApplicationFiled: September 10, 2015Publication date: August 25, 2016Inventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
-
Publication number: 20160246867Abstract: A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.Type: ApplicationFiled: February 25, 2015Publication date: August 25, 2016Inventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
-
Publication number: 20150286534Abstract: Recovering data to a point in time before pending definition changes are materialized in a relational database management system. One or more definition changes to a database schema are received. Original data base schema attributes are saved as point in time metadata in a catalog table until the one or more definition changes have been materialized. During recovery processing, it is determined for each object being recovered whether the object is being recovered to a point in time prior to which the one or more definition changes were materialized. In response to determining that an object is being recovered to a point in time prior to which the one or more definition changes were materialized, the saved point in time metadata is used for the object in the recovery process.Type: ApplicationFiled: April 7, 2014Publication date: October 8, 2015Applicant: International Business Machines CorporationInventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
-
Publication number: 20150286532Abstract: Recovering data to a point in time before pending definition changes are materialized in a relational database management system. One or more definition changes to a database schema are received. Original data base schema attributes are saved and maintained as point in time metadata in a catalog table until the one or more definition changes have been materialized. During recovery processing, it is determined for each object being recovered whether the object is being recovered to a point in time prior to which the one or more definition changes were materialized. In response to determining that an object is being recovered to a point in time prior to which the one or more definition changes were materialized, the saved point in time metadata is used for the object in the recovery process.Type: ApplicationFiled: February 27, 2015Publication date: October 8, 2015Inventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
-
Publication number: 20150254298Abstract: Techniques for restoring point-in-time and transaction consistency across consistency groups between a first and a second independent database management system (DBMS) for a disaster recovery. Several consistency groups (CGs) are defined for replication. For each CG in the first DBMS data changes are transmitted to a second DBMS. A timestamp representing a most recently received commit log record or a heartbeat during periods of inactivity for a CG is stored in a database table at regular intervals. At regular intervals, the timestamp is compared with timestamps for other CGs to identify a common time at which data to be applied to the CGs in the second DBMS have been received into a recoverable data store. The received data is applied to the CGs in the second DBMS up to the common time.Type: ApplicationFiled: February 27, 2015Publication date: September 10, 2015Inventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
-
Publication number: 20150254296Abstract: Techniques for restoring point-in-time and transaction consistency across consistency groups between a first and a second independent database management system (DBMS) for a disaster recovery. Several consistency groups (CGs) are defined for replication. For each CG in the first DBMS data changes are transmitted to a second DBMS. A timestamp representing a most recently received commit log record or a heartbeat during periods of inactivity for a CG is stored in a database table at regular intervals. At regular intervals, the timestamp is compared with timestamps for other CGs to identify a common time at which data to be applied to the CGs in the second DBMS have been received into a recoverable data store. The received data is applied to the CGs in the second DBMS up to the common time.Type: ApplicationFiled: March 6, 2014Publication date: September 10, 2015Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
-
Patent number: 8380680Abstract: Prefetching data using a piecemeal list prefetching method. This is achieved by various means, including building a plurality of data pages, sorting the plurality of data pages into sequential data pages and a list of non-sequential pages, prefetching the sequential data pages using a first prefetching technique, and prefetching the non-sequential list of data pages using a second prefetching technique.Type: GrantFiled: June 23, 2010Date of Patent: February 19, 2013Assignee: International Business Machines CorporationInventors: Jeffrey Berger, Terence P. Purcell, James Z. Teng
-
Publication number: 20120016881Abstract: Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.Type: ApplicationFiled: April 7, 2011Publication date: January 19, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Johannes Schuetzner, James Z. Teng
-
Publication number: 20110320415Abstract: Prefetching data using a piecemeal list prefetching method. This is achieved by various means, including building a plurality of data pages, sorting the plurality of data pages into sequential data pages and a list of non-sequential pages, prefetching the sequential data pages using a first prefetching technique, and prefetching the non-sequential list of data pages using a second prefetching technique.Type: ApplicationFiled: June 23, 2010Publication date: December 29, 2011Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: JEFFREY A. BERGER, TERENCE P. PURCELL, JAMES Z. TENG
-
Patent number: 7890482Abstract: A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.Type: GrantFiled: May 8, 2008Date of Patent: February 15, 2011Assignee: International Business Machines CorporationInventors: Karelle L. Cornwell, Tanya Couch, Robert W. Lyle, James Z. Teng, Julie A. Watts
-
Patent number: 7774372Abstract: A computer system and a relational database management system (RDMS) computer program product are described for interfacing a number of concurrently running database sessions with a large database in which a plurality of local temporary object database descriptors are used in lieu of a single global temporary object database descriptor where the global and each of the local temporary object database descriptors include identifiers for temporary objects, each of the local temporary object database descriptors is associated with a single database session and each of the global database descriptors is shared among multiple database sessions.Type: GrantFiled: May 16, 2007Date of Patent: August 10, 2010Assignee: International Business Machines CorporationInventors: Ramani M. Croisettier, Paramesh S. Desai, James Z. Teng
-
Publication number: 20080288561Abstract: A computer system and a relational database management system (RDMS) computer program product are described for interfacing a number of concurrently running database sessions with a large database in which a plurality of local temporary object database descriptors are used in lieu of a single global temporary object database descriptor where the global and each of the local temporary object database descriptors include identifiers for temporary objects, each of the local temporary object database descriptors is associated with a single database session and each of the global database descriptors is shared among multiple database sessions.Type: ApplicationFiled: May 16, 2007Publication date: November 20, 2008Applicant: International Business Machines CorporationInventors: RamanaKumari M. Croisettier, Paramesh S. Desai, James Z. Teng
-
Publication number: 20080270407Abstract: A system for ensuring referential integrity in a concurrent transaction database environment is disclosed. The system determines when an update to a dependent object requires special processing, and if special processing is required, locating and locking parent objects of the dependent object in share mode prior to committing the update to the dependent object.Type: ApplicationFiled: June 17, 2008Publication date: October 30, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Paramesh S. DESAI, Julie A. WATTS, James Z. TENG