Day 8 - Relational Database 101 - PostgreSQL Internals
আপনি এবং আপনার friend একটা seminar-এ গেছেন, seminar-এ speaker-রা তাদের মতামত share করছেন। মাঝে মাঝে কিছু important কথা বলছেন। এই কথাগুলো আপনার friend note করছে, কিন্তু আপনি কিছুই note করেননি। Seminar শেষ হওয়ার পরের দিন আপনি সবকিছুই ভুলে গেছেন, আবছা আবছা মনে আছে কিন্তু সম্পূর্ণ মনে করতে পারছেন না। উপায় না পেয়ে আপনার friend-কে জিজ্ঞেস করলেন। ও সবকিছুই সুন্দর করে বলে দিলো। কারণটা নিশ্চয়ই বুঝতে…
Day 8 - Relational Database 101 - PostgreSQL Internals
A seminar attendee shared insights about relational databases. The friend noted these points but struggled to remember later. The friend was asked for details, and they explained.
A database is a place to store data, similar to a file system on a hard drive. However, databases offer advanced features like indexing, which significantly speeds up data retrieval compared to searching through files directly. Atomicity, consistency, isolation, and durability (ACID) are the four key properties of a reliable database system.
Atomicity ensures that all operations in a transaction either succeed or fail together. Consistency guarantees that the database remains in a valid state after each transaction. Isolation prevents transactions from interfering with each other, while durability ensures that once data is committed, it will not be lost even in case of system failures. These principles form the foundation of reliable database management.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
