An important concern in supply chain management is about network design, involving factories, central warehouses, regional warehouses as well as customers. The best strategy has to be ascertained for distributing products within this network. The objective is to select the optimal numbers and locations of central and regional warehouses such that all customer demands are satisfied at minimum to...

To realize the accurate reserve and timely supply of emergency materials, influenced by idea intelligent storage material linkage, considering complexity, uncertainty, dynamism disasters, because national demand for allocation living based on study "ordinary integration" collaborative adaptation mechanism a kind This is virtual that "complementary in times peace dominant emergency". With help b...

In this paper, we consider a Markovian model for a two-echelon inventory/return system. The system consists of a supply plant with infinite capacity and a central warehouse for inventory and returns. There are also a number of local warehouses which are also capable of re-manufacturing of returns to products. To obtain a high service level of handling inventory and returns, lateral transshipmen...

OLAP queries involve a lot of aggregations on a large amount of data in data warehouses. To process expensive OLAP queries efficiently, we propose a new method for rewriting a given OLAP query using various kinds of materialized aggregate views which already exist in data warehouses. We first define the normal forms of OLAP queries and materialized views based on the lattice of dimension hierar...

The term refers to the ability of combining the content of two or more heterogeneous data warehouses, for the purpose of cross-analysis. This need emerges in a variety of practical situations. For instance, when different designers of a large company develop their data marts independently, or when different organizations involved in the same project need to integrate their data warehouses. Data...

Data warehouses are nowadays an important component in every competitive system, it's one of the main components on which business intelligence is based. We can even say that many companies are climbing to the next level and use a set of Data warehouses to provide the complete information or it's generally due to fusion of two or many companies. these Data warehouses can be heterogeneous and ge...

Modern enterprise data warehouses have complex workloads that are notoriously difficult to manage. Additionally, RDBMSs have many “knobs” for managing workloads efficiently. These knobs affect the performance of query workloads in complex interrelated ways and require expert manual attention to change. It often takes a long time for a performance expert to get enough experience with a large war...

This paper aims to describe the data warehousing process for the Pharmaceutical and the Healthcare industries. We will first examine the reasons and needs for the data warehouses and the expected benefits. Based on this, a general process for data warehousing emerges that utilizes a host of tools and techniques. These are then illustrated by two case studies as follows: (1) A Clinical Trials Da...

Yet, persistence of redundant data in Data Warehouses is often simply justified with an achievement of better performance when accessing data for analysis and reporting. Especially in Enterprise Data Warehouse systems, data management via multiple persistence levels is necessary to condition the huge amount of data into an adequate format for its final usage. However, there are further reasons ...

ETL (extraction, transformation, and loading) and data staging processes in Enterprise Data Warehouses have always been critical due to their consumption of time and resources. Mostly, the staging processes are accompanied with persistent storage of transformed data to enable a reasonable performance when accessing for analysis and other purposes. The persistence of – often redundant – data req...