US 12,124,419 B2
Transforming data of strict schema structure database
Cheng Luo, Beijing (CN); Wen Wen Guo, Beijing (CN); Chu Yun Tong, Beijing (CN); Xiao Ming Hu, Beijing (CN); Miao Liu, Beijing (CN); and Yi Xin Song, BeiJing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Mar. 15, 2022, as Appl. No. 17/654,861.
Prior Publication US 2023/0297551 A1, Sep. 21, 2023
Int. Cl. G06F 16/21 (2019.01); G06F 16/215 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/213 (2019.01) [G06F 16/215 (2019.01); G06F 16/258 (2019.01)] 14 Claims
OG exemplary drawing
 
1. A system comprising:
a memory; and
a processor in communication with the memory, the processor being configured to perform processes comprising:
porting a data model into a strict schema system;
translating the data model into a transformation rule definition;
fitting the transformation rule definition to a transform action;
receiving strict schema data;
modifying the data model using a semantic rule to transform the strict schema data;
performing the transform action on the strict schema data based on the transformation rule definition to form rough data;
mapping, by a translator, an original data model to rules from a legacy application,
wherein the transformation rule is a logical statement that correlates a specific set of fields within the data model as relating to specific predetermined data points,
wherein the data points are defined by the strict schema system of the data model;
porting a filter requirement,
translating the data model and the filter requirement into a purify rule definition;
fitting the purify rule definition to a purify action;
filtering the rough data with the purify action based on the purify rule definition to form the loose schema data;
receiving an enrich requirement;
translating the filter requirement and the enrich requirement into an enrich rule definition;
fitting the enrich rule definition to an enrich action; and enriching the loose schema data with the enrich action based on the enrich rule definition to generate enriched data; and
executing, based on the mapping, filtering and enriching operations on the rough data to form loose schema data.