0

I am familiar with SQL server as a product and want to use this to do data federation across a wide range of data sources that can be accessed trough linked servers. My data volumes are rather limited.

However I am interested how would this approach compare to existing data virtualisation software on a data federation level performance wise?

SQL server has his own query optimization engine and so on... so will performance of sql server linked servers federated queries be comparable to the Denodos, Red hats, Ciscos,... and other Data Virtualization products of this world? Or do they have some other trick up their sleeve?

Kind Regards!

OverflowStack
  • 259
  • 1
  • 3
  • 17
  • 1
    All I can tell you is Redhat Data Virtualization is NOT compatible with SQL Server federated queries. I do not suspect anyone else would be either. Download a Redhat datavirt copy from http://jboss.org and give it a try side by side test for performance. But I caution that to do such side of side bake-off you need to plan carefully to compare apples to apples :) – Ramesh Reddy Sep 18 '17 at 17:38

1 Answers1

0

The specialised data virtualization tools do have optimization techniques you will not find in LinkedServer and similar technologies. The optimizers of DV systems have been designed from scratch to work with distributed architectures, while the optimizer of SQL Server has been designed for a conventional database. The problem of optimizing queries in both scenarios is VERY different.

You can check this two blog posts by Denodo to get an idea of the differences (DISCLAIMER: I work for Denodo):

http://www.datavirtualizationblog.com/performance-data-virtualization-logical-data-warehouse-scenarios/

http://www.datavirtualizationblog.com/cost-based-optimization-in-data-virtualization/

Aubrey
  • 11
  • Interesting! Currently i am trying a POC between Denodo and SQL Server linked servers to compare the performance on exactly the same setup to the same sources with the same queries ... to be able to compare apples to apples. – OverflowStack Sep 25 '17 at 06:43