this paper deals with an i * corresponding author email address:   nventory system with one central warehouse and a number of identical retailers. we consider perishable-on-the-shelf items; that is, all items have a fixed shelf life and start to age on their arrival at the retailers. each retailer faces poisson demand and employs (1, t) inventory policy. although demand n...

The data warehousing approach intends to exploit a very large volume of data to make relevant decisions. In this paper, we deal with objectoriented data warehouse design. More precisely, we present an object-oriented data warehouse model, integrating temporal and archive data. We provide functions allowing the administrator to specify a data warehouse from a global source schema.

The construction of a warehouse using data from DuPont Pharmaceutical’s Clinical Pharmacokinetics Group with the SAS/Warehouse Administrator product is described herein. Data sources incorporated into the pharmacokinetic warehouse existed in multiple formats (Oracle, Excel, SAS data sets, etc) and were represented by numerous individual files, rather then few large files. In most cases, the da...

User participation has become paramount for any successful data warehouse initiative. In this paper, we present MD2, a tool based on the dimensional data modeling approach, which facilitates the user participation in the development of a data warehouse application. MD2 assists users on identifying their analytical needs in order to help data warehouse designers to better specify business requir...

DATA WAREHOUSING and Online Analytical Processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Data Warehouse provides an effective way for the analysis and statistic to the mass data and helps to do the decision making. Many commercial products and services are now available and all of the principal database management syste...

Running analytical queries directly against the huge raw data volume of a data warehouse results in unacceptable query performance. The solution to this problem is storing materialized views in the warehouse, which pre-aggregate the data and thus avoid raw data access and speed up queries. In this paper, at first the problems concerning the selection of the right pre-aggregations and their util...

This paper addresses a multiperiod integrated model that plans deliveries to customers based upon inventories (at warehouse and customer locations) and vehicle routes. The model determines replenishment quantities and intervals at the warehouse, and distribution lots and delivery routes at customer locations. We investigate coordination of customer and warehouse replenishment decisions and illu...

We present a technique for automatic expiration of data in a historical data warehouse that preserves answers to a known and fixed set of first-order queries. In addition, we show that for queries with output size bounded by a function of the active data domain size (the number of values that have ever appeared in the warehouse), the size of the portion of the data warehouse history needed to a...

The data warehouse is considered to be the best way to organize transactional data. However, as many researches claim data warehouse should be augmented with external textual information. The objective of this chapter is to examine the requirements for profiling in the data warehouse environment. Profiles created in the data warehouse are then utilized to filter information. The goal of the ske...

Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE 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...