Method and structure for clustering database tables into classes

Details Method and structure for clustering database tables into classes Method and structure for clustering database tables into classes

1994-11-29

1998-09-15

Black, Thomas G.

395613, G06F 1730

Patent

active

058092960

ABSTRACT:
A reverse engineering technology is capable of automatically reversing from a physical data model comprising a relational or 4GL data model of an existing application database into a logical data model comprising classes and an entity-relationship (E-R) model of each class, the classes representing the different types of high-level objects that make up the application. This logical data model allows users to have a much clearer understanding of their application database thereby increasing their productivity and ease of maintenance of their existing applications. This is made possible by the method and structure of this invention first capturing the application semantics from the physical data model to provide a set of derived semantics. The derived semantics are then used to identify classes and derive the class definitions which are then used to derive the E-R model of each class. In addition, the derived semantics can be easily updated by the method and structure of this invention when the physical data model is changed.

REFERENCES:
patent: 4815005 (1989-03-01), Oyanagi
patent: 4982340 (1991-01-01), Oyanagi
patent: 5010478 (1991-04-01), Deran
patent: 5043929 (1991-08-01), Kramer
patent: 5072406 (1991-12-01), Ammon
patent: 5123103 (1992-06-01), Ohtaki
patent: 5193185 (1993-03-01), Lanter
patent: 5224206 (1993-06-01), Simoudis
patent: 5235465 (1993-08-01), Hung et al.
patent: 5235701 (1993-08-01), Ohler et al.
patent: 5261080 (1993-11-01), Khoyi et al.
patent: 5295261 (1994-03-01), Simonetti
patent: 5303379 (1994-04-01), Khoyi et al.
patent: 5325465 (1994-06-01), Hung et al.
patent: 5421015 (1995-05-01), Khoyi et al.
patent: 5487135 (1996-01-01), Freeman
patent: 5499371 (1996-03-01), Henninger et al.
patent: 5535325 (1996-07-01), Catell et al.
patent: 5548749 (1996-08-01), Kroenke et al.
patent: 5566333 (1996-10-01), Olson et al.
patent: 5596746 (1997-01-01), Shen et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5627979 (1997-05-01), Chang et al.
patent: 5640559 (1997-06-01), Silberbauer et al.
patent: 5655116 (1997-08-01), Kirk et al.
Kroenke, Business Modeling with Semantic Objects, Wall Data Inc, pp. 1-4, Dec. 1994.
A Survey of the Universal Relation Model, Leymann, Data & Knowledge Engineering, vol. 4, 1989, pp. 305-320.
The Universal Relation as a user Interface, Ullinson, Principles of Database and Knowledge Based Systems, vol. II, Chpater 17, 1989.
Consequences of Assuming a Universal Relation, W. Kent, 1981 ACM Transactions on Database Systems, vol. 6, No. 4, pp. 539-556.
EasyTalk Product Backgrounder from Intelligent Business Systems Brochure pertaining to Software Interfaces product.
Premerlani, William, J., Blaha, Michael R., "An Approach for Reverse Engineering of Relational Databases". Communications of the ACM, May 1994, vol. 37, No. 5, pp. 42-49, especially pp. 48, 49, step 1-7.
Patent Abstracts of Japan, vol. 14, No. 381 (P-1093), 1990, JP 2-141 828 (Hitachi).

Affiliated with

Also associated with

Rating

Method and structure for clustering database tables into classes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and structure for clustering database tables into classes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and structure for clustering database tables into classes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-101214