Creation of generic hierarchies

Details Creation of generic hierarchies Creation of generic hierarchies

2007-03-30

2011-10-04

Cottingham, John R. (Department: 2167)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

Data extraction, transformation, and loading

C707S793000

Reexamination Certificate

active

08032484

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.

REFERENCES:
patent: 5396623 (1995-03-01), McCall et al.
patent: 5428772 (1995-06-01), Merz
patent: 6138121 (2000-10-01), Costa et al.
patent: 6381600 (2002-04-01), Lau
patent: 6687704 (2004-02-01), Russell
patent: 6963861 (2005-11-01), Boucher et al.
patent: 6999966 (2006-02-01), Liang et al.
patent: 7051043 (2006-05-01), Cameron et al.
patent: 2001/0027455 (2001-10-01), Abulleil et al.
patent: 2003/0187855 (2003-10-01), Fachat et al.
patent: 2004/0034634 (2004-02-01), Ichihara
patent: 2005/0196742 (2005-09-01), Harber et al.
patent: 2006/0080324 (2006-04-01), Bower et al.
patent: 2006/0136363 (2006-06-01), Nguyen et al.
patent: 2007/0239769 (2007-10-01), Fazal et al.
patent: WO 9707470 (1997-02-01), None
“New DB2 Table Model Which Minimizes Number of Tables and Allows Higher Scalability”, RD n441; Jan. 2001; Article 159, p. 165.

Affiliated with

Also associated with

Rating

Creation of generic hierarchies does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Creation of generic hierarchies, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Creation of generic hierarchies will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4289658