System and method for exporting report results from a reporting system
    2.
    发明授权
    System and method for exporting report results from a reporting system 有权
    从报告系统导出报告结果的系统和方法

    公开(公告)号:US09183317B1

    公开(公告)日:2015-11-10

    申请号:US09884468

    申请日:2001-06-20

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30563 G06F17/30896

    摘要: A technique for exporting results from a reporting system report in a format type including a datamart, PDF file, flat file, Excel™ file, HTML file, and XML file or in another relational database management system (RDBMS) format. In one embodiment, the technique is realized through a method and a system for automatically exporting results from a business intelligence, OLAP, or other reporting system. One embodiment of the present invention involves a method of enabling a user to designate a report desired for execution as an export-report. When the report is processed, the report is exported into a datamart or other format and made available for access by the user through one or more different types of user devices. The user may then further manipulate or export the results from the datamart to a file type as desired.

    摘要翻译: 一种用于以包括数据表,PDF文件,平面文件,Excel™文件,HTML文件和XML文件或其他关系数据库管理系统(RDBMS)格式的格式类型的报表系统报表导出结果的技术。 在一个实施例中,该技术通过用于从商业智能,OLAP或其他报告系统自动导出结果的方法和系统来实现。 本发明的一个实施例涉及一种使用户能够将执行期望的报告指定为导出报告的方法。 报告处理后,报告将导出为数据表或其他格式,并可供用户通过一个或多个不同类型的用户设备进行访问。 然后,用户可以根据需要进一步将结果从数据分组操作或导出到文件类型。

    Systems and methods for custom grouping of data
    3.
    发明授权
    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.

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

    Technique for handling server session requests in a system having a plurality of servers
    5.
    发明授权
    Technique for handling server session requests in a system having a plurality of servers 有权
    在具有多个服务器的系统中处理服务器会话请求的技术

    公开(公告)号:US07113993B1

    公开(公告)日:2006-09-26

    申请号:US10162716

    申请日:2002-06-06

    IPC分类号: G06F15/16

    摘要: A technique for handling server session requests in a system having a plurality of servers is disclosed. In one embodiment, the technique includes receiving a request to create a session on one of the plurality of servers. In response to the request, a primary session is created on a first of the plurality of servers. After the primary session is created, at least one other of the plurality of servers are notified that the primary session has been created. Such notification allows for a backup session on the at least one other of the plurality of servers to take over for the primary session upon a failure on the first of the plurality of servers.

    摘要翻译: 公开了一种在具有多个服务器的系统中处理服务器会话请求的技术。 在一个实施例中,该技术包括接收在多个服务器之一上创建会话的请求。 响应于该请求,在多个服务器中的第一个服务器上创建主会话。 在创建主会话之后,通知多个服务器中的至少一个服务器已经创建了主会话。 这种通知允许多个服务器中的至少另一个服务器上的备份会话在多个服务器中的第一个上的故障时接管主会话。

    System and method for syntax abstraction in query language generation
    6.
    发明授权
    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
    8.
    发明授权
    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语句到关系数据库,将初步结果传递给外部分析引擎,并将数据保存回关系数据库进行进一步处理,直到执行多步计算。

    System and method for multiple pass cooperative processing
    9.
    发明授权
    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语句到关系数据库,将初步结果传递给外部分析引擎,并将数据保存回关系数据库进行进一步处理,直到执行多步计算。

    Technique for limiting access to the resources of a system
    10.
    发明授权
    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.

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