International Business Machines Corporation

Ashraf Aboulnaga

Vijayshankar Raman

Calisto Paul Zuzarte

Sam Sampson Lightstone

Peter Haas

Kevin Scott Beyer

Andrey Balmin

Volker Gerhard Markl

Daniele Costante Zilio

Ivan Popivanov

Fei Yen Chiang

Iman Elghandour

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.

There is disclosed a data processing system implemented method, a data processing system, and an article of manufacture for directing a data processing system to maintain a database table associated with an initial maintenance scheduling interval. The data processing system implemented method includes selecting a randomizing factor, and selecting a new maintenance scheduling interval for the database table based on the initial maintenance scheduling interval and the selected randomizing factor.

Method, system and program for prioritizing maintenance of database tables

Growing community of inventors

Waterloo, Canada

Ashraf Aboulnaga