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

Sādhanā - 2016
Danijela Milošević1, Selver Pepić2, Muzafer Saračević3, Milan Tasić4
1Faculty of Technical Sciences Čačak, University of Kragujevac, Čačak, Serbia
2Information Technology in Engineering, The School of Mechanical Engineering of Applied Study, Trstenik, Serbia
3Department of Computer Science, University of Novi Pazar, Novi Pazar, Serbia
4Faculty of Science and Mathematics, University of Niš, Niš, Serbia

Tóm tắt

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.

Từ khóa


Tài liệu tham khảo

Tasić M, Stanimirović P and Pepić S 2011 Computation of generalized inverses using Php/MySql environment. Int. J. Comput. Math. 88(11): 2429–2446

Tasić M, Stanimirović P and Pepić S 2010 About the generalized LM-inverse and the Weighted Moore–Penrose inverse. Appl. Math. Comput. 216: 114–124

Elmasri R and Navathe SB 2003 Fundamentals of database systems: 4th edition. Addison-Wesley

Clear J, Dunn D, Harvey B, Heytens L, and Lohman P 1999 Non-stop SQL/MX primitives for knowledge discovery. In: ACM KDD Conference, pp. 425–429

Sattler K and Dunemann O 2001 SQL database primitives for decision tree classifiers. In: ACM CIKM Conference, pp. 379–386

Ordonez C and Garca J 2006 Vector and matrix operations programmed with UDFs in a relational DBMS. In: Proceedings of the 15th ACM international conference on information and knowledge management, Arlington, Virginia, USA, 503–512

Page R and Factor P 2008 SQL Server Matrix Workbench. In: http://www.simple-talk.com/sql/t-sql-programming/sql-server-matrix-workbench/, visited: September 2015

Egilsson S, Gudbjartsson H and Sigurjnsson S 2003 SQL query generator utilizing matrix structures. U.S. Patent 6,578,028

Suehring S 2002 MySQL bible. Wiley Publishing, USA

Obasanjo D 2009 Building scalable databases: Denormalization, the NoSQL movement and Digg. In: http://www.25hoursaday.com/weblog/2009/09/10/BuildingScalableDatabases-DenormalizationTheNoSQLMovementAndDigg.aspx, visited: sept 2015

Hewit E 2011 Cassandra: The definitive guide. O’Reilly Media, USA

Lakshman A and Malik P 2010 Cassandra: A decentralized structured storage system. SIGOPS Oper. Syst. Rev. 44: 35–40

Zielke G 1986 Report on test matrices for generalized inverses. Computing 36: 105–162

Thông tin
Thông tin xuất bản

Sādhanā

Thông tin tác giả