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

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

A key challenge for data warehouse security is how to manage the entire system coherently – from sources and their export tables, to warehouse stored tables (conventional and cubes) and views defined over the warehouse. Permissions on the warehouse must satisfy the restrictions of the data owners, and be updated quickly as those local concerns evolve. Yet the system cannot demand extensive admi...

Active data warehousing is rapidly changing the landscape for deployment of decision support solutions. The trend toward actionable business intelligence demands that capabilities for tactical and event-driven decision-making be supported in addition to traditional uses of the data warehouse for strategic decision-making. The resulting challenges to deliver extreme service levels in the areas o...