More Web Proxy on the site http://driver.im/

research-article

Query strategies on polyglot persistence in microservices

Authors:

Luís H. N. Villaça,

Leonardo G. Azevedo,

Fernanda BaiãoAuthors Info & Claims

SAC '18: Proceedings of the 33rd Annual ACM Symposium on Applied Computing

Pages 1725 - 1732

https://doi.org/10.1145/3167132.3167316

Published: 09 April 2018 Publication History

Abstract

Organizations have to quickly leverage both internal and external capabilities to survive and compete in the current world, using all possible resources to effectively solve their problems. In a microservice architecture, solutions are built through collaboration with external and internal parties, who promote distributed services across networks. An issue in this scenario is to query data across multiple services, within or beyond the organization. As an example, a single report may correlate information from services that deal with specific data sources such as graph, XML, document-oriented and relational databases - configuring a polyglot persistence setting. This work characterizes and analyzes available solutions to query data in a microservice architecture, based on academia and industry. Strengths and weaknesses of the solutions are provided, according to relevant software quality characteristics based on ISO 25010 model, aiming to guide efforts on future researches.

References

[1]

A. Adewumi, S. Misra, and N. Omoregbe. Evaluating open source software quality models against iso 25010. In CIT/IUCC/DASC/PICOM, 2015 IEEE International Conference on, pages 872--877. IEEE, 2015.

[2]

B. Behkamal, M. Kahani, and M. K. Akbari. Customizing iso 9126 quality model for evaluation of b2b applications. Information and software technology, 51(3):599--609, 2009.

Digital Library

[3]

E. A. Brewer. Towards robust distributed systems. In PODC, volume 7, 2000.

Digital Library

[4]

S. R. Collins, S. Navathe, and L. Mark. Xml schema mappings for heterogeneous database access. Information and Software Technology, 44(4):251--257, 2002.

[5]

T. Erl. Service-oriented architecture (SOA): concepts, technology, and design. Prentice Hall, 2005.

Digital Library

[6]

E. Evans. Domain-driven design: tackling complexity in the heart of software. Addison-Wesley Professional, 2004.

Digital Library

[7]

C. Fehling, F. Leymann, R. Retter, W. Schupeck, and P. Arbitter. Cloud computing patterns: fundamentals to design, build, and manage cloud applications. Springer Science & Business Media, 2014.

[8]

M. Fowler. Cqrs. Command Query Responsibility Segregation, https://martinfowler.com/bliki/CQRS.html, 2011.

[9]

M. Fowler. Microservice trade-offs. URL: http://martinfowler.com/articles/microservice-trade-offs.html, 2015.

[10]

M. Fowler. Polyglot persistence. 2015. URL: https://martinfowler.com/bliki/PolyglotPersistence.html, 2015.

[11]

M. Fowler and J. Lewis. Microservices. ThoughtWorks. https://martinfowler.com/articles/microservices.html, 2014.

[12]

R. Ghawi and N. Cullot. Database-to-ontology mapping generation for semantic interoperability. In Third International Workshop on Database Interoperability (InterDB 2007), volume 91, 2007.

[13]

R. Ghawi and N. Cullot. Building ontologies from xml data sources. In Database and Expert Systems Application, 2009. DEXA'09. 20th International Workshop on, pages 480--484. IEEE, 2009.

Digital Library

[14]

M. Gilpin. From the field: The first annual canonical model management forum. forrester blogs. URL: https://go.forrester.com/blogs/10-03-15-from_the_field_the_first_annual_canonical_model_management_forum, 2015.

[15]

M. Haklay and P. Weber. Openstreetmap: User-generated street maps. IEEE Pervasive Computing, 7(4):12--18, 2008.

Digital Library

[16]

ISO/IEC. Iec 9126 software engineering, product quality, part 1: Quality model. 2001. Geneva: International Organization for Standardization.

[17]

ISO/IEC et al. Iec25010: Systems and software engineering-systems and software quality requirements and evaluation (square). International Organization for Standardization, 34:2910, 2011.

[18]

ISO/IEC et al. System and software quality models. ISO/IEC 25010:2011, https://www.iso.org/standard/35733.html, 2011.

