利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

10 条记录 (耗时 0.02 秒)

    Systems and methods for providing custom or calculated data members in queries of a business intelligence server
    6.
    发明授权
    Systems and methods for providing custom or calculated data members in queries of a business intelligence server 有权
    在商业智能服务器的查询中提供自定义或计算的数据成员的系统和方法

    公开(公告)号：US08458206B2

    公开(公告)日：2013-06-04

    申请号：US13038243

    申请日：2011-03-01

    申请人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    发明人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30401 ,  G06Q10/10

    摘要： A business intelligence (BI) server and repository are described which support a set of customized and/or calculated data members. In accordance with an embodiment, the BI server maintains a connection to a plurality of data sources which may store a set of dimension members. The data source can be relational, file storage based, multidimensional and other types. In accordance with an embodiment, the BI server can accept queries from the user that contain calculated members as a parameter. The calculated member is defined by an expression including multiple dimension members and one or more arithmetic operators. The BI server can parse and validate the query and rewrite the query for the data source. After the query is rewritten and optimized, it is executed against the data source and a set of results is received.

    摘要翻译： 描述了商业智能（BI）服务器和存储库，其支持一组定制和/或计算的数据成员。 根据一个实施例，BI服务器保持与可以存储一组维度成员的多个数据源的连接。 数据源可以是关系，基于文件存储，多维和其他类型。 根据实施例，BI服务器可以接受来自包含计算的成员的用户的查询作为参数。 计算的成员由包括多个维度成员和一个或多个算术运算符的表达式定义。 BI服务器可以解析并验证查询并重写数据源的查询。 在查询被重写和优化之后，它被针对数据源执行并且接收到一组结果。

    SYSTEMS AND METHODS FOR PROVIDING MULTILINGUAL SUPPORT FOR DATA USED WITH A BUSINESS INTELLIGENCE SERVER
    7.
    发明申请
    SYSTEMS AND METHODS FOR PROVIDING MULTILINGUAL SUPPORT FOR DATA USED WITH A BUSINESS INTELLIGENCE SERVER 审中-公开
    为业务智能服务器提供数据提供多种支持的系统和方法

    公开(公告)号：US20110295837A1

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

    申请号：US13038252

    申请日：2011-03-01

    申请人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    发明人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    IPC分类号： G06F17/30

    CPC分类号： G06F16/245

    摘要： A business intelligence (BI) server is described that supports data and schemas stored in multiple languages. The BI server implements a lookup table and lookup function that allows users to work with queries in different languages. When the user logs in, a session object is created for the user, which maintains the state information. A session variable specifies the language currently being used by the user. The BI server can inspect this session variable to determine the language of the user and perform the lookup translations as necessary. For example, if the language used by the session is different from the language of the base table storing the necessary information, the BI server can perform a translation by invoking a lookup function. The execution of the lookup can include performing a join operation of the base table with the lookup table to yield a translated value requested by the query.

    摘要翻译： 描述了支持以多种语言存储的数据和模式的商业智能（BI）服务器。 BI服务器实现查找表和查找功能，允许用户使用不同语言的查询。 当用户登录时，为用户创建会话对象，维护状态信息。 会话变量指定用户当前使用的语言。 BI服务器可以检查此会话变量以确定用户的语言，并根据需要执行查找转换。 例如，如果会话使用的语言与存储必要信息的基本表的语言不同，则BI服务器可以通过调用查找功能来执行翻译。 查找的执行可以包括使用查找表执行基表的连接操作，以产生由查询请求的翻译值。

    SYSTEMS AND METHODS FOR PROVIDING CUSTOM OR CALCULATED DATA MEMBERS IN QUERIES OF A BUSINESS INTELLIGENCE SERVER
    8.
    发明申请
    SYSTEMS AND METHODS FOR PROVIDING CUSTOM OR CALCULATED DATA MEMBERS IN QUERIES OF A BUSINESS INTELLIGENCE SERVER 有权
    在业务智能服务器查询中提供自定义或计算数据成员的系统和方法

    公开(公告)号：US20110295870A1

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

    申请号：US13038243

    申请日：2011-03-01

    申请人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    发明人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30401 ,  G06Q10/10

    摘要： A business intelligence (BI) server and repository are described which support a set of customized and/or calculated data members. In accordance with an embodiment, the BI server maintains a connection to a plurality of data sources which may store a set of dimension members. The data source can be relational, file storage based, multidimensional and other types. In accordance with an embodiment, the BI server can accept queries from the user that contain calculated members as a parameter. The calculated member is defined by an expression including multiple dimension members and one or more arithmetic operators. The BI server can parse and validate the query and rewrite the query for the data source. After the query is rewritten and optimized, it is executed against the data source and a set of results is received.

    摘要翻译： 描述了商业智能（BI）服务器和存储库，其支持一组定制和/或计算的数据成员。 根据一个实施例，BI服务器保持与可以存储一组维度成员的多个数据源的连接。 数据源可以是关系，基于文件存储，多维和其他类型。 根据实施例，BI服务器可以接受来自包含计算的成员的用户的查询作为参数。 计算的成员由包括多个维度成员和一个或多个算术运算符的表达式定义。 BI服务器可以解析并验证查询并重写数据源的查询。 在查询被重写和优化之后，它被针对数据源执行并且接收到一组结果。

    SYSTEMS AND METHODS FOR PROVIDING VALUE HIERARCHIES, RAGGED HIERARCHIES AND SKIP-LEVEL HIERARCHIES IN A BUSINESS INTELLIGENCE SERVER
    9.
    发明申请
    SYSTEMS AND METHODS FOR PROVIDING VALUE HIERARCHIES, RAGGED HIERARCHIES AND SKIP-LEVEL HIERARCHIES IN A BUSINESS INTELLIGENCE SERVER 有权
    在商业智能服务器中提供价值层次分析，RAGGED层次分析和跳跃层次分析的系统和方法

    公开(公告)号：US20110295836A1

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

    申请号：US13038231

    申请日：2011-03-01

    申请人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    发明人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30401 ,  G06Q10/10

    摘要： A business intelligence (BI) server and repository are described which support a set of hierarchical relationships among the data. The BI server receives user input specifying a set of parent-child or other ancestral relationship among a set of data in a data source. The BI server generates a set of SQL queries and executes the queries to pre-populate a set of tables which specify the parent child relationships among the data in the data source. One such table is a parent-child relationship closure table that defines the inter-member relationships among the data members. Once the tables are populated, the BI server uses the closure tables to answer queries that require knowledge of the ancestral relationships among data.

    摘要翻译： 描述了支持数据之间的一组分层关系的商业智能（BI）服务器和存储库。 BI服务器接收指定数据源中的一组数据之间的父子节点或其他祖先关系集的用户输入。 BI服务器生成一组SQL查询，并执行查询以预先填充一组指定数据源中数据之间的父子关系的表。 一个这样的表是一个父子关系关系表，用于定义数据成员之间的成员之间的关系。 一旦表格被填充，BI服务器使用关闭表来回答需要知道数据之间的祖先关系的查询。

    Systems and methods for providing value hierarchies, ragged hierarchies and skip-level hierarchies in a business intelligence server
    10.
    发明授权
    Systems and methods for providing value hierarchies, ragged hierarchies and skip-level hierarchies in a business intelligence server 有权
    在商业智能服务器中提供价值层次结构，分层层次结构和跳过层级的系统和方法

    公开(公告)号：US08326857B2

    公开(公告)日：2012-12-04

    申请号：US13038231

    申请日：2011-03-01

    申请人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    发明人： Roger Bolsius ,  Raghuram Venkatasubramanian ,  Ling Ni ,  Donko Donjerkovic ,  Saugata Chowdhury

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30401 ,  G06Q10/10

    摘要： A business intelligence (BI) server and repository are described which support a set of hierarchical relationships among the data. The BI server receives user input specifying a set of parent-child or other ancestral relationship among a set of data in a data source. The BI server generates a set of SQL queries and executes the queries to pre-populate a set of tables which specify the parent child relationships among the data in the data source. One such table is a parent-child relationship closure table that defines the inter-member relationships among the data members. Once the tables are populated, the BI server uses the closure tables to answer queries that require knowledge of the ancestral relationships among data.

    摘要翻译： 描述了支持数据之间的一组分层关系的商业智能（BI）服务器和存储库。 BI服务器接收指定数据源中的一组数据之间的父子节点或其他祖先关系集的用户输入。 BI服务器生成一组SQL查询，并执行查询以预先填充一组指定数据源中数据之间的父子关系的表。 一个这样的表是一个父子关系关系表，用于定义数据成员之间的成员之间的关系。 一旦表格被填充，BI服务器使用关闭表来回答需要知道数据之间的祖先关系的查询。