Which are the most current design defects?
A basis is not conceived without a preliminary basic reflection founded on the practices and real needs of the users.
This principle, at the origin of good number of gas works in data processing, is the receipt of explosion of the basis.
, cofounder of Report analyzed well these through design particularly current which it describes as follows:
To store a maximum of data to authorize any type of analyzes
To define a great number of dimensions to facilitate the analyzes
To multiply the aggregates to improve the response times
And yet, S …
With use one notes that the majority of the requests relate generally only to one reduced whole of data. In addition, the exotic analyzes, if they are launched at the time of the first days of use to test the machine, remain rather exceptional of everyday usage.
It is by this identification which the design engineering of a basis must begin.
See also the site of Transfer
Data warehouses Handy guide of dimensional modeling.
With this book the authors expose consultings and Directives of design of dimensional models, illustrated by case studies drawn from the real-world: retail sale, management of inventory list, provisioning, controls and invoicing, management of the customer relation, book-keeping, financial services but also with implementations Internet. 460 pages 52,25 Euros
Copyright: Alain FERNANDEZ ©1998-2008- All rights reserved