[19]

J. Kabbedijk, S. Jansen, and S. Brinkkemper. A case study of the variability consequences of the cqrs pattern in online business software. In Proceedings of the 17th European Conference on Pattern Languages of Programs, page 2. ACM, 2012.

Digital Library

[20]

S. Leberknight. Polyglot persistence. Near infinity{Online}, Available: http://www.nearinfinity. com/blogs/scott_leberknight/polyglot_persistence.html, 2008.

[21]

D. Maron, J. Torquato, and P. C. Alves. Oracle distributed database (in portuguese). Universidade Federal da Bahia, Salvador, 10, 2011.

[22]

D. Merkel. Docker: lightweight linux containers for consistent development and deployment. Linux Journal, 2014(239):2, 2014.

Digital Library

[23]

A. Messina, R. Rizzo, P. Storniolo, and A. Urso. A simplified database pattern for the microservice architecture. DBKDA 2016 : The Eighth International Conference on Advances in Databases, Knowledge, and Data Applications, 2016.

[24]

I. Nadareishvili, R. Mitra, M. McLarty, and M. Amundsen. Microservice Architecture: Aligning Principles, Practices, and Culture. O'Reilly Media, Inc., 2016.

Digital Library

[25]

S. Newman. Building microservices. O'Reilly Media, Inc., 2015.

Digital Library

[26]

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

Digital Library

[27]

A. Panda, M. Sagiv, and S. Shenker. Verification in the age of microservices. 2017.

Digital Library

[28]

G. Petasis, V. Karkaletsis, G. Paliouras, A. Krithara, and E. Zavitsanos. Ontology population and enrichment: State of the art. In Knowledge-driven multimedia information extraction and ontology evolution, pages 134--166. Springer-Verlag, 2011.

[29]

T. d. Preez. Canonical data models and microservices. URL: https://www2.deloitte.com/content/dam/Deloitte/za/Documents/strategy/ZA_Deloitte_Digita_Canonical_Schemas.pdf, 2016.

[30]

P. Rajković, D. Janković, and A. Milenković. Using cqrs pattern for improving performances in medical information systems. BCI'13 September 19--21, 2013.

[31]

P. J. Sadalage and M. Fowler. NoSQL distilled: a brief guide to the emerging world of polyglot persistence. Pearson Education, 2012.

Digital Library

[32]

G. Scheibel. A software architecture for storing trajectories using polyglot persistence (in portuguese). Master dissertation, University of the State of Santa Catarina, 2016.

[33]

A. P. Sheth and J. A. Larson. Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Computing Surveys (CSUR), 22(3):183--236, 1990.

Digital Library

[34]

N. Viennot, M. Lécuyer, J. Bell, R. Geambasu, and J. Nieh. Synapse: a microservices architecture for heterogeneous-database web applications. In Proceedings of the Tenth European Conference on Computer Systems, page 21. ACM, 2015.

Digital Library

[35]

H. Wache, T. Voegele, U. Visser, H. Stuckenschmidt, G. Schuster, H. Neumann, and S. Hübner. Ontology-based integration of information-a survey of existing approaches. In IJCAI-01 workshop: ontologies and information sharing, volume 2001, pages 108--117. Seattle, USA, 2001.

[36]

Z. Xiao, I. Wijegunaratne, and X. Qiang. Reflections on soa and microservices. In Enterprise Systems, 4th International Conference on, pages 60--67. IEEE, 2016.

[37]

O. Zimmermann. Microservices tenets. Computer Science-Research and Development, pages 1--10, 2016.

Digital Library

Cited By

