Spreadsheet API Wizard for Database Data Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Complex enterprise resource management systems with relational databases pose difficulties for less technical users to access and manage data due to their complexity, leading to the need for customized applications that are costly and inefficient.
Innovation Solution
A system that uses spreadsheet programs to dynamically interact with database APIs through builder and loader templates, allowing users to easily access and manage data without requiring extensive programming, by building API execution statements and providing a user-friendly interface for data entry and reporting.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If customized applications are created to access database information, then user-friendly access is achieved, but development cost and complexity increase
Solution Approach 1:
The patent introduces an intermediary layer between the user and the database API. This intermediary uses spreadsheet templates as a mediator to translate user-friendly spreadsheet operations into API calls, eliminating the need for users to directly interact with complex database structures while maintaining ease of access
Solution Approach 2:
The patent creates a simplified copy of the database interface through spreadsheet templates. Instead of requiring users to work with the actual complex database structure, the system provides a simplified spreadsheet representation that copies the essential data access functionality while being much easier to use
2Adaptability or versatility
If standard forms are used for database access, then data access is enabled, but usability and flexibility are reduced
Solution Approach 1:
The patent makes the interface dynamic by allowing users to customize spreadsheet templates according to their specific data access needs. The templates can be dynamically adjusted to match different database structures and requirements, providing both flexibility and ease of operation simultaneously
Solution Approach 2:
The patent creates a universal interface using spreadsheet templates that can access multiple different database structures through a single familiar platform. The same spreadsheet-based approach works for various database types and purposes, making the system universally applicable while maintaining ease of use
3Reliability
If complex database structures are accessed directly, then data integrity is maintained, but accessibility for less technical users is reduced
Solution Approach 1:
The patent uses spreadsheet templates as an intermediary that sits between the user and the database. This intermediary handles the complexity of maintaining data integrity through the database structure while presenting a simple, intuitive spreadsheet interface to users, thus maintaining both reliability and ease of operation
Data Source
AI summary
A system for interacting with a database has interface software for enabling communication between a spreadsheet program and a database API. The interface software dynamically reads API parameter information in order to allow a user to select the fields to be added to a loader template. Using the loader template, a user can access the database with the spreadsheet program in order to add, edit or retrieve data from the database.