Patent ID: 7730065

Claim:
A computer system that facilitates access to and manipulation of a relational database from a client application, comprising an interface component that detects a programming language of the client application, and collects information on an object-relational mapping between the objects in the programming language of the client application and the relational database, the object-relational mapping including: an association class that represents a foreign-key to primary-key relationship in the relational database, wherein the association class includes: a first property including a list of the key values on a first side of the foreign-key to primary-key relationship in the relational database; a second property including a list of the key values on an opposing second side of the foreign-key to primary-key relationship in the relational database; a third property including the name of the foreign-key constraint in the relational database; and a fourth property that indicates whether there is a uniqueness constraint on the foreign key; and a mapping component that facilitates the access and manipulation of the relational database by employing a common object-relational mapping format that facilitates mapping classes of the programming language of the client application to tables in the relational database.