Is there a library for table arrays?

In summary, a library for reading and writing .net table arrays exists, but it is not commercially available.
  • #1
finaquant
8
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
  • #2
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.
 
  • #3
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
 
  • #4
I have not heard of such a library, but it seems quite feasible to write such a library yourself in .NET.
 
  • #5
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
 

1. What is a table array?

A table array is a data structure used to organize and store data in a tabular format, with rows and columns. It allows for efficient storage and retrieval of large amounts of data.

2. How is a table array different from a regular array?

A regular array is a linear data structure where data is stored in a single row or column. A table array, on the other hand, is a two-dimensional data structure with both rows and columns, allowing for more complex data organization.

3. What is a library for table arrays?

A library for table arrays is a collection of pre-written code and functions that can be used to create, manipulate, and analyze table arrays. It provides an easy and efficient way to work with table arrays without having to write all the code from scratch.

4. What are the benefits of using a library for table arrays?

Using a library for table arrays can save time and effort in coding, as well as provide access to advanced functions and features for data manipulation and analysis. It can also help ensure the accuracy and reliability of data stored in table arrays.

5. Are there different libraries for table arrays for different programming languages?

Yes, there are various libraries for table arrays available for different programming languages such as Python, Java, and R. Each library may have its own unique features and functions, but the basic principles of working with table arrays remain the same.

Similar threads

  • Programming and Computer Science
Replies
2
Views
1K
  • Programming and Computer Science
Replies
9
Views
955
  • Programming and Computer Science
Replies
2
Views
274
  • Programming and Computer Science
Replies
1
Views
416
  • Programming and Computer Science
Replies
13
Views
1K
  • Programming and Computer Science
Replies
11
Views
959
  • Programming and Computer Science
Replies
25
Views
1K
  • Programming and Computer Science
Replies
8
Views
1K
  • Programming and Computer Science
Replies
13
Views
1K
  • Programming and Computer Science
Replies
13
Views
1K
Back
Top