Patents by Inventor Stephen Andrew Brodsky
Stephen Andrew Brodsky has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10031830Abstract: 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.Type: GrantFiled: October 13, 2006Date of Patent: July 24, 2018Assignee: International Business Machines CorporationInventors: Stephen Andrew Brodsky, Holger Karn, Kevin Michael McBride, Peter Wansch, Maryela Evelin Weihrauch
-
Patent number: 9715438Abstract: 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.Type: GrantFiled: June 29, 2007Date of Patent: July 25, 2017Assignee: International Business Machines CorporationInventors: William Robert Bireley, Stephen Andrew Brodsky, Jaijeet Chakravorty, Anshul Dawra, Swaminathan Gounder
-
Patent number: 9489418Abstract: 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.Type: GrantFiled: April 27, 2007Date of Patent: November 8, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Stephen Andrew Brodsky, Ardeshir Jamshidi, Rebecca B. Nin, Brian Gerrit Payton, Sonali Surange
-
Patent number: 9129000Abstract: 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.Type: GrantFiled: April 30, 2010Date of Patent: September 8, 2015Assignee: International Business Machines CorporationInventors: Vijay R. Bommireddipalli, Stephen Andrew Brodsky, David Wei-Jye Chang, Anshul Dawra, Randall William Horman, Tony Kai-chi Leung, Paul Arnold Ostler
-
Patent number: 9047337Abstract: 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.Type: GrantFiled: April 27, 2007Date of Patent: June 2, 2015Assignee: International Business Machines CorporationInventors: Azadeh Ahadian, Stephen Andrew Brodsky, Ardeshir Jamshidi, Rebecca B. Nin, Brian Gerrit Payton, Sonali Surange
-
Patent number: 9020939Abstract: 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.Type: GrantFiled: June 30, 2009Date of Patent: April 28, 2015Assignee: International Business Machines CorporationInventors: Stephen Andrew Brodsky, Zeus Orion Courtois, Tom William Jacopi, Michael Yiupun Kwong, Tony Kai-chi Leung, Sonali Surange
-
Patent number: 8825634Abstract: 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.Type: GrantFiled: March 6, 2013Date of Patent: September 2, 2014Assignee: International Business Machines CorporationInventors: Stephen Andrew Brodsky, Zeus Orion Courtois, Anshul Dawra, Tom William Jacopi, Tony Kai-chi Leung, Sonali Surange
-
Patent number: 8566793Abstract: 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.Type: GrantFiled: April 27, 2007Date of Patent: October 22, 2013Assignee: International Business Machines CorporationInventors: Azadeh Ahadian, Stephen Andrew Brodsky, Ardeshir Jamshidi, Rebecca B. Nin, Brian Gerrit Payton, Sonali Surange
-
Patent number: 8473915Abstract: Embodiments of the invention provide coverage analysis of database elements accessed by a software application, thus providing improved and more complete testing of database-aware applications. In one embodiment, database elements accessed by the software application are determined during a run-time test of the software application.Type: GrantFiled: August 3, 2007Date of Patent: June 25, 2013Assignee: International Business Machines CorporationInventors: Stephen Andrew Brodsky, Anshul Dawra, Swaminathan Gounder, Brandon Wirick
-
Patent number: 8417691Abstract: 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.Type: GrantFiled: December 9, 2009Date of Patent: April 9, 2013Assignee: International Business Machines CorporationInventors: Stephen Andrew Brodsky, Zeus Orion Courtois, Anshul Dawra, Tom William Jacopi, Tony Kai-chi Leung, Sonali Surange
-
Patent number: 8392880Abstract: Embodiments of the invention provide application development tools that allow developers to rapidly build database-aware applications and database unit tests. Embodiments of the invention support multiple scenarios for database-aware application development, including beginning from a database table and automatically creating application code to access the table, beginning from an existing database query, beginning from existing application code that accesses a database, and hybrids or variations of these approaches.Type: GrantFiled: April 27, 2007Date of Patent: March 5, 2013Assignee: International Business Machines CorporationInventors: Azadeh Ahadian, Stephen Andrew Brodsky, Rebecca B. Nin, Sonali Surange
-
Patent number: 8375351Abstract: Embodiments of the invention provide an IDE tool that provides rapid application development features for a variety of disparate data sources. Further, developers may customize and extend the rapid application development features to suit their development needs in a particular case. In a particular embodiment, the rapid application development template may be configured to generate a set of configuration files localized used to deploy a “lightweight” application, such as a web-service, to a particular application server.Type: GrantFiled: June 23, 2007Date of Patent: February 12, 2013Assignee: International Business Machines CorporationInventors: Azadeh Ahadian, Stephen Andrew Brodsky, Anshul Dawra, Vasantha Jayakumar, Rebecca B. Nin, Michael Leon Pauser, Michael Schenker, Sonali Surange, Daya Vivek, Maryela Evelin Weihrauch
-
Patent number: 8276117Abstract: Embodiments of the invention provide techniques for displaying and refactoring of programs, including database statements. In one embodiment, database statements embedded in the program source are evaluated to identify statements of the source code affected by, or affecting, the changed element of the database. An indication of the statements of source code affected by or affecting the changed element of the database may be presented to a user.Type: GrantFiled: August 3, 2007Date of Patent: September 25, 2012Assignee: International Business Machines CorporationInventors: Azadeh Ahadian, Stephen Andrew Brodsky, Michael George Burke, Rebecca B. Nin, Igor Peshansky, Mukund Raghavachari, Sonali Surange
-
Patent number: 8145655Abstract: Provided are a method, system, and article of manufacture for generating information on database queries in source code into object code compiled from the source code. Source code including query statements to perform operations with respect to a database is translated into executable object code. A statement descriptor for at least one query statement is generated into the object code, wherein the statement descriptor for the at least one query statement includes information on the query statement including the query statement in the source code. The statement descriptors in the object code are processed to output information on the query statements indicated in the statement descriptors.Type: GrantFiled: June 22, 2007Date of Patent: March 27, 2012Assignee: International Business Machines CorporationInventors: William Robert Bireley, Delmar Eugene Blevins, Stephen Andrew Brodsky, Jaijeet Chakravorty, Anshul Dawra, Suavi Ali Demir, Swaminathan Gounder
-
Patent number: 8090735Abstract: Provided are techniques for generating a result set. A statement that includes at least one statement pattern is received, wherein each statement pattern is a template that indicates how a statement is to be modified for execution against a data store and wherein each statement pattern modifies program logic and control flow. Each statement pattern is expanded to generate one or more new statements, wherein each statement pattern is capable of being expanded to zero or more statement patterns. The one or more new statements are executed against a data store to obtain a result set. It is determined whether to modify the result set based on the at least one statement pattern. In response to determining that the result set is to be modified, modifying the result set.Type: GrantFiled: June 22, 2007Date of Patent: January 3, 2012Assignee: International Business Machines CorporationInventors: William Robert Bireley, Delmar Eugene Blevins, Stephen Andrew Brodsky, Curt Lee Cotner, Anshul Dawra, Swaminathan Gounder, Daya Vivek, Maryela Evelin Weihrauch
-
Publication number: 20100332473Abstract: 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.Type: ApplicationFiled: June 30, 2009Publication date: December 30, 2010Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Stephen Andrew Brodsky, Zeus Orion Courtois, Tom William Jacopi, Michael Yiupun Kwong, Tony Kai-chi Leung, Sonali Surange
-
Patent number: 7779047Abstract: Provided are techniques for storing data. Invocation of a data access service is received, wherein the invocation identifies a data structure storing one or more data elements having a data format. An update handler to be plugged into a data access framework is identified, wherein the update handler processes data elements having the data format. Under control of the update handler, data elements are accessed in the data structure; one or more statements for storing the data elements into the data store are determined; and the one or more statements are forwarded to the data access framework.Type: GrantFiled: June 22, 2007Date of Patent: August 17, 2010Assignee: International Business Machines CorporationInventors: William Robert Bireley, Delmar Eugene Blevins, Stephen Andrew Brodsky, Anshul Dawra, Swaminathan Gounder, Timo Juhani Salo, Brandon Jacob Wright Smith
-
Patent number: 7594217Abstract: Provided are a method, system, and program for matching client interfaces with service interfaces. A client component includes at least one client interface and a target component includes at least one service interface. A data structure for the client component associates at least one client interface in the client component with one target component. For each client interface indicated in the data structure, a determination is made as whether there is one service interface in the target component associated with the client interface that is compatible with the client interface.Type: GrantFiled: December 7, 2004Date of Patent: September 22, 2009Assignee: International Business Machines CorporationInventors: Michael Beisiegel, Stephen Andrew Brodsky, Jean-Sebastien Michel Delfino, Zhaohui Feng, Anh-Khoa Dinh Phan
-
Publication number: 20090037893Abstract: Embodiments of the invention provide coverage analysis of database elements accessed by a software application, thus providing improved and more complete testing of database-aware applications. In one embodiment, database elements accessed by the software application are determined during a run-time test of the software application.Type: ApplicationFiled: August 3, 2007Publication date: February 5, 2009Inventors: Stephen Andrew Brodsky, Anshul Dawra, Swaminathan Gounder, Brandon Wirick
-
Publication number: 20090037873Abstract: Embodiments of the invention provide techniques for displaying and refactoring of programs including databases statements. In one embodiment, database statements embedded in the program source are evaluated to identify statements of the source code affected by, or affecting, the changed element of the database. An indication of the statements of source code affected by or affecting the changed element of the database may be presented to a user.Type: ApplicationFiled: August 3, 2007Publication date: February 5, 2009Inventors: Azadeh Ahadian, Stephen Andrew Brodsky, Michael George Burke, Rebecca B. Nin, Igor Peshansky, Mukund Raghavachari, Sonali Surange