Client-Server Database Reporting System for Simultaneous Multi-View Analysis
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database reporting systems in OLAP environments are unable to accommodate multiple reports simultaneously, leading to inefficiencies in data access and storage, which restricts analysts' ability to view data from multiple viewpoints.
Innovation Solution
A client-server system with a report generation module on the server that accepts user criteria from a client computer, generates datasets, and displays reports, allowing for simultaneous generation and management of multiple reports by utilizing a hierarchical database structure and independent report management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple reports are generated and stored simultaneously, then analysts can view data from multiple viewpoints, but storage resources and system complexity increase
Solution Approach 1:
The patent segments the reporting system into multiple independent report instances, each with its own dataset and display context. This allows analysts to run multiple reports simultaneously without conflicts, as each report operates as an independent unit within the OLAP system.
Solution Approach 2:
The patent implements a nested structure where multiple report instances are contained within a single OLAP database connection. Each report nests its own data subset and configuration within the broader database context, allowing efficient sharing of underlying data sources while maintaining independent report functionality.
2Productivity
If multiple reports are run simultaneously, then reporting efficiency increases, but system performance and data access speed deteriorate
Solution Approach 1:
The patent performs preliminary actions by pre-defining data subsets and report configurations before execution. Reports are prepared with predetermined data filters and display parameters, allowing multiple reports to execute simultaneously without competing for real-time data processing resources.
Solution Approach 2:
The patent creates copies of data subsets for each report instance rather than requiring all reports to access the same data simultaneously. Each report receives its own data copy or view, eliminating contention for data access and allowing parallel report generation without performance degradation.
3Loss of information
If reports are made comprehensive and detailed, then analytical value increases, but report size and processing time increase
Solution Approach 1:
The patent applies local quality by allowing different reports to have different levels of detail and data granularity based on specific analytical needs. Each report can be customized with appropriate data depth and complexity for its intended purpose, rather than all reports being uniformly comprehensive or simplified.
Solution Approach 2:
The patent implements partial action by allowing users to retrieve only the specific data subsets needed for each report rather than loading entire datasets. This enables comprehensive analysis where required while avoiding unnecessary data processing and storage for reports that need only specific information.
Data Source
AI summary
A method of creating user-generated reports. The method begins with the step of receiving information related to consumer internet behavior. That information is then assembled into a database having facts and dimensions, in which the database resides on a server, the server being connected to a communications network. The method then provides a report generation system, including a report generation module resident on the server. The module generates a report, beginning with accepting user criteria for generating a report from a front end system resident on a client computer. It then generates from the database a dataset corresponding to the first report and forwards the same to the client computer, and it displays the report generated from the first dataset. The module then reiterates the report generation steps to generate a second report, the first report remaining resident on the client computer.