d680c458d3 Nonvolatile Nonvolatile means that, once entered into the data warehouse, data should not change. The OLTP database is always up to date, and reflects the current state of each business transaction. In OLTP systems, end users routinely issue individual data modification statements to the database. This is to support historical analysis. Three common architectures are: Data Warehouse Architecture (Basic) Data Warehouse Architecture (with a Staging Area) Data Warehouse Architecture (with a Staging Area and Data Marts) Data Warehouse Architecture (Basic) Figure 1-2 shows a simple architecture for a data warehouse.
Figure 1-3 Architecture of a Data Warehouse with a Staging Area Description of "Figure 1-3 Architecture of a Data Warehouse with a Staging Area" Data Warehouse Architecture (with a Staging Area and Data Marts) Although the architecture in Figure 1-3 is quite common, you may want to customize your warehouse's architecture for different groups within your organization. Figure 1-1 Contrasting OLTP and Data Warehousing Environments Description of "Figure 1-1 Contrasting OLTP and Data Warehousing Environments" One major difference between the types of system is that data warehouses are not usually in third normal form (3NF), a type of data normalization common in OLTP environments. Two standard texts are:. Data Warehouse Architecture (with a Staging Area) You need to clean and process your operational data before putting it into the warehouse, as shown in Figure 1-2. What is a Data Warehouse? Data Warehouse Architectures . Data modifications A data warehouse is updated on a regular basis by the ETL process (run nightly or weekly) using bulk data modification techniques. In addition to a relational database, a data warehouse environment can include an extraction, transportation, transformation, and loading (ETL) solution, online analytical processing (OLAP) and data mining capabilities, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.
Wethdayso replied
448 weeks ago