18211185. CUSTOM REPLACEMENT OF FUNCTIONS WITH INVERSE FUNCTIONS FOR IMPROVED QUERY PERFORMANCE (SAP SE)
Contents
CUSTOM REPLACEMENT OF FUNCTIONS WITH INVERSE FUNCTIONS FOR IMPROVED QUERY PERFORMANCE
Organization Name
Inventor(s)
Heiko Gerwens of Heidelberg (DE)
Johannes Merx of Heidelberg (DE)
CUSTOM REPLACEMENT OF FUNCTIONS WITH INVERSE FUNCTIONS FOR IMPROVED QUERY PERFORMANCE
This abstract first appeared for US patent application 18211185 titled 'CUSTOM REPLACEMENT OF FUNCTIONS WITH INVERSE FUNCTIONS FOR IMPROVED QUERY PERFORMANCE
Original Abstract Submitted
Techniques and solutions are provided for improving query performance using inverse functions. Often a function is used to perform operations such as data type conversions. The use of these functions can be resource intensive, such as if a conversion needs to be performed for all rows of a particular relational database table. The present disclosure allows for the registration of inverse functions that can be used, or at least be considered for use, in place of a function. A given inverse function can be associated with its function using techniques such as maintaining mapping information or using a particular naming convention. A particular syntax is provided for designating and creating an inverse function.
