Invention Grant
- Patent Title: Techniques for facilitating the joining of datasets
-
Application No.: US15705108Application Date: 2017-09-14
-
Publication No.: US10565222B2Publication Date: 2020-02-18
- Inventor: Glenn Allen Murray , Luis E. Rivas
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Kilpatrick Townsend & Stockton LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/248 ; G06F16/2455 ; G06F3/0481 ; G06F3/0482

Abstract:
Techniques are disclosed for a system that provides an intuitive way for merging or joining data from different datasets. The system may provide graphical interfaces to enable a user to combine or join datasets identified as having a relationship. In at least one embodiment, the system can determine options for joining datasets, such as by a left join, right join, or outer join. A graphical interface may display a visual representation (e.g., a “Glenn Diagram”) illustrate options for joining datasets based on identifying a relationship between the data sets. The representation may further illustrate one or more types of joins and information about the data, such as rows where data may be joined based on the type of join function for the relationship by columns. The visual representation may indicate where the datasets can be joined, such that they are not overlapping.
Public/Granted literature
- US20180075115A1 TECHNIQUES FOR FACILITATING THE JOINING OF DATASETS Public/Granted day:2018-03-15
Information query