Navigating the complexities of metadata management in the media industry