Author Archives: admin

Converting a MatrixTable to a DataTable, and vice versa

MatrixTable is a type (class) for in-memory representation of data tables just like DataTable of the .net framework (ADO.net). MatrixTable has but a much simplified data structure compared to DataTable with primary focus on mathematical (or analytical) table functions rather … Continue reading

Posted in Calculation engine | Tagged , , | Leave a comment

Testing Persistent Table Arrays with a MySQL database

MySQL is definitely one of the most popular database systems. It is free and open-source, and comparably easy to install and use. The all-in-one installation package makes the installation quite simple. This package also includes MySQL workbench for tasks like … Continue reading

Posted in Calculation engine | Tagged , | Leave a comment

Testing Persistent Table Array with a Microsoft SQL database

With the PersistentTableArray class of the non-commercial .net library finaquant® protos you can read and write in-memory tables from/to a relational database together with their instance information. If you have already installed Microsoft Visual Studio C# 2010 Express or a … Continue reading

Posted in Calculation engine | Tagged , | Leave a comment

Calling user-defined functions in R from within c#

In order to integrate R with high-level table constructs like function router1 or subtable transformer2 it might be desirable to call user-defined functions in R from within c#. This can be done quite easily with the help of the open-source … Continue reading

Posted in Calculation engine | Tagged , | Leave a comment