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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Multimedia Database Concepts
A multimedia database stores and manages different types of media − text, images, audio, video, and animations. All media files are stored as binary strings encoded according to their file types, enabling efficient storage and retrieval of rich content. Types of Multimedia Data Type Description Examples Static Media Not time-dependent Images, graphics, text Dynamic Media Time-dependent Audio, video, animations Dimensional Media 3D data for CAD programs 3D models, vector graphics Contents of a Multimedia Database Media data − The actual multimedia object (image, audio, video). ...
Read MoreMultilevel Association Rule in data mining
Association rule mining discovers relationships between items in a dataset using "If A, then B" rules measured by support (frequency) and confidence (reliability). Multilevel association rule mining extends this to find relationships at different levels of granularity − for example, between individual products and product categories. Association Rule Basics The Apriori algorithm is widely used for mining association rules. It iteratively generates candidate itemsets and prunes those below support/confidence thresholds. Electronics Laptops Phones ...
Read MoreNormal Forms Based on Primary Keys
Normalization organizes data in a database to reduce redundancy and improve consistency. Primary keys uniquely identify each row, and normal forms define progressive rules based on functional dependencies to eliminate data anomalies. Types of Keys Key Type Definition Super Key Set of attributes that uniquely identifies each record (may have extra attributes) Candidate Key Minimal super key − no redundant attributes Primary Key Chosen candidate key for unique identification Alternate Key Candidate keys not selected as primary key Foreign Key Column referencing another table's primary key ...
Read MoreNode in Apache Cassandra
Apache Cassandra is an open-source NoSQL database written in Java, designed for high availability with no single point of failure. Nodes are the fundamental building blocks of Cassandra's distributed architecture, forming a peer-to-peer ring structure. Node in Cassandra Each node holds actual data along with metadata (location, data center, keyspaces, tables, schema). Nodes form a ring where every node is equal − no master/slave hierarchy. Data is distributed across nodes using a partitioner, and replicas are stored on multiple nodes for fault tolerance. ...
Read MoreNO-UNDO REDO Recovery Based on Deferred Update
In deferred update recovery, actual database modifications on disk are postponed until a transaction commits. Updates are recorded only in the log and cache buffers during execution. If a transaction fails before commit, the database on disk remains unaffected − hence NO-UNDO. Only REDO is needed for committed transactions whose changes haven't been written to disk. Deferred Update Protocol A transaction cannot modify the database on disk until it reaches its commit point. All REDO log entries must be force-written to disk before commit (Write-Ahead Logging). Only REDO log entries (new values/AFIM) are needed − no UNDO ...
Read MoreNew 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 More