Replication Today There Are a Research Paper

Download this Research Paper in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Research Paper:

Each of the databases exports a view of its tables or objects that conforms to the shared data model, so that queries can be expressed using a common set of names for properties and relationships regardless of the database. The queries are then translated so that they are actually run against the local data using local names in the local query language; in the reverse direction results may be scaled, if needed, to take account of a change of measurement units or character codes (Applehans, et al. 2004). The technological test of these systems is to create programs with the intelligence necessary to divide queries into sub-queries to be interpreted and sent to local databases, and after that to merge all the results that come back. Great progress has been made in methods for setting up efficient dispersed query execution and the constituent that does this is frequently called an intermediary (Pacitti & Simon, 2000).With reference to the points previously listed:

Space. No extra space is needed locally, apart from a temporary cache for results retrieved from remote sites.

Updates. For the reason that a single replica of the data is worn with no local mirroring, all revisions to the remote component databases are instantly available. The presently update programs can carry on running, using the local names and storage arrangements and indexes. If in its place the data were to be transferred into some centralized format on a central computer, there would be a huge amount of work required to redraft the revise programs.

Autonomy. A multi-database architecture does not influence other clients of the constituent data resources who could, if they wanted, carry on using these precisely as before. In addition, we can take advantage of modified software tools by transferring requests to these from the intermediary. One benefits of this is that the local query language can gain benefits from the indexing systems that are locally obtainable.

Consequently there is no need to bring in large data sets from an array of servers. Nor is it essential to change all data for use with solitary physical storage architecture. On the other hand, additional effort is required to attain a mapping from the constituent databases onto the conceptual replica. The appropriateness of a coalesce multi-database approach for incorporating biological databases is backed by Leonard, (2007) and also projected by Aubrey & . Cohen (1996).

An Example Multi-Database System

In our current work, we are using the P/FDM database management system (Angoss Software, 2006), which is based on a powerful shared Functional Data Model (FDM; Shipman, 1981), to provide access to data held in different physical formats and at different sites. The FDM and its query language, Daplex (similar to OQL), arose from the MULTIBASE project (Gray, et al. 2005) which was an early project in integrating distributed heterogeneous database systems. Another feature of FDM is that both stored and derived data are created in a consistent way, through purpose (therefore the name useful data model). This suppleness allows us to obtain data during calls to remote databases.

Our main use of this database has been to support three-dimensional structural analysis and protein modeling (Sandler, 1994), and we have extended our initial general protein structure database to enable specialized techniques to be developed for modeling antibodies (Applehans, et. al, 2004). A sturdy semantic data mold like the FDM offers data independence, and we have tested more than a few alternative physical storage configurations, as well as hash files and relational tables (Gray & Watson, 1998).

Because this model uses object identifiers it is also potentially useful for federated access to the newer object databases that use object storage techniques (Kemme & Alonso, 2000) and with hybrid Object-Relational databases. These latter have the advantage of storing many special data types such as images and sound, possibly in huge volumes, which can be cross referenced from the usual relational tables of numerical and character data (Sandler, 1994).

FIG. 1.2: A Daplex query may be interpreted into a prolog query to contact data held locally or SRS code to gain right of entry data at EBI. However, some Daplex Queries will need both local and remote data and so will be interpreted into a Combination of Prolog and SRS code.

Our sample federated structure (Applehans, et. al, 2004) enters biological databanks stored at the European Bioinformatics Institute (EBI). These databanks contain formatted flat files, and a classification called the sequence retrieval system (SRS) retains cross-references between connected entries in dissimilar databanks held as directories in different tables. SRS also gives a command line crossing point that provides support for simple data selection queries. Our prototype system uses a description of the EBI databanks that maps these onto entities, relationships and attributes in an FDM schema. Queries submitted by the user are analyzed and partitioned automatically into parts that refer to data held locally and to data held at the EBI. Code generators construct data access requests to retrieve those data values from the local databases, and SRS code is produced and sent to the EBI for execution. This process is illustrated in Fig. 1.1 shows in detail the steps in processing a query that relates structural data in a local antibody database and data held at the EBI. Our P/FDM system is mainly implemented in the logic language Prolog, and query analysis and code generation is executed easily using Prolog's powerful pattern matching abilities. The particulars of this are, of course, hidden from the end user, who uses the Daplex language or a graphical interface that produces it without human intervention.

Tight and Loose Coupling

Early Computing Science research concentrated on distributed database systems that were tightly coupled together and accessible through an integrated data model known as a global schema. This meant that the integrated model was designed before designing the schemas of the individual databases, which were dependent on it. This was done partly for performance and partly in order to guarantee consistency of global updates of pieces of linked data. Thus this model has tended to be used within large companies such as banks, but not across autonomous sites (Gray & Watson, 1998). The execution made the shared data model very rigid, so that when local databases had to develop and add additional tables in dissimilar representations there was no way for this to be done and held in the shared model, and consequently the superfluous information was not accessible by the client computers. Certainly, some observers became very pessimistic about global schema integration, and rejected it as impractical and requiring too much strong central management (Aubrey & Cohen, 1996).

