A middle layer solution to support ACID properties for NoSQL databases
The main objective of this paper is to keep the strengths of RDBMSs as consistency and ACID properties and at the same time providing the benefits that inspired the NoSQL movement through a middle layer. The proposed middle layer uses a four phase commit protocol to ensure: the use of recent data, t...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Elsevier
2016-01-01
|
| Series: | Journal of King Saud University: Computer and Information Sciences |
| Subjects: | |
| Online Access: | http://www.sciencedirect.com/science/article/pii/S1319157815001044 |
| _version_ | 1818310423258071040 |
|---|---|
| author | Ayman E. Lotfy Ahmed I. Saleh Haitham A. El-Ghareeb Hesham A. Ali |
| author_facet | Ayman E. Lotfy Ahmed I. Saleh Haitham A. El-Ghareeb Hesham A. Ali |
| author_sort | Ayman E. Lotfy |
| collection | DOAJ |
| description | The main objective of this paper is to keep the strengths of RDBMSs as consistency and ACID properties and at the same time providing the benefits that inspired the NoSQL movement through a middle layer. The proposed middle layer uses a four phase commit protocol to ensure: the use of recent data, the use of the Pessimistic technique to forbid others dealing with data while it is used and the data updates residing in many locations to avoid the loss of data and disappointment. This mechanism is required, especially in distributed database application NoSQL based environment, because allowing conflicting transactions to continue not only wastes constrained computing power and decreases bandwidth, but also exacerbates conflicts. The middle layer keeps tracking all running transactions and manages with other layers the execution of concurrent transactions. This solution will help increase both of the scalability, and throughput. Finally, the experimental results show that the throughput of the system improves on increasing the number of middle layers in scenarios and the amount of updates to read in a transaction increases. Also the data are consistent with executing many transactions related to each other through updating the same data. The scalability and availability of the system is not affected while ensuring strict consistency. |
| first_indexed | 2024-12-13T07:45:49Z |
| format | Article |
| id | doaj.art-749b725826004930b9508b8015a94949 |
| institution | Directory Open Access Journal |
| issn | 1319-1578 |
| language | English |
| last_indexed | 2024-12-13T07:45:49Z |
| publishDate | 2016-01-01 |
| publisher | Elsevier |
| record_format | Article |
| series | Journal of King Saud University: Computer and Information Sciences |
| spelling | doaj.art-749b725826004930b9508b8015a949492022-12-21T23:54:50ZengElsevierJournal of King Saud University: Computer and Information Sciences1319-15782016-01-0128113314510.1016/j.jksuci.2015.05.003A middle layer solution to support ACID properties for NoSQL databasesAyman E. Lotfy0Ahmed I. Saleh1Haitham A. El-Ghareeb2Hesham A. Ali3Information Technology Institute, EgyptComputer Engineering and Systems Dept., Faculty of Engineering, Mansoura University, EgyptInformation Systems Dept., Faculty of Computers and Information Sciences, Mansoura University, EgyptComputer Engineering and Systems Dept., Faculty of Engineering, Mansoura University, EgyptThe main objective of this paper is to keep the strengths of RDBMSs as consistency and ACID properties and at the same time providing the benefits that inspired the NoSQL movement through a middle layer. The proposed middle layer uses a four phase commit protocol to ensure: the use of recent data, the use of the Pessimistic technique to forbid others dealing with data while it is used and the data updates residing in many locations to avoid the loss of data and disappointment. This mechanism is required, especially in distributed database application NoSQL based environment, because allowing conflicting transactions to continue not only wastes constrained computing power and decreases bandwidth, but also exacerbates conflicts. The middle layer keeps tracking all running transactions and manages with other layers the execution of concurrent transactions. This solution will help increase both of the scalability, and throughput. Finally, the experimental results show that the throughput of the system improves on increasing the number of middle layers in scenarios and the amount of updates to read in a transaction increases. Also the data are consistent with executing many transactions related to each other through updating the same data. The scalability and availability of the system is not affected while ensuring strict consistency.http://www.sciencedirect.com/science/article/pii/S1319157815001044NoSQLACIDConsistencyBASETransactionsConcurrency |
| spellingShingle | Ayman E. Lotfy Ahmed I. Saleh Haitham A. El-Ghareeb Hesham A. Ali A middle layer solution to support ACID properties for NoSQL databases Journal of King Saud University: Computer and Information Sciences NoSQL ACID Consistency BASE Transactions Concurrency |
| title | A middle layer solution to support ACID properties for NoSQL databases |
| title_full | A middle layer solution to support ACID properties for NoSQL databases |
| title_fullStr | A middle layer solution to support ACID properties for NoSQL databases |
| title_full_unstemmed | A middle layer solution to support ACID properties for NoSQL databases |
| title_short | A middle layer solution to support ACID properties for NoSQL databases |
| title_sort | middle layer solution to support acid properties for nosql databases |
| topic | NoSQL ACID Consistency BASE Transactions Concurrency |
| url | http://www.sciencedirect.com/science/article/pii/S1319157815001044 |
| work_keys_str_mv | AT aymanelotfy amiddlelayersolutiontosupportacidpropertiesfornosqldatabases AT ahmedisaleh amiddlelayersolutiontosupportacidpropertiesfornosqldatabases AT haithamaelghareeb amiddlelayersolutiontosupportacidpropertiesfornosqldatabases AT heshamaali amiddlelayersolutiontosupportacidpropertiesfornosqldatabases AT aymanelotfy middlelayersolutiontosupportacidpropertiesfornosqldatabases AT ahmedisaleh middlelayersolutiontosupportacidpropertiesfornosqldatabases AT haithamaelghareeb middlelayersolutiontosupportacidpropertiesfornosqldatabases AT heshamaali middlelayersolutiontosupportacidpropertiesfornosqldatabases |