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

1. 发明授权

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.
摘要翻译：在本公开的示例性实施例中，用于从数据库的备份映像加载数据的方法包括选择定义数据库中的数据子集的子集语句。基于数据库的元数据来识别数据库的表。写入目标数据库具有结构但不具有所识别的表的数据。一个或多个表语句由计算机处理器基于子集语句来定义每个识别的表的子集。使用相应的表语句作为过滤器，将所选数据从备份映像卸载到目标数据库中。

2. 发明申请

US20190095461A1 COLUMNAR DATABASE COMPRESSION 审中-公开
公开(公告)号：US20190095461A1
公开(公告)日：2019-03-28
申请号：US16203650
申请日：2018-11-29
申请人： International Business Machines Corporation
发明人： Sami Abed , Pedro Barbas , Austin Clifford , Konrad Emanowicz
IPC分类号： G06F17/30
摘要： Disclosed is an approach comprising a column partitioned into a plurality of partitions including an empty partition and a plurality of filled partitions each comprising data entries associated with a set of parameters having parameter values, the data entries compressed in accordance with a compression dictionary. The approach comprises receiving forecasted parameter values for an expected set of data entries to be stored in an empty partition; predicting a recurrence frequency of the data entries in the expected set using the forecasted parameter values by evaluating the respective compression dictionaries of the filled partitions with a machine learning algorithm; generating a predictive compression dictionary for the expected set of data entries based on the predicted recurrence frequency of the data entries in the expected set; receiving the expected set of data entries; and compressing at least part of the received expected set of data entries using the predictive compression dictionary.

3. 发明授权

US11036684B2 Columnar database compression 有权
公开(公告)号：US11036684B2
公开(公告)日：2021-06-15
申请号：US16203650
申请日：2018-11-29
申请人： International Business Machines Corporation
发明人： Sami Abed , Pedro Barbas , Austin Clifford , Konrad Emanowicz
IPC分类号： G06F17/00 , G06F16/174 , G06F16/22 , G06F16/27 , G06F16/2457 , G06N20/00
摘要： Disclosed is an approach comprising a column partitioned into a plurality of partitions including an empty partition and a plurality of filled partitions each comprising data entries associated with a set of parameters having parameter values, the data entries compressed in accordance with a compression dictionary. The approach comprises receiving forecasted parameter values for an expected set of data entries to be stored in an empty partition; predicting a recurrence frequency of the data entries in the expected set using the forecasted parameter values by evaluating the respective compression dictionaries of the filled partitions with a machine learning algorithm; generating a predictive compression dictionary for the expected set of data entries based on the predicted recurrence frequency of the data entries in the expected set; receiving the expected set of data entries; and compressing at least part of the received expected set of data entries using the predictive compression dictionary.

4. 发明授权

US10169361B2 Columnar database compression 有权
公开(公告)号：US10169361B2
公开(公告)日：2019-01-01
申请号：US14942772
申请日：2015-11-16
申请人： International Business Machines Corporation
发明人： Sami Abed , Pedro M Barbas , Austin Clifford , Konrad Emanowicz
IPC分类号： G06F17/30 , G06N99/00
摘要： Disclosed is a computer-implemented method of compressing data in a columnar database comprising at least one column partitioned into a plurality of partitions including at least one empty partition and a plurality of filled partitions each comprising data entries associated with a set of parameters having parameter values relevant to the recurrence frequency of the data entry in the partition, the data entries being compressed in accordance with a compression dictionary based on the respective recurrence frequencies of the data entries in the filled partition. The computer-implemented method comprises receiving forecasted parameter values for the set of parameters for an expected set of data entries to be stored in an empty partition of the column; predicting a recurrence frequency of the data entries in the expected set using the forecasted parameter values by evaluating the respective compression dictionaries of the filled partitions with a machine learning algorithm; generating a predictive compression dictionary for the expected set of data entries based on the predicted recurrence frequency of the data entries in the expected set; receiving the expected set of data entries; and compressing at least part of the received expected set of data entries using the predictive compression dictionary. A computer program product and a computer system for implementing such a method are also disclosed.

5. 发明授权

US09773027B2 Data loading tool 有权
公开(公告)号：US09773027B2
公开(公告)日：2017-09-26
申请号：US14851184
申请日：2015-09-11
申请人： International Business Machines Corporation
发明人： Sami Abed , Austin Clifford , Konrad Emanowicz , Gareth Jenkins
IPC分类号： G06F17/30 , G06F11/14
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.

6. 发明申请

US20170139947A1 COLUMNAR DATABASE COMPRESSION 审中-公开
公开(公告)号：US20170139947A1
公开(公告)日：2017-05-18
申请号：US14942772
申请日：2015-11-16
申请人： International Business Machines Corporation
发明人： Sami Abed , Pedro M. Barbas , Austin Clifford , Konrad Emanowicz
IPC分类号： G06F17/30 , G06N5/04 , G06N99/00
CPC分类号： G06F17/30153 , G06F17/30315 , G06F17/3053 , G06F17/30584 , G06N99/005
摘要： Disclosed is a computer-implemented method of compressing data in a columnar database comprising at least one column partitioned into a plurality of partitions including at least one empty partition and a plurality of filled partitions each comprising data entries associated with a set of parameters having parameter values relevant to the recurrence frequency of the data entry in the partition, the data entries being compressed in accordance with a compression dictionary based on the respective recurrence frequencies of the data entries in the filled partition. The computer-implemented method comprises receiving forecasted parameter values for the set of parameters for an expected set of data entries to be stored in an empty partition of the column; predicting a recurrence frequency of the data entries in the expected set using the forecasted parameter values by evaluating the respective compression dictionaries of the filled partitions with a machine learning algorithm; generating a predictive compression dictionary for the expected set of data entries based on the predicted recurrence frequency of the data entries in the expected set; receiving the expected set of data entries; and compressing at least part of the received expected set of data entries using the predictive compression dictionary. A computer program product and a computer system for implementing such a method are also disclosed.

7. 发明申请

US20160188418A1 DATA LOADING TOOL 有权
标题翻译：数据加载工具
公开(公告)号：US20160188418A1
公开(公告)日：2016-06-30
申请号：US14851184
申请日：2015-09-11
申请人： International Business Machines Corporation
发明人： Sami Abed , Austin Clifford , Konrad Emanowicz , Gareth Jenkins
IPC分类号： G06F11/14 , 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.
摘要翻译：在本公开的示例性实施例中，用于从数据库的备份映像加载数据的方法包括选择定义数据库中的数据子集的子集语句。基于数据库的元数据来识别数据库的表。写入目标数据库具有结构但不具有所识别的表的数据。一个或多个表语句由计算机处理器基于子集语句来定义每个识别的表的子集。使用相应的表语句作为过滤器，将所选数据从备份映像卸载到目标数据库中。

8. 发明申请

US20140114924A1 DATA LOADING TOOL 有权
标题翻译：数据加载工具
公开(公告)号：US20140114924A1
公开(公告)日：2014-04-24
申请号：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.
摘要翻译：在本公开的示例性实施例中，用于从数据库的备份映像加载数据的方法包括选择定义数据库中的数据子集的子集语句。基于数据库的元数据来识别数据库的表。写入目标数据库具有结构但不具有所识别的表的数据。一个或多个表语句由计算机处理器基于子集语句来定义每个识别的表的子集。使用相应的表语句作为过滤器，将所选数据从备份映像卸载到目标数据库中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式