Invention Grant
- Patent Title: Methods and systems for database optimization
-
Application No.: US16090512Application Date: 2017-03-24
-
Publication No.: US11321315B2Publication Date: 2022-05-03
- Inventor: Brett Anthony Shearer
- Applicant: WISETECH GLOBAL LIMITED
- Applicant Address: AU Alexandria
- Assignee: WISETECH GLOBAL LIMITED
- Current Assignee: WISETECH GLOBAL LIMITED
- Current Assignee Address: AU Alexandria
- Agency: Fenwick & West LLP
- Priority: AU2016901204 20160331,AU2016202911 20160505
- International Application: PCT/AU2017/050265 WO 20170324
- International Announcement: WO2017/165914 WO 20171005
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/28 ; G06F16/2455 ; G06F16/25 ; G06F16/242

Abstract:
This disclosure relates to increasing performance of database queries. A proxy server receives an input query string and a parameter value for first parameter name in the query string. The proxy server determines a second parameter name based on the parameter value and different to the first parameter name. The proxy server then determines an output query string based on the input query string. The output query string comprises a filter clause with a field name and a second field value, the second field value of the output query string being based on the second parameter name. The proxy server finally sends the output query string to a database management system to cause the database management system to execute a database query using an execution plan based on the second parameter name in the output query string.
Public/Granted literature
- US20190114294A1 METHODS AND SYSTEMS FOR DATABASE OPTIMISATION Public/Granted day:2019-04-18
Information query