公开(公告)号：US07711704B2

公开(公告)日：2010-05-04

申请号：US11412634

申请日：2006-04-27

申请人： Soufiane Azizi

发明人： Soufiane Azizi

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30592

摘要： A tabular operation provider is provided for processing a data agnostic business intelligence query with relational operations, herein called a relational query against a multidimensional datasource. The tabular operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a relational query that is issued against one or more multidimensional data sources. The query decomposer decomposes expressions of the relational query into one multidimensional expression and one or more relational expressions. The query replacer replaces the relational query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.

摘要翻译： 提供了一个表格操作提供程序，用于处理具有关系操作的数据不可知商业智能查询，这里称为针对多维数据源的关系查询。 表格操作提供程序包括查询拦截器，查询分解器和查询替换器。 查询拦截器检测和拦截针对一个或多个多维数据源发出的关系查询。 查询分解器将关系查询的表达式分解为一个多维表达式和一个或多个关系表达式。 查询替换器使用分解的多维表达式和/或关系表达式表示的一组操作来替换关系查询。

公开(公告)号：US20070061292A1

公开(公告)日：2007-03-15

申请号：US11473916

申请日：2006-06-23

申请人： Soufiane Azizi ,  David Cushing

发明人： Soufiane Azizi ,  David Cushing

IPC分类号： G06F17/30

CPC分类号： G06F17/30554

摘要： A method of providing metadata and data based on an arbitrary request for information, relative to a original report layout specification, in such a manner that a software process can render the results of the request for information using only the original report layout specification and the results of the proposed method without any knowledge of the underlying data source or the request posed to retrieve data is provided Also provided is a method that for each report specified in an original report layout specification a master dataset is returned that provides access to a dataset informational object and a partial dataset data retrieval object.

摘要翻译： 相对于原始报告布局规范，基于对信息的任意请求提供元数据和数据的方法，使得软件过程可以仅使用原始报告布局规范和结果来呈现信息请求的结果 提供的方法，而不知道基础数据源或提出的提取数据的请求。还提供了一种方法，对于原始报告布局规范中指定的每个报告，返回提供对数据集信息对象的访问的主数据集 和部分数据集数据检索对象。

公开(公告)号：US07647315B2

公开(公告)日：2010-01-12

申请号：US11472795

申请日：2006-06-22

申请人： Soufiane Azizi

发明人： Soufiane Azizi

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30483 ,  Y10S707/99935

摘要： A tabular set provider is provided for processing a data agnostic business intelligence query with relational set operations, herein called a relational query against a multidimensional datasource. The tabular set provider comprises a query interceptor, a query decomposer, an OLAP query provider interface, and an operation module. The query interceptor is provided for detecting and intercepting a data agnostic Business intelligence query that has relational set operations that is issued against one or more multidimensional data sources. The query decomposer is provided for decomposing the operands of the set operation in the input query into one or more sub-queries. The OLAP query provider interface is provided for sending the OLAP supported sub-queries to an OLAP query provider and receiving results. The operation module is provided for using set operation functionality provided by a relational query provider that performs the set operations locally on the results of the OLAP data extraction.

摘要翻译： 提供了一个表格集提供程序，用于处理具有关系集操作的数据不可知商业智能查询，这里称为针对多维数据源的关系查询。 表格集提供程序包括查询拦截器，查询分解器，OLAP查询提供程序接口和操作模块。 提供查询拦截器用于检测和拦截与一个或多个多维数据源相对应的关系集操作的数据不可知商业智能查询。 提供查询分解器用于将输入查询中的设置操作的操作数分解为一个或多个子查询。 提供了OLAP查询提供程序接口，用于将OLAP支持的子查询发送到OLAP查询提供程序并接收结果。 提供了操作模块，用于使用由关系查询提供者提供的设置操作功能，该关系查询提供程序在OLAP数据提取的结果上本地执行设置操作。

公开(公告)号：US20080177720A1

公开(公告)日：2008-07-24

申请号：US11655596

申请日：2007-01-19

申请人： Vladimir Mordvinov ,  Soufiane Azizi

