Blogs

Authentication in Software Systems As we know that, the concept of Authentication is simply identifying an entity (user). So, in a software system how do we manage the process? There are mainly two strategies and their combination when it comes to authentication Username and Password (Knowledge-based strategy) Passwordless (OTP, Login URL) (Possession-based strategy) Multi-factor (Combination of both, has to provide a password and also OTP) Authentication can be simplified into 4 parts ...

Authentication and Authorization Authentication and Authorization is the identification and access control of a user within a service. It is a way to provide security and privacy to users. 1. Authentication Authentication is the process of validating or identifying a user. Example: We keep an ID card to identify ourself as member of a company and as proof, A security will identify us using that ID card (this identification process is authentication). ...

ACID Properties in DBMS The concept of transaction enables the correctness of data in a database, it is achieved by maintaining ACID properties. 1. Atomicity Atomicity is the assurance of DBMS that a transaction will always be either done or not done. Duh… But wait, there are situations where the transactions won’t reach the COMMIT / ROLLBACK, Database program crashes Your OS crashes Computer got restarted etc… In these conditions, the Database ensures that the existing data is not at all affected. This is something RDBMS like Postgres gives us by default, we don’t need to specify anything by means of code. ...

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. ...