Materialized view selection under the maintenance time constraint

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. The objective is to select an appropriate set of views that minimizes the total query response time with the constraint that the total maintenance time for these materialized views is within a given bound. This view selection problem is totally different from the view selection problem under the disk space constraint. In this paper the view selection problem under the maintenance time constraint is investigated. Two efficient, heuristic algorithms for the problem are proposed. The key to devising the proposed algorithms is to define good heuristic functions and to reduce the problem to some well-solved optimization problems. As a result, an approximate solution of the known optimization problem will give a feasible solution of the original problem. (C) 2001 Elsevier Science B.V. All rights reserved.

Effects of maintenance management procedures in sugarcane mechanic harvesting system equipment

ABSTRACT The aim of this study was to evaluate the effects of modifying the maintenance programming of equipment used in sugarcane mechanical harvesting, by transferring actions that can be planned to periods when machines are inactive due to meal breaks and other working shift transitions stoppages. A simulation model was developed to represent the maintenance procedures of combines, haulouts, and other vehicles used by a harvest team. Scenarios were tested using alternatives for interventions such as refueling, lubrication and harvester blade replacement, enabling strategies to be focused towards better utilization of cutting, loading, and transport (CLT) system equipment. As a result, it was possible to remove one combine and two haulouts, while maintaining current daily production. The maintenance time for harvesters, which refers to corrective maintenance and the transfer of remaining interventions for periods of inactivity, was reduced from 10.0% to 3.5% over the useful period. This study indicates that maintenance management in the sugarcane sector enables the expanded use of equipment, leading to the greater productivity of the CLT system.

Optimal maintenance policies under different operational schedules

In the reliability literature, maintenance time is usually ignored during the optimization of maintenance policies. In some scenarios, costs due to system failures may vary with time, and the ignorance of maintenance time will lead to unrealistic results. This paper develops maintenance policies for such situations where the system under study operates iteratively at two successive states: up or down. The costs due to system failure at the up state consist of both business losses & maintenance costs, whereas those at the down state only include maintenance costs. We consider three models: Model A, B, and C: Model A makes only corrective maintenance (CM). Model B performs imperfect preventive maintenance (PM) sequentially, and CM. Model C executes PM periodically, and CM; this PM can restore the system as good as the state just after the latest CM. The CM in this paper is imperfect repair. Finally, the impact of these maintenance policies is illustrated through numerical examples.

The impact of time limitation: insights from a queueing experiment

We experimentally explore the effects of time limitation on decision making. Under different time allowance conditions, subjects are presented with a queueing situation and asked to join one of the two given queues. The results can be grouped under two main categories. The first one concerns the factors driving decisions in a queueing system. Only some subjects behave consistently with rationality principles and use the relevant information efficiently. The rest of the subjects seem to adopt a simpler strategy that does not incorporate some information into their decision. The second category is related to the effects of time limitation on decision performance. A substantial proportion of the population is not affected by time limitations and shows consistent behavior throughout the treatments. On the other hand, some subjects’ performance is impaired by time limitations. More importantly, this impairment is not due to the stringency of the limitation but rather to being exposed to a time constraint.

Automated generic integration of flight logbook data into aircraft maintenance systems

The automated transfer of flight logbook information from aircrafts into aircraft maintenance systems leads to reduced ground and maintenance time and is thus desirable from an economical point of view. Until recently, flight logbooks have not been managed electronically in aircrafts or at least the data transfer from aircraft to ground maintenance system has been executed manually. Latest aircraft types such as the Airbus A380 or the Boeing 787 do support an electronic logbook and thus make an automated transfer possible. A generic flight logbook transfer system must deal with different data formats on the input side – due to different aircraft makes and models – as well as different, distributed aircraft maintenance systems for different airlines as aircraft operators. This article contributes the concept and top level distributed system architecture of such a generic system for automated flight log data transfer. It has been developed within a joint industry and applied research project. The architecture has already been successfully evaluated in a prototypical implementation.

An integrated approach for distributed energy resource short term scheduling in smart grids considering realistic power system simulation

