Case Study: Publishing Database
Businesses need a competitive advantage.
Our custom software solutions can give you that edge.
Publishing Clearance Database and Royalty Calculation Suite of Applications
Client: An Interactive Media Company
The Business Challenge
Our client is the largest broadband touchscreen media network in the United States, providing digital music to over 10,000 bars and nightclubs across the country. With over 300,000 tracks in their active catalog of music, obtaining and verifying the rights to publish music, and reporting to the content owners about their use and royalty obligations, are mission-critical activities.
Prior to partnering with Engroove, our client contracted with a third-party vendor to provide publishing clearance data and royalty reporting services. However, due to the lack of quality control of third-party supplied data, and because the vendor was not responsive to change requests, Ecast experienced difficulties effectively managing its publishing clearance and royalty reporting processes.
The Solution
Engroove worked with our client to bring the publishing clearance and royalty services in-house, by building a database and a suite of Windows and web applications to import, validate, navigate, and report on publishing data, provided from a myriad of external sources.
Music publishing data poses particular challenges to maintaining data integrity because of the many ways to refer to a particular person or song. For instance, the composer, "Michael Jackson", may be referred to as "M. Jackson", "Jackson, Michael", or simply "M.J.". Therefore, a business rules engine was designed to validate new data against existing data and support an efficient workflow to reconcile possible duplicates and data entry errors.
A Windows based application was developed around the business rules engine to import and validate publishing data from multiple sources, including Excel, PDF, Flat Files, and other proprietary formats. The data import application is designed to be easily extended to support new data formats as contracts are signed with new publishers.
An Ajax-based web application was developed to allow users to browse the publishing database for researching and updating music data, and to integrate with other internal databases such as the data warehouse.
A WPF reporting application was developed to automate the generation of royalty reports. The tool leveraged the dimensional aspects of the database to calculate publisher royalty adjustments for prior reporting periods and organized the related report outputs by publisher into zip files for distribution to all publishers.
Key Features
- Real-time dimensional database
- Service oriented architecture
- Sophisticated extensible validation rules engine
- Extensible import engine
- Web 2.0 User Interface
Technology
Languages and Platforms |
|
Servers |
|
Data Stores |
|
Other Tools |
|
Case Studies
- SharePoint GIS
- e-Commerce Website
- Ingredient Database
- NAV ERP Integration
- Publishing Database
- Digital Signage
- Data Loss Prevention
- BizTalk EAI Application
- Financial Software
- Point-Of-Sales Software
Testimonials
“ I'm not a technology-oriented person, so when I needed to hire a technology team I felt like I was taking a big risk. Engroove understood my needs and envisioned the solution immediately. I gave them non-technical directions and they inferred the rest through their experience and their passion for what they do. They were explicit in their deliverables and clear in their timeline. They created the perfect solution designed exactly to specification and delivered ahead of schedule. I felt like I received enterprise-level work at a start-up price. I recommend them without reservation. „
- Allen Lee, Entrepreneur
Who We Are
We are a Los Angeles, CA based Microsoft Gold Certified Partners specializing in developing custom software solutions.
What We Do
Our mission is to write custom software that exceeds your expectations and supports the way your business operates today, tomorrow, and in the years to come.
Case Studies
We provide clients with the highest quality custom software with the quickest turn-around times.
Our business model combines the best local talent with the agile methodology to maximize our responsiveness and flexibility to your specific requirements.
Support
We provide technical support at all stages of the Software Development Life Cycle (SDLC) and post-deployment. In addition, we offer free, hosted configuration management and issue tracking services for our clients.