Data has always been a vital part of every business. It is therefore valuable for businesses to be able to integrate, manage, access, and aggregate data from different sources regardless of their physical location or real-time structure.
Distributed databases and heterogeneous data stores can be viewed as a single database by virtue of data virtualization technologies. ETL on data is virtualized through data virtualization servers rather than physically performed with transformation engines. With this technology, users can access enterprise-wide data - including big data sources, traditional databases, cloud, and IoT - in a fraction of the time and cost required for physical warehousing.
In contrast to traditional data warehouses, data virtualization often does not require a comprehensive infrastructure since data are often unbroken in their data supply systems. Usually the cost of this approach is lower than for normal ETL, which requires that data be transformed into specific formats before being physically stored.
Dell Technologies has partnered with Starburst to offer its customers the ability to use data virtualization across multicloud environments. For data-driven organizations, Starburst's capability of querying data across any database makes the solution instantly actionable. With Starburst, you can run rapid analytic queries against data sources ranging from gigabytes (GBs) to petabytes (PBs) by using Trino, an open-source, high-performance distributed SQL engine.