Automated Multidimensional Schema Conversion
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current business intelligence applications require significant human effort to convert, merge, or create information providers with different structures, as they need to analyze and transform data from various sources, which is time-consuming and prone to errors.
Innovation Solution
An automated method for converting, merging, and creating information providers, which involves metadata processing to classify and reorganize data elements, creating data transformation processes, and validating the target object structure, allowing for a single-click, fully automated conversion with minimal user intervention.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual conversion of information providers is performed, then data integrity can be verified, but human effort and time consumption increase significantly
Solution Approach 1:
The system performs automatic conversion of information providers by analyzing metadata and executing transformation processes without requiring manual intervention. The conversion process self-manages the analysis of source and target structures, generation of transformation rules, and execution of data mapping, thereby reducing human effort while maintaining conversion accuracy.
Solution Approach 2:
The patent replaces manual mechanical operations with automated computational processes. The system uses metadata analysis algorithms, structured transformation rules, and automated data mapping mechanisms to substitute for manual data conversion tasks, thereby reducing time consumption while preserving data integrity through systematic processing.
2Productivity
If automated conversion process is implemented, then conversion speed increases, but system complexity increases
Solution Approach 1:
The conversion process is segmented into distinct phases: metadata analysis, transformation rule generation, and data transformation execution. Each phase handles specific aspects of the conversion task independently, making the overall complex process manageable and maintainable through modular organization of conversion operations.
Solution Approach 2:
The system introduces metadata as an intermediary layer between source and target information providers. Metadata serves as a mediator that describes the structure and characteristics of data elements, enabling the system to automatically analyze differences and generate appropriate transformation rules without direct complex processing of the actual data.
3Manufacturing precision
If detailed analysis of data structures is performed, then conversion accuracy improves, but processing time increases
Solution Approach 1:
The system performs preliminary analysis of source and target information provider structures by examining metadata before actual data conversion begins. This preliminary metadata analysis identifies structural differences and generates transformation rules in advance, enabling accurate conversion without requiring time-consuming detailed analysis during the actual data processing phase.
Data Source
AI summary
In various embodiments, a system receives a multidimensional schema entity of a first type and converts the multidimensional schema entity to a second type. The system receives user input and converts the multidimensional schema entity to the second type based on the input received from the user. In various embodiments, the system creates multidimensional schema entities automatically. In various embodiments, a method for converting multidimensional schema entities from one or more types to one or more other types is described. In various embodiments, a multidimensional schema entity is created automatically based on input from two other multidimensional schema entities. In various embodiments, two multidimensional schema entities are merged in one multidimensional schema entity. In various embodiments, multidimensional schema entities are used to generate a report. Queries extract data from the multidimensional schema entities and load it in the report. The report is presented on a graphical user interface.