11 resultados para data warehouse tuning aggregato business intelligence performance

em University of Queensland eSpace - Australia


Relevância:

100.00% 100.00%

Publicador:

Resumo:

Even when data repositories exhibit near perfect data quality, users may formulate queries that do not correspond to the information requested. Users’ poor information retrieval performance may arise from either problems understanding of the data models that represent the real world systems, or their query skills. This research focuses on users’ understanding of the data structures, i.e., their ability to map the information request and the data model. The Bunge-Wand-Weber ontology was used to formulate three sets of hypotheses. Two laboratory experiments (one using a small data model and one using a larger data model) tested the effect of ontological clarity on users’ performance when undertaking component, record, and aggregate level tasks. The results indicate for the hypotheses associated with different representations but equivalent semantics that parsimonious data model participants performed better for component level tasks but that ontologically clearer data model participants performed better for record and aggregate level tasks.

Relevância:

100.00% 100.00%

Publicador:

Resumo:

Quantile computation has many applications including data mining and financial data analysis. It has been shown that an is an element of-approximate summary can be maintained so that, given a quantile query d (phi, is an element of), the data item at rank [phi N] may be approximately obtained within the rank error precision is an element of N over all N data items in a data stream or in a sliding window. However, scalable online processing of massive continuous quantile queries with different phi and is an element of poses a new challenge because the summary is continuously updated with new arrivals of data items. In this paper, first we aim to dramatically reduce the number of distinct query results by grouping a set of different queries into a cluster so that they can be processed virtually as a single query while the precision requirements from users can be retained. Second, we aim to minimize the total query processing costs. Efficient algorithms are developed to minimize the total number of times for reprocessing clusters and to produce the minimum number of clusters, respectively. The techniques are extended to maintain near-optimal clustering when queries are registered and removed in an arbitrary fashion against whole data streams or sliding windows. In addition to theoretical analysis, our performance study indicates that the proposed techniques are indeed scalable with respect to the number of input queries as well as the number of items and the item arrival rate in a data stream.

Relevância:

100.00% 100.00%

Publicador:

Resumo:

The negative effects of very low birthweight on intellectual development have been well documented, and more recently this effect has been shown to generalise to birthweights within the normal range. In this study we investigate the etiology of this relationship by using a classical twin design to disentangle the contributions of genes and environment. A previous Dutch study (Boomsma et al., 2001) examining these effects indicated that genes were important in mediating the association of birthweight to full IQ measured at ages 7 and 10, but not at ages 5 and 12. Here the association between birthweight and IQ at age 16 is considered (N = 523 twin pairs). Using variance components modeling we found that the genetic variance in birthweight (4%) completely overlapped with that in verbal IQ but not performance or full IQ. Results further showed the importance of shared environmental effects on birthweight (similar to 60%) but not on IQ (with genes explaining up to 72% of IQ variance). Models incorporating a direction of causation parameter between birthweight and IQ provided adequate fit to the data in either causal direction for performance and full IQ, but the model with verbal 10 causing birthweight was preferred to one in which birthweight influenced verbal IQ. As the measurement of birthweight precedes the measurement of twins' IQ at age 16, the influence of verbal IQ might be better considered as a proxy for parents' 10 or education, and it is possible that brighter mothers provide better prenatal environments for their children.

Relevância:

100.00% 100.00%

Publicador:

Resumo:

In the last decade, with the expansion of organizational scope and the tendency for outsourcing, there has been an increasing need for Business Process Integration (BPI), understood as the sharing of data and applications among business processes. The research efforts and development paths in BPI pursued by many academic groups and system vendors, targeting heterogeneous system integration, continue to face several conceptual and technological challenges. This article begins with a brief review of major approaches and emerging standards to address BPI. Further, we introduce a rule-driven messaging approach to BPI, which is based on the harmonization of messages in order to compose a new, often cross-organizational process. We will then introduce the design of a temporal first order language (Harmonized Messaging Calculus) that provides the formal foundation for general rules governing the business process execution. Definitions of the language terms, formulae, safety, and expressiveness are introduced and considered in detail.

Relevância:

100.00% 100.00%

Publicador:

Resumo:

This paper investigates the performance of EASI algorithm and the proposed EKENS algorithm for linear and nonlinear mixtures. The proposed EKENS algorithm is based on the modified equivariant algorithm and kernel density estimation. Theory and characteristic of both the algorithms are discussed for blind source separation model. The separation structure of nonlinear mixtures is based on a nonlinear stage followed by a linear stage. Simulations with artificial and natural data demonstrate the feasibility and good performance of the proposed EKENS algorithm.

Relevância:

100.00% 100.00%

Publicador:

Resumo:

The 'season of birth' effect is one of the most consistently replicated associations in schizophrenia epidemiology. In contrast, the association between season of birth and development in the general Population is relatively poorly understood. The aim of this study was to explore the impact of season of birth on various anthropometric and neurocognitive variables from birth to age seven in a large, community-based birth cohort. A sample of white singleton infants born after 37 weeks gestation (n =22,123) was drawn from the US Collaborative Perinatal Project. Anthropometric variables (weight, head circumference, length/height) and various measures of neurocognitive development, were assessed at birth, 8 months, 4 and 7 years of age. Compared to surnmer/autumn born infants, winter/spring born infants were significantly longer at birth, and at age seven were significantly heavier, taller and had larger head circumference. Winter/spring born infants were achieving significantly higher scores on the Bayley Motor Score at 8 months, the Graham-Ernhart Block Test at age 4, the Wechsler Intelligence Performance and Full Scale scores at age 7, but had significantly lower scores on the Bender-Gestalt Test at age 7 years. Winter/spring birth, while associated with an increased risk of schizophrenia, is generally associated with superior outcomes with respect to physical and cognitive development. (c) 2005 Elsevier B.V. All rights reserved.

Relevância:

100.00% 100.00%

Publicador:

Resumo:

This paper considers the pros and cons of using behavioural cloning for the development of low-level helicopter automation modules. Over the course of this project several Behavioural cloning approaches have been investigated. The results of the most effective Behavioural cloning approach are then compared to PID modules designed for the same aircraft. The comparison takes into consideration development time, reliability, and control performance. It has been found that Behavioural cloning techniques employing local approximators and a wide state-space coverage during training can produce stabilising control modules in less time than tuning PID controllers. However, performance and reliabity deficits have been found to exist with the Behavioural Cloning, attributable largely to the time variant nature of the dynamics due to the operating environment, and the pilot actions being poor for teaching. The final conclusion drawn here is that tuning PID modules remains superior to behavioural cloning for low-level helicopter automation.

Relevância:

50.00% 50.00%

Publicador:

Resumo:

The schema of an information system can significantly impact the ability of end users to efficiently and effectively retrieve the information they need. Obtaining quickly the appropriate data increases the likelihood that an organization will make good decisions and respond adeptly to challenges. This research presents and validates a methodology for evaluating, ex ante, the relative desirability of alternative instantiations of a model of data. In contrast to prior research, each instantiation is based on a different formal theory. This research theorizes that the instantiation that yields the lowest weighted average query complexity for a representative sample of information requests is the most desirable instantiation for end-user queries. The theory was validated by an experiment that compared end-user performance using an instantiation of a data structure based on the relational model of data with performance using the corresponding instantiation of the data structure based on the object-relational model of data. Complexity was measured using three different Halstead metrics: program length, difficulty, and effort. For a representative sample of queries, the average complexity using each instantiation was calculated. As theorized, end users querying the instantiation with the lower average complexity made fewer semantic errors, i.e., were more effective at composing queries. (c) 2005 Elsevier B.V. All rights reserved.