VIRTUAL MULTIDIMENSIONAL DATASETS FOR ENTERPRISE SOFTWARE SYSTEMS
    51.
    发明申请
    VIRTUAL MULTIDIMENSIONAL DATASETS FOR ENTERPRISE SOFTWARE SYSTEMS 有权
    企业软件系统的虚拟多维数据

    公开(公告)号:US20080046481A1

    公开(公告)日:2008-02-21

    申请号:US11564011

    申请日:2006-11-28

    IPC分类号: G06F17/30

    摘要: Techniques are described for specifying virtual datasets within an enterprise software system. A computer-implemented system, for example, includes an enterprise planning system and a computing device coupled to the enterprise planning system via a network connection. The computing device includes an object store that stores a dataset, an application programming interface (API) that defines an operation for specifying the virtual dataset from the dataset, and an object model that stores a virtual dataset to the object store in response to receiving the operation defined by the API. The computing device further includes a plurality of applications that utilize the virtual dataset for a further operation defined by the API without resolving the virtual dataset. Because virtual dataset may be utilized without first resolving them, the virtual datasets may require less storage space within a memory, may automatically remain synchronous with the underlying dataset, and may quickly layer to more readily perform complicated operations.

    摘要翻译: 描述了在企业软件系统中指定虚拟数据集的技术。 例如,计算机实现的系统包括经由网络连接耦合到企业规划系统的企业规划系统和计算设备。 计算设备包括存储数据集的对象存储器,定义用于从数据集指定虚拟数据集的操作的应用程序编程接口(API)以及响应于接收到的对象模型而存储虚拟数据集到对象存储的对象模型 由API定义的操作。 计算设备还包括利用虚拟数据集进行由API定义的另外操作的多个应用,而不解决虚拟数据集。 因为虚拟数据集可以在没有首先解决它们的情况下被利用,所以虚拟数据集可能需要更少的存储空间,可以自动保持与底层数据集同步,并且可以快速地层以更容易地执行复杂的操作。

    System and method of processing queries
    52.
    发明授权
    System and method of processing queries 有权
    处理查询的系统和方法

    公开(公告)号:US07318058B2

    公开(公告)日:2008-01-08

    申请号:US10855078

    申请日:2004-05-27

    申请人: Michael E. Styles

    发明人: Michael E. Styles

    IPC分类号: G06F17/30

    摘要: A parallel detail join system for processing a many-to-one-to-many relationship is provided. The system comprises a parallel detail analysis module for detecting a many-to-one-to-many relationship among elements, and a parallel detail transformation module for generating a SQL: 1999 statement to handle the many-to-one-to-many relationship.

    摘要翻译: 提供了一种用于处理多对一关系的并行详细连接系统。 该系统包括用于检测元件之间的多对一关系的并行细节分析模块,以及用于生成用于处理多对一关系的SQL:1999语句的并行细节变换模块 。

    System and method of formulating queries in relational databases
    53.
    发明授权
    System and method of formulating queries in relational databases 失效
    在关系数据库中制定查询的系统和方法

    公开(公告)号:US07296040B2

    公开(公告)日:2007-11-13

    申请号:US10835522

    申请日:2004-04-29

    IPC分类号: G06F12/00

    摘要: The invention introduces a method and system to automatically derive the relationships between query subjects and query items within query subjects so that problems such as those that result in double courting of information are avoided. It provides for creating a report by first defining a model based on an existing database comprising two or more query subjects, each query subject comprising at least one fact query item and one primary key, then generating a hierarchy of sets and subsets of key query items within the model. Next a further fact is introduced into one of the query subjects. The expression is decomposed into sub-queries to prevent double counting of data in ambiguously defined situations. This is achieved using the introduced fact to determine that such decomposition is required. Finally, the data is accessed using the sub-queries, and a report is produced.

    摘要翻译: 本发明引入了一种自动导出查询对象与查询对象之间的查询项目之间的关系的方法和系统,从而避免了诸如导致信息双重追索的问题。 它提供了通过首先基于包括两个或更多个查询对象的现有数据库定义模型来创建报告,每个查询对象包括至少一个事实查询项和一个主键,然后生成关键查询项的集合和子集的层级 在模型中。 接下来,将其中一个查询主题引入另一个事实。 该表达式被分解为子查询,以防止在模糊定义的情况下重复计算数据。 这是使用引入的事实来确定这种分解是必需的。 最后,使用子查询访问数据,并生成报告。

    Rendering page sets
    54.
    发明授权
    Rendering page sets 有权
    呈现页面集

    公开(公告)号:US07275211B2

    公开(公告)日:2007-09-25

    申请号:US10883890

    申请日:2004-07-02

    IPC分类号: G06F15/00

    CPC分类号: G06F17/211 G06F17/248

    摘要: Method and system for rendering a page set having logical pages into a physical report output page. The logical pages may have implicit or explicit repeating orders, implicit or explicit rendering orders; or identification attributes.

    摘要翻译: 将具有逻辑页面的页面集合呈现到物理报告输出页面中的方法和系统。 逻辑页面可以具有隐式或显式的重复顺序,隐式或显式渲染顺序; 或识别属性。

    Query framework system and method
    55.
    发明申请
    Query framework system and method 有权
    查询框架系统和方法

    公开(公告)号:US20070073853A1

    公开(公告)日:2007-03-29

    申请号:US11473375

    申请日:2006-06-22

    IPC分类号: G06F15/177

    摘要: A query framework system is provided. The query framework system comprises a query framework service for consuming a query and returning a result set, a provider application programming interface for defining a consistent application programming interface for providers, one or more providers incorporating query processing logic, and a configuration repository for storing the list of the providers in the query framework system and their properties.

    摘要翻译: 提供查询框架系统。 查询框架系统包括用于消费查询并返回结果集的查询框架服务,用于为提供者​​定义一致的应用程序编程接口的提供者应用程序编程接口,包含查询处理逻辑的一个或多个提供者以及用于存储 查询框架系统中的提供者列表及其属性。

    Event management method and system
    56.
    发明申请
    Event management method and system 失效
    事件管理方法和系统

    公开(公告)号:US20070067773A1

    公开(公告)日:2007-03-22

    申请号:US11481570

    申请日:2006-07-06

    IPC分类号: G06F9/46

    摘要: Method and system in an event management system is disclosed. The method includes the step of creating an agent on a server in an event management system for monitoring an event. The event is present when a data achieving a predefined status defined by a business rule. The event management system includes a data source for generating the notification. The method further includes the steps of running the agent according to a schedule; generating the notification upon occurring of the event.

    摘要翻译: 公开了事件管理系统中的方法和系统。 该方法包括在用于监视事件的事件管理系统中的服务器上创建代理的步骤。 当达到由业务规则定义的预定义状态的数据时,存在该事件。 事件管理系统包括用于生成通知的数据源。 该方法还包括根据时间表运行代理的步骤; 在事件发生时产生通知。

    Business intelligence incorporated business process management system and method thereof
    57.
    发明申请
    Business intelligence incorporated business process management system and method thereof 有权
    商业智能结合业务流程管理系统及其方法

    公开(公告)号:US20070061283A1

    公开(公告)日:2007-03-15

    申请号:US11473596

    申请日:2006-06-23

    IPC分类号: G06F17/30 G06F9/44 G06F17/00

    CPC分类号: G06Q10/10

    摘要: A business process management system provides one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from one or more data sources of an organization. The system allows embedment of one or more BI gadgets into a business process activity form for presenting to a user relevant data for a business process activity represented by the business process activity form.

    摘要翻译: 业务流程管理系统提供一个或多个商业智能(BI)小配件,每个小配件提供用于从组织的一个或多个数据源提取数据的预定义功能。 该系统允许将一个或多个BI小工具嵌入到业务流程活动表单中,以向用户呈现由业务流程活动表单表示的业务流程活动的相关数据。

    Methods and transformations for transforming metadata model
    58.
    发明授权
    Methods and transformations for transforming metadata model 有权
    转换元数据模型的方法和转换

    公开(公告)号:US07185016B1

    公开(公告)日:2007-02-27

    申请号:US09653827

    申请日:2000-09-01

    IPC分类号: G06F17/30

    摘要: Transformations are provided for transforming a metadata model that contains model objects. The metadata model has a multiple layers including a lower layer containing one or more lower abstraction model objects having a lower abstraction level and a higher layer containing one or more higher abstraction model objects having a higher abstraction level. The transformations transform the model objects from the lower layer to the higher layer.

    摘要翻译: 提供转换以转换包含模型对象的元数据模型。 元数据模型具有包括下层的多层,其中下层包含具有较低抽象级别的一个或多个较低抽象模型对象,以及包含具有较高抽象级别的一个或多个较高抽象模型对象的较高层。 转换将模型对象从下层转换为较高层。

    Budget planning
    59.
    发明授权
    Budget planning 有权
    预算规划

    公开(公告)号:US07130822B1

    公开(公告)日:2006-10-31

    申请号:US09628479

    申请日:2000-07-31

    IPC分类号: G06F17/60

    摘要: The invention is directed to a budget planning system that improves the accuracy and predictability of budget planning within large organizations by enabling organizations to reconcile corporate financial models and organizational targets with detailed spending forecasts. The budgeting system includes a database that is configured to store data defining a budgeting model for the organization. The model has a plurality of hierarchically arranged nodes, each node corresponding to a “contributor” that either provides forecast data or review data provided by contributors associated with lower level nodes. The system is configured to capture target data from a set of financial analysts, capture forecast data from the contributors and reconcile the target data and the forecast data according to the model.

    摘要翻译: 本发明涉及一种预算规划系统,通过使组织能够通过详细的支出预测来调节企业财务模型和组织目标,从而提高大型组织内预算规划的准确性和可预测性。 预算系统包括被配置为存储定义组织的预算模型的数据的数据库。 该模型具有多个分层布置的节点,每个节点对应于“贡献者”,其提供与下级节点相关联的贡献者提供的预测数据或审查数据。 该系统被配置为从一组财务分析师捕获目标数据,从贡献者捕获预测数据,并根据模型调整目标数据和预测数据。

    Metadata modelling for reporting
    60.
    发明申请
    Metadata modelling for reporting 有权
    用于报告的元数据建模

    公开(公告)号:US20050027674A1

    公开(公告)日:2005-02-03

    申请号:US10835236

    申请日:2004-04-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30392

    摘要: The invention comprises a method and system for reducing the apparent complexity faced by a user when confronted by this modeling environment. It provides for a metadata model that represents one or more data sources, the metadata model comprising a query layer combining tee functions of a data access layer and a business layer. The query layer includes query subjects that describe how to retrieve data from the data sources, and the query subjects contain query items. The query layer also allows the use of data access language statements which permit the use of more complex computed query subjects and query items.

    摘要翻译: 本发明包括一种用于在面对该建模环境时减少用户面临的明显复杂性的方法和系统。 它提供了表示一个或多个数据源的元数据模型,元数据模型包括组合数据访问层的T形功能和业务层的查询层。 查询层包括描述如何从数据源检索数据的查询对象,查询对象包含查询项。 查询层还允许使用允许使用更复杂的计算查询主题和查询项目的数据访问语言语句。