Re: Should I use one or two tables for summary data?

On 02/06/17 19:58, Victor Porton wrote:
> J.O. Aho wrote:
>
>> On 02/06/17 16:51, Victor Porton wrote:

>> If you prompt want to keeps aggregated data, then keep it in a separate
>> table, don't forget to keep track of how you group the data if you have
>> more than one way to group it.

As mixing aggregated data with the actual data is bad, specially when the values in the columns has slightly different meaning.

It's far cleaner what the data is and also you will be able to have a table name which tells you the data is aggregated. Think about the next person who is poking in your database, when the structure is clear, less likely they will make a mistake.

-- 

 //Aho