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: 9875266
    Abstract: 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: Grant
    Filed: February 27, 2015
    Date of Patent: January 23, 2018
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
  • Patent number: 9858305
    Abstract: 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: Grant
    Filed: March 6, 2014
    Date of Patent: January 2, 2018
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
  • Patent number: 9588996
    Abstract: 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: Grant
    Filed: February 27, 2015
    Date of Patent: March 7, 2017
    Assignee: International Business Machines Corporation
    Inventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
  • Patent number: 9588995
    Abstract: 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: Grant
    Filed: April 7, 2014
    Date of Patent: March 7, 2017
    Assignee: International Business Machines Corporation
    Inventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
  • Publication number: 20160246867
    Abstract: 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: Application
    Filed: February 25, 2015
    Publication date: August 25, 2016
    Inventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
  • Publication number: 20160246865
    Abstract: 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: Application
    Filed: September 10, 2015
    Publication date: August 25, 2016
    Inventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
  • Publication number: 20150286532
    Abstract: 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: Application
    Filed: February 27, 2015
    Publication date: October 8, 2015
    Inventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
  • Publication number: 20150286534
    Abstract: 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: Application
    Filed: April 7, 2014
    Publication date: October 8, 2015
    Applicant: International Business Machines Corporation
    Inventors: Szu-Huey Chuang, Craig A. Friske, Laura M. Kunioka-Weis, Regina J. Liu, Ka C. Ng, James Z. Teng, Binghui Zhong
  • Publication number: 20150254296
    Abstract: 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: Application
    Filed: March 6, 2014
    Publication date: September 10, 2015
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
  • Publication number: 20150254298
    Abstract: 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: Application
    Filed: February 27, 2015
    Publication date: September 10, 2015
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, You-Chin Fuh, James Z. Teng, Tyrone Yu
  • Patent number: 8380680
    Abstract: 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: Grant
    Filed: June 23, 2010
    Date of Patent: February 19, 2013
    Assignee: International Business Machines Corporation
    Inventors: Jeffrey Berger, Terence P. Purcell, James Z. Teng
  • Publication number: 20120016881
    Abstract: 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: Application
    Filed: April 7, 2011
    Publication date: January 19, 2012
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Namik Hrle, Johannes Schuetzner, James Z. Teng
  • Publication number: 20110320415
    Abstract: 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: Application
    Filed: June 23, 2010
    Publication date: December 29, 2011
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: JEFFREY A. BERGER, TERENCE P. PURCELL, JAMES Z. TENG
  • Patent number: 7890482
    Abstract: 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: Grant
    Filed: May 8, 2008
    Date of Patent: February 15, 2011
    Assignee: International Business Machines Corporation
    Inventors: Karelle L. Cornwell, Tanya Couch, Robert W. Lyle, James Z. Teng, Julie A. Watts
  • Patent number: 7774372
    Abstract: 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: Grant
    Filed: May 16, 2007
    Date of Patent: August 10, 2010
    Assignee: International Business Machines Corporation
    Inventors: Ramani M. Croisettier, Paramesh S. Desai, James Z. Teng
  • Publication number: 20080288561
    Abstract: 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: Application
    Filed: May 16, 2007
    Publication date: November 20, 2008
    Applicant: International Business Machines Corporation
    Inventors: RamanaKumari M. Croisettier, Paramesh S. Desai, James Z. Teng
  • Publication number: 20080270407
    Abstract: 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: Application
    Filed: June 17, 2008
    Publication date: October 30, 2008
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Paramesh S. DESAI, Julie A. WATTS, James Z. TENG
  • Publication number: 20080243966
    Abstract: A method and system to manage temporary storage space of a relational database management system by receiving a data segment allocation request from an application, allocating a data segment to the application, marking the data segment as allocated in a space map page, and indicating a usage status of the data segment. The method also includes receiving a mass delete command from the application, indicating reception of the mass delete command in a table-related control block, and marking the data segment as unavailable in the space map page. The method may also include indicating reception of the mass delete commit command in the table-related control block to enable the application to reuse the data segment.
    Type: Application
    Filed: April 2, 2007
    Publication date: October 2, 2008
    Inventors: RamanaKumari M. Croisettier, Paramesh S. Desai, James Z. Teng
  • Patent number: 7266552
    Abstract: A method, apparatus, and article of manufacture accesses a dataset using an unsupported access method. A first request to access a dataset is intercepted. The first request is associated with a first data structure that specifies a first access method. The first data structure is replaced with a second data structure that specifies a second access method which is different from the first access method. The dataset is accessed in accordance with the second access method of the second data structure. In another particular embodiment, the first access method is the basic direct access method, and the second access method is any of the basic sequential access method and the queued sequential access method. In yet another embodiment, the dataset is an extended format physical sequential dataset.
    Type: Grant
    Filed: April 9, 2004
    Date of Patent: September 4, 2007
    Assignees: International Business Machines Corporation, Rocket Software, Inc.
    Inventors: David R. Schwartz, Bryan Frederick Smith, James Z. Teng, David Warner
  • Patent number: 7174353
    Abstract: The present invention is related to a method and system for preserving an original table schema for a table in a database system that supports dynamic table schema changes. The method and system includes storing the original table schema for the table in a designated table prior to performing a schema change on the table. By storing the original table schema in the designated table, a backup copy of the table that includes rows which are not self-describing can be used for data recovery.
    Type: Grant
    Filed: October 24, 2003
    Date of Patent: February 6, 2007
    Assignee: International Business Machines Corporation
    Inventors: Craig A. Friske, Regina J. Liu, James A. Ruddy, James Z. Teng, Julie A. Watts