skip to main content
10.1145/2851553.2851561acmconferencesArticle/Chapter ViewAbstractPublication PagesicpeConference Proceedingsconference-collections
research-article

Experimental Performance Evaluation of different Data Models for a Reflection Software Architecture over NoSQL Persistence Layers

Published: 12 March 2016 Publication History

Abstract

The recent rise of the NoSQL movement motivates investigation on the performance impact that new persistence approaches can bring in the model-driven re-engineering of a consolidated object-oriented software architecture. We report comparative experimental performance results attained by combining a pattern-based domain logic with a persistence layer based on different paradigms and we describe how data model is persisted in various implementation based on MySQL, Neo4j, and MongoDB.

References

[1]
ISO/IEC. ISO/IEC 9126. Software engineering -- Product quality. ISO/IEC, 2001.
[2]
Frank Buschmann, Regine Meunier, Hans Rohnert, Peter Sommerlad, and Michael Stal. Pattern-oriented Software Architecture: A System of Patterns. John Wiley & Sons, Inc., New York, NY, USA, 1996.
[3]
Joseph W Yoder, Federico Balaguer, and Ralph Johnson. Architecture and design of adaptive object-models. ACM Sigplan Notices, 36(12):50--60, 2001.
[4]
Martin Fowler. Analysis patterns: reusable object models. Addison-Wesley Professional, 1997.
[5]
Connie U Smith and Lloyd G Williams. Software performance antipatterns. In Workshop on Software and Performance, pages 127--136, 2000.
[6]
Davide Arcelli, Vittorio Cortellessa, and Catia Trubiani. Antipattern-based model refactoring for software performance improvement. In Proceedings of the 8th international ACM SIGSOFT conference on Quality of Software Architectures, pages 33--42. ACM, 2012.
[7]
Laney Douglas. 3d data management: Controlling data volume, velocity and variety. Gartner. Retrieved, 6, 2001.
[8]
Scott Ambler. Agile database techniques: effective strategies for the agile software developer. John Wiley & Sons, Inc., New York, NY, USA, 2003.
[9]
Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko. High performance MySQL: optimization, backups, and replication. " O'Reilly Media, Inc.", 2012.
[10]
Saleem N Bhatti, Zahid H Abro, and Farzana R Abro. Performance evaluation of java based object relational mapping tool. Mehran University Research Journal of Engineering and Technology, 32(2):159--166, 2013.
[11]
Robert C Martin. The dependency inversion principle. C+ Report, 8(6):61--66, 1996.
[12]
Michael Stonebraker. SQL databases v. NoSQL databases. Communications of the ACM, 53(4):10--11, 2010.
[13]
Aaron Schram and Kenneth M Anderson. MySQL to NoSQL: data modeling challenges in supporting scalability. In Proceedings of the 3rd annual conference on Systems, programming, and applications: software for humanity, pages 191--202. ACM, 2012.
[14]
Bogdan G Tudorica and Cristian Bucur. A comparison between several NoSQL databases with comments and notes. In Roedunet International Conference (RoEduNet), 2011 10th, pages 1--5. IEEE, 2011.
[15]
Joao R Lourenço, Bruno Cabral, Paulo Carreiro, Marco Vieira, and Jorge Bernardino. Choosing the right NoSQL database for the job: a quality attribute evaluation. Journal of Big Data, 2(1):1--26, 2015.
[16]
Neo4j the world's leading graph database. http://neo4j.com/.
[17]
MongoDB for GIANT idea. https://www.mongodb.org/.
[18]
ISO/TR. ISO/TR 20514:2005. Health informatics -- Electronic health record -- Definition, scope and context. ISO/TR, 2005.
[19]
Paul C Tang, Joan S Ash, David W Bates, J Marc Overhage, and Daniel Z Sands. Personal health records: definitions, benefits, and strategies for overcoming barriers to adoption. Journal of the American Medical Informatics Association, 13(2):121--126, 2006.
[20]
Erich Gamma, Richard Helm, Ralph Johnson, and John Vlissides. Design Patterns: Elements of Reusable Object-oriented Software. Addison-Wesley Longman Publishing Co., Inc., Boston, MA, USA, 1995.
[21]
Thomas Beale, Sam Heard, Dipak Kalra, and David Lloyd. OpenEHR architecture overview. The OpenEHR Foundation, 2006.
[22]
Christopher Ireland, David Bowers, Michael Newton, and Kevin Waugh. A classification of object-relational impedance mismatch. In Advances in Databases, Knowledge, and Data Applications, 2009. DBKDA'09. First International Conference on, pages 36--43. IEEE, 2009.
[23]
ISO. ISO 9241. Ergonomics of human-system interaction. ISO, 2010.
[24]
Francesca Bugiotti, Luca Cabibbo, Paolo Atzeni, and Riccardo Torlone. How I learned to stop worrying and love NoSQL databases. In SEBD Italian Symposium on Advanced Database Systems, 2015.
[25]
Florian Holzschuher and René Peinl. Performance of graph query languages: comparison of Cypher, Gremlin and Native Access in Neo4J. In Proceedings of the Joint EDBT/ICDT 2013 Workshops, EDBT '13, pages 195--204, New York, NY, USA, 2013. ACM.
[26]
Wei Xu, Zhonghua Zhou, Hong Zhou, Wu Zhang, and Jiang Xie. MongoDB improves big data analysis performance on Electric Health Record system. In Life System Modeling and Simulation, pages 350--357. Springer, 2014.
[27]
Chad Vicknair, Michael Macias, Zhendong Zhao, Xiaofei Nan, Yixin Chen, and Dawn Wilkins. A comparison of a graph database and a relational database: a data provenance perspective. In Proceedings of the 48th annual Southeast regional conference, page 42. ACM, 2010.
[28]
Anuradha Kanade, Aarthi Gopal, and Shantanu Kanade. A study of normalization and embedding in MongoDB. In Advance Computing Conference (IACC), 2014 IEEE International, pages 416--421. IEEE, 2014.
[29]
Gansen Zhao, Qiaoying Lin, Libo Li, and Zijing Li. Schema conversion model of SQL database to NoSQL. In P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), 2014 Ninth International Conference on, pages 355--362. IEEE, 2014.
[30]
Ilya Katsov. NoSQL data modeling techniques. Highly Scalable Blog, 2012.
[31]
Richard Hull. Relative information capacity of simple relational database schemata. SIAM Journal on Computing, 15(3):856--886, 1986.
[32]
Paolo Atzeni, Giorgio Ausiello, Carlo Batini, and Marina Moscarini. Inclusion and equivalence between relational database schemata. Theoretical Computer Science, 19(3):267--285, 1982.
[33]
Michael R. Garey and David S. Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. W. H. Freeman & Co., New York, NY, USA, 1979.
[34]
Sudarshan S Chawathe, Anand Rajaraman, Hector Garcia-Molina, and Jennifer Widom. Change detection in hierarchically structured information. SIGMOD Rec., 25(2):493--504, June 1996.
[35]
Luigi P Cordella, Pasquale Foggia, Carlo Sansone, and Mario Vento. Performance evaluation of the VF graph matching algorithm. In Image Analysis and Processing, 1999. Proceedings. International Conference on, pages 1172--1177. IEEE, 1999.
[36]
Catriel Beeri, Philip A Bernstein, and Nathan Goodman. A sophisticate's introduction to database normalization theory. In Proceedings of the fourth international conference on Very Large Data Bases-Volume 4, pages 113--124. VLDB Endowment, 1978.
[37]
Elizabeth J O'Neil. Object/relational mapping 2008: Hibernate and the Entity Data Model (EDM). In Proceedings of the 2008 ACM SIGMOD international conference on Management of data, pages 1351--1356. ACM, 2008.
[38]
Qinglin Wu, Yanzhong Hu, and Yan Wang. Research on data persistence layer based on hibernate framework. In Intelligent Systems and Applications (ISA), 2010 2nd International Workshop on, pages 1--4. IEEE, 2010.
[39]
Zachary Parker, Scott Poe, and Susan V Vrbsky. Comparing NoSQL MongoDB to an SQL db. In Proceedings of the 51st ACM Southeast Conference, page 5. ACM, 2013.

