The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 04, 2025
Filed:
Jan. 31, 2024
Sap SE, Walldorf, DE;
Yu Ma, Xi'an, CN;
Jing He, Xi'an, CN;
Fu-qiang Lv, Xi'an, CN;
Haotian Zhou, Xi'an, CN;
Xiaotao Wang, Xi'an, CN;
SAP SE, Walldorf, DE;
Abstract
Systems and methods described herein relate to automatic index recommendations for improved database query performance. Candidate indexes are identified. The candidate indexes are associated with a database query that is classified as a slow query. A feature vector is generated for each candidate index to represent statement features and statistical features associated with the candidate index. The feature vectors are provided to one or more machine learning models to obtain an index recommendation value for each candidate index. An index recommendation is presented at a user device. The index recommendation identifies a first index of the candidate indexes based at least partially on the index recommendation value obtained for the first index. User input indicative of a user selection of the first index is received. A database schema is updated to include the first index in response to the user input.