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.

Design of a polyepitope construct for the induction of HLA-A0201-restricted HIV 1-specific CTL responses using HLA-A*0201 transgenic, H-2 class IKO mice

HLA-A*0201 transgenic, H-2D(b)/mouse beta2-microglobulin double-knockout mice were used to compare and optimize the immunogenic potential of 17HIV 1-derived, HLA-A0201-restricted epitopic peptides. A tyrosine substitution in position 1 of the epitopic peptides, which increases both their affinity for and their HLA-A0201 molecule stabilizing capacity, was introduced in a significant proportion, having verified that such modifications enhance their immunogenicity in respect of their natural antigenicity. Based on these results, a 13-polyepitope construct was inserted in the pre-S2 segment of the hepatitis B middle glycoprotein and used for DNA immunization. Long-lasting CTL responses against most of the inserted epitopes could be elicited simultaneously in a single animal with cross-recognition in several cases of their most common natural variants.

Expert system application on preliminary design of water retaining structures

Design of liquid retaining structures involves many decisions to be made by the designer based on rules of thumb, heuristics, judgment, code of practice and previous experience. Various design parameters to be chosen include configuration, material, loading, etc. A novice engineer may face many difficulties in the design process. Recent developments in artificial intelligence and emerging field of knowledge-based system (KBS) have made widespread applications in different fields. However, no attempt has been made to apply this intelligent system to the design of liquid retaining structures. The objective of this study is, thus, to develop a KBS that has the ability to assist engineers in the preliminary design of liquid retaining structures. Moreover, it can provide expert advice to the user in selection of design criteria, design parameters and optimum configuration based on minimum cost. The development of a prototype KBS for the design of liquid retaining structures (LIQUID), using blackboard architecture with hybrid knowledge representation techniques including production rule system and object-oriented approach, is presented in this paper. An expert system shell, Visual Rule Studio, is employed to facilitate the development of this prototype system. (C) 2002 Elsevier Science Ltd. All rights reserved.

The effects of level of dietary protein on the milk production and rumen physiology of dairy cows fed a diet based on a tropical grass hay

zFour rumen-fistulated, multiparous Holstein-Friesian cows in early lactation were offered mixed diets based on rhodes grass hay (Chloris gayana) cv. Callide containing 13, 14, 15 or 16% crude protein (CP) on a dry matter basis, in a 4 x 4 latin square design. The estimated undegradable protein concentration in these diets was similar with rumen degradable protein concentration varying. Cows fed a diet containing 13% CP had lower (P = 0.07) milk yields than cows in other treatments (20.4 vs 21.9, 22.0 and 22.2 L/d for 13, 14, 15 and 16% CP, respectively). A positive linear relationship was found (P = 0.06) between organic matter intake and dietary CP%. There were negative linear relationships between dietary CP% and digestibilities of dry matter (P = 0.09), organic matter (P = 0.06) and neutral detergent fibre (P = 0.02). Feeding a diet containing 13% CP resulted in significantly lower (P = 0.001) molar proportions (%) of rumen valerate in comparison with other treatments. The molar proportions of isovalerate differed (P = 0.001) between treatments (0.66, 0.78, 0.89 and 1.04%) for 13, 14, 15 and 16% CP, respectively). Dietary protein level had no effect on rates of passage, in situ digestion of rhodes grass hay or ratios of allantoin: creatinine in urine. These data showed that increasing the dietary CP concentration of lactating cows fed diets based on rhodes grass hay increased intakes and not significantly improved at dietary CP concentrations above 14% DM.

Oxide ionic conductivity and microstructures of Sm- or La-doped CeO2-based systems

The concept of crystallographic index termed the effective index is suggested and applied to the design of ceria (CeO2)-based electrolytes to maximize oxide ionic conductivity. The suggested index considers the fluorite structure, and combines the expected oxygen vacancy level with the ionic radius mismatch between host and dopant cations. Using this approach, oxide ionic conductivity of Sm- or La-doped CeO2-based system has been optimized and tested under operating conditions of a solid oxide fuel cell. In the observation of microstructure in atomic scale, both Sm-doped CeO2 and La-doped CeO2 electrolytes had large micro-domains over 10 nm in the lattice. On the other hand, Sm or La and alkaline earth co-doped CeO2-based electrolytes with high effective index had small micro-domains around 1-3 nm in the microstructure. The large micro-domain would prevent oxide ion from passing through the lattice. Therefore, it is concluded that the improvement of ionic conductivity is reflected in changes of microstructure in atomic scale. (C) 2002 Elsevier Science B.V. All rights reserved.

