This article focuses on the development of a data warehouse to facilitate government decision-making on national human resources development and to provide public access to information. A set of key challenges was confronted in the development of the data warehouse including: the conceptualisation, design, implementation and management of the data warehouse system. The underlying questions that...

The integration of a Data Warehouse and a Decision Support System (DSS) can provide construction managers with sufficient information for decision making without interrupting daily work of an On-Line Transaction Processing system. In this paper, the concepts of the data warehouse, On-Line Analysis Processing and DSS are first reviewed. The method of creating a data warehouse is then shown, chan...

Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensiona...

This paper presents a mathematical model of inventory control problem for determining the minimum total cost of multi-item multi-objective inventory model with fuzzy estimated price dependent demand, fuzzy deterioration and possible constraints. Here, three constraints we have taken; they are warehouse space constraint, investment amount constraint and the third constraint is the percentage of ...

Data warehouse architectural choices and optimization techniques are critical to decision support query performance. To facilitate these choices, the performance of the designed data warehouse must be assessed. This is usually done with the help of benchmarks, which can either help system users comparing the performances of different systems, or help system engineers testing the effect of vario...

Quantitive evaluations show that many data warehouse projects fail at an alarming rate, wasting all the time, money, and effort spent on them. Cost overruns and schedule delays are attributed in large part, to problems associated with requirements. Therefore, a crucial success factor for the implementation of data warehouse systems is efficient requirements management. In this paper we introduc...

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...

A data warehouse is a conceptual repository that collects information from one or more data sources and provides a schema that allows this repository to be queried by users of the warehouse. The dii-culties in designing a schema for a data warehouse whose member databases are multimedia databases are mainly caused by the highly diverse nature of multimedia data, a very wide range of multimedia ...

Practitioners and researchers in the domain of data warehousing are primarily focussing on technical aspects of data warehouse systems. Organizational issues are often neglected although several studies about critical success factors of data warehouse projects emphasize their importance. Thus, the aim of this paper is to provide deeper insights in organizational issues of data warehousing. The ...

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...