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

1. 发明申请

WO2011044286A2 DATA ANALYSIS EXPRESSIONS 审中-公开
标题翻译：数据分析表达
公开(公告)号：WO2011044286A2
公开(公告)日：2011-04-14
申请号：PCT/US2010/051696
申请日：2010-10-06
申请人： MICROSOFT CORPORATION
发明人： DICKERMAN, Howard, J. , DUMITRU, Marius , MIRCHANDANI, Akshai , WANG, Yutong (Jeffrey) , NETZ, Amir , SANDERS, Paul, J.
IPC分类号： G06F17/40 , G06F19/00
CPC分类号： G06F17/246
摘要： Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
摘要翻译：公开了接收和处理数据分析表达式的方法和系统。特定的方法包括在电子表格的枢轴表处接收数据分析表达式。通过确定与特定小区关联的上下文，基于上下文计算数据分析表达式的值，并且在特定小区处输出计算的值，对于枢纽表的特定小区执行数据分析表达式。

2. 发明申请

WO2012173827A2 QUERY OPTIMIZATION TECHNIQUES FOR BUSINESS INTELLIGENCE SYSTEMS 审中-公开
标题翻译：业务智能系统的查询优化技术
公开(公告)号：WO2012173827A2
公开(公告)日：2012-12-20
申请号：PCT/US2012/040953
申请日：2012-06-05
申请人： MICROSOFT CORPORATION
发明人： WANG, Yutong (Jeffrey) , DUMITRU, Marius
CPC分类号： G06F17/30448 , G06F17/30498
摘要： A variety of query optimization techniques are described herein. A first query optimization technique, referred to herein as non-empty transformation, may be applied to queries that specify one or more measures, a dimensional context within which the measure(s) are to be evaluated, and a filter condition specifying that rows with only empty measure values be excluded from a result set. The non-empty transformation technique enables such queries to be rewritten into another format that can be executed more efficiently than the original queries. A second query optimization technique described herein involves restructuring an operator tree representation of a query so as to avoid unnecessary duplicated evaluation of extension columns. A third query optimization technique described herein automatically selects a minimum number of join columns having the lowest cardinality for implementing a join between two tables.
摘要翻译：本文描述了各种查询优化技术。本文中称为非空转换的第一查询优化技术可以应用于指定一个或多个度量的查询，要在其中评估度量的维度上下文，以及指定具有只有空测量值才能从结果集中排除。非空转换技术使得这样的查询可以被重写成可以比原始查询更有效地执行的另一格式。本文描述的第二种查询优化技术涉及重组查询的运算符树表示，以避免扩展列的不必要的重复评估。本文所述的第三种查询优化技术自动选择具有最低基数的最小数目的连接列，以实现两个表之间的连接。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式