-
公开(公告)号:US20080222189A1
公开(公告)日:2008-09-11
申请号:US11714308
申请日:2007-03-06
申请人: Oleg Gregory Ovanesyan , Catalin Ion Sipos , Eric Scott Danas , Lewis C. Levin , Xiaohong Yang , Parul Manek , Peter Anthony Bull , Vladimir Sergeyev , Alvaro Peon Sanchez
发明人: Oleg Gregory Ovanesyan , Catalin Ion Sipos , Eric Scott Danas , Lewis C. Levin , Xiaohong Yang , Parul Manek , Peter Anthony Bull , Vladimir Sergeyev , Alvaro Peon Sanchez
IPC分类号: G06F17/00
CPC分类号: G06Q10/06 , G06F16/283
摘要: A source multidimensional data model is associated with a target multidimensional data model, for purposes of, for example, copying or linking data between the source and the target. Individual dimensions are mapped from the source to the target. Within each mapped dimension, individual dimension members are mapped from the source to the target. The resulting association may be stored and utilized to generate executable statements for copying or linking data between the source and the target.
摘要翻译: 源多维数据模型与目标多维数据模型相关联,用于例如复制或链接源和目标之间的数据。 个别维度从源映射到目标。 在每个映射维度中,单个维度成员从源映射到目标。 所得到的关联可以被存储和利用来生成用于在源和目标之间复制或链接数据的可执行语句。
-
公开(公告)号:US20080208720A1
公开(公告)日:2008-08-28
申请号:US11710702
申请日:2007-02-26
申请人: Randy Dong , Lewis C. Levin , Rou-Peng Huang , Peiyuan Yan , Xiaohong Yang , Peter Bull , Scott Sebelsky
发明人: Randy Dong , Lewis C. Levin , Rou-Peng Huang , Peiyuan Yan , Xiaohong Yang , Peter Bull , Scott Sebelsky
IPC分类号: G06Q40/00
摘要: Financial intelligence architecture that employs financial types that are combined with rules to build financial behavior into the product. Types have behaviors such that types can be assigned that lead to the physical creation of underlying code which embodies the behaviors. Extensibility is provided at least by type parameterization and new type creation. Because types are a design time experience, types are two-way and can be modified, even after instantiation. This allows for mixing and matching of types and underlying behavior giving the system more flexibility at design time while providing a huge simplification of all the details that actually go into such financial applications. The type library is a set of rules that produce metadata, which metadata is later processed by a separate engine to produce the physical schema. The type library defines the basic interactions, data types, and behaviors for predefined dimensions in the system.
摘要翻译: 金融情报架构,采用结合规则的金融类型,将财务行为纳入产品。 类型具有这样的行为,即可以分配类型,从而导致体现行为的底层代码的物理创建。 至少通过类型参数化和新类型创建来提供可扩展性。 因为类型是设计时间体验,所以类型是双向的,即使在实例化之后也可以进行修改。 这允许混合和匹配类型和底层行为,使系统在设计时更灵活,同时提供了实际进入这种财务应用程序的所有细节的巨大简化。 类型库是一组生成元数据的规则,后来由单独的引擎处理元数据以生成物理模式。 类型库定义系统中预定义维度的基本交互,数据类型和行为。
-
公开(公告)号:US08239299B2
公开(公告)日:2012-08-07
申请号:US11710702
申请日:2007-02-26
申请人: Randy Dong , Lewis C. Levin , Rou-Peng Huang , Peiyuan Yan , Xiaohong Yang , Peter Bull , Scott Sebelsky
发明人: Randy Dong , Lewis C. Levin , Rou-Peng Huang , Peiyuan Yan , Xiaohong Yang , Peter Bull , Scott Sebelsky
IPC分类号: G06Q40/00
摘要: Financial intelligence architecture that employs financial types that are combined with rules to build financial behavior into the product. Types have behaviors such that types can be assigned that lead to the physical creation of underlying code which embodies the behaviors. Extensibility is provided at least by type parameterization and new type creation. Because types are a design time experience, types are two-way and can be modified, even after instantiation. This allows for mixing and matching of types and underlying behavior giving the system more flexibility at design time while providing a huge simplification of all the details that actually go into such financial applications. The type library is a set of rules that produce metadata, which metadata is later processed by a separate engine to produce the physical schema. The type library defines the basic interactions, data types, and behaviors for predefined dimensions in the system.
摘要翻译: 金融情报架构,采用结合规则的金融类型,将财务行为纳入产品。 类型具有这样的行为,即可以分配类型,从而导致体现行为的底层代码的物理创建。 至少通过类型参数化和新类型创建来提供可扩展性。 因为类型是设计时间体验,所以类型是双向的,即使在实例化之后也可以进行修改。 这允许混合和匹配类型和底层行为,使系统在设计时更灵活,同时提供了实际进入这种财务应用程序的所有细节的巨大简化。 类型库是一组生成元数据的规则,后来由单独的引擎处理元数据以生成物理模式。 类型库定义系统中预定义维度的基本交互,数据类型和行为。
-
公开(公告)号:US08990147B2
公开(公告)日:2015-03-24
申请号:US13306156
申请日:2011-11-29
申请人: Xiaohong Yang , Luming Wang
发明人: Xiaohong Yang , Luming Wang
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.
摘要翻译: 本文描述了基于数据库查询来定义子立方体的范围的技术。 接收到请求,以执行存储在服务器计算机上的多维数据库(例如立方体)的查询。 响应于该请求,基于查询确定多维数据库的子部分(称为子立方体)的范围。 可以通过识别执行查询所需的立方体的最小子部分来确定子立方体的范围。 一旦确定了作用域,则在服务器计算机上生成子立方体,并将其发送到客户端计算机。 客户端计算机在本地存储子立方体,并对存储在客户端计算机上的子立方体执行请求的数据库查询。 可以提供用户界面,用户可以通过该界面来修改基于查询确定的子立方体的范围。
-
公开(公告)号:US20080208880A1
公开(公告)日:2008-08-28
申请号:US11710328
申请日:2007-02-23
申请人: George Randall Dong , Jeffrey A. Wang , Patricia O'Connor Sebelsky , Zhenyu Tang , Sridharan V. Ramanathan , Peter Eberhardy , Hai Huang , Xiaohong Yang
发明人: George Randall Dong , Jeffrey A. Wang , Patricia O'Connor Sebelsky , Zhenyu Tang , Sridharan V. Ramanathan , Peter Eberhardy , Hai Huang , Xiaohong Yang
IPC分类号: G06F7/00
CPC分类号: G06F17/30592 , G06F17/30312 , G06F17/30333 , G06F17/30477 , Y10S707/99933
摘要: Sharable extended cell information is used by multidimensional data models to enable cell annotations and line item details. Annotations are notes stored with a cell in a multidimensional dataset. Line item details permit levels of numeric detail below the lowest dimensional granularity. When receiving a multidimensional dataset in response to a query, a client application receives indicator information at the cell level, indicating to the client application that extended cell information is retrievable.
摘要翻译: 多维数据模型使用可扩展单元格信息来启用单元格注释和订单项详细信息。 注释是与单元格存储在多维数据集中的注释。 订单项详细信息允许低于最小尺寸粒度的数字细节级别。 当响应于查询接收到多维数据集时,客户端应用程序在单元级别接收指示符信息,向客户机应用程序指示扩展单元信息是可检索的。
-
公开(公告)号: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获取和显示数据。 提供了实现,用于创建一种机制来定义如何呈现给最终用户现有数据,指示写入可能的位置,捕获用户输入,然后将更改的数据提交回数据存储库。 因此,定义了一个“表单”,它提供了一个“数据输入报告”区域。
-
公开(公告)号:US20060107196A1
公开(公告)日:2006-05-18
申请号:US10987013
申请日:2004-11-12
申请人: Lakshmi Thanu , Peter Eberhardy , Dylan Huang , Xiaohong Yang
发明人: Lakshmi Thanu , Peter Eberhardy , Dylan Huang , Xiaohong Yang
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.
-
公开(公告)号:US08560519B2
公开(公告)日:2013-10-15
申请号: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.
摘要翻译: 链接和/或嵌入文档之间的关系以及共享数据源的文档通过虚拟文档进行捕获和渲染。 创建代表与相关文档相关联的链接/嵌入文档和数据源的虚拟文档。 真实文档和虚拟文档之间的关系与搜索结果一起保留并呈现,为用户提供了搜索结果的全面图片。
-
公开(公告)号:US08103687B2
公开(公告)日:2012-01-24
申请号:US12132075
申请日:2008-06-03
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.
摘要翻译: 描述了用于选择用于生成非对称查询的成员集的工具和技术。 由该描述提供的用户界面可以包括包括相应成员的不同维度的表示。 这些维度定义了运行查询以生成请求的报告的分层数据结构。 用户界面可以包括与不同尺寸相关联的构件的表示,其中来自不同维度的成员以选定顺序排列。 用户界面还可以提供激活用于构建查询的对称或非对称呈现模式的选择工具。 在对称渲染模式中,查询交叉连接从一个维度中选择的所有成员,其中所有成员从另一个维度中选择。 在非对称渲染模式下,查询将来自一个维度的一阶成员与来自另一个维度的第一个成员交叉连接,第二个成员从一个维度与另一个维度的第二个成员进行交叉连接,依此类推。
-
-
-
-
-
-
-
-
-