Patents by Inventor Karla Bester
Karla Bester 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: 11232099Abstract: A method for aggregating data in database tables. A computer receives a request to create an aggregation object comprising a set of related tables and aggregation rules. The computer system creates an aggregation object comprising multiple tables with related key and data columns and managed as a single entity with a single definition. Upon receiving data in the form of a new, inserted, or updated row, the computer system automatically aggregates the data to all objects in the aggregation object hierarchy by creating a summarized row for the current table using the inserted, merged or updated row and defined aggregation rules for each object.Type: GrantFiled: November 2, 2018Date of Patent: January 25, 2022Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 10783198Abstract: A database management system provides row based filtering of data at a database level by evaluating content of at least one record of a write data request received from an application for a particular table from among at least one table of a database, against at least one filter rule specified for the particular table. The database management system selects, for the at least one record, whether to store the at least one record of the write data request as a separate row in the particular table based on a separate action triggered for the at least one record when evaluated against the at least one filter rule specified for the particular table, each record not selected for storage being silently discarded.Type: GrantFiled: May 1, 2017Date of Patent: September 22, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 10783125Abstract: A computer-implemented method for managing a database space includes writing, via a processor, a purge rule to a database management system (DBMS). When the purge rule is executed by the DBMS they automatically purge data in one or more databases at regular intervals. The method includes executing, via a DBMS processor, the purge rule. The purge rule is configured to define, via the DBMS processor, a purge object having purge object attributes without user intervention, and purge, via the DBMS processor, the data based on the purge rule at intervals defined by the purge rule attributes and without user intervention.Type: GrantFiled: November 8, 2016Date of Patent: September 22, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Karla Bester, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20190073394Abstract: A method for aggregating data in database tables. A computer receives a request to create an aggregation object comprising a set of related tables and aggregation rules. The computer system creates an aggregation object comprising multiple tables with related key and data columns and managed as a single entity with a single definition. Upon receiving data in the form of a new, inserted, or updated row, the computer system automatically aggregates the data to all objects in the aggregation object hierarchy by creating a summarized row for the current table using the inserted, merged or updated row and defined aggregation rules for each object.Type: ApplicationFiled: November 2, 2018Publication date: March 7, 2019Inventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 10169404Abstract: A method for aggregating data in database tables. A computer receives a request to create an aggregation object comprising a set of related tables and aggregation rules. The computer system creates an aggregation object comprising multiple tables with related key and data columns and managed as a single entity with a single definition. Upon receiving data in the form of a new, inserted, or updated row, the computer system automatically aggregates the data to all objects in the aggregation object hierarchy by creating a summarized row for the current table using the inserted, merged or updated row and defined aggregation rules for each object.Type: GrantFiled: November 11, 2014Date of Patent: January 1, 2019Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 10025803Abstract: According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein.Type: GrantFiled: September 19, 2016Date of Patent: July 17, 2018Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9977798Abstract: A method for migrating data between tables. The method includes, receiving a Structured Query Language (SQL) statement, where the SQL statement identifies a source table and a destination table, and the source table contains source data divided into columns with a set of column names. A database management system identifies a set of instructions for manipulating the source data. The database management system generates an interim SQL statement, based on the SQL statement. The database management system executes the interim SQL statement, which copies the manipulated source data into a set of columns of the destination table.Type: GrantFiled: July 20, 2015Date of Patent: May 22, 2018Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20180129687Abstract: A computer-implemented method for managing a database space includes writing, via a processor, a purge rule to a database management system (DBMS). When the purge rule is executed by the DBMS they automatically purge data in one or more databases at regular intervals. The method includes executing, via a DBMS processor, the purge rule. The purge rule is configured to define, via the DBMS processor, a purge object having purge object attributes without user intervention, and purge, via the DBMS processor, the data based on the purge rule at intervals defined by the purge rule attributes and without user intervention.Type: ApplicationFiled: November 8, 2016Publication date: May 10, 2018Inventors: Karla Bester, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20170235840Abstract: A database management system provides row based filtering of data at a database level by evaluating content of at least one record of a write data request received from an application for a particular table from among at least one table of a database, against at least one filter rule specified for the particular table. The database management system selects, for the at least one record, whether to store the at least one record of the write data request as a separate row in the particular table based on a separate action triggered for the at least one record when evaluated against the at least one filter rule specified for the particular table, each record not selected for storage being silently discarded.Type: ApplicationFiled: May 1, 2017Publication date: August 17, 2017Inventors: KARLA BESTER, ALLAN T. CHANDLER, MARK A. SHEWELL, STEPHEN J. YATES
-
Patent number: 9665603Abstract: A database management system provides row based filtering of data at a database level by evaluating content of at least one record of a write data request received from an application for a particular table from among at least one table of a database, against at least one filter rule specified for the particular table. The database management system selects, for the at least one record, whether to store the at least one record of the write data request as a separate row in the particular table based on a separate action triggered for the at least one record when evaluated against the at least one filter rule specified for the particular table, each record not selected for storage being silently discarded.Type: GrantFiled: August 3, 2015Date of Patent: May 30, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20170116324Abstract: According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein.Type: ApplicationFiled: January 16, 2017Publication date: April 27, 2017Inventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9575666Abstract: In an approach for locating, preserving, and receiving registers, a register located within a central processing unit is modified a preservation bit, wherein the preservation bit designates when the register is to be preserved. The preservation bit of the register is activated. A preservation bit requests a subroutine to access content held on the register. A register is pushed to a memory source. The bitmask is pushed to a memory source, wherein the bitmask contains information regarding the content pushed to the memory source. The bitmask is popped, at the request of the subroutine, to determine that that content is to be popped. The content is popped from the memory source to the register. The content is returned from the subroutine.Type: GrantFiled: August 12, 2015Date of Patent: February 21, 2017Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20170024382Abstract: A method for migrating data between tables. The method includes, receiving a Structured Query Language (SQL) statement, where the SQL statement identifies a source table and a destination table, and the source table contains source data divided into columns with a set of column names. A database management system identifies a set of instructions for manipulating the source data. The database management system generates an interim SQL statement, based on the SQL statement. The database management system executes the interim SQL statement, which copies the manipulated source data into a set of columns of the destination table.Type: ApplicationFiled: July 20, 2015Publication date: January 26, 2017Inventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20170004149Abstract: According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein.Type: ApplicationFiled: September 19, 2016Publication date: January 5, 2017Inventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20160342627Abstract: According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein.Type: ApplicationFiled: August 15, 2016Publication date: November 24, 2016Inventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9495441Abstract: According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein.Type: GrantFiled: February 25, 2016Date of Patent: November 15, 2016Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9483545Abstract: According to embodiments of the present invention, two or more attributes that are included in a plurality of attributes are aggregated into a group defined by a first data definition language syntax. The first data definition language syntax defines the group as having a groupID and one or more of an attribute definition defined in a comma-separated list and a group definition. The attribute definition is defined by a second data definition syntax. The first data definition language syntax includes the second data definition language syntax. The first data definition language syntax is structured in a manner to allow a database operation associated with the group to be applied to all attributes and/or groups included therein.Type: GrantFiled: May 30, 2014Date of Patent: November 1, 2016Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Publication number: 20160246513Abstract: In an approach for locating, preserving, and receiving registers, a register located within a central processing unit is modified a preservation bit, wherein the preservation bit designates when the register is to be preserved. The preservation bit of the register is activated. A preservation bit requests a subroutine to access content held on the register. A register is pushed to a memory source. The bitmask is pushed to a memory source, wherein the bitmask contains information regarding the content pushed to the memory source. The bitmask is popped, at the request of the subroutine, to determine that that content is to be popped. The content is popped from the memory source to the register. The content is returned from the subroutine.Type: ApplicationFiled: August 12, 2015Publication date: August 25, 2016Inventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9389796Abstract: In an approach for locating, preserving, and receiving registers, a register located within a central processing unit is modified a preservation bit, wherein the preservation bit designates when the register is to be preserved. The preservation bit of the register is activated. A preservation bit requests a subroutine to access content held on the register. A register is pushed to a memory source. The bitmask is pushed to a memory source, wherein the bitmask contains information regarding the content pushed to the memory source. The bitmask is popped, at the request of the subroutine, to determine that that content is to be popped. The content is popped from the memory source to the register. The content is returned from the subroutine.Type: GrantFiled: February 23, 2015Date of Patent: July 12, 2016Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9378254Abstract: An approach is provided to copy records between tables in a relational database. In the approach, a Structured Query Language (SQL) table COPY statement is received with the COPY statement identifying a source table and a target table. Table column names are retrieved from a metadata that corresponds to the source table. The retrieved table column names are used to generate an SQL statement that includes an INSERT INTO clause pertaining to the target table and a SELECT clause pertaining to the source table, wherein the INSERT INTO clause includes a set of target column names and wherein the SELECT clause includes a set of corresponding source column names.Type: GrantFiled: March 15, 2013Date of Patent: June 28, 2016Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates