The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 04, 2011
Filed:
Mar. 30, 2007
Glenn C. Godoy, Endwell, NY (US);
Mark A. Musa, Brackney, PA (US);
David G. Ruest, Vestal, NY (US);
Debora A. Villella, Charlotte, NC (US);
Sherry L. Wilson, Conklin, NY (US);
Glenn C. Godoy, Endwell, NY (US);
Mark A. Musa, Brackney, PA (US);
David G. Ruest, Vestal, NY (US);
Debora A. Villella, Charlotte, NC (US);
Sherry L. Wilson, Conklin, NY (US);
International Business Machines Corporation, Armonk, NY (US);
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.