Blockchain comes to the database!
Вставка
- Опубліковано 8 лют 2025
- 20c bring blockchain to the relational world. If you are looking to take the standard database table concept, but make it absolutely tamper-proof using blockchain technology, then it is here in Oracle Database 20c. But a word of warning...a tamper-proof table really REALLY means no tampering.
blog: connor-mcdonal...
twitter: / connor_mc_d
Subscribe for new tech videos every week
All other social media channels here: linktr.ee/connor
Are you serious? A free Oracle database forever ?!?!?!?! Hell yeah!!!
www.oracle.com...
Music: Night Owl (Broke For Free)
, Dyalla
#oracle #blockchain #20c
Thanks Mr. Connor for this demonstration
what happens if you attempt to "truncate" the table ?
Thanks for this informative video
Thanks for the video Connor! Would you know if the Autonomous Database already includes the blockchain function of 21c?
I would imagine it will be coming soon because we have backported it to 19c - see my blog connor-mcdonald.com/2021/02/03/blockchain-tables-are-here-in-19c/
Thank you Connor, this was a great demo!
I was wondering whether you were going to make any content like this around AutoML, JSON binary representation, and persistent memory store that were new features to 20c?
Personally, I'd be very interested in the AutoML feature
They are on the list ..... but the list is long :-)
Hmm tamper proof eh? Lets say I get unauthorized access to a database with such a table. An now I manage to insert an insane amount of rows in it. Say with a script, 1 row each millisecond. No easy way deleting all those rows, better hope you backups are ok! Fine, I did not tamper with the data by altering it, but my last transaction might just have happened amid a the malicious inserts and not been added in the backups. I would be curious to see if we can rollback that well enough from the flashback.
"unauthorised access to ..." pretty much means all bets are off the table for any technology. Its the same reason why some bitcoin funds just magically disappeared into the night with investors funds :-)
But the flashback comment is interesting - I'll give that try. I suspect it will fail because under the covers, a flashback is a series of deletes/inserts
@@DatabaseDude True. I have helped someone with database issues after their site was hacked (by sql injection off all things...). And was able to clean stuff up (long story, no backups). This however would make fixing it a challenge :) . And perhaps one we should not be able to fix. Since doing so would just lead to other problems.