发明人： Vladimir Mordvinov ,  Soufiane Azizi

IPC分类号： G06F17/30

CPC分类号： G06F17/30424 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934

摘要： A query processing coordination planning unit coordinates a query processing to obtain requested data from one or more data sources. The query processing coordination planning unit comprises a request preparation coordinator and a request execution coordinator. The request planning unit invokes one or more query operation providers in a conditional query processing sequence for translating a logical representation of the user request into a physical representation of a user request, and generates an execution plan expressed by the physical representation of a user request. The request execution coordinator executes the physical representation of the user request in accordance with the execution plan using the query operation providers.

摘要翻译： 查询处理协调规划单元协调查询处理以从一个或多个数据源获得所请求的数据。 查询处理协调计划单元包括请求准备协调器和请求执行协调器。 请求规划单元在条件查询处理序列中调用一个或多个查询操作提供者，用于将用户请求的逻辑表示转换为用户请求的物理表示，并生成由用户请求的物理表示表示的执行计划。 请求执行协调器使用查询操作提供者根据执行计划执行用户请求的物理表示。

公开(公告)号：US08122050B2

公开(公告)日：2012-02-21

申请号：US12104108

申请日：2008-04-16

申请人： Vladimir Mordvinov ,  Soufiane Azizi

发明人： Vladimir Mordvinov ,  Soufiane Azizi

IPC分类号： G06F17/30

CPC分类号： G06F17/30424

摘要： A query processing visualization system comprises a visualization module. The visualization module visualizes logging information of query processing events occurring during processing of a client query requesting data from one or more data sources by analyzing the logging information to identify dependency of the query processing events, formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events, and presenting the visual presentation components in the context of the hierarchy of the visual components as formatted.

摘要翻译： 查询处理可视化系统包括可视化模块。 可视化模块通过分析记录信息来识别查询处理事件的相关性，将表示日志信息的视觉呈现组件格式化在层次结构中，从而可视化处理客户端查询处理期间发生的查询处理事件的记录信息，请求数据从一个或多个数据源 以反映查询处理事件的依赖性，以及在视觉组件的层次结构的上下文中呈现格式化的视觉呈现组件。

公开(公告)号：US07640238B2

公开(公告)日：2009-12-29

申请号：US11655596

申请日：2007-01-19

申请人： Vladimir Mordvinov ,  Soufiane Azizi

发明人： Vladimir Mordvinov ,  Soufiane Azizi

IPC分类号： G06F17/30

CPC分类号： G06F17/30424 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934

摘要： A query processing coordination planning unit coordinates a query processing to obtain requested data from one or more data sources. The query processing coordination planning unit comprises a request preparation coordinator and a request execution coordinator. The request planning unit invokes one or more query operation providers in a conditional query processing sequence for translating a logical representation of the user request into a physical representation of a user request, and generates an execution plan expressed by the physical representation of a user request. The request execution coordinator executes the physical representation of the user request in accordance with the execution plan using the query operation providers.

摘要翻译： 查询处理协调规划单元协调查询处理以从一个或多个数据源获得所请求的数据。 查询处理协调计划单元包括请求准备协调器和请求执行协调器。 请求规划单元在条件查询处理序列中调用一个或多个查询操作提供者，用于将用户请求的逻辑表示转换为用户请求的物理表示，并生成由用户请求的物理表示表示的执行计划。 请求执行协调器使用查询操作提供者根据执行计划执行用户请求的物理表示。

公开(公告)号：US20090265324A1

公开(公告)日：2009-10-22

申请号：US12104108

申请日：2008-04-16

申请人： VLADIMIR MORDVINOV ,  SOUFIANE AZIZI

发明人： VLADIMIR MORDVINOV ,  SOUFIANE AZIZI

IPC分类号： G06F17/30

CPC分类号： G06F17/30424

摘要： A query processing visualization system comprises a visualization module. The visualization module visualizes logging information of query processing events occurring during processing of a client query requesting data from one or more data sources by analyzing the logging information to identify dependency of the query processing events, formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events, and presenting the visual presentation components in the context of the hierarchy of the visual components as formatted.