The large increase of distributed energy resources, including distributed generation, storage systems and demand response, especially in distribution networks, makes the management of the available resources a more complex and crucial process. With wind based generation gaining relevance, in terms of the generation mix, the fact that wind forecasting accuracy rapidly drops with the increase of the forecast anticipation time requires to undertake short-term and very short-term re-scheduling so the final implemented solution enables the lowest possible operation costs. This paper proposes a methodology for energy resource scheduling in smart grids, considering day ahead, hour ahead and five minutes ahead scheduling. The short-term scheduling, undertaken five minutes ahead, takes advantage of the high accuracy of the very-short term wind forecasting providing the user with more efficient scheduling solutions. The proposed method uses a Genetic Algorithm based approach for optimization that is able to cope with the hard execution time constraint of short-term scheduling. Realistic power system simulation, based on PSCAD , is used to validate the obtained solutions. The paper includes a case study with a 33 bus distribution network with high penetration of distributed energy resources implemented in PSCAD .

Generating timed trajectories foran autonomous robot

Tese de Doutoramento Programa Doutoral em Engenharia Electrónica e Computadores

Ohjelmistotestauksen käytänteet Suomessa

Ohjelmistotestauksen merkitys on kasvanut sen mukaan mitä enemmän ohjelmisto-tuotteet vaikuttavat jokapäiväisesseen elämämme. Tämän vuoksi yritysten investointien ja laadunvarmentamisen yhteys on ilmeinen. Organisaatiot panostavat yhä enemmän ei–funktionaaliseen testaukseen, kuten turvallisuuden, suorituskyvyn ja käytettävyyden testaamiseen. Tämän työn tarkoituksena on tutkia ohjelmistotestauksen nykytilannetta Suomessa. Syy tähän on uudistaa ja parantaa ohjelmistotestauksen kurssitarjontaa Turun yliopistossa vastaamaan parhaalla mahdollisella tavalla yritysten tarvetta. Opinnäyte on toteutettu replikaatio-tutkimuksena. Pääosa kyselystä sisältää kysymyksiä ohjelmistotestauksen menetelmistä ja työkaluista testausprosessin toimintojen aikana. Lisäksi on yleisiä kysymyksiä yrityksistä ja niiden ohjelmistotestausympäristöistä. Kyselyssä otetaan myös kantaa yritysten käyttämiin monenlaisiin testaus-tasoihin, -tyyppeihin ja testauksessa kohdattuihin haasteisiin. Tämä opinnäyte perustuu testausprosessistandardeihin. Ohjelmistotestausstandardit ovat keskeisessä asemassa tässä työssä, vaikka ne ovat olleet viime aikoina vahvan kritiikin kohteena. Epäilys standardien välttämättömyyteen on syntynyt muutoksista ohjelmistokehityksessä. Tämä työ esittelee tulokset ohjelmistotestauksen käytännöistä. Tuloksia on verrattu aiheeseen liittyvän aiemman kyselyn (Lee, Kang, & Lee, 2011) tuloksiin. Ajanpuutteen havaitaan olevan suuri haaste ohjelmistotestauksessa. Ketterä ohjelmistokehitys on saavuttanut suosiota kaikissa vastaajien yrityksissä. Testauksen menetelmät ja työkalut testauksen arviointiin, suunnitteluun ja raportointiin ovat hyvin vähäisessä käytössä. Toisaalta testauksen menetelmien ja työkalujen käyttö automaattiseen testauksen toteuttamiseen ja virheiden hallintaan on lisääntynyt. Järjestelmä-, hyväksyntä-, yksikkö- ja integraatiotestaus ovat käytössä kaikkien vastaajien edustamissa yrityksissä. Kaikkien vastaajien mielestä regressio- sekä tutkiva- ja ei-funktionaalinen testaus ovat tärkeitä tekniikoita.

Interactions sociales et réseaux sociaux en économique : modélisation et estimation

Cette thèse comporte trois essais sur les interactions sociales en sciences économiques. Ces essais s’intéressent à la fois au côté théeorique qu’empirique des interactions sociales. Le premier essai (chapitre 2) se concentre sur l’étude (théorique et empirique) de la formation de réseaux sociaux au sein de petites économies lorsque les individus ont des préférences homophilique et une contrainte de temps. Le deuxième essai (chapitre 3) se concentre sur l’étude (principalement empirique) de la formation de réseau sociaux au sein de larges économies où les comportement d’individus très distants sont aproximativement indépendants. Le dernier essai (chapitre 4) est une étude empirique des effets de pairs en éducation au sein des écoles secondaires du Québec. La méthode structurelle utilisée permet l’identification et l’estimation de l’effet de pairs endogène et des effets de pairs exogènes, tout en contrôlant pour la présence de chocs communs.

Museum robots: multi-robot systems for public exhibition

