How to provide construction managers with information about and insight into the existing data so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system is a problem during the construction management process. To solve this problem, the integration of a Data Warehouse and a Decision Support System (DSS) seems to be efficient. ...

Data warehouse systems are used for decision-making purposes. The Online Analytical Processing (OLAP) tools are commonly used to query and analysis of results on such systems. It is complex task for non-technical users (executives, managers etc.,) to query the data warehouse using OLAP tool keeping in view the schema knowledge. For such data warehouse users, a natural language interface is a vi...

A data warehouse (DW) is a database used for reporting Paper describes Object Oriented Data Warehousing using a narrower compassed data model. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the Data warehousing for reporting. An Object Oriented Data Warehouse system includes a d...

Although many data warehouse systems have been developed in recent years, the practice of data warehouse is still immature. Most of current systems have some limitations in terms of flexibility, efficiency and scalability. Furthermore, the contents of a data warehouse are becoming a large and messy jungle. It is difficult to maintain and analyze the data. Much research has been done in data mar...

Traditional enterprise warehouse solutions center around an analytical database system that is monolithic and inflexible: data needs to be extracted, transformed, and loaded into the rigid relational form before analysis. It takes years of sophisticated planning to provision and deploy a warehouse; adding new hardware resources to an existing warehouse is an equally lengthy and daunting task. A...

Determining the optimal storage assignment for products in a dedicated warehouse has been addressed extensively in the Facility Logistics literature. However, the process of implementing a particular storage assignment given the current location of products has not received much attention in the existing literature. Typically, warehouses use downtime or overtime to remove products from their cu...

The input data of the corporate data warehouse is provided by the data sources, that are integrated. In the temporal database research area, a bitemporal database is a database supporting valid time and transaction time. Valid time is the time when the fact is true in the modeled reality, while transaction time is the time when the fact is stored in the database. Defining a data warehouse as a ...

The study investigates the practice of data warehouse system selection decisions for small and medium-sized enterprises (SMEs) and large enterprises (LEs) in Taiwan. The increasing number of companies looking for data warehousing solutions to gain a significant business advantage has created a need for systematic method for choosing appropriate data warehouse system. The aim of this study is to...

Warehouse operational costs are heavily influenced by the efficiency in which workers are able to traverse the warehouse and gather items on orders around the warehouse that must be shipped to customers; this action accounts for over 50% of warehouse operations expenses. The act of traversing the warehouse is greatly optimized by following a designated pick path; however, algorithms for pick pa...

− Previous research has provided metadata models that enable the capturing of the static components of a data warehouse architecture, along with information on different quality factors over these components. This paper complements this work with the modeling of the dynamic parts of the data warehouse. The proposed metamodel of data warehouse operational processes is capable of modeling complex...