Strategic Insights, Inc.
  • Home
  • About Strategic Insights
  • Data Reintegration Methodology
    • Data Modeling Flaw Causes Disparate Data
      • The Vision of Data Integration
        • Slash Data Integration Costs
          • ETL - Tedious, Complex, Expensive
            • ETL Data Integrations Are Obsolete
            • Data Integration Architectures
              • Data Architecture Standards
                • Disparate Data System Integration
                  • Data Federation Architectures
                    • Master Data Management Architecture
                      • Integrated Data Warehouse
                        • Integrated Data Architecture
                        • Data Model Integration
                          • Data Model Recasting
                            • Commonality Relationships
                            • Database Integration
                            • Products & Services
                            • Blog
                            • Contact Us
                            The Natural State of Data is to be Integrated 02/04/2012
                            3 Comments
                             
                            Is data naturally integrated or does it naturally exist as islands of disparate data?  Our investigated in search of the natural state of data began with our universe of data.  Our universe of data is composed from all metadata and all data from all data sources. Data models are perhaps our best  depiction of our universe of data. Within each well-developed data model, every data entity is connected by entity relationships to other data entities.  No data entity or cluster of data entities is isolated or partitioned from any other cluster of data entities.  There are no islands of disparate data represented within a single data model and there is no sign of data isolation.   

                            While we have certainly developed islands of disparate data within our data architectures, data integration methods may be applied to integrate this isolated data. Since any island of disparate data may be resolved by current data integration methods, one could therefore conclude that our universe of data should be integrated.  That is to say that the natural state of data is to be integrated.

                            So why is data isolation so prevalent in our data architectures?  We have discovered
                            that these islands of disparate data are an unintended artifact of our currently flawed data modeling methodology that ignores the interactions between data  models.  With current data modeling methodologies, data models are developed independently and composed from heterogeneous metadata.  The lack of metadata commonality and the lack of links between data models result in metadata and data isolation.  Since each database is normally developed from a single data model, the resulting database is just as isolated as the original data models.

                            Our new Data Reintegration Methodology corrects the database design flaws and eliminates the data isolation that was instantiated into our databases. Our data models now support relationships between data models. This is another first in the industry! These inter-data model entity relationships are named commonality relationships.  Commonality relationships, when properly instantiated, supports referential integrity between databases.  Within the Data Reintegration data architecture, each data model becomes a part of a distributed network on integrated data models.  When databases are instantiated from these data models, each database becomes a part of a single distributed network of integrated databases. 

                            You are invited to leave comments on this blog.  For more detailed information, 
                            contact us and request the Data Reintegration Methodology whitepaper.

                            Data Reintegration is a trademark of Strategic  Insights Inc. 
                            The Data Reintegration Methodology is patented by U.S. patent no. 7,979,475 and other pending patents. 
                            ©Copyright Strategic Insights, Inc. 2012.  All rights reserved.




                             


                            Comments

                            Thomas Vrouenraets link
                            02/15/2012 18:34

                            Always interested in new integration ideas! It's still one of the major challenges.

                            Reply
                            David Eddy link
                            03/17/2012 14:51

                            Given that very few organizations make even a half-hearted attempt to collect metadata, much less keep it current, the claim of "all metadata" is suspect.

                            How does one go about this?

                            Reply
                            Bob Mack link
                            03/18/2012 21:07

                            @ David - Thanks for the comment.
                            Perhaps I was not clear. I was attempting to define “our universe of data” as the totality of data and of metadata. This definition is required for my hypothesis that the natural state of data, in “our universe of data”, is to be integrated. Thanks again; Bob Mack

                            Reply

                            Your comment will be posted after it is approved.


                            Leave a Reply

                              Author

                              Robert Mack, Ph.D.
                              President of Strategic Insights, Inc. and Inventor of the Data Reintegration Methodology

                              View Robert Mack's profile on LinkedIn

                              Archives

                              April 2012
                              March 2012
                              February 2012
                              January 2012

                              Categories

                              All
                              Data Architecture
                              Data Integration
                              Data Modeling
                              Master Data


                              RSS Feed

                              Follow @RobertFMack
                              Click the Twitter button above to follow us for updates and special offers.

                              Get a free copy of the Data
                              Reintegration Methodology whitepaper
                              by:
                              Adding a blog
                              comment on this page
                               
                              or
                              completing the information request form.

                            Web Hosting by StartLogic