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
DBMS Articles
Page 6 of 27
Explain about two phase locking (2PL) protocol(DBMS)
Locking and unlocking of the database should be done in such a way that there is no inconsistency, deadlock, and no starvation.2PL locking protocolEvery transaction will lock and unlock the data item in two different phases.Growing Phase − All the locks are issued in this phase. No locks are released, after all changes to data-items are committed and then the second phase (shrinking phase) starts.Shrinking phase − No locks are issued in this phase, all the changes to data-items are noted (stored) and then locks are released.The 2PL locking protocol is represented diagrammatically as follows −In the growing phase transaction ...
Read MoreWhat is the difference Rename and Alias In DBMS
In this article, we are going to study Rename and Alias. Both these have their specific role when we talk in terms of DBMS. Renaming and aliases to the elements of the database provide a layer of abstraction and make the attributes of the relation presentable for the viewer. Mostly, Database store crucial information the concepts of renaming and aliasing plays an important role in representing data with efficiency. Let's gain an understanding of these concepts, their syntax, and the difference between them. What is Alias? Alias is an alternative name given to a column in the database Management System. This practice ...
Read MoreNoSQL Systems VS Traditional Database Systems
As individuals, we often save our data on devices like laptops and phones, but rarely do we consider the databases that underlie these storage systems. Databases are the place where organizations can easily store their data. DBMS is used to manage the database. In this article, we will study the two specific databases NoSQL and Traditional Database. However, their designs diverge, resulting in distinct approaches to data storage and retrieval. Let's explore the below article which gives you depth of understanding about the key differences in each of them. What is a NoSQL Database? When we say NoSQL it sounds ...
Read MoreExplain attributes and the different types of attributes in DBMS?
Attributes are the properties which describe an entity. Example The attributes of student entity are as follows − Roll number Name Branch Age Types of attributes The different types of attributes are as follows − Composite attribute It can be divided into smaller sub parts, each sub part can form an independent attribute. For example − ...
Read MoreExplain the role of the Database Administrator in DBMS?
A database administrator (DBA) is a person or group in charge of implementing DBMS in an organization. The DBA job requires a high degree of technical expertise. DBA consists of a team of people rather than just one person.The primary role of Database administrator is as follows −Database designPerformance issuesDatabase accessibilityCapacity issuesData replicationTable MaintenanceResponsibilities of DBAThe responsibilities of DBA are as follows −Makes the decision concerning the content of the database.Plans the storage structure and access strategy.Provides the support to the users.Defines the security and integrity checks.Interpreter backup and recovery strategies.Monitoring the performance and responding to the changes in the ...
Read MoreWhat is data Abstraction in DBMS?
Data Abstraction is a process of hiding unwanted or irrelevant details from the end user. It provides a different view and helps in achieving data independence which is used to enhance the security of data.The database systems consist of complicated data structures and relations. For users to access the data easily, these complications are kept hidden, and only the relevant part of the database is made accessible to the users through data abstraction.Levels of abstraction for DBMSDatabase systems include complex data-structures. In terms of retrieval of data, reduce complexity in terms of usability of users and in order to make ...
Read MoreExplain the characteristics of DBMS?
There are so many characteristics of a database management system, which are as follows − A database management system is able to store any kind of data in a database. The database management system has to support ACID (atomicity, consistency, isolation, durability) properties. The Database management system allows so many users to access databases at the same time. Backup and recovery are ...
Read MoreException Handling in Distributed System
Introduction In context of distributed systems, exception handling refers to process of detecting, diagnosing, and recovering from errors that occur in a distributed system. In such systems, errors can occur at any point in communication and coordination process, including network failures, hardware malfunctions, and software bugs. Thus, effective exception handling is crucial to ensure reliability and availability of a distributed system. In this article, we will explore various techniques and best practices for exception handling in distributed systems. Importance of Exception Handling in Distributed Systems In a distributed system, multiple processes run on different machines and communicate with each other ...
Read MoreEvolution of Distributed Computing Systems
Introduction Distributed computing systems refer to a network of interconnected devices that share resources and work together to achieve a common goal. evolution of distributed computing systems has been rapid, and it has transformed way we use technology in our daily lives. From simple file sharing systems to advanced cloud computing, distributed computing systems have come a long way. In this article, we will discuss evolution of distributed computing systems and explore some of examples. Early Days of Distributed Computing The early days of distributed computing can be traced back to 1960s, where researchers began experimenting with idea of sharing ...
Read MoreEvent Ordering in Distributed System
Introduction Distributed systems have become an integral part of our modern-day technological infrastructure. They have made it possible to deliver services at scale, provide better resilience, and enable better fault tolerance. However, designing distributed systems is a challenging task, and one of most significant challenges is maintaining ordering of events in system. This article will discuss event ordering in distributed systems and provide examples of different techniques used to achieve it. Event Ordering Event ordering is essential in distributed systems because it determines order in which events occur. In a distributed system, events can happen concurrently on different nodes, and ...
Read More