Patents by Inventor Tim Kiefer

Tim Kiefer 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).

  • Generating structured query language/extensible markup language (SQL/XML) statements
    Patent number: 8140558
    Abstract: A mechanism is provided for generating Structured Query Language/Extensible Markup Language (SQL/XML) statements. An SQL/XML generation module receives an SQL statement that is expressed in terms of logical data items. The SQL/XML generation module parses and analyzes the SQL statement and generates a set of XMLQUERY functions, a set of XMLTABLE functions, and a set of XMLEXISTS predicates to retrieve, filter, or update at least one of XML documents or relational data based on a main mapping table and a namespace mapping table. The SQL/XML generation module generates at least one SQL/XML statement from parts of the SQL statement and the generated set of XMLQUERY functions, the set of XMLTABLE functions, and the set of XMLEXISTS predicates. The at least one SQL/XML statement is substantially equivalent in functionality to the SQL statement. The SQL/XML generation module sends the at least one SQL/XML statement to a database engine for execution.
    Type: Grant
    Filed: May 22, 2009
    Date of Patent: March 20, 2012
    Assignee: International Business Machines Corporation
    Inventors: Tim Kiefer, Matthias M. Nicola
  • Generating Structured Query Language/Extensible Markup Language (SQL/XML) Statements
    Publication number: 20100299327
    Abstract: A mechanism is provided for generating Structured Query Language/Extensible Markup Language (SQL/XML) statements. An SQL/XML generation module receives an SQL statement that is expressed in terms of logical data items. The SQL/XML generation module parses and analyzes the SQL statement and generates a set of XMLQUERY functions, a set of XMLTABLE functions, and a set of XMLEXISTS predicates to retrieve, filter, or update at least one of XML documents or relational data based on a main mapping table and a namespace mapping table. The SQL/XML generation module generates at least one SQL/XML statement from parts of the SQL statement and the generated set of XMLQUERY functions, the set of XMLTABLE functions, and the set of XMLEXISTS predicates. The at least one SQL/XML statement is substantially equivalent in functionality to the SQL statement. The SQL/XML generation module sends the at least one SQL/XML statement to a database engine for execution.
    Type: Application
    Filed: May 22, 2009
    Publication date: November 25, 2010
    Applicant: International Business Machines Corporation
    Inventors: Tim Kiefer, Matthias M. Nicola