Feb 2 · 36 min read · যারা সবকিছু পরিপাটি করে রাখে, তারা মূলত খোঁজাখুঁজির কষ্ট করতে চায় না বলেই এমনটা করে। - German Proverb মৌলিকভাবে একটি ডাটাবেসকে দুটি কাজ নিখুঁতভাবে করতে হয়: ১. ডেটা স্টোর করা: যখন আপনি ডাটাবেসকে কোনো তথ্য দেবেন, তখন সেটি যেন সুরক্ষিতভাবে জমা রাখে। ২....
Join discussion
Aug 9, 2025 · 14 min read · OLTP vs OLAP represent two distinct approaches in data management. OLTP handles real-time transactions like processing an online purchase, while OLAP analyzes historical data to uncover business trends. Imagine a cashier scanning items for quick chec...
Join discussion
Jul 21, 2025 · 2 min read · OLTP means Online Transaction Processing and OLAP means Online Analytical Processing. OLTP (Online Transaction Processing) OLTP databases supports the day to day transactions. It’s a scenario database for storing day to day sales, people coming in, l...
Join discussion
Jun 1, 2025 · 3 min read · Hoy vamos a hablar de algo un poco más amplio: los motores de bases de datos. A grandes rasgos, los podemos dividir en dos grandes categorías: OLTP (procesamiento de transacciones online): los que están optimizados para procesar transacciones. OLAP...
Join discussion
Aug 17, 2024 · 3 min read · Henlo frens We discussed till LSM-tree in the last blog, had to break it down into 2 cause this chapter has too much information. Many databases use B-trees, it has become the standard. LSM-tree and B-tree both keep the key value pair sorted, but bot...
Join discussion
May 31, 2024 · 2 min read · Chapter Overview This chapter dives into the fundamental operations of databases - how they store and retrieve data. It categorizes storage engines into two main groups: I. Online Transaction Processing (OLTP) Databases Optimized for user-facing app...
Join discussion
Mar 12, 2024 · 2 min read · Changing the data type of a column in ClickHouse, like in many database systems, is a sensitive operation and needs careful planning, especially in a production environment. Directly altering a column's data type isn't supported as a single operation...
Join discussion
Feb 24, 2024 · 2 min read · Restricting new connections to a PostgreSQL database is essential during maintenance periods or to manage system resources effectively. Here are several methods to achieve this: 1. Modify max_connections Setting The max_connections setting in the pos...
Join discussion
Feb 12, 2024 · 3 min read · MySQL date columns come with certain default behaviors that, if not properly understood or managed, can lead to significant performance degradation in queries. Here's an overview of some "deadly defaults" associated with MySQL date columns and how th...
Join discussion
Feb 12, 2024 · 3 min read · Leaf block contention in InnoDB tables can significantly impact the performance of your MySQL database, especially under high concurrency. This situation typically occurs when multiple transactions are trying to modify or lock rows in the same leaf b...
Join discussion