Invention Grant
- Patent Title: Comparing join values in database systems
-
Application No.: US14572069Application Date: 2014-12-16
-
Publication No.: US09672249B2Publication Date: 2017-06-06
- Inventor: Gerhard L. Hill
- Applicant: Gerhard L. Hill
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The present disclosure describes methods, systems, and computer program products for performing JOIN value comparisons. One computer-implemented method includes converting, by operation of a computer system, a first value of a first data type into a second value of a second data type, wherein the first value is a value of a first attribute of a first table; converting, by operation of a computer system, the second value of the second data type into a third value of a third data type; converting, by operation of a computer system, a fourth value of the third data type into a fifth value of the second data type, wherein the fourth value is a value of a second attribute of a second table; converting, by operation of a computer system, the fifth value of the second data type into a sixth value of the first data type; and performing JOIN operations of the first table and the second table in response to determining that the first value equals the sixth value, and the fourth value equals the third value.
Public/Granted literature
- US20160171049A1 COMPARING JOIN VALUES IN DATABASE SYSTEMS Public/Granted day:2016-06-16
Information query