Mithlesh Upadhyay has Published 57 Articles

Multilevel Indexes

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:49:49

6K+ Views

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. But, traditional indexes can become inefficient as the database ... Read More

Multi-tier architecture of Data Warehouse

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:34:50

3K+ Views

In this article, we will discuss the Multi-tier architecture of Data Warehouse. Introduction A data warehouse is like a big storage house where information is kept so that people can use it to make better decisions. This information comes from different places like databases and other systems that keep track ... Read More

MOSS Concurrency Control Protocol (Distributed Locking in Database)

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:33:42

387 Views

This is a protocol used to control concurrency in a distributed database environment. It helps to ensure the consistency and integrity of data in distributed database systems. Concurrency control in databases allows multiple transactions to access the same data simultaneously. In this article, we will discuss the rules and regulations. ... Read More

Modifying a user-defined type (UDT)

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:20:52

206 Views

User Defined Types (UDTs) in Cassandra allows users to create custom data types. With UDTs, you can manage and organize data when multiple data fields are grouped together in a single column. In this article, we will discuss how to modify UDTs in Cassandra with the help of CQL examples. ... Read More

Modeling of UNION Types Using Categories

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:18:32

1K+ Views

In DBMS, Superclass/subclass relationships with a single super-class. A shared subclass may be represented in multiple superclass/subclass relationships, where each relationship has a single superclass. Understanding Superclass/Subclass Relationships in DBMS A single superclass/subclass relationship using more than one superclass. Each superclass represents a distinct entity type. Subclass represents a group ... Read More

Model Planning for Data Analytics

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:16:00

658 Views

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 ... Read More

Methodologies of Large Scale Distributed Systems

Mithlesh Upadhyay

Mithlesh Upadhyay

Updated on 17-May-2023 15:08:10

619 Views

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 have large amounts of data, many concurrent users, scalability requirements, and throughput requirements such as latency, etc. So, We need ... Read More

Advertisements