International Business Machines Corporation

Amazon Technologies, Inc.

Stephen Andrew Brodsky

Anshul Dawra

Sonali Surange

Rebecca Braun Nin

Azadeh Ahadian

Zeus Orion Courtois

Swaminathan Gounder

Timothy James Grose

Paul Arnold Ostler

Tony Leung

William Robert Bireley

Maryela Evelin Weihrauch

Brian Gerrit Payton

Gary Charles Doney

Michael Morris Golding

Rebecca Mei-Har Lau

Delmar Eugene Blevins

Tony Kai-chi Leung

Tom William Jacopi

Michael Leon Pauser

Dipayan James Gangopadhyay

Michael George Burke

Randall William Horman

Igor Peshansky

Suavi Ali Demir

Subrata Mitra

Ardeshir Jamshidi

Jaijeet Chakravorty

Vijay R Bommireddipalli

Eric X Yang

David W Chang

Wim De Pauw

Joseph Rozenfeld

Michael Yiupun Kwong

Thomas Friedrich

Todd Robert Bender

Daya Vivek

Rajendra Bhagwatisingh Panwar

Peter Wansch

Michael Schenker

Robin Meryl Noble-Thomas

Clifford D Chu

Hongdi Zhang

Benjamin Nguyen

Rohit R Thirumurthy

Sudarshan R Thitte

Curt Lee Cotner

Shyh-Mei Fang Ho

Michael Beisiegel

Holger Karn

Kevin Michael McBride

David Joseph Wisneski

Timo J Salo

Mukund Raghavachari

Zhaohui Feng

Robin Alan Golden

Roni Korenshtein

Jean-Sebastien Michel Delfino

Alexander Gennadievich Glebov

Aaron-Kenneth Karl Rehaag

Dilip Kumar Biswal

James Rush Rhyne, Ii

Anh-Khoa Dinh Phan

David Wei-Jye Chang

Hsin-Liang Huang

Shuki Binyamin

Lawrence E Dunnell

Loic Raymond Robert Julien

Shu Jung Wang

Brandon Wirick

Vasantha Jayakumar

Brandon Jacob Wright Smith

Manish Sehgal

Catalina Y Wei

A unique identifier of an expression which refers to a cell of a data sheet is stored in a repository. In an application comprising an operation based on evaluating the expression, the expression is indicated by the unique identifier. In response to detecting a write directed to the cell, a modified version of contents of the cell is stored without re-evaluating the expression. The expression is re-evaluated in response to determining that the operation of the application is to be implemented.

Expressions management service for data sheet-based applications

At a data management service, an index structure corresponding to a data sheet is stored. The data sheet comprises a grid of cells. An entry of the index structure comprises a reference to content of a cell of the data sheet. In response to a grid structure change of the data sheet, the index entry is automatically updated such that the same content remains referenced from the index entry as before. A result of a computation of an application is obtained using an identifier of the index entry to obtain content from the data sheet. The result is provided to a destination.

Index sheets for robust spreadsheet-based applications

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

An apparatus, system, and method are provided for evaluating database accesses. The apparatus may comprise a computer program that causes a computer system to exchange profiling data between a client application module and a database module; execute a database access; determine a database access policy violation at a detection point module; and selectively request context information from a context point module related to the database access.

Apparatus, system, and method for database management extensions

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 static execution of statements. Information from an execution file that describes statements that have been bound to a database during a previous execution of those statements dynamically and describes metadata about the statements is loaded. While executing a program that includes statements, for each of the statements, it is determined whether that statement is bound to the database. In response to determining that the statement is bound to the database, the statement is executed statically using the loaded information. In response to determining that the statement is not bound to the database, the statement is executed dynamically.

Static execution of statements in a program

Embodiments of the invention provide database integration within an integrated development environment (IDE) tool for displaying database structure and other database information, query editing and execution, and error detection for database statements embedded in program source code. Embodiments of the invention integrate database connectivity and error detection into the IDE tool, thereby potentially reducing the time required for database-aware application development.

Processing database queries embedded in application source code from within integrated development environment tool

According to one embodiment of the present invention, a system for processing a computer program for a distributed server environment executes the computer program in the distributed server environment in accordance with a configuration for the computer program. The computer program is generated within a development environment. The configuration indicates a type of server environment and is associated with one or more data sets for processing by the computer program. The system monitors execution of the computer program within the distributed server environment and provides a program status to the development environment. The system displays results produced by the computer program within the distributed server environment via the development environment. Embodiments of the present invention further include a method and computer program product for processing a computer program in substantially the same manners described above.

Program development in a distributed server environment

Systems, methods and articles of manufacture are disclosed for batching heterogeneous database commands. The heterogeneous database commands may include at least two database command types. Further, at least two of the heterogeneous database commands may include host variables. A request to execute the heterogeneous database commands may be received. The heterogeneous database commands may be sent to a database system for execution, responsive to the request.

Batching heterogeneous database commands

Data transfers within and between nodes in a distributed computing environment are visualized. In one aspect, the nodes are represented as geometrical shapes. The first part of the geometrical shape represents logic of the corresponding node. The second part of the geometrical shape represents storage of the corresponding node. A line connecting the first part and the second part represents data transfer between logic of a node and storage of a node. Both inter-node and intra-node transfers may be shown.

Visualizing data transfers in distributed file system

Database connectivity and database model integration within integrated development environment tool

Growing community of inventors

Los Gatos, CA, United States of America

Stephen Andrew Brodsky