Estimating Report Generation Time in Client-Server Applications
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The increasing complexity and utilization of databases lead to prolonged report generation times, impacting user productivity due to the unpredictability and inefficiency in generating reports.
Innovation Solution
A method and system that estimate report generation time by calculating the complexity of the report and database utilization, allowing users to select an appropriate delivery mode based on the estimated time, using a reporting server and client interaction to provide accurate time estimates and suggest delivery options.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database complexity and utilization increase to support more users and complex reports, then the database application's capability to handle diverse reporting needs improves, but report generation time increases and becomes unpredictable
Solution Approach 1:
The system performs preliminary analysis of report parameters and database conditions before actual report generation to calculate and display an estimated generation time to the user. This allows users to make informed decisions about report parameters or timing, preventing unnecessary long wait times while maintaining the system's ability to handle complex reports when needed.
2Loss of information
If report complexity increases to meet user needs, then the information value of reports improves, but report generation time increases
Solution Approach 1:
The system calculates estimated report generation time by analyzing report parameters (such as query complexity, data volume, and processing requirements) before report generation. This preliminary assessment allows users to understand the time cost of complex reports and adjust their requirements or timing accordingly, maintaining information quality while managing time expectations.
3Productivity
If database utilization increases to serve more users simultaneously, then system throughput improves, but report generation time becomes more variable and longer
Solution Approach 1:
The system provides feedback to users by displaying estimated report generation times based on current database utilization and report parameters. This feedback mechanism allows users to adjust their report requests or timing to avoid periods of high system load, thereby reducing variability in actual generation times while maintaining high system throughput for multiple users.
Data Source
AI summary
A method, system and computer program product for estimating report generation time are disclosed. The method includes receiving an indication that a user is requesting a report from a database application. An estimated amount of time for the database application to generate the report is calculated, and the estimated amount of time is displayed to the user.