Patents by Inventor Julie A. Watts
Julie A. Watts 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: 10747626Abstract: In a high insert throughput in a database system, the database management system (DBMS) caches, asynchronously from data insert transactions, a list of storage location identifiers for storage locations in a table space in the database system. When a request for an insert transaction with an insert size is received from an agent, the DBMS identifies a storage location on the list with an amount of free space meeting the insert size. The DBMS removes the storage location identifier from the list and returns the storage location identifier for the storage location. When the insert transaction completes, the DBMS determines a remaining free space at the storage location and adds the storage location identifier to the list according to the remaining free space. By removing storage location identifiers from the list, another agent cannot receive the same storage location identifier for a parallel task. Thus, space contention is avoided.Type: GrantFiled: October 16, 2016Date of Patent: August 18, 2020Assignee: International Business Machines CorporationInventors: Oliver Draese, Robert W. Lyle, Kalpana Shyam, George F. Wang, Julie A. Watts, Shirley Zhou
-
Patent number: 10747627Abstract: In a high insert throughput in a database system, the database management system (DBMS) caches, asynchronously from data insert transactions, a list of storage location identifiers for storage locations in a table space in the database system. When a request for an insert transaction with an insert size is received from an agent, the DBMS identifies a storage location on the list with an amount of free space meeting the insert size. The DBMS removes the storage location identifier from the list and returns the storage location identifier for the storage location. When the insert transaction completes, the DBMS determines a remaining free space at the storage location and adds the storage location identifier to the list according to the remaining free space. By removing storage location identifiers from the list, another agent cannot receive the same storage location identifier for a parallel task. Thus, space contention is avoided.Type: GrantFiled: January 9, 2018Date of Patent: August 18, 2020Assignee: International Business Machines CorporationInventors: Oliver Draese, Robert W. Lyle, Kalpana Shyam, George F. Wang, Julie A. Watts, Shirley Zhou
-
Publication number: 20180129677Abstract: In a high insert throughput in a database system, the database management system (DBMS) caches, asynchronously from data insert transactions, a list of storage location identifiers for storage locations in a table space in the database system. When a request for an insert transaction with an insert size is received from an agent, the DBMS identifies a storage location on the list with an amount of free space meeting the insert size. The DBMS removes the storage location identifier from the list and returns the storage location identifier for the storage location. When the insert transaction completes, the DBMS determines a remaining free space at the storage location and adds the storage location identifier to the list according to the remaining free space. By removing storage location identifiers from the list, another agent cannot receive the same storage location identifier for a parallel task. Thus, space contention is avoided.Type: ApplicationFiled: January 9, 2018Publication date: May 10, 2018Inventors: Oliver Draese, Robert W. Lyle, Kalpana Shyam, George F. Wang, Julie A. Watts, Shirley Zhou
-
Publication number: 20180107677Abstract: In a high insert throughput in a database system, the database management system (DBMS) caches, asynchronously from data insert transactions, a list of storage location identifiers for storage locations in a table space in the database system. When a request for an insert transaction with an insert size is received from an agent, the DBMS identifies a storage location on the list with an amount of free space meeting the insert size. The DBMS removes the storage location identifier from the list and returns the storage location identifier for the storage location. When the insert transaction completes, the DBMS determines a remaining free space at the storage location and adds the storage location identifier to the list according to the remaining free space. By removing storage location identifiers from the list, another agent cannot receive the same storage location identifier for a parallel task. Thus, space contention is avoided.Type: ApplicationFiled: October 16, 2016Publication date: April 19, 2018Inventors: Oliver DRAESE, Robert W. LYLE, Kalpana SHYAM, George F. WANG, Julie A. WATTS, Shirley ZHOU
-
Patent number: 9910869Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: GrantFiled: November 28, 2014Date of Patent: March 6, 2018Assignee: International Business Machines CorporationInventors: Craig A. Friske, Charles H. Lin, Regina J. Liu, Jerry Mukai, Kalpana Shyam, Cherri Vidmar, Julie A. Watts, Jay A. Yothers, Binghui Zhong
-
Patent number: 9317543Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: GrantFiled: January 13, 2014Date of Patent: April 19, 2016Assignee: International Business Machines CorporationInventors: Craig A. Friske, Charles H. Lin, Regina J. Liu, Jerry Mukai, Kalpana Shyam, Cherri Vidmar, Julie A. Watts, Jay A. Yothers, Binghui Zhong
-
Publication number: 20150199325Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: ApplicationFiled: November 28, 2014Publication date: July 16, 2015Inventors: Craig A. FRISKE, Charles H. LIN, Regina J. LIU, Jerry MUKAI, Kalpana SHYAM, Cherri VIDMAR, Julie A. WATTS, Jay A. YOTHERS, Binghui ZHONG
-
Publication number: 20150199393Abstract: Dropping of columns from a table with data availability, where the columns in the table are each associated with a column number, includes: executing a statement to drop a given column in the table and deferring an application of the statement until a reorganization of a current data set including the table. When the reorganization of the current data set is performed, the reorganization includes: updating column numbers for columns in each row of the table using a mapping data structure to remove the given column; loading the plurality of data rows with the updated column numbers into a shadow data set; applying to the shadow data set any changes to the table that are concurrent with the reorganization; updating a schema definition of the table with the updated column numbers; and switching the current data set to the shadow data set.Type: ApplicationFiled: January 13, 2014Publication date: July 16, 2015Applicant: International Business Machines CorporationInventors: Craig A. FRISKE, Charles H. LIN, Regina J. LIU, Jerry MUKAI, Kalpana SHYAM, Cherri VIDMAR, Julie A. WATTS, Jay A. YOTHERS, Binghui ZHONG
-
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: 7711730Abstract: A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.Type: GrantFiled: December 22, 2003Date of Patent: May 4, 2010Assignee: International Business Machines CorporationInventors: Margaret A. Bernal, Karelle L. Cornwell, Hsuiying Y. Cheng, Yao-Ching S. Chen, Christopher J. Crone, Fen-Ling Lin, James W. Pickel, Yumi K. Tsuji, Julie A. Watts
-
Publication number: 20090164468Abstract: 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: ApplicationFiled: May 8, 2008Publication date: June 25, 2009Applicant: International Business Machines CorporationInventors: Karelle L. CORNWELL, Tanya Couch, Robert W. Lyle, James Zu-Chia Teng, Julie A. Watts
-
Patent number: 7499924Abstract: A method for selectively releasing locks when rolling back to a savepoint includes: providing at least one savepoint in a transaction, where the at least one savepoint and the transaction are separate lock owners, where at least one lock is assigned to the at least one savepoint and at least one lock is assigned to the transaction; rolling back the transaction to the at least one savepoint; and releasing any locks owned by the at least one savepoint, where any locks owned by the transaction is maintained. Ownership of locks to persist until commit is assigned to the transaction. Ownership of locks to be released when rolled back to a savepoint is assigned to the savepoint. When roll back to a given savepoint occurs, locks owned by the savepoint are released while locks owned by the transaction are maintained.Type: GrantFiled: July 18, 2005Date of Patent: March 3, 2009Assignee: International Business Machines CorporationInventor: Julie A. Watts
-
Patent number: 7480653Abstract: A method and system for controlling concurrency of access to data in a database system, includes: partitioning a table in the database system into a plurality of partitions; receiving a request for access to data; determining a partition of the plurality of partitions that contains the data; determining if the data has been committed; and if so, avoiding locking the partition in response to the request. By avoiding locking the partition when the data has been committed, the number of partition locks that need to be requested from a local resource lock manager is reduced, improving performance.Type: GrantFiled: April 2, 2004Date of Patent: January 20, 2009Assignee: International Business Machines CorporationInventors: Karelle L. Cornwell, Tanya Couch, Robert W. Lyle, James Zu-Chia Teng, Julie A. Watts
-
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
-
Publication number: 20080010283Abstract: A method and system for controlling concurrency of access to data in a database system is provided. The method 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: ApplicationFiled: July 13, 2007Publication date: January 10, 2008Applicant: International Business Machines CorporationInventors: Karelle Cornwell, Tanya Couch, Robert Lyle, James Teng, Julie Watts
-
Publication number: 20070198591Abstract: A computer implemented method, apparatus, and computer usable program code for managing a table space for a database. The table space is searched to find available free space in a set of partitions in the table space in response to receiving a request to insert a record into a database table in the database. A new partition is created for the table space based on a size for the new partition in response to determining free space is unavailable for the record in the set of partitions. The record is inserted into the new partition.Type: ApplicationFiled: February 17, 2006Publication date: August 23, 2007Applicant: International Business Machines CorporationInventors: James Teng, Frances Villafuerte, Julie Watts
-
Patent number: 7174353Abstract: 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: GrantFiled: October 24, 2003Date of Patent: February 6, 2007Assignee: International Business Machines CorporationInventors: Craig A. Friske, Regina J. Liu, James A. Ruddy, James Z. Teng, Julie A. Watts
-
Patent number: 7080074Abstract: According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.Type: GrantFiled: November 5, 2001Date of Patent: July 18, 2006Assignee: International Business Machines CorporationInventors: Namik Hrle, Andreas R. Maier, James Zu-Chia Teng, Julie A. Watts
-
Publication number: 20060004757Abstract: A method for selectively releasing locks when rolling back to a savepoint includes: providing at least one savepoint in a transaction, where the at least one savepoint and the transaction are separate lock owners, where at least one lock is assigned to the at least one savepoint and at least one lock is assigned to the transaction; rolling back the transaction to the at least one savepoint; and releasing any locks owned by the at least one savepoint, where any locks owned by the transaction is maintained. Ownership of locks to persist until commit is assigned to the transaction. Ownership of locks to be released when rolled back to a savepoint is assigned to the savepoint. When roll back to a given savepoint occurs, locks owned by the savepoint are released while locks owned by the transaction are maintained.Type: ApplicationFiled: July 18, 2005Publication date: January 5, 2006Applicant: International Business Machines CorporationInventor: Julie Watts
-
Publication number: 20050138010Abstract: A method for generating an execution plan for updating and retrieving data from a database in a single process includes: receiving a statement by a server to update a database with a first set of data and to retrieve a second set of data from the database; building a first execution plan to update the database with the first set of data; building a second execution plan to retrieve the second set of data from the database; and building a single execution plan including a combination of the first and second execution plans. The single execution plan allows for the updating and retrieval of data with a single crossing of an interface between a client and the database. By performing both functions in this manner, the efficiency of performing such tasks on the database is significantly increased.Type: ApplicationFiled: December 22, 2003Publication date: June 23, 2005Inventors: Margaret Bernal, Karelle Cornwell, Hsuiying Cheng, Yao-Ching Chen, Christopher Crone, Fen-Ling Lin, James Pickel, Yumi Tsuji, Julie Watts