Blogs

Transaction in RDBMS Transaction can be defined as a smallest unit of work. In simple words, A single task or operation with one or multiple steps. It can be considered as one of the core concepts in DBMS (A unit of work is generally important to understand in all systems) Let’s see some transactions in our Magic Library A reader asks for a book: The librarian finds the book and gives it to the reader. An author wants to change the title of their book: Librarian finds the book, Changes the title and keeps it in the same place as before. So, Transaction can be either ...

Introduction to DBMS DBMS: A DataBase Management System is simply a program that stores data into a storage space. It knows how to sort and filter the data with various parameters and often does some processing with data. It can also organise the data in an optimal structure such that its faster to sort and filter them. DBMS or RDBMS ? DBMS is generally a management program for data. RDBMS is a DBMS that organize data based on tables, data is organized as rows and columns inside a table structure. Other DBMS stores data in a different format, mostly document structure similar to JSON Why do we need Database Management Program? A DBMS is needed to organize and serve requests of clients on collections of data. ...