Revolutionising the future of Television

Managing and optimising 4 petabytes of client data

22 July 2022 | Noor Khan

Managing and optimising 4 petabytes of client data

Key Challenges

Our client dealing with a growing, high volume of varied, complex data required advanced support and maintenance to avoid loss of data, ensure high uptime and enable data accessibility.

Key Details

Service

Managed Services

Technology

Python, Amazon SQS, Amazon S3, Amazon EC2, Amazon Redshift, Razor SWL Tool, Putty, Git, WINSCP

Industry

Technology

Sector

Entertainment

Key results

  • Around the clock data support and management
  • Near real-time data processing and reporting
  • A huge amount of data managed effectively
  • High level of error detection and alerting
  • Continuous development in line with the evolution of technologies
  • Over 7 years of data management

Leading consumer electronics brand

Dealing with huge volumes of data

Our client are a US-based, leading consumer electronics brand selling various electronic products such as LCD TVs, soundbars and operating systems for their smart TVs. They have been building innovative technology products for over two decades and are now an IPO listed company with an annual turnover of more than $2.1 billion. With a large consumer audience, our client collects huge volumes of TV data from their audience across the US.

Optimising 4 petabytes of client data

Ensuring data availability, consistency and accuracy

Delivering data quickly and efficiently

Data availability for our client was crucial. They were dealing with vast volumes of varied, complex TV and commercial data. They collected the data from all users that have opted in across the US, and this large amount of data is coming in continuously. It was vital that the data was available for our client’s data science teams, accurate and full without any data drops or gaps.

Read our success story on building a 10 TB data lake

Optimising 4 petabytes of client data

Optimising 4 petabytes of client data

Continuous data streams managed efficiently

Ardent’s exceptional engineers work around the clock to provide data engineering support to help effectively manage client data. Our data engineering team manage three Redshift clusters on behalf of the client, the first cluster contains the data for the previous month, the second cluster contains the data from the previous year and the third cluster is used for data sharing.

These clusters contain a substantially large amount of data as you can see in the image below. To put this into perspective, an average laptop has storage of around 256GB, so 1PB would equate to the storage of around 3,900 laptops.

Data clusters and the petabytes of data within them

One of the biggest technical challenges that our data engineering teams succeeded on was processing the data and delivering it to the client in near-real-time. Our expert data engineers were able to provide near real-time availability of the data to our client’s data science team by processing data in 6 parallel streams in Redshift, considerably increasing the speed at which the data available to the client.

The data is processed, transformed, loaded, and sent to the client ensuring that its free of duplication and errors and is delivered in near-real-time.

Advanced error detection and alerting

Ensuring data consistency

As part of the solution, our data engineers have the highest error detection and alerting processes in place with PagerDuty to ensure that any issues that arise are dealt with quickly and efficiently. Our teams are consistently monitoring the data around the clock to make certain that any errors that arise are communicated with the relevant teams and resolved immediately. This is to make sure that there is no loss of data which can lead to data gaps.

Managing and optimising 4 petabytes of client data

Progression of technologies

Continuous optimisation

We have been managing our client’s data for over seven years and how we do this has developed over time with the evolution of technologies. With a long-term project, consistent optimisation is key. Therefore, we are currently, we are in the process of moving data processing from Amazon S3 to AWS Firehouse for quicker data ingest and reporting for the client.

Find out about our technology partners.

Actionable commercial insights

Boosting revenue and growth

The Ardent data engineering team have been effectively managing our client’s data for over seven years and continue to innovate and evolve to improve data speed, accuracy and performance. We ensure that the client has peace of mind knowing that their data is in safe hands with Ardent and is managed effectively, securely and in line with industry best practices. Our client are able to use the data collected to gain meaningful insights for commercial benefit, boosting revenue and growth.

Explore our operational monitoring and support services or if you are looking to unlock your data potential get in touch today.

More Success Stories

recruitment software product

Success Story

Getting the job done

Technology | Recruitment, Software

Our client were looking to upgrade their existing software which was windows based and presented multiple limitations. They required expert skills to design and deliver software which would make the subscription-based software easier to deliver to end customer with improved features and functionality. [...]

Read More... from Revolutionising the future of Television

Keeping data consistent with operational monitoring and support

Success Story

Making data science efficient

Market Research | Entertainment, Broadcasting

Our client required high data availability with no delays therefore, they needed to ensure that their data pipeline consisting of various sources were continuously and consistently running without errors. [...]

Read More... from Revolutionising the future of Television

Robust, scalable data pipelines with AWS infrastructure

Success Story

Powerful insights driving growth for global brands

Market Research | Entertainment, Media

Our client were looking to collate data from various sources with high data accessibility and accuracy to provide a speedy turnaround time for their end customer. [...]

Read More... from Revolutionising the future of Television

Ardent Insights

Data Warehousing Architecture: Azure SQL vs Redshift

Data Warehousing Architecture: Azure SQL vs Redshift

There are quite a few different data warehouse technologies to choose from, and knowing where to start, what to look for, and what data warehouse service is going to be best for your business is key. Deciding on a data warehousing technology that is suitable to your business needs, goals and objective is essential as [...]

Read More... from Revolutionising the future of Television

Data Warehouse vs Database: The key differences

Data Warehouse vs Database: The key differences

Cloud technology and advances in hybrid-storage technologies have meant that data storage is no longer left entirely to internal equipment and a single company-owned server. Finding a database management solution that works with the size and scale of your needs is not a task to be overlooked. [...]

Read More... from Revolutionising the future of Television

Building data pipelines – a starting guide

Building data pipelines – a starting guide

Data visibility can be a huge driving factor for organisation growth. Poor data visibility can lead to a lack of compliance with data security, difficulty in understanding business performance and increased complexity in dealing with system performance issues. Developing secure, robust and scalable data pipelines can empower businesses to gain data visibility by connecting the [...]

Read More... from Revolutionising the future of Television