Hit the right note with data management

PPL verifies and validates millions of data records from multiple sources

PPL is a London-based music industry organization that licenses recorded music and music videos produced by record labels in the UK for use in public performances, broadcast and new media. It forms a data hub for more than 5,750 record companies and 45,000 performers in the UK. The PPL repertoire database contains more than 4 million recordings, which grows weekly by an average of 6,500 new recordings submitted electronically. In addition, through its 48 contracts with similar organizations around the world, it interacts with an additional 4,000 record companies and 21,000 performers that use many different languages and formats.

It was essential for us to develop a platform that integrates well with our existing systems and that makes it easy to manage, configure and customize for the future. The platform we now have in place provides an advanced way to store our mission-critical information and manage our business.

Peter Leathem
Executive Director

The challenge

The amount of royalties PPL remits each year is increasing in response to a growing member community, an increase in material to license and an expanding number of delivery mechanisms via social media outlets. To correctly assign and complete payments, PPL must start with accurate and standardized data on its network of members.

The solution

Historically, PPL built its own data management tools in-house. However, to keep pace with the continued expansion of the market, PPL turned to the technology of SAS and the strategic consulting of Deloitte to build a master data management (MDM) architecture that would provide the long-term infrastructure to meet the growing needs of its constituents.

Initially, PPL implemented an enterprisewide data quality program to profile, cleanse and align the data it managed. SAS technology generated easy-to-understand dashboards that helped staff measure the quality of the data against PPL's business rules. These rules enabled PPL to standardize key text fields (such as title and main artist), tailoring the dictionary to the specific needs of the music industry. This standardization streamlined PPL's ability to cluster and resolve duplicate data – an important requirement for PPL, since the same recordings are often legitimately submitted from many sources. Also, a series of "trust rules" enabled the creation of "golden recordings," blending the best information from each source to create a master data store.

After integrating the data management system into the new PPL database, the company had a data quality "gateway" to guard against poor-quality data. The overall architecture is groundbreaking for this industry, managing both original and master versions of all data received, as well as identifying complex relationships between recordings, rights holders, performers and related stakeholders.

The results

The initiative took nine months from vendor selection to project completion. The teams from Deloitte and SAS worked closely with the IT team at PPL to develop an MDM architecture designed to increase the frequency and accuracy of payments made by PPL.

"It was essential for us to develop a platform that integrates well with our existing systems and that makes it easy to manage, configure and customize for the future," says Peter Leathem, Executive Director at PPL. "The platform we now have in place provides an advanced way to store our mission-critical information and manage our business."

Challenge

Verify and validate millions of data records from multiple sources.

Solution

SAS® Data Management

Benefits

PPL used SAS Data Management to validate, standardize, cluster and integrate data on more than 6.5 million recordings, including a major migration and complete catalogue resubmissions of eight major record companies' entire UK databases. Each transaction can now be accurately traced through its life cycle.

The results illustrated in this article are specific to the particular situations, business models, data input, and computing environments described herein. Each SAS customer’s experience is unique based on business and technical variables and all statements must be considered non-typical. Actual savings, results, and performance characteristics will vary depending on individual customer configurations and conditions. SAS does not guarantee or represent that every customer will achieve similar results. The only warranties for SAS products and services are those that are set forth in the express warranty statements in the written agreement for such products and services. Nothing herein should be construed as constituting an additional warranty. Customers have shared their successes with SAS as part of an agreed-upon contractual exchange or project success summarization following a successful implementation of SAS software. Brand and product names are trademarks of their respective companies.

Back to Top