Is there a library for table arrays?

  • Thread starter Thread starter finaquant
  • Start date Start date
  • Tags Tags
    Arrays Table
AI Thread Summary
A discussion centered on the need for a .NET library capable of reading and writing arrays of data tables to relational databases highlighted the limitations of existing solutions like Entity Framework. The requirement was for a library that allows for persistence at the table level, enabling simple read and write operations for in-memory tables, specifically tailored for analytical functions. The example provided illustrated the use of separate cost and margin tables for yearly calculations, emphasizing the need for a custom solution. Participants noted the absence of such a library in the market and mentioned extending an existing non-commercial library, finaquant protos, to create a class called Persistent Table Array to fulfill these needs.
finaquant
Messages
8
Reaction score
0
Hello

For a software on which we are currently working we need a .net library for reading/writing array of data tables from/to relational databases.

Is there such a library for .net?

Tunc
 
Technology news on Phys.org
I am not sure exactly what you mean by "array of data tables", but if you have a "normal" .NET object model, then perhaps you can use Microsofts own Entity Framework (EF), which is a general purpose Object-Relational Mapping (ORM) library.
 
As far as I know, the Entity Framework is generally used for mapping object fields to table fields, in a sense, to achieve object persistence at field level.

What we need for our analytical table functions is slightly different. We want to store and read complete in-memory tables together with their instance information. Each table instance is an element of an array of tables. This is persistence at table level.

What we need is in principle simple read and write commands like the following:

write(TableName, Table, InstanceKey) : writes in-memory table Table into database

Table = read(TableName, InstanceKey) : reads in-memory table Table from database

For simplicity of understanding InstanceKey can be assumed to be a string and Table a DataTable object though they are both different types in our case. For example we use MatrixTable instead of DataTable for in-memory tables with a simplified data structure which is more proper for analytical operations.

Why table arrays? As an example assume we have separate cost and margin tables for each year in order to calculate price tables for each year. We could formulate this calculation as follows:

CostTbl2008 = read("cost_table", 2008);
MarginTbl2008 = read("margin_table", 2008);

PriceTbl2008 = tablemult(CostTbl2008, MarginTbl2008);
write("price_table", PriceTbl2008 , 2008); // store result for 2008 in database

Regards
Tunc
 
I have not heard of such a library, but it seems quite feasible to write such a library yourself in .NET.
 
Thanks.

We also couldn't find such a library; so we have extended our non-commercial library (finaquant protos) to include a class named Persistent Table Array which handles these database operations.

Tunc
 
Thread 'Is this public key encryption?'
I've tried to intuit public key encryption but never quite managed. But this seems to wrap it up in a bow. This seems to be a very elegant way of transmitting a message publicly that only the sender and receiver can decipher. Is this how PKE works? No, it cant be. In the above case, the requester knows the target's "secret" key - because they have his ID, and therefore knows his birthdate.
Back
Top