This paper seeks to build a data warehouse for the central region directorate of Ghana Education Service (GES). The project deployed top-down approach by relying on hub and spoke architecture based Joint Application Development (JAD) session organized elicit user requirements. Again, dependent marts, as well star schema, were chosen due their uniqueness appropriateness project. There were, howe...

In this paper, we study the data warehouse modelling used in decision support systems. We provide an objectoriented data warehouse model allowing data warehouse description as a central repository of relevant, complex and temporal data. Our model integrates three concepts such as warehouse object, environment and warehouse class. Each warehouse object is composed of one current state, several p...

Inventory control is a crucial activity for many companies. Given the recent advances in information technology, there have never been greater opportunities for coordinated inventory control across supply chain facilities. But how do we design efficient control methods and policies that take advantage of the detailed information that is now becoming available? This doctoral thesis investigates ...

We consider a single-item, two-echelon spare parts inventory model for repairable parts for capital goods with high down time costs. The inventory system consists of a central warehouse and multiple local warehouses, from where customers are served, and a central repair facility at an external supplier. When a part fails at a customer, his request for a ready-for-use part is immediately fulfill...

This paper considers a single-item, two-echelon, continuous-review inventory model. A number of retailers have their stock replenished from a central warehouse. The warehouse in turn replenishes stock from an external supplier. The demand processes on the retailers are independent Poisson. Demand not met at a retailer is lost. The order quantity from each retailer on the warehouse and from the ...

In manual order picking systems, order pickers walk or ride through a warehouse in order to collect items requested by customers. The performance of such a system is significantly dependent on its layout which determines the lengths of the order pickers’ tours and the corresponding picking times. Whereas for classic warehouse layouts all picking aisles are arranged in parallel to each other, in...

This paper considers a two-echelon distribution inventory system with a central warehouse and a number of retailers. There is direct customer demand also at the warehouse. If this upstream demand requires a high service, it may be advantageous to give higher priority to customer orders compared to retailer replenishments. We suggest and evaluate two techniques for handling this situation. One t...

This paper deals with temporal and archive object-oriented data warehouse modelling and querying. In a first step, we define a data model describing warehouses as central repositories of complex and temporal data extracted from one information source. The model is based on the concepts of warehouse object and environment. A warehouse object is composed of one current state, several past states ...

Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement. However, the increasing demands for interactive response time from the users make query performance one of the central problems of data warehousing today. In this paper we defend that data warehouse design must t...

The increasing demands for interactive response time from the users makes query performance one of the central problems of Data warehouse systems today. Performance is an important quality aspect of Data warehouse systems. Predicting the performance of Data warehouse systems during early design stages of their development is significant. Software Performance Engineering(SPE) promotes the idea t...