window function
[/ˈwɪndoʊ ˈfʌŋkʃən/]
nounpl: window functions
função de janela
1. In signal processing and mathematics, a mathematical function that is zero-valued outside a chosen interval, used to taper or smooth data at the boundaries to reduce spectral leakage
The Hamming window function is commonly used in digital signal processing to reduce spectral leakage.
A função de janela de Hamming é comumente usada no processamento de sinais digitais para reduzir o vazamento espectral.
2. In SQL and database systems, an analytical function that performs calculations across a set of rows related to the current row within a defined window frame
We used a window function with OVER clause to calculate the running total of sales for each month.
Usamos uma função de janela com a cláusula OVER para calcular o total acumulado de vendas para cada mês.
3. In data analysis, a technique for computing values over a subset or partition of data while maintaining the original row structure
Window functions allow us to rank employees within their departments without losing the original data rows.
As funções de janela nos permitem classificar funcionários dentro de seus departamentos sem perder as linhas de dados originais.
This is primarily a technical term used in software development, data science, and signal processing. It gained significant prominence in Brazil and Portugal with the widespread adoption of advanced SQL analytics and data science education. In both Brazilian and Portuguese tech communities, the term 'função de janela' is standard, though English 'window function' is also commonly used in technical documentation and code.
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →