0
The database can be of two types either distributed or centralized . In distributed database the data is in different systems. In centralized database the data is in a single central system.
We can categorize database as either distributed or centralized . In centralized database the data is in a single centralized system. While In distributed database the data is in different systems .
What else can I help you with?
Different between distributed and decentralized on database?
Distributed database is one logical database which is spread out over multiple sites, connected by network. It behaves as it were a single database. Decentralized databases are a group of independent databases spead out over different locations. They are not connected and do not share updates between each other.
Discuss the relative advantages of centralized and distributed databases?
Answer:http://wiki.answers.com/Advantages_and_disadvantages_of_distributed_system_over_centralized_system&action=editAdvantages of Distributed Systems over Centralized ones1:Incremental growth:Computing power can be added in smallincrements2:Reliability:If one machine crashes, the system as a whole canstill survive3:Speed:A distributed system may have more total computing power than amainframe4:Open system:This is the most important point and themost characteristic pointof a distributed system.Since it is an open system it is always ready to communicate withother systems.an open system that scales has an advantage over a perfectly closedand self-contained system.Economic:ANd Microprocessors offer a better price/performance thanmainframesDisadvantages of Distributed Systems over Centralized ones1:As i previously told you distributed systems will have aninherent security issue.2:Networking:If the network gets saturated then problems withtransmission will surface.3:Software:There is currently very little less software support forDistributed system.4:Troubleshooting:Troubleshooting and diagnosing problems in adistributed system can also become more difficult, because theanalysis may require connecting to remote nodes or inspectingcommunication between nodes.
What are advantages of rdbms over dbms?
Some advantages of relational database management systems (RDBMS) over traditional database management systems (DBMS) include data integrity through the use of constraints, normalization to reduce redundancy, support for ACID transactions, and standardized SQL language for data manipulation. RDBMS also offer scalability and flexibility for complex data structures and relationships.
What are the disadvantages of a DDBMS?
1) complexity is more compared to centralized DBMS 2) It is much more expensive to setup and maintain a DDBMS. More hardware is required the network maintenance is increased the communication costs increase and there will be additional labour costs. 3) It is much more difficult to maintain a secure network system across multiple locations. The network needs to be made secure and access to replicated data needs to be maintained across multiple sites. 4)Integrity control is more difficult 5)Lack of standard 6)lack of experience 7)more complex database design
Why fragmentation and date replication are useful in Distributed DBMS?
Most people use Relational databases to simplify work. All a Distributed DBMS is a Relational Database spread over a wider area than the workplace. Fragmentation and Date replication are complications and experience says that Distributed DBMS are built to make life simpler
Different between distributed and decentralized on database?
Distributed database is one logical database which is spread out over multiple sites, connected by network. It behaves as it were a single database. Decentralized databases are a group of independent databases spead out over different locations. They are not connected and do not share updates between each other.
Why are distributed systems complex than centralized systems?
Distributed systems are more complex than centralized systems because they involve multiple nodes interacting over a network, leading to challenges such as network latency, node failures, and data consistency. Coordinating and managing these interactions across multiple nodes require additional considerations such as fault tolerance, concurrency control, and communication protocols.
Discuss the relative advantages of centralized and distributed databases?
Answer:http://wiki.answers.com/Advantages_and_disadvantages_of_distributed_system_over_centralized_system&action=editAdvantages of Distributed Systems over Centralized ones1:Incremental growth:Computing power can be added in smallincrements2:Reliability:If one machine crashes, the system as a whole canstill survive3:Speed:A distributed system may have more total computing power than amainframe4:Open system:This is the most important point and themost characteristic pointof a distributed system.Since it is an open system it is always ready to communicate withother systems.an open system that scales has an advantage over a perfectly closedand self-contained system.Economic:ANd Microprocessors offer a better price/performance thanmainframesDisadvantages of Distributed Systems over Centralized ones1:As i previously told you distributed systems will have aninherent security issue.2:Networking:If the network gets saturated then problems withtransmission will surface.3:Software:There is currently very little less software support forDistributed system.4:Troubleshooting:Troubleshooting and diagnosing problems in adistributed system can also become more difficult, because theanalysis may require connecting to remote nodes or inspectingcommunication between nodes.
Is there an advantage if a top weight jockey rides a horse with high handicap?
The main advantage is that the weight is distributed over the wither rather than in a lead bag right across the hos back.
What advantage do reports have over printed forms in database?
Reports allow you greater flexibility in grouping and summarising data compared to printed forms.
Advantage of relational model over hierarchical model?
Use of primary keys less data redundancy compatible with inconsistencies associated with database anomalies
Advantages and disadvantages of distributed system over centralized system?
Advantages of Distributed Systems over Centralized ones 1:Incremental growth:Computing power can be added in small increments 2:Reliability:If one machine crashes, the system as a whole can still survive 3:Speed: A distributed system may have more total computing power than a mainframe 4:Open system: This is the most important point and themost characteristic point of a distributed system. Since it is an open system it is always ready to communicate with other systems. an open system that scales has an advantage over a perfectly closed and self-contained system. Economic:ANd Microprocessors offer a better price/performance than mainframes Disadvantages of Distributed Systems over Centralized ones 1:As i previously told you distributed systems will have an inherent security issue. 2:Networking:If the network gets saturated then problems with transmission will surface. 3:Software:There is currently very little less software support for Distributed system. 4:Troubleshooting:Troubleshooting and diagnosing problems in a distributed system can also become more difficult, because the analysis may require connecting to remote nodes or inspecting communication between nodes. To design my own distribute system i would do the following: 1:Distributed users always pose a threat to be exposed by hackers.Therefore I'l create groups of users and will provide them constrained access to data. 2:Authentication required by all users who use the system. 3:encryption..that is for message protection, 4:The whole Domain is also to be protected via firewalls..so i would install good Firewalls. 5:Would install good anti viruses on my machines which are a part of the distributed system, as these systems are prone to the domino effect that is if one system gets effected the whole network will be susceptible to becoming effected. 6:Design: As far as possible I'll keep the design simple and as local as possible.Will probably use a virtual private network. Will use machines that are compatible with each other. Will enforce secure access on all users. Will probably save the most important, the database on another well equipped machine so that it has a system that is only dedicated to look after the database.
What is a result of a force distributed over area?
What is the result of a force distributed over an area?
What is the result of a force distributed over the area?
What is the result of a force distributed over an area?
What is the result of the force distributed over an area?
What is the result of a force distributed over an area?
Is Facebook a peer to peer file?
No; users communicate over a group of centralized servers, so this is a client-server system.No; users communicate over a group of centralized servers, so this is a client-server system.No; users communicate over a group of centralized servers, so this is a client-server system.No; users communicate over a group of centralized servers, so this is a client-server system.
What happen to Egypt when centralized rule weakened?
When centralized rule in Egypt was weakened, the Hyksos attacked and ruled for over 160 years.
