Premium Essay

Distributed Database

In: Computers and Technology

Submitted By djaboutbusiness
Words 944
Pages 4
Assignment 8: Distributed Databases

The reason for writing this paper is to clarify the importance of distributed database and why national chain restaurant should implement it. Given the situation presented in the assignment a small restaurant has grown to become a national restaurant chain and now they are concerning more on the distribution of data among different sites chains. For this approach distributed database architecture is suggested and reasons to implement the distributed database I will explain throughout the rest of this paper.
The three reasons why an organization may have a need for distributed databases and best practices for implementation of distributed database would be that it provides the distributed transaction management. It provides the provision to do the distributed transactions like select, update and delete on the data without worrying about concurrency or locking problems and they distributed database are independent of given hardware. Today’s world involves a diversity of different machines like Sun machines, PCs, IBM machines, HP machines, and workstations of various kinds. In distributed DBMS all these machines are able to incorporate the data on all of those systems. The plan is to be able to run the same DBMS on a different hardware platform. Operating system independence distribute DBMS is independent of the underlying operating system like UNIX, Linux, Sun Solaris or Windows. All the databases in this model are compatible with different OS versions. DBMS independence means this model different types of databases are integrated with each other to create distributed architecture and performs distributed transaction easily. These databases may be Oracle, SQL Server or DB2.

The software and hardware components of a distributed database would consist of Computer workstation at all location sites called as nodes. Network...

Similar Documents

Free Essay

Distributed Databases

...centralized and we design a new system of database which is distributed i.e. the database of the Lahore campus is in Lahore and the database of karachi campus is in Karachi i.e a collection of multiple ,logically interrelated databases distributed over a computer network. DDBMS: A distributed database management system is defined as a software system that permits the management of the ddbs and makes the distribution transparent to the users. Why we use distributed database? In centralized system, all queries are handled by the main server and all loads are on the server but in distributed system, a separate server for each site exists. • In centralized system If centre goes down, everything is down. So you need to have offsite redundant servers. • In centralized system there is the single point of failure that can bring an entire company down in the event of a server crash but in distributed system if one server crashed down we get information from main server. Distributed Database design: The design of a distributed computer system involves making decisions on the placement of data and programs across the sites of the computer network .in the case of distributed DBMSs,the distribution of application invoves two things: • The distribution of the distributed DBMS softwares • the distribution of thr application of the programs that run on it It has been suggested that the organization of the distributed systems can be investigated along......

Words: 2137 - Pages: 9

Premium Essay

Distributed Database

...Distributed database is one in which multiple database sites are linked by a communications system in such a way that the data at any site is available to users at other sites. Depending on the needs of an organization the following reasons would be why they would have the needs of distributed databases: * Improved reliability. A distributed system is more reliable than a centralized one, because processing is done at several sites, so failure of a single node does not halt the entire system. Distributed systems can be designed to continue to function despite failure of a node or of a communications link. * Better Data availability. Distributed database systems often provide for replication of data. If a node fails, or the only link to a node is down, its data is still available, provided a copy is kept somewhere else in the system. * Lower communication cost. If data used locally is stored locally, communications cost will be lower, since the network will not be used for most request. In centralized system, the communications network is needed for all remote requests. However, we must consider the additional cost for the database software, additional storage costs for multiple copies of data items and software, higher hardware costs, and higher operating costs the distribution can entail. Distributed database has different types of distributed systems. These systems ate homogeneous and heterogeneous. With homogeneous all modes use the same hardware and......

Words: 866 - Pages: 4

Premium Essay

Distributed Databases

...Assignment 8: Distributed Databases Due Week 9 and worth 50 points A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fifty states will not have ready access to the data. Your supervisor has asked you to write a report to address the concerns of the customer and figure out how to expand the single server / single location database so the other 500 locations will be able to access and update the system. Write a 2-3 page paper in which you: 1.List three (3) reasons why an organization may have a need for distributed databases and best practices for implementation of distributed database. 2.List and explain: ◦The software and hardware components of a distributed database. ◦Techniques for distributed data placement. ◦Strategies for distributed query processing. 3.Briefly explain how an organization would allow programmatic access to a database through the Internet. 4.Please make any or all appropriate assumptions to answer the following. ◦Propose a solution for the national restaurant chain on a distributed database system that will work for them. ◦Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length. 5.Use at least three (3) quality resources in this assignment.......

Words: 440 - Pages: 2

Free Essay

Distributed Database

