Decorator Framework for Updating Virtual Data Model Artefacts
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In complex database systems, especially for enterprise resource planning (ERP) systems, it is challenging to directly interact with databases due to technical issues in accessing them and the lack of significant semantic information, leading to complications in updating data artefacts that are reused across multiple virtual data model artefacts.
Innovation Solution
A decorator framework is introduced that allows metadata artefacts, containing semantic elements like annotations, to update data artefacts by specifying operations such as add, remove, or synchronize, enabling efficient modification of data artefacts within a virtual data model.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If developers work indirectly with database tables through virtual data models, then ease of operation is improved, but device complexity increases due to the need to manage multiple artefacts and their relationships
Solution Approach 1:
The patent introduces a decorator framework as an intermediary layer between developers and the virtual data model. This framework uses metadata artefacts with annotations to automatically update and synchronize data artefacts, reducing the manual complexity of managing virtual data models while maintaining ease of database interaction.
2Productivity
If data artefacts are reused across multiple virtual data model artefacts, then productivity is improved through code reusability, but difficulty of detecting and measuring increases when updates need to be propagated
Solution Approach 1:
The patent implements a feedback mechanism where metadata artefacts contain annotations that automatically detect and propagate updates to all data artefacts that reference them. The decorator framework monitors changes and triggers synchronization across the virtual data model, providing automatic feedback about update propagation without manual tracking.
Solution Approach 2:
The patent uses preliminary action by pre-defining metadata artefacts with annotations that specify how updates should be propagated. These metadata artefacts are prepared in advance to automatically handle synchronization when data artefacts change, eliminating the need for manual update tracking.
3Ease of operation
If semantic information is added to virtual data model artefacts, then ease of operation is improved for developers, but device complexity increases due to additional metadata management
Solution Approach 1:
The patent implements self-service by enabling metadata artefacts to automatically update themselves and other related artefacts through annotations. The decorator framework allows the system to manage its own metadata without requiring manual intervention, reducing the operational burden despite the increased semantic information.
Data Source
AI summary
Techniques and solutions are described for defining metadata artefacts and, using a framework, which can be referred to as a decorator framework, updating data artefacts. The data artefacts can be artefacts in a virtual data model, such as data artefacts representing views that can correspond to a view, or one or more tables, of a relational database system. A metadata artefact can include semantic elements, such as annotations, that are processable by the decorator framework in updating data artefacts. Annotations can specify an operation type, such as to include, remove, replace, or synchronize, for content a metadata artefact, where the operation will be carried out on data artefacts to which the metadata artefact is applied and which contain specified content. Multiple metadata artefacts can be applied to a given data artefact, and a given metadata artefact can be applied to multiple data artefacts.