公开(公告)号：US20110231386A1

公开(公告)日：2011-09-22

申请号：US12727739

申请日：2010-03-19

申请人： Luming Wang ,  Xiaohong Yang ,  Anton Amirov ,  Pablo Barvo

发明人： Luming Wang ,  Xiaohong Yang ,  Anton Amirov ,  Pablo Barvo

IPC分类号： G06F17/30

CPC分类号： G06F17/30864

摘要： Relationships between linked and/or embedded documents as well as documents sharing data source(s) are captured and rendered through virtual documents. Virtual documents are created representing linked/embedded documents and data sources associated with a relevant document. Relationships between real and virtual documents are preserved and rendered along with search results providing a user a comprehensive picture of search results.

摘要翻译： 链接和/或嵌入文档之间的关系以及共享数据源的文档通过虚拟文档进行捕获和渲染。 创建代表与相关文档相关联的链接/嵌入文档和数据源的虚拟文档。 真实文档和虚拟文档之间的关系与搜索结果一起保留并呈现，为用户提供了搜索结果的全面图片。

公开(公告)号：US20090300527A1

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

申请号：US12131678

申请日：2008-06-02

申请人： Jason L. Malcolm ,  Patrick J. Baumgartner ,  Luming Wang ,  Xiaohong Yang

发明人： Jason L. Malcolm ,  Patrick J. Baumgartner ,  Luming Wang ,  Xiaohong Yang

IPC分类号： G06F3/048

CPC分类号： G06Q10/06

摘要： A user interface displays a group of related documents such that bulk operations may be performed on them without requiring the user to individually access each document to perform an action. Properties, such as a status, contributor information, submission date and submission deadline and the like are also displayed with the documents. From this information, a user may decide to open a specific document and/or version of the document for review while bulk approving the other displayed documents. A user may perform an action on all or part of the displayed documents and their versions from the user interface. In this way, the efficiency of the workflow may be increased since the user doesn't have to individually access each document to perform the action.

摘要翻译： 用户界面显示一组相关文档，使得可以在其上执行批量操作，而不需要用户单独访问每个文档以执行动作。 属性，如状态，贡献者信息，提交日期和提交截止日期等也与文档一起显示。 根据该信息，用户可以决定在批准其他显示的文档的同时打开文档的特定文档和/或版本以供审核。 用户可以从用户界面对所有或部分显示的文档及其版本执行操作。 以这种方式，可以增加工作流的效率，因为用户不必单独地访问每个文档来执行动作。

公开(公告)号：US20080221958A1

公开(公告)日：2008-09-11

申请号：US11714975

申请日：2007-03-07

申请人： Patrick Baumgartner ,  Alisson Sol ,  Peter Eberhardy ,  Luming Wang ,  Mark Yang ,  Amer Shahnawaz

发明人： Patrick Baumgartner ,  Alisson Sol ,  Peter Eberhardy ,  Luming Wang ,  Mark Yang ,  Amer Shahnawaz

IPC分类号： G06F9/46

CPC分类号： G06Q10/00 ,  G06Q10/0631

摘要： Techniques to manage information for dynamic reports are described. An apparatus may comprise a business planning application module to update a current period reference to a time member of a time dimension, generate a rolling data entry form with actual data members and forecast data members based on the current period reference, and set a data locking mode for the actual data members and a data access mode for the forecast data members. Other embodiments are described and claimed.

摘要翻译： 描述了管理动态报告信息的技术。 设备可以包括业务规划应用模块，用于更新当前时间段对时间维度的时间成员的参考，基于当前周期参考生成具有实际数据成员和预测数据成员的滚动数据输入表，并且设置数据锁定 实际数据成员的模式和预测数据成员的数据访问模式。 描述和要求保护其他实施例。

公开(公告)号：US08515906B2

公开(公告)日：2013-08-20

申请号：US13494650

申请日：2012-06-12

申请人： Jin Wang ,  Luming Wang ,  Malik Hussain ,  Zaiwei Du ,  Zhenyu Tang ,  Patrick J. Baumgartner ,  Mark Xiaohong Yang ,  Peter Eberhardy

发明人： Jin Wang ,  Luming Wang ,  Malik Hussain ,  Zaiwei Du ,  Zhenyu Tang ,  Patrick J. Baumgartner ,  Mark Xiaohong Yang ,  Peter Eberhardy

IPC分类号： G06F17/30

CPC分类号： G06F17/30578

摘要： Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage.