Blast design using measurement while drilling parameters

Measurement while drilling (MWD) techniques can provide a useful tool to aid drill and blast engineers in open cut mining. By avoiding time consuming tasks such as scan-lines and rock sample collection for laboratory tests, MWD techniques can not only save time but also improve the reliability of the blast design by providing the drill and blast engineer with the information specially tailored for use. While most mines use a standard blast pattern and charge per blasthole, based on a single rock factor for the entire bench or blast region, information derived from the MWD parameters can improve the blast design by providing more accurate rock properties for each individual blasthole. From this, decisions can be made on the most appropriate type and amount of explosive charge to place in a per blasthole or to optimise the inter-hole timing detonation time of different decks and blastholes. Where real-time calculations are feasible, the system could extend the present blast design even be used to determine the placement of subsequent holes towards a more appropriate blasthole pattern design like asymmetrical blasting.

Asymmetric blasting: a rock mass dependent blast design method

Blasting has been the most frequently used method for rock breakage since black powder was first used to fragment rocks, more than two hundred years ago. This paper is an attempt to reassess standard design techniques used in blasting by providing an alternative approach to blast design. The new approach has been termed asymmetric blasting. Based on providing real time rock recognition through the capacity of measurement while drilling (MWD) techniques, asymmetric blasting is an approach to deal with rock properties as they occur in nature, i.e., randomly and asymmetrically spatially distributed. It is well accepted that performance of basic mining operations, such as excavation and crushing rely on a broken rock mass which has been pre conditioned by the blast. By pre-conditioned we mean well fragmented, sufficiently loose and with adequate muckpile profile. These muckpile characteristics affect loading and hauling [1]. The influence of blasting does not end there. Under the Mine to Mill paradigm, blasting has a significant leverage on downstream operations such as crushing and milling. There is a body of evidence that blasting affects mineral liberation [2]. Thus, the importance of blasting has increased from simply fragmenting and loosing the rock mass, to a broader role that encompasses many aspects of mining, which affects the cost of the end product. A new approach is proposed in this paper which facilitates this trend 'to treat non-homogeneous media (rock mass) in a non-homogeneous manner (an asymmetrical pattern) in order to achieve an optimal result (in terms of muckpile size distribution).' It is postulated there are no logical reasons (besides the current lack of means to infer rock mass properties in the blind zones of the bench and onsite precedents) for drilling a regular blast pattern over a rock mass that is inherently heterogeneous. Real and theoretical examples of such a method are presented.

Sequencing batch reactor technology: the key to a BP refinery (Bulwer Island) upgraded environmental protection system - a low cost lagoon based retro-fit

BP Refinery (Bulwer Island) Ltd (BP) located on the eastern Australian coast is currently undergoing a major expansion as a part of the Queensland Clean Fuels Project. The associated wastewater treatment plant upgrade will provide a better quality of treated effluent than is currently possible with the existing infrastructure, and which will be of a sufficiently high standard to meet not only the requirements of imposed environmental legislation but also BP's environmental objectives. A number of challenges were faced when considering the upgrade, particularly; cost constraints and limited plot space, highly variable wastewater, toxicity issues, and limited available hydraulic head. Sequencing Batch Reactor (SBR) Technology was chosen for the lagoon upgrade based on the following; SBR technology allowed a retro-fit of the existing earthen lagoon without the need for any additional substantial concrete structures, a dual lagoon system allowed partial treatment of wastewaters during construction, SBRs give substantial process flexibility, SBRs have the ability to easily modify process parameters without any physical modifications, and significant cost benefits. This paper presents the background to this application, an outline of laboratory studies carried out on the wastewater and details the full scale design issues and methods for providing a cost effective, efficient treatment system using the existing lagoon system.

Design gráfico : análise da relação com a performance da micro e pequena empresa

