Data warehousing

Today, pharmaceutical companies are linking CDS to business systems such as SAP, chemical structure databases, electronic laboratory notebooks, and corporate data warehousing solutions. Many commonly used software products utilize COM Automation (Microsoft s Component Object Model) to provide a powerful array of programmable objects that allow seamless connections between applications. 

Placed in a completely different and far more fixedly structured domain, the results of the DWQ project were not directly transferable to the CRC 476 IMPROVE. For the support of creative design processes, different approaches were - and are - necessary. Yet the approach of applying methods of meta modeling in domain and application models was expected to succeed there as well. Especially the use of ConceptBase, as described before, was used to achieve a sound conceptual and ontological basis for the modeling aspects, the process extensions to Data Warehousing as researched in the subproject Cl, and the meta process and product repository of the subproject B1. 

The same basic arguments apply to engineering applications. In these applications, the buffer function of data warehousing may be even more important. Research results are often obtained by expensive simulations or even more expensive laboratory experiments, such that analytic processing on demand from information sources is only possible with exceptional effort. 

The conceptualization and implementation of the authors Process Data Warehousing approach has been illustrated, as realized as part of the research done in the subproject Cl. Aiming at goal-driven information flow management, three different prototypes have been described in their application and evaluation for engineering design process support. 

Jarke, M., List, T., Koller, J. The Challenge of Process Data Warehousing. In Proceedings of the 26 International Conference on Very Large Databases (VLDB), Cairo, Egypt, pp. 473-483 (2000)... 

Calvanese D, de Giomo G, Lenzerini M, Nardi D, Rosati R (2001) Data integration in data warehousing. Int J Cooper Inform Syst 10 237-271 Casanova M, Vidal V (1983) Towards a sound view integration methodology. In PODS. ACM,... 

---