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!
Auf dieser Seite können Sie das Online-Video 1000 Techniques to Join Data Across Database Platforms mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Coffing Data Warehousing 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 240 Mal angesehen und es wurde von 1 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
