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

1. 发明授权

US09418101B2 Query optimization 有权
标题翻译：查询优化
公开(公告)号：US09418101B2
公开(公告)日：2016-08-16
申请号：US13612611
申请日：2012-09-12
申请人： Xiaowen He , Lin Luo , Martin Petitclerc
发明人： Xiaowen He , Lin Luo , Martin Petitclerc
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30389 , G06F17/30592
摘要： Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression. The collected information is used to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.
摘要翻译：提供了用于生成关系查询的技术。从具有至少第一表达式和第二表达式的在线分析处理（OLAP）查询的查询规范和模型收集信息。收集的信息用于生成关系查询以检索用于满足第一表达式和第二表达式的报告数据。

2. 发明申请

US20140074771A1 QUERY OPTIMIZATION 有权
标题翻译：查询优化
公开(公告)号：US20140074771A1
公开(公告)日：2014-03-13
申请号：US13612611
申请日：2012-09-12
申请人： Xiaowen He , Lin Luo , Martin Petitclerc
发明人： Xiaowen He , Lin Luo , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30389 , G06F17/30592
摘要： Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression. The collected information is used to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.
摘要翻译：提供了用于生成关系查询的技术。从具有至少第一表达式和第二表达式的在线分析处理（OLAP）查询的查询规范和模型收集信息。收集的信息用于生成关系查询以检索用于满足第一表达式和第二表达式的报告数据。

3. 发明授权

US07139766B2 Universal drill-down system for coordinated presentation of items in different databases 有权
标题翻译：通用钻取系统，用于协调呈现不同数据库中的项目
公开(公告)号：US07139766B2
公开(公告)日：2006-11-21
申请号：US10321781
申请日：2002-12-16
申请人： Neil Thomson , Andre Paiement , Dave Gould , Martin Petitclerc , Brian Donnelly , Gordon Chow
发明人： Neil Thomson , Andre Paiement , Dave Gould , Martin Petitclerc , Brian Donnelly , Gordon Chow
IPC分类号： G06F7/00
CPC分类号： G06F17/30569 , G06F17/30539 , G06F17/30663 , Y10S707/99942
摘要： A computer implemented method for mapping data from one presentation to another includes capturing and transmitting the context of an original report based on an originating data source such that it preserves the organization of the query and variable levels of context “fidelity”. The context of the originating report is translated in terms of the originating data source to a target context for presentation of a target report based on a target data source. The translation of different mapping scenarios is controlled in accordance with a translation model with a translation map.
摘要翻译：用于将数据从一个演示文稿映射到另一个演示文稿的计算机实现的方法包括基于始发数据源捕获和发送原始报告的上下文，使得其保留查询的组织和上下文“保真度”的可变级别。原始报告的上下文根据原始数据源被转换为目标上下文，用于基于目标数据源呈现目标报告。根据具有翻译图的翻译模型来控制不同地图场景的翻译。

4. 发明授权

US09286370B2 Viewing a dimensional cube as a virtual data source 有权
标题翻译：将维多维数据集视为虚拟数据源
公开(公告)号：US09286370B2
公开(公告)日：2016-03-15
申请号：US12711562
申请日：2010-02-24
申请人： David B. Cushing , Martin Petitclerc
发明人： David B. Cushing , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： Techniques are disclosed for generating a dimensional query that includes dimensional and relational constructs. A report specification for retrieving data from a dimensional data model is received. The report specification includes the dimensional and relational constructs. The dimensional query is generated from the report specification, based on a predetermined sequence of applying the dimensional and relational constructs.
摘要翻译：公开了用于生成包括尺寸和关系构造的维度查询的技术。接收到用于从维数据模型检索数据的报告规范。报告规范包括维度和关系结构。基于应用维度和关系结构的预定顺序，从报告规范生成维度查询。

5. 发明授权

US08745021B2 Transformation of complex data source result sets to normalized sets for manipulation and presentation 失效
标题翻译：将复杂数据源结果集转换为用于操纵和呈现的归一化集合
公开(公告)号：US08745021B2
公开(公告)日：2014-06-03
申请号：US13276134
申请日：2011-10-18
申请人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
发明人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.
摘要翻译：企业商业智能系统包括数据访问服务。在一个示例中，一种方法包括使用数据访问服务从应用程序接收查询和报告规范，其中数据访问服务位于应用程序和数据源之间; 创建一个包含可执行装饰节点序列的运行树; 执行对数据源的查询，从而提供包括响应于查询的从数据源抽取的查询结果的查询结果集; 并在查询结果集上执行装饰节点序列。装饰节点修改查询结果集，从而根据查询结果集和装饰节点生成装饰结果集。生成装饰结果集包括将查询结果中的成员或值与报表规范中的相应位置或计算成员相关联。

