Comparison with sql based database programming?

Table-valued functions in finaquant .net libraries

Comparison with sql based database programming?

Postby parmesan » 08 Feb 2014, 11:08

Hello, what are the advantages of finaquant table functions compared to the classical sql-based database programming? What is the difference?
Posts: 1
Joined: 08 Feb 2014, 11:04

Re: Comparison with sql based database programming?

Postby finaquant » 15 Feb 2014, 16:25

You may find some answers in this article:
What is a table function? Why do we need table functions?

The most important differences between Table Functions and SQL programming can be summarized as follows:
  1. SQL is more appropriate for operational purposes, like recording new data, or updating existing data in tables. Table Functions are designed for analytical operations based on data tables, like forecasts, risk analysis, complex commissions, and so on.
  2. Table Functions can be compared to Matrix Functions with the difference that their input and output parameters are data tables instead of matrices. Data tables are taken as a whole as parameters.
  3. Complex analytical operations like financial plans, sales commissions etc. can be formulated much easier, faster and compacter (reduced complexity) with Table Functions.
  4. A function tree (or any analytical relationship) implemented with Table Functions has clearly defined input and output parameters. That's not always the case with lengthy SQL scripts, partially due to tight integration with the underlying data structure (or schema) of the database.
  5. Parametric Table Functions are generally much higher-level programming constructs than SQL statements. A table function can be compared to a well-designed Stored Procedure with clearly defined input and output tables without hidden interactions (or parameters) with a database.

So what? To summarize:
If you are developing a software which should record, query (for reports) or update data, conventional SQL programming is the better choice.

If you want to formulate analytical relationships based on data tables like some forecasts, sales or dealer commissions, simulations, optimizations etc. (analytical) table functions are the better choice.
User avatar
Posts: 61
Joined: 16 Sep 2013, 18:37

Return to Table Functions

Who is online

Users browsing this forum: No registered users and 1 guest