Using SLP method obtains the comprehensive correlation through analysis of logistics relationship and non-logistics between various operating units warehouse. According to current situation related warehouse problem, designers can formulate a feasible plan. However, owing is insufficient in solving problem facility layout, that is, it easy be influenced by subjective factors designer, especiall...

A data warehouse is an integrated and timevarying collection of data derived from operational data and primarily used in strategic decision making by means of online analytical processing (OLAP) techniques. Although it is generally agreed that warehouse design is a non-trivial problem and that multidimensional data models and star or snowflake schemata are relevant in this context, hardly any m...

We consider a real-world problem arising in a warehouse for spare parts. Items ordered by customers shall be collected and for this purpose our task is to determine efficient pickup tours within the warehouse. The algorithm we propose embeds a dynamic programming algorithm for computing individual optimal walks through the warehouse in a general variable neighborhood search (VNS) scheme. To enh...

We investigate the problem of storage assignment in a warehouse served by milkrun logistics, i.e. vehicles circulating according to a pre-defined schedule between the warehouse and the production facilities of the plant. Such a logistic system results in an easy-to-characterize correlation among the request probabilities of the items in the warehouse. A MIP model is proposed that exploits this ...

Effective analysis of genome sequences and associated functional data requires access to many different kinds of biological information. A data warehouse [14,16] plays an important role for storage and analysis for genome sequence and functional data. A data warehouse stores lots of materialized views to provide an efficient decision-support or OLAP queries. The view-selection problem addresses...

Data warehouses collect copies of information from remote sources into a single database. Since the remote data is cached at the warehouse, it appears as local relations to the users of the warehouse. To improve query response time, the warehouse administrator will often materialize views defined on the local relations to support common or complicated queries. Unfortunately, the requirement to ...

This paper introduces an integrated approach for solving the Period Vehicle Routing Problem with Simultaneous Delivery and Pickup (PVRPSDP). The problem considers a dis tribution system consisting of a warehouse and many dispersed location retailers, where each of which having two type of demands to be delivered and collected, respectively. A fleet of capacitated vehicle is employed for deliver...

Data warehouse refreshment is often viewed as a problem of maintaining materialized views over operational sources. In this paper, we show that the data warehouse refreshment process is a complex process comprising several tasks, e.g., monitoring, extracting, transforming, integrating and cleaning operational data, deriving new data, building histories and loading the data warehouse. We propose...

In this study a hybrid (including qualitative and quantitative objectives) fuzzy multi objective nonlinear programming (H-FMONLP) model with different goal priorities will be developed for aggregate production planning (APP) problem in a fuzzy environment. Using an interactive decision making process the proposed model tries to minimize total production costs, carrying and back ordering costs a...