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.
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.
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 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."
Verify and validate millions of data records from multiple sources.
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.