Optimization of Data Requests Timing by Working with Matrixes under MSAccess Environment

Abstract

This paper is going to emphasize an optimised code in order to manage matrix calculus under MSAccess. The economic impact of using such a method is the optimal cost-benefit solution, and optimised timing for data management. As well, matrix calculus is the base of Variance-Covariance method used by financial corporations as an advanced method for estimation of market risk movements with direct impact over the capital required by prudential bodies.

Keywords

• Visual Basic
• DAO (Data Access Objects) Recordset
• System DSN (Data Source Name) driver
• Variance-Covariance Matrix
• Value at Risk