Web Application UI Framework Using Database Tables for Reusable Components

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current web application user interfaces lack standardization and reusability, as server-side scripting languages like JSP, ASP, and BSP do not provide a standardized way to treat user interface layout and specialized tags, resulting in solutions that are application-specific and difficult to customize or personalize.

Innovation Solution

A framework that generates user interfaces for web applications by using a set of database tables to define screen components, layout, configuration, and event handling, allowing for the creation of reusable screen patterns and enabling customization and personalization through a repository of components and data storage for rendering information, which can generate HTML code without requiring detailed knowledge of underlying scripting languages.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If server side scripting languages (JSP, ASP, BSP) are used to create dynamic web pages, then dynamic screen content can be achieved, but user interface layout lacks standardization and reusability

Engineering Contradiction:
Improvedynamic screen content capabilityVSAvoiduser interface layout complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the user interface into reusable components stored in database tables. Each component (buttons, text fields, tables) is defined separately with its own properties, allowing independent modification and reuse across multiple web pages while maintaining dynamic content capabilities through server-side scripting integration.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent creates universal UI components that can be used across different web pages and applications. By storing component definitions in database tables with standardized structures, the same component can be instantiated multiple times with different configurations, achieving both standardization and adaptability.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If application-specific solutions are created for each web page, then specific functional requirements are met, but maintenance cost increases and code reusability decreases

Engineering Contradiction:
Improvefunctional requirement fulfillmentVSAvoidmaintenance cost
Core Design Contradiction:
Adaptability or versatilityVSEase of manufacture

Solution Approach 1:

The patent enables copying of UI component definitions from database tables to create identical or modified instances across multiple web pages. Instead of rewriting the same UI elements for each page, developers can reference existing component definitions, reducing maintenance effort and ensuring consistency across the application.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The patent creates universal UI components that serve multiple functions across different web pages. A single component definition in the database can be reused in various contexts with different configurations, reducing the overall amount of code to maintain while fulfilling diverse functional requirements.

Inventive Principle:
Principle #6Universality (Multi-functionality)

3Extent of automation

If detailed knowledge of scripting languages is required to create web page layouts, then precise control over web page generation is achieved, but ease of operation decreases

Engineering Contradiction:
Improveweb page generation controlVSAvoidlayout creation difficulty
Core Design Contradiction:
Extent of automationVSEase of operation

Solution Approach 1:

The patent introduces database tables as an intermediary layer between the user interface designer and the scripting language implementation. Users can define and configure UI components through standardized database schemas without needing to write scripting code directly. The framework automatically generates the necessary HTML and integrates with server-side scripting, providing precise control while simplifying operation.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS7689923B2Framework for creating user interfaces for web application programs
Publication Date: 2010.03.30 SAP SE
  • US7689923B2 patent drawing
  • US7689923B2 patent drawing
  • US7689923B2 patent drawing

AI summary

A framework is disclosed for generating user interfaces for application programs, such as web application programs. The framework may provide a first set of database tables to define screens including tables that describe components, screen layout, component configuration, application model assignment, and/or event handling. The framework may further provide a first set of transactions for maintaining the first set of database tables and hypertext transfer protocol (HTTP) response means for generating the web pages by accessing the first set of database tables.