摘要翻译： 数据处理架构，其中提交者可以通过异步接口将数据和/或元数据更改写入目的地。 该架构包括一个票务系统，以向提交者发出一张票据（唯一标识符），以响应从提交者接收更改列表。 当在目的地成功完成更改时，缓存的目标数据可以重新下载到提交者，并且缓存在提交者中的更改被丢弃。 缺少此功能，用户必须手动管理缓存的更改和缓存的数据。 该架构可以分布在多个提交者可以提交更改列表。 目的地通过管理提交来提供数据完整性，以帮助确保多个提交中的数据完整性。 提交者提供自动更改清理功能，以便更改列表不会影响性能，内存和存储空间。

公开(公告)号：US20120072447A1

公开(公告)日：2012-03-22

申请号：US13306156

申请日：2011-11-29

申请人： 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.

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

公开(公告)号：US20090300048A1

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

申请号：US12132075

申请日：2008-06-03

申请人： PATRICK JONH BAUMGARTNER ,  LUMING WANG ,  JASON MALCOLM ,  XIAOHONG YANG ,  PETER EBERHARDY

发明人： PATRICK JONH BAUMGARTNER ,  LUMING WANG ,  JASON MALCOLM ,  XIAOHONG YANG ,  PETER EBERHARDY

IPC分类号： 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.

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

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：US07617221B2

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

申请号：US11675841

申请日：2007-02-16

申请人： Patrick Baumgartner ,  Alisson A. S. Sol ,  Peter Eberhardy ,  Luming Wang ,  Mark Yang ,  Amer Shahnawaz

发明人： Patrick Baumgartner ,  Alisson A. S. Sol ,  Peter Eberhardy ,  Luming Wang ,  Mark Yang ,  Amer Shahnawaz

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/2294 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99939

摘要： A computer-implemented method includes selecting a first member of a first dimension of a database to be included at a first location in a report. The first member includes first data to be retrieved from the database. A blank space to be added at a second location relative to the first member is also selected. A database query is generated that includes a first instruction to retrieve first data included in the first member. The first instruction is located at a first position in the query and the first data will appear in the report at the first location. The database query also includes a second instruction to retrieve a null set of data. The second instruction is located at a second position in the query and the null set of data will appear in the report at the second location.

摘要翻译： 计算机实现的方法包括选择要包括在报告中的第一位置的数据库的第一维的第一成员。 第一个成员包括要从数据库检索的第一个数据。 还选择要在第二位置相对于第一构件添加的空白空间。 生成数据库查询，其包括用于检索第一成员中包括的第一数据的第一指令。 第一条指令位于查询中的第一个位置，第一个数据将显示在第一个位置的报表中。 数据库查询还包括检索一组空数据的第二条指令。 第二条指令位于查询中的第二个位置，空值数据集将出现在第二个位置的报表中。

公开(公告)号：US20090113283A1

公开(公告)日：2009-04-30

申请号：US11931857

申请日：2007-10-31

申请人： Alisson A.S. Sol ,  Luming Wang ,  Xiaohong Mark Yang ,  Patrick J. Baumgartner ,  Peter Eberhardy

发明人： Alisson A.S. Sol ,  Luming Wang ,  Xiaohong Mark Yang ,  Patrick J. Baumgartner ,  Peter Eberhardy

IPC分类号： G06F15/00

CPC分类号： G06F17/246

摘要： An interface for designing a report is provided, with elements of the report being disposed at intersections of report positions and configured to present information derived from data in a database. A formula is associated with one or more selected elements in the report to generate a result for the one or more selected elements. A tuple identifying the report positions of the one or more selected elements is associated and stored with the formula in a formula list associated with the report. The report is configured so that, when the report is generated, it is determined whether identifying report positions corresponding to an identified element in the report correspond with the tuple in the formula list. Upon determining the tuple corresponds with the identifying report positions for the identified element, the formula associated with the tuple is applied to generate the result.

摘要翻译： 提供了一种用于设计报告的界面，其中报告的要素被布置在报告位置的交点处，并被配置为呈现从数据库中的数据导出的信息。 公式与报告中的一个或多个所选元素相关联，以生成一个或多个所选元素的结果。 识别一个或多个所选元素的报告位置的元组与公式相关联并存储在与报告相关联的公式列表中。 报告被配置为使得当生成报告时，确定与报告中的所识别的元素相对应的识别报告位置是否与公式列表中的元组相对应。 在确定元组对应于所识别的元素的识别报告位置时，应用与元组相关联的公式以生成结果。