Traditional enterprise data warehouse, an integral part of decision support systems (DSS), provides a variety of granularity data to satisfy requirements of different users. It is estimated that about 80% of the information stored in data warehouse is geo-spatial related. However, traditional data warehouse cannot efficiently process spatial data. With the increasing amount of spatial data stor...

Data warehouse modeling is a complex task, which involves knowledge of business processes of the domain of discourse, understanding the structural and behavioral system’s conceptual model, and familiarity with data warehouse technologies. The suitability of current data warehouse modeling methods for large-scale systems is questionable, as they require multiple manual actions to discover measur...

This paper explores the importance of semantic integrity during data warehouse design and its impact on the successful use of the implemented warehouse. This was achieved through a detailed case study. Consequently, a conceptual framework for describing intersubjective meaning in data modelling has been developed. The purpose of the framework is to provide a theoretical basis for explaining how...

We consider a continuous-time, single-echelon, multi-location inventory model with Poisson demand processes. In case of a stock-out at a local warehouse, a demand can be fulfilled via a lateral transshipment (LT). Each warehouse is assigned a predetermined sequence of other warehouses where it will request for an LT. However, a warehouse can hold its last part(s) back from such a request. This ...

Spatial Data warehouses pose many challenging requirements with respect to the design of the data model due to the nature of analytical operations and the nature of the views to be maintained by the spatial warehouse. The first challenge is due to the multi-dimensional nature of each dimension itself. In a traditional data warehouse the various dimensions contributing to the warehouse data are ...

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.

This article will introduce an inventory model for deteriorating items under a ramp-type demand rate. In the sequel, preservation technology has appeared to reduce deterioration rate of items. The is considered time-dependent. Due demand, retailers may face complete and partial backlogged shortages. We suggest two-warehouse effect when retailer faces storage capacity problem. this model, it wou...