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. 14, 2017
Filed:
Jun. 28, 2012
Ashraf Aboulnaga, Waterloo, CA;
Andrey Balmin, San Jose, CA (US);
Kevin S. Beyer, San Francisco, CA (US);
Iman Elghandour, Alexandria, EG;
Fei Yen Chiang, Toronto, CA;
Daniele Costante Zilio, Georgetown, CA;
Calisto Paul Zuzarte, Pickering, CA;
Ashraf Aboulnaga, Waterloo, CA;
Andrey Balmin, San Jose, CA (US);
Kevin S. Beyer, San Francisco, CA (US);
Iman Elghandour, Alexandria, EG;
Fei Yen Chiang, Toronto, CA;
Daniele Costante Zilio, Georgetown, CA;
Calisto Paul Zuzarte, Pickering, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method, computer-implemented system, and computer program product for creating indexes over XML data managed by a database system are provided. The method, computer-implemented system, and computer program product provide for receiving a workload for the XML data, the workload including one or more database statements, utilizing an optimizer of the database system to enumerate a set of one or more path expressions by creating a virtual universal index based on the workload received and matching a path expression to the virtual universal index, and recommending one or more path expressions from the set of one or more candidate path expressions to create the indexes over the XML data.