Data preparation using semantic roles
US12197505B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Dec 21, 2023 |
| Grant date | Jan 14, 2025 |
| Priority date | — |
| Expiry date | Dec 21, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/9577
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computer system obtains a data model that encodes a data source as a tree of logical tables. Each logical table includes respective data fields of the data source. For each data field in the logical tables, the system automatically assigns a semantic role to the data field based on a concept obtained from a concept graph, a data type of the data field, and data values of the data field. The system determines hierarchies between the data field and other data fields in the data source based on their respective semantic roles. The system validates the data field based on the assigned semantic role and the determined hierarchies. The system displays transformations to clean the data field based on the assigned semantic role. The system transforms data values for the data field according to a user input and updates the logical tables according to the transforming.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.