Patents by Inventor Gerald George Kiernan
Gerald George Kiernan 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: 7890774Abstract: A system, method, computer program product, and data management service that allows any comparison operation to be applied on encrypted data, without first decrypting the operands. The encryption scheme of the invention allows equality and range queries as well as the aggregation operations of MAX, MIN, and COUNT. The GROUPBY and ORDERBY operations can also be directly applied. Query results produced using the invention are sound and complete, the invention is robust against cryptanalysis, and its security strictly relies on the choice of a private key. Order-preserving encryption allows standard database indexes to be built over encrypted tables. The invention can easily be integrated with existing systems.Type: GrantFiled: May 29, 2008Date of Patent: February 15, 2011Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Gerald George Kiernan
-
Patent number: 7873840Abstract: A system, method, and computer program product to automatically eliminate the distribution information available for reconstruction from a disguised dataset. The invention flattens input numerical values into a substantially uniformly distributed dataset, then maps the uniformly distributed dataset into equivalent data in a target distribution. The invention allows the incremental encryption of new values in an encrypted database while leaving existing encrypted values unchanged. The flattening comprises (1) partitioning, (2) mapping, and (3) saving auxiliary information about the data processing, which is encrypted and not updated. The partitioning is MDL based, and includes a growth phase for dividing a space into fine partitions and a prune phase for merging some partitions together.Type: GrantFiled: July 2, 2008Date of Patent: January 18, 2011Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Gerald George Kiernan, Srikant Ramakrishnan, Yirong Xu
-
Patent number: 7810142Abstract: An auditing framework for determining whether a database disclosure of information adhered to its data disclosure policies. Users formulate audit expressions to specify the (sensitive) data subject to disclosure review. An audit component accepts audit expressions and returns all queries (deemed “suspicious”) that accessed the specified data during their execution.Type: GrantFiled: March 21, 2005Date of Patent: October 5, 2010Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Roberto Bayardo, Christos Faloutsos, Gerald George Kiernan, Ralf Rantzau, Ramakrishnan Srikant
-
Patent number: 7752446Abstract: A method and system for enhancing security in a database by establishing a bit pattern using secret information, the pattern establishing a watermark that can be detected in a copy (authorized or not) of the database only by using the secret information.Type: GrantFiled: May 15, 2002Date of Patent: July 6, 2010Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Gerald George Kiernan
-
Publication number: 20090327748Abstract: A system, method, computer program product, and data management service that allows any comparison operation to be applied on encrypted data, without first decrypting the operands. The encryption scheme of the invention allows equality and range queries as well as the aggregation operations of MAX, MIN, and COUNT. The GROUPBY and ORDERBY operations can also be directly applied. Query results produced using the invention are sound and complete, the invention is robust against cryptanalysis, and its security strictly relies on the choice of a private key. Order-preserving encryption allows standard database indexes to be built over encrypted tables. The invention can easily be integrated with existing systems.Type: ApplicationFiled: May 29, 2008Publication date: December 31, 2009Applicant: International Business Machines Corp.Inventors: Rakesh Agrawal, Gerald George Kiernan
-
Publication number: 20080282096Abstract: A system, method, and computer program product to automatically eliminate the distribution information available for reconstruction from a disguised dataset. The invention flattens input numerical values into a substantially uniformly distributed dataset, then maps the uniformly distributed dataset into equivalent data in a target distribution. The invention allows the incremental encryption of new values in an encrypted database while leaving existing encrypted values unchanged. The flattening comprises (1) partitioning, (2) mapping, and (3) saving auxiliary information about the data processing, which is encrypted and not updated. The partitioning is MDL based, and includes a growth phase for dividing a space into fine partitions and a prune phase for merging some partitions together.Type: ApplicationFiled: July 2, 2008Publication date: November 13, 2008Inventors: Rakesh Agrawal, Gerald George Kiernan, Srikant Ramakrishnan, Yirong Xu
-
Patent number: 7440937Abstract: A query optimization technique that determines whether a query includes a self join that is transitively derived through table expressions having UNION operators. If so, the query is simplified to eliminate the table expressions and to reduce the query to an equivalent query over tables.Type: GrantFiled: July 28, 2006Date of Patent: October 21, 2008Assignee: International Business Machines CorporationInventors: Gerald George Kiernan, Jayavel Shanmugasundaram
-
Publication number: 20080243524Abstract: A computer-based system and method to enforce, monitor, and assess internal controls over financial reporting is provided. A bottom-up approach is used to model transaction-control workflows using logs of past transaction activity executions. Past workflows are reconstructed from these logs and reconstruction rules. The transaction-control workflows are compared with these reconstructed past workflows to determine whether transactions are compliant with the internal controls.Type: ApplicationFiled: March 28, 2007Publication date: October 2, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Rakesh Agrawal, Christopher Johnson, Gerald George Kiernan, Frank Leymann
-
Patent number: 7426752Abstract: A system, method, and computer program product to automatically eliminate the distribution information available for reconstruction from a disguised dataset. The invention flattens input numerical values into a substantially uniformly distributed dataset, then maps the uniformly distributed dataset into equivalent data in a target distribution. The invention allows the incremental encryption of new values in an encrypted database while leaving existing encrypted values unchanged. The flattening comprises (1) partitioning, (2) mapping, and (3) saving auxiliary information about the data processing, which is encrypted and not updated. The partitioning is MDL based, and includes a growth phase for dividing a space into fine partitions and a prune phase for merging some partitions together.Type: GrantFiled: January 5, 2004Date of Patent: September 16, 2008Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Gerald George Kiernan, Ramakrishnan Srikant, Yirong Xu
-
Patent number: 7395437Abstract: A system, method, computer program product, and data management service that allows any comparison operation to be applied on encrypted data, without first decrypting the operands. The encryption scheme of the invention allows equality and range queries as well as the aggregation operations of MAX, MIN, and COUNT. The GROUPBY and ORDERBY operations can also be directly applied. Query results produced using the invention are sound and complete, the invention is robust against cryptanalysis, and its security strictly relies on the choice of a private key. Order-preserving encryption allows standard database indexes to be built over encrypted tables. The invention can easily be integrated with existing systems.Type: GrantFiled: January 5, 2004Date of Patent: July 1, 2008Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Gerald George Kiernan
-
Patent number: 7243097Abstract: A method of transforming relational database management systems into their privacy-preserving equivalents is provided. Language constructs allow fine grained access control (FGAC) restrictions to be specified on the access to data in a table at the level of a row, a column or a cell. Fine grained restrictions are a combination of access control and privacy policy restrictions, which ensure compliance with current privacy legislation mandates.Type: GrantFiled: February 21, 2006Date of Patent: July 10, 2007Assignee: International Business Machines CorporationInventors: Rakesh Agrawal, Paul Miller Bird, Tyrone W. A. Grandison, Gerald George Kiernan, Scott Ian Logan, Walid Rjaibi
-
Patent number: 7107255Abstract: A query optimization technique that determines whether a query includes a self join that is transitively derived through table expressions having UNION operators. If so, the query is simplified to eliminate the table expressions and to reduce the query to an equivalent query over tables.Type: GrantFiled: June 21, 2001Date of Patent: September 12, 2006Assignee: International Business Machines CorporationInventors: Gerald George Kiernan, Jayavel Shanmugasundaram
-
Patent number: 6934712Abstract: A method for publishing relational data as XML by translating XML queries into queries against a relational database. Conversion of the relational database into an XML database is not required. Each relational table is mapped to a virtual XML document, and XML queries are issued over these virtual documents. An XML query is parsed and transformed into a language-neutral intermediate representation, which is a sequence of operations describing how the output document is derived from the underlying relational tables. The intermediate representation is then translated into an SQL query over the underlying relational tables. The intermediate representation is also used to generate a tagger graph, which the tagger runtime ‘walks’ to generate the tagged, structured XML output. Each of the nodes of the tagger graph are operators which perform processing on the results of the SQL query. The SQL query is executed, and the SQL query results are then provided to the tagger.Type: GrantFiled: March 19, 2001Date of Patent: August 23, 2005Assignee: International Business Machines CorporationInventors: Gerald George Kiernan, Jayavel Shanmugasundaram, Eugene Jon Shekita
-
Publication number: 20050147240Abstract: A system, method, and computer program product to automatically eliminate the distribution information available for reconstruction from a disguised dataset. The invention flattens input numerical values into a substantially uniformly distributed dataset, then maps the uniformly distributed dataset into equivalent data in a target distribution. The invention allows the incremental encryption of new values in an encrypted database while leaving existing encrypted values unchanged. The flattening comprises (1) partitioning, (2) mapping, and (3) saving auxiliary information about the data processing, which is encrypted and not updated. The partitioning is MDL based, and includes a growth phase for dividing a space into fine partitions and a prune phase for merging some partitions together.Type: ApplicationFiled: January 5, 2004Publication date: July 7, 2005Inventors: Rakesh Agrawal, Gerald George Kiernan, Ramakrishnan Srikant, Yirong Xu
-
Patent number: 6721730Abstract: A query optimization technique that determines whether any column from a right quantifier of a left outer join query is projected out of the query. If not, then all predicates in an ON clause are removed from the left outer join query, the right quantifier is removed from the left outer join query, and the left outer join query is converted to a simple select query. A number of steps are performed to determine whether any of the columns quantified by the right quantifier participate in a projection list of the query. A set of equivalence class columns is computed for the query, wherein the equivalence classes are derived from equi-join predicates in the query. A set of columns quantified by the right quantifier across the computed set of equivalence classes is computed. A determination is made whether a subset of the set of columns form a key for the right quantifier. If the right quantifier columns are not projected out of the query, then the optimization may be performed.Type: GrantFiled: June 21, 2001Date of Patent: April 13, 2004Assignee: International Business Machines CorporationInventors: Gerald George Kiernan, Jayavel Shanmugasundaram
-
Publication number: 20030217272Abstract: A method and system for enhancing security in a database by establishing a bit pattern using secret information, the pattern establishing a watermark that can be detected in a copy (authorized or not) of the database only by using the secret information.Type: ApplicationFiled: May 15, 2002Publication date: November 20, 2003Applicant: International Business Machines CorporationInventors: Rakesh Agrawal, Gerald George Kiernan
-
Patent number: 6574639Abstract: A method, apparatus, and article of manufacture for a computer-implemented technique for query optimization with deferred updates and autonomous sources. An object-oriented query is executed to retrieve data from a database. The database is stored on a data storage device connected to a computer. The object-oriented query is transformed into subqueries, wherein at least one subquery is directed against a database, and wherein one subquery is directed against an object cache. Each subquery that is directed against a database is executed to retrieve data from the database into the object cache. The subquery that is directed against the object cache is executed to retrieve data for the query, wherein the data incorporates updates to the object cache and updates to the database.Type: GrantFiled: June 27, 2001Date of Patent: June 3, 2003Assignee: International Business Machines CorporationInventors: Michael James Carey, Gerald George Kiernan
-
Publication number: 20030009450Abstract: A query optimization technique that determines whether any column from a right quantifier of a left outer join query is projected out of the query. If not, then all predicates in an ON clause are removed from the left outer join query, the right quantifier is removed from the left outer join query, and the left outer join query is converted to a simple select query. A number of steps are performed to determine whether any of the columns quantified by the right quantifier participate in a projection list of the query. A set of equivalence class columns is computed for the query, wherein the equivalence classes are derived from equi-join predicates in the query. A set of columns quantified by the right quantifier across the computed set of equivalence classes is computed. A determination is made whether a subset of the set of columns form a key for the right quantifier. If the right quantifier columns are not projected out of the query, then the optimization may be performed.Type: ApplicationFiled: June 21, 2001Publication date: January 9, 2003Applicant: International Business Machines CorporationInventors: Gerald George Kiernan, Jayavel Shanmugasundaram
-
Publication number: 20020198726Abstract: A query optimization technique that determines whether a query includes a self join that is transitively derived through table expressions having UNION operators. If so, the query is simplified to eliminate the table expressions and to reduce the query to an equivalent query over tables.Type: ApplicationFiled: June 21, 2001Publication date: December 26, 2002Applicant: International Business Machines CorporationInventors: Gerald George Kiernan, Jayavel Shanmugasundaram
-
Patent number: 6457020Abstract: A method, apparatus, and article of manufacture for a computer-implemented technique for query optimization using a multi-layered object cache. An object-oriented query is executed to retrieve data from a database. The database is stored on a data storage device connected to a computer and queries are run against lower cache layers which have better performance characteristics than the external or upper layers. The multi-layered cache has an application objects (AOs) cache and a data access objects (DAOs) cache, and the application objects include methods deriving data from DAOs. The method includes a step of rewriting the query into a query directed against the DAOs cache, applying a pushdown transformation algorithm to the rewritten query directed against the DAOs cache, and executing the transformed query against the DAOs cache. The method also allows optimizing queries with path expressions by transforming path expression into joins.Type: GrantFiled: March 20, 2000Date of Patent: September 24, 2002Assignee: International Business Machines CorporationInventors: Michael James Carey, Gerald George Kiernan