Patents by Inventor Curt L. Cotner
Curt L. Cotner 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).
-
Publication number: 20130325826Abstract: A method for identifying matching transactions between two log files where each transaction includes one or more statements. Each log file record records the execution of a statement and includes a transaction identifier. Each record in turn in one log file is compared to an advancing window of records in the other log file. A first table contains associations of statements to transactions and transactions to statements for records in the window. If a match is found between a record in the one file and a record in the window, information associating partial transactions in the one file to potential transactions of the records in the window is added to a second table. If an end-of-transaction record is read from the one file, a best match is found between the ended transaction and the potential transactions based on information in the first and second tables.Type: ApplicationFiled: May 30, 2012Publication date: December 5, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Manoj K. Agarwal, Curt L. Cotner, Amitava Kundu, Prasan Roy, Rajesh Sambandhan
-
Publication number: 20130325829Abstract: A method for identifying matching transactions between two log files where each transaction includes one or more statements. Each log file record records the execution of a statement and includes a transaction identifier. Each record in turn in one log file is compared to an advancing window of records in the other log file. A first table contains associations of statements to transactions and transactions to statements for records in the window. If a match is found between a record in the one file and a record in the window, information associating partial transactions in the one file to potential transactions of the records in the window is added to a second table. If an end-of-transaction record is read from the one file, a best match is found between the ended transaction and the potential transactions based on information in the first and second tables.Type: ApplicationFiled: May 31, 2013Publication date: December 5, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Manoj K. Agarwal, Curt L. Cotner, Amitava Kundu, Prasan Roy, Rajesh Sambandhan
-
Publication number: 20130262435Abstract: An adaptive query execution plan enhancement is provided by: selecting a sample of literal sets from an execution history of a query statement; determining a plurality of access paths by applying each literal set in the sample to the query statement; for each given access path of the plurality of access paths, determining a total execution cost by applying each literal set in the sample to the given access path; and selecting a preferred access path from the plurality of access paths based on the total execution costs for each given access path. A plurality of preferred access paths for a plurality of query statements in an application workload is collected and may be presented as a query execution plan enhancement recommendation to users.Type: ApplicationFiled: March 28, 2012Publication date: October 3, 2013Applicant: International Business Machines CorporationInventors: Patrick D. BOSSMAN, Curt L. COTNER, You-Chin FUH, Adarsh S. PANNU, Kun Peng REN
-
Publication number: 20130254173Abstract: Methods for processing a query in a multi-tenancy environment utilizing an electronic computing device are presented, the methods including: causing the electronic computing device to receive the query to a database, where the query includes a number of objects; causing the electronic computing device to determine whether any of the number of objects correspond with the set of tenant database objects; if any of the number of objects correspond with the set of tenant database objects, causing the electronic computing device to process the number of objects from the tenant production table; and if any of the number of objects correspond with the set of instance database objects, causing the electronic computing device to process the number of objects from the instance production table.Type: ApplicationFiled: May 10, 2013Publication date: September 26, 2013Inventors: Curt L. Cotner, Namik Hrle
-
Patent number: 8515948Abstract: Provided are techniques for creating one or more fine-grained access control rules that are associated with a base table. A materialized query table is created from the base table without applying the one or more fine-grained access control rules associated with the base table when obtaining data from the base table. A fine-grained access control protection indicator is turned on for the materialized query table. In response to receiving a direct access request to the materialized query table in a query referencing the materialized query table, access is provided to the data in the materialized query table by applying one or more fine-grained access control rules associated directly with the materialized query table to the data in the materialized query table before returning the data.Type: GrantFiled: March 9, 2011Date of Patent: August 20, 2013Assignee: International Business Machines CorporationInventors: Yao-Ching S. Chen, Curt L. Cotner, Gerald G. Kiernan, David J. Kuang, Irene C. Liu, Regina J. Liu, Walid Rjaibi, Timothy J. Vincent
-
Patent number: 8473515Abstract: Database systems are presented including: a database; a database instance of the database, where the database instance includes a set of instance database objects, and where the database instance is accessible by an instance user; and a database tenant associated with the database instance, where the database tenant includes a set of tenant database objects, where the database tenant provides access to the database instance by the tenant user, such that the instance user and the tenant user may independently access the database instance without affecting one another where each of the instance user and the tenant user are configured with independent accessibility. In some embodiments, systems further include: an instance production table associated with the database instance and a tenant production table associated with the database instance.Type: GrantFiled: May 10, 2010Date of Patent: June 25, 2013Assignee: International Business Machines CorporationInventors: Curt L. Cotner, Namik Hrle
-
Publication number: 20130086088Abstract: According to one embodiment of the present invention, a system processes a database query, and comprises a computer system including at least one processor. The system identifies one or more expressions within the database query utilizing a database object with value masking. Masking requirements are determined for each identified expression and the database object utilized by that identified expression is replicated to provide masked and actual versions of that database object in response to the masking requirements for that expression including masked values and actual values of that database object. The value masking of the database object is applied to the identified expressions within the database query based on the determined masking requirements to produce search results with masked values for the database query. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manner described above.Type: ApplicationFiled: October 3, 2011Publication date: April 4, 2013Applicant: International Business Machines CorporationInventors: Eric L. Alton, Thomas A. Beavin, Harley W. Boughton, Yao-Ching S. Chen, Curt L. Cotner, Yuping Ding, Dengfeng Gao, Gerald G. Kiernan, Xun Li, Irene C. Liu, Walid Rjaibi, Gregory R. Stager, Joyce A. Taylor, Timothy J. Vincent, Liyan Zhou
-
Patent number: 8386522Abstract: A row property provides a mechanism for implementing advanced functional behavior in a relational database management system (RDBMS) without introducing new data types. A row property is part of a table definition, such that, when a table is defined in the RDBMS, at least one row property is specified for one or more associated columns of rows of the table, wherein the row property has an associated functional behavior that is predefined within the RDBMS. The columns associated with the row property are generally of existing data types supported by an RDBMS. A row property may be invoked when the RDBMS processes a language statement that references the row property. When the row property is invoked, the RDBMS executes programming logic associated with the row property, in order to perform the advanced functional behavior using data stored in the associated columns.Type: GrantFiled: May 28, 2010Date of Patent: February 26, 2013Assignee: International Business Machines CorporationInventors: Curt L. Cotner, Balakrishna R. Iyer, Krishnarao G. Kulkarni, Robert W. Lyle
-
Publication number: 20120259824Abstract: In a particular embodiment, a method includes storing, at a staging table of a database, a data update generated based on a transaction performed with respect to a data table that is associated with one or more indexes. Each index of the one or more indexes is maintained externally to the database. The method further includes maintaining the data update at the staging table at least until index update data is received at the database. The index update data represents a modification, based on the data update, to a particular index of the one or more the indexes.Type: ApplicationFiled: June 20, 2012Publication date: October 11, 2012Applicant: International Business Machines CorporationInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, JR., Claus Kempfert
-
Publication number: 20120233148Abstract: Provided are techniques for creating one or more fine-grained access control rules that are associated with a base table. A materialized query table is created from the base table without applying the one or more fine-grained access control rules associated with the base table when obtaining data from the base table. A fine-grained access control protection indicator is turned on for the materialized query table. In response to receiving a direct access request to the materialized query table in a query referencing the materialized query table, access is provided to the data in the materialized query table by applying one or more fine-grained access control rules associated directly with the materialized query table to the data in the materialized query table before returning the data.Type: ApplicationFiled: March 9, 2011Publication date: September 13, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Yao-Ching S. CHEN, Curt L. COTNER, Gerald G. KIERNAN, David J. KUANG, Irene C. LIU, Regina J. LIU, Walid RJAIBI, Timothy J. VINCENT
-
Patent number: 8239389Abstract: Systems, methods, and computer program products to persist external index data in a database are disclosed. In an embodiment, a method includes maintaining a database including a first data table that is configured to store data in a database format and a second data table that is configured to store index data. The index data represents an index of a first portion of the first data table, and the index maintained externally to the database by an index manager. The method also includes generating a data update representing a modification to the first data table and communicating the data update to the index manager. The method further includes receiving index update data from the index manager representing a modification to the index as a result of the data update and applying the index update data to the second data table.Type: GrantFiled: September 29, 2008Date of Patent: August 7, 2012Assignee: International Business Machines CorporationInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, Jr., Claus Kempfert
-
Publication number: 20120197919Abstract: Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.Type: ApplicationFiled: January 28, 2011Publication date: August 2, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Stephen Yao Ching Chen, Curt L. Cotner, Gerald G. Kiernan, Irene Ching-Hua Liu, Claire W. McFeely, Walid Rjaibi, Timothy J. Vincent
-
Publication number: 20110295909Abstract: A row property provides a mechanism for implementing advanced functional behavior in a relational database management system (RDBMS) without introducing new data types. A row property is part of a table definition, such that, when a table is defined in the RDBMS, at least one row property is specified for one or more associated columns of rows of the table, wherein the row property has an associated functional behavior that is predefined within the RDBMS. The columns associated with the row property are generally of existing data types supported by an RDBMS. A row property may be invoked when the RDBMS processes a language statement that references the row property. When the row property is invoked, the RDBMS executes programming logic associated with the row property, in order to perform the advanced functional behavior using data stored in the associated columns.Type: ApplicationFiled: May 28, 2010Publication date: December 1, 2011Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: CURT L. COTNER, BALAKRISHNA R. IYER, KRISHNARAO G. KULKARNI, ROBERT W. LYLE
-
Publication number: 20110276584Abstract: Database systems are presented including: a database; a database instance of the database, where the database instance includes a set of instance database objects, and where the database instance is accessible by an instance user; and a database tenant associated with the database instance, where the database tenant includes a set of tenant database objects, where the database tenant provides access to the database instance by the tenant user, such that the instance user and the tenant user may independently access the database instance without affecting one another where each of the instance user and the tenant user are configured with independent accessibility. In some embodiments, systems further include: an instance production table associated with the database instance and a tenant production table associated with the database instance.Type: ApplicationFiled: May 10, 2010Publication date: November 10, 2011Applicant: International Business Machines CorporationInventors: Curt L. Cotner, Namik Hrle
-
Patent number: 7933948Abstract: In a system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.Type: GrantFiled: June 30, 2008Date of Patent: April 26, 2011Assignee: International Business Machines CorporationInventors: Paul M. Bird, William R. Bireley, Curt L. Cotner, Tammie Dang, Margaret A. Dong, Georgia C. Fuller, Michelle D. Lam, James W. Pickel, Frankie K. Sun
-
Patent number: 7899797Abstract: A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.Type: GrantFiled: December 4, 2003Date of Patent: March 1, 2011Assignee: International Business Machines CorporationInventors: Curt L. Cotner, Tammie Dang, Brian K. Howell, Fung Lee, Hui-An Lee, Charles H. Lin, Claire W. McFeely, Jennifer W. Ou, James W. Pickel, Jay A. Yothers
-
Patent number: 7716213Abstract: An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.Type: GrantFiled: April 26, 2007Date of Patent: May 11, 2010Assignee: International Business Machines CorporationInventors: Curt L. Cotner, Christopher M. Farrar, Robert T. Miller, Maryela E. Weihrauch
-
Publication number: 20100082630Abstract: Systems, methods, and computer program products to persist external index data in a database are disclosed. In an embodiment, a method includes maintaining a database including a first data table that is configured to store data in a database format and a second data table that is configured to store index data. The index data represents an index of a first portion of the first data table, and the index maintained externally to the database by an index manager. The method also includes generating a data update representing a modification to the first data table and communicating the data update to the index manager. The method further includes receiving index update data from the index manager representing a modification to the index as a result of the data update and applying the index update data to the second data table.Type: ApplicationFiled: September 29, 2008Publication date: April 1, 2010Applicant: International Business Machines CorporationInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, JR., Claus Kempfert
-
Patent number: 7661125Abstract: A system for establishing a connection between a data server and a middleware server is disclosed. The system includes defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The system also includes establishing the trusted context based on the validating the plurality of trust attributes.Type: GrantFiled: July 2, 2008Date of Patent: February 9, 2010Assignee: International Business Machines CorporationInventors: Paul M. Bird, Gayathiri R. Chandran, Curt L. Cotner, Adrian B. Lobo, James W. Pickel, Walid Rjaibi
-
Patent number: 7624119Abstract: A method for providing a timestamp for data in a database system, in which the database system operates in accordance with a database schema. The method includes providing a hidden timestamp column in a table in the database system, in which the hidden timestamp column includes a timestamp value for each row of data in the table. The timestamp value indicates a last time a corresponding row of data in the table was previously modified. The hidden timestamp column does not appear in the database schema by default and exposes the timestamp value for a given row of data in the table only to a query that calls the timestamp column by name.Type: GrantFiled: February 11, 2004Date of Patent: November 24, 2009Assignee: International Business Machines CorporationInventors: Yao-Ching Stephen Chen, Curt L. Cotner