Invention Grant
- Patent Title: Method, device, server and storage apparatus of reviewing SQL
-
Application No.: US15579376Application Date: 2017-05-09
-
Publication No.: US10402402B2Publication Date: 2019-09-03
- Inventor: Song Hou , Yeung Wong
- Applicant: PING AN TECHNOLOGY (SHENZHEN) CO., LTD.
- Applicant Address: CN Shenzhen, Guangdong
- Assignee: PING AN TECHNOLOGY (SHENZHEN) CO., LTD.
- Current Assignee: PING AN TECHNOLOGY (SHENZHEN) CO., LTD.
- Current Assignee Address: CN Shenzhen, Guangdong
- Agency: Polsinelli PC
- Priority: CN201610860550 20160928
- International Application: PCT/CN2017/083645 WO 20170509
- International Announcement: WO2018/058959 WO 20180405
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/2453 ; G06F11/34 ; G06F16/21

Abstract:
A method of reviewing SQL includes: obtaining slow log data; extracting a SQL sentence to be reviewed and basic information matched with the SQL sentence from the slow log data; identifying and parsing the SQL sentence to obtain a parsed result; reviewing the parsed result and/or the basic information in accordance with review items in a preset review template one by one to obtain a review result; and generating a review result set according to the review result.
Public/Granted literature
- US20190228008A1 METHOD, DEVICE, SERVER AND STORAGE APPARATUS OF REVIEWING SQL Public/Granted day:2019-07-25
Information query