newsql - brown university€¦ · how acid is achieved a : all transactions are either made...
TRANSCRIPT
![Page 1: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/1.jpg)
NUODB
NewSQL
BROWN UNIVERSITY PRESENTED BY NELSON ONYIBE
![Page 2: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/2.jpg)
NuoDB is … v Distributed v Relational v ACID-ic v Mostly SQL compliant v P2P v Elastic?
![Page 3: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/3.jpg)
SQL Layer
ATOMS
![Page 4: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/4.jpg)
How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB
C : NuoDB uses MVCC to maintain a consistent view of data among transactions. Data is NEVER deleted or actually UPDATED just versioned. This is of course relative consistency
I : Since every concurrent writes to the same object are actually creation of a new object, transactions are isolated.
D : Distributes changes to at least two archive nodes. Archive nodes are able to write a non-buffered log of replication messages. This will enable the archive node to recover the state of the database at the time of the crash. (Could be expensive under heavy load)
![Page 5: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/5.jpg)
CONCLUSION
It would be nice to test drive it
![Page 6: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/6.jpg)
![Page 7: NewSQL - Brown University€¦ · How Acid is achieved A : All transactions are either made permanent when the transactions commits or are removed from the DB C : NuoDB uses MVCC](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb29479a6bef74bae082dbb/html5/thumbnails/7.jpg)
Sources v http://ww1.prweb.com/prfiles/2011/08/22/8738428/NuoDB
%20White%20Paper%20v310.pdf v http://nuodb.com/how_it_works.html v http://en.wikipedia.org/wiki/Multiversion_concurrency_control