Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
RDBMS Articles
Page 3 of 8
New Storage Systems
Modern storage systems are designed to handle large data volumes with reliability, scalability, and cost-effectiveness. The three significant developments are SAN, NAS, and iSCSI. SAN Fibre Channel Block-level access NAS Ethernet / LAN File-level access iSCSI SCSI over IP Block-level over Ethernet Storage Area Networks (SAN) SAN is a high-speed dedicated network of storage devices configured as nodes, allowing flexible attachment and detachment from servers. SANs use Fibre ...
Read MoreNetwork Attached Storage in DBMS
Network Attached Storage (NAS) is a dedicated storage device connected to a network that allows multiple clients to store and access files. In DBMS, NAS serves as a storage solution for database files, backups, and shared data without requiring a full server. NAS Storage Device LAN (Ethernet) DB Server Web Server ...
Read MoreNested Queries in SQL
A nested query (subquery) is a query placed inside another query. The inner query executes first and its result is used by the outer query for more complex data retrieval. Syntax SELECT column1, column2 FROM table1 WHERE column1 IN ( SELECT column1 FROM table2 WHERE condition ); Types of Nested Queries Non-Correlated Inner runs independently Result passed to outer Operators: IN, NOT IN, ALL, ANY ...
Read MoreMySQL PARTITION BY Clause
The PARTITION BY clause in MySQL groups rows into separate partitions (windows) for use with window functions like RANK(), DENSE_RANK(), LEAD(), and LAG(). It must always be used inside an OVER() clause. If omitted, the entire table is treated as a single partition. Syntax window_function(expression) OVER (PARTITION BY column_name [ORDER BY column_name] [frame_clause]) Example Consider a Hacker table ? CREATE TABLE Hacker ( h_id INT, h_name VARCHAR(50), challenge_id INT, score INT ); INSERT INTO Hacker ...
Read MoreMultiversion Timestamp Ordering
Multiversion Timestamp Ordering (MVTO) is a concurrency control technique that maintains multiple versions of each data item. Each version has a unique timestamp, and transactions access the appropriate version based on their own timestamp, preventing conflicts and deadlocks. Components Each version Xi of a data item maintains − Value − The data content of that version. Read_TS(Xi) − Largest timestamp of any transaction that successfully read Xi. Write_TS(Xi) − Timestamp of the transaction that created Xi. How MVTO Works ...
Read MoreMultiple Granularity Locking in DBMS
Multiple granularity locking provides different levels of locks for different database objects − from the entire database down to individual records. This maximizes concurrency while maintaining consistency. Granularity Hierarchy Database Area 1 Area 2 File 1 File 2 File 3 File 4 R1 ...
Read MoreMultilevel Indexes
In RDBMS, indexes are data structures that speed up data retrieval by reducing disk accesses. As databases grow, single-level indexes become too large for main memory. Multilevel indexes solve this by dividing the index into a hierarchy of smaller, manageable blocks. Index Components Search Key Sorted primary/candidate key points to Data Reference Pointer to disk ...
Read MoreMulti-tier architecture of Data Warehouse
A data warehouse is a central repository that consolidates data from multiple sources into a format optimized for analysis and decision-making. To handle the complexity and volume of data efficiently, data warehouses use a multi-tier architecture where each layer performs a specific function. Multi-tier Architecture Layers Data Sources DBs, Files, External APIs ...
Read MoreMOSS Concurrency Control Protocol (Distributed Locking in Database)
The MOSS (Multi-Object Synchronized Scheduling) Concurrency Control Protocol manages concurrency in distributed database systems by handling hierarchical transactions with parent-child relationships and lock inheritance. Distributed Locking Types Optimistic locking − No locks acquired upfront; conflicts detected at commit time. Pessimistic locking − Locks acquired before accessing shared resources; conflicts prevented from the start. MOSS Protocol MOSS is a hierarchical locking protocol for nested transactions where subtransactions can inherit locks from ancestors ? ...
Read MoreModeling of UNION Types Using Categories
In DBMS, superclass/subclass relationships typically involve a single superclass. However, a union type or category represents a subclass that is a subset of the UNION of multiple distinct superclass entity types. Example: Vehicle Owner Category Consider a motor vehicle registration database with three entity types: PERSON, BANK, and COMPANY. A vehicle owner can be any one of these. We create a category called OWNER that represents the union of all three ? PERSON BANK COMPANY ...
Read More