Santana CAndrade LDelicato FPrazeres C(2021)Increasing the availability of IoT applications with reactive microservicesService Oriented Computing and Applications10.1007/s11761-020-00308-815:2(109-126)Online publication date: 1-Jun-2021
https://dl.acm.org/doi/10.1007/s11761-020-00308-8
Миронов ВГусаренко АЮсупова Н(2019)APPLICATION OF WEB SERVICES BASED ON SITUATION-ORIENTED DATABASE FOR MONITORING THE VIEWING OF THE EDUCATIONAL VIDEO-CONTENTМОДЕЛИРОВАНИЕ, ОПТИМИЗАЦИЯ И ИНФОРМАЦИОННЫЕ ТЕХНОЛОГИИ10.26102/2310-6018/2019.26.3.0317:3(26)(31-32)Online publication date: 15-Sep-2019
https://doi.org/10.26102/2310-6018/2019.26.3.031
de Santana Cde Mello Alencar BPrazeres CHung CPapadopoulos G(2019)Reactive microservices for the internet of thingsProceedings of the 34th ACM/SIGAPP Symposium on Applied Computing10.1145/3297280.3297402(1243-1251)Online publication date: 8-Apr-2019
https://dl.acm.org/doi/10.1145/3297280.3297402

Index Terms

Query strategies on polyglot persistence in microservices

Recommendations

A Comparative Performance Evaluation of Multi-Model NoSQL Databases and Polyglot Persistence
SAC '23: Proceedings of the 38th ACM/SIGAPP Symposium on Applied Computing

Multi-model databases support different NoSQL data models at once, typically a combination of relational, key-value, document, and graph models. Their expected benefits include increased versatility, reduced installation complexity, improved database ...
A distributed database system for event-based microservices
DEBS '21: Proceedings of the 15th ACM International Conference on Distributed and Event-based Systems

Microservice architectures are an emerging industrial approach to build large scale and event-based systems. In this architectural style, an application is functionally partitioned into several small and autonomous building blocks, so-called ...
Performance Evaluation of NoSQL Multi-Model Data Stores in Polyglot Persistence Applications
IDEAS '16: Proceedings of the 20th International Database Engineering & Applications Symposium

NoSQL data store systems have recently been introduced as alternatives to traditional relational database management systems. These data stores systems implement simpler and scalable data models that increase the performance and efficiency of a new kind ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences

SAC '18: Proceedings of the 33rd Annual ACM Symposium on Applied Computing

April 2018

2327 pages

ISBN:9781450351911

DOI:10.1145/3167132

Conference Chairs:
Hisham M. Haddad
Kennesaw State University
,
Roger L. Wainwright
University of Tulsa
,
Richard Chbeir
University of Pau & Pays Adour, France

Copyright © 2018 ACM.

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

SIGAPP: ACM Special Interest Group on Applied Computing

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 09 April 2018

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SAC 2018

Sponsor:

SIGAPP

SAC 2018: Symposium on Applied Computing

April 9 - 13, 2018

Pau, France

Acceptance Rates

Overall Acceptance Rate 1,650 of 6,669 submissions, 25%

Upcoming Conference

SAC '25

Sponsor:
sigapp

The 40th ACM/SIGAPP Symposium on Applied Computing

March 31 - April 4, 2025

Catania , Italy

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

3
Total Citations
View Citations
422
Total Downloads

Downloads (Last 12 months)14
Downloads (Last 6 weeks)2

Reflects downloads up to 26 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Santana CAndrade LDelicato FPrazeres C(2021)Increasing the availability of IoT applications with reactive microservicesService Oriented Computing and Applications10.1007/s11761-020-00308-815:2(109-126)Online publication date: 1-Jun-2021
https://dl.acm.org/doi/10.1007/s11761-020-00308-8
Миронов ВГусаренко АЮсупова Н(2019)APPLICATION OF WEB SERVICES BASED ON SITUATION-ORIENTED DATABASE FOR MONITORING THE VIEWING OF THE EDUCATIONAL VIDEO-CONTENTМОДЕЛИРОВАНИЕ, ОПТИМИЗАЦИЯ И ИНФОРМАЦИОННЫЕ ТЕХНОЛОГИИ10.26102/2310-6018/2019.26.3.0317:3(26)(31-32)Online publication date: 15-Sep-2019
https://doi.org/10.26102/2310-6018/2019.26.3.031
de Santana Cde Mello Alencar BPrazeres CHung CPapadopoulos G(2019)Reactive microservices for the internet of thingsProceedings of the 34th ACM/SIGAPP Symposium on Applied Computing10.1145/3297280.3297402(1243-1251)Online publication date: 8-Apr-2019
https://dl.acm.org/doi/10.1145/3297280.3297402

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten