International Business Machines Corporation

Amazon Technologies, Inc.

Jeffrey Ralph Ruggles

Joel Frank Farber

Nathan Daniel Church

Teresa Lynn Leamon

Patrick Michael Malone

Yun Yu Wang

Guogen Zhang

Julien Jacques Ellie

Jerry Mukai

Brian Scott Dreher

Christopher John Crone

Stephen Yao Ching Chen

Hsin-Liang Huang

Desai Paramesh Sampatrai

Daniel M Haller

Nanda Madhugiri Vijaydev

Shilpa Mohan

Donald B Langworthy

David Geyer

Vidit Ochani

Jayashree Ramachandran

Aparna Shikhare

Amir Shmuel Bar-Or

Shikha Verma

A system and method for project-based uniform data analytics in a provider network. The system and method provide data projects. A data project is a secure container that brings people, data, and tools together to enable easy collaboration and access management for data analytic projects. A data project enables a group of users to collaborate on a particular business use case for producing and consuming data. A data project and its content are subject to their own access controls so that only authorized individuals, groups, and roles can access the projects and data that project has subscribed to, and only use tools permitted by project permissions.

Project-based unified data analytics in a provider network

The present invention provides methods and systems for a customizable collector application, which automates multiple diagnostic techniques to obtain sets of diagnostic information. The collector application is easily customizable for use by different products, and may reduce the diagnostic information gathering to a single session. This includes gathering all of the required sets of information about a product problem, the hardware environment, the maintenance levels of the operating system environment, and the involved middleware, both local and distributed. In addition, the collector application has a reusable framework designed to have minor external customization for each product that requires its' service. The output of the collector application may be provided in a format, such as XML, that is viewable by another application, such as browser.

Customizable system for the automatic gathering of software service information

A mechanism minimizes the management issues of the participant objects of the logical target set, such as an application set. The mechanism maps the current physical implementation. The mechanism then identifies the target and extraneous object set locations to facilitate isolation. Thereafter, the mechanism optimizes the logical target set placement for best manageability and performance. The mechanism minimizes the management issues by providing a small application footprint. This is accomplished by placing the object set on the fewest necessary volumes to facilitate both application performance and independence of administrative action.

Automatic management of dependencies between physical and logical elements in an application set

A computer implemented method, apparatus, and computer usable program code to compare a base model to a desired model to identify changes needed to form the desired model. The changes are placed in a data structure containing a set of elements, wherein the set of elements identify a set of structural database entities and a set of changes to the set of structural database entities. Changes are made to a target model using the data structure to form a resulting model.

Method and apparatus for database change management

Disclosed is a method, system, and program for performing a join operation on a multi-column table and at least two satellite tables having a join condition. Each satellite table is comprised of multiple rows and at least one join column. The multi-column table is comprised of multiple rows and at least one column corresponding to the join column in each satellite table. A join operation is performed on the rows of the satellite tables to generate concatenated rows of the satellite tables. One of the concatenated rows is joined to the multi-column table and a returned entry from the multi-column table is received. A determination is then made as to whether the returned entry matches the search criteria. If so, a determination is made as to whether one of the satellite tables has duplicates of values in the join column of the returned matching entry or the multi-column table has duplicate entries in the join columns. Returned matching entries are generated for each duplicate value in the satellite tables and duplicate entry in the multi-column table.

Method, system, and program for a join operation on a multi-column table and satellite tables including duplicate values

A method, apparatus and article of manufacture for computer implemented method of efficiently executing built-in functions is defined. Function modules are defined to process a single data type class and to process as many functions as possible before returning to the caller. Functions related to a query are each assigned a key, a type of code, to indicate the data type class to which the function belongs. The functions are then ordered so that a particular module scope can be held as long as possible. Further, data fields, another type of code containing optimization information, can be added to the functions to further enable the holding of module scope. Finally, the functions are executed at runtime. During execution, the database system looks ahead at upcoming functions in an attempt anticipate the next course of action by examining the keys and data fields. Various additional optimization techniques can then be used to enhance runtime performance.

Method and apparatus for efficiently executing built-in functions

Growing community of inventors

Sunnyvale, CA, United States of America

Jeffrey Ralph Ruggles