Navjot Singhnavjot369.hashnode.dev·21 hours agoRelational Model in DBMSIn this model, the data is organised in form of tables(relations). Each table is assigned a unique name. Each table has set of columns (attributes) which tell the relation between values of each record. The single entity in table is called tuple (rec...DiscussDBMS
rohit shahirohitdebugbugs.hashnode.dev·May 14, 2024Simplified DBMS: What You Need to Know1. Introduction to DBMS A Database Management System (DBMS) is a software suite designed to manage, manipulate, and organize data in a database. It serves as an interface between the database and the end-users or application programs, ensuring effici...DiscussDBMS
Amrutha Damruthadronamraju.hashnode.dev·May 12, 2024SQL IndexesIndexes in SQL are data structures that speed up searching and sorting in tables by storing references to specific columns. They allow databases to quickly locate relevant data when executing queries, avoiding the need to scan the entire table. The C...DiscussDevOps Blogssql index
Amrutha Damruthadronamraju.hashnode.dev·May 12, 2024Understanding DBMSDBMS, or Database Management System, serves as software facilitating interaction with databases. It enables users to perform operations like creating, reading, updating, and deleting data stored in the database. Moreover, it aids in organizing and ma...DiscussDevOps BlogsDBMS
Devashish Jadhavdevj.hashnode.dev·May 7, 2024Database IndexingWhen developing a web application for sales analysis, I encountered a significant challenge: sluggish query performance. It left me pondering how major companies effortlessly deliver data within seconds, even when dealing with billions of records. As...Discuss·63 readsDBMS
Siddhartha Gauravsgaurav.hashnode.dev·May 6, 2024Demystifying MySQL: A Beginner's Exploration with Real-world ExamplesAre you new to the world of MySQL databases? Does the terminology seem like a foreign language? Fear not! In this beginner's guide, we'll embark on a journey through MySQL's essential concepts using everyday examples to make them crystal clear. Let's...DiscussMySQLMySQL
Akshay Pariharakshayparihar.hashnode.dev·May 5, 2024Introduction to Database Management SystemsWhat are Data and Information Data is a Collection of raw factors and figures that can be processed to derive meaning or knowledge. In easier terms, we can say that any fact can be Data e.g. 'XYZ', [1, 2, 3] What is a Database A Database is a collect...DiscussDatabases
Siddhartha Gauravsgaurav.hashnode.dev·Apr 29, 2024Understanding String Functions in MySQL with ExampleMySQL is like a toolbox for storing and managing data, and one of its most useful tools is its string functions. These functions help us do cool stuff with text, like combining words, cutting out parts we don't need, and changing letters to uppercase...DiscussMySQLMySQL
Atif Aliatifff.hashnode.dev·Apr 28, 2024Transactions in MongoDB with ACID PropertiesIntroduction Transactions are set of operations that are executed as a single atomic unit, It means a set of operation is called transaction if all the operation are executed successfully and if any one of the operation fails then the entire transact...Discuss·50 likes·95 readsMongoDB
Chidinmachidinma.dev·Apr 28, 2024Exploring DBMS Storage Structures: Heap- vs Hash- vs Index-Organised TablesIntroduction Database Management Systems (DBMS) use different storage structures to organise and access data. Three of the most popular storage structures are Heap-Organised Tables, Hash-Organised Tables, and Index-Organised Tables. In this post, we’...Discuss·33 readshashed-file