Method for converting a database schema in relational form to a schema in object-oriented form

Claim 1

A method residing in a computer system for converting a database schema in relational form including at least one relation, with each relation having attributes, one or more of said attributes functioning as a primary key of a given relation, and other attributes of the relation functioning as reference keys as needed, to an equivalent object-oriented schema in functional data model form; comprising the steps of: a) receiving as an input the database schema in relational form including a list of the relations of the data base schema, and the attributes of each relation including its primary key and reference keys if any of said input database schema; b) determining the maximum number of attributes comprising the primary key of each relation of the input schema; c) creating a special data structure (SDS) for each primary key of each relation of the input schema based on the number of attributes of the primary key of each relation of the input schema, each SDS constituting an object in the equivalent schema; d) converting each SDS to a complex object of the equivalent object-oriented schema; e) identifying data types of each complex object of the equivalent schema; f) producing for each complex object a set of functions that represent attributes of the complex object; g) producing cross reference functions based on the SDS's produced in step c) for each relation and the reference keys thereof; h) selecting appropriate SQL commands to provide a mapping between the input database schema in relational form to an equivalent object-oriented schema in functional data model form; and i) producing as an output the equivalent object-oriented schema in functional data model form including names of objects and functions, and SQL commands.

Claim 2

A method residing in a computer system for converting a database schema in relational form including at least one relation, with each relation having attributes, one or more of said attributes functioning as a primary key of a given relation, and other attributes of the relation functioning as reference keys as needed, to an equivalent object-oriented schema in functional data model form; comprising the steps of: a) receiving as an input the database schema in relational form including a list of the relations of the data base schema, and the attributes of each relation including its primary key and reference keys if any of said input database schema; b) determining the maximum number of attributes comprising the primary key of each relation of the input schema; c) creating a special data structure (SDS) for each primary key of each relation of the input schema based on the number of attributes of the primary key of each relation of the input schema, each SDS constituting an object in the equivalent schema; d) converting each SDS to a complex object of the equivalent object-oriented schema; e) identifying data types of each complex object of the equivalent schema; f) producing for each complex object a set of functions that represent attributes of the complex object; g) producing cross reference functions based on the SDS's produced in step c) for each relation and the reference keys thereof; h) selecting appropriate SQL commands to provide a mapping between the input database schema in relational form to an equivalent object-oriented schema in functional data model form; and i) producing as an output the equivalent object-oriented schema in functional data model form including names of objects and functions, and SQL commands.