Patents by Inventor Douglas Michael Frederick Hembry

Douglas Michael Frederick Hembry 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).

  • Publication number: 20080215527
    Abstract: The apparatus and system are provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.
    Type: Application
    Filed: May 6, 2008
    Publication date: September 4, 2008
    Applicant: International Business Machines Corporation
    Inventors: Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Carol M. Wiedenmann
  • Patent number: 7418456
    Abstract: A method is provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.
    Type: Grant
    Filed: January 16, 2004
    Date of Patent: August 26, 2008
    Assignee: International Business Machines Corporation
    Inventors: Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Carol M. Wiedenmann
  • Patent number: 7290012
    Abstract: An apparatus, system, and method are provided for passing data between an XML document and a hierarchical database. The apparatus, system, and method include a hierarchical database, a metadata schema, and a mapping module. The hierarchical database comprises a conventional hierarchical database, such as IMS. The metadata schema is derived from the hierarchical database. The metadata schema includes a first representation representative of the hierarchical structure of the hierarchical database, a second representation representative of the hierarchical structure of XML documents valid for passing into and out of the hierarchical database, one or more database field names, and one or more XML element names that map to the one or more database field names. The mapping module passes data between the XML document and the hierarchical database using the metadata schema.
    Type: Grant
    Filed: January 16, 2004
    Date of Patent: October 30, 2007
    Assignee: International Business Machines Corporation
    Inventors: Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Carol M. Wiedenmann
  • Patent number: 7058651
    Abstract: A database definition, logical database view, extended field definition and control statement information are accessed to build an in-memory representation of selective information contained therein. Utilizing this in-memory representation, a class in one form is automatically generated and customized wherein this class is used to access a hierarchical database responsive to a hierarchical database access request from an application.
    Type: Grant
    Filed: June 14, 2002
    Date of Patent: June 6, 2006
    Assignee: International Business Machines Corporation
    Inventors: Douglas Michael Frederick Hembry, Christopher M. Holtz, Robert Daniel Love
  • Patent number: 7020648
    Abstract: A system for identifying and utilizing a secondary index to access a database using a management system without an internal catalogue of online metadata. The system receives an application request to access a database from the application program, and parses the application request to determine at least one column name and at least one table name. The system utilizes an online catalogue containing metadata to translate the column name to a field name and the table name to a segment name, wherein the segment name has an associated secondary index. The system utilizes the online catalogue to determine an associated secondary index name, and builds a database request that includes the segment name, the field name, and the associated secondary index name. The system then sends the database request to the database management system, so that the associated secondary index can be used by the database management system in response to the database request.
    Type: Grant
    Filed: December 14, 2002
    Date of Patent: March 28, 2006
    Assignee: International Business Machines Corporation
    Inventors: Kiran Challapalli, Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Robert Daniel Love
  • Patent number: 6980995
    Abstract: A database definition, logical database view, extended field definition and control statement information are accessed to build an in-memory representation of selective information contained therein. Utilizing this in-memory representation, a hierarchical database schema report is automatically generated wherein this hierarchical database schema report may be used to write application code to access the hierarchical database without further need to utilize the database definition, the extended field definition, the logical database view or any combination thereof.
    Type: Grant
    Filed: July 23, 2002
    Date of Patent: December 27, 2005
    Assignee: International Business Machines Corporation
    Inventors: Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Robert Daniel Love
  • Publication number: 20040117351
    Abstract: A system for identifying and utilizing a secondary index to access a database using a management system without an internal catalogue of online metadata. The system receives an application request to access a database from the application program, and parses the application request to determine at least one column name and at least one table name. The system utilizes an online catalogue containing metadata to translate the column name to a field name and the table name to a segment name, wherein the segment name has an associated secondary index. The system utilizes the online catalogue to determine an associated secondary index name, and builds a database request that includes the segment name, the field name, and the associated secondary index name. The system then sends the database request to the database management system, so that the associated secondary index can be used by the database management system in response to the database request.
    Type: Application
    Filed: December 14, 2002
    Publication date: June 17, 2004
    Applicant: International Business Machines Corporation
    Inventors: Kiran Challapalli, Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Robert Daniel Love
  • Publication number: 20040019600
    Abstract: A database definition, logical database view, extended field definition and control statement information are accessed to build an in-memory representation of selective information contained therein. Utilizing this in-memory representation, a hierarchical database schema report is automatically generated wherein this hierarchical database schema report may be used to write application code to access the hierarchical database without further need to utilize the database definition, the extended field definition, the logical database view or any combination thereof.
    Type: Application
    Filed: July 23, 2002
    Publication date: January 29, 2004
    Applicant: International Business Machines Corporation
    Inventors: Kyle Jeffrey Charlet, Douglas Michael Frederick Hembry, Christopher M. Holtz, Robert Daniel Love
  • Publication number: 20030233373
    Abstract: A database definition, logical database view, extended field definition and control statement information are accessed to build an in-memory representation of selective information contained therein. Utilizing this in-memory representation, a class in one form is automatically generated and customized wherein this class is used to access a hierarchical database responsive to a hierarchical database access request from an application.
    Type: Application
    Filed: June 14, 2002
    Publication date: December 18, 2003
    Applicant: International Business Machines Corporation
    Inventors: Douglas Michael Frederick Hembry, Christopher M. Holtz, Robert Daniel Love