Course: Database Systems Discussion 1 (Chapter 23): What are the main reasons for an potential advantages of distributed databases? Instructions: Your response to the initial question should be 350
Substantive posts to the below:
Post 1:
2 days ago
Ramya
Discussion
COLLAPSE
Top of Form
What are the main reasons for a potential advantages of distributed databases.
Distributed databases basically provide us the advantages of distributed computing to the database management domain. Basically, we can define a Distributed database as a collection of multiple interrelated databases distributed over a computer network and a distributed database management system as a software system that basically manages a distributed database while making the distribution transparent to the user Distributed database management basically proposed for the various reason from organizational decentralization and economical processing to greater autonomy. Databases in the collection are logically interrelated with each other. Often they represent a single logical database. Data is physically stored across multiple sites. Data in each site can be managed by a DBMS independent of the other sites. The processors in the sites are connected via a network. They do not have any multiprocessor configuration. A distributed database is not a loosely connected file system. A distributed database incorporates transaction processing, but it is not synonymous with a transaction processing system. It is used to create, retrieve, update and delete distributed databases. It synchronizes the database periodically and provides access mechanisms by the virtue of which the distribution becomes transparent to the users. It ensures that the data modified at any site is universally updated. It is used in application areas where large volumes of data are processed and accessed by numerous users simultaneously. It is designed for heterogeneous database platforms. It maintains confidentiality and data integrity of the databases. If the system needs to be expanded to new locations or new units, in centralized database systems, the action requires substantial efforts and disruption in the existing functioning. However, in distributed databases, the work simply requires adding new computers and local data to the new site and finally connecting them to the distributed system, with no interruption in current functions.
Reference:
Wiese, Lena. Advanced Data Management : For SQL, NoSQL, Cloud and Distributed Databases . Berlin ;: De Gruyter,, 2015. Web.
Editorial Team. (2014, May 25). What Is a Distributed Database, and What Are Distributed Data Systems For?Atlantic.Net. https://www.atlantic.net/vps-hosting/about-distributed-databases-and-distributed-data-systems/
Altarade, M. (2016, December 15). The Definitive Guide to NoSQL Databases. Toptal Engineering Blog. https://www.toptal.com/database/the-definitive-guide-to-nosql-databases
Post 2:
2 days ago
Brittany
COLLAPSE
Top of Form
Distributed Databases
Distributed databases is a collection of interrelated databases that is logically distributed over a computer network. In order for a distributed database to be managed and distributed, a database management system is the software system that makes the distribution transparent to users (Elmarsi & Navathe, 2017). Distributed databases have many reasons and many potential advantages that attract users to look upon implementing it in their database and software systems. They provide ease and flexibility during application development, increased availability, increased performance, and scalability. During application development there are many users from different geographic regions that will be implementing this, so it is important to have transparency and control when distributing information over computer networks. Information will be distributed over many different nodes and sites, so having data that is reachable and available to all users without having system errors or failures is an advantage. The performance distributed databases provides allows many users to use the nodes, information can be distributed at multiple location sites, there are no delays when accessing information, and multiple queries may be entered and executed at different sites. With scalability, there is more room for expansion, so more data can be added which will then increase database sizes and add more nodes to the distributed databases (Elmarsi & Navathe, 2017).
References
Elmarsi, Ramez & Navathe, Shamkant. (2017). "Fundamentals of Database Systems". (7th Edition). Pearson Education Limited.
