answersLogoWhite

0


Best Answer

Well difference between maintaining and generating fields is simple. Simple table

Qty Bought Price Total paid (Calculated field)

1 £3 £3

2 £4 £8

Total is calculated field so when we maintain it we use a lilttle bit of memory to save the value and it will be always there for us so anytime we need it we just look it up. This however causes some problems if say the price will change we will need to update the field or else the data would be wrong. So in a large database if you have a lot of these calculated fields besides using a lot of memory you will need to update them frequently.

If however we generate a calculted field to find out total paid it may take a little longer time for the calcultaion but it will be updated and the value will be correct. In large databases I think generating calculated fields is a much better way to get data as it will save memory and time updating them.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Maintaining versus generating calculated fields in rdbms?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the difference between the first and second phases of the prewritingprocessO A. Outlining versus writingB. Brainstorming versus editingO C. Organizing versus writingD. Generating versus organizing?

What is the difference between the first and second phases of the prewriting process? O A. Outlining versus writing B. Brainstorming versus editing O C. Organizing versus writing D. Generating versus organizing


Is the efficiency of a machine calculated by the ratio or by the product?

efficiency is a product of the input versus the output


Define row crop farming?

Row crop farming is the production of plants is fields versus greenhouse production.


In calculating GDP versus GNP what is now not counted?

GDP is calculated for a specific period of time, usually a year or a quarter of a year. No listing for "What is not counted in calculating GDP versus GNP".


What is the difference between the first and second phases of the prewriting process?

Generating versus organizingPrewriting is the first stage of the writing process, typically followed by drafting. The writer often looks up definitions, synonyms and finds ways that different.


What is the lunar month during pregnancy?

A lunar month is a month calculated on the moon. It is a 28 day month versus the normal monthly variable.


What is the different between the first and second phases of the prewriting process?

Generating versus organizingPrewriting is the first stage of the writing process, typically followed by drafting. The writer often looks up definitions, synonyms and finds ways that different.


How chlorine is calculated by using chlorotex reagent?

Most of the Chlorotex bottle's has chart on their label, which shows the color appeared by mixing sample and chlorotex, versus concentration.


What is the differences between the first and second phases of the prewriting process?

Generating versus organizingPrewriting is the first stage of the writing process, typically followed by drafting. The writer often looks up definitions, synonyms and finds ways that different.


What are the benefits of having synthetic grass versus having real grass?

The benefits of synthetic grass is that it doesn't need any lawn care besides maintaining it from falling apart and it doesn't need to be mowed.


What is the future tense of versus?

The word versus is a preposition; therefore, it doesn't have tense.


What does the name Versus mean?

To me 'Versus' means 'against' as in 'Portsmouth versus Manchester United'.