What should the dimension of the data warehouse establishment-CodePudding

The establishment of the specific steps is what kind of data warehouse, on baidu's all I'm a beginner, you need to complete a job, thank you for your great god answer patiently! There are several don't understand place
1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?

Passing by the great god answers

CodePudding user response:

1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
To solve the problem, we need to use the corresponding data,
Theme cube is a data source, as well as the dimension, calculating,

2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
Theme, to include all the detailed data, and after all the permutation and combination according to the different dimensions of summary data,
You want analysis of foreign capital, must want to have a rank, such as which company in amount is how much, this is the detail data, in addition, the total in how much money, this is the summary, and divisions, chemical industry, high-tech industry, foreign capital can divide the United States, Europe, Hong Kong and Taiwan, proportion, amount,

3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?
Dimensions on the whole, or to set up according to your specific problem, but there are some general dimensions, such as time dimension, as time changes, for example, you can analyze how much monthly into 2015, can generate a graph, in addition, still can next to a month of data each day, see the detail,

, I think you'd better buy the book to see, if only to generate a few charts, then use excel directly, if you want to do a system that best learn the data warehouse, especially the use of the tools, the development of data warehouse, or more complex,

CodePudding user response:

reference 1/f, don't want to grow up ah response:

1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
To solve the problem, we need to use the corresponding data,
Theme cube is a data source, as well as the dimension, calculating,

2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
Theme, to include all the detailed data, and after all the permutation and combination according to the different dimensions of summary data,
You want analysis of foreign capital, must want to have a rank, such as which company in amount is how much, this is the detail data, in addition, the total in how much money, this is the summary, and divisions, chemical industry, high-tech industry, foreign capital can divide the United States, Europe, Hong Kong and Taiwan, proportion, amount,

3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?
Dimensions on the whole, or to set up according to your specific problem, but there are some general dimensions, such as time dimension, as time changes, for example, you can analyze how much monthly into 2015, can generate a graph, in addition, still can next to a month of data each day, see the detail,

, I think you'd better buy the book to see, if only to generate a few charts, then use excel directly, if you want to do a system that best learn the data warehouse, especially the use of the tools, the development of data warehouse, or more complex,

is very useful! Thanks for patience to answer and I'm going to see some of this book, only superficial knowledge relationship is a mess now

CodePudding user response:

Recommend look at books, propagate the explanation is not enough

CodePudding user response:

Hello, what can books recommended, about the modeling and the subject

reference 1st floor yupeigu response:

1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
To solve the problem, we need to use the corresponding data,
Theme cube is a data source, as well as the dimension, calculating,

2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
Theme, to include all the detailed data, and after all the permutation and combination according to the different dimensions of summary data,
You want analysis of foreign capital, must want to have a rank, such as which company in amount is how much, this is the detail data, in addition, the total in how much money, this is the summary, and divisions, chemical industry, high-tech industry, foreign capital can divide the United States, Europe, Hong Kong and Taiwan, proportion, amount,

3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?
Dimensions on the whole, or to set up according to your specific problem, but there are some general dimensions, such as time dimension, as time changes, for example, you can analyze how much monthly into 2015, can generate a graph, in addition, still can next to a month of data each day, see the detail,

, I think you'd better buy the book to see, if only to generate a few charts, then use excel directly, if you want to do a system that best learn the data warehouse, especially the use of the tools, the development of data warehouse, or more complex,

reference 1st floor yupeigu response:

1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
To solve the problem, we need to use the corresponding data,
Theme cube is a data source, as well as the dimension, calculating,

2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
Theme, to include all the detailed data, and after all the permutation and combination according to the different dimensions of summary data,
You want analysis of foreign capital, must want to have a rank, such as which company in amount is how much, this is the detail data, in addition, the total in how much money, this is the summary, and divisions, chemical industry, high-tech industry, foreign capital can divide the United States, Europe, Hong Kong and Taiwan, proportion, amount,

3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?
Dimensions on the whole, or to set up according to your specific problem, but there are some general dimensions, such as time dimension, as time changes, for example, you can analyze how much monthly into 2015, can generate a graph, in addition, still can next to a month of data each day, see the detail,

, I think you'd better buy the book to see, if only to generate a few charts, then use excel directly, if you want to do a system that best learn the data warehouse, especially the use of the tools, the development of data warehouse, or more complex,

CodePudding user response:

Exzhangchenggong001

reference 4 floor response:

hello, what can books recommended, about the modeling and the subject
Quote: refer to 1st floor yupeigu response:

1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
To solve the problem, we need to use the corresponding data,
Theme cube is a data source, as well as the dimension, calculating,

2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
Theme, to include all the detailed data, and after all the permutation and combination according to the different dimensions of summary data,
You want analysis of foreign capital, must want to have a rank, such as which company in amount is how much, this is the detail data, in addition, the total in how much money, this is the summary, and divisions, chemical industry, high-tech industry, foreign capital can divide the United States, Europe, Hong Kong and Taiwan, proportion, amount,

3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?
Dimensions on the whole, or to set up according to your specific problem, but there are some general dimensions, such as time dimension, as time changes, for example, you can analyze how much monthly into 2015, can generate a graph, in addition, still can next to a month of data each day, see the detail,

, I think you'd better buy the book to see, if only to generate a few charts, then use excel directly, if you want to do a system that best learn the data warehouse, especially the use of the tools, the development of data warehouse, or more complex,

reference 1st floor yupeigu response:
1. According to the problem to be solved how to choose the theme of a data warehouse? What's the relationship between the subject and the problem to be solved? Contains or is equal to?
To solve the problem, we need to use the corresponding data,
Theme cube is a data source, as well as the dimension, calculating,

2. The subject was summarized in detail? Want to have more detailed problem? For example to analyze the 2015 foreign capital in suzhou industrial park is
Theme, to include all the detailed data, and after all the permutation and combination according to the different dimensions of summary data,
You want analysis of foreign capital, must want to have a rank, such as which company in amount is how much, this is the detail data, in addition, the total in how much money, this is the summary, and divisions, chemical industry, high-tech industry, foreign capital can divide the United States, Europe, Hong Kong and Taiwan, proportion, amount,

3. Only is established, aiming at the above problems? Each to solve a problem is a set of dimension table?
Dimensions on the whole, or to set up according to your specific problem, but there are some general dimensions, such as time dimension, as time changes, for example, you can analyze how much monthly into 2015, can generate a graph, in addition, still can next to a month of data each day, see the detail,

, I think you'd better buy the book to see, if only to generate a few charts, then use excel directly, if you want to do a system that best learn the data warehouse, especially the use of the tools, the development of data warehouse, or more complex,

You use what tools, based on SQL server or oracle

CodePudding user response:

If it is ORACLE, have what kind of tool

CodePudding user response:

refer to 6th floor jinancf response:

if ORACLE, have what kind of tool

You need patience to learn the knowledge of two aspects:
Aspects: 1. The Oracle database SQL and PL/SQL Ding Shifeng "Oracle PL/SQL from entry to master"
2. Data warehouse: it is recommended that look at the William H.I nmon fourth edition of the "data warehouse"