International Business Machines Corporation

Iman Elghandour

Calisto Paul Zuzarte

Kevin Scott Beyer

Andrey Balmin

Daniele Costante Zilio

Ashraf Aboulnaga

Fei Yen Chiang

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.

Index selection for XML database systems

A method, system, and computer program product for selecting indexes to be created over XML data are provided. The method, system, and computer program product provide for receiving a workload for the XML data, the workload including one or more database statements, and utilizing an optimizer to recommend a set of one or more path expressions based on the workload received, wherein the set of one or more path expressions is to be used to create one or more indexes over the XML data.

Growing community of inventors

Alexandria, Egypt

Iman Elghandour