StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Distributed databases - Research Paper Example

Cite this document
Summary
Distributed and parallel processing is a well-organized way of enhancing performance of DBMSs (Data-Base Management Systems) and systems that…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.1% of users find it useful
Distributed databases
Read Text Preview

Extract of sample "Distributed databases"

Distributed Databases Introduction A distributed database (DDB) is a compilation of numerous, logically interconnected databases distributed through a computer system. Distributed and parallel processing is a well-organized way of enhancing performance of DBMSs (Data-Base Management Systems) and systems that control large volumes of data (Abuelyaman, 2008). The main concern of DBMS structure is the partitioning and allocation of the fundamental hypothesis partitioning techniques. This paper seeks to find a suitable distributed database that can fit two small retail stores.

A partitioning schemeThis paper recommends a scheme for vertical partitioning of a distributed database. Vertical partitioning involves creating of tables with fewer columns and utilizing additional tables to keep the outstanding columns. Normalization also comprises this partitioning of columns within tables, but vertical partitioning goes further than that and fragments columns even when normalized. Different physical storeroom might be applied to comprehend vertical fragmenting. Non relational databases initiated the idea of column based databases (Abuelyaman, 2008).

The rationale for choosing this partitioning scheme is that it is cost efficient more than other schemes. In addition, it fits the required distributed databases required for this work. In order to surpass the limitations of accessible partitioning algorithm; a fresh algorithm known as VPartition, is recommended that enhances the performance of the current algorithm. The algorithm comprises an enhanced vertical partitioning system where cost is computed in terms of time utilizing greedy technique (Poniatowski & Safari Tech Books Online, 2003).

This leads to improved data consignment as compared to earlier approach. The characteristics of VPartition that comprises a series such as [I, T, TI, w, p, r, D, C comm., C route, N] where I: counter initialized to 0, T: time, Ti: time at ith second is initialized to 0,w: weight of database, p: partition data, r: path function, D: subset of query, C comm.: cost of comm., C route: cost of path finding, N: no of servers (Poniatowski & Safari Tech Books Online, 2003). A Method for TimingRecommended timing system to manage sale, purchase and management of data is a time warp.

Time Warp system is a novel method for database concurrency management, varying from other kinds of systems in at least five respects (Jeffesron & Sowizral, 1999). First, it obeys an object-oriented strategy to database concept in which there are no prescribed distinctions between transaction u objects, system objects and Udata~ objects. Second, it uses neither abortion-and-retry nor locking to resolve right of entry conflicts. In its place, it employs a more influential synchronization instrument: broad rollback.

The third unique feature is that it is free of starvation and deadlock. Another distinction is that it is free of limitations on transaction type such as sequentiality, two-phase model, or pre-declaration of object items to be obtained. Lastly, it introduces the concept of the virtual time, a simulated time scope from which business timestamps are drafted (Jeffesron & Sowizral, 1999). The virtual instance of a transaction is never altered after it is allocated, and activities are guaranteed be dedicated strictly in virtual time sequence.

Location limitation is associated with geographical distances that are created when the business goes globally. However, this is catered for through distribution database. A distributed database is a distinct logical system that is distributed physically across systems in numerous locations that are linked by a data communications system.ReferencesAbuelyaman, S. E. (2008). An Optimized Scheme for Vertical Partitioning of a Distributed Database. IJCSNS International Journal of Computer Science and Network Security, VOL.8 No.1, Jeffesron D.R. and Sowizral H. A. (1999).

Fast Concurrent Simulation Using the Time Warp Mechanism, Part H: Global Control. Technical Report, Rand Corporation, Santa Monica,California Poniatowski, M., & Safari Tech Books Online. (2003). HP-UX 11i system administration handbook and toolkit. Upper Saddle River, N.J: Prentice Hall PTR.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Distributed databases Research Paper Example | Topics and Well Written Essays - 500 words”, n.d.)
Distributed databases Research Paper Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/information-technology/1630165-distributed-databases
(Distributed Databases Research Paper Example | Topics and Well Written Essays - 500 Words)
Distributed Databases Research Paper Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/information-technology/1630165-distributed-databases.
“Distributed Databases Research Paper Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/information-technology/1630165-distributed-databases.
  • Cited: 0 times

CHECK THESE SAMPLES OF Distributed databases

Client-Server Model, Risks to Data Integrity of Distributed Databases

From the paper "Client-Server Model, Risks to Data Integrity of distributed databases" it is clear that groupware means using shared resources to complete business tasks.... 2 a) Risks to Data Integrity of distributed databases “A distributed database is a database that is split over multiple hardware devices but managed by a central database controller” (Holmes n.... Some of the main advantages of using distributed databases in business include better control of resources and improved business performances....
6 Pages (1500 words) Assignment

Happy Homes Database System

Distributed Database Management System This database system connects a variety of databases in various regions over a network and operates in a way that the users are not aware of the distributed databases.... In the case of Happy Homes Ltd, the databases could be located in various regions and then have a central server that synchronizes the operations of the whole system.... Centralizing the data in one area reduces the system performance as compared to distributed system....
6 Pages (1500 words) Coursework

Interoperability and Middleware

Interoperability and Middleware (Author's name) (Institutional Affiliation) Interoperability and middleware are computing and programming systems that are used in resource and application management in the field of telecommunications and computer industry especially applied and used to develop required infrastructure in ICT (Pfaffenberger, 2003)....
4 Pages (1000 words) Research Paper

Global Catalog in Fast-Paced Financial Companys Sites

Active Directory Domain Services gives a platform where information is stored in distributed databases.... Information in these databases is easy to maintain and manage.... The forest creates platforms of authority by administrators and hence each worker will have limits to what they access within the databases.... Installation of AD DS will provide security of data, through the administrator login features, which only allow people with passwords to access the databases; hence, sensitive data is perfectly secure....
5 Pages (1250 words) Assignment

Emergent Technology : Web 3.0

What these processes entail is a fact related with the building up of the databases, accessibility of content through the use of non-browser programs and… There is also the relation of artificial intelligence technologies which are embedded within Web 3.... which have leveraged the overall look and feel of this emerging new technology....
4 Pages (1000 words) Essay

DISTRIBUTED SYSTEMS

The application successfully demonstrates the distributed database operations as it allows the user to not only view the records of both London and Scotland sites, but also to manipulate the data by inserting new or updating existing records.... However, still there is a lot of… Currently, this web application can only be executed through ASP....
12 Pages (3000 words) Essay

What Is a Distributed Database

Some of the main advantages of using distributed databases in business include better control of resources and improved business performances.... However, the risks associated with the data integrity of distributed databases include the accuracy of stored data and the risk of unauthorized access to spoil or alter the stored data.... This assignment "What Is a distributed Database" sheds some light on the word client-server that refers to an accepted model for networking of computer systems that makes use of server and client devices which are designed for their respective purposes....
6 Pages (1500 words) Assignment

Review of the Popular Association-Mining Algorithms - Apriori

To make it more feasible, the data sets from the distributed databases have to be merged which would prove very costly.... The paper "Review of the Popular Association-Mining Algorithms - Apriori" highlights that algorithm that can mine classification over large databases with great efficiency and scalability is naive Bayes.... It is a well-researched technique that aids in the discovery and derivation of interesting relationships between variables present in databases (Benoit 2002)....
10 Pages (2500 words) Case Study
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us