By Elzbieta Malinowski
This unheard of paintings offers readers with an creation to the state of the art examine on info warehouse layout, with many references to extra precise resources. It deals a transparent and a concise presentation of the main suggestions and leads to the topic zone. Malinowski and Zimányi clarify traditional info warehouse layout intimately, and also deal with cutting edge domain names lately brought to increase the features of information warehouse structures: specifically, the administration of spatial and temporal information.
Read or Download Advanced data warehouse design : from conventional to spatial and temporal applications PDF
Best information systems books
The aim of the seventh overseas convention on firm info structures (ICEIS) was once to collect researchers, engineers and practitioners attracted to the advances and company purposes of data platforms. 5 simultaneous tracks were held, overlaying assorted features of firm details platforms purposes, together with firm Database expertise, structures Integration, man made Intelligence, determination aid platforms, info structures research and Specification, web Computing, digital trade and Human elements.
This learn quantity incorporates a synthesis of modern advances within the conception of the multinational company, with a spotlight on internalization and foreign diversification concerns. It proposes very important extensions of establishment firm conception, specifically as regards the significance of geography to multinational process, and the linkages among internalization and overseas diversification.
Extra info for Advanced data warehouse design : from conventional to spatial and temporal applications
The relationship type that relates a weak entity type to its owner is called the identifying relationship type of the weak entity type. In Fig. 1, Course and CouSec are, respectively, the identifying entity type and the identifying relationship type of Section. As shown in the ﬁgure, an identifying relationship is distinguished by the double line of its diamond. A relationship type that is not an identifying relationship type is called a regular relationship type. Note that identifying relationships types have a cardinality (1,1) in the role of the weak entity type and may have a (0,n) or (1,n) cardinality in the role of the owner.
Further, a table of the above structured type must be declared, in which the not null constraints for the mandatory attributes are also deﬁned. The identiﬁer of the entity type deﬁnes the key of the associated table. Rule 2: A weak entity type is transformed as a strong entity type, with the exception that the associated structured type contains in addition the identiﬁer of the owner entity type. Further, the combination of the partial identiﬁer of the weak entity type and the identiﬁer of its owner entity type deﬁnes the key of the associated table.
A weak entity type typically has a partial key, which is the set of attributes that can uniquely identify weak entities that are related to the same owner entity. In our example, we assume that a course has at most one associated section in a semester and a year. In Fig. 1, the partial key attributes are underlined with a dashed line. Finally, owing to the complexity of conceptualizing the real world, human beings usually refer to the same concept using several diﬀerent perspectives with diﬀerent abstraction levels.
Advanced data warehouse design : from conventional to spatial and temporal applications by Elzbieta Malinowski