0
It is when two processes are waiting for something and unable to continue. For example, if you have process A which needs a lock on database X and Y but only has a lock on database X while there is a process B which needs the same locks but only has a lock on database Y, then the 2 processes could potentially wait forever if they are unwilling to let go of their existing locks.
What else can I help you with?
What is false deadlock?
the coordinator conculde incorrectly that a deadlock exist and kills some process --------------------------- Detecting a non existent deadlock in distributed system has been referred as false deadlock and it may occur due to communication delay.. ---->Ashok Paranjothi
What is centralized database?
Distributed and Centralized Databases Distributed data is defined as collection of logically distributed database which are connected with each other through a network. A distributed database management system is used for managing distributed database. Each side has its own database and operating system.A centralized database has all its data on one place. As it is totally different from distributed database which has data on different places. In centralized database as all the data reside on one place so problem of bottle-neck can occur, and data availability is not efficient as in distributed database. Let me define some advantages of distributed database, it will clear the difference between centralized and distributed database.Users can issue commands from any location to access data and it does not affect the working of database. Distributed database allows us to store one copy of data at different locations. Its advantage is that if a user wants to access data then the nearest site (location) will provide data so it takes less time.There are multiple sites (computers) in a distributed database so if one site fails then system will not be useless, because other sites can do their job because as I earlier said that same copy of data is installed on every location. You will not find this thing in centralized database.Any time new nodes (computers) can be added to the network without any difficulty.Users do not know about the physical storage of data and it is known as distribution transparency, as we know that ideally, a DBMS must not show the details of where each file is stored or we can say that a DBMS should be distribution transparent.
What problems could occur if a student database is not maintained?
What problem can occur if a student database is not maintained
Is it possible to occur deadlock in one process during rsource allocation?
No, deadlock occurs when two or more processes are waiting for resources held by each other, leading to a stalemate. In a single process, there is no contention for resources between different processes, so deadlock cannot occur.
What is the difference among deadlock avoidance detection and prevention?
Deadlock prevention is the name of the technique that is designed to get rid of deadlocks by changing the specifications of the system , that is the system design change. This is , basically , about how requests about resources are made and how they are permitted. However , deadlock avoidance is a technique that aims to check deadlock possibility dynamically and decides whether it is safe to grant a resource or not. It ,definitely , needs extra information about potential use of resources for each process. Deadlock Prevention: Preventing deadlocks by constraining how requests for resources can be made in the system and how they are handled (system design). The goal is to ensure that at least one of the necessary conditions for deadlock can never hold. Deadlock Avoidance: The system dynamically considers every request and decides whether it is safe to grant it at this point, The system requires additional apriori information regarding the overall potential use of each resource for each process. Allows more concurrency. Similar to the difference between a traffic light and a police officer directing traffic.
Is deadlock possible only using two way handshake?
Deadlock can occur in various communication protocols, not just those using a two-way handshake. It typically arises when multiple processes or threads are waiting for resources that are held by each other, creating a circular wait condition. While a two-way handshake may contribute to scenarios that lead to deadlock, it is not the sole mechanism through which deadlock can happen. Other protocols and methods, like those using multiple resources or different types of handshakes, can also result in deadlock situations.
What is the Concepts in Orphan in distributed database?
Orphan message - a message whose receive is recorded in some local checkpoint of a global checkpoint but send is not recorded in any local checkpoint in that global checkpoint ( Note : A consistent global checkpoint cannot have an orphan message)
What is necessary condition for deadlock to occur?
1. Competition for non-sharable resources2. Resources requested on a partial basis3. An allocated resource can not be forcibly retrieved
What is the purposed normalization in database?
The purpose of normalization is to reduce the chances for anomalies to occur in a database. The Normalization also forces you to use a database in a Object orientated manner. (This is good of course.)
What is the prime attribute in a database?
It is an attribute that does not occur in some candidate key.
How many types of database connectivity occur?
How many types of database connectivity occur? answer: well,There are several types of database 5 kinds considered to be under database types and 4 under the classification by location: n-1 Single- user:supports only one user at a time .-2 desktop:single=usere database running on a personal computer.3-Multi-user:supports multiple users at the same time such tat can be said as "network"where there are more than one computer at a time.4- workgroupMulti-user database that supports a small group of users or a single department.5-Enterprise;Multi-user database that supports a large group of users or an entire organizationNow is the classification by location database types:1-centralized:supports data located at a single site.2-Distributed :suporrts data distributed across several sites.3-Transactional(or production):supports a company's day to day operations.4-data warehouse:stores data used to generate information required to make tactical or strategic decisions.however,often used to store historical data as well as the structure database is quite different.thanks for reading the artical.MY name is serag zentani if there is any inquire plz do contact me legend1977z@hotmail.com
When a process is rolled back as a result of deadlock the difficulty arises is?
The difficulty that arises when a process is rolled back due to deadlock is ensuring that the system can recover to a consistent state. This involves undoing the actions taken by the rolled back process and potentially restarting or reordering other processes to resolve the deadlock. It can be a complex and time-consuming task to manage the rollback process efficiently and ensure that no further deadlocks occur.
