eprintid: 46549 rev_number: 11 eprint_status: archive userid: 1903 dir: disk0/00/04/65/49 datestamp: 2017-06-22 11:03:15 lastmod: 2019-03-13 14:49:50 status_changed: 2019-03-13 14:49:50 type: article metadata_visibility: show creators_name: Jiménez Peris, Ricardo creators_name: Patiño Martínez, Marta creators_name: Brondino, Ivan creators_name: Vianello, Valerio title: Transaction management across data stores publisher: Inderscience Publishers rights: by-nc-nd ispublished: unpub subjects: informatica full_text_status: public keywords: Data management; NoSQL; Consistency abstract: Companies have evolved from a world where they only had SQL databases to a world where they use different kinds of data stores, such as key­value data stores, document­oriented data stores and graph databases. The reason why they have started to introduce this diversity of persistency models is because different NoSQL technologies bring different data models with associated query languages and/or APIs. However, they are confronted now with a problem in which they have the data scattered across different data stores. This problem lies in that when a business action requires to update the data, the data reside in different data stores, and they are subject to inconsistencies in the event of failure and/or concurrent access. These inconsistencies appear due to the lack of transactional consistency that was guaranteed in traditional SQL databases but is not guaranteed either within the NoSQL data stores or across data stores and databases. CoherentPaaS comes to remedy this need. CoherentPaaS provides an ultra­scalable transactional management layer that can be integrated with any data store with multi­ versioning capabilities. The layer has been integrated with six different data stores, three NoSQL data stores and three SQL­like databases. In this paper, we describe this generic ultra­scalable transactional management layer and focus on its API and how it can be integrated in different ways with different data stores and databases. date_type: published date: 2017 publication: International Journal of High Performance Computing And Networking pagerange: 0-10 institution: ETSI_Informatica department: Lenguajes refereed: TRUE issn: 1740-0562 official_url: http://www.inderscience.com/info/ingeneral/forthcoming.php?jcode=ijhpcn comprojects_type: FP7 comprojects_type: FP7 comprojects_type: CM comprojects_type: MINECO comprojects_code: 611068 comprojects_code: 619606 comprojects_code: S2013TIC-2894 comprojects_code: TIN2013-46883 comprojects_acronym: CoherentPaaS comprojects_acronym: LeanBigData comprojects_acronym: CLOUD4BIGDATA comprojects_acronym: BigDataPaaS comprojects_leader: UNIVERSIDAD POLITECNICA DE MADRID comprojects_leader: UNIVERSIDAD POLITECNICA DE MADRID comprojects_leader: comprojects_leader: comprojects_title: A Coherent and Rich PaaS with a Common Programming Model CoherentPaaS comprojects_title: Ultra-Scalable and Ultra-Efficient Integrated and Visual Big Data Analytics comprojects_title: comprojects_title: citation: Jiménez Peris, Ricardo and Patiño Martínez, Marta and Brondino, Ivan and Vianello, Valerio (2017). Transaction management across data stores. "International Journal of High Performance Computing And Networking" ; pp.. ISSN 1740-0562. document_url: https://oa.upm.es/46549/1/INVE_MEM_2017_257448.pdf