초록 ▼

An algorithm for transforming data base schema information to object modeling notation utilizes meta models of the data base tables and the target object modeling notation respectively to bridge the gap between the data base schema representation and the object model representation. Detection of ass

An algorithm for transforming data base schema information to object modeling notation utilizes meta models of the data base tables and the target object modeling notation respectively to bridge the gap between the data base schema representation and the object model representation. Detection of associations between classes of objects is performed for one-to-one, one-to-many, and many-to-many associations by analyzing unique key attributes. Once an object meta model is populated, the underlying object model may be displayed using existing software packages.

대표청구항 ▼

A computer-implemented method for transforming a data base schema of a relational data base into an object model representative of said data base schema, the object model showing various objects within the data schema and their data attributes, operations, and relationships between each object in th

A computer-implemented method for transforming a data base schema of a relational data base into an object model representative of said data base schema, the object model showing various objects within the data schema and their data attributes, operations, and relationships between each object in the data schema, said method comprising the steps of: constructing an ideal table meta model of said data base schema; populating said ideal table meta model with data extracted from said data base schema; constructing an object diagram meta model of said data base schema from said ideal table meta model; populating said object diagram meta model with data extracted from said ideal table meta model; and transforming said object diagram meta model into said object model representative of said data base schema, the object model showing various objects within the data schema and their data attributes, operations, and relationships between each object in the data schema, said transforming including the step of transforming said object diagram meta model into a series of successive, intermediate, populated object diagram meta models describing the object model, wherein said step of transforming said object diagram meta model into said series of successive, intermediate, populated object diagram meta models comprises the steps of determining the multiplicity of associations on classes mapped from tables with foreign keys; converting classes mapped from tables whose primary keys can be partitioned into mutually exclusive primary key attributes of other classes, to many-to-many associations; converting classes mapped from tables whose primary keys are primary keys of other classes and whose non-primary key attributes include primary keys of other classes, to one-to-many associations; converting classes mapped from tables having multiple primary keys and wherein each said primary key is a primary key of another class, to one-to-one associations; and determining the actual multiplicity of said one-to-many and many-to-many associations.