Delta-mechanism for integration of OLAP-based planning and reporting

• US 7,606,828 B2
• Filed: 11/18/2003
• Issued: 10/20/2009
• Est. Priority Date: 11/18/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Koerner, Hartmut, Marschall, Erich
• Primary Examiner(s): Vo; Tim T.
• Assistant Examiner(s): Morrison; Jay A
• Application Number:
  US10/717,186
• Publication Number:
  US 20050108294A1
• Time in Patent Office: 2,163 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A database system may include a database, a set of tools for accessing the database, a data buffer for storing data objects from the database, and a “delta buffer” for storing delta records. Simulations may be performed in the database system by the set of tools that access the database. Simulative changes of the data may be handled by the delta buffer. The delta buffer need not contain all the data used for simulations and may include delta records. Each delta record may include simulative changes of the data and a request identifier. The content of the delta buffer may be integrated with the unchanged, original data from the database. The delta buffer in combination with the data buffer may provide an integrated view for tools that access the database, such as planning and reporting tools.

Claims

1. A database system embodied in computer-readable storage media, the database system comprising:

a database, wherein the database is a multidimensional database;

a plurality of application tools, each of the tools being configured to access data objects from the database, the tools comprising;

a business reporting tool which performs online analytical processing business reporting operations based on one or more data objects accessed from a data buffer, the business reporting tool configured to view the one or more data objects and to not make changes to the one or more data objects, and

a business planning tool, integrated with the reporting tool, which performs online analytical processing business planning operations based on the one or more data objects accessed from the data buffer, the business planning tool configured to view the one or more data objects and to change the one or more data objects;

the data buffer configured to store a copy of the one or more data objects accessed from the database; and

a delta buffer configured to store a delta record, wherein the delta record characterizes a difference between the one or more data objects and a modified version of the one or more data objects, the modified version being a result of a change made by the business planning tool to the data objects accessed from the database, the data objects buffered in the data buffer having a logical key corresponding to the database of the data objects, a description of an aggregation level described by characteristics and key figures from which aggregates of the data object may be constructed, and a description of a selection condition representing a slice of the multidimensional database, the business reporting tool and the business planning tool requesting data from the data buffer having a specified aggregation level and a specified selection condition, the delta buffer and the data buffer providing an integrated view to the business reporting tool and the business planning tool.

2. A database system in accordance with claim 1, wherein the delta buffer is configured to generate a cumulative delta record.

3. A database system in accordance with claim 1, wherein the delta buffer includes at least one delta record and each delta record has a corresponding request identifier, and wherein the request identifier is usable by a data object to represent the one or more delta records that have been used to update a data object.

4. A database system in accordance with claim 1, wherein the delta buffer includes at least one delta record and the database system is configured to store the at least one delta record with data in the database.

5. A database system in accordance with claim 1, wherein the data buffer and the delta buffer are parts of a system memory of a computer system.

6. A database system in accordance with claim 1, wherein the delta buffer is configured to compress two or more delta records to generate a cumulative delta record.

7. A computer-implemented method comprising:

reading data from a database, wherein the database is a multidimensional database;

storing a data object in a data buffer, wherein the data object includes the data read from the database;

accessing the data object from the data buffer with one of a plurality of application tools, the tools comprising;

a business reporting tool which performs online analytical processing business reporting operations based on one or more data objects accessed from the data buffer, the business reporting tool configured to view the one or more data objects and to not make changes to the one or more data objects, and

a business planning tool, integrated with the reporting tool, which performs online analytical processing business planning operations based on the one or more data objects accessed from the data buffer, the business planning tool configured to view the one or more data objects and to change the one or more data objects;

storing, in a delta buffer, a delta record characterizing a difference between the data object and a modified version of the data object, the modified version being a result of a change to the data object made by one of the application tools; and

updating the data object in the data buffer with the delta record, the data object buffered in the data buffer having a logical key corresponding to the database of the data objects, a description of an aggregation level described by characteristics and key figures from which aggregates of the data object may be constructed, and a description of a selection condition representing a slice of the multidimensional database, the business reporting tool and the business planning tool requesting data from the data buffer having a specified aggregation level and a specified selection condition, the delta buffer and the data buffer providing an integrated view to the business reporting tool and the business planning tool.

8. A method in accordance with claim 7, further comprising:

compressing the delta buffer, wherein compressing the delta buffer includes generating a cumulative delta record.

9. A method in accordance with claim 7, further comprising:

storing the delta buffer in the database, wherein storing the delta buffer in the database includes integrating the one or more delta records in the delta buffer with the corresponding data in the database.

10. A method in accordance with claim 7, further comprising:

associating the delta record with a request identifier, wherein the request identifier is usable by a data object to represent the one or more delta records that have been used to update a data object.

11. An integrated business planning and reporting platform embodied in computer-readable storage media, the platform comprising:

a database storing data, wherein the database is a multidimensional database;

a data buffer configured to store one or more data objects, wherein the at least one data object includes data read from the database;

a business reporting tool which performs online analytical processing business reporting operations based on one or more data objects accessed from the data buffer, the business reporting tool configured to view the one or more data objects and to not make changes to the one or more data objects;

a business planning tool, integrated with the reporting tool, which performs online analytical processing business planning operations based on the one or more data objects accessed from the data buffer, the business planning tool configured to view the one or more data objects and to change the one or more data objects; and

a delta buffer configured to store a delta record characterizing a difference between the one or more data objects and a modified version of the one or more data objects, the modified version being a result of a change made to the one or more data objects by the business reporting tool, the business planning tool, or both, the data objects buffered in the data buffer having a logical key corresponding to the database of the data objects, a description of an aggregation level described by characteristics and key figures from which aggregates of the data object may be constructed, and a description of a selection condition representing a slice of the multidimensional database, the business reporting tool and the business planning tool requesting data from the data buffer having a specified aggregation level and a specified selection condition, the delta buffer and the data buffer providing an integrated view to the business reporting tool and the business planning tool.

12. A platform in accordance with claim 11, further comprising:

a server program configured to manage the data buffer.

13. A platform in accordance with claim 11, further comprising:

a server program configured to manage the delta buffer.

14. A platform in accordance with claim 11, wherein the reporting tool and/or planning tool generates the delta record.

15. A platform in accordance with claim 11, wherein the delta buffer stores at least one delta record and each delta record corresponds to a request identifier, wherein the request identifier represents at least one delta record that has been used to update a data object.

16. A platform in accordance with claim 11, wherein the delta buffer is configured to compress two or more delta records to generate a cumulative delta record.

17. A platform in accordance with claim 11, wherein the delta buffer includes at least one delta record and the database system is configured to store the at least one delta record in the database, wherein storing the at least one delta record includes integrating the at least one delta record with data in the database.