利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

43 条记录 (耗时 0.018 秒)

    Metadata-based form rendering and write-back
    1.
    发明申请
    Metadata-based form rendering and write-back 审中-公开
    基于元数据的表单呈现和回写

    公开(公告)号：US20070011177A1

    公开(公告)日：2007-01-11

    申请号：US11175701

    申请日：2005-07-05

    申请人： Alisson Sol ,  Peter Eberhardy ,  Xiaohong Yang

    发明人： Alisson Sol ,  Peter Eberhardy ,  Xiaohong Yang

    IPC分类号： G06F7/00

    CPC分类号： G06F16/20

    摘要： RDL (report description language) is an XML-based schema that has been designed and extended for standardizing report generation and maintenance. Reports can be generated that allow inspection of data that can come from several sources. The data can come from several arbitrary data sources, which can then be obtained and displayed using RDL. Implementations are provided for creating a mechanism to define how to present to end-users existing data, indicate where writing is possible, capture the user input, and later submit the changed data back to the data repository. Accordingly, a “Form” is defined, which provides a “report with data entry” areas.

    摘要翻译： RDL（报告描述语言）是一种基于XML的架构，已经设计和扩展，用于标准化报告生成和维护。 可以生成报告，允许检查可能来自多个来源的数据。 数据可以来自几个任意数据源，然后可以使用RDL获取和显示数据。 提供了实现，用于创建一种机制来定义如何呈现给最终用户现有数据，指示写入可能的位置，捕获用户输入，然后将更改的数据提交回数据存储库。 因此，定义了一个“表单”，它提供了一个“数据输入报告”区域。

    Selecting member sets for generating asymmetric queries
    2.
    发明授权
    Selecting member sets for generating asymmetric queries 有权
    选择用于生成非对称查询的成员集

    公开(公告)号：US08103687B2

    公开(公告)日：2012-01-24

    申请号：US12132075

    申请日：2008-06-03

    申请人： Patrick John Baumgartner ,  Luming Wang ,  Jason Malcolm ,  Xiaohong Yang ,  Peter Eberhardy

    发明人： Patrick John Baumgartner ,  Luming Wang ,  Jason Malcolm ,  Xiaohong Yang ,  Peter Eberhardy

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

    CPC分类号： G06F17/30

    摘要： Tools and techniques are described for selecting member sets for generating asymmetric queries. User interfaces provided by this description may include representations of different dimensions that include respective members. These dimensions define hierarchical data structures against which queries are run to generate requested reports. The user interfaces may include representations of members associated with different dimensions, with members from different dimensions arranged in selected orders. The user interfaces may also provide selection tools that activate symmetrical or asymmetrical rendering modes for constructing the query. In the symmetrical rendering mode, the query cross-joins all of the members selected from one dimension with all of the members selected from the other dimension. In the asymmetrical rendering mode, the query cross-joins the first-ordered member from one dimension with the first-ordered member from another dimension, cross-joins the second member from one dimension with the second member from another dimension, and so on.

    摘要翻译： 描述了用于选择用于生成非对称查询的成员集的工具和技术。 由该描述提供的用户界面可以包括包括相应成员的不同维度的表示。 这些维度定义了运行查询以生成请求的报告的分层数据结构。 用户界面可以包括与不同尺寸相关联的构件的表示，其中来自不同维度的成员以选定顺序排列。 用户界面还可以提供激活用于构建查询的对称或非对称呈现模式的选择工具。 在对称渲染模式中，查询交叉连接从一个维度中选择的所有成员，其中所有成员从另一个维度中选择。 在非对称渲染模式下，查询将来自一个维度的一阶成员与来自另一个维度的第一个成员交叉连接，第二个成员从一个维度与另一个维度的第二个成员进行交叉连接，依此类推。

    Method for expanding and collapsing data cells in a spreadsheet report
    7.
    发明申请
    Method for expanding and collapsing data cells in a spreadsheet report 审中-公开

    公开(公告)号：US20060107196A1

    公开(公告)日：2006-05-18

    申请号：US10987013

    申请日：2004-11-12

    申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Dylan Huang ,  Xiaohong Yang

    发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Dylan Huang ,  Xiaohong Yang

    IPC分类号： G06F17/00 ,  G06F15/00 ,  G06F17/21

    CPC分类号： G06F17/246 ,  G06F17/212 ,  G06F17/24 ,  G06F17/245

    摘要： Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.

    Two pass calculation to optimize formula calculations for a spreadsheet
    8.
    发明申请
    Two pass calculation to optimize formula calculations for a spreadsheet 审中-公开
    两次计算，以优化电子表格的公式计算

    公开(公告)号：US20060085386A1

    公开(公告)日：2006-04-20

    申请号：US10969381

    申请日：2004-10-19

    申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Xiaohong Yang

    发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Xiaohong Yang

    IPC分类号： G06F17/30 ,  G06F17/00 ,  G06F17/24

    CPC分类号： G06F17/246 ,  G06F16/24556 ,  G06F16/24557

    摘要： Current cell values are provided to a client using two-passes. When a first request to provide values is received during a first pass, default values are provided to the client. Upon receiving each value request, the formula parameters are collected that are associated with the cell. The formula parameters are parsed to determine data that is to be retrieved from a database. Once the locations for all of the data to be retrieved has been determined, the data is retrieved from a database in as few as hits as possible. After obtaining the current values from the database, the client is informed to request the values a second time. When the second request to provide values is received, the client is provided with the calculated values during the second pass.

    摘要翻译： 当前单元格值使用双程提供给客户端。 当在第一次通过期间收到提供值的第一个请求时，将向客户端提供默认值。 收到每个值请求后，收集与该单元格关联的公式参数。 解析公式参数以确定要从数据库检索的数据。 一旦确定要检索的所有数据的位置，就尽可能少地从数据库中检索数据。 在从数据库获取当前值之后，通知客户端再次请求值。 当接收到提供值的第二请求时，在第二次通过期间向客户端提供计算的值。

    Defining sub-cube scope based upon a query
    9.
    发明授权
    Defining sub-cube scope based upon a query 有权
    基于查询定义子立方体范围

    公开(公告)号：US08990147B2

    公开(公告)日：2015-03-24

    申请号：US13306156

    申请日：2011-11-29

    申请人： Xiaohong Yang ,  Luming Wang

    发明人： Xiaohong Yang ,  Luming Wang

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

    CPC分类号： G06F17/30592

    摘要： Technologies are described herein for defining the scope of a sub-cube based upon a database query. A request is received to perform a query of a multi-dimensional database, such as a cube, stored at a server computer. In response to the request, the scope for a sub-portion, called a sub-cube, of the multi-dimensional database is determined based upon the query. The scope of the sub-cube may be determined by identifying the minimum sub-portion of the cube necessary to perform the query. Once the scope has been determined, the sub-cube is generated at the server computer and transmitted to a client computer. The client computer stores the sub-cube locally and performs the requested database query on the sub-cube stored at the client computer. A user interface may be provided through which a user can modify the scope of the sub-cube determined based upon the query.

    摘要翻译： 本文描述了基于数据库查询来定义子立方体的范围的技术。 接收到请求，以执行存储在服务器计算机上的多维数据库（例如立方体）的查询。 响应于该请求，基于查询确定多维数据库的子部分（称为子立方体）的范围。 可以通过识别执行查询所需的立方体的最小子部分来确定子立方体的范围。 一旦确定了作用域，则在服务器计算机上生成子立方体，并将其发送到客户端计算机。 客户端计算机在本地存储子立方体，并对存储在客户端计算机上的子立方体执行请求的数据库查询。 可以提供用户界面，用户可以通过该界面来修改基于查询确定的子立方体的范围。

    Defining sub-cube scope based upon a query
    10.
    发明授权
    Defining sub-cube scope based upon a query 有权
    基于查询定义子立方体范围

    公开(公告)号：US08082239B2

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

    申请号：US12025696

    申请日：2008-02-04

    申请人： Xiaohong Yang ,  Luming Wang

    发明人： Xiaohong Yang ,  Luming Wang

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30592

    摘要： Technologies are described herein for defining the scope of a sub-cube based upon a database query. A request is received to perform a query of a multi-dimensional database, such as a cube, stored at a server computer. In response to the request, the scope for a sub-portion, called a sub-cube, of the multi-dimensional database is determined based upon the query. The scope of the sub-cube may be determined by identifying the minimum sub-portion of the cube necessary to perform the query. Once the scope has been determined, the sub-cube is generated at the server computer and transmitted to a client computer. The client computer stores the sub-cube locally and performs the requested database query on the sub-cube stored at the client computer. A user interface may be provided through which a user can modify the scope of the sub-cube determined based upon the query.

    摘要翻译： 本文描述了基于数据库查询来定义子立方体的范围的技术。 接收到请求，以执行存储在服务器计算机上的多维数据库（例如立方体）的查询。 响应于该请求，基于查询确定多维数据库的子部分（称为子立方体）的范围。 可以通过识别执行查询所需的立方体的最小子部分来确定子立方体的范围。 一旦确定了作用域，则在服务器计算机上生成子立方体，并将其发送到客户端计算机。 客户端计算机在本地存储子立方体，并对存储在客户端计算机上的子立方体执行请求的数据库查询。 可以提供用户界面，用户可以通过该界面来修改基于查询确定的子立方体的范围。