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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Multiple Relation Queries and JOIN Ordering
Multiple relation queries involve joining several tables to produce a result set. The order in which JOIN operations are executed can significantly affect query performance. Query optimization determines the most efficient execution plan by evaluating different JOIN orderings. Challenges The query optimizer must determine the most efficient execution plan considering join selectivity, data size, distribution, and available access paths. With n tables, there are n! possible join orderings, making optimal selection a complex process. Table A 1M rows Table B ...
Read MoreMultiversion Concurrency Control Techniques
This article has a truncated Drawbacks section at the end. Let me fix that and clean up the SVGs: It is essential to maintain data consistency and prevent concurrency issues in database systems when multiple transactions access the same data simultaneously. Multiversion Concurrency Control (MVCC) techniques provide an efficient way to achieve this by maintaining multiple versions of data items. Concurrency Control Protocols Database systems provide concurrency control to ensure isolation among transactions, maintain consistency, and resolve conflicts arising from read−write and write−read operations. The main techniques used are − Two−phase locking protocol Timestamp ordering ...
Read MoreMultiversion Timestamp Ordering
Multiversion Timestamp Ordering (MVTO) is a popular concurrency control technique used in database management systems (DBMSs). MVTO allows multiple versions of a data item to coexist at the same time, providing high concurrency and data consistency while preventing conflicts and deadlocks. In this article, we will discuss the definition and components of MVTO, as well as how it works. Multiversion Timestamp Ordering (MVTO) In MVTO, each version of the data item has a unique timestamp associated with it. Transactions that access the data item are assigned timestamps as well. There are three components of MVTO: timestamps, ...
Read MoreMultiple Granularity Locking in DBMS
DBMS (Database Management System) is used for effective management of data. It enables multiple users to access the same data without compromising its consistency and integrity. A challenge in DBMS is locking, which is used to prevent multiple users from accessing the same data simultaneously. In this article, we will discuss multiple granularity locking in detail. Multiple Granularity Locking Multiple granularity locking is a locking mechanism that provides different levels of locks for different database objects. It allows for different locks at different levels of granularity. This mechanism allows multiple transactions to lock different levels of granularity, ensuring ...
Read MoreMultilevel Indexes
In this article, we will discuss multilevel indexes in RDBMS, their types, and examples. In Relational Database Management Systems (RDBMS), indexes are essential data structures that allow faster data retrieval by reducing the number of disk accesses required to retrieve data. However, traditional indexes can become inefficient as the database size grows. Multilevel indexes provide a solution to this problem by dividing the index into smaller, manageable pieces. Indexing Indexing helps to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. It is a data structure technique ...
Read MoreMOSS Concurrency Control Protocol (Distributed Locking in Database)
The MOSS (Multi-Object Synchronized Scheduling) Concurrency Control Protocol is used to control concurrency in a distributed database environment. It helps to ensure the consistency and integrity of data in distributed database systems by managing hierarchical transactions with parent-child relationships. In this article, we will discuss the rules and implementation details required while applying the MOSS Concurrency Control Protocol. Overview of Distributed Locking Distributed locking is a mechanism used to synchronize access to shared resources in a distributed computing environment. It involves locking shared resources to prevent other transactions from accessing them concurrently. Distributed locking can be classified into ...
Read MoreModeling of UNION Types Using Categories
In DBMS, superclass/subclass relationships typically involve a single superclass. However, a shared subclass may participate in multiple superclass/subclass relationships, where each relationship has a single superclass. Understanding Superclass/Subclass Relationships in DBMS A union type or category represents a single superclass/subclass relationship using more than one superclass. Each superclass represents a distinct entity type, and the subclass represents a group of objects that is a subset of the UNION of these distinct entity types. Example Consider a motor vehicle registration database with three distinct entity types: PERSON, BANK, and COMPANY. A vehicle owner can be classified as ...
Read MoreModel Planning for Data Analytics
In this article, we will discuss Model Planning for Data Analytics, Role Models and Challenges in Model Planning. We will also discuss the importance of model planning and ways to make an effective model plan. Data analytics is an important component of business strategy nowadays. It helps businesses make informed decisions by extracting meaningful insights from large amounts of data. But model planning plays an important role in data analytics. Model planning involves selecting the right analytical models and techniques that will effectively analyze and interpret the data, thereby helping in making accurate decisions. Data Analytics Data ...
Read MoreMethodologies of Large Scale Distributed Systems
In this article, we will discuss the different methodologies like waterfall, agile and DevOps methodologies. We will also compare them in tabular format. Large Scale Distributed Systems Large-scale distributed systems handle large amounts of data, many concurrent users, scalability requirements, and performance requirements such as low latency and high throughput. Therefore, we need methodologies that can help developers and engineers efficiently build and manage these large-scale distributed systems. In large scale distributed systems, there are various challenges and the major challenge is that the platform becomes huge, making it difficult to meet all the requirements present in ...
Read MoreWhat is NoSQL and is it the next big trend in databases?
This article is already well-structured and comprehensive. It just needs minor cleanup — the 500 word limit doesn't apply here since it's a long-form article that's already good. Let me just fix the small issues: A NoSQL (originally referring to "non SQL" or "non relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases (RDBMS). It encompasses a wide variety of different database technologies that were developed in response to a rise in the volume of data stored about users, objects and products, the ...
Read More