-
公开(公告)号：US09348941B2
公开(公告)日：2016-05-24
申请号：US13162538
申请日：2011-06-16
申请人： Howard Dickerman , Vjacheslav Min , Marius Dumitru
发明人： Howard Dickerman , Vjacheslav Min , Marius Dumitru
IPC分类号： G06F17/30
CPC分类号： G06F17/30421 , G06F17/3056 , G06F17/30595 , G06F17/30955
摘要： A relationship amongst multiple relationships between database tables can be specified independent of a query. More specifically, a function (USERELATIONSHIP) can be introduced to the DAX language (Data Analysis Expressions), which provides a way to author formulas that are not evaluated immediately, but that can be evaluated dynamically and concurrently in many different contexts. The function enables a single relationship to be specified in the calculation formula away from the query. This provides a mechanism within the formula that specifies specific relationship(s) that are to be followed when the dynamic expression is evaluated.
摘要翻译： 可以独立于查询来指定数据库表之间的多个关系之间的关系。 更具体地说，可以将DAX语言（数据分析表达式）中的函数（USERELATIONSHIP）引入到数据分析表达式中，该方法可以为不能立即评估的公式进行编写，但可以在许多不同的上下文中动态和并发地进行评估。 该功能可以在计算公式中指定单个关系，远离查询。 这提供了公式中的机制，指定了在评估动态表达式时要遵循的特定关系。
-
公开(公告)号：US08898145B2
公开(公告)日：2014-11-25
申请号：US13160982
申请日：2011-06-15
IPC分类号： G06F17/30
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.
摘要翻译： 本文描述了各种查询优化技术。 本文中称为非空转换的第一查询优化技术可以应用于指定一个或多个度量的查询，要在其中评估度量的维度上下文，以及指定具有 只有空测量值才能从结果集中排除。 非空转换技术使得这样的查询可以被重写成可以比原始查询更有效地执行的另一格式。 本文描述的第二种查询优化技术涉及重组查询的运算符树表示，以避免扩展列的不必要的重复评估。 本文所述的第三种查询优化技术自动选择具有最低基数的最小数目的连接列，以实现两个表之间的连接。
-
公开(公告)号：US20120323885A1
公开(公告)日：2012-12-20
申请号：US13160982
申请日：2011-06-15
IPC分类号： G06F17/30
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.
摘要翻译： 本文描述了各种查询优化技术。 本文中称为非空转换的第一查询优化技术可以应用于指定一个或多个度量的查询，要在其中评估度量的维度上下文，以及指定具有 只有空测量值才能从结果集中排除。 非空转换技术使得这样的查询可以被重写成可以比原始查询更有效地执行的另一格式。 本文描述的第二种查询优化技术涉及重组查询的运算符树表示，以避免扩展列的不必要的重复评估。 本文所述的第三种查询优化技术自动选择具有最低基数的最小数目的连接列，以实现两个表之间的连接。
-
公开(公告)号：US20070219957A1
公开(公告)日：2007-09-20
申请号：US11384676
申请日：2006-03-20
申请人： Thierry D'Hers , Bala Atur , Marius Dumitru
发明人： Thierry D'Hers , Bala Atur , Marius Dumitru
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/957
摘要： A data processing and analysis system is provided. The system includes an analysis engine that queries one or more components of data. A rules component specifies a relationship between at least one dimension of the data with respect to at least one other dimension of the data in order to facilitate an analysis of the data. In one example, the analysis engine is provided as an online analytical processing component.
摘要翻译： 提供数据处理和分析系统。 该系统包括一个查询数据的一个或多个组件的分析引擎。 规则组件指定数据的至少一个维度与数据的至少一个其他维度之间的关系，以便于对数据的分析。 在一个示例中，分析引擎被提供为在线分析处理组件。
-
公开(公告)号：US20050171950A1
公开(公告)日：2005-08-04
申请号：US10766184
申请日：2004-01-29
申请人： Marius Dumitru , Robert Fuhge , Ute Stiegeler
发明人： Marius Dumitru , Robert Fuhge , Ute Stiegeler
CPC分类号： G06F17/3089 , Y10S707/99934
摘要： Generally, the invention provides the capability to store and use web application status information for each web page dynamically generated and transmitted to a web browser in a communications session. The status information is stored so that it may be later retrieved and used to reset the status of the web application each time requests are generated by action taken while the page is displayed. Resetting the status each time action is taken from the web page ensures that the corresponding request produces the same results every time that it is submitted, as is expected by the user.
摘要翻译： 通常，本发明提供了存储和使用在通信会话中动态生成并发送到web浏览器的每个网页的web应用状态信息的能力。 存储状态信息，以便随后可以检索并且用于每当通过在显示页面时采取的动作来生成请求时重新设置web应用的状态。 每当从网页采取行动时重置状态，确保相应的请求在每次提交时都产生相同的结果，如用户期望的那样。
-
公开(公告)号：US20120323956A1
公开(公告)日：2012-12-20
申请号：US13161522
申请日：2011-06-16
申请人： Marius Dumitru , Jeffrey Wang
发明人： Marius Dumitru , Jeffrey Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , G06F17/30545
摘要： A system and method for facilitating querying one or more data sources. A system provides mechanisms to enable flexible specification of user queries and generation of one or more SQL queries that correspond closely to corresponding user queries. An operator tree and a logical operator tree may be created as intermediate steps to generate the one or more SQL queries. Capabilities of data sources are determined and used to generate remotable SQL queries for composable queries, to reduce an amount of post-processing that is performed on result sets. The system enables user queries that extend beyond those defined by a data model.
摘要翻译： 一种便于查询一个或多个数据源的系统和方法。 系统提供了使用户能够灵活地指定用户查询并生成与相应用户查询密切对应的一个或多个SQL查询的机制。 可以创建运算符树和逻辑运算符树作为生成一个或多个SQL查询的中间步骤。 确定数据源的能力并用于为可组合查询生成可远程SQL查询，以减少对结果集执行的后处理量。 该系统允许超出数据模型定义的用户查询。
-
公开(公告)号：US07451137B2
公开(公告)日：2008-11-11
申请号：US11069121
申请日：2005-02-28
IPC分类号： G06F17/30
CPC分类号： G06F17/30539 , G06F17/30421 , G06F17/30595 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： Architecture that facilitates syntax processing for data mining statements. The system includes a syntax engine that receives as an input a query statement which, for example, is a data mining request. The statement can be generated from many different sources, e.g., a client application and/or a server application, and requests query processing of a data source (e.g., a relational database) to return a result set. The syntax engine includes a binding component that converts the query statement into an encapsulated statement in accordance with a predefined grammar. The encapsulated statement includes both data and data operations to be performed on the data of the data source, and which is understood by the data source. An execution component processes the encapsulated statement against the data source to return the desired result set.
摘要翻译： 促进数据挖掘语句的语法处理的架构。 该系统包括语法引擎，其作为输入接收诸如数据挖掘请求的查询语句。 语句可以从许多不同的来源（例如客户端应用程序和/或服务器应用程序）生成，并且请求数据源（例如，关系数据库）的查询处理以返回结果集。 语法引擎包括一个绑定组件，它根据预定义的语法将查询语句转换成封装语句。 封装语句包括要对数据源的数据执行的数据和数据操作，数据源可以理解。 执行组件根据数据源处理封装语句以返回所需的结果集。
-
公开(公告)号：US20060010112A1
公开(公告)日：2006-01-12
申请号：US11069121
申请日：2005-02-28
申请人： Ioan Crivat , C. MacLennan , Raman Iyer , Marius Dumitru
发明人： Ioan Crivat , C. MacLennan , Raman Iyer , Marius Dumitru
IPC分类号： G06F17/30
CPC分类号： G06F17/30539 , G06F17/30421 , G06F17/30595 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： Architecture that facilitates syntax processing for data mining statements. The system includes a syntax engine that receives as an input a query statement which, for example, is a data mining request. The statement can be generated from many different sources, e.g., a client application and/or a server application, and requests query processing of a data source (e.g., a relational database) to return a result set. The syntax engine includes a binding component that converts the query statement into an encapsulated statement in accordance with a predefined grammar. The encapsulated statement includes both data and data operations to be performed on the data of the data source, and which is understood by the data source. An execution component processes the encapsulated statement against the data source to return the desired result set.
摘要翻译： 促进数据挖掘语句的语法处理的架构。 该系统包括语法引擎，其作为输入接收诸如数据挖掘请求的查询语句。 语句可以从许多不同的来源（例如客户端应用程序和/或服务器应用程序）生成，并且请求数据源（例如，关系数据库）的查询处理以返回结果集。 语法引擎包括一个绑定组件，它根据预定义的语法将查询语句转换成封装语句。 封装语句包括要对数据源的数据执行的数据和数据操作，数据源可以理解。 执行组件根据数据源处理封装语句以返回所需的结果集。
-
公开(公告)号：US20120323958A1
公开(公告)日：2012-12-20
申请号：US13162538
申请日：2011-06-16
申请人： Howard Dickerman , Vjacheslav Min , Marius Dumitru
发明人： Howard Dickerman , Vjacheslav Min , Marius Dumitru
IPC分类号： G06F17/30
CPC分类号： G06F17/30421 , G06F17/3056 , G06F17/30595 , G06F17/30955
摘要： A relationship amongst multiple relationships between database tables can be specified independent of a query. More specifically, a function (USERELATIONSHIP) can be introduced to the DAX language (Data Analysis Expressions), which provides a way to author formulas that are not evaluated immediately, but that can be evaluated dynamically and concurrently in many different contexts. The function enables a single relationship to be specified in the calculation formula away from the query. This provides a mechanism within the formula that specifies specific relationship(s) that are to be followed when the dynamic expression is evaluated.
摘要翻译： 可以独立于查询来指定数据库表之间的多个关系之间的关系。 更具体地说，可以将DAX语言（数据分析表达式）中的函数（USERELATIONSHIP）引入到数据分析表达式中，该方法可以为不能立即评估的公式进行编写，但可以在许多不同的上下文中动态和并发评估。 该功能可以在计算公式中指定单个关系，远离查询。 这提供了公式中的机制，指定了在评估动态表达式时要遵循的特定关系。
-
公开(公告)号：US07970735B2
公开(公告)日：2011-06-28
申请号：US11384676
申请日：2006-03-20
申请人： Thierry D'Hers , Bala Atur , Marius Dumitru
发明人： Thierry D'Hers , Bala Atur , Marius Dumitru
CPC分类号： G06F17/30592 , Y10S707/957
摘要： A data processing and analysis system is provided. The system includes an analysis engine that queries one or more components of data. A rules component specifies a relationship between at least one dimension of the data with respect to at least one other dimension of the data in order to facilitate an analysis of the data. In one example, the analysis engine is provided as an online analytical processing component.
摘要翻译： 提供数据处理和分析系统。 该系统包括一个查询数据的一个或多个组件的分析引擎。 规则组件指定数据的至少一个维度与数据的至少一个其他维度之间的关系，以便于对数据的分析。 在一个示例中，分析引擎被提供为在线分析处理组件。
-
-
-
-
-
-
-
-
-
搜索结果
41 条记录 (耗时 0.033 秒)
