Clustering-Based Materialized View Selection in Data Warehouses

Materialized view selection is a non-trivial task. Hence, its complexity must be reduced. A judicious choice of views must be cost-driven and influenced by the workload experienced by the system. In this paper, we propose a framework for materialized view selection that exploits a data mining technique (clustering), in order to determine clusters of similar queries. We also propose a view merging algorithm that builds a set of candidate views, as well as a greedy process for selecting a set of views to materialize. This selection is based on cost models that evaluate the cost of accessing data using views and the cost of storing these views. To validate our strategy, we executed a workload of decision-support queries on a test data warehouse, with and without using our strategy. Our experimental results demonstrate its efficiency, even when storage space is limited

Tracking Chart 2010 Jostens, Inc. (Factory 2), United States

This document is part of a digital collection provided by the Martin P. Catherwood Library, ILR School, Cornell University, pertaining to the effects of globalization on the workplace worldwide. Special emphasis is placed on labor rights, working conditions, labor market changes, and union organizing.FLA_2010TrackingChart_JostensIncFactory2.pdf: 143 downloads, before Oct. 1, 2020

The Role of Maintenance and Facility Management in Logistics: A Literature Review

Purpose - The purpose of this paper is to provide a literature review on the different ways of carrying out Facility Management and related topics in order to uncover that there is limited research regarding the impact of Facility Management on the logistics and operational performance of warehouses. Design/methodology/approach - Four different focus areas have been identified and for each one different methodologies and streams of research have been studied. Findings - The study underlines the importance of Facility Management for the logistics operations; therefore it supports the notion that investments aiming at preserving the status of the building and service components of warehouses are crucial. Originality/value - This paper aims to suggest to Facility Management managers that they can contribute to enhance business performance by designing effective Facility Management strategie

The developing field of integrated vehicle health management

The goals that are being set for aviation growth in the near future, combined with the growth in service provision, are unattainable without active health management of airplanes. Numbers associated with door to door travel time and accident rates, coupled with availability demands to provide cost-effective transport, simply do not allow time for unscheduled maintenance. We are therefore going to experience a step jump in the take up of Integrated Vehicle Health Management (IVHM) on these platforms in order to give accurate warning of sub-system and component degradation, allowing for maintenance to be carried out in a timely, scheduled, manner. This paper describes the development of IVHM, covering emerging services, standards, technology and IVHM as used in various industry sectors. This will lead to the commercial picture of today with the top level goals that are being set, providing the business push for technology and its adoption. Examples of research being conducted in the field will be shown, to support the claim that real progress is being made, with implementation of this technology on the horizon.http://www.aerojournalindia.com/journal.htm

Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses

A data warehouse integrates large amounts of extracted and summarized data from multiple sources for direct querying and analysis. While it provides decision makers with easy access to such historical and aggregate data, the real meaning of the data has been ignored. For example, "whether a total sales amount 1,000 items indicates a good or bad sales performance" is still unclear. From the decision makers' point of view, the semantics rather than raw numbers which convey the meaning of the data is very important. In this paper, we explore the use of fuzzy technology to provide this semantics for the summarizations and aggregates developed in data warehousing systems. A three layered data warehouse semantic model, consisting of quantitative (numerical) summarization, qualitative (categorical) summarization, and quantifier summarization, is proposed for capturing and explicating the semantics of warehoused data. Based on the model, several algebraic operators are defined. We also extend the SQL language to allow for flexible queries against such enhanced data warehouses