Data warehouses have become an instant phenomenon in many large organizations that deal with massive amounts of information. Drawing on the experiences from the systems development ®eld, we surmise that an effective design tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...

Data Warehouse design requires a to why dimensional modelling is preferred over E-R modelling when creating data warehouse. Radical rebuilding of tremendous measures of information, frequently of questionable or conflicting quality, drawn from various heterogeneous sources. Data Warehouse configuration assimilates business learning and innovation know-how. The outline of theData Warehouse requi...

With the large-scale introduction of the data warehouse concept, a new phenomenon has appeared in the field of information systems development. Facts in a data warehouse – as opposed to those in an operational database – mainly represent immutable, aggregated or otherwise derived, historical information. The aggregation level and specific layout of management information reports often cannot be...

Data integration systems are planned to offer uniform access to data from heterogeneous and distributed sources. Two classical data integration architectures have been proposed in the literature. In the materialized approach, data are stored, integrated and accessed directly from a data warehouse. In the virtual approach, the queries posed to the integration system are decomposed into queries a...

Data warehouse [2,4,5,6] is an integrated repository derived from multiple source (operational and legacy) databases. The data warehouse is created by either replicating the different source data or transforming them to new representation. This process involves reading, cleaning, aggregating and storing the data in the warehouse model. The software tools are used to access the warehouse for str...

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

The data warehouse has become a necessary component for an effective analysis of large businesses. It is widely accepted that the data warehouse must be structured according to the multidimensional model to facilitate OLAP analysis. The two driving force for the design of a multidimensional model are data source and business requirements. In recent years in addition to operational databases, we...

Automatic Guided Vehicles (AGVs) are unmanned vehicles that can transport loads in a warehouse. AGVs are instructed by on-board AGV control software. As multiple AGVs operate in a decentralized manner in the warehouse environment, conflicts may arise. Consequently, it is crucial to test thoroughly whether the AGV control software actually handles the potential conflicts in the appropriate way. ...

In many applications one has to fetch and assemble pieces of information coming from more than one SPARQL endpoints. In this paper we describe the corresponding requirements and challenges, and then we present a process for constructing such a semantic warehouse. We focus on the aspects of quality and value of the warehouse, and for this reason we introduce various metrics for quantifying its c...

This paper proposes a web warehouse based approach to facilitating efficiency improvement, information sharing and service personalization for the World Wide Web. We will overview various functions of a web warehouse by considering the following applications: (1) a web warehouse as shared information repository, (2) a web warehouse as large-scale intelligent cache. We conclude that web warehous...