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).
Brazil import trends by HS code-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).
Mining industry HS code analysis
author: 2024-12-24 00:08HS code strategy for African trade lanes
author: 2024-12-23 23:51Global trade documentation templates
author: 2024-12-23 23:16HS code-driven supplier rationalization
author: 2024-12-23 22:06Russia HS code-based trade compliance
author: 2024-12-23 21:59Shipping lane performance metrics
author: 2024-12-24 00:23Pharmaceutical intermediates HS code mapping
author: 2024-12-23 23:07Industry consolidation via HS code data
author: 2024-12-23 22:25Predictive analytics in international trade
author: 2024-12-23 22:11HS code validation for diverse industries
author: 2024-12-23 21:58331.76MB
Check324.78MB
Check376.86MB
Check566.67MB
Check244.18MB
Check586.35MB
Check853.41MB
Check482.36MB
Check488.38MB
Check785.58MB
Check112.56MB
Check993.89MB
Check175.81MB
Check335.43MB
Check385.17MB
Check877.21MB
Check146.96MB
Check822.19MB
Check573.19MB
Check784.96MB
Check615.71MB
Check516.18MB
Check226.99MB
Check882.93MB
Check519.34MB
Check928.84MB
Check323.26MB
Check393.96MB
Check444.79MB
Check246.11MB
Check789.48MB
Check717.47MB
Check877.31MB
Check512.66MB
Check471.16MB
Check662.26MB
CheckScan to install
Brazil import trends by HS code to discover more
Netizen comments More
2652 HS code mapping for ASEAN countries
2024-12-24 00:22 recommend
334 Global HS code classification standards
2024-12-23 23:46 recommend
2009 Real-time supply chain event updates
2024-12-23 22:59 recommend
2603 Gemstones HS code references
2024-12-23 22:46 recommend
1756 Predictive supplier scoring algorithms
2024-12-23 22:31 recommend