Navneet Pandey

Database Indexing

An index is a data structure created on top of an existing table within a database. Its purpose is to improve the speed of data retrieval by providing a way to access quickly (fast lookups) the desired data without having to scan the entire table. A real-world example can be

Strategy Pattern

The Strategy pattern allows you to swap out different algorithms or strategies without changing the overall behaviour of the program. This pattern is part of behavioural design pattern. The Strategy pattern enables following the Open/Closed principle by promoting abstraction, encapsulation and loose coupling between interchangeable behaviours/algorithms and the

Liskov Substitution Principle

The Liskov Substitution Principle (LSP) is a principle in object-oriented programming that suggests that objects of a superclass should be replaceable with objects of its subclasses. That means  if a piece of code is designed to work with objects of a certain base class, it should also work correctly with

Open Closed Principle

The Open/Closed Principle, a principle of object-oriented programming, emphasises that classes or methods should be designed in a way that allows for extension (adding new functionality) without modification (changing existing code). This principle promotes the idea of designing code that is flexible, maintainable, and resilient to change. The rationale

Single Responsibility Principle

The Single Responsibility Principle (SRP) is a principle in object-oriented programming that suggests that a class should have only one reason to change. This means that a class should have a single responsibility or purpose, and should not be responsible for multiple unrelated tasks. By following the SRP, 1. classes

Navneet Pandey © 2026