New PDF release: Advanced Data Warehouse Design: From Conventional to Spatial

By Elzbieta Malinowski

ISBN-10: 3540744045

ISBN-13: 9783540744047

ISBN-10: 3540744053

ISBN-13: 9783540744054

A info warehouse shops huge volumes of old facts 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 throughout the extraction-transformation-loading (ETL) process.

Malinowski and Zimányi clarify intimately traditional facts warehouse layout, overlaying specifically advanced hierarchy modeling. also, they tackle cutting edge domain names lately brought to increase the features of knowledge warehouse platforms, particularly the administration of spatial and temporal info. Their presentation covers diverse levels of the layout technique, corresponding to necessities specification, conceptual, logical, and actual layout. They contain 3 varied techniques for specifications specification looking on no matter if clients, operational information assets, or either are the driver within the necessities accumulating technique, they usually exhibit how every one technique results in the production of a conceptual multidimensional version. during the publication the strategies 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 advent to the cutting-edge on information warehouse layout, with many references to extra precise assets. delivering a transparent and a concise presentation of the most important innovations and result of information warehouse layout, it may possibly even be used because the foundation of a graduate or complex undergraduate path. The booklet can assist skilled facts warehouse designers to amplify their research probabilities through incorporating spatial and temporal info. eventually, specialists in spatial databases or in geographical details structures may benefit from the information warehouse imaginative and prescient for development cutting 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

Download e-book for kindle: The Practice of Enterprise Modeling: Third IFIP WG 8.1 by Patrick van Bommel, Stijn Hoppenbrouwers, Sietse Overbeek,

This quantity constitutes the complaints of the 3rd IFIP WG eight. 1 operating convention at the perform of company Modeling, held in Delft, The Netherlands, in the course of November 9-10, 2010. The objective of the convention is either to foster a greater realizing of the perform of firm modeling and to enhance its theoretical foundations.

Enterprise Supply Chain Management: Integrating Best in - download pdf or read online

Compliment for firm offer Chain administration: Integrating Best-in-Class Processes"Enterprise offer Chain administration: Integrating Best-in-Class strategies is a smart primer on all issues offer chain. this can be a must-read for any IT, finance, enterprise, or revenues government operating for a company the place provide chain is a strategic self-discipline.

Read e-book online Geoinformation Technologies for Geo-Cultural Landscapes: PDF

The focal major goal of the publication is to represent a significant linkage between learn difficulties, geoinformation equipment and corresponding purposes. The examine pursuits, comparable either to theoretical and functional matters, derive from multidisciplinary fields corresponding to archaeology, historical past, geography, panorama making plans, setting, geoinformation technology, geology and geomorphology.

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

Sample text

A large number of approaches for requirements specification have been developed by both academia and practitioners. , separate necessary from “nice to have” system properties [318]. During this phase, active participation of users will increase customer satisfaction with the delivered system and avoid errors, which can be very expensive to correct if the subsequent phases have already been developed. • Conceptual design, which aims at building a user-oriented representation of the database that does not contain any implementation considerations.

Referential integrity allows links between two tables (or twice the same table) to be specified, where a set of attributes in one table, called the foreign key, references the primary key of the other table. This means that the values accepted in the foreign key must also exist in the primary key. In Fig. 2, referential integrity constraints are represented by arrows from the foreign key to the primary key of the table that is referenced. For example, the attribute Employee no in table Professor references the primary key of the table Academic staff.

2. We can easily verify that the information about a project such as its name, acronym, and description is repeated for each staff member who works on that project. Therefore, when for example the description of a project is to be updated, it must be ensured that all tuples in the relation Participates concerning that particular project are given the modified description, otherwise there will be inconsistencies. Similarly, the relation Assistant in Fig. 3b is also redundant, since the first name, last name, and email address of every professor are repeated for all assistants who have the same advisor.

Download PDF sample

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

by Daniel

Rated 4.59 of 5 – based on 22 votes