05104nam a22006375i 4500 978-3-540-74405-4 DE-He213 20210625092236.0 cr nn 008mamaa 100301s2008 gw | s |||| 0|eng d 9783540744054 978-3-540-74405-4 10.1007/978-3-540-74405-4 doi QA76.9.D35 Q350-390 UMB bicssc COM031000 bisacsh UMB thema GPF thema 005.73 23 Malinowski, Elzbieta. author. aut http://id.loc.gov/vocabulary/relators/aut Advanced Data Warehouse Design [electronic resource] : From Conventional to Spatial and Temporal Applications / by Elzbieta Malinowski, Esteban Zimányi. 1st ed. 2008. Berlin, Heidelberg : Springer Berlin Heidelberg : Imprint: Springer, 2008. XXI, 435 p. online resource. text txt rdacontent computer c rdamedia online resource cr rdacarrier text file PDF rda Data-Centric Systems and Applications, 2197-9723 to Databases and Data Warehouses -- Conventional Data Warehouses -- Spatial Data Warehouses -- Temporal Data Warehouses -- Designing Conventional Data Warehouses -- Designing Spatial and Temporal Data Warehouses -- Conclusions and Future Work. A data warehouse stores large volumes of historical data required for analytical purposes. This data is extracted from operational databases; transformed into a coherent whole using a multidimensional model that includes measures, dimensions, and hierarchies; and loaded into a data warehouse during the extraction-transformation-loading (ETL) process. Malinowski and Zimányi explain in detail conventional data warehouse design, covering in particular complex hierarchy modeling. Additionally, they address two innovative domains recently introduced to extend the capabilities of data warehouse systems, namely the management of spatial and temporal information. Their presentation covers different phases of the design process, such as requirements specification, conceptual, logical, and physical design. They include three different approaches for requirements specification depending on whether users, operational data sources, or both are the driving force in the requirements gathering process, and they show how each approach leads to the creation of a conceptual multidimensional model. Throughout the book the concepts are illustrated using many real-world examples and completed by sample implementations for Microsoft's Analysis Services 2005 and Oracle 10g with the OLAP and the Spatial extensions. For researchers this book serves as an introduction to the state of the art on data warehouse design, with many references to more detailed sources. Providing a clear and a concise presentation of the major concepts and results of data warehouse design, it can also be used as the basis of a graduate or advanced undergraduate course. The book may help experienced data warehouse designers to enlarge their analysis possibilities by incorporating spatial and temporal information. Finally, experts in spatial databases or in geographical information systems could benefit from the data warehouse vision for building innovative spatial analytical applications. Data structures (Computer science). Database management. Geographical information systems. Information technology. Business—Data processing. Environmental monitoring. Earth sciences. Data Structures and Information Theory. https://scigraph.springernature.com/ontologies/product-market-codes/I15009 Database Management. https://scigraph.springernature.com/ontologies/product-market-codes/I18024 Geographical Information Systems/Cartography. https://scigraph.springernature.com/ontologies/product-market-codes/J13000 IT in Business. https://scigraph.springernature.com/ontologies/product-market-codes/522000 Monitoring/Environmental Analysis. https://scigraph.springernature.com/ontologies/product-market-codes/U1400X Earth Sciences, general. https://scigraph.springernature.com/ontologies/product-market-codes/G00002 Zimányi, Esteban. author. (orcid)0000-0003-1843-5099 https://orcid.org/0000-0003-1843-5099 aut http://id.loc.gov/vocabulary/relators/aut SpringerLink (Online service) Springer Nature eBook Printed edition: 9783540842668 Printed edition: 9783642093838 Printed edition: 9783540744047 Data-Centric Systems and Applications, 2197-9723 https://doi.org/10.1007/978-3-540-74405-4 ZDB-2-SCS ZDB-2-SXCS Computer Science (SpringerNature-11645) Computer Science (R0) (SpringerNature-43710)