User participation has become paramount for any successful data warehouse initiative. In this paper, we present MD2, a tool based on the dimensional data modeling approach, which facilitates the user participation in the development of a data warehouse application. MD2 assists users on identifying their analytical needs in order to help data warehouse designers to better specify business requir...

E-Business have a variety of on-line transaction processing (OLTP) systems and operational database. Data Warehouse is different from operational database. A data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data in support of management's decision-making process. The features of Data Warehouse cause the its design process and strategies to be differ...

The data warehousing approach intends to exploit a very large volume of data to make relevant decisions. In this paper, we deal with objectoriented data warehouse design. More precisely, we present an object-oriented data warehouse model, integrating temporal and archive data. We provide functions allowing the administrator to specify a data warehouse from a global source schema.

This paper addresses a multiperiod integrated model that plans deliveries to customers based upon inventories (at warehouse and customer locations) and vehicle routes. The model determines replenishment quantities and intervals at the warehouse, and distribution lots and delivery routes at customer locations. We investigate coordination of customer and warehouse replenishment decisions and illu...

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

The bottleneck of a data warehouse implementation is the ETL (extraction, transformation, and load) process, which carries out the initial population of the data warehouse and its further (usually periodical) updates. There is a number of software products supporting the OLAP analysis. However, the ETL process implementation is not repeatable in a significant way. This paper reports on a resear...

Science and technology in Brazil are areas that have few available resources and many times these scarce resources are badly used. The data warehouse is a tool that can make possible a better distribution of these resources. In this article are considered some issues in the development of a data warehouse for Science & Technology management. The paper describes the necessity of a supporting sys...

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

Aiming at the problems in the management and sharing research of antique information, this paper discussed the necessity to build antique information distributed data warehouse. The data warehouse architecture and the multidimensional data model were put forward, by usingonline analysis processing (OLAP) the multidimensional analysis of antique distributed data warehouse was presented, and a mu...