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

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

How to provide construction managers with information about and insight into the existing data so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system is a problem during the construction management process. To solve this problem, the integration of a Data Warehouse and a Decision Support System (DSS) seems to be efficient. ...

Data warehouse systems are used for decision-making purposes. The Online Analytical Processing (OLAP) tools are commonly used to query and analysis of results on such systems. It is complex task for non-technical users (executives, managers etc.,) to query the data warehouse using OLAP tool keeping in view the schema knowledge. For such data warehouse users, a natural language interface is a vi...