Project - Stock Service (microservice)
Summary
Provide multi-catalogue search functionality to applications, with data being refreshed quarterly each hour. Legacy VB6 applications must be supported in addition to modern .net applications. Search results must be returned within 1 second of search query being posted.
Stock service search page
Supplier invoicing process flow
Architecture
Service orientated architectural principles were adopted to provide SOAP and RESTful (to support legacy VB6 applications) endpoints in the presentation tier of a solution. Within the solution, n-tier architecture was employed, including domain, business logic and data access tiers. Data provided via the endpoints is retrieved firstly from a Lucene search index then from an MS SQL database. A secure web based user interface is utilised to test search queries. A Windows service runs a configurable intervals to refresh the search database from data sources downloaded via ftp.
Infrastructure
A dedicated Windows server providing IIS based service and api hosting and Microsoft SQL Server.
Project Role
Lead Developer (Storm Technologies)Technologies
- c#
- wcf (SOAP)
- wcf (RESTful)
- sql
- html
- css
- javascript
Methodologies
- agile