SmartClean: an incremental data cleaning tool

This paper presents the SmartClean tool. The purpose of this tool is to detect and correct the data quality problems (DQPs). Compared with existing tools, SmartClean has the following main advantage: the user does not need to specify the execution sequence of the data cleaning operations. For that, an execution sequence was developed. The problems are manipulated (i.e., detected and corrected) following that sequence. The sequence also supports the incremental execution of the operations. In this paper, the underlying architecture of the tool is presented and its components are described in detail. The tool's validity and, consequently, of the architecture is demonstrated through the presentation of a case study. Although SmartClean has cleaning capabilities in all other levels, in this paper are only described those related with the attribute value level.

Ontologies for reusing data cleaning knowledge

The emergence of new business models, namely, the establishment of partnerships between organizations, the chance that companies have of adding existing data on the web, especially in the semantic web, to their information, led to the emphasis on some problems existing in databases, particularly related to data quality. Poor data can result in loss of competitiveness of the organizations holding these data, and may even lead to their disappearance, since many of their decision-making processes are based on these data. For this reason, data cleaning is essential. Current approaches to solve these problems are closely linked to database schemas and specific domains. In order that data cleaning can be used in different repositories, it is necessary for computer systems to understand these data, i.e., an associated semantic is needed. The solution presented in this paper includes the use of ontologies: (i) for the specification of data cleaning operations and, (ii) as a way of solving the semantic heterogeneity problems of data stored in different sources. With data cleaning operations defined at a conceptual level and existing mappings between domain ontologies and an ontology that results from a database, they may be instantiated and proposed to the expert/specialist to be executed over that database, thus enabling their interoperability.

Effect of the compact Ti layer on the efficiency of dye-sensitized solar cells assembled using stainless steel sheets

Titanium films have been deposited on stainless steel metal sheets using dc magnetron sputtering technique at different substrate temperatures. The structure of the titanium films strongly depend on the substrate temperature. The titanium film deposited at the substrate temperature lower than 300 ◦C has a loose flat sheet grains structure and the titanium film prepared at the substrate temperature higher than 500 ◦C has a dense nubby grains structure. The DSSC assembled using stainless steel sheet coated with titanium film deposited at high substrate temperature has a low charge transfer resistance in the TiO2/Ti interface and results in a high conversion efficiency. The DSSC assembled using stainless steel sheet coated with titanium film deposited at temperature higher than 500 ◦C has higher conversion efficiency than that assembled using titanium metal sheet as the substrate. The maximum conversion efficiency, 2.26% is obtained for DSSC assembled using stainless steel sheet coated with titanium film deposited at 700 ◦C substrate temperature, which is about 70% of the conversion efficiency of the FTO reference cell used in this study.

Microstructure, mechanical properties and chemical degradation of brazed AISI 316 stainless steel/alumina systems

The main aims of the present study are simultaneously to relate the brazing parameters with: (i) the correspondent interfacial microstructure, (ii) the resultant mechanical properties and (iii) the electrochemical degradation behaviour of AISI 316 stainless steel/alumina brazed joints. Filler metals on such as Ag–26.5Cu–3Ti and Ag–34.5Cu–1.5Ti were used to produce the joints. Three different brazing temperatures (850, 900 and 950 °C), keeping a constant holding time of 20 min, were tested. The objective was to understand the influence of the brazing temperature on the final microstructure and properties of the joints. The mechanical properties of the metal/ceramic (M/C) joints were assessed from bond strength tests carried out using a shear solicitation loading scheme. The fracture surfaces were studied both morphologically and structurally using scanning electron microscopy (SEM), energy dispersive spectroscopy (EDS) and X-ray diffraction analysis (XRD). The degradation behaviour of the M/C joints was assessed by means of electrochemical techniques. It was found that using a Ag–26.5Cu–3Ti brazing alloy and a brazing temperature of 850 °C, produces the best results in terms of bond strength, 234 ± 18 MPa. The mechanical properties obtained could be explained on the basis of the different compounds identified on the fracture surfaces by XRD. On the other hand, the use of the Ag–34.5Cu–1.5Ti brazing alloy and a brazing temperature of 850 °C produces the best results in terms of corrosion rates (lower corrosion current density), 0.76 ± 0.21 μA cm−2. Nevertheless, the joints produced at 850 °C using a Ag–26.5Cu–3Ti brazing alloy present the best compromise between mechanical properties and degradation behaviour, 234 ± 18 MPa and 1.26 ± 0.58 μA cm−2, respectively. The role of Ti diffusion is fundamental in terms of the final value achieved for the M/C bond strength. On the contrary, the Ag and Cu distribution along the brazed interface seem to play the most relevant role in the metal/ceramic joints electrochemical performance.