These pessimistic views began to change with the enormous success of the World Wide Web, which has shown that loosely coupled systems with only local updates can be remarkably flexible and effective. In this case users have been very willing to adjust their exported data to conform to a common syntax for marked up document (HTML) and a common protocol for exchanging messages (HTTP). The question is whether scientists with information to exchange will go one step further and use a shared data model, because the problem with WWW is that the information is now exchanged largely in natural language that computers can transport but not understand! Thus it is much harder for computers to process answers from autonomous web sites and be sure that the questions asked were interpreted consistently at each site.

At the pinnacle of the spectrum of choices for data integration we have tight-coupling alternatives that, as we have learnt, are too preventive. At the base we have an accord exclusively on syntax, which communicates approximately to the use of HTML. So as to get the preferred coalesce information infrastructure we believe, that we do not need the implementation of an ordinary hardware platform or vendor DBMS, but we do require a shared data model across contributing sites.


Angoss Software. (2006) KnowledgeSEEKER in Action: Case Studies. Toronto: Angoss Software International Limited.

Applehans, W., a. Globe, and G. Laugero. (2004) Managing Knowledge: A Practical Web-Based Approach. Reading, MA: Addison-Wesley.

Aubrey, a., and P.M. Cohen. (1996) Working Wisdom: Timeless Skills and Vanguard Strategies for Learning Organizations. San Francisco: Jossey-Bass.

Gray, J. Helland, P. O'Neil, P. And D. Shasha, (2005) the dangers of replication and a solution, Proc. ACM SIGMOD Conference, pages 173-182.

Gray, P., and H. Watson. (1998) Decision Support in the Data Warehouse. Upper Saddle River, NJ: Prentice-Hall.

Kemme B. And Alonso, G. (2000) a new approach to developing and implementing eager database replication protocols, ACM Trans. Database Systems.

Pacitti E. And Simon, E. (2000) Update propagation strategies to improve freshness in lazy master replicated databases, VLDB Journal,…[continue]

Cite This Research Paper:

"Replication Today There Are A" (2011, March 28) Retrieved November 28, 2016, from

"Replication Today There Are A" 28 March 2011. Web.28 November. 2016. <>

"Replication Today There Are A", 28 March 2011, Accessed.28 November. 2016,

Other Documents Pertaining To This Topic

  • Lesbian Health Issues Living in a Heterosexual Society

    Lesbian Health Care Lesbian Health Issues in a Heterosexual Society The additional burdens placed on the lives of minorities as a result of social exclusion can lead to health disparities. Social exclusion theory has been used in previous research to investigate the health disparities that exist between socioeconomic classes and individuals of different ethnic backgrounds living in the United States, but it has not yet been applied to another important minority group:

  • E Manufacturing A New Link

    Ayers (2000, p. 4) describes a supply chain as "Life cycle processes supporting physical, information, financial, and knowledge flows for moving products and services from suppliers to end-users." A supply chain can be short, as in the case of a cottage industry, or quite long and complex as in the manufacture, distribution, and sales of automobiles. In fact, the automobile supply chain has its origin in the mining of the

  • Application of a Pedagogic Model to the Teaching of Technology to...

    Pedagogic Model to the Teaching of Technology to Special Education Students Almost thirty years ago, the American federal government passed an act mandating the availability of a free and appropriate public education for all handicapped children. In 1990, this act was updated and reformed as the Individuals with Disabilities Education Act, which itself was reformed in 1997. At each step, the goal was to make education more equitable and more

  • Mitochondrial Diseases a Gene Is Basically a

    Mitochondrial Diseases A gene is basically a one dimension sequence of nucleotides that signals for the production of a protein. (Reynaud, 2010) The protein itself is merely a sequence of amino acids arranged in a specific manner. The sequence of the gene is linear and so is the sequence of the protein. DNA, which is a common term heard now and then is merely a collective term for all the genes

  • Is a Bachelor s Degree Worthwhile

    Value of a BA Degree The Value of BA Degrees Would you say this statement is "True" or "False"? Too many people are going to college these days. Many experts in business say that the statement is true. People once thought that college degrees were the most important advantage that people could attain through their own efforts (Ruiz 2011). But the situation is changing. A look at employees and entrepreneurs in

  • Coca Cola Supply Chain Management A Coca Cola Supply

    Coca-Cola Supply Chain Management-A Coca cola supply chain management The first section of this paper touches on the Coca-Cola Company's historical background detailing the time of its inception and the brains that were behind its formation and growth. This section also touches on the advertisements that have since been used from its inception. This section finally illuminates its mission statement. The second section talks about the challenges that Coca-cola has faced. These challenges

  • Cloning Today Man Has Progressed

    "Animals that are experiencing dwindling numbers could be cloned to prevent their extinction. Taiwanese scientists claimed to have made five clones of an endangered pig to save this species" (Anonymous). While some say man should not play God there are others like Edmund Erde who disagree and say that "playing God" is a phrase that is "muddle-headed" and "nonsensical" and should be deserted (Edmund Erde, p.594). For those who

Read Full Research Paper
Copyright 2016 . All Rights Reserved