Microsoft Technology Licensing, LLC

Lengning Liu

Tanuja Machineni

Surajit J Chaudhuri

Vivek Ravindranath Narasayya

Yeye He

Yue Wang

Richard T Guy

Lucas Pritz

Manohar Sreenivasachar

Roji Pulimoottil Thomas

Chad Michael Heyne

Katchaguy Areekijseree

Gaurav Ghosh

Paula Budig Greve

Patrick Clinton Little

Meiyalagan Balasubramanian

Aditya Kuppa

Kirk Hartmann Freiheit

Kalen Wong

William Mohabbati

Joerg Derungs

Manu Medigesi Shivakumar

Siddhesh Ramesh Surve

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.

Data unification

Solutions for enforcing both syntactic and semantic correctness of domain-specific data queries include: receiving a data query; constraining an operation of the data query to enforce semantic correctness, wherein enforcing semantic correctness comprises: determining semantic information associated with each of a plurality of data entities; based on at least the semantic information, determining whether combining the two data entities of the plurality of data entities is allowed or is not allowed; based on at least determining that combining the two data entities is allowed, permitting combining the two data entities in the data query; and based on at least determining that combining the two data entities is not allowed, preventing combining the two data entities in the data query; and executing the data query. Some examples further include basing the permission on (at least) an ontology between the semantic information of the two data entities and a set of axioms.

Enforcing both syntactic and semantic correctness of domain-specific data queries

Systems and methods for controlling data in a hierarchy receive a data query corresponding to data organized within nodes in a data hierarchy, wherein the data hierarchy is defined by a plurality of dimensions. A data traversal of the data hierarchy is performed including a rollup operation between different nodes at different levels of the plurality of dimensions. The rollup operation aggregates data values of the nodes at the different levels. Aggregated values for different nodes at each level are output based on the rollup operation, and the data query is executed using the aggregated values for the different nodes.

Data aggregation in a hierarchy for query execution

Growing community of inventors

Redmond, WA, United States of America

Lengning Liu