摘要翻译： 查询处理可视化系统包括可视化模块。 可视化模块通过分析记录信息来识别查询处理事件的相关性，将表示日志信息的视觉呈现组件格式化在层次结构中，从而可视化处理客户端查询处理期间发生的查询处理事件的记录信息，请求数据从一个或多个数据源 以反映查询处理事件的依赖性，以及在视觉组件的层次结构的上下文中呈现格式化的视觉呈现组件。

公开(公告)号：US20060294076A1

公开(公告)日：2006-12-28

申请号：US11408705

申请日：2006-04-21

申请人： Vladimir Mordvinov ,  Soufiane Azizi

发明人： Vladimir Mordvinov ,  Soufiane Azizi

IPC分类号： G06F17/30

CPC分类号： G06F17/30433 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A coordination planner is suitably used for a query framework system for processing a user request for data from one or more data sources. The query framework system comprises multiple query processing components including a set of query operation providers, each being capable of providing a specific query operation. The coordination planner prepares a user request for execution by translating a logical representation of the user request into a physical representation of the user request using the query operation providers, and executes the physical representation of the user request to obtain a result data stream using the query operation providers.

公开(公告)号：US08112385B2

公开(公告)日：2012-02-07

申请号：US11473916

申请日：2006-06-23

申请人： Soufiane Azizi ,  David Cushing

发明人： Soufiane Azizi ,  David Cushing

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30554

摘要： A query that is based on a predefined format of an arbitrary query language is received. A data analyzing component performs the query to obtain a query result. The query result and a report layout specification are provided from the data analyzing component to a data processing component, the data processing component being on a computer. The data processing component associates the query result with at least one element of the report layout specification to generate an association. The query result is provided from the data processing component through an interface based on the report layout specification without reliance on the type of the arbitrary query language to a rendering component. The report layout specification is provided from the data analyzing component to the rendering component to render the query result in a report according to the association without reliance on the type of the arbitrary query language.

摘要翻译： 接收基于任意查询语言的预定义格式的查询。 数据分析组件执行查询以获得查询结果。 查询结果和报告布局规范从数据分析组件提供给数据处理组件，数据处理组件位于计算机上。 数据处理组件将查询结果与报告布局规范的至少一个元素相关联以生成关联。 查询结果通过基于报告布局规范的接口从数据处理组件提供，而不依赖于渲染组件的任意查询语言的类型。 报告布局规范从数据分析组件提供给呈现组件，以根据关联将查询结果呈现在报告中，而不依赖于任意查询语言的类型。

公开(公告)号：US20090307200A1

公开(公告)日：2009-12-10

申请号：US12477627

申请日：2009-06-03

申请人： Liviu IGNAT ,  Soufiane AZIZI ,  David CUSHING

发明人： Liviu IGNAT ,  Soufiane AZIZI ,  David CUSHING

IPC分类号： G06F17/30 ,  G06F15/16

CPC分类号： G06F16/24564 ,  G06F16/283

摘要： A suppression provider comprises a query preparation unit and a query execution unit. The query preparation unit analyzes a request from a client for data to obtain suppression criteria from an edge suppression specification in the request, and saving the suppression criteria in a query plan generated. The query execution unit receives execution result data including values, each associated with one or more edge values, determines if each value is to be suppressed based on the suppression criteria, and identifies one or more edge values to be suppressed when an edge value has only values that are determined to be suppressed. Thus, the suppression provider suppresses values and/or edge values identified to be suppressed in a resultant report.

摘要翻译： 抑制提供者包括查询准备单元和查询执行单元。 查询准备单元从客户端分析来自请求中的边缘抑制规范的数据获得抑制标准的请求，并且在生成的查询计划中保存抑制标准。 查询执行单元接收包括与一个或多个边缘值相关联的值的执行结果数据，基于抑制准则来确定是否要抑制每个值，并且当边缘值仅具有标识时识别待抑制的一个或多个边缘值 确定被抑制的值。 因此，抑制提供者抑制在得到的报告中识别为被抑制的值和/或边缘值。