Weighted Moore–Penrose generalized matrix inverse: MySQL vs. Cassandra database storage system

Abstract

The research in this paper refers to two areas: programming and data storage (data base) for computing the weighted Moore-Penrose inverse. The main aim of this paper analysis of the execution speed of computing using PHP programming language and data store. The research shows that the speed of execution gives considerable difference between the Procedural programming and Object Oriented PHP language, on the middle layer in the three tier of the web architecture. Also, the research concerning the comparison of relation database system, MySQL and NoSQL, key value store system, ApacheCassandra, on the database layer. The CPU times are compared and discussed. Keywords. Generalized inverse; weighted Moore-Penrose inverse; PHP programming; MySQL database; NoSQL Cassandra database storage system.