Invention Grant
- Patent Title: Spreadsheet compiler for stream processing
-
Application No.: US15018671Application Date: 2016-02-08
-
Publication No.: US10691881B2Publication Date: 2020-06-23
- Inventor: Martin J. Hirzel , Rodric Rabbah , Philippe Suter , Olivier Tardieu , Mandana Vaziri
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Scully, Scott, Murphy & Presser, P.C.
- Agent Samuel Waldbaum, Esq.
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F40/18

Abstract:
A method, system and computer readable program product are disclosed for compiling a spreadsheet to execute stream processing in a computing system. In an embodiment, the method comprises extracting a function from the spreadsheet, said function supporting data windows and stream partitioning in the computing system; and identifying input cells of the spreadsheet for holding input values for the function, and identifying output cells of the spreadsheet for holding output values of the function. In embodiments of the invention, a data stream is partitioned into a plurality of data stream partitions, and the extracted function is applied to the stream partitions in parallel. In embodiments of the invention, the extracted function is applied to the data stream partitions in series. The windows may be time based windows, and may be count based windows, and the windows may have variable sizes.
Public/Granted literature
- US20170228357A1 SPREADSHEET COMPILER FOR STREAM PROCESSING Public/Granted day:2017-08-10
Information query