US 2014/0236781 A1Published application

Systems and Methods for an In-Memory Budget Finder

AssigneeSap SE

InventorsUlrich Bestfleisch, Jochen Mayerle

Life of this patent

Estimating the term…

Loading patent…

Abstract

Systems and methods for automatically finding available funds in an in-memory database are disclosed. In response to receiving an proposed expenditure amount associated with a proposed budget identifier, a set of proximity rules can be determined. The proximity rules define a budget graph and the scope for a particular search. The budget graph defines relationships between budgets. The relationships between the budgets in the graphs can be based on a budget hierarchy or functions or purposes associated with the budgets. The scope can define an allowed degree of separation between a the proposed budget and a related budget in the graph that the search for funds will be permitted to traverse. Using the graph, multiple related budgets with available funds can be identified. The proposed budget expenditure amount can be allocated to one of the budgets with available funds instead of the budget associated with the proposed budget identifier.

Claims20

Dependent claims

A method comprising:

providing, in a computer system, an in-memory database comprising a plurality of budgets and a plurality of expenditure items, wherein the plurality of budgets comprises a plurality of budget identifiers associated with a plurality of corresponding budget amounts, and wherein each of the plurality of expenditure items comprises an expenditure amount associated with one of the plurality of budget identifiers;
receiving, in the computer system, a proposed expenditure item comprising a proposed expenditure amount associated with a first budget identifier in the plurality of budget identifiers;
determining, in the computer system, a plurality of related budget identifiers related to the first budget identifier;
searching, in the computer system, the in-memory database for a first portion of the plurality of budgets comprising budget identifiers determined to match at least one of the plurality of related budget identifiers;
searching, in the computer system, the in-memory database for a first portion of the plurality of expenditure items comprising budget identifiers determined to match at least one of the plurality of related budget identifiers;
determining, in the computer system, a plurality of available budget amounts based on the first portion of the plurality of budgets and the first portion of the plurality of expenditure items;
and
comparing, in the computer system, the proposed expenditure amount with each of the plurality of available budget amounts to determine a portion of the plurality of available budget amounts greater than the proposed expenditure amount.

5 more elements

A non-transitory computer-readable storage medium containing instructions that, when executed, control an computer processor to be configured for:

providing an in-memory database comprising a plurality of budgets and a plurality of expenditure items, wherein the plurality of budgets comprises a plurality of budget identifiers associated with a plurality of corresponding budget amounts, and wherein each of the plurality of expenditure items comprises an expenditure amount associated with one of the plurality of budget identifiers;
receiving a proposed expenditure item comprising a proposed expenditure amount associated with a first budget identifier in the plurality of budget identifiers;
determining a plurality of related budget identifiers related to the first budget identifier;
searching the in-memory database for a first portion of the plurality of budgets comprising budget identifiers determined to match at least one of the plurality of related budget identifiers;
searching the in-memory database for a first portion of the plurality of expenditure items comprising budget identifiers determined to match at least one of the plurality of related budget identifiers;
determining a plurality of available budget amounts based on the first portion of the plurality of budgets and the first portion of the plurality of expenditure items;
and
comparing the proposed expenditure amount with each of the plurality of available budget amounts to determine a portion of the plurality of available budget amounts greater than the proposed expenditure amount.

5 more elements

A system comprising:

one or more computer processors;
and
a non-transitory computer-readable storage medium containing instructions, that when executed, control the one or more computer processors to be configured for:
providing an in-memory database comprising a plurality of budgets and a plurality of expenditure items, wherein the plurality of budgets comprises a plurality of budget identifiers associated with a plurality of corresponding budget amounts, and wherein each of the plurality of expenditure items comprises an expenditure amount associated with one of the plurality of budget identifiers;
receiving a proposed expenditure item comprising a proposed expenditure amount associated with a first budget identifier in the plurality of budget identifiers;
determining a plurality of related budget identifiers related to the first budget identifier;
searching the in-memory database for a first portion of the plurality of budgets comprising budget identifiers determined to match at least one of the plurality of related budget identifiers;
searching the in-memory database for a first portion of the plurality of expenditure items comprising budget identifiers determined to match at least one of the plurality of related budget identifiers;
determining a plurality of available budget amounts based on the first portion of the plurality of budgets and the first portion of the plurality of expenditure items;
and
comparing the proposed expenditure amount with each of the plurality of available budget amounts to determine a portion of the plurality of available budget amounts greater than the proposed expenditure amount.

8 more elements

Dependencies are inferred from the claim text.