Scheduling a cutting and treatment stainless steel sheet line with self-management capabilities

With advancement in computer science and information technology, computing systems are becoming increasingly more complex with an increasing number of heterogeneous components. They are thus becoming more difficult to monitor, manage, and maintain. This process has been well known as labor intensive and error prone. In addition, traditional approaches for system management are difficult to keep up with the rapidly changing environments. There is a need for automatic and efficient approaches to monitor and manage complex computing systems. In this paper, we propose an innovative framework for scheduling system management by combining Autonomic Computing (AC) paradigm, Multi-Agent Systems (MAS) and Nature Inspired Optimization Techniques (NIT). Additionally, we consider the resolution of realistic problems. The scheduling of a Cutting and Treatment Stainless Steel Sheet Line will be evaluated. Results show that proposed approach has advantages when compared with other scheduling systems

Low torque loss gears: austempered ductile iron versus carburized steel

Low-loss power transmission gears operate at lower temperature than conventional ones because their teeth geometry is optimized to reduce friction. The main objective of this work is to compare the operating stabilization temperature and efficiency of low-loss austempered ductile iron (ADI) and carburized steel gears. Three different low-loss tooth geometries were adopted (types 311, 411 and 611, all produced using standard 20° pressure angle tools) and corresponding steel and ADI gears were tested in a FZG machine. The results obtained showed that low-loss geometries had a significant influence on power loss, gears 611 generating lower power loss than gears 311. At low speeds (500 and 1000 rpm) and high torque ADI gears generated lower power loss than steel gears. However, at high speed and high torque (high input power and high stabilization temperature) steel gears had better efficiency.

Development of paper-based color test-strip for drug detection in aquatic environment: Application to oxytetracycline

The wide use of antibiotics in aquaculture has led to the emergence of resistant microbial species. It should be avoided/minimized by controlling the amount of drug employed in fish farming. For this purpose, the present work proposes test-strip papers aiming at the detection/semi-quantitative determination of organic drugs by visual comparison of color changes, in a similar analytical procedure to that of pH monitoring by universal pH paper. This is done by establishing suitable chemical changes upon cellulose, attributing the paper the ability to react with the organic drug and to produce a color change. Quantitative data is also enabled by taking a picture and applying a suitable mathematical treatment to the color coordinates given by the HSL system used by windows. As proof of concept, this approach was applied to oxytetracycline (OXY), one of the antibiotics frequently used in aquaculture. A bottom-up modification of paper was established, starting by the reaction of the glucose moieties on the paper with 3-triethoxysilylpropylamine (APTES). The so-formed amine layer allowed binding to a metal ion by coordination chemistry, while the metal ion reacted after with the drug to produce a colored compound. The most suitable metals to carry out such modification were selected by bulk studies, and the several stages of the paper modification were optimized to produce an intense color change against the concentration of the drug. The paper strips were applied to the analysis of spiked environmental water, allowing a quantitative determination for OXY concentrations as low as 30 ng/mL. In general, this work provided a simple, method to screen and discriminate tetracycline drugs, in aquaculture, being a promising tool for local, quick and cheap monitoring of drugs.

Rapid automated method for on-site determination of sulfadiazine in fish farming: a stainless steel veterinary syringe coated with a selective membrane of PVC serving as a potentiometric detector in a flow-injection-analysis system

Sulfadiazine is an antibiotic of the sulfonamide group and is used as a veterinary drug in fish farming. Monitoring it in the tanks is fundamental to control the applied doses and avoid environmental dissemination. Pursuing this goal, we included a novel potentiometric design in a flow-injection assembly. The electrode body was a stainless steel needle veterinary syringe of 0.8-mm inner diameter. A selective membrane of PVC acted as a sensory surface. Its composition, the length of the electrode, and other flow variables were optimized. The best performance was obtained for sensors of 1.5-cm length and a membrane composition of 33% PVC, 66% onitrophenyloctyl ether, 1% ion exchanger, and a small amount of a cationic additive. It exhibited Nernstian slopes of 61.0 mV decade-1 down to 1.0×10-5 mol L-1, with a limit of detection of 3.1×10-6 mol L-1 in flowing media. All necessary pH/ionic strength adjustments were performed online by merging the sample plug with a buffer carrier of 4-(2-hydroxyethyl)-1-piperazineethanesulfonic acid, pH 4.9. The sensor exhibited the advantages of a fast response time (less than 15 s), long operational lifetime (60 days), and good selectivity for chloride, nitrite, acetate, tartrate, citrate, and ascorbate. The flow setup was successfully applied to the analysis of aquaculture waters. The analytical results were validated against those obtained with liquid chromatography–tandem mass spectrometry procedures. The sampling rate was about 84 samples per hour and recoveries ranged from 95.9 to 106.9%.

