Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...

This paper describes a decision support system (DSS) for use in allocating scarce resources associated with data quality efforts in the construction of a data warehouse. The DSS is populated with metadata from a data warehouse project, including tags that identify the quality at intersections of data field, data use, and data dimension. The resulting DSS can then be queried by novices on a data...

Thanks to Web 2.0 and socio-technical environments, we need to shift the paradigm in current conceptual framework for interactive systems from professionally dominated cultures to democratized design cultures. With this paradigm shift, it requires us to use better output filters. I have addressed the mechanisms to build effective output filters and the ways to increase the social creativity of ...

In this chapter, we present the Multimodal Warehouse Project, which aimed at applying multimodal interaction to a warehouse picking process. We provide an overview of the warehouse picking procedure as well as the overall architecture of the multimodal picking application and technologies applied to design the application. Furthermore, we describe the execution of user tests of the picking appl...

Based on an actual dataset of college human resources, we analyzed the data warehouse technologies and combined them with the pracical work. The snowflake structure has been described about a data warehouse of university human resource and the data warehouse has been constructed. This paper reduces and categorizes features by explorative data analysis. When the data warehouse had built and appl...

Current data warehouse and OLAP technologies are applied to analyze the structured data that companies store in databases. The context that helps to understand data over time is usually described separately in text-rich documents. This paper proposes to integrate the traditional corporate data warehouse with a document warehouse, resulting in a contextualized warehouse. Thus, the user first sel...

Market competition requires continuous improvement in the design and operation of supply chains. Warehouse management is a field of interest for both practitioners and researchers and involves material, information and financial flow management in a highly dynamic environment. Designing and planning a warehouse (distribution centre) involve different levels of decisionmaking, with high levels o...

An extensive review on warehouse operation planning problems is presented. The problems are classified according to the basic warehouse functions, i.e., receiving, storage, order picking, and shipping. The literature in each category is summarized with an emphasis on the characteristics of various decision support models and solution algorithms. The purpose is to provide a bridge between academ...

Data warehouse systems offer novel techniques and services for data-rich applications both from a data modeling and a data processing point of view. In this paper, we investigate how well state-of-the-art concepts fulfill the requirements of real-world data warehouse applications. Referring to a concrete example from the market research area, key problems with current approaches are identified ...

Information requirements analysis for data warehouse systems differs significantly from requirements analysis for conventional information systems. Existing data warehouse specific approaches are reviewed. A comprehensive methodology that supports the entire process of determining information requirements of data warehouse users, matching information requirements with actual information supply,...