专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20180096051A1 TEST DATA MANAGEMENT 审中-公开
公开(公告)号：US20180096051A1
公开(公告)日：2018-04-05
申请号：US15834180
申请日：2017-12-07
申请人： International Business Machines Corporation
发明人： Pedro M. Barbas , Konrad Emanowicz , Enda McCallig , Aslam F. Nomani , Lei Pan
IPC分类号： G06F17/30 , G06F11/36
CPC分类号： G06F16/285 , G06F11/3684 , G06F16/221 , G06F16/2237 , G06F16/2365
摘要： 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.

2. 发明授权

US09589019B2 Performance analysis of a database 有权
标题翻译：数据库的性能分析
公开(公告)号：US09589019B2
公开(公告)日：2017-03-07
申请号：US13887718
申请日：2013-05-06
申请人： International Business Machines Corporation
发明人： Austin Clifford , Konrad Emanowicz , Enda McCallig
IPC分类号： G06F7/00 , G06F17/30 , G06F11/34
CPC分类号： G06F17/30469 , G06F11/3409 , G06F11/3447 , G06F17/30294 , G06F2201/80
摘要： A method and system are provided for performance analysis of a database. The method includes receiving a proposed data model, generating a hypothetical query workload using a plurality of sample query templates representing different query constructs for the proposed data model, generating hypothetical optimizer statistics using predefined generating rules that include a projected cardinality for the proposed data model and creating a sample empty database and database schema using the proposed data model. The method also includes applying the hypothetical optimizer statistics to the sample empty database, based on generating the hypothetical optimizer statistics, applying each query construct of the hypothetical query workload to the database schema and estimating a cost of the hypothetical query workload for the proposed data model.
摘要翻译：提供了一种用于数据库性能分析的方法和系统。该方法包括接收所提出的数据模型，使用表示用于所提出的数据模型的不同查询结构的多个样本查询模板来生成假设查询工作负载，使用包括所提出的数据模型的预计基数的预定义生成规则生成假设优化器统计，以及使用提出的数据模型创建样本空数据库和数据库模式。该方法还包括将虚拟优化器统计信息应用于样本空数据库，基于生成假设的优化器统计信息，将假设查询工作负载的每个查询结构应用于数据库模式并估计所提出的数据模型的假设查询工作负载的成本。

3. 发明授权

US09471607B2 Data loading tool 有权
标题翻译：数据加载工具
公开(公告)号：US09471607B2
公开(公告)日：2016-10-18
申请号：US13966360
申请日：2013-08-14
申请人： International Business Machines Corporation
发明人： Sami Abed , Austin Clifford , Konrad Emanowicz , Gareth Jenkins
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F11/1451 , G06F17/30339 , G06F17/30424 , G06F2201/84
摘要： In an exemplary embodiment of this disclosure, a method for loading data from a backup image of a database includes selecting a subset statement defining a subset of the data in the database. Tables of the database are identified based on metadata of the database. A target database is written having the structure but not the data of the identified tables. One or more table statements are constructed, by a computer processor, defining a subset of each identified table based on the subset statement. Selected data is unloaded from a backup image into the target database using respective table statements as filters.
摘要翻译：在本公开的示例性实施例中，用于从数据库的备份映像加载数据的方法包括选择定义数据库中的数据子集的子集语句。基于数据库的元数据来识别数据库的表。写入目标数据库具有结构但不具有所识别的表的数据。一个或多个表语句由计算机处理器基于子集语句来定义每个识别的表的子集。使用相应的表语句作为过滤器，将所选数据从备份映像卸载到目标数据库中。

4. 发明授权

US09465840B2 Dynamically indentifying and preventing skewed partitions in a shared-nothing database 有权
标题翻译：在无共享数据库中动态识别和防止偏斜的分区
公开(公告)号：US09465840B2
公开(公告)日：2016-10-11
申请号：US14210505
申请日：2014-03-14
申请人： International Business Machines Corporation
发明人： Austin Clifford , Konrad Emanowicz , Enda McCallig
IPC分类号： G06F17/30
CPC分类号： G06F17/30454 , G06F17/30339 , G06F17/30445 , G06F17/30584 , G06F17/30864
摘要： Dynamically identifying and preventing skewed partitions in a shared-nothing database is provided. The database management system software receives a parameter for identifying a threshold value associated with at least one distribution key value. Optimizer statistics are gathered on a first table that is distributed across one or more partitions in the shared-nothing database, wherein the first table includes a first table name. Distribution key skew is identified based on the gathered optimizer statistics indicating the threshold value being exceeded. A second table with an alternate distribution key, is created having a second table name for receiving overflow data rows associated with the at least one distribution key value based on the identified distribution key skew. A union all view is created based on the first and the second table.
摘要翻译：提供动态识别和防止无共享数据库中的偏斜分区。数据库管理系统软件接收用于识别与至少一个分配密钥值相关联的阈值的参数。优化器统计信息被收集在分布在无共享数据库中的一个或多个分区上的第一表上，其中第一表包括第一表名。基于收集的优化器统计信息来指定分配密钥偏移量，该统计信息指示超过阈值。创建具有备用分发密钥的第二表，其具有第二表名称，用于基于所识别的分配密钥偏移来接收与所述至少一个分发密钥值相关联的溢出数据行。联合所有视图都是基于第一个和第二个表创建的。

5. 发明申请

