Distributed Database System Essay

Submitted By rayan85sa
Words: 1375
Pages: 6
Open Document
INTRODUCTION
Databases have become an important function of everyday life in the management of business or departments as now it is possible to have an access to numerous websites and the information that is kept in these sites (Cavage 2013). A distributed database system is composed of a distributed database that administers or manages the distributed database management system while a distributed database system is a compilation of data that is logically interconnected over several sites that are linked through a network of computer. On the other hand, the distributed database management System is the software that administers the distributed database and provides a framework that ensures that information or data is dispensed or dealt-out in a transparent manner. In a distributed database, system it is assumed that the data or the information is stored at numerous sites, which consist of single processors situated in diverse sites of the system, linked together by a computer network. (Cavage, 2013). The main purpose of a distributed database system is that there is improved availability and reliability of data access as well as improved performance. It is also an easier and economical way of expanding the system. It also ensures the transparent management of data that is distributed that is exhibited by independence of distributed data as well as distributed transaction atomicity.
EXPLANATION OF PAPER
A distributed database system must have some desired properties that include consistency, availability and partition tolerance. The distributive database system should be consistent in the sense that all the sites within the system must be able to see the similar data at the same time, what is known as distributed transaction atomicity. There must be availability of response at any given time when requested or on demand. There must also be a guarantee that the properties in the system will be maintained even when some sites cannot be in constant communication with each other which may be caused by failures in the network, what is known as partition tolerance. However, it is incredible to have a distributed database system that is dependable, readily accessible and can tolerate partitioning all happening at the same time. There are two types of distributed database systems that is the homogenous database system and the heterogeneous database system. In a homogenous distributed database system appears as a single system and all the sites have the same software and are knowledgeable of the existence of the other and agree to process data when requested by other users. In a homogenous distributive database management system, the operating system used in all the sites or location must be similar and well matched as well as the structures of the data utilized. The application used in the database must also be similar and well matched. However, in heterogeneous distributed database the different sites may make use of different schemes and software or what is referred to as multi-database systems. The sites may be unaware of the existence of the other and thus there may only be few facilities for cooperating in transactions confirming how the system is autonomous.
In homogenous distributed database systems there may be distributed data storage whereby we can have different relations stored at distinct sites kept at the different partitions or compartments. The partitions may be organized in horizontal partitioning or vertical partitioning. Further, the horizontal or vertical partitioning may be divided further that is recursively. Moreover, if the partitions are to be brought together, the relations that were initially present must be retained. If they are to be reproduced, the replicas may be stored at multiple or several sites within the distributed database system.
In distributed database systems, there is also distributed query planning that involves data localization, global localization then local optimization. After
Show More

Related Documents: Distributed Database System Essay

Essay Acid and Transaction Model

Industrial Management & Data Systems Architecture for integration of distributed ERP systems and e‐commerce systems Lars Frank Article information: To cite this document: Lars Frank, (2004),"Architecture for integration of distributed ERP systems and e#commerce systems", Industrial Management & Data Systems, Vol. 104 Iss 5 pp. 418 - 429 Permanent link to this document: http://dx.doi.org/10.1108/02635570410537507 Downloaded by Northumbria University At 13:02 01 October 2014 (PT) Downloaded on:…

Words 8856 - Pages 36

Nt1330 Unit 2 Client Server Computing

alternative architecture. The performance is slower because it affected due to process context switches. Fig.1.5: Process-per-client Architecture 2- Multi-threaded architecture: Multithreading architecture refers to the ability of operating system to provide services to more than one request or to more than one user at a time. That meaning, a large number of a short transaction of clients running in the same process and keeps track of each client request as a separate thread as shown in Fig…

Words 1598 - Pages 7

Telemedicine Research Paper

and application, system configuration and requirements. In [1] author describes how Health-care system reforms can change the structure of the current U.S. health-care system, from centralized large hospitals to a distributed, networked health care system. In our model, medical care is delivered locally in neighborhoods and individual homes, using computer technologies like telemedicine, to link patients and primary care providers to tertiary medical providers. Health-care system reforms can change…

Words 562 - Pages 3

Database System Concepts Essay example

Chapter 1: Introduction Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db­book.com for conditions on re­use Database Management System (DBMS)  DBMS contains information about a particular enterprise  Collection of interrelated data  Set of programs to access the data  An environment that is both convenient and efficient to use  Database Applications:  Banking: transactions  Airlines: reservations, schedules  Universities: registration, grades…

Words 1215 - Pages 5

Essay about Distributed Systems and Centralized Sys hellip

Distributed Systems and Centralized Systems Distributed System and Centralized Failures By Kentrell Lanier POS/355 March 28, 2014 Paul Borkowski Distributed System and Centralized System Failures Distributed system is many computers linked together that take on different tasks and act like one big computer. Distributed system is found in business across the world. When computers are linked together they share the same database and server. Distributed system is constructed for resource sharing, computation…

Words 866 - Pages 4

Essay about week1individual 1

Database Systems and Their Architecture Design Victoria Thompson April 13, 2015 DBM/380 Instructor Scott Cain Database Systems and Their Architectural Design According to PCMag Digital Group (1996-2015) a database system is defined as "software that controls the organization, storage, retrieval, security, and integrity of data in a database" (para. 1). Database systems consist of the following four components- end users, database application(s),the database management system, and the database…

Words 591 - Pages 3

Computer Science Essay

An Overview of Database and Database Management System CSC316: Database Systems I A database is a structured collection of data, accessible in various ways. It can be as simple as a text file with a list of names or it can be a complex one, a large relational database management system (DBMS), complete with in-built tools to help one maintain the data. Database design is about how to organize large amounts of information so that it is understandable and can be stored in a computer in such…

Words 1411 - Pages 6

Essay about INFORMATION SYSTEM AND DATABASE

Information Systems and Databases Information systems are computer systems that support end users, giving them access to the information. For a large number of information systems, the data is held in databases and access is via database management systems. Information systems perform a variety of tasks and these are considered in the following topics in the HSC course. While all of the information processes are represented in information systems, the emphasis in this topic is on the processes…

Words 567 - Pages 3

Pravarshi R Essay

Pravarshi R Hadoop Developer - Comcast New Jersey - Email me on Indeed: indeed.com/r/Pravarshi-R/8269aeeecb18f151 Over 5+ years of programming experience with skills in analysis, design, development, testing and deploying for large scale distributed data processing using Hadoop, Pig, Hive and Java and other various software applications with emphasis on Object oriented programming. About 5 years of work experience on Big Data Analytics. Strong hands on experience with Big Data Technologies including…

Words 1560 - Pages 7

E-Ticketing System Case Study

The previous system had been designed in 2002 and scaled for 10 years, but could no longer meet growing demand. In 2013 railway management decided it was time to re-architect the e-ticketing system to better manage existing e-ticket sales, minimize impact on counter sales and accommodate future growth and hired the Centre for Railway Information Systems (CRIS) to complete the work. Solution Engineering for High Concurrency with Distributed In-Memory Database CRIS experts had already determined that…

Words 922 - Pages 4