Advanced Data Warehouse Design: From Conventional to Spatial by Elzbieta Malinowski

By Elzbieta Malinowski

A info warehouse shops huge volumes of old info required for analytical reasons. this information is extracted from operational databases; remodeled right into a coherent entire utilizing a multidimensional version that incorporates measures, dimensions, and hierarchies; and loaded right into a info warehouse through the extraction-transformation-loading (ETL) process.

Malinowski and Zimányi clarify intimately traditional information warehouse layout, overlaying particularly advanced hierarchy modeling. also, they handle leading edge domain names lately brought to increase the functions of knowledge warehouse platforms, particularly the administration of spatial and temporal details. Their presentation covers various levels of the layout procedure, similar to necessities specification, conceptual, logical, and actual layout. They contain 3 various ways for requisites specification counting on even if clients, operational information assets, or either are the motive force within the necessities collecting approach, and so they exhibit how every one strategy ends up in the production of a conceptual multidimensional version. in the course of the booklet the recommendations are illustrated utilizing many real-world examples and accomplished by way of pattern implementations for Microsoft's research prone 2005 and Oracle 10g with the OLAP and the Spatial extensions.

For researchers this ebook serves as an creation to the cutting-edge on information warehouse layout, with many references to extra specific resources. delivering a transparent and a concise presentation of the most important ideas and result of facts warehouse layout, it may possibly even be used because the foundation of a graduate or complex undergraduate direction. The e-book can help skilled facts warehouse designers to amplify their research percentages via incorporating spatial and temporal details. eventually, specialists in spatial databases or in geographical details structures may benefit from the knowledge warehouse imaginative and prescient for construction leading edge spatial analytical applications.

Show description

Read or Download Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications PDF

Similar information systems books

The Multinational Enterprise Revisited: The Essential Buckley and Casson

Incorporating essays from over thirty years, this publication includes key writings by way of the authors at the way forward for the multinational enterprise. Along with their seminal writings, a new creation and end are integrated to tie those items jointly in a complete assessment of the speculation of the multinational firm.

Ethical Money: How to Invest in Sustainable Enterprises and Avoid the Exploiters and Polluters

Socially accountable funding is the quickest starting to be zone of the collective funding undefined. via its development and powerful monetary functionality, it has proved to be an incredible funding strength in the monetary global. moral funding is definitely now not a monetary protest stream during which humans anticipate to lose their cash for a very good reason.

Business Geography and New Real Estate Market Analysis (Spatial Information Systems)

This paintings makes a speciality of integrating land-use position technological know-how with the expertise of geographic info platforms (GIS). The textual content describes the elemental rules of situation determination and the ability for utilising them that allows you to increase the genuine property determination.

GIS Applications in Agriculture, Volume Three: Invasive Species

Whereas many "alien" plant and animal species are purposefully brought into new parts as ornamentals, cattle, plants, or even pets, those species can break out into different parts and threaten agricultural and local ecosystems inflicting financial and environmental damage, or damage to human wellbeing and fitness. more and more, scientists are utilizing Geographic details platforms (GIS) to trace and deal with the invaders, mitigate the capability expense of unfold and point of effect, and shield the local economic climate and atmosphere.

Additional resources for Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications

Sample text

Such a restricted set of types does not fit complex application domains. , there is no encapsulation, and no methods associated with a table. • Since there is no possibility to directly reference an object by use of a surrogate or a pointer, every link between tables is based on comparison of values. Therefore, joins represent a bottleneck with respect to performance. During the 1980s, a considerable amount of research addressed the issue of relaxing the assumption that relations must satisfy the first normal form.

3d. A relation R is in the fourth normal form with respect to a set of functional and multivalued dependencies F if, for every nontrivial dependency X →→ Y that can be derived from F , X 32 2 Introduction to Databases and Data Warehouses is a key or contains a key of R. The table above is not in the fourth normal form, since there are multivalued dependencies from Employee no to Research area, and from Employee no to Department id, and Employee no is not a key of the relation. To make the relation comply with the fourth normal form, the attribute Department id must be removed from the table, and an additional table Affiliation(Employee no, Department id) must be added to store the information about the departments to which a member of the academic staff is affiliated.

Applying the above rules to the conceptual schema in Fig. 1 yields the types for the object-relational schema given in Fig. 4. With each of these types is associated a corresponding table. In the schema, arrows represent ref types pointing to a referenced type. Note that the relationship type Teaches in Fig. 1 is represented in Fig. 4 in the types corresponding to professors and sections. All other entity and relationship types of the conceptual schema are represented as structured types in the object-relational schema.

Download PDF sample

Rated 4.77 of 5 – based on 10 votes