Patents by Inventor Mark A. Musa

Mark A. Musa 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: 9026561
    Abstract: In a method for reporting data loaded to a database that does not adhere to referential constraints of the database that are not enforced, a computer receives a file of Data Definition Language (DDL) statements for creating a database. The computer identifies statements from the DDL statements that comprise text indicating the statements are referential constraints that are not to be enforced. The computer converts indentified statements to create view statements. The computer generates a file comprising the create view statements. Create view statements are used to generate database views during database build. The computer generates a file, comprising the received DDL statements without the statements that comprise the text indicating the one or more DDL statements are referential constraints not to be enforced in the database. The computer, responsive to new data being loaded to the database, creates a report comprising data from the database views.
    Type: Grant
    Filed: July 2, 2012
    Date of Patent: May 5, 2015
    Assignee: International Business Machines Corporation
    Inventors: Kathleen F. Hills, Thomas Kersjes, Mark A. Musa, Fu-Chen Pan
  • Publication number: 20140006367
    Abstract: In a method for reporting data loaded to a database that does not adhere to referential constraints of the database that are not enforced, a computer receives a file of Data Definition Language (DDL) statements for creating a database. The computer identifies statements from the DDL statements that comprise text indicating the statements are referential constraints that are not to be enforced. The computer converts indentified statements to create view statements. The computer generates a file comprising the create view statements. Create view statements are used to generate database views during database build. The computer generates a file, comprising the received DDL statements without the statements that comprise the text indicating the one or more DDL statements are referential constraints not to be enforced in the database. The computer, responsive to new data being loaded to the database, creates a report comprising data from the database views.
    Type: Application
    Filed: July 2, 2012
    Publication date: January 2, 2014
    Applicant: International Business Machines Corporation
    Inventors: Kathleen F. Hills, Thomas Kersjes, Mark A. Musa, Fu-Chen Pan
  • Patent number: 8589251
    Abstract: A method and system for managing trading in trading networks. At least one trading network package is offered. Each trading network package is based on negotiations occurring prior to receiving purchase requests from customer members of the trading network. Each trading network package is configured to include: (i) a value-add service offering offered by the trading network to the customer members for a fee, (ii) a managed package for which a customer member of the customer members provides a volume commitment and for which actual purchases are tracked; or (iii) both the value-add service offering and the managed package.
    Type: Grant
    Filed: September 12, 2012
    Date of Patent: November 19, 2013
    Assignee: International Business Machines Corporation
    Inventors: Theresa W. Broden, Glenn C. Godoy, Jane M. Murphy, Mark A. Musa, Sherry L. Wilson
  • Publication number: 20130006836
    Abstract: A method and system for managing trading in trading networks. At least one trading network package is offered. Each trading network package is based on negotiations occurring prior to receiving purchase requests from customer members of the trading network. Each trading network package is configured to include: (i) a value-add service offering offered by the trading network to the customer members for a fee, (ii) a managed package for which a customer member of the customer members provides a volume commitment and for which actual purchases are tracked; or (iii) both the value-add service offering and the managed package.
    Type: Application
    Filed: September 12, 2012
    Publication date: January 3, 2013
    Applicant: International Business Machines Corporation
    Inventors: Theresa W. Broden, Glenn C. Godoy, Jane M. Murphy, Mark A. Musa, Sherry L. Wilson
  • Patent number: 8332280
    Abstract: A system for performing a method for managing a supplier for participation in trading networks. The method includes: receiving from each trading network a volume commitment consolidating volume commitments for offerings of commodities and services; negotiating with each trading network to supply to customer members of the trading network the commodity or service; storing, for each trading network for each supplier, attributes including start date, end date, services and products offered to the trading network, and payment flow for the commodities and services; offing a trading network package based on negotiations occurring before receiving purchase requests from the customer members, the trading network package including: (i) a value-add service offering to the customer members for a fee, and (ii) a managed package for which a customer member provides a volume commitment and actual purchases are tracked; and negotiating price discount levels for committed levels of demand from the trading networks.
    Type: Grant
    Filed: July 18, 2011
    Date of Patent: December 11, 2012
    Assignee: International Business Machines Corporation
    Inventors: Theresa W. Broden, Glenn C. Godoy, Jane M. Murphy, Mark A. Musa, Sherry L. Wilson
  • Publication number: 20110276458
    Abstract: A system for performing a method for managing a supplier for participation in trading networks. The method includes: receiving from each trading network a volume commitment consolidating volume commitments for offerings of commodities and services; negotiating with each trading network to supply to customer members of the trading network the commodity or service; storing, for each trading network for each supplier, attributes including start date, end date, services and products offered to the trading network, and payment flow for the commodities and services; offing a trading network package based on negotiations occurring before receiving purchase requests from the customer members, the trading network package including: (i) a value-add service offering to the customer members for a fee, and (ii) a managed package for which a customer member provides a volume commitment and actual purchases are tracked; and negotiating price discount levels for committed levels of demand from the trading networks.
    Type: Application
    Filed: July 18, 2011
    Publication date: November 10, 2011
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Theresa W. Broden, Glenn C. Godoy, Jane M. Murphy, Mark A. Musa, Sherry L. Wilson
  • Patent number: 8032484
    Abstract: A method and system are disclosed for modeling a relational database. The method comprises the steps of defining a set of data tables to accommodate any number of levels of a business hierarchy and using these tables as a generic data model to handle various levels of requirements of the business hierarchy. This set of tables include a first control table, a second table containing hierarchy nodes in a flattened format, a third table storing unique hierarchy node names, and a fourth table describing the hierarchy nodes in one or more languages. For example, this business hierarchy may be a commodity hierarchy, a geography hierarchy and a client organization hierarchy. Also, in the preferred embodiment, no new tables are needed when a new hierarchy is introduced, and the generic data model supports different numbers of reporting levels from one hierarchy to the next hierarchy.
    Type: Grant
    Filed: March 30, 2007
    Date of Patent: October 4, 2011
    Assignee: International Business Machines Corporation
    Inventors: Glenn C. Godoy, Mark A. Musa, David G. Ruest, Debora A. Villella, Sherry L. Wilson
  • Patent number: 8027981
    Abstract: A method, system and program product for classifying data elements into different levels of a business hierarchy. The method includes identifying data elements to be classified into one or more levels of a business hierarchy, selecting a first logic decision tree for evaluating the data elements identified for classification into the hierarchy and executing the first tree for recursively evaluating each data element identified until the first tree has been traversed. Further, the method includes dynamically creating configurable anchor point classifications for the data elements evaluated through the first tree and assigning a respective anchor point classification to each data element evaluated, such that, a respective anchor point classification assigned to a data element evaluated links the data element to a lowest level of the hierarchy, and where the anchor point classification conveys classification information as to each higher level of the hierarchy that the data element belongs to.
    Type: Grant
    Filed: December 10, 2008
    Date of Patent: September 27, 2011
    Assignee: International Business Machines Corporation
    Inventors: James D. Episale, Mark A. Musa, David G. Ruest
  • Patent number: 7983958
    Abstract: An Internet trading network is operated by establishing supplier memberships of suppliers providing offerings to the trading network; establishing customer memberships of customers providing volume commitments; consolidating all volume commitments for a particular commodity or service when negotiating an offering with the supplier; managing memberships and their accounts.
    Type: Grant
    Filed: May 25, 2007
    Date of Patent: July 19, 2011
    Assignee: International Business Machines Corporation
    Inventors: Theresa W. Broden, Glenn C. Codoy, Jane M. Murphy, Mark A. Musa, Sherry L. Wilson
  • Patent number: 7945122
    Abstract: The invention provides a method, system, and program product for processing an electronic document. In one embodiment, the invention includes determining a procedure applicable to the electronic document; defining at least one step of the procedure; in the case that the at least one step includes a plurality of steps, determining an order of the plurality of steps; determining whether the at least one step applies to the electronic document; applying an algorithm for carrying out the at least one step; applying a completion algorithm; determining whether the procedure includes an additional step for which an algorithm has not been applied; and in the case that the procedure includes an additional step for which an algorithm has not been applied: determining whether the additional step applies to the electronic document; applying an algorithm for carrying out the additional step; and applying a completion algorithm.
    Type: Grant
    Filed: September 27, 2006
    Date of Patent: May 17, 2011
    Assignee: International Business Machines Corporation
    Inventors: Glenn C. Godoy, Mark A. Musa, Amy J. Snavely
  • Patent number: 7856352
    Abstract: A method and system for presenting a document to a user. The method comprises the steps of providing a plurality of documents having one or more language translations; specifying a preferred order of languages for the user; and when the user requests a search term, searching the plurality of documents for those that contain the search term. The method comprises the further steps of matching the language translations of the documents containing the search term with the preferred order of languages for the user; and delivering, for each of the documents containing the search term, a best match language translation to the user.
    Type: Grant
    Filed: April 28, 2008
    Date of Patent: December 21, 2010
    Assignee: International Business Machines Corporation
    Inventors: Glenn C. Godoy, Mark A. Musa
  • Publication number: 20100145945
    Abstract: A method, system and program product for classifying data elements into different levels of a business hierarchy. The method includes identifying data elements to be classified into one or more levels of a business hierarchy, selecting a first logic decision tree for evaluating the data elements identified for classification into the hierarchy and executing the first tree for recursively evaluating each data element identified until the first tree has been traversed. Further, the method includes dynamically creating configurable anchor point classifications for the data elements evaluated through the first tree and assigning a respective anchor point classification to each data element evaluated, such that, a respective anchor point classification assigned to a data element evaluated links the data element to a lowest level of the hierarchy, and where the anchor point classification conveys classification information as to each higher level of the hierarchy that the data element belongs to.
    Type: Application
    Filed: December 10, 2008
    Publication date: June 10, 2010
    Applicant: International Business Machines Corporation
    Inventors: James D. Episale, Mark A. Musa, David G. Ruest
  • Patent number: 7593865
    Abstract: Under the present invention, when a requestor submits a request for an item, a single, appropriate back-end system for processing the request is identified. Typically, the back-end system is identified based on the item requested and a location setting within the requestor's profile. The location setting generally indicates the requestor's geographic location and their job responsibility. Once a particular back-end system is identified, subsequent requests in the same order are limited to items that are associated with the identified back-end system. If the requester attempts to request an item that is not available via the identified back-end system, an error message is displayed.
    Type: Grant
    Filed: October 17, 2003
    Date of Patent: September 22, 2009
    Assignee: International Business Machines Corporation
    Inventors: Susan B. Cirulli, Glenn C. Godoy, Mark A. Musa, Amy J. Snavely
  • Publication number: 20080270108
    Abstract: A method and system for presenting a document to a user. The method comprises the steps of providing a plurality of documents having one or more language translations; specifying a preferred order of languages for the user; and when the user requests a search term, searching the plurality of documents for those that contain the search term. The method comprises the further steps of matching the language translations of the documents containing the search term with the preferred order of languages for the user; and delivering, for each of the documents containing the search term, a best match language translation to the user.
    Type: Application
    Filed: April 28, 2008
    Publication date: October 30, 2008
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Glenn C. Godoy, Mark A. Musa
  • Publication number: 20080243876
    Abstract: A method and system are disclosed for modeling a relational database. The method comprises the steps of defining a set of data tables to accommodate any number of levels of a business hierarchy and using these tables as a generic data model to handle various levels of requirements of the business hierarchy. This set of tables include a first control table, a second table containing hierarchy nodes in a flattened format, a third table storing unique hierarchy node names, and a fourth table describing the hierarchy nodes in one or more languages. For example, this business hierarchy may be a commodity hierarchy, a geography hierarchy and a client organization hierarchy. Also, in the preferred embodiment, no new tables are needed when a new hierarchy is introduced, and the generic data model supports different numbers of reporting levels from one hierarchy to the next hierarchy.
    Type: Application
    Filed: March 30, 2007
    Publication date: October 2, 2008
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Glenn C. Godoy, Mark A. Musa, David G. Ruest, Debora A. Villella, Sherry L. Wilson
  • Patent number: 7392173
    Abstract: A method and system for presenting a document to a user. The method comprises the steps of providing a plurality of documents having one or more language translations; specifying a preferred order of languages for the user; and when the user requests a search term, searching the plurality of documents for those that contain the search term. The method comprises the further steps of matching the language translations of the documents containing the search term with the preferred order of languages for the user; and delivering, for each of the documents containing the search term, a best match language translation to the user.
    Type: Grant
    Filed: September 6, 2001
    Date of Patent: June 24, 2008
    Assignee: International Business Machines Corporation
    Inventors: Glenn C. Godoy, Mark A. Musa
  • Publication number: 20080077860
    Abstract: The invention provides a method, system, and program product for processing an electronic document. In one embodiment, the invention includes determining a procedure applicable to the electronic document; defining at least one step of the procedure; in the case that the at least one step includes a plurality of steps, determining an order of the plurality of steps; determining whether the at least one step applies to the electronic document; applying an algorithm for carrying out the at least one step; applying a completion algorithm; determining whether the procedure includes an additional step for which an algorithm has not been applied; and in the case that the procedure includes an additional step for which an algorithm has not been applied: determining whether the additional step applies to the electronic document; applying an algorithm for carrying out the additional step; and applying a completion algorithm.
    Type: Application
    Filed: September 27, 2006
    Publication date: March 27, 2008
    Inventors: Glenn C. Godoy, Mark A. Musa, Amy J. Snavely
  • Publication number: 20070265955
    Abstract: An Internet trading network is operated by establishing supplier memberships of suppliers providing offerings to the trading network; establishing customer memberships of customers providing volume commitments; consolidating all volume commitments for a particular commodity or service when negotiating an offering with the supplier; managing memberships and their accounts.
    Type: Application
    Filed: May 25, 2007
    Publication date: November 15, 2007
    Applicant: International Business Machines Corporation
    Inventors: Theresa Broden, Glenn Codoy, Jane Murphy, Mark Musa, Sherry Wilson
  • Patent number: 7243077
    Abstract: An Internet trading network is operated by establishing supplier memberships of suppliers providing offerings to the trading network; establishing customer memberships of customers providing volume commitments; consolidating all volume commitments for a particular commodity or service when negotiating an offering with the supplier; managing memberships and their accounts.
    Type: Grant
    Filed: March 2, 2001
    Date of Patent: July 10, 2007
    Assignee: International Business Machines Corporation
    Inventors: Theresa W. Broden, Glenn C. Godoy, Jane M. Murphy, Mark A. Musa, Sherry L. Wilson
  • Patent number: 7133868
    Abstract: A hybird Notes/DB2 environment provides a requisition catalog on the Web. Client browsers are connected to a GWA infrastructure including a first network dispatcher and a virtual cluster of Domino.Go servers. The network dispatcher sprays out browser requests among configured .nsf servers in virtual server cluster. Communications from this virtual server cluster are, in turn, dispatched by a second network dispatcher servers in a Domino cluster. External objects, primarily for a GUI, are served in a .dfs and include graphic files, Java files, HTML images and net.data macros. The catalog is built from supplier provided flat files. A front end is provided for business logic and validation, as also is a relation database backend. HTML forms are populated using relational database agents. A role table is used for controlling access both to Notes code and DB2 data. Large amounts of data is quickly transferred using an intermediate agent and window.
    Type: Grant
    Filed: September 7, 2000
    Date of Patent: November 7, 2006
    Assignee: International Business Machines Corporation
    Inventors: David G. Ruest, Amy J. Snavely, Mark A. Musa, Candace M. Cunningham