Matches in SemOpenAlex for { <https://semopenalex.org/work/W2397280391> ?p ?o ?g. }
- W2397280391 endingPage "147" @default.
- W2397280391 startingPage "106" @default.
- W2397280391 abstract "A data warehouse architecture (DWA) has been developed for the purpose of integrating data from multiple heterogeneous, distributed, and autonomous external data sources (EDSs) as well as for providing means for advanced analysis of integrated data. The major components of this architecture include: an external data source (EDS) layer, and extraction-transformation-loading (ETL) layer, a data warehouse (DW) layer, and an on-line analytical processing (OLAP) layer. Methods of designing a DWA, research developments, and most of the commercially available DW technologies tacitly assumed that a DWA is static. In practice, however, a DWA requires changes among others as the result of the evolution of EDSs, changes of the real world represented in a DW, and new user requirements. Changes in the structures of EDSs impact the ETL, DW, and OLAP layers. Since such changes are frequent, developing a technology for handling them automatically or semi-automatically in a DWA is of high practical importance. This chapter discusses challenges in designing, building, and managing a DWA that supports the evolution of structures of EDSs, evolution of an ETL layer, and evolution of a DW. The challenges and their solutions presented here are based on an experience of building a prototype Evolving-ETL and a prototype Multiversion Data Warehouse (MVDW). In details, this chapter presents the following issues: the concept of the MVDW, an approach to querying the MVDW, an approach to handling the evolution of an ETL layer, a technique for sharing data between multiple DW versions, and two index structures for the MVDW." @default.
- W2397280391 created "2016-06-24" @default.
- W2397280391 creator A5054888563 @default.
- W2397280391 date "2011-05-25" @default.
- W2397280391 modified "2023-09-26" @default.
- W2397280391 title "On Handling the Evolution of External Data Sources in a Data Warehouse Architecture" @default.
- W2397280391 cites W1482268585 @default.
- W2397280391 cites W1485215906 @default.
- W2397280391 cites W1485634545 @default.
- W2397280391 cites W1492574951 @default.
- W2397280391 cites W1503515369 @default.
- W2397280391 cites W1513236376 @default.
- W2397280391 cites W1514474360 @default.
- W2397280391 cites W1515036872 @default.
- W2397280391 cites W1517890499 @default.
- W2397280391 cites W1525246352 @default.
- W2397280391 cites W1529852762 @default.
- W2397280391 cites W1532295613 @default.
- W2397280391 cites W1538827254 @default.
- W2397280391 cites W1541087195 @default.
- W2397280391 cites W1544363742 @default.
- W2397280391 cites W1550582582 @default.
- W2397280391 cites W1551548222 @default.
- W2397280391 cites W1554212881 @default.
- W2397280391 cites W1556253886 @default.
- W2397280391 cites W1564115980 @default.
- W2397280391 cites W1574127120 @default.
- W2397280391 cites W1576405860 @default.
- W2397280391 cites W1578180423 @default.
- W2397280391 cites W1580024578 @default.
- W2397280391 cites W1581707734 @default.
- W2397280391 cites W1596708276 @default.
- W2397280391 cites W1602239196 @default.
- W2397280391 cites W1608014529 @default.
- W2397280391 cites W1820949069 @default.
- W2397280391 cites W1826683848 @default.
- W2397280391 cites W1847900129 @default.
- W2397280391 cites W1914905978 @default.
- W2397280391 cites W1931451256 @default.
- W2397280391 cites W1947383236 @default.
- W2397280391 cites W1971518725 @default.
- W2397280391 cites W1975487496 @default.
- W2397280391 cites W1975616538 @default.
- W2397280391 cites W197630086 @default.
- W2397280391 cites W1982141094 @default.
- W2397280391 cites W1983721754 @default.
- W2397280391 cites W1989532930 @default.
- W2397280391 cites W1992752048 @default.
- W2397280391 cites W1994899565 @default.
- W2397280391 cites W2000049284 @default.
- W2397280391 cites W2003863309 @default.
- W2397280391 cites W2004281168 @default.
- W2397280391 cites W2006250242 @default.
- W2397280391 cites W2013571244 @default.
- W2397280391 cites W2014763157 @default.
- W2397280391 cites W2016432893 @default.
- W2397280391 cites W2025455014 @default.
- W2397280391 cites W2026130312 @default.
- W2397280391 cites W2034664050 @default.
- W2397280391 cites W2055385473 @default.
- W2397280391 cites W2056553115 @default.
- W2397280391 cites W2058732050 @default.
- W2397280391 cites W2059603704 @default.
- W2397280391 cites W2064384103 @default.
- W2397280391 cites W2065188484 @default.
- W2397280391 cites W2065274285 @default.
- W2397280391 cites W2065530596 @default.
- W2397280391 cites W2071162673 @default.
- W2397280391 cites W2072764742 @default.
- W2397280391 cites W2075451706 @default.
- W2397280391 cites W2081564436 @default.
- W2397280391 cites W2081725016 @default.
- W2397280391 cites W2094131118 @default.
- W2397280391 cites W2096347930 @default.
- W2397280391 cites W2096527593 @default.
- W2397280391 cites W2097721784 @default.
- W2397280391 cites W2100576135 @default.
- W2397280391 cites W2100879782 @default.
- W2397280391 cites W2102023823 @default.
- W2397280391 cites W2103465290 @default.
- W2397280391 cites W2107664716 @default.
- W2397280391 cites W2110249885 @default.
- W2397280391 cites W2118341957 @default.
- W2397280391 cites W2119984902 @default.
- W2397280391 cites W2124031328 @default.
- W2397280391 cites W2124520930 @default.
- W2397280391 cites W2126671130 @default.
- W2397280391 cites W2131623627 @default.
- W2397280391 cites W2133054368 @default.
- W2397280391 cites W2144606308 @default.
- W2397280391 cites W2146081990 @default.
- W2397280391 cites W2146253100 @default.
- W2397280391 cites W2149877754 @default.
- W2397280391 cites W2150145391 @default.
- W2397280391 cites W2152236140 @default.
- W2397280391 cites W2152301310 @default.
- W2397280391 cites W2152726407 @default.
- W2397280391 cites W2153737095 @default.