Logical Data Warehouse / Virtual Data Warehouse

A Logical Data Warehouse (LDW) is a data warehouse that is implemented through Data Virtualization middleware rather than physically copying data. Data Virtualization is a technology that provides a consistent interface to data that is located in multiple, heterogeneous data stores. It provides a level of data abstraction which makes the data appear to users to be a single, large data store. The end-user does not need to know where data is physically stored or what type of database technology contains it.

Data Virtualization is a powerful technology which improves read access to data – such as:

• Fast Time to Market: enables rapid PoC and prototyping.
• Virtual Database: creates small virtual databases to support individual microservices.
• Logical Data Warehouse: brings in data from multiple sources – combining data warehouses and big data.
• Virtual Data Mart: provides a subset view into existing data warehouses and databases.
• Analytical Sandbox: supports data exploration.
• Cloud Source: avoids copying excessive data to or from the cloud or between cloud platforms.
• ETL Source: makes ETL independent of specific data sources and abstracts data transformation.
• Transactional Updates: performs updates of underlying data stores.