O design possui um papel central nos negócios, participando de forma crucial no intercambio cultural e econômico da sociedade. Uma das competências do profissional de design gráfico é o desenvolvimento da Identidade Visual Corporativa (IVC). Ela tem como função definir visualmente o perfil de uma empresa, configurando-se, assim, como um composto mercadológico de fundamental importância para diferenciação das organizações, possuindo um importante papel para o crescimento das micro e pequenas empresas (MPEs). O objetivo desta pesquisa é verificar de que forma os gestores de MPEs percebem a atuação do design gráfico sobre a performance do seu negócio, avaliada a partir da sua experiência com a IVC desenvolvida por um profissional de design e aplicada pela empresa em suas atividades. A pesquisa é aplicada, em relação a sua finalidade, e exploratória, quanto ao seu objetivo. Sua condução se deu a partir de pesquisa bibliográfica, entrevista semiestruturada com os gestores das MPEs investigadas e pesquisa documental em materiais fornecidos pelos sujeitos da pesquisa, realizando-se, desta forma, uma triangulação metodológica a fim de contribuir para o exame do fenômeno. Como estratégia de investigação foi utilizado o estudo de casos múltiplos, realizado com 7 (sete) MPEs que haviam incorporado sua IVC há pelo menos 2 (dois) anos, dos setores de comércio e serviço, localizadas nos municípios de Vitória, Vila Velha, Serra ou Cariacica. Os dados coletados foram analisados por meio da Análise de Conteúdo, com base nas etapas descritas por Bardin (1977) e Laville (1999), distribuindo as unidades de análise (frases e parágrafos) nas categorias desenvolvidas: Motivação, Integração da IVC, Gestão da IVC, Relevância da IVC, IVC e Performance e Expressão Visual. A análise utilizou a abordagem quantitativa, realizada por meio da técnica de percentagem, e qualitativa, com maior ênfase na última, onde foram analisadas as categorias e seus elementos, assim como as relações entre elas, buscando extrair os significados construídos. Desta forma, foi possível verificar que a maior parte dos gestores das MPEs investigadas identificam que o design gráfico, por meio da IVC, contribui de forma positiva para a performance do seu negócio, proporcionando diferentes tipos de benefícios, dentre os mais citados foram: Identificação/Reconhecimento, Fortalecimento (solidez, estabilidade, profissionalismo), Novos Clientes, Imagem, Receptividade, Agregação de Valor para a Marca e Diferenciação.

Design gráfico : análise da relação com a performance da micro e pequena empresa

O design possui um papel central nos negócios, participando de forma crucial no intercambio cultural e econômico da sociedade. Uma das competências do profissional de design gráfico é o desenvolvimento da Identidade Visual Corporativa (IVC). Ela tem como função definir visualmente o perfil de uma empresa, configurando-se, assim, como um composto mercadológico de fundamental importância para diferenciação das organizações, possuindo um importante papel para o crescimento das micro e pequenas empresas (MPEs). O objetivo desta pesquisa é verificar de que forma os gestores de MPEs percebem a atuação do design gráfico sobre a performance do seu negócio, avaliada a partir da sua experiência com a IVC desenvolvida por um profissional de design e aplicada pela empresa em suas atividades. A pesquisa é aplicada, em relação a sua finalidade, e exploratória, quanto ao seu objetivo. Sua condução se deu a partir de pesquisa bibliográfica, entrevista semiestruturada com os gestores das MPEs investigadas e pesquisa documental em materiais fornecidos pelos sujeitos da pesquisa, realizando-se, desta forma, uma triangulação metodológica a fim de contribuir para o exame do fenômeno. Como estratégia de investigação foi utilizado o estudo de casos múltiplos, realizado com 7 (sete) MPEs que haviam incorporado sua IVC há pelo menos 2 (dois) anos, dos setores de comércio e serviço, localizadas nos municípios de Vitória, Vila Velha, Serra ou Cariacica. Os dados coletados foram analisados por meio da Análise de Conteúdo, com base nas etapas descritas por Bardin (1977) e Laville (1999), distribuindo as unidades de análise (frases e parágrafos) nas categorias desenvolvidas: Motivação, Integração da IVC, Gestão da IVC, Relevância da IVC, IVC e Performance e Expressão Visual. A análise utilizou a abordagem quantitativa, realizada por meio da técnica de percentagem, e qualitativa, com maior ênfase na última, onde foram analisadas as categorias e seus elementos, assim como as relações entre elas, buscando extrair os significados construídos. Desta forma, foi possível verificar que a maior parte dos gestores das MPEs investigadas identificam que o design gráfico, por meio da IVC, contribui de forma positiva para a performance do seu negócio, proporcionando diferentes tipos de benefícios, dentre os mais citados foram: Identificação/Reconhecimento, Fortalecimento (solidez, estabilidade, profissionalismo), Novos Clientes, Imagem, Receptividade, Agregação de Valor para a Marca e Diferenciação.

Towards the design of efficient nonbeacon-enabled ZigBee networks

