Code Impact

Code Impact

By Sanket MakhijaEducation
Download on the App Store

All Code Impact episodes

  • Uber's MySQL Upgrade: A Smooth Ride to Version 8.0

    Join us as we go behind the scenes with Uber engineers to learn how they upgraded their massive MySQL fleet to version 8.0 - without any downtime! We'll explore the challenges they faced, the solutions they developed, and the lessons they learned along the way. From performance boosts to enhanced security, discover how this major upgrade paved the way for a smoother, more efficient Uber experience.


    Reference: https://www.uber.com/en-IN/blog/upgrading-ubers-mysql-fleet/

    12 min
  • Data Wranglers: Mastering the Art of Data Integration with AWS Glue

    In this podcast, we explore the intricate world of data integration and how AWS Glue empowers data professionals to conquer its complexities.

    Through conversations with experts and real-world case studies, we uncover the secrets to efficiently extracting, cleaning, enriching, and loading data using Glue's powerful suite of tools.

    Whether you're a seasoned data engineer or a curious data scientist, join us as we break down the barriers to seamless data integration and unlock the true potential of your data.

    Referece: https://drive.google.com/file/d/1CxK5bTV8ZQgNFe3TI582W9N8PyLa5nK3/view

    12 min
  • Revolutionising Cloud Data Warehouses: The Power of Predicate Caching
    • Cloud data warehouses have become an essential part of data analytics, offering speed, scalability, and elasticity for processing massive datasets12.
    • However, traditional caching methods like result caching and materialized views often struggle with data updates and can have high overhead134.
    • This episode explores predicate caching, a novel indexing technique that enhances query performance by caching ranges of qualifying data, leading to significant speed improvements without the drawbacks of traditional methods56.
    • Tune in to discover how predicate caching leverages the repetitive nature of real-world workloads, minimises resource usage, and adapts to data updates seamlessly.
    • Reference: https://drive.google.com/file/d/1K-tWD8-SnQbenEajEHKfPOOL7va-3viA/view

      6 min
    • Beyond the Cloud: Databases for the Serverless Edge

      Explore the cutting-edge world of serverless computing at the network edge and the challenges of integrating databases for lightning-fast data access.

      Join us as we unpack Limbo, a groundbreaking approach to re-architecting SQLite, the world's most popular database, for a serverless future.

      We'll discuss the limitations of traditional database architectures in serverless environments and how asynchronous I/O could unlock a new era of performance and scalability.


      Reference: https://drive.google.com/file/d/1nuURga5TdctAorXCRPOraIgiLwT0n6S-/view

      6 min
    • Scaling Up with Amazon Redshift

      This podcast explores how businesses can use Amazon Redshift to scale their data warehousing needs. Each episode will feature experts who will share their insights on topics such as intelligent scaling, performance tuning, and best practices for using Redshift.


      Reference: https://drive.google.com/file/d/1E7cb5Ttj21JvI3svJC0QnkhncycX2PS-/view

      5 min
    • Inside GFS: A Deep Dive into Google's Distributed File System

      This podcast explores the Google File System (GFS), a groundbreaking distributed file system designed to handle Google's massive data processing needs.

      We'll examine the key design principles behind GFS, such as its focus on fault tolerance, scalability, and high aggregate performance.

      Join us as we discuss the challenges of building and maintaining such a system, and the innovative solutions that Google engineers have implemented.


      Reference: https://drive.google.com/file/d/1S_hYRcjdo7aR0ShXuIuK5ePQm2U0FEs2/view

      11 min
    • Building Highly Available and Durable Applications with DynamoDB

      In this podcast, we'll explore how Amazon DynamoDB ensures high availability and data durability for mission-critical applications.

      We'll discuss how the service replicates data across multiple availability zones, employs techniques like log replicas to maintain write quorums, and continuously verifies data at rest to prevent data loss.

      We'll also cover strategies for failure detection, deployment best practices, and managing dependencies on external services.

      Learn how to leverage DynamoDB's robust features to build resilient and reliable applications.


      Reference document: https://drive.google.com/file/d/1nA7iL9b_WLlQKhuzAV9RlgsrSrWKDsG4/view

      20 min
    • Scaling for Dhoni: How JioCinema Streams IPL to Millions

      This podcast goes behind the scenes with Prachi Sharma, a senior engineering director at JioCinema, to explore the technical challenges of live streaming the Indian Premier League (IPL) to millions of concurrent viewers.

      • Discover how JioCinema’s engineering team prepares for massive traffic spikes, especially when MS Dhoni is playing, by using strategies like pre-scaling, multi-CDN optimisation, and graceful degradation.
      • Learn about the crucial role of feature flags in mitigating issues during live matches, as well as the importance of rigorous auditing and testing of both front-end and back-end systems.
      • Gain insights into the complexities of ad insertion at scale and the different approaches to delivering targeted ads to viewers.
      • 20 min
      • A Flexible Large-Scale Similar Product Identification System in E-commerce

        This research paper explores the development of a "Product Similarity Service" (PSS) for identifying similar products within e-commerce platforms.

        The authors highlight the challenges of defining "similarity" across diverse applications and the need for scalable solutions to handle massive product datasets. PSS leverages deep neural networks, multi-task learning, and distributed computing techniques to address these challenges.

        The system employs a hybrid approach, integrating product content information (e.g., images, titles) with customer behaviour data (e.g., co-purchases, co-views), and provides flexible configuration options for different applications.

        Experimental results demonstrate the effectiveness of PSS in both offline evaluation tasks (pairwise verification and ranking) and online A/B tests conducted on Amazon products.

        The paper concludes with a discussion of the system's scalability, potential future extensions, and its potential for broader research use.

        https://drive.google.com/file/d/16fqZFuri2WWKM6bfsy-HpWe0hWkdWZdV/view

        9 min
      • SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL

        This document discusses the limitations of SQL and proposes a solution in the form of pipe syntax. The document is titled "SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL" and focuses on the idea that SQL, a language used for managing data in databases, has deficiencies.

        The authors advocate for using pipe syntax to improve SQL's capabilities, suggesting that it would address some of the perceived problems within the existing SQL framework.

        https://drive.google.com/file/d/1hmtVJJ5Lud3Z1GebHqZGW1V-8Oe0g3lN/view

        4 min