...Today's business environment has an increasing need for distributed database and client/server applications as the desire for reliable, scalable and accessible information is steadily rising. Distributed database systems provide an improvement on communication and data processing due to its data distribution throughout different network sites. Not only is data access faster, but a single-point of failure is less likely to occur, and it provides local control of data for users. However, there is some complexity when attempting to manage and control distributed database systems. The DDBMS synchronizes all the data periodically, and in cases where multiple users must access the same data, ensures that updates and deletes performed on the data at one location will be automatically reflected in the data stored elsewhere. A distributed database can also be defined as a collection of multiple, logically interrelated databases distributed over a computer network. A distributed database management system is then defined as the software system that permits the management of the distributed databases and makes this distribution transparent to the users. Distributed database system is to referred as a combination of the distributed databases and the distributed DBMS Current trends in multi-tier client/server networks make DDBS an appropriated solution to provide access to and control over localized databases. Oracle, as a leading Database Management System (DBMS) vendor employs the......

Words: 3658 - Pages: 15

Premium Essay

Design and Applied Research of the Distributed Real-Time Database in Smart Grid

...Design and Applied Research of the Distributed Real-time Database in Smart Grid Chunfeng Liu, Yan Jiang, Feng Zhao, Qiao Sun, Yang Zhang, Zhiqi Li, Chao Li Beijing Guodiantong Network Technology Company Ltd., No.1 Hangfeng Road, Fengtai District, Beijing, 100070, China {liuchunfeng, jiangyan, feng_zhao, sunqiao, zhangyang2, lizhiqi, lichao3}@sgepri.sgcc.com.cn database. Both timing constraints and data consistency should be taken into consider in real-time database systems when scheduling the transactions so that they can be accomplished by their corresponding deadlines[3]. For instance, both the query and update on the acquisition data of smart electricity meters, mainly working for the calculation of the multistep electricity price and electricity increment, must satisfy not only the database consistency constraints but also the time constrain, processed within the given deadlines. Apart from the time constraints that are out of the demand of continuously data tracking, timing correctness requirements are also proposed due to the need to keep data available for the decision-making activities of the controlling systems[4]. Based on these situations, real-time databases are used in a wide Keywords— Distributed, real-time database, smart grid, typical range of applications in the power industry. applications, electric energy data acquire system At the same time, the electricity data also has astounding I. INTRODUCTION quantities. In China, the scale of the data points in......

Words: 4176 - Pages: 17

Premium Essay

Advantages And Disadvantages Of Distributed Database System

...A distributed database is a database in which storage devices are not all attached to a common processor. Portions of the database are stored in multiple physical locations and processing is distributed among multiple database nodes. The data on several computers can be simultaneously accessed and modified using a network. Unlike parallel systems, in which the processors are tightly coupled and constitute a single database system, a distributed database system consists of loosely coupled sites that share no physical components. A centralized distributed database management system (DDBMS) integrates the data logically so it can be managed as if it were all stored in the same location. The DDBMS synchronizes all the data periodically and ensures...

Words: 747 - Pages: 3

Free Essay

Assignment

... |: |HND | |SEMESTER |: |04 | |UNIT NO./TITLE |: |35/ Distributed Design and Development | |ASSIGNMENT NO. |: |01 | |ASSIGNMENT TITLE |: |City Bank Distributed Design System | |UNIT OUTCOMES COVERED |: | | | 35.1 Understand Microsoft architecture for enterprise applications | |35.2 Design a distributed application | |35.3 Build a distributed application | |35.4 Build and use components | |ASSIGNMENT TYPE ...

Words: 1429 - Pages: 6

Free Essay

Pos 355 Failures

...Failures POS/355 August 26, 2013 UOPX Failures Distributed systems emerged recently in the world of computers. A distributed system is an application of independent computers that appear to work as a coherent system to its users. The advantages of distributed systems consist of developing the ability to continually to open interactions with other components to accommodate a number of computers and users. Thus, stating that a stand-alone system is not as powerful as a distributed system that has the combined capabilities of distributed components. This type of system does have its complications and is difficult to maintain complex interactions continual between running components. Problems do arise because distributed systems are not without its failures. Four types of failures will characterize and the solutions to two of these failures will address on how to fix such problems. Before constructing a distributed system reliable one must consider fault tolerance, availability, reliability, scalability, performance, and security. Fault tolerance means that the system continues to operate in the event of internal or external system failure to prevent data loss or other issues. Availability needed to restore operations to resume procedure with components has failed to perform. For the system to run over a long period without any errors is need and known as reliability. To remain scalable means to operate correctly on a large scale. Performance and security remains......

