Patents by Inventor David J. Wisneski
David J. Wisneski 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: 9251236Abstract: A method for synchronizing a database with displayed data, includes providing a data feed to receive data from the database to provide displayed document data, detecting a database change to the data within the database by a database synchronizer to provide a change event, polling the database synchronizer using an HTTP message to detect the change event, and pushing the database change to the displayed document data to update the displayed document data in accordance with the database change and the polling. The polling includes long polling and short polling. A polling servlet within the database synchronizer performs the polling by the database synchronizer. The database synchronizer updates the displayed document data by way of a data structure. The data structure is a queue.Type: GrantFiled: December 30, 2013Date of Patent: February 2, 2016Assignee: International Business Machines CorporationInventors: Nisha K. Nair, Dinesh K. Nirmal, Sandhya C. Turaga, David J. Wisneski
-
Patent number: 9171036Abstract: 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.Type: GrantFiled: May 15, 2009Date of Patent: October 27, 2015Assignee: International Business Machines CorporationInventors: William R. Bireley, Dilip K. Biswal, Delmar E. Blevins, Stephen A. Brodsky, Anshul Dawra, Swaminathan Gounder, Paul A. Ostler, Manish Sehgal, Catalina Y. Wei, David J. Wisneski
-
Patent number: 8725679Abstract: A method for synchronizing a database with data stored at a client includes providing a data feed to receive data by the client from the database and provide received data, caching the received data in a client side cache to provide client side cached data, detecting a database change to data within the database corresponding to the client side cached data according to a polling operation to provide a change event, pushing the change event to the client side cached data to update the client side cached data in accordance with the database change and the polling operation, requesting further data from the database, determining whether the further data includes data of the client side cached data to determine remaining data exclusive of the client side cached data and pushing the remaining data to the client side cached data.Type: GrantFiled: April 7, 2008Date of Patent: May 13, 2014Assignee: International Business Machines CorporationInventors: Nisha K. Nair, Dinesh Nirmal, Sandhya C. Turaga, David J. Wisneski
-
Publication number: 20140114912Abstract: A method for synchronizing a database with displayed data, includes providing a data feed to receive data from the database to provide displayed document data, detecting a database change to the data within the database by a database synchronizer to provide a change event, polling the database synchronizer using an HTTP message to detect the change event, and pushing the database change to the displayed document data to update the displayed document data in accordance with the database change and the polling. The polling includes long polling and short polling. A polling servlet within the database synchronizer performs the polling by the database synchronizer. The database synchronizer updates the displayed document data by way of a data structure. The data structure is a queue.Type: ApplicationFiled: December 30, 2013Publication date: April 24, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Nisha K. NAIR, Dinesh K. NIRMAL, Sandhya C. TURAGA, David J. WISNESKI
-
Patent number: 8650154Abstract: A method for synchronizing a database with displayed data, includes providing a data feed to receive data from the database to provide displayed document data, detecting a database change to the data within the database by a database synchronizer to provide a change event, polling the database synchronizer using an HTTP message to detect the change event, and pushing the database change to the displayed document data to update the displayed document data in accordance with the database change and the polling. The polling includes long polling and short polling. A polling servlet within the database synchronizer performs the polling by the database synchronizer. The database synchronizer updates the displayed document data by way of a data structure. The data structure is a queue.Type: GrantFiled: February 19, 2008Date of Patent: February 11, 2014Assignee: International Business Machines CorporationInventors: Nisha K Nair, Dinesh Nirmal, Sandhya C Turaga, David J Wisneski
-
Patent number: 8156134Abstract: Provided are a method, system, and article of manufacture for using different groups of query graph transform modules to generate execution plans for queries for different database types. A plurality of first type query translator modules include information indicating a first data store type to which the first query translator modules apply and a plurality of second query translator modules include information indicating a second data store type to which the first query translator modules apply. A query is received to query a target data store. A determination is made as to whether the target data store is of the first data store type or the second data store type. The first query translator modules are used to translate the received query to a query execution plan in response to determining that the target data store is of the first data store type.Type: GrantFiled: November 15, 2007Date of Patent: April 10, 2012Assignee: International Business Machines CorporationInventors: Charlene Xiaoqin Sun, David J. Wisneski
-
Patent number: 8005807Abstract: Provided is an object oriented query path expression to relational outer join translator. A path expression, comprising a navigation path through a relationship in a schema, in an object oriented query is translated to a relational database outer join by analyzing each path expression defined in each level of the object oriented query, and by identifying each path expression which can be a candidate for a translation to an outer join. A quantifier is created for each path expression. A translation of the object oriented query to a relational query is then completed. An optimization may also be performed on the grouped quantifiers. After the optimization, an inner join is generated for each quantifier which remains a candidate for a translation to an inner join, and an outer join is generated for each quantifier which remains a candidate for a translation to an outer join.Type: GrantFiled: February 1, 2008Date of Patent: August 23, 2011Assignee: International Business Machines CorporationInventors: Ahmad Nouri, David J. Wisneski
-
Publication number: 20100293209Abstract: 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.Type: ApplicationFiled: May 15, 2009Publication date: November 18, 2010Applicant: INTERNATIONAL BUSINESS MACHINES, CORPORATIONInventors: William R. Bireley, Dilip K. Biswal, Delmar E. Blevins, Stephen A. Brodsky, Anshul Dawra, Swaminathan Gounder, Paul A. Ostler, Manish Sehgal, Catalina Y. Wei, David J. Wisneski
-
Publication number: 20090254589Abstract: A method for synchronizing a database with data stored at a client includes providing a data feed to receive data by the client from the database and provide received data, caching the received data in a client side cache to provide client side cached data, detecting a database change to data within the database corresponding to the client side cached data according to a polling operation to provide a change event, pushing the change event to the client side cached data to update the client side cached data in accordance with the database change and the polling operation, requesting further data from the database, determining whether the further data includes data of the client side cached data to determine remaining data exclusive of the client side cached data and pushing the remaining data to the client side cached data.Type: ApplicationFiled: April 7, 2008Publication date: October 8, 2009Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Nisha K. Nair, Dinesh Nirmal, Sandhya C. Turaga, David J. Wisneski
-
Publication number: 20090210459Abstract: A method for synchronizing a database with displayed data, includes providing a data feed to receive data from the database to provide displayed document data, detecting a database change to the data within the database by a database synchronizer to provide a change event, polling the database synchronizer using an HTTP message to detect the change event, and pushing the database change to the displayed document data to update the displayed document data in accordance with the database change and the polling. The polling includes long polling and short polling. A polling servlet within the database synchronizer performs the polling by the database synchronizer. The database synchronizer updates the displayed document data by way of a data structure. The data structure is a queue.Type: ApplicationFiled: February 19, 2008Publication date: August 20, 2009Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Nisha K. Nair, Dinesh Nirmal, Sandhya C. Turaga, David J. Wisneski
-
Publication number: 20090132503Abstract: Provided are a method, system, and article of manufacture for using different groups of query graph transform modules to generate execution plans for queries for different database types. A plurality of first type query translator modules include information indicating a first data store type to which the first query translator modules apply and a plurality of second query translator modules include information indicating a second data store type to which the first query translator modules apply. A query is received to query a target data store. A determination is made as to whether the target data store is of the first data store type or the second data store type. The first query translator modules are used to translate the received query to a query execution plan in response to determining that the target data store is of the first data store type.Type: ApplicationFiled: November 15, 2007Publication date: May 21, 2009Applicant: INTERNATIONAL BUSINESS MACHINES ORGANIZATIONInventors: Charlene Xiaoqin SUN, David J. WISNESKI
-
Patent number: 7426522Abstract: A path expression is translated to a relational database outer join by analyzing each path expression defined in each level of the object oriented query, and by identifying each path expression which can be a candidate for a translation to an outer join. The path expressions are ordered staffing with path expressions defined in a FROM clause. These ordered path expressions are grouped sequentially based upon on a source-target dependency between ordered path expressions and based upon the identifications as a candidate for a translation to an outer join. A quantifier is created for each path expression, said quantifier comprising a variable representing a table in a relational database, and each grouped path expression is replaced with a corresponding quantifier and related table in a relational database. A translation of the object oriented query to a relational query is then completed.Type: GrantFiled: September 23, 2003Date of Patent: September 16, 2008Assignee: International Business Machines CorporationInventors: Ahmad Nouri, David J. Wisneski
-
Patent number: 7409386Abstract: Methods and apparatus for executing a query on dynamic properties of a plurality of objects in a database are provided. In one implementation, the method includes obtaining a query; determining that a first portion of the query comprises a method for accessing a dynamic property of the plurality of objects; obtaining mapping data associated with the dynamic property of the plurality of objects, the mapping data mapping the dynamic property to a pre-determined location in the database; translating the first portion of the query in accordance with the mapping data such that the first portion of the query is executable against the pre-determined location in the database without creating instances of the plurality of objects; executing the query including executing the translated first portion of the query without creating instances of the plurality of objects; and displaying a result of the executed query to a user.Type: GrantFiled: May 1, 2007Date of Patent: August 5, 2008Assignee: International Business Machines CorporationInventors: George F. Hongell, Chih-Cheng Hsu, Harisch R. Nayak, David J. Wisneski
-
Publication number: 20080140614Abstract: A path expression, comprising a navigation path through a relationship in a schema, in an object oriented query is translated to a relational database outer join by analyzing each path expression defined in each level of the object oriented query, and by identifying each path expression which can be a candidate for a translation to an outer join. The path expressions are ordered starting with path expressions defined in a FROM clause, to which are added each path expression identified as a candidate for a translation to an outer join. These ordered path expressions are input to a select operator for each level of the object oriented query, and the ordered path expressions are grouped sequentially based upon on a source-target dependency between ordered path expressions and based upon the identifications as a candidate for a translation to an outer join.Type: ApplicationFiled: February 1, 2008Publication date: June 12, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Ahmad NOURI, David J. WISNESKI
-
Patent number: 7263514Abstract: The present invention provides a method and system for a query on dynamic properties of objects. The method includes: obtaining a query; determining that the query pertains to at least one mapped dynamic property; obtaining mapping data for the at least one mapped dynamic property; and translating the query for the at least one mapped dynamic property according to the mapping data to run against a database. The method uses the stored mapping data of the dynamic property to translate the query on the mapped dynamic property such that it may be run against the database. In this manner, queries on mapped dynamic properties are performed through pushdown rather than in object space. This increases the efficiency of the queries.Type: GrantFiled: May 17, 2001Date of Patent: August 28, 2007Assignee: International Business Machines CorporationInventors: George F. Hongell, Chih-Cheng Hsu, Harisch R. Nayak, David J. Wisneski
-
Publication number: 20020184192Abstract: The present invention provides a method and system for a query on dynamic properties of objects. The method includes: obtaining a query; determining that the query pertains to at least one mapped dynamic property; obtaining mapping data for the at least one mapped dynamic property; and translating the query for the at least one mapped dynamic property according to the mapping data to run against a database. The method uses the stored mapping data of the dynamic property to translate the query on the mapped dynamic property such that it may be run against the database. In this manner, queries on mapped dynamic properties are performed through pushdown rather than in object space. This increases the efficiency of the queries.Type: ApplicationFiled: May 17, 2001Publication date: December 5, 2002Inventors: George F. Hongell, Chih-Cheng Hsu, Harisch R. Nayak, David J. Wisneski
-
Patent number: 5897634Abstract: A computer-implemented component broker series server for optimized caching of SQL data is implemented. In an object-oriented computer system, relational data from a relational database is cached in a data cache. The object-oriented computer system has a server that includes an instance manager and that is connected to at least one client. Objects that represent the relational data are created and managed under control of the instance manager. The relational data is stored in the data cache, which includes a virtual memory data cache for each client.Type: GrantFiled: May 9, 1997Date of Patent: April 27, 1999Assignee: International Business Machines CorporationInventors: Gopi Krishna Attaluri, Catalina Y. Fan, Gerald A. Fisher, Robert Dean Jackson, Harry Rohidas Nayak, David J. Wisneski
-
Patent number: 5495606Abstract: A parallel query processing system comprises a front end processor, a query processing complex attached to the front end processor, and a database on a data repository attached by a first path to the front end processor, and by one or more additional paths to one or more slave processors within the query processing complex. An external operations command processor within the front end processor quiesces database managers in the slave processors to permit maintenance operations by the front end processor, and restarts the slave processors in read-only mode after maintenance operation completion. A splitter/scheduler function in a master processor within the query processor complex receives complex read-only queries from the front end processor, splits them into query elements, schedules the query elements for execution on the slave processors and recombines the execution results to be sent back to the front end processor.Type: GrantFiled: November 4, 1993Date of Patent: February 27, 1996Assignee: International Business Machines CorporationInventors: Terry L. Borden, William K. Kelley, Iderpal S. Narang, Bharat D. Rathi, David J. Wisneski