Case Study: Ingredient Database
Businesses need a competitive advantage.
Our custom software solutions can give you that edge.
Ingredient Monograph Database for Scientific and Regulatory Reporting
Client: A Global Nutritional Supplement Company
The Business Challenge
With large, world-wide sales of nutritional supplement products, our client carries a significant amount of social responsibility. Their requirement is to carefully research and report on all the ingredients that are used in each product. A team of scientists create ingredient monographs that are used for scientific and regulatory reporting purposes by researching and combining information from a variety of internal and online sources.
The Solution
Engroove developed a web application and database system to automate the process of aggregating ingredient monograph data and generating reports. A Windows Communication Foundation (WCF) Windows service downloads and parses live data on-demand from online sources using a sophisticated regular expressions engine. The data is then automatically validated against business rules before being consolidated into reporting views via user-configurable mappings. This level of automation saves each scientist hours of researching time per report. The web application allows users to edit each field to further refine the report before exporting the report, ready-for-distribution, to the most popular file formats including, Word, Excel, PDF, Text, and XML.
To meet the security and auditing requirements of our client's large scale enterprise environement, the database application was designed to support and log all actions of three user roles: administrator, contributor, and viewer. An proprietary incremental data storage architecture provides snapshots of the data at any point in time, allowing for full data rollbacks and the complete ability to audit all user changes to the database.
Key Features
- Web 2.0 User Interface
- Temporal Database Architecture
- Lucene Full-Text Indexing
- Role-Based Authentication / Authorization
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.