Patents by Inventor Salvador Ledezma

Salvador Ledezma 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: 9710500
    Abstract: Some embodiments include a method for searching a hierarchical database structure of a database management system. In some embodiments, the method comprises detecting text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure. The method can also comprise selecting items in the hierarchical database structure based on the text input; presenting selectable options, wherein the selectable options are associated with the items in the hierarchical database structure; detecting selection of one of the selectable options, and presenting data associated with the one of the items.
    Type: Grant
    Filed: October 18, 2011
    Date of Patent: July 18, 2017
    Assignee: International Business Machines Corporation
    Inventors: Vinod P. Chirayath, Zackery M. England, Venkatesh S. Gopal, Salvador Ledezma
  • Patent number: 9678970
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Grant
    Filed: October 24, 2016
    Date of Patent: June 13, 2017
    Assignee: International Business Machines Corporation
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Patent number: 9672215
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Grant
    Filed: October 24, 2016
    Date of Patent: June 6, 2017
    Assignee: International Business Machines Corporation
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Patent number: 9588999
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Grant
    Filed: April 27, 2015
    Date of Patent: March 7, 2017
    Assignee: International Business Machines Corporation
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Publication number: 20170031941
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Application
    Filed: October 24, 2016
    Publication date: February 2, 2017
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Publication number: 20170031942
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Application
    Filed: October 24, 2016
    Publication date: February 2, 2017
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Patent number: 9558219
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Grant
    Filed: July 15, 2016
    Date of Patent: January 31, 2017
    Assignee: International Business Machines Corporation
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Publication number: 20160314148
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Application
    Filed: April 27, 2015
    Publication date: October 27, 2016
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Publication number: 20160314150
    Abstract: The computer retrieves a list of the data elements contained in a database. The computer performs a static and dynamic analysis on the list to determine which data elements have been active in a static or dynamic Structured Query Language (SQL) statement, then removes active data elements from the list. The computer performs a dependency test to determine which data elements on the list are depended on by data objects not on the list and removes those data elements which are depended on. The computer analyzes application code to extract SQL statements and determine whether data elements on the list are active in application code SQL. Any data elements on the list which are active in application code SQL are removed from the list and the remaining data elements on the list are sorted in descending order based on size.
    Type: Application
    Filed: July 15, 2016
    Publication date: October 27, 2016
    Inventors: Vinod P. Chirayath, Gary T. Gong, Salvador Ledezma
  • Publication number: 20130097193
    Abstract: Some embodiments include a method for searching a hierarchical database structure of a database management system. In some embodiments, the method comprises detecting text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure. The method can also comprise selecting items in the hierarchical database structure based on the text input; presenting selectable options, wherein the selectable options are associated with the items in the hierarchical database structure; detecting selection of one of the selectable options, and presenting data associated with the one of the items.
    Type: Application
    Filed: October 18, 2011
    Publication date: April 18, 2013
    Applicant: International Business Machines Corporation
    Inventors: Vinod P. Chirayath, Zackery M. Englang, Venkatesh S. Gopal, Salvador Ledezma