Words: 953 - Pages: 4

Free Essay

The Knuth Marris Pratt Algorithm

...Middleware for Distributed Systems Evolving the Common Structure for Network-centric Applications Richard E. Schantz BBN Technologies 10 Moulton Street Cambridge, MA 02138, USA schantz@bbn.com Douglas C. Schmidt Electrical & Computer Engineering Dept. University of California, Irvine Irvine, CA 92697-2625, USA schmidt@uci.edu 1 Overview of Trends, Challenges, and Opportunities Two fundamental trends influence the way we conceive and construct new computing and information systems. The first is that information technology of all forms is becoming highly commoditized i.e., hardware and software artifacts are getting faster, cheaper, and better at a relatively predictable rate. The second is the growing acceptance of a network-centric paradigm, where distributed applications with a range of quality of service (QoS) needs are constructed by integrating separate components connected by various forms of communication services. The nature of this interconnection can range from 1. The very small and tightly coupled, such as avionics mission computing systems to 2. The very large and loosely coupled, such as global telecommunications systems. The interplay of these two trends has yielded new architectural concepts and services embodying layers of middleware. These layers are interposed between applications and commonly available hardware and software infrastructure to make it feasible, easier, and more cost effective to develop and evolve systems using reusable software.......

Words: 10417 - Pages: 42

Premium Essay

Failures in Distributed and Centralized Systems

