Patent
1995-07-07
1998-02-10
Loomis, John C.
395612, 395614, G06F 1730
Patent
active
057179247
ABSTRACT:
An object model comprises one or more semantic objects that represent items about which data is stored in a relational database in a computer system. Each semantic object has one or more components that define the data stored for each item. The object model is mapped into a current relational database schema. As a user makes changes to the model the computer system generates a proposed relational database schema, and the differences between the current relational database schema and the proposed relational database schema are determined. The relation database is modified to reflect changes made in the corresponding object model based upon the differences between the current and proposed relational database schemas.
REFERENCES:
patent: 4930071 (1990-05-01), Tou et al.
patent: 5212787 (1993-05-01), Baker et al.
patent: 5263167 (1993-11-01), Conner, Jr. et al.
patent: 5278946 (1994-01-01), Shimada et al.
patent: 5295256 (1994-03-01), Bapat
patent: 5307499 (1994-04-01), Yin
patent: 5418950 (1995-05-01), Li et al.
patent: 5495567 (1996-02-01), Iizawa et al.
patent: 5499371 (1996-03-01), Henninger et al.
patent: 5548749 (1996-08-01), Kroenke et al.
patent: 5550971 (1996-08-01), Brunner et al.
D. R. McClanahan, "Database Design: Relational Rules," DBMS, vol. 4, No. 12, Nov. 1991, pp. 54-58.
D. R. McClanahan, "Conceptual Design," DBMS, vol. 5, No. 1, Jan. 1992, p. 66(5).
Codd, E. F., "Extending the Database Relational Model to Capture More Meaning," ACM Transactions on Database Systems, vol. 4, No. 4, Dec. 1979, pp. 397-434.
G. Decorte et al., "An Object-Oriented Model for Capturing Data Semantics," IEEE Computer Society Press, Feb. 1992, pp. 126-135.
M. Hammer and D. McLeod, "Database Description with SDM: A Semantic Database Model," ACM Transaction On Database Systems, vol. 6, No. 3, Sep. 1981, pp. 351-386.
D. M. Kroenke, "Developing Object-Oriented Database Applications on Microcomputers," The Second International Conference on Computers and Applications, The Computer Society of the IEEE, Jun. 1987, pp. 70-77.
D. M. Kroenke, Database Processing: Fundamentals, Design, Implementation, 4th Ed., Macmillan Publishing Company, 1992, Chapters 5 and 7, pp. 123-167 and pp. 205-252.
D. Keim et al., "Object-Oriented Querying of Existing Relational Database," Databases and Expert Systems Application, 4th International Conference, Sep. 6-8, 1993, pp. 326-336.
F. Leymann, "UDH: A Universal Relation System," Data & Knowledge Engineering vol. 5, (1990) pp. 21-38.
"Visual Representation of Database Query Definition," IBM Technical Disclosure Bulletin, vol. 33, No. 9 Feb. 1991, pp. 238-242.
International Search Report dated Jan. 31, 1995.
S. Dewitz and M. Olson, "Semantic Object Modeling with SALSA," Mitchell McGraw-Hill Publishing Company, 1994.
Blaha et al., "Relational Database Design Using An Object-Oriented Methodology," Communications of the ACM, vol. 31, No. 4 Apr. 1988, pp. 414-427.
Lejter et al., "Support for Maintaining Object-Oriented Programs," IEEE Transactions on Software Engineering, vol. 18, Dec. 1992, pp. 1045-1052.
Loomis John C.
Wall Data Incorporated
LandOfFree
Method and apparatus for modifying existing relational database 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 apparatus for modifying existing relational database , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for modifying existing relational database will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2086754