# US 2009/0276482 A1 · Automated offloading of user-defined functions to a high performance computing system

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2009/0276482 A1
- Document ID: US20090276482A1
- Status: Published application
- Kind: A1
- Application number: 12/113,930
- Filed: 2008-05-01
- Published: 2009-11-05
- Earliest claimed: 2008-05-01
- Assignees: Microsoft Corporation
- Inventors: Chris L. Rae; Charles David Ellis; Mark Dalin Parris; Minggiang Xu
- Web page: https://patentgrep.com/patent/US20090276482A1

## CPC

- G06F 9/5027: {the resource being a machine, e.g. CPUs, Servers, Terminals}
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 2209/509: Offload
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Technologies are described herein for the automated offloading of the execution of a user-defined function (“UDF”) to a high performance computing (“HPC”) system. When a request is received to calculate a workbook that references a UDF, a spreadsheet application program determines, based upon a tag set by the UDF, whether the UDF is safe for execution on the HPC system. If the UDF is safe for execution on the HPC system, the spreadsheet application program causes the UDF to be executed on the HPC system using a connector that communicates with the HPC system to cause the UDF to be executed thereupon. A container executing on the HPC system emulates interfaces provided by the spreadsheet application program and is utilized to execute the UDF. Results of the execution of the UDF on the HPC system may be returned asynchronously to the connector and to the spreadsheet application program.

## Claims

### Claim 1

A method for offloading the execution of a user-defined function (UDF) from a client computer to a high performance computing (HPC) system, the method comprising:
providing a tag within the UDF indicating whether the UDF can be executed on the HPC system;
receiving a request to execute the UDF;
in response to receiving the request to execute the UDF, determining based upon the tag whether the UDF can be executed on the HPC system; and
in response to determining that the UDF can be executed on the HPC system, executing a connector at the client computer, the connector configured to cause the UDF to be executed on the HPC system.

### Claim 2 (depends on 1)

The method of claim 1, further comprising executing the UDF on the client computer in response to determining that the UDF cannot be executed on the HPC system.

### Claim 3 (depends on 1)

The method of claim 1, wherein the connector is configured to cause a container executing on the HPC system to execute the UDF on the HPC system, the container configured to return one or more results of the execution of the UDF to the connector.

### Claim 4 (depends on 3)

The method of claim 3, wherein the UDF comprises a custom function referenced by a workbook, and wherein the request to execute the UDF comprises a request to calculate the workbook.

### Claim 5 (depends on 4)

The method of claim 4, wherein the container is configured to return the results of the execution of the UDF to the connector asynchronously.

### Claim 6 (depends on 5)

The method of claim 5, wherein the connector is configured to return the results of the execution of the UDF to a spreadsheet application program asynchronously.

### Claim 7 (depends on 6)

The method of claim 6, wherein the HPC system comprises a computing cluster.

### Claim 8 (depends on 7)

The method of claim 7, wherein the container is configured to emulate one or more interfaces provided by the spreadsheet application program.

### Claim 9

A computer storage medium having computer executable instructions stored thereon which, when executed by a computer, cause the computer to:
receive a request to execute a user-defined function (UDF), the UDF being contained within a spreadsheet add-in callable from a spreadsheet application program executing on a client computer;
in response to the request, to examine a tag set by the UDF to determine whether the UDF can be executed on the HPC system; and
in response to determining that the UDF can be executed on the HPC system, to execute a connector on the client computer, the connector configured to cause the UDF to be executed on the HPC system.

### Claim 10 (depends on 9)

The computer storage medium of claim 9, having further executable instructions stored thereon which, when executed by the computer, cause the computer to execute the UDF on the client computer in response to determining that the UDF cannot be executed on the HPC system.

### Claim 11 (depends on 9)

The computer storage medium of claim 9, wherein the connector is configured to cause a container executing on the HPC system to execute the UDF on the HPC system, the container configured to return one or more results of the execution of the UDF to the connector.

### Claim 12 (depends on 11)

The computer storage medium of claim 11, wherein the container is configured to return the results of the execution of the UDF to the connector asynchronously and the connector is configured to return the results of the execution of the UDF to the spreadsheet application program asynchronously.

### Claim 13 (depends on 12)

The computer storage medium of claim 12, wherein the UDF comprises a custom function referenced by a workbook, and wherein the request to execute the UDF comprises a request to calculate the workbook.

### Claim 14 (depends on 13)

The computer storage medium of claim 13, wherein the HPC system comprises a computing cluster.

### Claim 15

A system for offloading the execution of a user-defined function (UDF) from a client computer to a computing cluster, the system comprising:
a container capable of being executed on the computing cluster, the container configured to receive and respond to requests to execute the UDF on the computing cluster; and
a cluster connector capable of being executed on the client computer, the cluster connector configured to receive a request from a spreadsheet application program to execute the UDF on the computing cluster and, in response thereto, to communicate with the computing cluster to cause the container to execute the UDF on the computing cluster.

### Claim 16 (depends on 15)

The system of claim 15, wherein the container is further configured to receive one or more results from the UDF and to asynchronously return the results to the cluster connector.

### Claim 17 (depends on 16)

The system of claim 16, wherein the cluster connector is further configured to receive the results from the container and to asynchronously return the results to the spreadsheet application program in response to the request to execute the UDF on the computing cluster.

### Claim 18 (depends on 17)

The system of claim 17, further comprising a spreadsheet application program configured to receive a request to recalculate a workbook that references the UDF and, in response thereto, to determine whether the UDF can be executed on the computing cluster by examining a tag set by the UDF.

### Claim 19 (depends on 18)

The system of claim 18, wherein the spreadsheet application program is further configured to call the cluster connector with a request to execute the UDF on the computing cluster in response to determining that the UDF can be executed on the computing cluster.

### Claim 20 (depends on 19)

The system of claim 19, wherein the spreadsheet application program is further configured to execute the UDF on the client computer in response to determining that the UDF cannot be executed on the computing cluster.