6. 发明申请

US20130097151A1 TRANSFORMATION OF COMPLEX DATA SOURCE RESULT SETS TO NORMALIZED SETS FOR MANIPULATION AND PRESENTATION 有权
公开(公告)号：US20130097151A1
公开(公告)日：2013-04-18
申请号：US13545520
申请日：2012-07-10
申请人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
发明人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.

7. 发明申请

US20110208690A1 VIEWING AN OLAP CUBE AS A VIRTUAL DATA SOURCE 有权
标题翻译：查看OLAP CUBE作为虚拟数据源
公开(公告)号：US20110208690A1
公开(公告)日：2011-08-25
申请号：US12711562
申请日：2010-02-24
申请人： DAVID B. CUSHING , Martin Petitclerc
发明人： DAVID B. CUSHING , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： Systems, methods and articles of manufacture are disclosed for generating an online analytical processing (OLAP) query. A report specification may be received against the OLAP system. The report specification may include relational constructs. An application may apply constructs in the OLAP query according to a mapping and in a specific order. Consequently, the semantics of the report specification may be preserved.
摘要翻译：公开了用于生成在线分析处理（OLAP）查询的系统，方法和制品。可能会针对OLAP系统收到报告规范。报告规范可以包括关系结构。应用程序可以根据映射和特定顺序在OLAP查询中应用构造。因此，可以保留报告规范的语义。

8. 发明授权

US07716257B2 Universal drill-down system for coordinated presentation of items in different databases 有权
标题翻译：通用钻取系统，用于协调呈现不同数据库中的项目
公开(公告)号：US07716257B2
公开(公告)日：2010-05-11
申请号：US11511939
申请日：2006-08-28
申请人： Neil Thomson , Andre Paiement , Dave Gould , Martin Petitclerc , Brian Donnelly , Gordon Chow
发明人： Neil Thomson , Andre Paiement , Dave Gould , Martin Petitclerc , Brian Donnelly , Gordon Chow
IPC分类号： G06F17/30
CPC分类号： G06F17/30569 , G06F17/30539 , G06F17/30663 , Y10S707/99942
摘要： A computer readable storage medium includes executable instructions to receive context information specifying dimensional criteria defining a first value in a first data source. A context transfer to a second value in a second data source is generated based upon the dimensional criteria. The context transfer is performed in accordance with a translation model with a translation map for mapping between multiple data sources. The second value is supplied.
摘要翻译：计算机可读存储介质包括用于接收指定在第一数据源中定义第一值的维度标准的上下文信息的可执行指令。基于尺寸标准产生到第二数据源中的第二值的上下文传送。根据具有用于在多个数据源之间映射的转换映射的翻译模型来执行上下文传送。提供第二个值。

9. 发明授权

US08825621B2 Transformation of complex data source result sets to normalized sets for manipulation and presentation 有权
公开(公告)号：US08825621B2
公开(公告)日：2014-09-02
申请号：US13545520
申请日：2012-07-10
申请人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
发明人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.

10. 发明申请

US20130097150A1 TRANSFORMATION OF COMPLEX DATA SOURCE RESULT SETS TO NORMALIZED SETS FOR MANIPULATION AND PRESENTATION 失效
标题翻译：复制数据源结果转换为用于操作和呈现的正规化集
公开(公告)号：US20130097150A1
公开(公告)日：2013-04-18
申请号：US13276134
申请日：2011-10-18
申请人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
发明人： David B. Cushing , Robin N. Grosset , Charles Ng , Martin Petitclerc
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an application, wherein the data access service is positioned between the application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set. The decoration nodes modify the query result set, thereby producing a decorated result set based on the query result set and the decoration nodes. Producing the decorated result set comprises associating members or values in the query results with corresponding positions or calculated members in the report specification.
摘要翻译：企业商业智能系统包括数据访问服务。在一个示例中，一种方法包括使用数据访问服务从应用程序接收查询和报告规范，其中数据访问服务位于应用程序和数据源之间; 创建一个包含可执行装饰节点序列的运行树; 执行对数据源的查询，从而提供包括响应于查询的从数据源抽取的查询结果的查询结果集; 并在查询结果集上执行装饰节点序列。装饰节点修改查询结果集，从而根据查询结果集和装饰节点生成装饰结果集。生成装饰结果集包括将查询结果中的成员或值与报表规范中的相应位置或计算成员相关联。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式