Cited By

View all
  • (2024)Unveiling Faulty User Sequences: A Model-Based Approach to Test Three-Tier Software ArchitecturesJournal of Systems and Software10.1016/j.jss.2024.112015212(112015)Online publication date: Jun-2024
  • (2017)Engineering the Performance of a Meta-modeling ArchitectureProceedings of the 8th ACM/SPEC on International Conference on Performance Engineering Companion10.1145/3053600.3053647(203-208)Online publication date: 18-Apr-2017

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
ICPE '16: Proceedings of the 7th ACM/SPEC on International Conference on Performance Engineering
March 2016
346 pages
ISBN:9781450340809
DOI:10.1145/2851553
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 12 March 2016

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. electronic health record (EHR) systems
  2. model-driven performance engineering
  3. mongoDB
  4. mySQL
  5. neo4j
  6. noSQL databases
  7. reflection pattern
  8. relational databases

Qualifiers

  • Research-article

Conference

ICPE'16

Acceptance Rates

ICPE '16 Paper Acceptance Rate 23 of 74 submissions, 31%;
Overall Acceptance Rate 252 of 851 submissions, 30%

Upcoming Conference

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)6
  • Downloads (Last 6 weeks)2
Reflects downloads up to 20 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (2024)Unveiling Faulty User Sequences: A Model-Based Approach to Test Three-Tier Software ArchitecturesJournal of Systems and Software10.1016/j.jss.2024.112015212(112015)Online publication date: Jun-2024
  • (2017)Engineering the Performance of a Meta-modeling ArchitectureProceedings of the 8th ACM/SPEC on International Conference on Performance Engineering Companion10.1145/3053600.3053647(203-208)Online publication date: 18-Apr-2017

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media