Window functions, also known as analytic OLAP functions, have been part of the SQL standard for more than a decade and are now a widely-used feature. Window functions allow to elegantly express many useful query types including time series analysis, ranking, percentiles, moving averages, and cumulative sums. Formulating such queries in plain SQL-92 is usually both cumbersome and inefficient. De...

todays, in many modern applications, we search for frequent and repeating patterns in the analyzed data sets. in this search, we look for patterns that frequently appear in data set and mark them as frequent patterns to enable users to make decisions based on these discoveries. most algorithms presented in the context of data stream mining and frequent pattern detection, work either on uncertai...

Vectorization of cartographic features is a difficult task in geographic information acquisition from topographic maps. This paper presents a semi-automatic approach to linear feature vectorization directly in original scanned colour topographic maps without layer separation. In the approach, a sliding window is added on a user-given linear feature, and the current line in the window is segment...

Video preserves valuable raw information. Understanding these data and then recognizing objects and tagging them are crucial to intelligent planning and decision making. Deep learning provides us an effective way to understand big data with a human-level. As traffic video is characterized by crowded scene and low definition, it will be non-effective to deal with the whole image once. An alterna...

In this work, higher-order moving average polynomials are defined by straightforward generalization of the standard moving average. The self-similarity of the polynomials is analyzed for fractional Brownian series and quantified in terms of the Hurst exponent H by using the detrending moving average method. We prove that the exponent H of the fractional Brownian series and of the detrending mov...

The forced vibration behaviors are examined for nonlocal strain gradient nanobeams with surface effects subjected to a moving harmonic load travelling with a constant velocity in terms of three beam models namely, the Euler-Bernoulli, Timoshenko and modified Timoshenko beam models. The modification for nonlocal strain gradient Timoshenko nanobeams is exerted to the constitutive equations by exc...

Non-parametric methods of Spectrum Estimation Such as Periodogram, Modified Periodogram, Welch, Bartlett and Blackman-Tukey are generally used but are not always efficient in finding out the power spectral densities. These methods lacks due to their limitations like windowing of the autocorrelation sequence, spectral leakage, poor resolution and incapability to include the available information...

In this paper, we are proposing an approach to minimize very high density salt and pepper noise through trimmed global mean. The Modified decision based unsymmetrical trimmed median filter tries to remove high density salt and pepper noise by taking the mean value of the elements within the processing window. This algorithm fails if all the elements within the processing window is either ‘0’ or...

Repeated behaviours in stable contexts can become automatic habits. Habits are resistant to information-based techniques to change behaviour, but are contextually cued, so a change in behaviour context (e.g., location) weakens habit strength and can facilitate greater consideration of the behaviour. This idea was demonstrated in previous work, whereby people with strong environmental attitudes ...