Oracle traditional warehouse inventory

God, you have to copy what others can understand. Things processing focuses on daily business applications, while data warehouse focuses on data analysis and statistics.

For example, banks need both. Transaction processing is mainly used to record the details of savings business, how much your interest is, how long your loan period is, and so on. The data warehouse is used to analyze and calculate whether your loan is reasonable, whether your statement is true, and calculate your non-performing loan ratio. Of course, I can't tell you some core statistics, so you should probably understand the concepts.

The two sets of templates are different from the foreground to the background. From the bottom of the data, the physical transaction data block is small, the uid and pid are small, and the reading and writing speed is emphasized. Redundancy is small, but data warehouse is the opposite. Large data block, large uid and pid, emphasis on analysis and research, and great redundancy.

There are a lot of professional knowledge, I'm afraid it's hard for you to understand, so I won't explain it here.