Established data modeling methods were engineered in the late 1970’s to design a single database. These data modeling methods function well when instantiated as an individual database. Multiple disparate databases instantiated from the same data model are best characterized as incompatible information silos. The simple reason for these information silos is that the interfaces between these databases were never adequately designed as the established data modeling methods were never engineered for this purpose.
While databases often contain common data such as addresses, organization, persons, and products, for example, established data modeling methods do not adequately address designing compatibility between the common data of these databases. The database incompatibility that results is an unintended artifact of established data modeling methods and is the essence of the data integration problem. The lack of compatibility between databases is the main reason that the established data modeling methods needed to be enhanced.
Data Integration by Design methods are a simple enhancement of the established data modeling methods that we named Integrated Data Modeling. Integrated Data Modeling methods focus upon designing interoperability between “integrated” databases where the proper data compatibility and data management functionality is provided. Integrated databases are a set of databases designed so that data from any of the set of databases may be dynamically combined in real-time.