Invention Grant
- Patent Title: Trie-structure formulation and navigation for joining
-
Application No.: US15972555Application Date: 2018-05-07
-
Publication No.: US11036717B2Publication Date: 2021-06-15
- Inventor: Cristian Petculescu , Marius Dumitru , Vasile Paraschiv , Amir Netz
- Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC
- Applicant Address: US WA Redmond
- Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee Address: US WA Redmond
- Agency: Workman Nydegger
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22

Abstract:
A computer-navigable trie structure used in order to represent predicates for matching foreign keys to primary rows in a primary table. The predicates may be wide ranging, and each may be represented by a corresponding descendant path of the trie structure, and defines which foreign keys are to be mapped to the particular row. The trie structure is built by incrementally augmenting the trie structure as each predicate is analyzed. During later use of the trie structure, each foreign key that is a candidate for mapping to one or more parent rows are evaluated. The foreign key is used to navigate through a set of one or more descendant paths of the computer-navigable trie structure. Matching parent rows may then be identified based on the identity of the navigated descendant paths. The foreign key may then be mapped to each of the one or more matching parent rows.
Public/Granted literature
- US20180253466A1 TRIE-STRUCTURE FORMULATION AND NAVIGATION FOR JOINING Public/Granted day:2018-09-06
Information query