Mobile robots provide a versatile platform for research, however they can also provide an interesting educational platform for public exhibition at museums. In general museums require exhibits that are both eye catching and exciting to the public whilst requiring a minimum of maintenance time from museum technicians. In many cases it is simply not possible to continuously change batteries and some method of supplying continous power is required. A powered flooring system is described that is capable of providing power continuously to a group of robots. Three different museum exhibit applications are described. All three robot exhibits are of a similar basic design although the exhibits are very different in appearance and behaviour. The durability and versatility of the robots also makes them extremely good candidates for long duration experiments such as those required by evolutionary robotics.

Recurring themes in value management practice

This paper reports on a survey of 17 value management exercises recently carried out within the UK construction industry. Twelve leading value management practitioners were asked to describe an example of a value management study which ‘worked well’ and one which ‘did not work well’. They were further asked to explain the underlying factors which they considered had influenced the eventual outcome of the value management study. The subsequent analysis of the interview transcripts reveals six recurring themes which were held to have had a significant influence: expectations, implementation, participation, power, time constraint and uncertainty. Whilst caution is necessary in extracting the themes from their individual contexts, they do provide a valuable insight into the factors which influence the outcome of value management studies.

Constraining the age of the iporanga formation with SHRIMP U-Pb zircon: Implications for possible ediacaran glaciation in the Ribeira Belt, SE Brazil

The Ribeira belt in SE Brazil is a Neoproterozoic to Early Palaeozoic orogen, whose architecture and history is not yet fully understood. The depositional age of many of the sedimentary sequences in the Ribeira Belt remains unconstrained, and with debate concerning their depositional environment and tectonic setting. In this paper we present SHRIMP zircon U/Pb age constraints for one such problematic unit in the Ribeira Belt the lporanga Formation - and discuss the significance of this age with regards to the timing of Neoproterozoic glacial events in southeast Brazil. Using a felsic volcanic unit immediately under the lporanga Formation and granite cobbles from breccias in its basal parts a reconnaissance SHRIMP U/Pb zircon maximum depositional age of 580 Ma is assigned for the base of this unit. This age is marginally younger than the 625605 Ma ages for intrusions into the Lajeado and Ribeira subgroups, with which the lporanga Formation is in tectonic contact. This indicates that the Lajeado and Ribeira subgroups are not stratigraphically equivalent to the lporanga Formation, as thought previously by some workers. The maximum depositional age of 580 Ma also places a maximum time constraint on the tectonic juxtaposition of the lporanga Formation with other supracrustal units, and on the greenschist facies metamorphism and isoclinal folding that affected it. The potential glacial origin for the lporanga Formation, if correct, would place it in the late Ediacaran - provisionally equivalent to the Gaskiers glaciation. (c) 2007 International Association for Gondwana Research. Published by Elsevier B.V. All rights reserved.

Photovoltaic System Design for a Contaminated Area in Falun – Comparison of South and East- West Layout

In this thesis the solar part of a large grid-connected photovoltaic system design has been done. The main purpose was to size and optimize the system and to present figures helping to evaluate the prospective project rationality, which can potentially be constructed on a contaminated area in Falun. The methodology consisted in PV market study and component selection, site analysis and defining suitable area for solar installation; and system configuration optimization based on PVsyst simulations and Levelized Cost of Energy calculations. The procedure was mainly divided on two parts, preliminary and detailed sizing. In the first part the objective was complex, which included the investigation of the most profitable component combination and system optimization due to tilt and row distance. It was done by simulating systems with different components and orientations, which were sized for the same 100kW inverter in order to make a fair comparison. For each simulated result a simplified LCOE calculation procedure was applied. The main results of this part show that with the price of 0.43 €/Wp thin-film modules were the most cost effective solution for the case with a great advantage over crystalline type in terms of financial attractiveness. From the results of the preliminary study it was possible to select the optimal system configuration, which was used in the detailed sizing as a starting point. In this part the PVsyst simulations were run, which included full scale system design considering near shadings created by factory buildings. Additionally, more complex procedure of LCOE calculation has been used here considered insurances, maintenance, time value of money and possible cost reduction due to the system size. Two system options were proposed in final results; both cover the same area of 66000 m2. The first one represents an ordinary South faced design with 1.1 MW nominal power, which was optimized for the highest performance. According to PVsyst simulations, this system should produce 1108 MWh/year with the initial investment of 835,000 € and 0.056 €/kWh LCOE. The second option has an alternative East-West orientation, which allows to cover 80% of occupied ground and consequently have 6.6 MW PV nominal power. The system produces 5388 MWh/year costs about 4500,000 € and delivers electricity with the same price of 0.056 €/kWh. Even though the EW solution has 20% lower specific energy production, it benefits mainly from lower relative costs for inverters, mounting and annual maintenance expenses. After analyzing the performance results, among the two alternatives none of the systems showed a clear superiority so there was no optimal system proposed. Both, South and East-West solutions have own advantages and disadvantages in terms of energy production profile, configuration, installation and maintenance. Furthermore, the uncertainty due to cost figures assumptions restricted the results veracity.

