Are there any .NET and Java libraries with table functions? [closed]

Question

Are there any java or .net libraries with table functions?

With "table function" I mean functions with tables as input and output parameters like:

T3 = f(T1, T2) , where T1, T2 and T3 are tables.

Matrix multiplication that we know from linear algebra is for example a matrix function:

M3 = M1 x M2 = f(M1, M2). 

Similarly, the distribution function often used in accounting or financial planning is a typical table function. For example, distribution of costs per department further to teams.

CostTable = costs(department, year), KeyTable = DitsributionRatio(department, team) --> DistributedCostTable = DistributionFunc(CostTable, KeyTable).

Business planning tools from SAP for example offer such standard table functions like Allocations/Distributions. SAP FOX formulas are also table functions with user-defined formulas.

These are high level functions to capture general calculation patterns in applications like financial planning, or fee calculations in financial services. Without any database or any other sort of programming, just by setting parameters for available table functions (i.e. by configuration) one can do the whole calculation. That is the idea behind table functions

Answer 1

If your tables will contain only numbers, then they can be represented as matrices. I found out this library:

http://code.google.com/p/efficient-java-matrix-library/

Looks like exactly what you need.

Answer 2

Department No 
           D1,D2,D3....DN----finance array of N Objects[N]
           D4,D5.D6....DM----accounting array of M Objects[M]
           D7,D8,D9 ...DK-----marketing array of K Objects[K]
For each department cost per year shown in monthly basis 
 (  departemtn) finance D1= C1  C2  C3  C4      
                            C5  C6  C7  C8
                            C9 C10 C11 C12
    .
    .
    .
 (  departemtn) finance   DN=   C1  C2  C3  C4
                                C5  C6  C7  C8
                                C9 C10 C11 C12

 (  departemtn) accounting D4= C1  C2  C3  C4      
                               C5  C6  C7  C8
                               C9 C10 C11 C12
    .
    .
    .
 (  departemtn) accounting     DM=   C1  C2  C3  C4
                                     C5  C6  C7  C8
                                     C9 C10 C11 C12

(  departemtn) marketing D7=   C1  C2  C3  C4      
                               C5  C6  C7  C8
                               C9 C10 C11 C12
    .
    .
    .
 (  departemtn) marketing    DK=   C1  C2  C3  C4
                                   C5  C6  C7  C8
                                   C9 C10 C11 C12

I exactly donot know what urs clear requirement is .But,you can start this way.But,its better to use arraylist of you have different variation of objects .