One of the most exciting opportunities in my career was training corporations on their Teradata Enterprise Data Warehouse. I was one of the original teachers at Walmart, AT&T, Bank of America, and Bell Labs, and I eventually taught over 1,000 classes across 5 continents.
The Enterprise Data Warehouse concept allowed thousands of users to access and join tables across all aspects of the business and thus provided a single source of the truth.
However, with the tidal wave of data, advanced analytics, machine learning, geospatial data types, and cloud computing, the sheer magnitude and volume meant no system was powerful enough to manage everything.
The only answer is to join data across systems, referring to federated queries.
In a world where data is the linchpin of success, joining tables across different systems is not just a convenience; it’s a necessity. Combining tables across any two systems in a single query is even more important as organizations migrate to the cloud. As we navigate the complexities of modern business, data integration should be a cornerstone of our strategy.
The Enterprise Data Warehouse, as we know and love, is dead.
I spent 20 years and millions of dollars perfecting the federated query’s art with a team of developers second to none.
To show you how perfect I will join 20 tables in a single query involving 20 separate systems and process the join on any system I choose. And one of the tables will be an Excel spreadsheet!
Every enterprise has thousands of users and hundreds of departments, each responsible for different systems. When everyone can perform federated queries on the systems they access, your company is at the forefront of data, and your competitors are outclassed.
If you’re interested in exploring how we can leverage data integration to drive success in our organization, I’d be happy to discuss this further. Please feel free to reach out.
Thank you for your time, and I look forward to hearing from you.
Tom Coffing, better known as Tera-Tom, founded Coffing Data Warehousing, where he has been CEO for the past 30 years. Tom has written over 90 books on Architecture, performance tuning, and SQL on all relevant systems. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus, which celebrates 20 years of brilliantly integrating all databases.