Patent ID: 7296232

Claim:
A method for processing data stored in a database associated with a server, said method comprising: displaying a calendar user interface to a user, said calendar user interface defining a plurality of time periods, at least one of said time periods having data stored in the database corresponding thereto; receiving from the user at least a first selection and a second selection of the plurality of time periods, said first selection comprising individually selected starting and ending times, said second selection comprising individually selected starting and ending times, wherein said first selection and said second selection are non-contiguous time periods; modifying the selections as a function of the cumulative time; enabling further selections if the cumulative time of the selected time periods does not exceed a maximum amount of time based on the server performance; disabling further selections if the cumulative time of the selected time periods exceeds a maximum amount of time based on the server performance; updating the displayed calendar user interface in response to the received selections to indicate the selected time periods; generating a query based on the selected time periods in response to a user command; and submitting the query to the database to retrieve non-calendar data associated with the selected time periods from the database for processing, wherein the database is aggregated into tables based on the selected time periods and wherein the generated query is submitted to the corresponding aggregated table of the database based on the selected time periods.