Data Base week9_4 Extra class

26/03/2010

 

Transaction Management

Concurrency Control

 

HW Research

Compare the features of Oracle and SQL Server, under the headings below:

• Name three different programming interfaces that applications programmers can use to process data in each DBMS from external programs written in C++, Java, Visual Basic or other languages. 
  
• For each DBMS, identify and name one query tool supplied with the DBMS and name the language it uses.
• SQL Server and Oracle both provide similar data access tools. Consider an environment where both products are in use. What differences if any would we expect to see in physical database designs between the two products? How would this impact the data management role?
• For each DBMS, name a feature to support distributing read-only data and additionally to support distributing data for updating remotely.
• Describe THREE types of distributed update conflict problem that may occur, and one strategy used to manage this.
• For each DBMS, name two logging and archiving features available to support database recovery and/or audit.
• For each DBMS, describe what option(s) must be chosen to ensure log files are created.
• Describe what implementation strategies would be required to ensure no data is lost in the event of a media failure. Your answer should refer to backup, recovery, audit.
• Describe the options each DBMS has to support concurrent transaction processing. For each option, give the range of values available.
• From your answers to part(i), state the options you would choose for consistent processing in each database if you were required to implement ACID (atomic, consistent, isolated and durable) transactions. 
• Describe one consequence to the business of choosing options that fail to guarantee ACID transactions in a multi-user environment.