Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the use of materialized view in talend how can i use it ?
Hi,
Materialized view will create a data replica of a big table or an expensive query which will be used for data ware environment. Below link is a fantastic article about Materized view from Oracle.
https://docs.oracle.com/cd/B10500_01/server.920/a96567/repmview.htm
If you notice the version of Oracle, it is 9.2 and during that time, datawarehouses and Data lakes were not matured enough like today. So many business queries were executed on top of the materialized views.
But my personal view is that new technologies in OLTP, data warehouses and Data lakes have almost made the concept of Materialized views to a sunset mode. You can run much complex queries directly in Data warehouse (or in Data like using Bigdata jobs).
So it is a concept good to understand but always think about new developments in technology related to data.
If my answer has helped to resolve your query, could you please amrk the topic as resolved? Kudos are also welcome 🙂
Warm Regards,
Nikhil Thampi
Hi Ram,
Could you please share more inputs about your use case where you need to use Materialized views instead of normal views? Could you also specify the database you are using to achieve it and it would be great if you could share your current Talend job flow diagram which you have created to achieve your use case.
Warm Regards,
Nikhil Thampi
Hi,
Materialized view will create a data replica of a big table or an expensive query which will be used for data ware environment. Below link is a fantastic article about Materized view from Oracle.
https://docs.oracle.com/cd/B10500_01/server.920/a96567/repmview.htm
If you notice the version of Oracle, it is 9.2 and during that time, datawarehouses and Data lakes were not matured enough like today. So many business queries were executed on top of the materialized views.
But my personal view is that new technologies in OLTP, data warehouses and Data lakes have almost made the concept of Materialized views to a sunset mode. You can run much complex queries directly in Data warehouse (or in Data like using Bigdata jobs).
So it is a concept good to understand but always think about new developments in technology related to data.
If my answer has helped to resolve your query, could you please amrk the topic as resolved? Kudos are also welcome 🙂
Warm Regards,
Nikhil Thampi
Hi,
I would use something different rather than creating a materialized view on top of same database 🙂
Warm Regards,
Nikhil Thampi
Hi Ram,
It depends on the technology landscape available in your organization. A simple example will be to pump the necessary details to a Massively parallel processing data warehouse like Snowflake or Teradata) rather than using a Materialized view to generate your reports.
You will have to do research based on your specific use case and there is no single solution for all the different use cases.
Warm Regards,
Nikhil Thampi