The "theme-oriented" data operation layer, also known as the ODS layer, is the closest layer to the data source. The data in the data source, through After extraction, washing and transmission, that is to say, after the legendary ETL, it is loaded into this layer. In general, most of the data at this layer is classified according to the classification method of the source business system.
In statistics, stratification refers to dividing a population or a population into multiple levels according to different characteristics. In sample research, in order to improve the reliability and accuracy of the data, it is often necessary to carry out stratified sampling. At this time, it is necessary to calculate the hierarchical sample variance.
Data layeringThe purpose is to improve the efficiency and accuracy of data processing, simplify the data processing process, optimize the data storage space, etc.
[Answer]: B The number of layers in layers has nothing to do with the size of the data volume, so A is wrong. Only relevant signs with layers can be layered, so D is wrong.
The principle of using the hierarchical method: the data fluctuation in the layer should be as small as possible, and the data difference between the layers should be as large as possible.
DW data stratification, from bottom to top are DWD, DWB, DWS DWD: data warehouse detail detail data layer, also known as ODS layer, is the separation layer between the business layer and the data warehouse.
1, operational data store.Operable data storage (ODS) refers to a database that is often used as a temporary area of a data warehouse. Unlike the data warehouse containing static data, the content of ODS is updated through the commercial operation process.
2. ODS is a thematic, integrated, variable and current detailed data collection used to support the needs of enterprises for immediate, operational and integrated information. It is often used as a transition to the data warehouse, and it is also one of the options for data warehouse projects.
3. ods is the abbreviation of Open Document Spreadsheet, which represents a spreadsheet file in OpenDocument format. OpenDocument is an open standard by OASIS(Organization for the Advancement of Structured Information Standards) formulation and development.
4. ods means data table, which is a Microsoft Outlook Express mailbox file, which is generally opened with OpenOffice. The .ods file cannot be opened normally. To open this file, you need to install Ope on your computer. nOffice software, and then click the .ods file directly to view the content of the file.
5. ODS - operational data. ODS is known as Operational Data Store, is a system used to store business data from multiple data sources. Its data is used to support business processes or input into the data warehouse for analysis. It is mainly used for business support.
According to the actual business, the digital warehouse is divided into ODS, DW, SCD, RPT layers, and the DIM dimension layer will run through all layers. , for the convenience of background query, it will be put into the RPT layer. The ODS layer stores data synchronized from the business source system. The prefix [ODS_Business Abbreviated_] is added to the table name, and the table structure and data structure are consistent with the source system.
Source Data Layer (ODS): There is no change in the data of this layer. It directly follows the data structure and data of the peripheral system, and is not open to the public;For the temporary storage layer, it is the temporary storage area of interface data to prepare for the data processing of the next step.
This layer mainly provides data for data products and data analysis. It is generally stored in ES, MySQL and other systems for online system use. It may also exist in Hive or Druid for data analysis and data mining. For example, the report data we often talk about, or the kind of wide table, is generally placed here.
So it is generally said to be a three-layer model: data operation layer (ODS), data warehouse layer (DW) and data application layer (APP).
How to validate supplier compliance-APP, download it now, new users will receive a novice gift pack.
The "theme-oriented" data operation layer, also known as the ODS layer, is the closest layer to the data source. The data in the data source, through After extraction, washing and transmission, that is to say, after the legendary ETL, it is loaded into this layer. In general, most of the data at this layer is classified according to the classification method of the source business system.
In statistics, stratification refers to dividing a population or a population into multiple levels according to different characteristics. In sample research, in order to improve the reliability and accuracy of the data, it is often necessary to carry out stratified sampling. At this time, it is necessary to calculate the hierarchical sample variance.
Data layeringThe purpose is to improve the efficiency and accuracy of data processing, simplify the data processing process, optimize the data storage space, etc.
[Answer]: B The number of layers in layers has nothing to do with the size of the data volume, so A is wrong. Only relevant signs with layers can be layered, so D is wrong.
The principle of using the hierarchical method: the data fluctuation in the layer should be as small as possible, and the data difference between the layers should be as large as possible.
DW data stratification, from bottom to top are DWD, DWB, DWS DWD: data warehouse detail detail data layer, also known as ODS layer, is the separation layer between the business layer and the data warehouse.
1, operational data store.Operable data storage (ODS) refers to a database that is often used as a temporary area of a data warehouse. Unlike the data warehouse containing static data, the content of ODS is updated through the commercial operation process.
2. ODS is a thematic, integrated, variable and current detailed data collection used to support the needs of enterprises for immediate, operational and integrated information. It is often used as a transition to the data warehouse, and it is also one of the options for data warehouse projects.
3. ods is the abbreviation of Open Document Spreadsheet, which represents a spreadsheet file in OpenDocument format. OpenDocument is an open standard by OASIS(Organization for the Advancement of Structured Information Standards) formulation and development.
4. ods means data table, which is a Microsoft Outlook Express mailbox file, which is generally opened with OpenOffice. The .ods file cannot be opened normally. To open this file, you need to install Ope on your computer. nOffice software, and then click the .ods file directly to view the content of the file.
5. ODS - operational data. ODS is known as Operational Data Store, is a system used to store business data from multiple data sources. Its data is used to support business processes or input into the data warehouse for analysis. It is mainly used for business support.
According to the actual business, the digital warehouse is divided into ODS, DW, SCD, RPT layers, and the DIM dimension layer will run through all layers. , for the convenience of background query, it will be put into the RPT layer. The ODS layer stores data synchronized from the business source system. The prefix [ODS_Business Abbreviated_] is added to the table name, and the table structure and data structure are consistent with the source system.
Source Data Layer (ODS): There is no change in the data of this layer. It directly follows the data structure and data of the peripheral system, and is not open to the public;For the temporary storage layer, it is the temporary storage area of interface data to prepare for the data processing of the next step.
This layer mainly provides data for data products and data analysis. It is generally stored in ES, MySQL and other systems for online system use. It may also exist in Hive or Druid for data analysis and data mining. For example, the report data we often talk about, or the kind of wide table, is generally placed here.
So it is generally said to be a three-layer model: data operation layer (ODS), data warehouse layer (DW) and data application layer (APP).
Trade data solutions for wholesalers
author: 2024-12-23 22:58Customizable export data queries
author: 2024-12-23 22:10Export planning using HS code data
author: 2024-12-23 21:23Brazil import trends by HS code
author: 2024-12-23 21:13HS code-driven route-to-market planning
author: 2024-12-23 23:53Furniture trade (HS code ) insights
author: 2024-12-23 23:14Holistic international trade reports
author: 2024-12-23 22:16How to build a resilient supply chain
author: 2024-12-23 22:06How to reduce supply chain overheads
author: 2024-12-23 21:34161.36MB
Check127.54MB
Check513.38MB
Check297.79MB
Check481.39MB
Check841.71MB
Check541.21MB
Check337.43MB
Check217.32MB
Check471.37MB
Check438.67MB
Check758.55MB
Check534.38MB
Check967.37MB
Check879.97MB
Check647.88MB
Check281.81MB
Check951.45MB
Check746.84MB
Check269.47MB
Check948.61MB
Check996.57MB
Check525.52MB
Check955.94MB
Check156.43MB
Check625.58MB
Check674.91MB
Check331.58MB
Check184.65MB
Check939.27MB
Check324.95MB
Check714.52MB
Check914.85MB
Check917.26MB
Check752.27MB
Check229.38MB
CheckScan to install
How to validate supplier compliance to discover more
Netizen comments More
2192 HS code-based global benchmarking
2024-12-23 23:52 recommend
1703 HS code alignment with import licensing
2024-12-23 23:52 recommend
1861 Metal scrap HS code classification
2024-12-23 23:12 recommend
1114 Global trade documentation standards
2024-12-23 21:48 recommend
575 Semiconductor HS code verification
2024-12-23 21:35 recommend