Establishing the main Guidelines for Cast Steel to Produce Truck Parts

Este trabalho foi realizado na Scania CV AB e teve como principal objectivo estabelecer uma diretriz sobre a possível utilização de aços vazados. Existe uma grande necessidade na realização deste trabalho, de forma a apoiar os engenheiros de projecto no seu processo de selecção dos materiais mais adequados, para produzir componentes mais leves e de elevado desempenho. Esta diretriz apresenta informação relacionada com propriedades mecânicas, processos de fundição, vazabilidade, tipologia de defeitos, tratamentos térmicos, soldabilidade e tratamentos superficiais dos aços vazados. Este trabalho foi limitado, na seleção de materiais para componentes do camião, a aços vazados que poderiam ser aplicados em dois componentes específicos: um componente estrutural da carroçaria sujeito a esforços de fadiga e a um colector de gases de combustão, sujeito a fluência, oxidação, fadiga por corrosão, fadiga-térmica e fadiga-mecânica. Foi realizado um benchmark focado nestes dois componentes de forma a saber que materiais são utilizados de momento por outras empresas concorrentes. Foi realizada ainda uma análise sobre possíveis materiais que possam ser aplicados em cada componente referido. Foi conduzida uma caracterização no estado bruto de fundição de um aço inoxidável vazado usado para produzir um protótipo do colector de gases. Esta caracterização consistiu numa análise microestrutural e medição de macro e microdurezas. Além da caracterização inicial, foram aplicados um conjunto de tratamentos térmicos, de forma a estudar a possibilidade de eliminar os carbonetos presentes inicialmente nas fronteiras de grão. As principais conclusões deste trabalho são que o aço vazado apresenta potencial para ser uma escolha válida em diversas aplicações, devido a um leque alargado de propriedades apresentadas tipicamente por este material. Relativamente a aplicações estruturais, o aço vazado é vantajoso comparativamente ao ferro fundido, quando são requeridos, por exemplo, soldabilidade e elevada resistência, combinada com elevada tenacidade à fractura. Para componentes sujeitos a elevadas temperaturas de serviço, o aço inoxidável vazado é vantajoso quando usado a temperaturas superiores a 750°C, apesar do seu elevado custo. O tratamento térmico composto por um recozimento de solubilização seguido de envelhecimento, elimina quase na totalidade os carbonetos presentes nas fronteiras de grão e verifica-se um aumento de dureza através de uma precipitação de carbonetos finamente dispersos na matriz, que poderão também aumentar a resistência à fluência.

Estudo de problemas de corrosão em cabos de aço zincado

As cablagens metálicas são aplicadas abundantemente na montagem dos automóveis, para accionamento de diversos dispositivos, tais como a abertura de portas, abertura da mala ou da tampa do motor, abertura do tampão do depósito de combustível, accionamento do travão de mão, etc. Nas cablagens metálicas utilizadas na indústria automóvel é comummente utilizado arame entrançado de aço zincado, o qual foi já estudado resistir à agressividade das condições em que habitualmente trabalham. No entanto, para que esta estabilidade de funcionamento exista, torna-se necessário que a qualidade do arame entrançado seja a mais adequada. O presente trabalho surgiu da necessidade de averiguar quais as razões que estariam por detrás do aparecimento de quantidades relativamente abundantes de Óxido de Zinco (ZnO) em cablagens metálicas utilizadas na indústria automóvel, poucas semanas depois do seu fabrico. O estudo foi levado a cabo com vista a satisfazer as necessidades de investigação deste problema por parte de uma empresa de cablagens metálicas instalada no nosso país, a FicoCables, estabelecendo quais as causas-raiz deste problema, com vista a poder evitálo no futuro. O trabalho foi concluído com sucesso, tendo-se averiguado que existiam lacunas graves de limpeza do cabo entre as operações de conformação do arame e de zincagem, com deposição de elementos potenciadores do Óxido de Zinco na interface, os quais viriam a revelar-se cruciais à posteriori, para a nucleação e desenvolvimento do Óxido de Zinco na superfície do cabo.