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).
Real-time supply-demand matching-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).
How to build a resilient supply chain
author: 2024-12-23 23:13HS code-based freight consolidation
author: 2024-12-23 22:23European Union HS code verification
author: 2024-12-23 21:34How to detect trade-based money laundering
author: 2024-12-23 21:25HS code compliance for Pacific Island nations
author: 2024-12-23 21:04Customizable export data queries
author: 2024-12-23 23:25Tire imports HS code classification
author: 2024-12-23 23:16Industry-specific HS code database
author: 2024-12-23 22:31HS code integration with supply chain
author: 2024-12-23 21:42China trade data analysis tools
author: 2024-12-23 20:48846.58MB
Check396.93MB
Check241.87MB
Check473.37MB
Check338.26MB
Check456.76MB
Check269.28MB
Check533.48MB
Check833.81MB
Check718.12MB
Check693.69MB
Check376.92MB
Check811.51MB
Check245.83MB
Check922.43MB
Check625.28MB
Check728.99MB
Check527.75MB
Check531.75MB
Check785.21MB
Check877.65MB
Check143.51MB
Check778.55MB
Check566.13MB
Check148.45MB
Check986.78MB
Check144.84MB
Check426.61MB
Check228.37MB
Check259.82MB
Check597.49MB
Check191.69MB
Check692.94MB
Check788.42MB
Check153.79MB
Check636.41MB
CheckScan to install
Real-time supply-demand matching to discover more
Netizen comments More
1403 HS code tagging in tariff databases
2024-12-23 23:10 recommend
269 Real-time supply chain event updates
2024-12-23 22:14 recommend
2874 How to find untapped export partners
2024-12-23 22:11 recommend
2486 How to leverage data for export growth
2024-12-23 21:44 recommend
1027 Textile supply chain HS code mapping
2024-12-23 21:13 recommend