Extracting Semantics from Data

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.

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.