Advanced data warehouse design : from conventional to spatial and temporal applications
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...
Lưu vào:
| Tác giả chính: | , |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Thông tin xuất bản: |
Springer
2017
|
| Chủ đề: | |
| Truy cập trực tuyến: | http://repository.vnu.edu.vn/handle/VNU_123/24000 |
| Từ khóa: |
Thêm từ khóa bạn đọc
Không có từ khóa, Hãy là người đầu tiên gắn từ khóa cho biểu ghi này!
|
| id |
oai:112.137.131.14:VNU_123-24000 |
|---|---|
| record_format |
dspace |
| spelling |
oai:112.137.131.14:VNU_123-240002020-07-09T07:41:39Z Advanced data warehouse design : from conventional to spatial and temporal applications Malinowski, Elzbieta Zimányi, Esteban Multidimensional databases -- Design ; Temporal databases -- Design 005.74 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. 2017-04-04T03:30:05Z 2017-04-04T03:30:05Z 2008 Book 978-3-540-74404-7 http://repository.vnu.edu.vn/handle/VNU_123/24000 en ©2009 Springer-Verlag Berlin Heidelberg 457 p. application/pdf Springer |
| institution |
Đại học Quốc Gia Hà Nội |
| collection |
DSpace |
| language |
English |
| topic |
Multidimensional databases -- Design ; Temporal databases -- Design 005.74 |
| spellingShingle |
Multidimensional databases -- Design ; Temporal databases -- Design 005.74 Malinowski, Elzbieta Zimányi, Esteban Advanced data warehouse design : from conventional to spatial and temporal applications |
| description |
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. |
| format |
Book |
| author |
Malinowski, Elzbieta Zimányi, Esteban |
| author_facet |
Malinowski, Elzbieta Zimányi, Esteban |
| author_sort |
Malinowski, Elzbieta |
| title |
Advanced data warehouse design : from conventional to spatial and temporal applications |
| title_short |
Advanced data warehouse design : from conventional to spatial and temporal applications |
| title_full |
Advanced data warehouse design : from conventional to spatial and temporal applications |
| title_fullStr |
Advanced data warehouse design : from conventional to spatial and temporal applications |
| title_full_unstemmed |
Advanced data warehouse design : from conventional to spatial and temporal applications |
| title_sort |
advanced data warehouse design : from conventional to spatial and temporal applications |
| publisher |
Springer |
| publishDate |
2017 |
| url |
http://repository.vnu.edu.vn/handle/VNU_123/24000 |
| work_keys_str_mv |
AT malinowskielzbieta advanceddatawarehousedesignfromconventionaltospatialandtemporalapplications AT zimanyiesteban advanceddatawarehousedesignfromconventionaltospatialandtemporalapplications |
| _version_ |
1811375076961943552 |