Explore BrainMass
Share

Explore BrainMass

    DB2, SQL Server, MySQL, Oracle, or Sybase

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Use the Internet or computer magazines to investigate one of the following DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase. Then prepare a report that explains how the DBMS handles tow of the following distributed database functions: deadlock, fragmentation, replication, the data dictionary or log, and distributed queries.

    © BrainMass Inc. brainmass.com October 9, 2019, 5:00 pm ad1c9bdddf
    https://brainmass.com/computer-science/data-clustering/db2-sql-server-mysql-oracle-or-sybase-45774

    Solution Preview

    DB: Oracle

    1. Fragmentation: Please see

    http://www.embarcadero.com/resources/tech_papers/managingspace.pdf

    2. Replication, please see the attached documents. and also:
    http://www.nyoug.org/200212baumgartel.pdf

    3. Deadlock detection in Oracle: see the attached document.

    4. Distributed queries:

    Distributed Queries

    A ...

    Solution Summary

    Assess one of the following DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase

    $2.19