Traditional Culture Encyclopedia - Traditional customs - What is bw star structure and what is the difference from traditional star structure?

What is bw star structure and what is the difference from traditional star structure?

BW star structure: a fact table in the middle is connected with a dimension table, in which the main data sid is stored and connected to the attribute table, text table and hierarchy table of the main data through the main data sid. Difference: the traditional star structure dimension table stores the dimension key attribute, while the dimension table in BW star structure stores the sid of the main data, which is connected to the attribute, text and hierarchy of the main data through the sid. Through the sid, multi-language support can be realized, and the main data can be enjoyed.