Development of Product Information Management Software for a College Search Website

Development of Product Information Management Software for a College Search Website

Industry
Education
Technologies
AWS, MySQL, PHP

Customer

The Customer is a company that provides a centralized database of US college profiles, admission details, scholarships, etc. It helps bringing students and colleges together, so that students could compare college offerings and find the most suitable options for them.

Challenge

The Customer didn’t have a centralized system for storing and managing data about colleges. They received college data from colleges in various formats and processed it in Excel to unify before uploading to the database. So, the Customer wanted a product information management solution that would support data export from external sources and import of file formats compatible with Excel, such as .csv and .xlsx. A large data storage, flexibility for integrating with third-party software and automated reporting were also required. What’s more, the solution was to handle the load of at least 100 concurrent users.

Solution

After carefully analyzing the Customer’s needs, ScienceSoft’s team started implementing a product information management (PIM) solution in the cloud. Our team deployed the PIM solution in Amazon Web Services (AWS).

The project took 3 months. Our team started the work with implementing a data model that supported storing entities with an overall number of attributes of around 1,000. This was needed to allow the PIM solution to store large amounts of data.

To fulfill the Customer’s requirement on the solution’s ability to handle the load of 100 concurrent users, ScienceSoft’s specialists carried out testing of the solution under load and decided on its optimal configuration based on the testing results.

Besides, our team enabled the PIM solution to support data exchange in Excel-supported file formats and automated reporting on the collected college data. Also, the team made possible the integration of the PIM solution with third-party software like catalog or content management solutions by using RESTful API.

Results

The PIM solution deployed in AWS enabled the Customer to arrange the centralized storing and effective managing of college data received from many sources and in various formats. The solution was in line with the Customer’s storage and load requirements. Also, the product information management solution was integration-friendly.

Technologies and Tools

Linux, Nginx, PHP, MySQL, Docker, PHPUnit, git.

Need help with a similar project?

Drop us a line, and our rep will contact you within 30 minutes to arrange an initial discussion.

MORE CASE STUDIES