Data Science Solutions
Horeca
- By bs23net
- Time 9:29 am
- Date October 27, 2023
Introduction
Horeca is a B2B data profile management company that offers a platform for users to search and communicate with business professionals in their specific domains. With the need to manage a vast amount of records and optimize search capabilities, Horeca faced several challenges.
Highlights
- Supercharged Search: From 3000 RU to just 34 RU (Request Units)
- All your business data, 200 times faster
Challenge
- Client Data Access Criticality: Sensitive client data required secure and efficient access.
- Volume of Records: Horeca had to manage around 50 million records.
- Search Optimization Issues: The search function was not as quick or efficient as needed.
- Full-Text Search Capability: The application required a powerful full-text search feature.
- Cost Concerns: Azure cognitive search solutions were too expensive for the client.
Solution
To tackle these challenges, several strategies were implemented:
- Mass Scale Data Generation with Dotnet Cosmos DB App: This allowed for better management of the 50 million records.
- Simulated the Search Problem in Azure Cosmos DB: By doing this, we could identify and resolve the existing search issues.
- Custom Index with Word Parameters: This improved the search function.
- Stemming and Generalization of Words: This made the search feature more flexible and accurate.
Benefit
- All Data in One Place: Centralized data made it easier to manage and access.
- Optimized Data Processing: Data processing speed was increased by up to 200 times.
Result
The implementation of these solutions brought about impressive results:
- Reduced Resource Utilization: Initially, the average SQL-like query consumed 3000 Request Units (RU). With the new improvements, the main search required only 34 RU, and an additional 1000 RU was needed for data aggregation.
By focusing on efficient data management and search optimization, Horeca was able to improve its application significantly. Not only did this reduce operational costs, but it also led to faster and more accurate search capabilities, thereby enhancing user satisfaction.
Services We Provide
Brain Station 23 is focused on delivering tailored services to meet the unique needs and expectations of their clients. Here we provided Data Science Solutions to our client.