RDBMS - what is aggregation, decomposition, generalization in rdbms

GeekInterview.com > Tech FAQs > RDBMS

Go To First | Previous Question | Next Question

RDBMS | Question 16 of 18

what is aggregation, decomposition, generalization in rdbms

Total Answers and Comments: 1

Last Update: July 13, 2007 Asked by: anupriya

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 13, 2007 04:25:09

Gajanan K

RE: what is aggregation, decomposition, generalization...

Aggregation: Selecting the data in group of records is called aggregation.

There are five aggregate system functions they are viz. Sum, Min, Max, Avg, Count. They all have their own purpose Decomposition: Selecting all data without
any grouping and aggregate functions is called Decomposition. The data is selected, as it is present in the table.

Generalization: while generalization seems to be simplification of data, i.e. to bring the data from Un-normalized form to normalized form.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

What is Data Generalization

Data Generalization is the process of creating successive layers of summary data in an evaluational database. It is a process of zooming out to get a broader view of a problem, trend or situation. It is also known as rolling-up data. There are millions and millions of data stored in the database a

What is Data Aggregation

In Data Aggregation, value is derived from the aggregation of two or more contributing data characteristics.   Aggregation can be made from different data occurrences within the same data subject, business transactions and a de-normalized database and between the

What is Aggregation

In the broadest sense of the word, aggregation means collecting and combining of data horizontally, vertically and chronologically and then expressed in summary form to be used for statistical analysis. In the more technical sense, aggregation is a special kind association that specified a part of w

RDBMS FAQs Related

—