Triggering mechanism for multi-dimensional databases

• US 6,115,714 A
• Filed: 03/20/1998
• Issued: 09/05/2000
• Est. Priority Date: 03/20/1998
• Status: Expired due to Term

• Current Assignee: Amdocs Development Limited (Amdocs Ltd.)
• Original Assignee: Kenan Systems Corp (Nokia Corporation)
• Inventors: Kropp, Alan David, McGill, Brian James, Gallagher, Mary Clara
• Primary Examiner(s): Alam, Hosain T.
• Application Number:
  US09/045,433
• Time in Patent Office: 900 Days
• Field of Search: 707/1-3, 707/100-104, 707/200-201, 707/503, 707/504, 395/701-705
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method for invoking an action on a multi-dimensional database includes associating a procedure with a plurality of cells and invoking the procedure when at least one cell in the plurality is accessed. The method may be embodied on an article of manufacture.

Claims

1. In a multi-dimensional database comprised of a plurality of dimensions of data, a method for invoking a database action, the method comprising:

(a) associating a procedure with a plurality of cells of the multi-dimensional database the plurality of cells defining an array, the array operative to store array cell data and an indicator of the procedure to be invoked when at least one of the plurality of cells of the array is accessed; and

(b) invoking the procedure when at least one of the plurality of cells of the array of the multi-dimensional database is accessed, the procedure operative to perform a database action on the multi-dimensional database.

2. The method of claim 1 wherein step (a) comprises associating a procedure with a plurality of cells of the multi-dimensional database, the procedure receiving as an argument an identifier of a first array on which the procedure acts.

3. The method of claim 1 wherein step (a) comprises associating with a plurality of cells a procedure identifier, the procedure identifier indicating an initial array which the procedure targets.

4. The method of claim 1 further comprising the step of (c) associating with the plurality of cells an operation type which must be performed on the array to invoke the procedure.

5. The method of claim 4 wherein step (c) comprises associating with the plurality of cells an indication that a read operation must be performed on the array to invoke the procedure.

6. The method of claim 4 wherein step (c) comprises associating with the plurality of cells an indication that a load operation must be performed on the array to invoke the procedure.

7. The method of claim 4 wherein step (c) comprises associating with the plurality of cells an indication that the procedure should be invoked before a write operation is performed on the array.

8. The method of claim 4 wherein step (c) comprises associating with the plurality of cells an indication that the procedure should be invoked after a write operation is performed on the array.

9. A computer-readable medium encoded with a multi-dimensional database element array structure supporting invocation of a procedure when one or more cells of the array is accessed, said structure comprising:

an information portion stored in a storage element of the multi-dimensional database for storing array cell data; and

a header portion stored in a storage element of the multi-dimensional database, said header portion storing an indication of a procedure to be invoked when at least one cell in the array is accessed, the procedure operative to perform a database action on the multi-dimensional database.

10. The computer-readable medium encoded with a multi-dimensional database structure of claim 9 wherein said header portion also stores an indication of a type of access that invokes the procedure.

11. The computer-readable medium encoded with a multi-dimensional database structure of claim 9 wherein said header portion stores a plurality of indicators, each of said plurality of indicators storing an indication of a procedure to be invoked when at least one cell in the array is accessed.

12. An article of manufacture having a computer-readable programs means embodied thereon for invoking an action in a multi-dimensional database comprised of a plurality of dimensions of data, the article of manufacture comprising:

computer-readable program means for associating a procedure with a plurality of cells of the multi-dimensional database, the plurality of cells defining an array, the array operative to store array cell data and an indicator of the procedure to be invoked when at least one of the plurality of cells of the array is accessed; and

computer-readable program means for invoking the procedure when the array of the multi-dimensional database is accessed, the procedure operative to perform a database action on the multi-dimensional database.

13. The article of manufacture of claim 12 further comprising computer-readable program means for associating with the plurality of cells an operation type which must be performed on the array to invoke the procedure.

14. The article of manufacture of claim 13 further comprising computer-readable program means for associating with the plurality of cells an indication that a load operation must be performed on the array to invoke the procedure.

15. The article of manufacture of claim 13 further comprising computer-readable program means for associating with the plurality of cells an indication that a read operation must be performed on the array to invoke the procedure.

16. The article of manufacture of claim 13 further comprising computer-readable program means for associating with the plurality of cells an indication that a write operation must be performed on the array to invoke the procedure.

17. The article of manufacture of claim 13 further comprising computer-readable program means for associating with the plurality of cells an indication that the procedure should be invoked after a write operation is performed on the array.