The Data normalization service plugin is a must when you want to keep your core_company table clean. It directs the CMDB to a single source of truth but not only that it will narrow the number of companies/manufacturers/publishers to a single entry in your dropdown lists for many applications in SAM, HAM and even in ITSM.