A confusão no processo de escolha do consumidor

Dentro da literatura de Comportamento do Consumidor e Teoria da Decisão existe considerável corpo teórico que analisa sentimentos negativos e reações adversas no processo decisório de compras de produtos de alto e baixo envolvimento. Vários fenômenos são identificados como negativos no processo, principalmente a Confusão do Consumidor, que compreende três dimensões: i) muitas informações similares sobre produtos, ii) muitas informações sobre diferentes produtos e iii) informações falsas e ambíguas. Tal fenômeno, no entanto, parece ser moderado por um conjunto de variáveis, como o Envolvimento, a Experiência e a Restrição de Tempo (moderadoras da relação entre Confusão do Consumidor e Intenção de Compra). Este fato foi identificado através de entrevistas em profundidade. Os resultados das entrevistas permitiram identificar as variáveis moderadoras, assim como a existência do fenômeno e sua relação com a decisão final de compra. Na segunda fase da pesquisa, supõe-se que indivíduos com baixo Envolvimento e Restrição de Tempo possuam uma propensão maior à confusão. No Estudo 2 foram utilizados como moderadores o Envolvimento e a Restrição de Tempo, ambos manipulados por instrução, sendo as variáveis dependentes a Intenção de Compra e a Confusão do Consumidor. Os resultados do Estudo 2 permitiram inferir que existem diferenças significativas entre os grupos, quando analisada a variável Confusão do Consumidor, mas, em alguns grupos, a Intenção de Compra não era significativamente diferente. No Estudo 3 foram manipuladas a Experiência (forte e fraca) e a Confusão do Consumidor, sendo a variável dependente a Intenção de Compra. Os resultados do Estudo 3 também permitiram inferir que existem diferenças significativas entre os grupos na Intenção de compra, quando consideradas baixa ou alta confusão, assim como Experiência forte ou fraca. Na última fase da pesquisa foram destacadas as estratégias dos consumidores para lidar com o fenômeno Confusão do Consumidor. Tais estratégias, muitas vezes, são mediadoras de comportamentos posteriores, como a compra do produto. No Estudo 4 manipulou-se a Confusão do Consumidor em duas de suas dimensões. Foi possível destacar a preponderância da estratégia por busca de informações e postergação da decisão, quando o consumidor se depara com situações confusas.

Análise crítica dos produtos de mobilidade sentada - cadeiras de rodas - utilizados por crianças e adolescentes com paralisia cerebral em Natal/RN e outros municípios do Rio Grande do Norte

The objective of this work is to critically analyze the seated mobility adaptive equipment, wheelchair, used by non-ambulatory children/adolescents diagnosed with cerebral palsy of the quadriplegy type with ages in between 0-18 years old in the municipal city of Natal/RN and of other ones in the state of Rio Grande do Norte. This study is characterized as descriptive as it took into consideration the individualized conditions of each child/adolescent and of their home environment, and also evaluates the condition of the used seated mobility devices such as wheelchairs or strollers. Thirty three (33) subjects which had a wheelchair prescribed by a healthcare professional specialist in adaptive equipment within the past 3 years were selected. A questionnaire was applied through a phone with the patient s primary care giver or parents. The results obtained showed that all the equipment being used had an anatomical seat and back and the tilt system mechanism and even though most of the patients required small individual adjustments upon receiving the wheelchair in order to accommodate to the patients characteristics. From the point of view of the caregiver/parents interviewed, 97% described satisfied with the equipment and report assistance with mobility (97%), comfort (82%) and good posture (82%) as the main positive aspects from the equipment. The results also describe the aspects related to the maintenance, time used and activities developed that were reported by the patients. The conclusion therefore is that in order to select the equipment to meet the needs of the consumer it is necessary that: an appropriate wheelchair prescription takes place, the up-to-date knowledge of equipment available in the market, the appropriate use of the resources from the concession programs of the government that purchase equipment and the establishment of link in between the manufacturers, patients and the caregivers