# US 2012/0084250 A1 · Data write-back to data provider from individual grid cells

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

- Number: US 2012/0084250 A1
- Document ID: US20120084250A1
- Status: Published application
- Kind: A1
- Application number: 12/894,241
- Filed: 2010-09-30
- Published: 2012-04-05
- Earliest claimed: 2010-09-30
- Assignees: Microsoft Corporation
- Inventors: Sergei Gundorov; Pablo Trejo Montemayor; Sreepada Santhegudda
- Web page: https://patentgrep.com/patent/US20120084250A1

## CPC

- G06F 16/23: Updating
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Architecture that provides an asymmetrical data approach to data write-back to a backend data store. Write-back is accomplished from a grid cell to a data provider (e.g., OLAP (online analytical processing)) that handles UPDATE CUBE statements. The coordinates of the data to access from the cube are provided in a first cell. In a second cell, the user provides the value desired to send back to the cube and a reference to the first cell that contains data value coordinates property. A calculation is triggered to determine if there is a difference in the value at the coordinates provided in the first cell and the user-supplied value in the second cell. If there is a difference, then the properties of the cube value function associated with the first cell are used to construct the UPDATE CUBE statement to send back the user-provided value to the data location defined by the coordinates.

## Claims

### Claim 1

A computer-implemented write-back system having computer readable media that store executable instructions executed by a processor, comprising:
a data grid having a first cell associated with a function, the function retrieves a data value from a data location of a backend data store and inserts the data value into the first cell; and
a write-back component that utilizes a write-back function to write-back a new data value to the data location in the data store.

### Claim 2 (depends on 1)

The system of claim 1, wherein the first cell is associated with a property that contains coordinates of the data location from which the data value is retrieved.

### Claim 3 (depends on 1)

The system of claim 1, wherein the new data value is associated with a data entry cell and write-back is triggered in response to the data value in the first cell being different than the new data value in the data entry cell.

### Claim 4 (depends on 3)

The system of claim 3, wherein the write-back component is in association with the data entry cell and a trigger cell, the trigger cell associated with a user-defined function as the write-back function that constructs, validates, and executes an update statement during calculation.

### Claim 5 (depends on 3)

The system of claim 3, wherein the write-back component is in association with the data entry cell and a trigger cell, the trigger cell associated with a user-defined function as the write-back function that constructs, validates, and returns an update trigger directive.

### Claim 6 (depends on 1)

The system of claim 1, wherein the write-back component utilizes the write-back function to transform coordinates of a property associated with the first cell and the new data value of a manual data entry cell into a statement that is sent to the data store for the write-back of the new data value.

### Claim 7 (depends on 6)

The system of claim 6, wherein the statement is an UPDATE CUBE statement that is compatible with the data store, which is an OLAP (online analytical processing) data store.

### Claim 8 (depends on 6)

The system of claim 6, wherein the data grid is a spreadsheet.

### Claim 9

A computer-implemented write-back system having computer readable media that store executable instructions executed by a processor, comprising:
a data grid having a first cell that maintains coordinates of a data value in a cell support function, the support function retrieves the data value from a data location of a data store defined by the coordinates and inserts the data value into the first cell; and
a write-back component that utilizes a write-back function to write-back a new data value from a data entry cell to the data location in the data store, the write-back triggered in realtime in response to the new data value being different than the data value.

### Claim 10 (depends on 9)

The system of claim 9, wherein the write-back component utilizes the write-back function to transform coordinates of a property associated with the first cell and the new data value of the data entry cell into a statement that is sent to the data store for the write-back of the new data value.

### Claim 11 (depends on 9)

The system of claim 9, wherein the write-back component is in association with the data entry cell and a user-defined function as the write-back function that constructs, validates, and executes an update statement during calculation.

### Claim 12 (depends on 9)

The system of claim 9, wherein the write-back component is in association with the data entry cell and a user-defined function as the write-back function that constructs, validates, and returns an update trigger directive.

### Claim 13 (depends on 9)

The system of claim 9, wherein the write-back component has an associated function that employs an allocation rule as a parameter.

### Claim 14

A computer-implemented write-back method executed by a processor, comprising:
receiving a first cell of a data grid, the first cell having a data value;
maintaining coordinates of a data location in a data store from which the data value is retrieved in association with the first cell;
inserting into a second cell a new data value;
checking for a difference between the data value and the new data value; and
automatically performing write-back of the new data value to the data location in response to a detected difference.

### Claim 15 (depends on 14)

The method of claim 14, further comprising performing the write-back to a data cube using an UPDATE CUBE statement.

### Claim 16 (depends on 15)

The method of claim 15, further comprising writing back the new data value to the data location using a write-back function that takes as input at least the coordinates and the new data value.

### Claim 17 (depends on 14)

The method of claim 14, further comprising performing the write-back using a statement that is compatible with the data store, which is an OLAP data store.

### Claim 18 (depends on 14)

The method of claim 14, further comprising associating a user-defined function with the second cell that constructs, validates, and executes an update statement during a calculation process.

### Claim 19 (depends on 14)

The method of claim 14, further comprising associating a user-defined function with the second cell that constructs, validates, and returns a write-back directive.

### Claim 20 (depends on 14)

The method of claim 14, further comprising committing a transaction in conjunction with an update statement.
