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

11. 发明申请

US20110231389A1 ADAPTIVE ROW-BATCH PROCESSING OF DATABASE DATA 有权
标题翻译：数据库数据的自适应分组处理
公开(公告)号：US20110231389A1
公开(公告)日：2011-09-22
申请号：US12727235
申请日：2010-03-19
申请人： Aleksandras Surna , Per-Ake Larson , Srikumar Rangarajan
发明人： Aleksandras Surna , Per-Ake Larson , Srikumar Rangarajan
IPC分类号： G06F17/30
CPC分类号： G06F17/30492
摘要： Architecture that provides for greater interoperability between column stores and row stores by leveraging the advantages both have to offer. The architecture operates automatically (e.g., dynamically) to move between row oriented processing mode and batch processing mode, and the combination thereof, when it is more beneficial to run in one mode relative to the other mode, or both modes. The auto-switching of data processing between batch and row oriented mode occurs during the execution of a single query. The architecture can automatically modify an operator in the query tree and/or remove an operator if desired at runtime for more efficient processing. This approach also accounts for memory constraints for either of row or column processing.
摘要翻译：架构通过利用两者必须提供的优点，提供列存储和行存储之间的更大的互操作性。当相对于其他模式或两种模式运行在一种模式中更有利时，架构在行面向处理模式和批处理模式之间自动运行（例如，动态地）移动，以及其组合。批处理和行向模式之间的数据处理自动切换在执行单个查询期间发生。架构可以在运行时自动修改查询树中的运算符和/或删除运算符，以便更有效的处理。这种方法也解决了行或列处理中的任何一个的内存限制。

12. 发明授权

US08990216B2 Scalable index build techniques for column stores 有权
标题翻译：列存储的可扩展索引构建技术
公开(公告)号：US08990216B2
公开(公告)日：2015-03-24
申请号：US12727266
申请日：2010-03-19
申请人： Artem Oks , Qingqing Zhou , Srikumar Rangarajan , Aleksandras Surna , Wey Guy , Cipri Clinciu , Ashit Gosalia
发明人： Artem Oks , Qingqing Zhou , Srikumar Rangarajan , Aleksandras Surna , Wey Guy , Cipri Clinciu , Ashit Gosalia
IPC分类号： G06F17/30 , G06F9/50
CPC分类号： G06F17/30315 , G06F9/5083 , G06F17/30321 , G06F17/30474 , H04L47/82
摘要： Architecture that includes an index creation algorithm that utilizes available resources and dynamically adjusts to successfully scale with increased resources and be able to do so for any data distribution. The resources can be processing resources, memory, and/or input/output, for example. A finer level of granularity, called a segment, is utilized to process tuples in a partition while creating an index. The segment also aligns with compression techniques for the index. By choosing an appropriate size for a segment and using load balancing the overall time for index creation can be reduced. Each segment can then be processed by a single thread thereby limiting segment skew. Skew is further limited by breaking down the work done by a thread into parallelizable stages.
摘要翻译：体系结构包括利用可用资源并动态调整的索引创建算法，以便通过增加的资源成功扩展，并能够为任何数据分配做到这一点。资源可以是例如处理资源，存储器和/或输入/输出。使用更精细的粒度级别（称为段）来处理分区中的元组，同时创建索引。该段也与索引的压缩技术保持一致。通过为段选择适当的大小并使用负载平衡，可以减少创建索引的总时间。然后可以通过单个线程处理每个段，从而限制段偏移。通过将线程完成的工作分解成可并行化阶段来进一步限制倾斜。

13. 发明授权

US08086593B2 Dynamic filters for relational query processing 有权
标题翻译：用于关系查询处理的动态过滤器
公开(公告)号：US08086593B2
公开(公告)日：2011-12-27
申请号：US11680708
申请日：2007-03-01
申请人： Aleksandras Surna , Sreenivas Gukal , Peter Zabback
发明人： Aleksandras Surna , Sreenivas Gukal , Peter Zabback
IPC分类号： G06F7/00
CPC分类号： G06F17/30424
摘要： Systems and methods that eliminate non-qualifying data for queries against data warehouses and improve execution time, via a dynamic filter component(s). In general, such dynamic filter components are derived from data during processing of the query and without being explicitly defined by the users within a query forwarded to the data warehouse. Moreover, an evaluation component can monitor efficiency of filter components (e.g., number of rows that can be eliminated), and dynamically change and/or update the evaluation order of such filters.
摘要翻译：通过动态过滤器组件消除针对数据仓库的查询的非限定数据并提高执行时间的系统和方法。一般来说，这样的动态过滤器组件在处理查询期间从数据派生而不是由转发到数据仓库的查询中的用户明确定义。此外，评估组件可以监视滤波器组件的效率（例如，可以消除的行数），并动态地改变和/或更新这些滤波器的评估顺序。

14. 发明申请

US20080215556A1 DYNAMIC FILTERS FOR RELATIONAL QUERY PROCESSING 有权
标题翻译：用于相关查询处理的动态过滤器
公开(公告)号：US20080215556A1
公开(公告)日：2008-09-04
申请号：US11680708
申请日：2007-03-01
申请人： Aleksandras Surna , Sreenivas Gukal , Peter Zabback
发明人： Aleksandras Surna , Sreenivas Gukal , Peter Zabback
IPC分类号： G06F17/30
CPC分类号： G06F17/30424
摘要： Systems and methods that eliminate non-qualifying data for queries against data warehouses and improve execution time, via a dynamic filter component(s). In general, such dynamic filter components are derived from data during processing of the query and without being explicitly defined by the users within a query forwarded to the data warehouse. Moreover, an evaluation component can monitor efficiency of filter components (e.g., number of rows that can be eliminated), and dynamically change and/or update the evaluation order of such filters.
摘要翻译：通过动态过滤器组件消除针对数据仓库的查询的非限定数据并提高执行时间的系统和方法。一般来说，这样的动态过滤器组件在处理查询期间从数据派生而不是由转发到数据仓库的查询中的用户明确定义。此外，评估组件可以监视过滤器组件的效率（例如，可以消除的行数），并动态地改变和/或更新这些过滤器的评估顺序。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式