A data warehouse is a data repository which collects and maintains a large amount of data from multiple distributed, autonomous and possibly heterogeneous data sources. Often the data is stored in the form of materialized views in order to provide fast access to the integrated data. One of the most important decisions in designing a data warehouse is the selection of views for materialization. ...

Multi-item inventory model for deteriorating items with stock dependent demand under two-warehouse system is developed in fuzzy environment (purchase cost, investment amount and storehouse capacity are imprecise ) under inflation and time value of money. For display and storage, the retailers hire one warehouse of finite capacity at market place, treated as their own warehouse (OW), and another...

Multi-robot task assignment is one of the main processes in an intelligent warehouse. This paper models multi-robot warehouse as open-path multi-depot asymmetric traveling salesman problem (OP-MATSP). A two-objective integer linear programming (ILP) model for solving OP-MDTSP proposed. The theoretical bound on computational time complexity this O(n!). We can solve small by ILP using Gurobi solv...

The objective of most users for consulting any information database, information warehouse or the internet is to resolve one problem or the other. Available online or offline annotation tools were not conceived with the objective of assisting users in their bid to resolve a decisional problem. Apart from the objective and usage of annotation tools, how these tools are conceived and classified h...

Abstract— The development and use of technological innovations have changed people's behavior from an industrial society to information society. It can be seen in the increase consumption patterns trading through physical stores (offline) electronic systems, often referred as e-commerce. Logistics services are distribution actors downstream line which tasked with delivering products fulfillment...

Using appropriate metadata is a central success factor for (re)engineering and using data warehouse systems effectively and efficiently. The approach presented in this paper aims to reduce the effort in developing and operating data warehouse systems and thus to increase the ability and acceptance of a data warehouse. To achieve these objectives identifying the appropriate metadata is an import...

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...

Problem statement: The Data Warehouse is a database dedicated to the storage of all data used in the decision analysis, it meets the customer requirements, to ensure, in time, that a data warehouse complies with the rules of construction and manages the evolutions necessary of the information system (IS). Results: According to the studies carried out, we see that a system based on a data wareho...

In an e-retailing setting, the efficient utilization of inventory, storage space, and labor is paramount to achieving high levels of customer service and company profits. To optimize the storage space and labor, a retailer will split the warehouse into two storage regions with different densities. One region is for picking customer orders and the other to hold reserve stock. As a consequence, t...

In this paper, a multi-product continuous review inventory control problem within the batch arrival queuing approach (M/M/1) is modeled to find the optimal quantities of the maximum inventory. The objective function is to minimize the total costs of ordering, holding and shortage under warehouse space and service level, and expected lost-sales shortage cost constraints from retailer and warehou...