Database Content Publisher for Dynamic Service Exposure
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing gateway tools for accessing business data require pre-programming or development of new modules to expose additional business objects or data, limiting flexibility and requiring additional programming efforts.
Innovation Solution
A system and method that automatically generates a data structure model based on identified database tables and relationships during business transactions, allowing business data to be exposed as a service without additional programming, using OData protocol and integrating a publisher with business transaction and database relationship analyzers.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If pre-programmed modules or new modules are developed to expose additional business objects or data, then data access capability is enhanced, but device complexity and programming effort increase
Solution Approach 1:
The system enables self-service by automatically generating data structure models and exposing business data as services without requiring manual pre-programming. The analyzer components automatically identify database tables and relationships, generate corresponding data models, and publish them via OData services, allowing the system to serve itself rather than requiring external programming intervention
Solution Approach 2:
The system performs preliminary action by pre-configuring the automatic generation mechanism and security policies before data access requests arrive. The data structure model generation and service publication processes are prepared in advance through automated analysis of database schemas and security configurations, eliminating the need for reactive module development
2Adaptability or versatility
If pre-programmed modules are used to access business data, then data security is maintained through controlled access, but flexibility and adaptability are reduced
Solution Approach 1:
The system implements dynamics by making the data access architecture adaptive rather than static. Instead of fixed pre-programmed modules with hard-coded access rules, the system dynamically generates data structure models and publishes services based on automated analysis of database schemas and security configurations, allowing the architecture to adapt to changing business requirements while maintaining security through policy-based access control
3Adaptability or versatility
If manual module development is performed to expose additional data, then customized data access is achieved, but productivity and time efficiency are reduced
Solution Approach 1:
The system replaces the mechanical process of manual module development with an automated information processing system. Instead of developers manually analyzing database schemas, writing code, and configuring access controls, the system uses analyzer components to automatically extract database metadata, generate data structure models, and publish OData services, substituting human mechanical work with automated computational processes
Data Source
AI summary
Various embodiments of systems and methods to publish database content as service for accessing business data are described herein. In one aspect, a business transaction instantiated by a user is executed on an application server. During the execution, at least one database table of a plurality of database tables and at least one database relationship associated with the at least one database table are identified. In another aspect, a data structure model is automatically generated based on the identified at least one database table and at least one database relationship. In yet another aspect, data from the at least one database table is exposed to be consumed as a service based on the data structure model.