Database

Other Parts of This Series: Part 11: Journey To Database World: Part 11 (Knowledge Should Have According to Role) Database Internals (Photo Credit: LinkedIn Image) Database internals refer to how a database system works behind the scenes. Like how it stores data in memory and on disk, how it manages updates and deletions, and how it retrieves data efficiently. So as you can imagine, it is a huge topic and a vast area to discuss. But before starting, I want to set the expectation level. In this article, I just touch on the concepts in a summary style and do not go into details to keep it short. If you feel really interested, then you can search each topic and learn the details. Also, you can deep dive into the further learning section given at the end of this article. So let’s get started… ...

Other Parts of This Series: Part 10: Journey To Database World: Part 10 (Vector Database - Qdrant As Example) Part 12: Journey To Database World: Part 12 (Database Internals) Database Role Wise Knowledge (Photo Credit: LinkedIn Image) Here, I’m trying to identify the roles at a low level. Roles and responsibilities may vary based on the needs of the company and the area. Let’s get started… ...

Other Parts of This Series: Part 9: Journey To Database World: Part 9 (Graph Database - Neo4j As Example) Part 11: Journey To Database World: Part 11 (Knowledge Should Have According to Role) Vector Database - Qdrant (Photo Credit: LinkedIn Image) Story: In a university, there was a magical library called The Vector Vault. Instead of books, it stored colorful stars that captured the essence of each book, like its meaning or feel. ...

Other Parts of This Series: Part 8: Journey To Database World: Part 8 (Column Family Database - Cassandra As Example) Part 10: Journey To Database World: Part 10 (Vector Database - Qdrant As Example) Graph Database - Neo4j (Photo Credit: LinkedIn Image) Story: In a magical city called GraphLand, everything is connected in unique and meaningful ways. The city is home to people, places, and things, each playing a special role of relationships that define life there. ...

Other Parts of This Series: Part 7: Journey To Database World: Part 7 (Document Database - MongoDB As Example) Part 9: Journey To Database World: Part 9 (Graph Database - Neo4j As Example) Column Family Database - Cassandra (Photo Credit: LinkedIn Image) Story: Imagine a flexible library where each bookshelf (column family) represents a category of data, such as “Science” or “History.” Within each bookshelf, books (rows) contain unique chapters (columns), and not all books need to have the same chapters. Each book has a unique ID (row key), making it easy to locate on the shelf. So if you only want to read about “Physics,” you can go directly to the “Science” bookshelf and the specific book without flipping through everything else. ...

Other Parts of This Series: Part 6: Journey To Database World: Part 6 (Key-Value Pair Database - Redis As Example) Part 8: Journey To Database World: Part 8 (Column Family Database - Cassandra As Example) Document Database - MongoDB (Photo Credit: LinkedIn Image) Story: Once upon a time, there was a toy store owner named Toma. Toma had a lot of different toys to manage like action figures, dolls, board games, and puzzles. Each toy was unique and had its own special features. ...

Other Parts of This Series: Part 5: Journey To Database World: Part 5 (NoSQL Key-Value Pair Database - DynamoDB As Example) Part 7: Journey To Database World: Part 7 (Document Database - MongoDB As Example) Key Value Pair Database - Redis (Photo Credit: LinkedIn Image) Story: Once upon a time, in the Kingdom of DataLand, there lived a wise wizard named Redis. Redis was known far and wide for his magical Treasure Chest. This chest was special because it could store and retrieve anything instantly, faster than any other chest in the entire kingdom. Also it store data with a key. ...

Other Parts of This Series: Part 4: Journey To Database World: Part 4 (Relational Database - PostgreSQL As Example) Part 6: Journey To Database World: Part 6 (Key-Value Pair Database - Redis As Example) Key Value Pair Database (Photo Credit: LinkedIn Image) Story: Imagine you walk into a futuristic restaurant called “The Key-Value Restaurant.” Instead of a traditional menu, this restaurant uses a magical order board where every item is stored as a key-value pair. It means every food item is stored with a label (key) attached to information (value). You approach the counter, and the counterman says, “Welcome! Tell me your key and your order details (value).” Then after the order is placed, everything will be handled by the key as a reference point. It means finding and updating the order by the key and so on. ...

Other Parts of This Series: Part 3: Journey To Database World: Part 3 (Database Management System - DBMS) Part 5: Journey To Database World: Part 5 (NoSQL Key-Value Pair Database - DynamoDB As Example) Relational Database (Photo Credit: LinkedIn Image) Story: Opu is a student of class 10. He studies in a good, well-known school, and he is a very regular student who attends every class every day. His school keeps all the attendance records of all students. His school has an official canteen and an official bookstore run by the school authority. So they keep those products and sell information as well. Sometimes, for report generation purposes, they need all the information of students, including attendance, food buy, book buy, etc. So they need to store this data very carefully and efficiently. ...

Other Parts of This Series: Part 2: Journey To Database World: Part 2 (Database and Its Different Types) Part 4: Journey To Database World: Part 4 (Relational Database - PostgreSQL As Example) Database Management System (Photo Credit: LinkedIn Image) Story: I hope you now understand exactly what information, records, and data are. Additionally, you should have a general understanding of databases and their many forms. We will learn more about database management systems in this section. Let’s get started. ...