948 resultados para Query-by-example
Resumo:
Geographic Data Warehouses (GDW) are one of the main technologies used in decision-making processes and spatial analysis, and the literature proposes several conceptual and logical data models for GDW. However, little effort has been focused on studying how spatial data redundancy affects SOLAP (Spatial On-Line Analytical Processing) query performance over GDW. In this paper, we investigate this issue. Firstly, we compare redundant and non-redundant GDW schemas and conclude that redundancy is related to high performance losses. We also analyze the issue of indexing, aiming at improving SOLAP query performance on a redundant GDW. Comparisons of the SB-index approach, the star-join aided by R-tree and the star-join aided by GiST indicate that the SB-index significantly improves the elapsed time in query processing from 25% up to 99% with regard to SOLAP queries defined over the spatial predicates of intersection, enclosure and containment and applied to roll-up and drill-down operations. We also investigate the impact of the increase in data volume on the performance. The increase did not impair the performance of the SB-index, which highly improved the elapsed time in query processing. Performance tests also show that the SB-index is far more compact than the star-join, requiring only a small fraction of at most 0.20% of the volume. Moreover, we propose a specific enhancement of the SB-index to deal with spatial data redundancy. This enhancement improved performance from 80 to 91% for redundant GDW schemas.
Resumo:
Single-point diamond turning of monocrystalline semiconductors is an important field of research within brittle materials machining. Monocrystalline silicon samples with a (100) orientation have been diamond turned under different cutting conditions (feed rate and depth of cut). Micro-Raman spectroscopy and atomic force microscopy have been used to assess structural alterations and surface finish of the samples diamond turned under ductile and brittle modes. It was found that silicon undergoes a phase transformation when machined in the ductile mode. This phase transformation is evidenced by the creation of an amorphous surface layer after machining which has been probed by Raman scattering. Compressive residual stresses are estimated for the machined surface and it is observed that they decrease with an increase in the feed rate and depth of cut. This behaviour has been attributed to the formation of subsurface cracks when the feed rate is higher than or equal to 2.5 mu m/rev. The surface roughness was observed to vary with the feed rate and the depth of cut. An increase in the surface roughness was influenced by microcrack formation when the feed rate reached 5.0 mu m/rev. Furthermore, a high-pressure phase transformation induced by the tool/material interaction and responsible for the ductile response of this typical brittle material is discussed based upon the presented Raman spectra. The application of this machining technology finds use for a wide range of high quality components, for example the creation of a micrometre-range channel for microfluidic devices as well as microlenses used in the infrared spectrum range.
Resumo:
The crystalline structure of transition-metals (TM) has been widely known for several decades, however, our knowledge on the atomic structure of TM clusters is still far from satisfactory, which compromises an atomistic understanding of the reactivity of TM clusters. For example, almost all density functional theory (DFT) calculations for TM clusters have been based on local (local density approximation-LDA) and semilocal (generalized gradient approximation-GGA) exchange-correlation functionals, however, it is well known that plain DFT fails to correct the self-interaction error, which affects the properties of several systems. To improve our basic understanding of the atomic and electronic properties of TM clusters, we report a DFT study within two nonlocal functionals, namely, the hybrid HSE (Heyd, Scuseria, and Ernzerhof) and GGA + U functionals, of the structural and electronic properties of the Co(13), Rh(13), and Hf(13) clusters. For Co(13) and Rh(13), we found that improved exchange-correlation functionals decrease the stability of open structures such as the hexagonal bilayer (HBL) and double simple-cubic (DSC) compared with the compact icosahedron (ICO) structure, however, DFT-GGA, DFT-GGA + U, and DFT-HSE yield very similar results for Hf(13). Thus, our results suggest that the DSC structure obtained by several plain DFT calculations for Rh(13) can be improved by the use of improved functionals. Using the sd hybridization analysis, we found that a strong hybridization favors compact structures, and hence, a correct description of the sd hybridization is crucial for the relative energy stability. For example, the sd hybridization decreases for HBL and DSC and increases for ICO in the case of Co(13) and Rh(13), while for Hf(13), the sd hybridization decreases for all configurations, and hence, it does not affect the relative stability among open and compact configurations.
Resumo:
Cuboctahedron (CUB) and icosahedron (ICO) model structures are widely used in the study of transition-metal (TM) nanoparticles (NPs), however, it might not provide a reliable description for small TM NPs such as the Pt(55) and Au(55) systems in gas phase. In this work, we combined density-functional theory calculations with atomic configurations generated by the basin hopping Monte Carlo algorithm within the empirical Sutton-Chen embedded atom potential. We identified alternative lower energy configurations compared with the ICO and CUB model structures, e. g., our lowest energy structures are 5.22 eV (Pt(55)) and 2.01 eV (Au(55)) lower than ICO. The energy gain is obtained by the Pt and Au diffusion from the ICO core region to the NP surface, which is driven by surface compression (only 12 atoms) on the ICO core region. Therefore, in the lowest energy configurations, the core size reduces from 13 atoms (ICO, CUB) to about 9 atoms while the NP surface increases from 42 atoms (ICO, CUB) to about 46 atoms. The present mechanism can provide an improved atom-level understanding of small TM NPs reconstructions.
Diagnostic errors and repetitive sequential classifications in on-line process control by attributes
Resumo:
The procedure of on-line process control by attributes, known as Taguchi`s on-line process control, consists of inspecting the mth item (a single item) at every m produced items and deciding, at each inspection, whether the fraction of conforming items was reduced or not. If the inspected item is nonconforming, the production is stopped for adjustment. As the inspection system can be subject to diagnosis errors, one develops a probabilistic model that classifies repeatedly the examined item until a conforming or b non-conforming classification is observed. The first event that occurs (a conforming classifications or b non-conforming classifications) determines the final classification of the examined item. Proprieties of an ergodic Markov chain were used to get the expression of average cost of the system of control, which can be optimized by three parameters: the sampling interval of the inspections (m); the number of repeated conforming classifications (a); and the number of repeated non-conforming classifications (b). The optimum design is compared with two alternative approaches: the first one consists of a simple preventive policy. The production system is adjusted at every n produced items (no inspection is performed). The second classifies the examined item repeatedly r (fixed) times and considers it conforming if most classification results are conforming. Results indicate that the current proposal performs better than the procedure that fixes the number of repeated classifications and classifies the examined item as conforming if most classifications were conforming. On the other hand, the preventive policy can be averagely the most economical alternative rather than those ones that require inspection depending on the degree of errors and costs. A numerical example illustrates the proposed procedure. (C) 2009 Elsevier B. V. All rights reserved.
Resumo:
Interactions between the oscillations of piezoceramic transducer and the mechanism of as excitation-the generator of the electric current of limited power-supply-are analyzed in this paper In practical situations, the dynamics of the forcing function on a vibrating system cannot be considered as given a priori, and it must be taken as a consequence of the dynamics of the whole system. In other words, the forcing source has limited power as that provided by a dc motor for an example, and thus its own dynamics is influenced by that of the vibrating system being forced. This increases the number of degrees of freedom of the problem, and it is called a nonideal problem. In this work, we present certain phenomena as Sommerfeld effect, jump, saturation, and stability, through the influences of the parameters of the governing equations motion. [DOI: 10.1115/1.3007909]
Resumo:
We present a descriptive analysis of a mechanism to coordinate and implement human immunodeficiency virus (HIV) prevention and care in the occupational setting. The mechanism we describe is a multidisciplinary committee composed of stakeholders in the occupational health environment including unions, management, medical researchers, and medical personnel. The site chosen for the analysis was a South African sugar mill in rural KwaZulu-Natal. The factory is situated in an area of high HIV seroprevalence and has a workforce of 400 employees. The committee was initiated to coordinate a combined prevention-care initiative. The issues that were important in the formation of the committee included confidentiality, trust, and the traditional roles of the stakeholder relationships. When these points were addressed through the focus on a common goal, the committee was able to function in its role as a coordinating body. Central to this success was the inclusion of all stakeholders in the process, including those with traditionally opposing, interests and legitimacy conferred by the stakeholders. This committee was functionally effective and demonstrated the benefit of a freestanding committee dedicated to addressing HIV/acquired immune deficiency syndrome (AIDS) issues. We describe the implementation and feasibility of a multisectoral committee in directing HIV/AIDS initiatives in the occupational setting in rural South Africa.
Resumo:
We re-mapped the soils of the Murray-Darling Basin (MDB) in 1995-1998 with a minimum of new fieldwork, making the most out of existing data. We collated existing digital soil maps and used inductive spatial modelling to predict soil types from those maps combined with environmental predictor variables. Lithology, Landsat Multi Spectral Scanner (Landsat MSS), the 9-s digital elevation model (DEM) of Australia and derived terrain attributes, all gridded to 250-m pixels, were the predictor variables. Because the basin-wide datasets were very large data mining software was used for modelling. Rule induction by data mining was also used to define the spatial domain of extrapolation for the extension of soil-landscape models from existing soil maps. Procedures to estimate the uncertainty associated with the predictions and quality of information for the new soil-landforms map of the MDB are described. (C) 2002 Elsevier Science B.V. All rights reserved.
Resumo:
Traditional treatment of infectious diseases is based on compounds that kill or inhibit growth of bacteria. A major concern with this approach is the frequent development of resistance to antibiotics. The discovery of communication systems (quorum sensing systems) regulating bacterial virulence has afforded a novel opportunity to control infectious bacteria without interfering with growth. Compounds that can override communication signals have been found in the marine environment. Using Pseudomonas aeruginosa PAO1 as an example of an opportunistic human pathogen, we show that a synthetic derivate of natural furanone compounds can act as a potent antagonist of bacterial quorum sensing. We employed GeneChip((R)) microarray technology to identify furanone target genes and to map the quorum sensing regulon. The transcriptome analysis showed that the furanone drug specifically targeted quorum sensing systems and inhibited virulence factor expression. Application of the drug to P.aeruginosa biofilms increased bacterial susceptibility to tobramycin and SDS. In a mouse pulmonary infection model, the drug inhibited quorum sensing of the infecting bacteria and promoted their clearance by the mouse immune response.
Resumo:
Phylogenetic trees can provide a stable basis for a higher-level classification of organisms that reflects evolutionary relationships. However, some lineages have a complex evolutionary history that involves explosive radiation or hybridisation. Such histories have become increasingly apparent with the use of DNA sequence data for phylogeny estimation and explain, in part, past difficulties in producing stable morphology-based classifications for some groups. We illustrate this situation by using the example of tribe Mirbelieae (Fabaceae), whose generic classification has been fraught for decades. In particular, we discuss a recent proposal to combine 19 of the 25 Mirbelieae genera into a single genus, Pultenaea sens. lat., and how we might find stable and consistent ways to squeeze something as complex as life into little boxes for our own convenience. © CSIRO.
Resumo:
This article seeks to retrace some of the empirical, historical and sociological elements of Max Weber Sociology of music. Even if he is first and foremost interested in the process of rationalisation throughout western civilisation, his Sociology of music is founded on the idea of the technical medium, which he explores in several different directions. This idea will be examined here by means of several examples drawn from western music, particularly from the romantic piano repertoire.
Resumo:
Protein purification that combines the use of molecular mass exclusion membranes with electrophoresis is particularly powerful as it uses properties inherent to both techniques. The use of membranes allows efficient processing and is easily scaled up, while electrophoresis permits high resolution separation under mild conditions. The Gradiflow apparatus combines these two technologies as it uses polyacrylamide membranes to influence electrokinetic separations. The reflux electrophoresis process consists of a series of cycles incorporating a forward phase and a reverse phase. The forward phase involves collection of a target protein that passes through a separation membrane before trailing proteins in the same solution. The forward phase is repeated following clearance of the membrane in the reverse phase by reversing the current. We have devised a strategy to establish optimal reflux separation parameters, where membranes are chosen for a particular operating range and protein transfer is monitored at different pH values. In addition, forward and reverse phase times are determined during this process. Two examples of the reflux method are described. In the first case, we describe the purification strategy for proteins from a complex mixture which contains proteins of higher electrophoretic mobility than the target protein. This is a two-step procedure, where first proteins of higher mobility than the target protein are removed from the solution by a series of reflux cycles, so that the target protein remains as the leading fraction. In the second step the target protein is collected, as it has become the leading fraction of the remaining proteins. In the second example we report the development of a reflux strategy which allowed a rapid one-step preparative purification of a recombinant protein, expressed in Dictyostelium discoideum. These strategies demonstrate that the Gradiflow is amenable to a wide range of applications, as the protein of interest is not necessarily required to be the leading fraction in solution. (C) 1997 Elsevier Science B.V.
Forecasting regional crop production using SOI phases: an example for the Australian peanut industry
Resumo:
Using peanuts as an example, a generic methodology is presented to forward-estimate regional crop production and associated climatic risks based on phases of the Southern Oscillation Index (SOI). Yield fluctuations caused by a highly variable rainfall environment are of concern to peanut processing and marketing bodies. The industry could profitably use forecasts of likely production to adjust their operations strategically. Significant, physically based lag-relationships exist between an index of ocean/atmosphere El Nino/Southern Oscillation phenomenon and future rainfall in Australia and elsewhere. Combining knowledge of SOI phases in November and December with output from a dynamic simulation model allows the derivation of yield probability distributions based on historic rainfall data. This information is available shortly after planting a crop and at least 3-5 months prior to harvest. The study shows that in years when the November-December SOI phase is positive there is an 80% chance of exceeding average district yields. Conversely, in years when the November-December SOI phase is either negative or rapidly falling there is only a 5% chance of exceeding average district yields, but a 95% chance of below average yields. This information allows the industry to adjust strategically for the expected volume of production. The study shows that simulation models can enhance SOI signals contained in rainfall distributions by discriminating between useful and damaging rainfall events. The methodology can be applied to other industries and regions.
Resumo:
A straightforward method is proposed for computing the magnetic field produced by a circular coil that contains a large number of turns wound onto a solenoid of rectangular cross section. The coil is thus approximated by a circular ring containing a continuous constant current density, which is very close to the real situation when sire of rectangular cross section is used. All that is required is to evaluate two functions, which are defined as integrals of periodic quantities; this is done accurately and efficiently using trapezoidal-rule quadrature. The solution can be obtained so rapidly that this procedure is ideally suited for use in stochastic optimization, An example is given, in which this approach is combined with a simulated annealing routine to optimize shielded profile coils for NMR.
Resumo:
This paper examines the effects of information request ambiguity and construct incongruence on end user's ability to develop SQL queries with an interactive relational database query language. In this experiment, ambiguity in information requests adversely affected accuracy and efficiency. Incongruities among the information request, the query syntax, and the data representation adversely affected accuracy, efficiency, and confidence. The results for ambiguity suggest that organizations might elicit better query development if end users were sensitized to the nature of ambiguities that could arise in their business contexts. End users could translate natural language queries into pseudo-SQL that could be examined for precision before the queries were developed. The results for incongruence suggest that better query development might ensue if semantic distances could be reduced by giving users data representations and database views that maximize construct congruence for the kinds of queries in typical domains. (C) 2001 Elsevier Science B.V. All rights reserved.