Problems in Designing Huge Datawarehouses and Datamarts
Didier Nakache · Journal of the Association for Information Systems · 2003
This paper reports on a Datawarehouse application.The French national health department has to face numerous problems: financial, medical, social, accounting, public health and political.Thus, an efficient tool is needed for managing the decision support information system.In this context we have proposed the ERASME/SNIIR-AM Datawarehouse project.To the best of our knowledge, it has been considered as the largest Datawarehouse in the world.The main challenge we had to solve were due to huge volumes.We have chosen to solve it by an ad hoc methodology mainly based on datamart design.