REST Webservice Configuration for No-Code Database Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Accessing information in complex databases requires complex computer coding tasks, making it difficult for non-specialist users and even specialist developers, and is time-consuming.
Innovation Solution
A method and system that presents a list of pre-existing events and actions to users, allowing them to select and call REST web services without coding, using a data model and repository to identify and configure the services for standard and non-standard database tables.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If complex coding methods are used to access database information, then the ability to interact with standard and non-standard tables is improved, but the ease of operation deteriorates as non-technical users cannot efficiently retrieve or update data
Solution Approach 1:
The patent introduces a REST webservice as an intermediary layer between users and the database. This mediator translates simple HTTP requests into complex database operations, allowing non-technical users to access both standard and non-standard tables without writing code. The webservice handles the complexity of database interactions while presenting a simple interface to users.
Solution Approach 2:
The system enables self-service database access by allowing users to directly call REST webservices with predefined actions. Users can independently retrieve, create, update, and delete records in both standard and non-standard tables by simply configuring service parameters rather than relying on technical experts to write custom scripts.
2Adaptability or versatility
If bespoke scripts are written by specialist developers to access database information, then the functionality to access complex databases is improved, but the loss of time increases due to the time-consuming nature of custom script development
Solution Approach 1:
The patent implements preliminary action by pre-configuring REST webservices with common database operations and actions. Instead of writing custom scripts for each access need, users can select from pre-defined services that already have the complex database logic prepared, significantly reducing the time required to access database information while maintaining the ability to handle both standard and non-standard tables.
3Ease of operation
If a user-friendly interface is provided for database access, then the ease of operation is improved, but the device complexity increases due to the need for configuration frameworks and service management
Solution Approach 1:
The patent applies segmentation by dividing the database access system into distinct modular components: a framework REST webservice layer, configurable action modules, and database interface layers. This segmentation allows the complex functionality to be broken down into manageable, independently configurable units that can be assembled through simple user selections rather than complex programming.
Data Source
AI summary
A computer-implemented method for calling a REST webservice for interacting with a database that stores database information, the method comprising: presenting to a user a list of pre-existing events, wherein each of the pre-existing events provides a trigger in response to activity in the database; receiving a user selection of one of the presented pre-existing events; receiving a user selection of one or more actions to be taken in response to the selected pre-existing event providing a trigger; and when the selected pre-existing event happens, calling a REST webservice by sending data to a receiver based on the selected pre-existing event and the one or more selected actions.