...Failures in Distributed and Centralized Systems Student Name POS/355 Instructor Name Date Failures in Distributed and Centralized Systems In today’s technology we have a vastly wide range of options when it comes to networking and linking computer systems. Organizations use a few different methods to linking their systems together. Large organizations, such as banks, power grids, and airport flight controller systems use what is called a distributed system. A distributed system must be reliable, available, safe, and secure. Since a distributed system is a widely available system that is essentially a collection of independent computers. With any large system, there are more components, more software, and more security risks that can jeopardize the system’s integrity. Many smaller organizations use what is called a centralized system, which can be anything from a personal computer to several terminals connected to a server. These systems can run into a few errors within their processes called failures. Distributed System According to our text, “A distributed system is a collection of processors that do not share memory or a clock. Instead, each processor has its own local memory. The processors communicate with one another through various communication networks, such as high-speed buses or telephone lines. In this chapter, we discuss the general structure of distributed systems and the networks that interconnect them.” (Silbershatz, A., Galvin, P. B., & Gagne,......

Words: 1091 - Pages: 5

Premium Essay

Four Types of Distributed Computer System Failures

...Four Types of Distributed Computer System Failures University of Phoenix August 19, 2013 David Conway Four Types of Distributed Computer System Failures This paper will discuss four common types of distributed computer system failures which are Crash failures also known as operating system failures, Hardware Failures, Omission Failures and Byzantine Failures. Included in the discussion are failures which can also occur in a centralized computer system, and how to isolate and repair two types of failures. Crash failures are normally associated with a server fault in a typical distributed system. Inherently crash failures are interrupt operations of the server and can halt operation for a considerable time (Projects Helper, 2012).Operating system failures are the best examples for this scenario. Operating System or software failures come in many more varieties than hardware failures. Software bugs in distributed systems can be difficult to replicate and, consequently, repair and or debug. Corresponding fault tolerant systems are developed and employed with respect to these affects. An operating system or software failure can also occur in a centralized system such as a data base this is why it is highly recommended to back up a data base using stable mass storage media (Projects Helper, 2012). We have an......

Words: 1180 - Pages: 5

Free Essay

Distributed System Failures

...Victoria White Distributed System Failure December 16, 2013 There are two types of system structures that can be created. The first is a centralized system, which consists of one or more major hubs. All communication is processed through these hubs. This system setup provides security, to an extent, since all of the computing is done through a single computer. However, it also creates a single point of failure, if the main computer goes down the system is down. A distributed system is a collection of processors connected by a communication network. The processors may include microprocessors, workstations, minicomputers, and large computer systems. These processors are known by a few different names, sites, hosts, nodes, computers, and machines. There are a couple major reasons for creating a distributed system, these reasons include resource sharing, communication, reliability, and computation speedup. However, there are a few failures that may occur with a distributed system these failures include link failure, host failure, storage media failure, and scalability. The first failure, link failure, occurs when the connection between two parts of the system fails. When this takes type of failure takes place the two parts of the system connecting can no longer communicate with each other. To detect link failure, a procedure known as handshaking is done. With this procedure first the host that is still functioning will continue to send I-am-up messages to the other host.......

Words: 1102 - Pages: 5

Free Essay

Operating System Upgrade

...NAME: MODERN OPERATING SYSTEMS PROFESSOR: SCHOOL: DATE: MARCH 25th, 2013 Table of Contents Company Background 4 Employee Access 4 Data center description (servers, OS) 4 Client machines 4 Company Communication 5 Problems with the Current Information Systems 5 Proposed System 6 OS Processor and Core 8 Hardware 8 Benefits from Upgrading to Operating System Utilizing a Multi-Processor 9 Steps to Upgrade the Processor and Core 9 Requirements Supporting the Upgrade 10 Conclusion 10 Scheduling Algorithm 11 In First-Come First-Served Scheduling 11 Benefits and Challenges Presented by FCFS 12 Round robin scheduling 12 Benefits and Challenges Presented by Round Robin Scheduling 13 Conclusion 14 Distributed Computing Environment 15 Operating System Concurrency Mechanism 15 Grid Computing 16 Concurrency control mechanisms in handling communications and synchronization 17 OS Security Risks and Mitigation Strategy 18 The main areas of the operating system that are evaluated for performing the risk assessment are: 20 Prioritization risks in the operating system: 21 Risk mitigations for the risks in the operating systems: 24 Emerging Technologies and Architecture 26 Cloud Computing 26 Remote Procedure Call (RPC) 27 Object Request Broker (ORB) 28 Advantages of Cloud Computing to Jinx 29 Advantages of RPCs 29 Advantages of using ORB 30 How Jinx Will Benefit from these Technologies 30 References 32 Appendix......

Words: 7042 - Pages: 29

Premium Essay

What Title ?

...The University Student Registration System: a Case Study in Building a High-Availability Distributed Application Using General Purpose Components M. C. Little, S. M. Wheater, D. B. Ingham, C. R. Snow, H. Whitfield and S. K. Shrivastava Department of Computing Science, Newcastle University, Newcastle upon Tyne, NE1 7RU, England. Abstract Prior to 1994, student registration at Newcastle University involved students being registered in a single place, where they would present a form which had previously been filled in by the student and their department. After registration this information was then transferred to a computerised format. The University decided that the entire registration process was to be computerised for the Autumn of 1994, with the admission and registration being carried out at the departments of the students. Such a system has a very high availability requirement: admissions tutors and secretaries must be able to access and create student records (particularly at the start of a new academic year when new students arrive). The Arjuna distributed system has been under development in the Department of Computing Science for many years. Arjuna’s design aims are to provide tools to assist in the construction of fault-tolerant, highly available distributed applications using atomic actions (atomic transactions) and replication. Arjuna offers the right set of facilities for this application, and its deployment would enable the University to exploit the......

Words: 8052 - Pages: 33

Premium Essay

Case Study Lego

...LEGO - EMBRACING CHANGE BY COMBINING BUSINESS INTELLIGENCE WITH A FLEXIBLE INFORMATION SYSTEM History of LEGO Company The LEGO Group was founded in 1932 by Ole Kirk Kristiansen. The company has passed from father to son and is now owned by Kjeld Kirk Kristiansen, a grandchild of the founder.   It has come a long way over the past almost 80 years - from a small carpenter’s workshop to a modern, to a global enterprise that is now, in terms of sales, the world’s fourth-largest manufacturer of toys. The name 'LEGO' is an abbreviation of the two Danish words "leg godt", meaning "play well". The original Lego toys started with a wooden duck. But the first LEGO automatic binding brick is their most important product. The products have undergone extensive development over the years – but the foundation remains the traditional LEGO brick. The Lego Group began in the carpentry workshop of Ole Kirk Christiansen, in Billund, Denmark in 1916.  In 1961, Lego wished to expand sales to North America, but did not have the logistical capabilities to do so. Lego made an arrangement allowing Samsonite to begin producing and selling Lego products in the United States and Canada.  On 7 June 1968, the first Legoland Park was opened in Billund. This theme park featured elaborate models of miniature towns built entirely from Lego bricks. The three acre (12,000 m²) park attracted 625,000 visitors in its first year alone. During the next 20 years, the park grew to more than eight......

Words: 1468 - Pages: 6