Explain the term- periodic recomputation, Database Management System

Assignment Help:

Explain the term- Periodic recomputation

Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes periodically without recomputing derived attributes after each base value is altered. Recomputation of all the derived attributes can be more proficient than incremental update since some derived attributes may depend on many base attributes and might be updated more than one time by an incremental approach.

Also, periodic recomputation is easier than explicit updates and less prone to bugs. While, if data set changes incrementally, some objects at a time, periodic recomputation is not practical since too many derived attributes may be recomputed when only a little are affected.

 


Related Discussions:- Explain the term- periodic recomputation

Describe all integrity constraints which are violated, Consider the two rel...

Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all

The transactions, The Transactions- A transaction is definite as the unit o...

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

What is equi join, What is equi join? Equi Join - It generates all th...

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

Implementation of association as an object, Implementation of association a...

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

Objectives-the structured query language, Objectives After reading this...

Objectives After reading this part, you should be able to: Modify, create, and delete database schema objects; Update database using SQL command; Retrieve data f

Doppler Effectabase Management , #question. Draw a picture of a moving sour...

#question. Draw a picture of a moving source and the waves surrounding it according to what you observed in this experiment. How does the spacing of the wave-fronts in front of the

OLAP CUBES, 1) Define a job scheduling strategy that will meet business req...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

In which form of relational database developer refers, In which form of rel...

In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.

Primary and foreign key, Primary Key The primary key is the candidate k...

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd