-
公开(公告)号：US11139968B2
公开(公告)日：2021-10-05
申请号：US16733649
申请日：2020-01-03
发明人： Pedro M. Barbas , Joseph Duffy , Ken Maycock , David M. Tilson
IPC分类号： H04L29/06 , H04L9/08 , G06F21/60 , G06F11/14 , G06F21/62 , G06F16/182 , G06F3/06 , H04L29/08 , H04N21/2318 , H04L9/14 , H04L9/30 , G06C1/00
摘要： As disclosed herein a computer system for secure database backup and recovery in a secure database network has N distributed data nodes. The computer system includes program instructions that include instructions to receive a database backup file, fragment the file using a fragment engine, and associate each fragment with one node, where the fragment is not stored on the associated node. The program instructions further include instructions to encrypt each fragment using a first encryption key, and store, randomly, encrypted fragments on the distributed data nodes. The program instructions further include instructions to retrieve the encrypted fragments, decrypt the encrypted fragments using the first encryption key, re-encrypt the decrypted fragments using a different encryption key, and store, randomly, the re-encrypted fragments on the distributed data nodes. A computer program product and method corresponding to the above computer system are also disclosed herein.
-
公开(公告)号：US10198472B2
公开(公告)日：2019-02-05
申请号：US15177392
申请日：2016-06-09
发明人： Pedro M. Barbas , Peter J. Duffy , Lei Pan , David M. Tilson
IPC分类号： G06F17/30
摘要： In one embodiment, a method of processing a structured query language (SQL) statement is provided, comprising: determining whether a first query and a second query are equivalent, the first and second queries being respectively the left side and the right side operands of the OUTER JOIN operation; determining whether a SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation; and responsive to determining that the first query and the second query are equivalent and that the SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation, transforming the SQL statement into an optimized query SQL statement by removing the OUTER JOIN operation.
-
公开(公告)号：US10073866B2
公开(公告)日：2018-09-11
申请号：US15196202
申请日：2016-06-29
发明人： Pedro M. Barbas
CPC分类号： G06F16/21
摘要： Aspects of the present invention disclose a method, computer program product, and system for prioritizing test cases for relational database systems. The method includes identifying one or more data tables within a relational database. The method further includes identifying an exclusivity value for each of the one or more identified data tables. The method further includes calculating a table weight for each of the one or more identified data tables. The method further includes prioritizing the one or more identified data tables based on the respective calculated table weights. The method further includes identifying one or more sequences of database statements corresponding to the prioritized data tables, wherein a database statement is a command executed on one of the prioritized data tables. The method further includes prioritizing the one or more identified sequences based on the corresponding database statements.
-
公开(公告)号：US20180137114A1
公开(公告)日：2018-05-17
申请号：US15833339
申请日：2017-12-06
发明人： Pedro M. Barbas , Konrad Emanowicz , Gareth Jenkins , Enda McCallig , Lei Pan
摘要： Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.
-
公开(公告)号：US09916460B2
公开(公告)日：2018-03-13
申请号：US15338486
申请日：2016-10-31
发明人： Pedro M. Barbas , Joseph Duffy , Ken Maycock , David M. Tilson
CPC分类号： G06F21/602 , G06C1/00 , G06F11/1448 , G06F11/1464 , G06F21/6209 , G06F2201/80 , G06F2201/805 , G06F2221/2107 , H04L9/085 , H04L9/0861 , H04L9/0891 , H04L9/0894 , H04L9/14 , H04L9/30
摘要： As disclosed herein a computer system for secure database backup and recovery in a secure database network has N distributed data nodes. The computer system includes program instructions that include instructions to receive a database backup file, fragment the file using a fragment engine, and associate each fragment with one node, where the fragment is not stored on the associated node. The program instructions further include instructions to encrypt each fragment using a first encryption key, and store, randomly, encrypted fragments on the distributed data nodes. The program instructions further include instructions to retrieve the encrypted fragments, decrypt the encrypted fragments using the first encryption key, re-encrypt the decrypted fragments using a different encryption key, and store, randomly, the re-encrypted fragments on the distributed data nodes. A computer program product and method corresponding to the above computer system are also disclosed herein.
-
公开(公告)号：US09715594B2
公开(公告)日：2017-07-25
申请号：US14883905
申请日：2015-10-15
发明人： Pedro M. Barbas , Joseph Duffy , Ken Maycock , David M. Tilson
CPC分类号： G06F21/602 , G06C1/00 , G06F11/1448 , G06F11/1464 , G06F21/6209 , G06F2201/80 , G06F2201/805 , G06F2221/2107 , H04L9/085 , H04L9/0861 , H04L9/0891 , H04L9/0894 , H04L9/14 , H04L9/30
摘要： As disclosed herein a computer system for secure database backup and recovery in a secure database network has N distributed data nodes. The computer system includes program instructions that include instructions to receive a database backup file, fragment the file using a fragment engine, and associate each fragment with one node, where the fragment is not stored on the associated node. The program instructions further include instructions to encrypt each fragment using a first encryption key, and store, randomly, encrypted fragments on the distributed data nodes. The program instructions further include instructions to retrieve the encrypted fragments, decrypt the encrypted fragments using the first encryption key, re-encrypt the decrypted fragments using a different encryption key, and store, randomly, the re-encrypted fragments on the distributed data nodes. A computer program product and method corresponding to the above computer system are also disclosed herein.
-
公开(公告)号：US20170046521A1
公开(公告)日：2017-02-16
申请号：US15338486
申请日：2016-10-31
发明人： Pedro M. Barbas , Joseph Duffy , Ken Maycock , David M. Tilson
CPC分类号： G06F21/602 , G06C1/00 , G06F11/1448 , G06F11/1464 , G06F21/6209 , G06F2201/80 , G06F2201/805 , G06F2221/2107 , H04L9/085 , H04L9/0861 , H04L9/0891 , H04L9/0894 , H04L9/14 , H04L9/30
摘要： As disclosed herein a computer system for secure database backup and recovery in a secure database network has N distributed data nodes. The computer system includes program instructions that include instructions to receive a database backup file, fragment the file using a fragment engine, and associate each fragment with one node, where the fragment is not stored on the associated node. The program instructions further include instructions to encrypt each fragment using a first encryption key, and store, randomly, encrypted fragments on the distributed data nodes. The program instructions further include instructions to retrieve the encrypted fragments, decrypt the encrypted fragments using the first encryption key, re-encrypt the decrypted fragments using a different encryption key, and store, randomly, the re-encrypted fragments on the distributed data nodes. A computer program product and method corresponding to the above computer system are also disclosed herein.
摘要翻译： 如本文所公开的，用于在安全数据库网络中进行安全数据库备份和恢复的计算机系统具有N个分布式数据节点。 计算机系统包括程序指令，其包括接收数据库备份文件的指令，使用片段引擎对文件进行分片，并将每个片段与一个节点相关联，其中片段未存储在相关联的节点上。 程序指令还包括使用第一加密密钥加密每个片段的指令，并且在分布式数据节点上存储随机加密的片段。 程序指令还包括检索加密片段的指令，使用第一加密密钥对加密的片段进行解密，使用不同的加密密钥重新加密解密的片段，并且在分布式数据节点上随机存储重新加密的片段。 本文还公开了与上述计算机系统相对应的计算机程序产品和方法。
-
公开(公告)号：US20170031989A1
公开(公告)日：2017-02-02
申请号：US14814544
申请日：2015-07-31
发明人： Pedro M. Barbas , Peter J. Duffy , Lei Pan , David M. Tilson
IPC分类号： G06F17/30
CPC分类号： G06F17/30454
摘要： In one embodiment, a method of processing a structured query language (SQL) statement is provided, comprising: determining whether a first query and a second query are equivalent, the first and second queries being respectively the left side and the right side operands of the OUTER JOIN operation; determining whether a SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation; and responsive to determining that the first query and the second query are equivalent and that the SELECT output of the SQL statement does not refer to database columns from the left side of the OUTER JOIN operation which are not also partitioning columns of the OUTER JOIN operation, transforming the SQL statement into an optimized query SQL statement by removing the OUTER JOIN operation.
-
公开(公告)号：US20150227756A1
公开(公告)日：2015-08-13
申请号：US14618200
申请日：2015-02-10
发明人： Pedro M. Barbas
CPC分类号： G06F21/6227 , G06F17/30522 , G06F17/30867 , G06F21/604 , G06F2221/2141
摘要： One embodiment is a system for implementing context-aware access control of data in a relational database system. The system includes a memory having computer readable instructions and one or more processors for executing the computer readable instructions. According to the computer readable instructions, a request is received to access one or more tables of a database. Further according to the computer readable instructions, a context-aware access control, defined for at least a portion of the one or more tables, is identified. It is verified that the context-aware access control is satisfied. Access to the at least a portion of the one or more tables is permitted, responsive to verifying that the context-aware access control is satisfied.
摘要翻译： 一个实施例是用于在关系数据库系统中实现数据的上下文感知访问控制的系统。 该系统包括具有计算机可读指令的存储器和用于执行计算机可读指令的一个或多个处理器。 根据计算机可读指令，接收到访问数据库的一个或多个表的请求。 此外，根据计算机可读指令，识别为一个或多个表的至少一部分定义的上下文感知访问控制。 验证了上下文感知访问控制是否满足。 响应于验证是否满足上下文感知访问控制，允许对一个或多个表的至少一部分的访问。
-
公开(公告)号：US10860616B2
公开(公告)日：2020-12-08
申请号：US15173982
申请日：2016-06-06
发明人： Pedro M. Barbas , Konrad Emanowicz , Enda McCallig , Aslam F. Nomani , Lei Pan
摘要： As disclosed herein, a method includes receiving a plurality of datasets from a database, wherein each dataset comprises one or more data fields represented in a single data format, and wherein the data fields from at least two of the datasets are represented in different data formats, combining the plurality of datasets to provide a created data column corresponding to all of the data fields from the plurality of datasets, organizing the data column into data clusters, wherein each data cluster includes data fields represented in a single data format, and wherein each data field belongs to a data cluster, providing a key-value map referencing data fields with respect to their corresponding data formats, and verifying the database with respect to the created column. A corresponding computer program product and computer system are also disclosed.
-
-
-
-
-
-
-
-
-
搜索结果
41 条记录 (耗时 0.026 秒)
