- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Mithlesh Upadhyay has Published 47 Articles
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
2K+ Views
The concept of deferred update in database management systems (DBMS) involves postponing the actual updates to the database on disk until a transaction successfully completes its execution and reaches the commit point. During the execution of a transaction, updates are only recorded in the log and in the cache buffers. ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
170 Views
New storage systems are designed to handle large volumes of data. These new storage systems provide reliable, scalable, and cost-effective storage solutions. In this article, we will discuss three of the most significant recent developments in storage systems Storage Area Networks Storage Area Network (SAN) is a high-speed network of ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
120 Views
Data is the lifeline of businesses. With the increasing amount of data being generated and stored, businesses need a reliable and efficient storage solution. One such solution is Network Attached Storage (NAS). In this article, we will discuss the role of Network Attached Storage in Database Management Systems (DBMS), ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
5K+ Views
Partition By clause can be used to improve query performance. It reduces storage requirements, and improves data manageability. By partitioning a large table, queries that access only a small subset of the data can be executed more quickly. Partitioning can also improve backup and restore times. In this article, we ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
2K+ Views
Normalization is a process of organizing data in a database to reduce redundancy and improve data consistency. Primary keys are really important in organizing information in a database. They help to make sure that every row in a table has a unique identification so that nothing gets mixed up or ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
16K+ Views
Structured Query Language (SQL) is a programming language. SQL is used to manage data stored in a relational database. SQL has the ability of nest queries. A nested query is a query within another query. Nested query allows for more complex and specific data retrieval. In this article, we will ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
1K+ Views
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 ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
11K+ Views
It is essential to maintain data consistency and prevent concurrency issues in database systems. It should be multiple transactions accessing the same data simultaneously. Multiversion Concurrency Control (MVCC) techniques provide an efficient and effective way to achieve this. In this article, we will discuss Multiversion Concurrency Control (MVCC) techniques, its ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
641 Views
Multiple relation queries and JOIN ordering are crucial components of modern database management systems (DBMSs). The execution of multiple relation queries can be challenging because they involve multiple tables, and the order of JOIN operations can affect query performance significantly. Query optimization is a vital aspect of DBMS, as it ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
3K+ Views
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 ... Read More