System and method for multiple pass cooperative processing
    11.
    发明授权
    System and method for multiple pass cooperative processing 有权
    多通道协同处理系统和方法

    公开(公告)号:US07003512B1

    公开(公告)日:2006-02-21

    申请号:US10912174

    申请日:2004-08-06

    IPC分类号: G06F17/30

    摘要: A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

    摘要翻译: 一种用于协同处理的系统,包括控制模块,该控制模块可访问至少一个能够对数据库中的数据执行第一组功能的关系数据库和至少一个外部分析引擎,所述外部分析引擎在关系数据库外部 并且能够对数据库中的数据进行第二组功能。 控制模块能够迭代处理多步计算,包括生成SQL语句到关系数据库,将初步结果传递给外部分析引擎,并将数据保存回关系数据库进行进一步处理,直到执行多步计算。

    Systems and methods for assigning priority to jobs in a reporting system
    13.
    发明授权
    Systems and methods for assigning priority to jobs in a reporting system 有权
    在报告系统中为作业分配优先级的系统和方法

    公开(公告)号:US07509671B1

    公开(公告)日:2009-03-24

    申请号:US09884475

    申请日:2001-06-20

    IPC分类号: G06F9/46

    摘要: The methods and systems of the invention provide for processing of jobs, that comprise one or more reports to be processed in a reporting system, by assigning a priority to a job. The priority may include a queue or a queue set priority, as well as a sub-queue priority in accordance with some embodiments of the methods and systems of the invention. Once the priority is assigned, the job is placed into a selected queue, selected from a plurality of possible queues, based on the queue priority assigned to the job. The job may also be designated to a particular sub-queue within the selected queue, i.e., based on the sub-queue priority. Then, the job is processed based on the priority.

    摘要翻译: 本发明的方法和系统通过为作业分配优先级来提供包括在报告系统中处理的一个或多个报告的作业处理。 根据本发明的方法和系统的一些实施例,优先级可以包括队列或队列集优先级,以及子队列优先级。 一旦分配了优先级,根据分配给作业的队列优先级,将作业放入从多个可能队列中选择的选定队列中。 该作业也可以被指定到所选队列内的特定子队列,即基于子队列优先级。 然后,根据优先级对作业进行处理。

    System and method for syntax abstraction in query language generation
    14.
    发明授权
    System and method for syntax abstraction in query language generation 有权
    查询语言生成中语法抽象的系统和方法

    公开(公告)号:US08005870B1

    公开(公告)日:2011-08-23

    申请号:US09883302

    申请日:2001-06-19

    IPC分类号: G06F17/30 G06F17/00

    CPC分类号: G06F17/30398

    摘要: A system and method for syntax abstraction in query language generation in an online analytical processing system, a business intelligence system, a reporting system, or a data mining system. The system generates one or more query language statements that can be run against one or more data sources to return a desired data result set. The system includes a syntax pattern selector module and a statement assembly module. The syntax pattern selector module selects a syntax pattern corresponding to a desired function and a syntax standard. The statement assembly module populates the syntax pattern with an argument data set associated with the desired data set. The result is the generation of one or more query language statements with the correct function, syntax, and data parameters to return the desired data result set from the data sources. A method and medium having processor readable code therein are also described.

    摘要翻译: 在线分析处理系统,商业智能系统,报告系统或数据挖掘系统中的查询语言生成中的语法抽象的系统和方法。 该系统生成一个或多个可针对一个或多个数据源运行的查询语言语句,以返回所需的数据结果集。 该系统包括语法模式选择器模块和语句组合模块。 语法模式选择器模块选择与所需功能和语法标准相对应的语法模式。 语句组合模块使用与所需数据集相关联的参数数据集填充语法模式。 结果是生成具有正确功能,语法和数据参数的一个或多个查询语言语句,以从数据源返回所需的数据结果集。 还描述了其中具有处理器可读代码的方法和介质。

    System and method for multiple pass cooperative processing
    16.
    发明授权
    System and method for multiple pass cooperative processing 有权
    多通道协同处理系统和方法

    公开(公告)号:US06820073B1

    公开(公告)日:2004-11-16

    申请号:US10101488

    申请日:2002-03-20

    IPC分类号: G06F1730

    摘要: A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

    摘要翻译: 一种用于协同处理的系统,包括控制模块,该控制模块可访问至少一个能够对数据库中的数据执行第一组功能的关系数据库和至少一个外部分析引擎,所述外部分析引擎在关系数据库外部 并且能够对数据库中的数据进行第二组功能。 控制模块能够迭代处理多步计算,包括生成SQL语句到关系数据库,将初步结果传递给外部分析引擎,并将数据保存回关系数据库进行进一步处理,直到执行多步计算。

    Integration of e-learning with business intelligence system
    17.
    发明授权
    Integration of e-learning with business intelligence system 有权
    电子学习与商业智能系统的整合

    公开(公告)号:US08761659B1

    公开(公告)日:2014-06-24

    申请号:US11055716

    申请日:2005-02-11

    IPC分类号: G09B7/00

    CPC分类号: G09B7/00

    摘要: A business intelligence system comprises a business intelligence interface system that enables users to interface with a business intelligence system and an electronic learning system that delivers electronic learning related to the business intelligence system. The business intelligence interface system enables one or more portions, such as folders of reports, individual reports, metadata or other business intelligence objects, or a report definition, of the business intelligence system for use by a user based on information related to whether the user has engaged in electronic learning associated with the one or more portions. A user may self-provision access by earning a privilege based on reviewing a lesson, passing a test, and/or other activities relative to the business intelligence object. Upon meeting electronic learning criteria, the electronic learning system updates privileges to enable access to the business intelligence object or class of objects.

    摘要翻译: 商业智能系统包括商业智能接口系统,其使得用户能够与商业智能系统和电子学习系统接口,该系统提供与商业智能系统相关的电子学习。 商业智能接口系统使得商业智能系统的一个或多个部分(例如报告的文件夹,单独的报告,元数据或其它商业智能对象)或报告定义能够由用户根据与用户是否相关的信息来使用 已经从事与一个或多个部分相关联的电子学习。 用户可以通过基于审查课程,传递测试和/或与商业智能对象相关的其他活动来获得特权来自行提供访问。 在符合电子学习标准的情况下,电子学习系统更新权限,以便访问商业智能对象或对象类。

    Technique for limiting access to the resources of a system
    18.
    发明授权
    Technique for limiting access to the resources of a system 有权
    限制对系统资源的访问的技术

    公开(公告)号:US07836178B1

    公开(公告)日:2010-11-16

    申请号:US10166044

    申请日:2002-06-11

    IPC分类号: G06F15/173

    CPC分类号: G06F9/505

    摘要: A technique for limiting access to the resources of a system is disclosed. In one embodiment, wherein the system has a server for processing requests, and wherein the server supports a plurality of projects, the technique includes receiving a request to access the resources of the system. The request is denied based upon an application level and a setting level, wherein the application level is associated with one of a plurality of functional layers within the system that is affected by the request, and wherein the setting level is a limiting value associated with one of the server alone and the server with one or more of the plurality of projects. The limiting value limits an operation on one of the plurality of functional layers, thereby limiting access to the resources of the system.

    摘要翻译: 公开了一种用于限制对系统的资源的访问的技术。 在一个实施例中,其中系统具有用于处理请求的服务器,并且其中服务器支持多个项目,该技术包括接收访问系统资源的请求。 所述请求基于应用级别和设置级别而被拒绝,其中所述应用级别与所述系统中受所述请求影响的多个功能层中的一个相关联,并且其中所述设置级别是与一个相关联的限制值 的服务器和具有多个项目中的一个或多个的服务器。 限制值限制在多个功能层之一上的操作,从而限制对系统的资源的访问。

    Systems and methods for custom grouping of data
    19.
    发明授权
    Systems and methods for custom grouping of data 有权
    用于数据自定义分组的系统和方法

    公开(公告)号:US06996569B1

    公开(公告)日:2006-02-07

    申请号:US10120192

    申请日:2002-04-11

    IPC分类号: G06F17/30

    摘要: A system and method for creating a custom grouping of data in a database. A custom group object is created, a plurality of custom group elements are defined, each of the custom group elements being a subset of the custom group object and being defined by a different filter, each one of the different filters representing a logical expression of qualifications based on the data or a derived calculation of the data. Each of the different filters is resolved against the data or a subset of the data, and the plurality of custom group elements are grouped into a consolidated result set which in not naturally existing in the data structure.

    摘要翻译: 用于在数据库中创建自定义数据分组的系统和方法。 创建自定义组对象,定义多个自定义组元素,每个自定义组元素是自定义组对象的子集,并由不同的过滤器定义,每个不同的过滤器表示资格的逻辑表达式 基于数据或数据的派生计算。 每个不同的过滤器都针对数据或数据的一个子集进行解析,并且多个自定义组元素被分组成并不自然地存在于数据结构中的统一结果集合。

    System and method for function selection in analytic processing
    20.
    发明授权
    System and method for function selection in analytic processing 有权
    分析处理中功能选择的系统和方法

    公开(公告)号:US08606813B1

    公开(公告)日:2013-12-10

    申请号:US10043263

    申请日:2002-01-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30545

    摘要: A selection engine for a cooperative processing network, in which databases compute portions of searches and analyses which they may most efficiently compute. A data mining network may contain large scale databases, analytic engines which communicate with the databases, and other resources, each capable of performing or executing certain functions, such as statistical functions. When a user desires to run a specified report against the databases, those functions that can be computed locally in the database are trapped and computed therein, whereas other functions, such as advanced statistical functions, may be distributed to remote analytic engines or other resources in the network. A management module may coordinate the transmission and assembly of the data, including to order dependencies. The management module may contain a selection engine to allocate computations to databases or other resources as a default, to test for load balancing before choosing a compute site, or apply other criteria.

    摘要翻译: 用于协作处理网络的选择引擎,其中数据库计算搜索和分析的部分,哪些可以最有效地计算。 数据挖掘网络可能包含大型数据库,与数据库通信的分析引擎,以及其他能够执行或执行某些功能(如统计功能)的资源。 当用户希望针对数据库运行指定的报告时,可以在数据库中本地计算的那些功能被捕获和计算,而诸如高级统计功能的其他功能可以分发到远程分析引擎或其他资源 网络。 管理模块可以协调数据的传输和组装,包括订单依赖性。 管理模块可以包含选择引擎以将计算分配给数据库或其他资源作为默认值,以在选择计算站点之前测试负载平衡或应用其他标准。