Question

User table contains the following attributes (dateOfBirth, race, gender, ...). We would like to generate a report in the following format.

Year Race All Male Female 2000 Asian 2000 1000 1000 2000 Hispanic 1000 500 500 2001 Asian 1500 700 800 2001 Hispanic 1300 400 900 ...

Total 5800 2600 3200

Ideally I would like to view different reports filtered by the above parameters (e.g. All Asian Male users in year 2000, All Asian users b/w years 2000-2005, All Hispanic community in 2001). What would be the best way to fetch this data, as I would like to avoid too many hits to the database to construct this data. What framework would be ideal in fetching / representing this data

Answer 1

You didn t give any details about the database back end you will be using, but in general the most efficient way to generate this information will be to process the data aggregation and filtering on the database side with the correct SQL and pass only the result set to your report generator. For the first example, which appears to be an aggregation of all of the data in the table, the database engine will have to sort and process all of the rows, but you ll be better off doing it there instead of the client. For queries involving subsets of the data, make sure you re indexed correctly for your queries.

Answer 2

友情链接