Tandem Primary Keys tm are a new type of primary key that totally isolates business data from the keys that link data records between database tables. This level of business data isolation did not exist before the use of Tandem Primary Keys and the reference data, that is the defining or identifying business data, was too tightly coupled to all their linked data records.
Tandem Primary Keys work in consort with your current primary key to extend the functionality of your existing data structures. You are now provided a new paradigm where the reference data is completely isolated. Your core reference data may now be cleansed, removed, replaced, augmented, shared, enriched, or redirected. Your imagination is the limit!
The use of Tandem Primary Keys has a most tremendous impact upon data architectures. It appears that any data architecture you can imagine is now possible! Centralized, distributed, vertically and horizontally partitioned data architectures are supported. Linking databases together into coherent collections of information is no longer difficult. Data Transformation or ETL programming is now minimized for producing data warehouses!
By using Tandem Primary Keys in our data architectures, we may:
-
Encourage data integration, data hygiene, and other data functions as ongoing processes instead of one-shot data transformations.
-
Develop a data architecture that greatly reduces the cost of providing quality data.
-
Enhance the functionality of current database objects without impacting current applications.
-
-
Develop a data architecture that endures data requirements chaos and still provides a solid, long-term foundation for managing data assets.
Tandem Primary Keys tm is a trademark of Strategic Insights, Inc. Tandem Primary Keys is patented by U.S. Patent No. 6801915. Copyright ©2005 Strategic Insights, Inc. All Rights Reserved.