US20140059026A1 TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING USING UNIQUE COMMON FACTOR SEQUENCING 有权
标题翻译：使用统一通用因子序列的数据库测试的测试数据生成和定标
公开(公告)号：US20140059026A1
公开(公告)日：2014-02-27
申请号：US13974717
申请日：2013-08-23
申请人： International Business Machines Corporation
发明人： Austin Clifford , Konrad Emanowicz , Enda McCallig , Gary Murtagh , Clare Scally
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F11/3684 , G06F17/30289 , G06F17/30306
摘要： Embodiments of the present invention provide a system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a computer program product for test data generation using unique common factor sequencing is provided. The computer program product includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers.
摘要翻译：本发明的实施例提供了一种用于使用独特的共同因子测序的测试数据生成的系统和计算机程序产品。在本发明的一个实施例中，提供了一种使用独特的共同因素测序的用于测试数据生成的计算机程序产品。计算机程序产品包括在计算机存储器中执行的测试数据生成工具中加载具有测试数据的人口的表。可以选择与表的键相关联的表中的多列的列集合用于处理，并且将不同的基数序列值分配给集合中的列，使得基数序列值不共享除了统一的共同因素作为在素数的情况下。

6. 发明授权

US10657287B2 Identification of pseudonymized data within data sources 有权
公开(公告)号：US10657287B2
公开(公告)日：2020-05-19
申请号：US15800405
申请日：2017-11-01
申请人： International Business Machines Corporation
发明人： Pedro Barbas , Austin Clifford , Konrad Emanowicz , Patrick G. O'Sullivan
IPC分类号： G06F21/62 , H04L9/00
摘要： A computer-implemented method, computer program product and system for identifying pseudonymized data within data sources. One or more data repositories within one or more of the data sources are selected. One or more privacy data models are provided, where each of the privacy data models includes pattern(s) and/or parameter(s). One or more of the one or more privacy data models are selected. Data identification information is generated, where the data identification information indicates a presence or absence of pseudonymized data and of non-pseudonymized data within the one or more of the data sources. The data identification information is generated utilizing the pattern(s) and/or the parameter(s) to determine pseudonymized data.

7. 发明申请

US20190130132A1 RUNTIME CONTROL OF AUTOMATION ACCURACY USING ADJUSTABLE THRESHOLDS 审中-公开
公开(公告)号：US20190130132A1
公开(公告)日：2019-05-02
申请号：US15800405
申请日：2017-11-01
申请人： International Business Machines Corporation
发明人： Pedro Barbas , Austin Clifford , Konrad Emanowicz , Patrick G. O'Sullivan
IPC分类号： G06F21/62
摘要： A computer-implemented method, computer program product and system for identifying pseudonymized data within data sources. One or more data repositories within one or more of the data sources are selected. One or more privacy data models are provided, where each of the privacy data models includes pattern(s) and/or parameter(s). One or more of the one or more privacy data models are selected. Data identification information is generated, where the data identification information indicates a presence or absence of pseudonymized data and of non-pseudonymized data within the one or more of the data sources. The data identification information is generated utilizing the pattern(s) and/or the parameter(s) to determine pseudonymized data.

8. 发明申请

US20180137114A1 DATA MIGRATION IN A NETWORKED COMPUTER ENVIRONMENT 审中-公开
公开(公告)号：US20180137114A1
公开(公告)日：2018-05-17
申请号：US15833339
申请日：2017-12-06
申请人： International Business Machines Corporation
发明人： Pedro M. Barbas , Konrad Emanowicz , Gareth Jenkins , Enda McCallig , Lei Pan
IPC分类号： G06F17/30 , H04L29/08
摘要： 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.

9. 发明申请

US20150261840A1 DYNAMICALLY INDENTIFYING AND PREVENTING SKEWED PARTITIONS IN A SHARED-NOTHING DATABASE 有权
标题翻译：动态地标记和预防在无数据库中进行的划分的划分
公开(公告)号：US20150261840A1
公开(公告)日：2015-09-17
申请号：US14535566
申请日：2014-11-07
申请人： International Business Machines Corporation
发明人： Austin Clifford , Konrad Emanowicz , Enda McCallig
IPC分类号： G06F17/30
CPC分类号： G06F17/30454 , G06F17/30339 , G06F17/30445 , G06F17/30584 , G06F17/30864
摘要： Dynamically identifying and preventing skewed partitions in a shared-nothing database is provided. The database management system software receives a parameter for identifying a threshold value associated with at least one distribution key value. Optimizer statistics are gathered on a first table that is distributed across one or more partitions in the shared-nothing database, wherein the first table includes a first table name. Distribution key skew is identified based on the gathered optimizer statistics indicating the threshold value being exceeded. A second table with an alternate distribution key, is created having a second table name for receiving overflow data rows associated with the at least one distribution key value based on the identified distribution key skew. A union all view is created based on the first and the second table.
摘要翻译：提供动态识别和防止无共享数据库中的偏斜分区。数据库管理系统软件接收用于识别与至少一个分配密钥值相关联的阈值的参数。优化器统计信息被收集在分布在无共享数据库中的一个或多个分区上的第一表上，其中第一表包括第一表名。基于收集的优化器统计信息来指定分配密钥偏移量，该统计信息指示超过阈值。创建具有备用分发密钥的第二表，其具有第二表名称，用于基于所识别的分配密钥偏移来接收与所述至少一个分配密钥值相关联的溢出数据行。联合所有视图都是基于第一个和第二个表创建的。

10. 发明申请

US20140059086A1 TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING USING UNIQUE COMMON FACTOR SEQUENCING 有权
公开(公告)号：US20140059086A1
公开(公告)日：2014-02-27
申请号：US13974623
申请日：2013-08-23
申请人： International Business Machines Corporation
发明人： Austin Clifford , Konrad Emanowicz , Enda McCallig , Gary Murtagh , Clare Scally
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F11/3684 , G06F17/30289 , G06F17/30306
摘要： Embodiments of the present invention provide a system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a computer program product for test data generation using unique common factor sequencing is provided. The computer program product includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式