Discuss the undo and redo techniques of recovery

Assignment Help Computer Engineering

Reference no: EM133508400

Discussion Post

Part I

Question 1. Describe what a database is?

Question 2. Discuss the main characteristics of the database approach and how it differs from traditional file systems. Discuss the differences between database systems and information retrieval.

Part II

Question: Discuss the mechanism of attribute/relationship inheritance. Why is it useful? Discuss the two main types of constraints on specializations and generalizations. A minimum of 1 outside reference is required along with APA formatting. (LO1) (LO3)

Part III

Question 1. Discuss some types of queries for which renaming of attributes is necessary to specify the query unambiguously.

Question 2. Discuss the various types of inner join operations. Why is theta join required?

Part IV

Question: What is ODBC? How is it related to SQL/CLI? List the three main approaches to database programming. What are the advantages and disadvantages of each approach? A minimum of 1 outside reference is required, along with APA formatting. (LO2).

Part V

Question: What is the difference between primary and secondary storage? Discuss the mechanism used to read data from or write data to the disk. What is the difference between static and dynamic files?

Part VI

Question 1. Discuss the different types of parameters that are used in cost functions. Where is this information kept?

Question 2. Discuss the cost components for a function used to estimate query execution cost. Which cost components are used most often as the basis for cost functions?

Part VII

Question 1. Discuss the UNDO and REDO techniques of recovery. What are the advantages and disadvantages of this technique?

Question 2. Discuss how disaster recovery from catastrophic failures is handled.

Part VIII

Question 1. Discuss each term: database authorization, access control, data encryption, privileged (system) account, database audits, and audit trail.

Question 2. Discuss the types of privilege. What is meant by revoking a privilege?

Reference no: EM133508400

Questions Cloud

Detect the endocrine glands on models : Detect the endocrine glands on models and charts and their histological properties in the microscope

What are the two primary types of financial statements : What are the two primary types of financial statements? and what are the different between the two? are the two primary types of financial statements?

Which are ergonomic hazard identification, ergonomic hazard : which are ergonomic hazard identification, ergonomic hazard evaluation and ergonomic control implementation. Explain in detail each step with suitable examples

Violent media and subsequent aggressive behavior : In today's society, there is a lot of interest in understanding the relationship between exposure to violent media and subsequent aggressive behavior.

Discuss the undo and redo techniques of recovery : Discuss the UNDO and REDO techniques of recovery. What are the advantages of this technique? Discuss how disaster recovery from catastrophic failure is handled.

Discuss what is meant by observational learning : Discuss what is meant by observational learning. Describe how it differs from conditioning, but also how conditioning principles may be part of observational

What should firms do to ensure they do not experience : What should firms do to ensure they do not experience such a problem when using an acquisition strategy? do you think it will result in increased strategic

Did you intervene or were you a bystander : Have you ever witnessed an emergency situation? Did you intervene or were you a bystander?

How can you make sure that the objectives set are specific : How can you make sure that the objectives set are specific, measurable, and time-bound? How does risk management play into business performance?

User Account

All Pages