Web Service Platform Stored Procedure for Data Integration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing web service platforms lack the ability to easily integrate and combine data from multiple disparate services, limiting the development of new web-based applications and requiring extensive coding and network data transmission.
Innovation Solution
A web service platform with keyword service APIs and a framework that supports service discovery, stored procedures, and object-based programming, allowing for seamless integration and combination of results from multiple services, reducing data transmission and coding complexity.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If web services from disparate sources are integrated manually, then data from multiple sources can be combined, but extensive coding and network data transmission are required
Solution Approach 1:
The patent introduces a stored procedure as an intermediary component that mediates between multiple web services and the application. The stored procedure receives service identifiers and parameters, automatically retrieves data from the specified services, combines the results, and returns the combined data to the application. This eliminates the need for applications to directly code complex integration logic and reduces network transmission overhead by performing combinations server-side.
Solution Approach 2:
The stored procedure implements a universal interface for combining results from any number of web services. By accepting service identifiers and parameters as input, the same stored procedure can handle integration of different services (e.g., weather services, news services, stock services) without requiring separate integration code for each service combination, thus providing multi-functional capability.
2Adaptability or versatility
If services are added to the web service platform, then service functionality increases, but integration and updates require extensive coding efforts
Solution Approach 1:
The platform enables self-service for service integration through the stored procedure mechanism. Service providers can add new services by simply registering service identifiers and basic configuration information in the database, without requiring complex integration coding. The stored procedure automatically handles the service invocation, result retrieval, and data combination, allowing services to be added and updated through simple configuration rather than extensive programming.
3Productivity
If direct service integration is performed without a framework, then service results can be obtained, but network data transmission and coding efforts increase
Solution Approach 1:
The stored procedure merges multiple service result sets into a single combined result before returning to the application. By performing the combination operation server-side within the stored procedure, the patent reduces the amount of data that needs to be transmitted over the network compared to returning individual service results separately. It also consolidates multiple service calls and result processing into a single database operation, reducing overall processing time.
Data Source
AI summary
The present web service platform includes a set of application program interfaces (APIs) and a framework for adding services that correspond to the APIs. The web service platform may also support a stored procedure (sproc) that allows combining results from two or more services before transmitting results to an application. The services relate to keyword technologies.