The invention relates to a shared dimension optimization method for a
data warehouse model. The method comprises the following steps of: collecting a
business data table, generating Chinese description of a field, disassembling and counting the Chinese description by adopting a text
analysis method, tagging part-of-speech and generating an analysis result. And carrying out optimization
processing on an analysis result, filtering part-of-speech irrelevant to the shared dimension, and screening out time period part-of-speech and measurement part-of-speech. And carrying out
statistical analysis on an optimized analysis result, and identifying dimensions with common characteristics. And
processing the identified common dimension based on
business logic to generate a shared dimension. Through the generated shared dimension, the structure of the number bin model is adjusted, the structural design of the
dimension table and the
fact table is perfected, and the
data query efficiency is optimized. According to the method, the
workload of manual investigation and
data analysis is reduced, the efficiency of dimension identification and sharing is improved through
automatic processing, the period of
data sorting is shortened, the labor cost is reduced, and the method adapts to
data processing requirements of complex business scenes.