International Business Machines Corporation

Mark Anthony Musa

Glenn C Godoy

Sherry Lee Wilson

Amy Jeanne Snavely

Jane M Murphy

Theresa W Broden

David G Ruest

Susan Bumgardner Cirulli

Russell Thomas White, Jr

William Montgomery Sjostrom

Thomas William Rath

James D Episale

Stanley Phillip Cason

Glenn Carroll Godoy

Kathleen F Hills

Debora A Villella

Fu-Chen Pan

Glenn C Codoy

Thomas Kersjes

Candace M Cunningham

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.

Automated report of broken relationships between tables

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.

Method, system, and storage device for managing trading network packages for a plurality of trading networks

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.

System for managing a supplier for participation in a plurality of trading networks

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.

Creation of generic hierarchies

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.

System, method and program product for classifying data elements into different levels of a business hierarchy

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.

Method and program storage device for managing a supplier for participation in a plurality of trading networks

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.

Method, system, and program product for processing an electronic document

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. With the preferred embodiment of the invention, the following functionalities are enabled: (1) Present to the user his preferred translation or a default translation if the preferred has not yet been made available to the system; (2) Present to the user the 'best available' translation, given an order of preference, or a default translation if none of the 'better' translations are available; and (3) Present to the user the &#x201c;best available&#x201d; translation using a user's specified preference, or, if none of those translations are available, the &#x201c;best available&#x201d; according to a system level specified preference.

Method and system of presenting a document to a user

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.

Back-end data routing method, system and program product

Method and computer program product for managing an internet trading network

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.

System and method for catalog administration using supplier provided flat files

A system and method for organizing program code and database objects implemented within an enterprise server in support of the accounting and/or procurement systems of a plurality of customer companies. The customer companies are organized into groups of companies having the same accounting rules, and a company grouping code assigned to each company group. Responsive to input through a browser of a requisition request and user ID including a password, a user profile database is accessed to determine the user's company grouping code. Responsive to the company grouping code, a URL or other type of program call to company specific accounting rules is generated to apply appropriate accounting procedures and program logic. Responsive to the program logic and accounting rules accessed by, for example, that URL, the requisition request is applied and validated against company specific data in a common database.

System and method for grouping companies according to accounting system or rules

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 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 are quickly transferred using an intermediate agent and window.

System and method for providing a role table GUI via company group

A computer system modeling tool generates a working user interface from the entities, attributes and relationships of a data model while assuring referential data integrity and and enforcing cardinality.

Growing community of inventors

Brackney, PA, United States of America

Mark Anthony Musa