Hi [[ session.user.profile.firstName ]]

Under the Hood of Denodo’s Query Optimizer

The optimizer is one of the most complex parts of any data engine; it must ensure that the execution engine is performing at its best, so understanding how it works, is crucial.

This webinar deep dives into the various performance optimization techniques employed by Denodo’s Dynamic Query Optimizer and illustrates these techniques via a demonstration.

View this session to ensure that you achieve the maximum value from your data processing infrastructure:

Various components of query optimization engine
Different stages leveraged within the optimizer and the techniques applied.


When, how and why to use each option available in the query optimizer
Don’t miss the chance to discover Denodo’s Query Optimizer capabilities.
Recorded Mar 10 2017 57 mins
Your place is confirmed,
we'll send you email reminders
Presented by
Pablo Álvarez, Principal Technical Account Manager, Denodo
Presentation preview: Under the Hood of Denodo’s Query Optimizer

Network with like-minded attendees

  • [[ session.user.profile.displayName ]]
    Add a photo
    • [[ session.user.profile.displayName ]]
    • [[ session.user.profile.jobTitle ]]
    • [[ session.user.profile.companyName ]]
    • [[ userProfileTemplateHelper.getLocation(session.user.profile) ]]
  • [[ card.displayName ]]
    • [[ card.displayName ]]
    • [[ card.jobTitle ]]
    • [[ card.companyName ]]
    • [[ userProfileTemplateHelper.getLocation(card) ]]
  • Channel
  • Channel profile
  • My ETL Tools Do Everything That I Need. Why Do I Need Data Virtualization? Jul 28 2021 12:00 pm UTC 45 mins
    Paul Moxon, SVP Data Architectures & Chief Evangelist, Denodo
    So your data architecture keeps getting more and more complex - new data sources, new data types and formats, and ever-increasing demands from the users for more, better, and faster data. You're struggling to keep up and your users are getting more and more vocal about the amount of time it takes to get their data. But you have faith in your ETL tools. They've solved the problem in the past and you're sure that they can do the same now…or can they?

    ETL tools - or even the ELT variants - have their use and purpose. We're not going to argue that. However, they are not the solution to all of your data integration and access challenges. Data Virtualization can provide quicker and easier access to integrated and curated data that doesn't require the creation of data replication pipelines and tasks. In many circumstances, this can be a better alternative to ETL and can promote self-service initiatives to reduce the pressure on stressed ETL teams.

    Not convinced? Give us an opportunity and join us as we try to bust this myth!

    Watch this webinar as we explore the benefits and pitfalls of ETL and how Data Virtualization can be a complementary alternative to copying data to make it accessible by users.
  • Logical Data Fabric for Building a Unified Data Warehouse and Data Lake Jul 15 2021 6:00 pm UTC 60 mins
    Robin Tandon, Director Product Marketing, Denodo
    In the recent Building the Unified Data Warehouse and Data Lake report by leading industry analysts TDWI we discovered 64% of organizations stated the objective for a unified Data Warehouse and Data Lakes is to get more business value and that 84% of organizations polled felt that a unified approach to Data Warehouses and Data Lakes was either extremely or moderately important. During this webinar, we will discuss how by applying a logical data fabric and the associated technologies of machine learning, artificial intelligence and data virtualization. We will discuss how a Logical Data Fabric reduces time to value hence increasing the overall business value of your data assets.

    Attend & Learn:
    * How a Logical Data Fabric is the right approach to assist organizations to unify their data.
    * The advanced features of a Logical Data Fabric that assist with the democratization of data, providing an agile and governed approach to business analytics and data science.
    * How a Logical Data Fabric with Data Virtualization enhances your legacy data integration landscape to simplify data access and encourage self-service.
  • Bringing a Real-Time Flavor to Your Enterprise Analytics (APAC) Jul 15 2021 2:00 am UTC 60 mins
    Sushant Kumar, Product Marketing Manager, Denodo and Katrina Briedis, Sales Engineering, Denodo
    Real-time analytics techniques promise to enrich your traditional analytics with real-time data points. It's key for many scenarios like supply chain management or customer care. Data Virtualization is well known for offering real-time connectivity to diverse sources and federation capabilities: the two base ingredients for real-time analytics. However, building a strategy around these concepts can be challenging. Impacting delicate data sources, security, and performance concerns are often mentioned.

    Attend this session to learn more about:
    - What are the scenarios where the value of real-time analytics can make a difference
    - The core capabilities that enable them
    - Key best practices to make them succeed
  • A virtualização dos dados pode sustentar o desempenho com consultas complexas? Jul 14 2021 2:00 pm UTC 45 mins
    Evandro Pacolla
    Você é um dos céticos sobre o desempenho em tempo real da Virtualização de Dados? Se sim, junte-se a nós para esta sessão de webinar para que possamos demonstrar o verdadeiro valor e desempenho desta moderna tecnologia de integração de dados e tenha dito: "Uau".

    A virtualização de dados é uma ferramenta que permite a integração de dados de vários locais, em vários formatos e através de diferentes latências. Muitas vezes ouvimos dizer que, por causa disso, ela deve sofrer atrasos e problemas de desempenho. Na verdade, é um dos mitos mais comuns que temos que abordar, por isso decidimos acabar com ele.

    Aqui está o que vamos cobrir:
    A virtualização de dados não é só performática, mas também impulsiona o desempenho.
    Uma case real sobre um de nossos clientes e como eles estão otimizando o desempenho em sua organização.
    Uma rápida demonstração para mostrar a rapidez com que se pode executar uma consulta de múltiplas fontes usando a virtualização de dados.
  • ROI e valore per il business della Data Virtualization Jul 9 2021 9:30 am UTC 60 mins
    Andrea Zinno - Data Evangelist | Denodo
    Gartner prevede che le organizzazioni che utilizzeranno la virtualizzazione dei dati spenderanno il 40% in meno per l'integrazione dei dati rispetto a quelle che utilizzano tecnologie tradizionali.

    I clienti di Denodo, infatti, hanno registrato miglioramenti del time-to-deliver fino al 90% nei loro processi di provisioning dei dati e un risparmio dei costi di gestione e integrazione dati superiori al 50%.

    Partecipa a questo webinar per scoprire come la virtualizzazione dei dati può aiutare ad accelerare il vostro time-to-value dai dati riducendo allo stesso tempo i costi di gestione e integrazione del patrimonio informativo aziendale. Come diceva Rod Tidwell (Cuba Gooding Jr.) nel film "Jerry Maguire", "Show me the money!”

    Registrati per partecipare a questo webinar e approfondire su come la virtualizzazione dei dati può:

    • Ridurre i tempi di delivery dei dati agli utenti aziendali
    • Accelerare le iniziative di trasformazione digitale
    • Ridurre i costi e le timelines dei progetti
    • Portare valore alll’interno della tua organizzazione
  • Advancing Critical Banking Data Infrastructure without Business Disruption Jul 7 2021 2:00 am UTC 57 mins
    Nicholas Kuhne, CEO - Metora Data Science and Alex Hoehl, Senior Director - Denodo
    Many banking and financial services' organisations have been caught off-guard in their digital journey with external forces like a pandemic adversely impacting IT project timelines, resource availability, whilst also requiring innovation and agility to respond to the new normal. As the sector empowering businesses, banking organisations have to stay ahead without business disruptions to be able to respond to these internal and external impediments. Staying ahead on the digital curve requires modern data architecture and technology that ensures expansion and additional capabilities without stress to infrastructure, specifically when the landscape is a hybrid of legacy and modern applications.

    Join this webinar to learn about logical data architecture and how it modernises your data landscape, enabling a unified and integrated view of business data in real time, whether for customer360, financial intelligence, risk reporting, regulatory compliance, etc.
  • Enabling Cloud Data Integration Jul 1 2021 12:00 pm UTC 60 mins
    Robin Tandon Director of Product Marketing at Denodo & Mark Pritchard, Director of EMEA Sales Engineering at Denodo
    Denodo recently released the Denodo Cloud Survey 2021. Learn about some of the insights we have from the survey as well as some of the use cases Denodo comes across in the cloud. We will also conduct a brief product demonstration highlighting how easy it is to migrate to the cloud and support access to data in hybrid cloud architectures.

    In this session not only will we look at what you, the customers are saying in the Denodo Cloud Survey but also
    • We will explore how, in reality, many organizations are already operating in a hybrid or multi-cloud environment and how their needs are being met through the use of a logical data fabric and data virtualization
    • We will discuss how easy it is to reduce the risk and minimize disruption when migrating to the cloud
    • We will educate you on why a uniform security layer removes regulatory risk in data governance.
    • Finally we will demonstrate some of the key capabilities of the Denodo Platform to support the above.
  • Data Virtualization: Fulfilling The Digital Transformation Requirement In BFSI Jul 1 2021 7:30 am UTC 60 mins
    Alexey Sidorov - Chief Evangelist Middle East, Stefano Cruciani - Marketing Manager Middle East
    In the digital transformation era, Banking, Financial Services and Insurance (BFSI) organizations are globally accelerating their digital journey, making rapid strides with their digitization efforts, and adding key capabilities to adapt and innovate in the new normal.

    BFSI institutions need to update their legacy systems, create a single view of all their data, establish security controls across the entire infrastructure and implement strategies and services that will transform them into digital financial organizations. This can be achieved with Data Virtualization.

    In this joint live webinar session from Denodo, you will learn:

    • Industry key trends and challenges driving the digital transformation mandate and platform modernization initiatives
    • How data virtualization can help update and modernize data architectures
    • Key concepts of Data Virtualization, and how it can enable BFSI customers to develop critical capabilities for real-time / near real-time data integration
    • Success stories of BFSI companies that already use this technology to differentiate themselves from the competition, optimize processes, and create new business opportunities through more agile data management.
  • Enabling Real-Time Analytics in Today's Complex Enterprise Data Environments Recorded: Jun 24 2021 34 mins
    Chris Walters, Sr. Solutions Consultant, Denodo
    Achieving the goals of real time analytics in today's increasingly complex enterprise data environments poses numerous challenges. Most organizations today require efficient access to integrated data assets across a wide variety of on-prem and cloud data sources. In addition to the inherent complexities of real time integration of data across a variety of disparate sources that is enabled by data virtualization technology, being able to do so in a secure and performant manner while addressing concerns relevant to accessing delicate data sources makes this a most challenging obstacle for enterprise data professionals.

    Attend this session to learn more about:

    * Real time integration of data assets across disparate data environments
    * Minimizing impact to source systems during real time access
    * Optimizing performance in real time analytics scenarios
  • Analyst Webinar: Enabling a Customer Data Platform Using Data Virtualization -NA Recorded: Jun 23 2021 57 mins
    Mike Ferguson, Managing Director, Intelligent Business Strategies & Robin Tandon, Director Product Marketing, Denodo
    In today’s digital economy, customers are all-powerful. They have the ability to search for and find products and services, find reviews and ratings, find out about alternative products and services via search and social networks, ask questions of others about products and services, and find comparison sites. All of this can be done from a mobile device while on the move and with so many options available to them. They can switch to a competitor at the touch of a mobile phone screen or the click of a mouse.

    In this kind of economy, customer loyalty is cheap and so it is essential to know more about your customers, if you want to keep them. However, in many companies, customer data is fractured across many different systems with no way to share and access integrated customer data and insights across all channels to offer up a consistent, personalized customer experience.

    This webinar looks at this problem and shows how data virtualization can be used to create a Customer Data Platform to solve it.

    Discussion details:

    - Digital transformation and the impact on customers
    - The importance of the customer in the boardroom
    - Customer interaction - the impact of COVID-19 pandemic
    - Current problems facing many companies in the front-office from fractured customer data
    - The need for a Customer Data Platform to engage and retain customers while improving their overall experience
    - The central role of data virtualization as a foundation for a customer intelligent front-office
  • Delivering Faster Insights: The Hybrid Cloud Data Warehouse Recorded: Jun 23 2021 68 mins
    David Loshin, President of Knowledge Integrity and Ravi Shankar, SVP & CMO, Denodo
    The adoption of cloud data warehousing is no longer seen as teetering on the bleeding edge of technology; a growing number of organizations are already using a cloud data warehouse or cloud data lake to support enterprise business intelligence, reporting, and dashboards. Businesses that migrate to the cloud still face challenges that complicate their ability to leverage cloud-based resources. Although conventional wisdom promotes the cost-effectiveness of the cloud, ungoverned operations allow data storage, egress, and computing resource costs to spiral out of control. Cost management is a common challenge, plus some organizations remain concerned about adequate data protections.

    Organizations plan to address these challenges through technology, and businesses can overcome these uncertainties with a logical data fabric that seamlessly simplifies data movement and protection for reporting and analytics. In this webinar, we discuss the potential of a hybrid cloud data warehouse enabled by a logical data fabric, with data virtualization at its core, to deliver faster insights.

    Attendees will learn about:

    Hybrid cloud data warehouse architecture
    Optimizing data movement on the cloud
    Understanding cloud costs
    Harmonizing data security
    Streamlining data movement across the hybrid cloud environment
  • Bringing a Real-Time Flavor to Your Enterprise Analytics Recorded: Jun 17 2021 44 mins
    Pablo Alvarez-Yanez - Global Director of Product Management
    Real time analytics techniques promise to enrich your traditional analytics with real time data points. It's key for many scenarios like supply chain management or customer care. Data Virtualization is well known for offering real time connectivity to diverse sources and federation capabilities: the two base ingredients for real time analytics. However, building a strategy around these concepts can be challenging. Impacting delicate data sources, security and performance concerns are often mentioned.

    Attend this session to learn more about:
    * What are the scenarios where the value of real time analytics can make a difference
    * The core capabilities that enable them
    * Key best practices to to make them succeed
  • Enabling Self-Service Analytics with Logical Data Warehouse (APAC) Recorded: Jun 17 2021 66 mins
    Sushant Kumar, Product Marketing Manager, Denodo and Chris Day, Director, APAC Sales Engineering, Denodo
    What makes data scientists happy? Of course, data. They want it fast and flexible, and they want to do it themselves. But most classic data warehouses (DW) and data lakes are not easy to deal with for agile data access. A more practical solution is the logical data warehouse (LDW), which has shown to be a more agile foundation for delivering and transforming data and makes it easy to quickly plug in new data sources.

    Attend this webinar to learn:
    - How easily new data sources can be made available for analytics and data science
    - How your organization can successfully migrate to a flexible LDW architecture in a step-by-step fashion
    - How LDWs help integrate self-service analytics with classic forms of business intelligence
  • Se la meta è la Self-Service Analytics, il Logical Data Warehouse ne è la rotta Recorded: May 28 2021 77 mins
    Andrea Zinno - Data Evangelist, Paolo Crivelli - Technical Sales Director Italy | Denodo
    In tutte le aziende c’è una necessità crescente di ottenere informazioni e di prendere decisioni, spesso strategiche, a partire da dati che continuano a crescere in numero, volume e varietà delle fonti, e in cui la componente non strutturata è sempre più prevalente.

    La maggior parte delle soluzioni più classiche adottate fino ad oggi, come i tradizionali Data Warehouse e Data Lake hanno una governance più complessa e non garantiscono un accesso agile ai dati.

    I sistemi di Business Intelligence devono essere in grado di supportare nuove forme di reporting e di analisi, come l’analisi Self-Service, le analisi investigative e la Data Science; nuovi utenti, come clienti online, partner e fornitori; tecnologie emergenti, come Hadoop e NoSQL; fonti di dati esterne, come i dati sui Social Media e gli Open Data.

    Inoltre, elemento non meno importante, la velocità con la quale le aziende devono prendere decisioni o portare sul mercato nuovi prodotti o servizi, è sempre maggiore.

    La risposta a queste necessità aziendali, secondo gli analisti, è il Data Warehouse Logico (LDW), che ha dimostrato garantire una elevata agilità per il Delivery e la trasformazione dei dati, semplificando la connessione a nuove sorgenti dati, comunque siano fatte e ovunque siano.

    Partecipa a questo webinar per approfondire:
    • Come implementare un Data Warehouse logico secondo Gartner
    • Come la tua organizzazione può migrare in modo graduale e con successo verso un'architettura di Data Warehouse logico flessibile
    • Come rendere disponibili in modo agile e veloce nuove fonti di dati agli analisti e ai data scientist
    • In che modo il Logical Data Warehouse aiuta a integrare l'analisi Self-Service con le altre forme più classiche di Business Intelligence
  • Building a Consistent Hybrid Cloud Semantic Model In Denodo Recorded: May 27 2021 31 mins
    Mike Dickson , Sr. Sales Engineer, Denodo
    “Theoretically, business leaders know it’s important to have strategies in place to align stakeholders, decision making and activities with future organizational goals, but many still struggle when it comes to actually crafting those strategies. However, organizations with developed strategies are in a better position to obtain business value — especially when it comes to cloud computing.” Gartner Cloud Stategy Cookbook

    Many businesses are moving to the Cloud but still have lots of data On-Prem. How can they span both environments yet combine their data efficiently and quickly to get the answers they need?

    Join this session to get a deep dive look at how to create a Hybrid Cloud Architecture that solves this problem while providing a consistent Semantic Data Model where every your users get their data from, On-Prem or the Cloud.

    Attend this webinar to learn:
    * How to create a Semantic Data Model in Dendo
    * How to use Denodo Interfaces to abstract data access for the Semantic Model
    * How to create a shared Virtual Database that exposes a consistent Semantic Model using Denodo’s Interfaces regardless of users entering from On-Prem or The Cloud.
  • Data Services and The Modern Data Ecosystem Recorded: May 27 2021 73 mins
    Alexey Sidorov - Chief Evangelist Middle East, Stefano Cruciani - Marketing Manager Middle East
    Digital Transformation has changed IT the way information services are delivered. The pace of business engagement, the rise of Digital IT (formerly known as “Shadow IT), has also increased demands on IT, especially in the area of Data Management. Data Services exploits widely adopted interoperability standards, providing a strong framework for information exchange but also has enabled a growth of robust systems of engagement that can now exploit information that was normally locked away in some internal silo.

    Join us for our upcoming Middle East Webinar series episode, “Data Services and the Modern Data Ecosystem,” presented by Chief Evangelist MEA, Alexey Sidorov. Tune-in as we explore how a business can easily support and manage a Data Service ecosystem, providing a more flexible approach for information sharing supporting an ever diverse community of consumers.
    Attend this webinar to learn:
    ● Why Data Services are a critical part of a modern data ecosystem
    ● How IT teams can manage Data Services and the increasing demand by businesses
    ● How Digital IT can benefit from Data Services and how this can support the need for rapid prototyping allowing businesses to experiment with data and fail fast where necessary.
    ● How a good Data Virtualization platform can encourage a culture of Data amongst business consumers (internally and externally)
  • Physical or Logical Data Fabric: Which One to Use and When? Recorded: May 25 2021 46 mins
    Ravi Shankar, SVP & CMO, Denodo
    What is a data fabric? Gartner defines it as “one architecture that can address the extreme levels of diversity, distribution, scale and complexity in organizations’ data assets that are adding tremendous complexity to the overall data integration and data management design.”
    But do you know that data fabric can be logical or physical? What’s the difference? Which one to use and when?
    Attend this webinar and find out:
    · What is a data fabric?
    · How is a physical data fabric different from a logical data fabric?
    · Which one should you use and when?
    · What’s the underlying technology that makes up the data fabric?
    · Which companies are successfully using it and for what use case?
    · How can I get started and what are the best practices to avoid pitfalls?
  • Data Driven Insights via Cloud Data Integration Recorded: May 20 2021 46 mins
    Mitesh Shah, Senior Cloud Product Manager, Denodo
    Businesses have benefited greatly from the ability to combine all of their cloud applications as well as on-premises systems. Migrating workloads to the cloud has led to increased cloud adoption while business leaders are realizing their digital cloud transformation has the potential to unlock their data in extraordinary ways. Data driven insights and strategies help ensure that cloud data integration can enable the platform modernization initiatives in your organization.

    Attend & Learn:

    * How you can accelerate agile data integration for hybrid cloud workloads
    * How customers are reducing costs and delivering faster insights
    * Why Data Virtualization is finding enterprise-wide adoption
  • Simplifying Your Cloud Architecture with a Logical Data Fabric (APAC) Recorded: May 20 2021 62 mins
    Sushant Kumar, Product Marketing Manager, Denodo and Katrina Briedis, Sales Engineering, Denodo
    It's not if you move to the cloud, but when. Most organisations are well underway with migrating applications and data to the cloud. In fact, most organisations - whether they realise it or not - have a multi-cloud strategy. Single, hybrid, or multi-cloud…the potential benefits are huge - flexibility, agility, cost savings, scaling on-demand, etc. However, the challenges can be just as large and daunting. A poorly managed migration to the cloud can leave users frustrated at their inability to get to the data that they need and IT scrambling to cobble together a solution.

    In this session, we will look at the challenges facing data management teams as they migrate to cloud and multi-cloud architectures. We will show how the Denodo Platform can:

    - Reduce the risk and minimise the disruption of migrating to the cloud.
    - Make it easier and quicker for users to find the data that they need - wherever it is located.
    - Provide a uniform security layer that spans hybrid and multi-cloud environments.
  • Introduzione alla Virtualizzazione dei Dati Recorded: Apr 30 2021 76 mins
    Andrea Zinno - Data Evangelist, Paolo Crivelli - Technical Sales Director Italy | Denodo
    In un’era sempre più dominata dal cloud computing, dall’AI e dall’analisi avanzata, può sembrare per lo meno anacronistico che molte organizzazioni facciano ancora affidamento ad architetture di dati costruite prima della fine del secolo.

    Fortunatamente questo scenario sta subendo un cambiamento repentino con l’adozione di nuove tecnologie di integrazione dati, come la virtualizzazione dei dati, che forniscono un livello logico, in tempo reale e sicuro di accesso ai dati aziendali. Le diverse sorgenti dati non devono più essere trasferite fisicamente in un nuovo repositorio e trasformate, prima di essere utilizzate dall’azienda. E’ per questo che la virtualizzazione dei dati soddisfa le esigenze di trasformazione dell’architettura e permette la costruzione di un Data Fabric aziendale.

    In questa sessione parleremo di:
    1. Cos'è la virtualizzazione dei dati;
    2. Come differisce da altre forme di integrazione a livello Enterprise; 
    3. Casi d’uso della Virtualizzazione dei dati: Business Intelligence, Data Science, democratizzazione dei dati, Master Data Management, Dati distribuiti
    4. Perché la virtualizzazione dei dati si sta espandendo dentro le organizzazioni in Italia;
Achieving Business Agility with Data Virtualization
For IT professionals who are focused on data integration and enterprise data management and are overwhelmed by the growing number of data and data types, data virtualization provides real-time integration with agility to access and integrate disparate sources with ease. For business professionals, Data Virtualization brings agile information access that in turn drives business agility. The webcasts provided in this channel by Denodo, the leader in Data Virtualization, provide the latest in common usage patterns, use cases, best practices and strategies for driving business value with data virtualization.

Embed in website or blog

Successfully added emails: 0
Remove all
  • Title: Under the Hood of Denodo’s Query Optimizer
  • Live at: Mar 10 2017 9:35 am
  • Presented by: Pablo Álvarez, Principal Technical Account Manager, Denodo
  • From:
Your email has been sent.
or close