We consider a one-warehouse, N-identical-retailer model. Random demands occur at the retailers with complete backlogging. The retailers replenish their inventories from the warehouse, which in turn orders from an outside supplier with unlimited stock. Each retailer places an order every N periods according to a base-stock policy, and the reorder intervals of the retailers are staggered so that ...

The use of materialized views in a data warehouse installation is a common tool to speed up mostly aggregation queries. The problems coming along with materialized aggregate views have triggered a huge variety of proposals, such as picking the optimal set of aggregation combinations, transparently rewriting user queries to take advantage of the summary data, or synchronizing pre-computed summar...

Data in a warehouse can be perceived as a collection of materialized views that are generated as per the user requirements specified in the queries being generated against the information contained in the warehouse. User requirements and constraints frequently change over time, which may evolve data and view definitions stored in a data warehouse dynamically. The current requirements are modifi...

We consider a periodic-review inventory system in which multiple non-identical retailers replenish from a warehouse, which further replenishes from an outside ample source. Each facility faces Poisson customer demand and replenishes according to a base-stock policy in a fixed time interval. There are fixed costs incurred for placing an order. The warehouse fills the retailers’ orders in the sam...

In a large data warehouse, thousands of jobs run during each cycle in dozens of subject areas. Many of the data warehouse tables are quite large and they need to be refreshed at the right time, several times a day, to support strategic business decisions. To enable cycles to run more frequently and keep the data warehouse environment stable the database system’s resource utilization must be opt...

Warehouse of Company X has two production supply destinations, TFD 315 and 500. One the destinations a high workload for forklift driver. It happened because long distance when doing material handling. Warehouse’s layout company is not optimal that causing huge handling costs. So, relayout facilities done in order to reduce costs by shortening between based on relationship activities. The stage...

This paper develops simple approximate methods to analyze a two-stage stochastic distribution system consisting of one warehouse and multiple retailers. We consider local and central control schemes. The main ideas are based on relaxing and or decomposing the system into more manageable newsvendor type subsystems. We provide bounds on optimal echelon base-stock levels and on the optimal expecte...

The emergence of new higher education institutions has created the competition in higher education market, and data warehouse can be used as an effective technology tools for increasing competitiveness in the higher education market. Data warehouse produce reliable reports for the institution’s high-level management in short time for faster and better decision making, not only on increasing the...