-
1.发明申请公开(公告)号：US20180225090A1
公开(公告)日：2018-08-09
申请号：US15943748
申请日：2018-04-03
发明人： Rini Kaushik
CPC分类号： G06F7/24 , G06F12/0246 , G06F17/30315 , G06F17/30519 , G06F2212/1044 , G06F2212/7208
摘要： A technique relates to flash-optimized data layout of a dataset for queries. Selection columns are stored in flash memory according to a selection optimized layout, where the selection optimized layout is configured to optimize predicate matching and data skipping. The selection optimized layout, for each selection column, is formed by storing a selection column dictionary filled with unique data values in a given selection column, where the unique data values are stored in sorted order in the selection column dictionary. Row position designations are stored corresponding to each row position that the unique data values are present within the given selection column, without duplicating storage of any of the unique data values that occur more than once in the given selection column.
-
公开(公告)号：US10037501B2
公开(公告)日：2018-07-31
申请号：US14132920
申请日：2013-12-18
发明人： Rini Kaushik
CPC分类号： G06Q10/06312 , G06Q10/04 , G06Q50/06
摘要： A method and computer program product for managing energy management costs of a data center is disclosed. The method and computer program product include computing an energy cost estimate based on available energy rates which include wholesale electricity prices for periods of time of an hour. Embodiments of the method and computer program product include establishing fees for processing jobs. The fees are based on at least one wholesale electricity price. Embodiments of the method and computer program product include processing jobs based on scheduling-factors. Example scheduling-factors include factors related to timing, duration, environment, cost, or priority.
-
公开(公告)号：US20150170080A1
公开(公告)日：2015-06-18
申请号：US14132920
申请日：2013-12-18
发明人： Rini Kaushik
CPC分类号： G06Q10/06312 , G06Q50/06
摘要： A method and computer program product for managing energy management costs of a data center is disclosed. The method and computer program product include computing an energy cost estimate based on available energy rates which include wholesale electricity prices for periods of time of an hour. Embodiments of the method and computer program product include establishing fees for processing jobs. The fees are based on at least one wholesale electricity price. Embodiments of the method and computer program product include processing jobs based on scheduling-factors. Example scheduling-factors include factors related to timing, duration, environment, cost, or priority.
摘要翻译： 公开了一种用于管理数据中心的能量管理成本的方法和计算机程序产品。 该方法和计算机程序产品包括基于可用的能量速率来计算能量成本估计，其包括一小时的批发电价格。 该方法和计算机程序产品的实施例包括建立处理作业的费用。 费用至少是批发电价。 该方法和计算机程序产品的实施例包括基于调度因素的处理作业。 示例调度因素包括与时间，持续时间，环境，成本或优先级相关的因素。
-
4.发明授权公开(公告)号：US10048937B2
公开(公告)日：2018-08-14
申请号：US15693513
申请日：2017-09-01
发明人： Rini Kaushik
摘要： A technique relates to flash-optimized data layout of a dataset for queries. Selection columns are stored in flash memory according to a selection optimized layout, where the selection optimized layout is configured to optimize predicate matching and data skipping. The selection optimized layout, for each selection column, is formed by storing a selection column dictionary filled with unique data values in a given selection column, where the unique data values are stored in sorted order in the selection column dictionary. Row position designations are stored corresponding to each row position that the unique data values are present within the given selection column, without duplicating storage of any of the unique data values that occur more than once in the given selection column.
-
公开(公告)号：US20150363443A1
公开(公告)日：2015-12-17
申请号：US14305061
申请日：2014-06-16
发明人： Rini Kaushik
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30144 , G06F17/3053 , G06F17/30864
摘要： Methods and arrangements for predictively placing columns of a large database in a multi-tier storage system. Aspects include receiving a database to be stored in the multi-tier storage system, wherein the database comprises a plurality of columns and the multi-tier storage system comprises at least two storage devices and evaluating one or more attributes of each of the plurality of columns of the database. Aspects also include storing each of the plurality of columns of the database on one of the at least two storage devices, wherein a determination of which of the at least two storage devices to store each of the plurality of columns is based on the one or more attributes of each of the columns, a predictive model based on the weighted columnar relationship graph, and the characteristics of the storage devices.
摘要翻译： 在多层存储系统中预测性地放置大型数据库的列的方法和安排。 方面包括接收要存储在多层存储系统中的数据库，其中所述数据库包括多个列，并且所述多层存储系统包括至少两个存储设备并评估所述多个列中的每一个的一个或多个属性 的数据库。 方面还包括将所述数据库的多个列中的每一列存储在所述至少两个存储设备中的一个上，其中所述至少两个存储设备中的哪一个存储多个列中的每一个的确定是基于所述一个或多个 每个列的属性，基于加权柱状关系图的预测模型和存储设备的特性。
-
6.发明申请FLASH OPTIMIZED COLUMNAR DATA LAYOUT AND DATA ACCESS ALGORITHMS FOR BIG DATA QUERY ENGINES 有权用于大数据查询引擎的闪存优化列数据布局和数据访问算法公开(公告)号：US20150363167A1
公开(公告)日：2015-12-17
申请号：US14305179
申请日：2014-06-16
发明人： Rini Kaushik
CPC分类号： G06F7/24 , G06F12/0246 , G06F17/30315 , G06F17/30519 , G06F2212/1044 , G06F2212/7208
摘要： A technique relates to flash-optimized data layout of a dataset for queries. Selection columns are stored in flash memory according to a selection optimized layout, where the selection optimized layout is configured to optimize predicate matching and data skipping. The selection optimized layout, for each selection column, is formed by storing a selection column dictionary filled with unique data values in a given selection column, where the unique data values are stored in sorted order in the selection column dictionary. Row position designations are stored corresponding to each row position that the unique data values are present within the given selection column, without duplicating storage of any of the unique data values that occur more than once in the given selection column.
摘要翻译： 一种技术涉及用于查询的数据集的闪存优化数据布局。 选择列根据选择优化的布局存储在闪存中，其中选择优化布局被配置为优化谓词匹配和数据跳过。 通过在给定的选择列中存储填充有唯一数据值的选择列字典来形成针对每个选择列的选择优化布局，其中唯一数据值以排序顺序存储在选择列字典中。 行位置指定对应于独特数据值存在于给定选择列中的每个行位置，而不复制在给定选择列中多于一次出现的任何唯一数据值的存储。
-
公开(公告)号：US10558399B2
公开(公告)日：2020-02-11
申请号：US15904190
申请日：2018-02-23
发明人： Rini Kaushik
摘要： A method includes separating a file into multiple blocks. Each block of the multiple blocks are separated into at least two correlated sub-blocks. Intra-file block organized storage placement on different types of memory devices is determined for the at least two correlated sub-blocks in a file system metadata layout. The intra-file block organized storage placement is based on a predictive column data block placement model that considers multiple attributes of column data blocks.
-
8.发明授权公开(公告)号：US10162598B2
公开(公告)日：2018-12-25
申请号：US15943748
申请日：2018-04-03
发明人： Rini Kaushik
摘要： A technique relates to flash-optimized data layout of a dataset for queries. Selection columns are stored in flash memory according to a selection optimized layout, where the selection optimized layout is configured to optimize predicate matching and data skipping. The selection optimized layout, for each selection column, is formed by storing a selection column dictionary filled with unique data values in a given selection column, where the unique data values are stored in sorted order in the selection column dictionary. Row position designations are stored corresponding to each row position that the unique data values are present within the given selection column, without duplicating storage of any of the unique data values that occur more than once in the given selection column.
-
公开(公告)号：US09633058B2
公开(公告)日：2017-04-25
申请号：US14305061
申请日：2014-06-16
发明人： Rini Kaushik
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30144 , G06F17/3053 , G06F17/30864
摘要： Methods and arrangements for predictively placing columns of a large database in a multi-tier storage system. Aspects include receiving a database to be stored in the multi-tier storage system, wherein the database comprises a plurality of columns and the multi-tier storage system comprises at least two storage devices and evaluating one or more attributes of each of the plurality of columns of the database. Aspects also include storing each of the plurality of columns of the database on one of the at least two storage devices, wherein a determination of which of the at least two storage devices to store each of the plurality of columns is based on the one or more attributes of each of the columns, a predictive model based on the weighted columnar relationship graph, and the characteristics of the storage devices.
-
公开(公告)号：US11593037B2
公开(公告)日：2023-02-28
申请号：US16698373
申请日：2019-11-27
发明人： Rini Kaushik
IPC分类号： G06F3/06
摘要： A method includes receiving a workload in a multi-tier enterprise storage system. The workload including a database. A processor determines if historical query logs present for the workload. Upon a determination that historical query logs are present for the workload: the processor analyzes a query log of historical queries for the database; an inter- and intra-query weighted column relationship graph is created based on the analyzing; and weights are assigned to the weighted column relationship graph based on an optimization process that maximizes performance for the historical queries in a training window.
-
-
-
-
-
-
-
-
-
搜索结果
16 条记录 (耗时 0.042 秒)