Layered Query Application Architecture for Database Scalability
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database access applications are inflexible, difficult to maintain, and not scalable for concurrent users, lacking user customization and data query optimization, and are often limited to specific hardware and software environments.
Innovation Solution
A system and method that includes a query application with a client layer, presentation layer, and database access layer, interfaced by an application server and Internet-type server, allowing for customizable data access and scalability, using a J2EE server to manage user interactions and database queries, and enabling configuration through an Options Configuration file.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a complex conglomeration of data structures and routines is used to access databases, then data access functionality is achieved, but the application becomes difficult to maintain and enhance
Solution Approach 1:
The patent divides the database access application into separate layers: a presentation layer for user interface, a business logic layer for processing, and a data access layer for database operations. This segmentation allows each layer to be maintained and enhanced independently, reducing overall complexity while preserving reliable data access functionality.
2Device complexity
If a one size fits all application design is used, then implementation is simplified, but user customization and dynamic control are prevented
Solution Approach 1:
The patent implements dynamic configuration capabilities where the application can be customized per user, per user group, or per system basis. The system allows dynamic control over data access methods and enables users to configure their own query parameters and access preferences, transforming a static one-size-fits-all application into a dynamic, adaptable system.
3Device complexity
If fixed data access methods are used, then implementation is straightforward, but control over data access methods and performance expansion is prevented
Solution Approach 1:
The patent enables dynamic modification of data access parameters and methods. Users can configure query parameters, access methods, and performance optimization settings according to their specific needs. The system supports parameter changes in data access methods, allowing for performance expansion and optimization without requiring complex implementation changes.
4Reliability
If proprietary server designs are required, then application compatibility is ensured, but scalability to large numbers of concurrent users is limited
Solution Approach 1:
The patent designs the application with universal interfaces and standardized protocols that work across multiple server platforms and hardware environments. The layered architecture uses standard database connectivity protocols, allowing the same application to scale to large numbers of concurrent users on different server designs without requiring proprietary server-specific modifications.
Data Source
AI summary
A system and method to retrieve information is disclosed. The system may include a processor to run a query application to retrieve selected information from one or more databases. The query application may include a client layer and a presentation layer to interface with the client layer. A database access layer may be provided and an interface layer may be provided to interface between the presentation layer and the database access layer.