Horeca is a B2B data profile management company. Through this application, users are able to search, and communicate to business professionals’ profiles related to their business domains
Challenges
Client data access criticality
50 million records to manage
Search optimization issue
Full-text search capability providing
Azure cognitive search was too much costly for the client
Solution
- Mass scale data generation with Dotnet cosmos DB app
- Simulate the search problem in azure cosmos DB
- Custom index with word parameters
- Stemming and generalization of words
Impact
Average SQL-like query took 3000RU with our improvement it took only 34 RU for the main search and for data aggregation additional 1000RU was required. (RU->Request Unit)
Fetures
- All Data in one place
- Optimize data processing up to 200X faster
Technology
- Microsoft SQL Server