Data Architect, InfiniDB
Dipti Joshi is Data Architect with InfiniDB, Inc. Dipti Joshi joined InfiniDB in 2012. Dipti Joshi has more than 20 years of design, development, architecture, and product management experience. She has worked on software and database applications for Telecommunications, Healthcare, and Government organizations.
A windowing function as defined in ANSI SQL11 performs a calculation across a set of table rows that are somehow related to the current row. The windowing functions simplify complex analytics tasks for computing cumulative, moving, centered or reporting aggregates without requiring doing sub-queries or writing stored procedures. Existing MySQL storage engines do not support this windowing... [read more]