Automated relational schema generation within a multidimensional enterprise software system

A schema generator and schema technology, applied to multidimensional databases, database models, instruments, etc.

Inactive Publication Date: 2011-01-19
INT BUSINESS MASCH CORP
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this hinders further calculation and analysis of the published data by the reporting software

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automated relational schema generation within a multidimensional enterprise software system
  • Automated relational schema generation within a multidimensional enterprise software system
  • Automated relational schema generation within a multidimensional enterprise software system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] For purposes of example, the present invention is described with reference to a business planning system, such as a business financial or budget planning system. The techniques described here can be readily applied to other software systems that use multidimensional data, including other large enterprise software systems. Examples of other enterprise software systems include order management systems, inventory management systems, sales force management systems, business intelligence tools, enterprise reporting tools, project and resource management systems, and other enterprise software systems.

[0037] Typically, the enterprise planning system 14 is capable of aligning and automating the enterprise's top-down goals and detailed bottom-up forecasts. The enterprise planning system 14 implements and manages the enterprise planning process, which generally includes three functions: (1) modeling, (2) contribution, and (3) reconciliation.

[0038]Initially, high-level busi...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Techniques are described for publishing multidimensional data from an enterprise software system. A relational database schema is automatically created for storing the multidimensional data. The database schema may be a relational star schema as described herein. The techniques may include processes for automatically producing the database schema based on the organization of the multidimensional data cube, and for populating the database schema with data from the data cube. The database schema may be used for reporting the multidimensional enterprise data, or may serve as a staging area to move the enterprise data toward a data warehouse within an enterprise software system. The reporting schema may support heterogeneous data types and heterogeneous formats. The reporting schema may also contain metadata that describes the schema, allowing for enhanced interpretation of the database schema. Also described is a process for automatically generating a reporting model from the database schema.

Description

technical field [0001] The present invention relates to software systems, and more particularly to computing environments for enterprise business planning. Background technique [0002] Enterprise software systems are typically complex, large-scale systems that support many, eg, hundreds or thousands, concurrent users. Examples of enterprise software systems include financial planning systems, budget planning systems, order management systems, inventory management systems, sales force management systems, business intelligence tools, enterprise reporting tools, project and resource management systems, and other enterprise software systems. [0003] In many cases, users may wish to publish data from one enterprise software system to other third-party software tools. For example, a user may wish to publish data from a financial planning system to reporting and analysis software. However, many enterprise software systems, such as financial planning systems, store data in the ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06Q10/00
CPCG06F17/30297G06F17/30592G06Q10/00G06F16/213G06F16/283Y10S707/99943
Inventor T·勒高尔特D·罗伊M·安特罗伯斯
Owner INT BUSINESS MASCH CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap