Yue Wang

US Patent:

20220318221, Oct 6, 2022

Filed:

Jun 23, 2022

Appl. No.:

17/847902

Inventors:

- Redmond WA, US
Jie SONG - Ann Arbor MI, US
Yue WANG - Bellevue WA, US
Surajit CHAUDHURI - Kirkland WA, US
Vishal Kumar Seshagirirao ANIL - Redmond WA, US
Yaron Y. GOLAND - Seattle WA, US
Gaurav MALHOTRA - Bothell WA, US
Blake LASSITER - Seattle WA, US

Assignee:

Microsoft Technology Licensing, LLC - Redmond WA

International Classification:

G06F 16/22
G06F 16/23

Abstract:

Systems and methods relate to auto-tagging of data in a data lake or a data storage. Generating a statistical summary of the data lake and interactively receiving data in a selected column of an exemplar data addresses an issue of efficiently and accurately auto-tagging data in a data lake. The present disclosure automatically generates a statistical summary of the data lake using a lightweight off-line processing. A graphical user interface interactively receives an exemplar data file with a selection of a column in the exemplar data file. A list of candidate data-tagging patterns is generated based on the statistical summary and updates the list by removing candidate data-tagging patterns that under-generalize the data. The present disclosure determines a data-tagging pattern by selecting a candidate data-tagging profile from the list based on having the least number of matching columns in the data lake.

US Patent:

20230098926, Mar 30, 2023

Filed:

Sep 30, 2021

Appl. No.:

17/490908

Inventors:

- Redmond WA, US
Aditya KUPPA - Redmond WA, US
Kirk Hartmann FREIHEIT - Orlando FL, US
Kalen WONG - Redmond WA, US
Paula Budig GREVE - Monroe WA, US
Patrick Clinton LITTLE - Seattle WA, US
Lucas PRITZ - Redmond WA, US
Yue WANG - Bellevue WA, US
Vivek Ravindranath NARASAYYA - Redmond WA, US
Yeye HE - Bellevue WA, US
Surajit CHAUDHURI - Kirkland WA, US

International Classification:

G06F 16/215
G06F 16/2455

Abstract:

Solutions for data unification include: receiving a data record, the data record comprising a plurality of data fields; selecting, from among the plurality of data fields, a subset of the data fields, the subset of the data fields being fewer in number than the plurality of data fields, wherein selecting the subset of the data fields comprises: applying a first rule to select at least a first one of the data fields within the data record for inclusion in the subset of the data fields; using content of the subset of the data fields, generating a stable identifier (stableID) for the data record; and inserting the stableID into a primary key data field of the data record.