Patent ID: 7870164

Claim:
A method in a computer system for merging database parts into a database, comprising: receiving, by a computer, a selection of a database part, the database part comprising a table; checking, by the computer, for metadata associated with the database part to identify an action property, wherein the action property comprises metadata comprises an ID property for identifying a table type associated with at least one of the database part and at least one database table in the database; if, after checking for the metadata, a merge action property is identified, then determining from the metadata, by the computer, if a table type is set for the database part; if it is determined that a table type is set for the database part then determining, by the computer, whether the table type matches a target table type for the at least one database table in the database; and if the table type matches the target table type, merging, by the computer, the database part with the at least one database table in the database, wherein merging the database part with the at least one database table in the database comprises automatically merging table information from the database part with table information from the at least one database table to create a new table containing the table information from the database part and the table information from the at least one database table, the new table having a relationship with the database part and the at least one database table, wherein the relationship is created by the metadata and defined by a foreign key in one of the database part and the at least one database table that correlates to data stored in an other one of the database part and the at least one database table.