Elasticsearch ãæŽ»çšããã€ã³ããªãžã§ã³ã㪠B2B ãµãã©ã€ã€ãŒæ€çŽ¢ãšã³ãžã³
ãã³ããŒãã©ãããã©ãŒã ã¯ãæ°åã®åœéçãªãµãã©ã€ã€ãŒã«ãããè€éãªå€é¢çãªã¯ãšãªã1ç§æªæºã®å¿çæéã§åŠçã§ãã髿§èœãªæ€çŽ¢ãšã³ãžã³ãå¿ èŠãšããŠããŸããã
ãããžã§ã¯ããçžè«ãã
課é¡
åŸæ¥ã®ããŒã¿ããŒã¹ã¯ãšãªã§ã¯ãæ€çŽ¢èŠä»¶ãæºããããšãã§ããŸããã§ãã:
- SQL ã§ã¯ããã³ããŒããšã«80以äžã®ãã£ãŒã«ãã«ãããå šææ€çŽ¢ãé ãããŸãã
- åªå 床ã«åºã¥ãã©ã³ãã³ã°ã«ã¯ãããŒã¿ã®å®å šæ§ãšæ€èšŒãèæ ®ããå¿ èŠããããŸãã
- ãœãŒã·ã£ã«ã¡ãã£ã¢ã®ååšã¯ã第äžçŽã®å±æ§ãšããŠæ€çŽ¢å¯èœã§ããå¿ èŠããããŸãã
- ãã¡ãžãŒãããã³ã°ãšå ¥åãã¹ãžã®èš±å®¹ã¯ãåœéçãªãµãã©ã€ã€ãŒåã«ãšã£ãŠäžå¯æ¬ ã§ãã
- ã«ããŽãªãšå Žæã®éå±€ã«ã¯ããã¡ã»ããæ€çŽ¢æ©èœãå¿ èŠã§ãã
ç§ãã¡ã®ãœãªã¥ãŒã·ã§ã³
åœç€Ÿã¯ããã³ããŒçºèŠã®ããã«ãåªå 床ããŒã¹ã®ã€ã³ããã¯ã¹äœæãå€ãã£ãŒã«ãæ€çŽ¢ãã€ã³ããªãžã§ã³ããªã©ã³ãã³ã°ãåããã«ã¹ã¿ã Elasticsearch çµ±åãå®è£ ããŸããã
ã¢ãŒããã¯ãã£
- æ€çŽ¢ãšã³ãžã³: ãã³ããŒãã«ããŽãªããœãŒã·ã£ã«ã¡ãã£ã¢çšã®ã«ã¹ã¿ã ãããã³ã°ãåãã Elasticsearch
- ããŒã¿å±€: çã®æ å ±æºãšã㊠TypeORM/PostgreSQLãElasticsearch ã«åæ
- APIå±€: Elasticsearch ã¯ã©ã€ã¢ã³ããåãã Node.js/Express
- ããã³ããšã³ã: ãªã¢ã«ã¿ã€ã ã®ã¿ã€ãå ¥åæ€çŽ¢æ©èœãåãã React
- åæ: æ€çŽ¢è¡å远跡çšã® PostHog
æ€çŽ¢æ©èœ
- å€ãã£ãŒã«ãæ€çŽ¢ - ãã³ããŒåã説æããã©ã³ããã«ããŽãªãåæã«ã¯ãšãª
- ãœãŒã·ã£ã«ã¡ãã£ã¢ãã£ã«ã¿ãªã³ã° - ç¹å®ã®ãã©ãããã©ãŒã ã§ã®ååšã«åºã¥ããŠãã³ããŒãæ€çŽ¢
- ã«ããŽãªãã¡ã»ãã - 補åã«ããŽãªéå±€ãããªã«ããŠã³
- å Žæãã£ã«ã¿ãªã³ã° - åœãå°åããŸãã¯éœåžã§æ€çŽ¢
- åªå 床ã©ã³ãã³ã° - æ€èšŒæžã¿ã§ããŒã¿ãå®å šãªãã³ããŒãäžäœã«ã©ã³ã¯ä»ããããŸã
- ãã¡ãžãŒãããã³ã° - å ¥åãã¹ãåœéçãªååã®ããªãšãŒã·ã§ã³ãåŠç
äž»èŠæ©èœ
- ã«ã¹ã¿ã ã€ã³ããã¯ã¹ãããã³ã° - ãã³ããŒãã«ããŽãªããœãŒã·ã£ã«ã¡ãã£ã¢ããŒã¿åãã«æé©åãããã¹ããŒã
- ãªã¢ã«ã¿ã€ã åæ - ããŒã¿ããŒã¹ã®å€æŽãæ°ç§ä»¥å ã«æ€çŽ¢ã«åæ ãããŸã
- æ€çŽ¢åæ - 人æ°ã®ããã¯ãšãªãçµæããŒãã®æ€çŽ¢ãã¯ãªãã¯çã远跡
- äžæ¬ã€ã³ããã¯ã¹äœæ - å€§èŠæš¡ãªãã³ããŒã€ã³ããŒãã®ããã®å¹ççãªãããã€ã³ããã¯ã¹äœæ
- å éã¹ã³ã¢ãªã³ã° - ãã£ãŒã«ãã®éèŠåºŠã«åºã¥ããèšå®å¯èœãªé¢é£æ§ã¹ã³ã¢ãªã³ã°
ææ
æè¡ã¹ã¿ãã¯
caseStudyDetail.more ã±ãŒã¹ã¹ã¿ãã£
ãã®ä»ã®æè¡å®è£ äºäŸãã芧ãã ãã
AIãæŽ»çšãããã³ããŒçºèŠïŒãœãŒã·ã³ã°ãã©ãããã©ãŒã
Eã³ããŒã¹äŒæ¥ãèŒžå ¥æ¥è ã¯ãAlibabaã®ãããªB2BããŒã±ãããã¬ã€ã¹ãæäœæ¥ã§æ€çŽ¢ããããã»ã¹ã«ä»£ãããåœéçãªãµãã©ã€ã€ãŒãçºèŠãè©äŸ¡ã管çããããã®ã€ã³ããªãžã§ã³ããªãã©ãããã©ãŒã ãå¿ èŠãšããŠããŸããã
AIãæŽ»çšããOCRã«ããè«æ±æžåŠçãšQuickBooks飿º
æ¯ææ°çŸä»¶ã®ä»å ¥å è«æ±æžãåŠçããäžèŠæš¡äŒæ¥ããAI/OCRã䜿çšããŠè«æ±æžããŒã¿ãèªåæœåºãããããèšåž³ãšæ¯æè¿œè·¡ã®ããã«QuickBooksã«çŽæ¥åæãããããšã§ãæåããŒã¿å ¥åãæé€ããå¿ èŠããããŸããã
ãããã質å
MicrocosmWorks configured Elasticsearch with custom analyzers that combine edge n-gram tokenization for partial matching, synonym dictionaries for industry terminology, and a dedicated keyword field for exact part number lookups. This approach returns relevant suppliers even when buyers use different terminology than what appears in the supplier's catalog.
MicrocosmWorks designed the Elasticsearch cluster with a sharding strategy that distributes supplier documents across multiple nodes based on industry vertical, enabling horizontal scaling without reindexing. The architecture supports cross-cluster search for geographic distribution, maintaining sub-200ms query response times even at millions of supplier records.
Yes, MicrocosmWorks implemented function score queries that dynamically boost supplier rankings based on buyer-defined weights for proximity, MOQ fit, lead time, certification requirements, and past transaction history. Buyers can save their weighting profiles and apply them across searches for consistent sourcing preferences.
MicrocosmWorks built a change data capture pipeline using Debezium connected to the PostgreSQL source database, streaming supplier record changes to Elasticsearch in near real-time via Kafka. This ensures search results reflect database updates within seconds rather than waiting for batch reindex cycles.
MicrocosmWorks delivers Elasticsearch-powered search solutions at rates of $20-$45/hr, with a full B2B supplier search engine including custom analyzers, relevance tuning, faceted filtering, and CDC pipeline typically requiring 350-550 development hours. The Elasticsearch infrastructure itself runs cost-effectively on three-node clusters starting around $500/month on AWS.
ããžãã¹ã®å€é©ã®æºåã¯ã§ããŠããŸããïŒ
ã客æ§ã®èª²é¡ã«é¡äŒŒã®ãœãªã¥ãŒã·ã§ã³ãé©çšããæ¹æ³ã«ã€ããŠè©±ãåããŸãããã