International Business Machines Corporation

Tony Kai-chi Leung

Stephen Andrew Brodsky

Anshul Dawra

Sonali Surange

Tom William Jacopi

Zeus Orion Courtois

Stan Wong

Reiner Kraft

Eugene Jon Shekita

Marcus Felipe Fontoura

Sridhar Rajagopalan

Paul Arnold Ostler

Andreas Neumann

Jason Yeong Zien

Terry Michael Bleizeffer

John A McPherson, Jr

Runping Qi

Randall William Horman

Michael Yiupun Kwong

David Wei-Jye Chang

Cheung-Yuk Wu

Vijay R Bommireddipalli

Allan Eugene Gillespie

Eileen Felicia Kopp

Maxime Romain Tiran

Siu Nang See

According to one embodiment of the present invention, a system enables control of database applications. The system comprises a computer system including a database application to provide access to a database system, and at least one processor. The computer system requests retrieval of application specific property information for the database application from a data repository, and applies the retrieved application specific property information to the database application to control operation of the database application. Embodiments of the present invention further include a method and computer program product for controlling database applications in substantially the same manner described above.

Method and system for centralized control of database applications

Provided are techniques for invoking with a processor executing on a computer a source code parser to obtain source information that includes a first location of an Application Programming Interface (API) call and parameters of the API call in source code of a client application, where the parameters the API call do not include query text for a query that is to be used to access a database; examining a stack trace to determine a second location of the API call in the stack trace; and deriving the query of the API call and a third location of the query in the source code by identifying the query in the stack trace at the location of the API call in the stack trace.

Correlating queries issued by applications with their source lines and analyzing applications for problem determination and where used analysis

Provided are techniques for collecting client information for client applications running on a client computer, wherein the client information includes a client application identifier for each client application that issues queries to a database along with text of each of the queries that the client application issues; collecting database monitoring information that includes text of each query issued against the database and performance information for each query; combining the client information and the database monitoring information based on the text of the queries to obtain combined information that provides the client application identifier and the performance information for each of the queries; and identifying a problem query and at least one client application that has issued the problem query using the combined information.

Client and database problem determination and monitoring

Provided are techniques for handling error documents. One or more entries for error documents are stored in a text index. A document with a document identifier is received. It is determined whether the document has an entry in the text index.

Handling error documents in a text index

Provided are techniques for defining a web crawl space to be crawled. A seed list including one or more seed names is received from a user, wherein each seed name represents a website. In response to receiving the seed list, a web crawl space for the received seed list is generated by generating one or more allow rules.

Defining a web crawl space

Provided is a technique for building an index. A new indexis built and an anchor text tableand a duplicates tableare output using a store, a delta store, and previously generated global analysis computations, wherein the previously generated global analysis computationsinclude an anchor text table, a rank table, and a duplicates table. New global analysis computationsare generated using the anchor text tablei+1, the duplicates table, and the previously generated global analysis computations.

Pipelined architecture for global analysis and index building

A method, apparatus, and article of manufacture for computer-implemented creation of customized tree. A customized tree is created in a computer from an original tree. The original tree contains objects from a data storage device connected to the computer. One or more objects are selected from the original tree to be contained in the customized tree in response to user input. The selected objects are linked in a user-specified manner.

Creation of customized trees

The present invention discloses a method, apparatus, and article of manufacture for monitoring performance of a parallel database in a computer. In accordance with the present invention, the parallel database is stored on a data storage device in the computer. Groups of database nodes are identified. Collection time periods for collecting performance statistics from the identified group of database nodes are determined. Performance statistics are periodically collected from a subset of each identified group of nodes during the collection time periods. The collected performance statistics are stored in a memory connected to the computer and re-used when collecting performance statistics from one or more groups of database nodes in a succeeding collection time period.

Monitoring a large parallel database through dynamic grouping and sequential sampling

Growing community of inventors

San Jose, CA, United States of America

Tony Kai-chi Leung