How Data Virtualization can display the data in real time?

[cristopher.torres]

Hello! I've always heard that data virtualization achieves an information response in real time and wants to know if there is a source that supports how it achieves it; If you have a link or document would appreciate it very much.

[rareddy]

You can use what we call materialization to cache the data of view. You can read about it here Materialized Views · Teiid Documentation

[cristopher.torres]

First of all thanks Ramesh for the time you give me to help me.

I understand that materializing views is something that you must create and is available in certain database engines. But, I have been able to see that without the need to create them I can see the data in real time and that is what my question is; How does it do it?

[rareddy]

Not sure what you mean. The whole idea behind JBoss Data Virtualization (JDV) is creating logical views based on disparate datasources. i.e. you can connect to databases like Informix, Oracle and/or files, web services etc at same time, and create a View that spans more then single data source in JDV. And when you query this View, all the data sources that involved in creating this View will be queried in real time and results are fetched and presented to the user. Here I am saying JDV also offers a option to cache these View result content (aka Materialization) if you want. The materialization is created inside JDV not the source databases, it can be as easy as setting a single property on the View to turn this option ON.

I suggest you run through a quick start example like the one here first to understand fully how JDV works. Hello World Teiid Data Federation Example - Teiid Examples - Project Documentation Editor  This example is written for Teiid, but equally applies to JDV.