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

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

DWT is a tool for the maintenance of data warehouse structures based on the temporal data warehouse model COMET. Data warehouse systems do not provide support for maintaining changes in dimension data. DWT allows keeping track of modifications made in the dimension-structure of multidimensional cubes stored in an OLAP (On-Line Analytical Processing) system. We present the overall structure of t...

Problem statement: The Data Warehouse is a database dedicated to the storage of all data used in the decision analysis, it meets the customer requirements, to ensure, in time, that a data warehouse complies with the rules of construction and manages the evolutions necessary of the information system (IS). Results: According to the studies carried out, we see that a system based on a data wareho...

The aim is to study the data warehouse specific security needs which means focusing on the long life cycle of the data and the data security and privacy issues. These requirements needs to be fulfilled despite of the unpredictable future uses of the data. The basic assumption is that data warehouse server is running on the dedicated server, and the basic information system security is properly ...

We study a two-item two-warehouse periodic review inventory model that allows transshipment between warehouses and emergency orders. The model helps to determine two decisions: (i) the order up to levels for the two items at the two warehouses, and (ii) whether to accept a transshipment request from the other warehouse. The acceptance of a transshipment request in a warehouse depends on the tim...

The Traditional data warehouse did not contain data as today. Hence, it is difficult to retrieve these data and treat them. Furthermore, its content is not updated, which may lead to bad decisions. Data are typically loaded from conventional operational systems. Given that today’s decisions, in the business world, are becoming more and more in real time. Thus, the system supporting these decisi...