Skip to main content
SpringerLink
Log in

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

  • Published:
Sādhanā Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Figure 1
Figure 2
Figure 3
Figure 4
Figure 5

Similar content being viewed by others

References

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

    Article  MATH  Google Scholar 

  2. 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

    MathSciNet  MATH  Google Scholar 

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

    MATH  Google Scholar 

  4. 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

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

  6. 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

  7. 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

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

  9. Suehring S 2002 MySQL bible. Wiley Publishing, USA

    Google Scholar 

  10. 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

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

    Google Scholar 

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

    Article  Google Scholar 

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

    Article  MathSciNet  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Technical Sciences Čačak, University of Kragujevac, 32000, Čačak, Serbia

    Danijela Milošević

  2. Information Technology in Engineering, The School of Mechanical Engineering of Applied Study, 37240, Trstenik, Serbia

    Selver Pepić

  3. Department of Computer Science, University of Novi Pazar, 36300, Novi Pazar, Serbia

    Muzafer Saračević

  4. Faculty of Science and Mathematics, University of Niš, 18000, Niš, Serbia

    Milan Tasić

Authors
  1. Danijela Milošević
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Selver Pepić
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Muzafer Saračević
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Milan Tasić
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Muzafer Saračević.

Appendix: Classes and procedures for algorithms of weighted Moore–Penrose inverse

Appendix: Classes and procedures for algorithms of weighted Moore–Penrose inverse

Class 1.

The class UploadFile(), the constructor and list all the methods and properties for upload txt file which contains matrix.

figure c

Class 2.

The class DataManipulation(), the constructor and list all the methods and properties for database connect and data manipulating (search, insert, read...)

figure d

Class 3.

Central class in our client/server application is a \(class \, Matrix()\) with variables declaration, the constructor and the list of all the methods and properties.

figure e

Procedure 1.

OOP approach of the weighted Moore–Penrose inverse.

figure f

Procedure 2.

A new instance of the Matrix class using:

figure g

Procedure 3.

Insert matrix file in MySQL database with blob data type.

figure h

Procedure 4.

Function for insert the file, witch contains matrix, on \(MySQL \, varchar\) and longtext data type.

figure i

Procedure 5.

Function for the search data from MySQL database with blob data type.

figure j

Procedure 6.

Function for the search data from MySQL database with varchar and longtext data type.

figure k

Procedure 7.

Code for create the Keyspace in Cassandra.

figure l

Procedure 8.

Function getConnection(), connecting to localhost test server.

figure m

We use this new keyspace with:

Procedure 9.

Insert data in the Cassandra column family \(matrices\_in\).

figure n

Procedure 10.

Searching for data from the Cassandra column family \(matrices\_in\).

figure o

Procedure 11.

Insert data in the Cassandra column family \(matrices\_out\).

figure p

Procedure 12.

Searching for data from the Cassandra column family \(matrices\_out\).

figure q

Procedure 13.

Display result from the Cassandra column family \(matrices\_out\).

figure r

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Milošević, D., Pepić, S., Saračević, M. et al. Weighted Moore–Penrose generalized matrix inverse: MySQL vs. Cassandra database storage system. Sādhanā 41, 837–846 (2016). https://doi.org/10.1007/s12046-016-0523-6

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s12046-016-0523-6

Keywords

Search

Navigation