Abstract
Background: A Window Aggregate function belongs to a class of functions, which have emerged as a very important tool for Big Data Analytics. They lend support in analysis and decisionmaking applications. A window aggregate function aggregates and returns the result by applying the function over a limited number of tuples corresponding to current tuple and hence lending support for big data analytics. We have gone through different patents related to window aggregate functions and its optimization. The cost associated with Big data analytics, especially the processing of window functions is one of the major limiting factors. However, now a number of optimizing techniques have evolved for both single as well as multiple window aggregate functions.
Methods: In this paper, the authors have discussed various optimization techniques and summarized the latest techniques that have been developed over a period through intensive research in this area. The paper tried to compare various techniques based on certain parameters like the degree of parallelism, multiple window function support, execution time etc.
Results: After analyzing all these techniques, segment tree data structure seems better technique as it outperforms other techniques on different grounds like efficiency, memory overhead, execution speed and degree of parallelism.
Conclusion: In order to optimize the window aggregate function, segment tree data structure technique is a better technique, which can certainly improve the processing of window aggregate function specifically in big data analytics.
Keywords: Window aggregate function, optimization, parallel processing, query processing, big data analytics, segment tree data structure.
Graphical Abstract
Call for Papers in Thematic Issues
Advanced Experimental, Computational Fluid Dynamics and Intelligent Computing Techniques on Complex Multiphase Flow Problems
Computational fluid dynamics (CFD) and Intelligent computing are very emerging technology in various industrial applications. Multiphase flow problems are very dominant in hydro as well as power plants, mining, marine, cementing, food processing, and ore-processing industries. Multiphase flows include gas-solid as well as liquid-solid flows. The solid like ores, ash, ...read more
Advanced materials for energy production, transmission, and utilization
Hydrogen storage and production materials: Developing high-performance hydrogen generation and storage materials, as well as researching the mechanism of hydrogen-material interaction. The emphasis for supercapacitors is on carbon-based materials derived from various biomass carbonization methods, as well as carbon-containing electrode materials such as metal sulfide, oxides, and other similar compounds. ...read more
Advancements in Machine Learning for Medical Applications in Material Science
The fusion of machine learning with medical applications and material science has ushered in a new era of innovation, offering transformative solutions to complex healthcare challenges. "Advancements in Machine Learning for Medical Applications in Material Science," a special issue, serves as a crucible for exploring the remarkable synergy between these ...read more
Computational Methods in Engineering
In recent decades, computational methods have revolutionized the field of engineering, playing a pivotal role in enhancing efficiency, accuracy, and innovation across various disciplines. This proposed thematic issue aims to explore and showcase the latest advancements, challenges, and applications of computational methods in engineering. As technology continues to evolve, computational ...read more
Related Books
Intelligent Technologies for Automated Electronic Systems
Modern Radio Signals Filtering Devices Methods, Technologies, & Structures
Functional Bio-based Materials for Regenerative Medicine: From Bench to Bedside (Part 2)
Mechanical Engineering Technologies and Applications
Multistage Interconnection Network Design for Engineers
Mechanical Engineering Technologies and Applications
Semi-rotary and Linear Actuators for Compressed Air Energy Storage and Energy Efficient Pneumatic Applications
Waste Valorization for Value-added Products
One-Dimensional Transient Flow in Pipelines Modelling and Simulation
Principles of Automation and Control
50
4
2
2