This paper presents experimental results of the communication performance evaluation of a prototype ZigBee-based patient monitoring system commissioned in an in-patient floor of a Portuguese hospital (HPG – Hospital Privado de Guimar~aes). Besides, it revisits relevant problems that affect the performance of nonbeacon-enabled ZigBee networks. Initially, the presence of hidden-nodes and the impact of sensor node mobility are discussed. It was observed, for instance, that the message delivery ratio in a star network consisting of six wireless electrocardiogram sensor devices may decrease from 100% when no hidden-nodes are present to 83.96% when half of the sensor devices are unable to detect the transmissions made by the other half. An additional aspect which affects the communication reliability is a deadlock condition that can occur if routers are unable to process incoming packets during the backoff part of the CSMA-CA mechanism. A simple approach to increase the message delivery ratio in this case is proposed and its effectiveness is verified. The discussion and results presented in this paper aim to contribute to the design of efficient networks,and are valid to other scenarios and environments rather than hospitals.

Accessing movies based on emotional impact

Emotions play a central role in our daily lives, influencing the way we think and act, our health and sense of well-being, and films are by excellence the form of art that exploits our affective, perceptual and intellectual activity, holding the potential for a significant impact. Video is becoming a dominant and pervasive medium, and online video a growing entertainment activity on the web and iTV, mainly due to technological developments and the trends for media convergence. In addition, the improvement of new techniques for gathering emotional information about videos, both through content analysis or user implicit feedback through user physiological signals complemented in manual labeling from users, is revealing new ways for exploring emotional information in videos, films or TV series, and brings out new perspectives to enrich and personalize video access. In this work, we reflect on the power that emotions have in our lives, on the emotional impact of movies, and on how to address this emotional dimension in the way we classify and access movies, by exploring and evaluating the design of iFelt in its different ways to classify, access, browse and visualize movies based on their emotional impac

Contribution towards a reflection about methodological strategies in design education and the function of drawing in design

This work presents a reflection on Design education and specifically on the role of Drawing in this area. As a subject, Design has expanded its field of action expanding into new areas such as Experience Design or Service Design. It became necessary for the designer to have more than an education based on technological knowledge or know-how. Many authors like Meredith Davis, Don Norman or Jamie Hobson point out the urgency to review the curricula of Design courses because nowadays “… design is more than appearance, design is about interaction, about strategy and about services. Designers change social behavior” (Norman 2011). When shifting from a product-centered design to a person-centered design (in a structure, a service or in a relationship) what should the function of drawing in a design course be? What should its curriculum be? Our work methodology will be to confront today’s perspectives on design theory and practice in an attempt to add to the discussion on the methodological strategies in design teaching in the contemporary context.

Contribution towards a reflection about methodological strategies in Design Education and the function of Drawing in Design

This work presents a reflection on Design education and specifically on the role of Drawing in this area. As a subject, Design has expanded its field of action expanding into new areas such as Experience Design or Service Design. It became necessary for the designer to have more than an education based on technological knowledge or know-how. Many authors like Meredith Davis, Don Norman or Jamie Hobson point out the urgency to review the curricula of Design courses because nowadays “ … design is more than appearance, design is about interaction, about strategy and about services. Designers change social behavior” (Norman, 2011) When shifting from a product-centered design to a person-centered design (in a structure, a service or in a relationship) what should the function of drawing in a design course be? What should its curriculum be? Our work methodology will be to confront today’s perspectives on design theory and practice in an attempt to add to the discussion on the methodological strategies in design teaching in the contemporary context.

Neural Electrode Array Based on Aluminum: Fabrication and Characterization

A unique neural electrode design is proposed with 3 mm long shafts made from an aluminum-based substrate. The electrode is composed by 100 individualized shafts in a 10 × 10 matrix, in which each aluminum shafts are precisely machined via dicing-saw cutting programs. The result is a bulk structure of aluminum with 65 ° angle sharp tips. Each electrode tip is covered by an iridium oxide thin film layer (ionic transducer) via pulsed sputtering, that provides a stable and a reversible behavior for recording/stimulation purposes, a 40 mC/cm2 charge capacity and a 145 Ω impedance in a wide frequency range of interest (10 Hz-100 kHz). Because of the non-biocompatibility issue that characterizes aluminum, an anodization process is performed that forms an aluminum oxide layer around the aluminum substrate. The result is a passivation layer fully biocompatible that furthermore, enhances the mechanical properties by increasing the robustness of the electrode. For a successful electrode insertion, a 1.1 N load is required. The resultant electrode is a feasible alternative to silicon-based electrode solutions, avoiding the complexity of its fabrication methods and limitations, and increasing the electrode performance.