1000 Techniques to Join Data Across Database Platforms
Which is more difficult, landing on the Moon or joining tables across database platforms? It is probably more difficult to land on the Moon.
However, everybody knows databases are proprietary and don't talk with others. Over 20 years, we made it our business to integrate all database systems completely.
Can we join data across database platforms in a single query? Not only can we do it, but we have also made it so anyone and everyone can do it.
Why do we use thousands of techniques inside the engine to do federated queries? Because data is complicated, the size of data matters and system resources are scarce, so we allow users to join data in any way they want.
I will start the video by showing simple techniques to combine data from different platforms. At first glance, you might even say this is not sophisticated, but as the video progresses, you will soon understand that we can join data across any combination of systems in any way you want.
You will begin to believe when I join 20 tables from 20 different systems in a single query. You will know we are serious when I join a production table with 19 Excel spreadsheets.
And all you have to do is point-and-click your mouse!
Смотрите видео 1000 Techniques to Join Data Across Database Platforms онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Coffing Data Warehousing 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 198 раз и оно понравилось 1 людям.