System and method for extracting a star schema from tabular data for use in a multidimensional database environment
US11392558B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Jun 22, 2020 |
| Grant date | Jul 19, 2022 |
| Priority date | — |
| Expiry date | Jun 22, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The application describes a system and method for extracting a star schema from tabular data for use in a multidimensional database. The system can receive a tabular data including a plurality of columns, and determine a relationship between each pair of the plurality of columns by analyzing actual values in a plurality of rows for each pair of columns. Based on the determined relationships among the plurality of columns and a type of each column, the system can use a heuristic process to identify a plurality of cube elements from the plurality of columns to construct a star schema. A user interface can be provided to display potential problems of the star schema, and one or more alternative approaches for a user to select to extract a star schema from the tabular data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.