11/22/2023 0 Comments Oracle virtualizationOn the other side, when massive amounts of data need to be parsed, transformed and joined and data-retrieval speed is the key, then an ETL (or ELT) approach is still the way to go. Data Virtualization is a perfect scenario when reduced amounts of data coming from various systems need to be joined and exposed. To be clear: Data Virtualization is NOT a replacement of ETL, both paradigms are valid in specific use-cases. Unlike the ETL approach, there is no data copy or movement, with source systems accessed in real-time when the query is executed (also called Query in Place (QIP)). Data Virtualization abstracts the technical aspects of the datasources from the consumer. ![]() ![]() The fast growth of company's data, data-sources and data-formats is driving an increasing interest in the field of Data Virtualization what is it about? And what tools can provide this functionality?ĭata Virtualization defines an approach to expose data coming from disparate data sources via a common interface to downstream applications.ĭo you have your sales data in an Oracle Database and client peculiar information in some Cloud App? Data Virtualization will show them as an unique data source while, in the backend, will fire the proper queries to source-systems, retrieve the data and apply the correct joining conditions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |