Intelligent approach to automated star-schema construction using a knowledge base

作者：

Highlights：

• Automatic star schema construction with the assistance of a knowledge-based model.

• NLP was collaborated with an ontology to extract measures for a star schema.

• Arithmetic coding and Probability function infer the missing column names.

• The ontology model assists to determine data type and size of an attribute in a table.

摘要

•Automatic star schema construction with the assistance of a knowledge-based model.•NLP was collaborated with an ontology to extract measures for a star schema.•Arithmetic coding and Probability function infer the missing column names.•The ontology model assists to determine data type and size of an attribute in a table.

论文关键词：Data warehouse,Intelligent system,Multidimensional model,Ontology,Semantic approach,Star schema

论文评审过程：Received 3 December 2019, Revised 30 March 2021, Accepted 14 May 2021, Available online 28 May 2021, Version of Record 3 June 2021.

论文官网地址：https://doi.org/10.1016/j.eswa.2021.115226