This paper aims to describe the data warehousing process for the Pharmaceutical and the Healthcare industries. We will first examine the reasons and needs for the data warehouses and the expected benefits. Based on this, a general process for data warehousing emerges that utilizes a host of tools and techniques. These are then illustrated by two case studies as follows: (1) A Clinical Trials Da...

This study investigates a two-echelon supply chain model for deteriorating inventory in which the retailer’s warehouse has a limited capacity. The system includes one wholesaler and one retailer and aims to minimise the total cost. The demand rate in retailer is stock-dependent and in case of any shortages, the demand is partially backlogged. The warehouse capacity in the retailer (OW) is limit...

This paper proposes an analytical method for performance evaluation and optimization of a production-distribution system composed of a warehouse supplied from an upstream manufacturing plant. Customer orders arrive randomly with random order size and the production capacity is finite. Transportation time from plant to warehouse is fixed. The analytical approach needs only the first two moments ...

This article will introduce an inventory model for deteriorating items under a ramp-type demand rate. In the sequel, preservation technology has appeared to reduce deterioration rate of items. The is considered time-dependent. Due demand, retailers may face complete and partial backlogged shortages. We suggest two-warehouse effect when retailer faces storage capacity problem. this model, it wou...

This paper describes how a performance data warehouse can be used to facilitate business process improvement that is based on holistic performance measurement. The feasibility study shows how management and analysis of performance data can be facilitated by a data warehouse approach. It is argued that many of the shortcomings of traditional measurement systems can be overcome with this performa...

This paper addresses issues related to Knowledge Management in the context of heterogeneous data warehouse environments. The traditional notion of data warehouse is evolving into a federated warehouse augmented by a knowledge repository, together with a set of processes and services to support enterprise knowledge creation, refinement, indexing, dissemination and evolution.

This paper analyzed the model design process of data warehouse project and the various factors which affected the performance in data warehouse model design. Then the author introduced the multistage fuzzy comprehensive evaluation method, and studied its application to the data warehouse’s model performance evaluation, and gave the performance measure model of data warehouse based on multistage...

IntroductIon Enhanced knowledge warehouse (eKW) is an extension of the enhanced data warehouse (eDW) system (Abramowicz, 2002). eKW is a Web services-based system that allows the automatic filtering of information from the Web to the data warehouse and automatic retrieval through the data warehouse. Web services technology extends eKW beyond the organization. It makes the system open and allows...

In recent years, the number of digital information storage and retrieval systems has increased immensely. Data warehousing has been found to be an extremely useful technology for integrating such heterogeneous and autonomous information sources. Data within the data warehouse is modelled in the form of a star or snowflake schema which facilitates business analysis in a multidimensional perspect...