# US 2010/0169758 A1 · Extracting Semantics from Data

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

- Number: US 2010/0169758 A1
- Document ID: US20100169758A1
- Status: Published application
- Kind: A1
- Application number: 12/560,389
- Filed: 2009-09-15
- Published: 2010-07-01
- Earliest claimed: 2008-09-15
- Inventors: Erik Thomsen
- Web page: https://patentgrep.com/patent/US20100169758A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Embodiments of the invention convert data from atomic tuples found in data sources such as spreadsheets (e.g., raw numbers, words, and formatted dates) into semantically enriched schemas and associated tuples. In addition to the data content, visual content, such as font and background color, is also analyzed as a part of the interpretation process. Embodiments of the invention also provide methods of interacting with the raw data via the semantically enriched schema tuples.

## Claims

### Claim 1

A computer-implemented method comprising:
(A) converting a plurality of atomic tuples, representing contents of a plurality of cells stored in a grid, into a plurality of schema tuples, comprising:
(A)(1) assigning a plurality of catalog-defined types to the plurality of atomic tuples;
(A)(2) assigning a role of locator to a subset of the plurality of cells based on the plurality of catalog-defined types; and
(A)(3) determining whether a locator tuple slice in the plurality of cells contains a missing value.