![]() ![]() As OLTP data accumulates in production databases, it is regularly extracted, filtered, and then loaded into a dedicated warehouse server that is accessible to users. In contrast, a warehouse database is updated from operational systems periodically, usually during off-hours. ![]() Production databases are updated continuously by either by hand or via OLTP applications. These include applications such as forecasting, profiling, summary reporting, and trend analysis. Such applications gather detailed data from day to day operations.ĭata Warehouse applications are designed to support the user ad-hoc data requirements, an activity recently dubbed online analytical processing (OLAP). Production applications such as payroll accounts payable product purchasing and inventory control are designed for online transaction processing (OLTP). Each data warehouse is different, but all are characterized by standard vital components. ![]() Next → ← prev Data Warehouse ArchitectureĪ data warehouse architecture is a method of defining the overall architecture of data communication processing and presentation that exist for end-clients computing within the enterprise. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |