如果我想在记录数据库中查找前5个最相似的记录，使用什么样的Azure服务比较好？

zbdgwd5y  于 2022-11-17  发布在  其他
关注(0)|答案(2)|浏览(144)

我在Cosmos DB中有一个记录数据库。我想编写一些东西，允许我在给定一个特定记录（假设它有一个描述）的情况下，找到与该特定记录描述最相似的前5个记录。要完成此任务，最好的Azure服务是什么？
我研究了文本分析，但它似乎没有我需要的功能。也许我错了，欢迎任何建议！

Azure

2条答案

按热度按时间
knsnq2tg

knsnq2tg1#

我从未使用过Cosmos DB，但Microsoft文档应该可以帮助您入门https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/powerbi-visualize

赞(0）分享  回复(0）举报  2022-11-17
wfauudbj

wfauudbj2#

1.使用Azure认知搜索服务，您可以检索具有相似描述或包含特定单词的前5个记录。
1.我在cosmos DB中有一个表，其中的数据如下所示，

  1. [
  2.   {
  3.      "id": "1",
  4.     "category": "personal",
  5.     "name": "groceries",
  6.    "description": "Pick up apples and strawberries.",
  7.    "isComplete": false,
  8.   "_rid": "Le4RAMNCjb4BAAAAAAAAAA==",
  9. "_self":"dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4BAAAAAAAAAA==/",
  10. "_etag": "\"00000ab3-0000-0700-0000-636393880000\"",
  11. "_attachments": "attachments/",
  12. "_ts": 1667470216
  13.    },
  14. {
  15. "id": "2",
  16. "category": "social",
  17. "name": "activity",
  18. "description": "social activity statu",
  19. "isComplete": false,
  20. "_rid": "Le4RAMNCjb4CAAAAAAAAAA==",
  21. "_self": "dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4CAAAAAAAAAA==/",
  22. "_etag": "\"00000bb3-0000-0700-0000-6363943e0000\"",
  23. "_attachments": "attachments/",
  24. "_ts": 1667470398
  25.    },
  26. {
  27. "id": "3",
  28. "category": "personal",
  29. "name": "rent",
  30. "description": "transfer rent and pick up apples ",
  31. "isComplete": false,
  32. "_rid": "Le4RAMNCjb4DAAAAAAAAAA==",
  33. "_self": "dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4DAAAAAAAAAA==/",
  34. "_etag": "\"00000cb3-0000-0700-0000-636394b70000\"",
  35. "_attachments": "attachments/",
  36. "_ts": 1667470519
  37.  },
  38. {
  39.   "id": "4",
  40. "category": "professional",
  41. "name": "activity",
  42. "description": "Pot luck activity. Bring apples and snacks",
  43. "isComplete": false,
  44. "_rid": "Le4RAMNCjb4EAAAAAAAAAA==",
  45. "_self": "dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4EAAAAAAAAAA==/",
  46. "_etag": "\"000012b3-0000-0700-0000-636395890000\"",
  47. "_attachments": "attachments/",
  48. "_ts": 1667470729
  49. },
  50.  {
  51. "id": "5",
  52. "category": "personal",
  53. "name": "Diet",
  54. "description": "It is suggested to add apples in your diet",
  55. "isComplete": false,
  56. "_rid": "Le4RAMNCjb4FAAAAAAAAAA==",
  57. "_self": "dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4FAAAAAAAAAA==/",
  58. "_etag": "\"000013b3-0000-0700-0000-636395d00000\"",
  59. "_attachments": "attachments/",
  60. "_ts": 1667470800
  61. },
  62. {
  63. "id": "6",
  64. "category": "personal",
  65. "name": "Snacks",
  66. "description": "Fruit salad including apples, grapes, banana and mango",
  67. "isComplete": false,
  68. "_rid": "Le4RAMNCjb4GAAAAAAAAAA==",
  69. "_self": "dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4GAAAAAAAAAA==/",
  70. "_etag": "\"00001eb3-0000-0700-0000-6363961e0000\"",
  71. "_attachments": "attachments/",
  72. "_ts": 1667470878
  73. },
  74. {
  75. "id": "7",
  76. "category": "personal",
  77. "name": "groceries",
  78. "description": "bring apples and oats.",
  79. "isComplete": false,
  80. "_rid": "Le4RAMNCjb4HAAAAAAAAAA==",
  81. "_self": "dbs/Le4RAA==/colls/Le4RAMNCjb4=/docs/Le4RAMNCjb4HAAAAAAAAAA==/",
  82. "_etag": "\"00002bb3-0000-0700-0000-636399c80000\"",
  83. "_attachments": "attachments/",
  84. "_ts": 1667471816
  85.  }
  86.   ]

1.该表具有名称为description的列。表中共有六条记录在description列中包含术语apples。
1.已创建搜索服务。

1.选择Azure cosmos DB作为数据源，创建索引并创建索引器。
数据来源


索引


索引器


6.使用Azure搜索资源管理器，给定如下查询词以仅获得包含词apples的前5个记录。
下面是上述查询的输出，

  1. {
  2. "@odata.context": "https://<searchservicename>.search.windows.net/indexes('cosmosdb-index')/$metadata#docs(*)",
  3. "value": [
  4. {
  5. "@search.score": 0.26742277,
  6. "id": "3",
  7. "category": "personal",
  8. "name": "rent",
  9. "description": "transfer rent and pick up apples ",
  10. "isComplete": false,
  11. "rid": "TGU0UkFNTkNqYjREQUFBQUFBQUFBQT090"
  12.   },
  13. {
  14. "@search.score": 0.25811607,
  15. "id": "6",
  16. "category": "personal",
  17. "name": "Snacks",
  18. "description": "Fruit salad including apples, grapes, banana and mango",
  19. "isComplete": false,
  20. "rid": "TGU0UkFNTkNqYjRHQUFBQUFBQUFBQT090"
  21.  },
  22. {
  23. "@search.score": 0.20521776,
  24. "id": "7",
  25. "category": "personal",
  26. "name": "groceries",
  27. "description": "bring apples and oats.",
  28. "isComplete": false,
  29. "rid": "TGU0UkFNTkNqYjRIQUFBQUFBQUFBQT090"
  30.  },
  31. {
  32. "@search.score": 0.2034302,
  33. "id": "1",
  34. "category": "personal",
  35. "name": "groceries",
  36. "description": "Pick up apples and strawberries.",
  37. "isComplete": false,
  38. "rid": "TGU0UkFNTkNqYjRCQUFBQUFBQUFBQT090"
  39. },
  40. {
  41. "@search.score": 0.16281115,
  42. "id": "4",
  43. "category": "professional",
  44. "name": "activity",
  45. "description": "Pot luck activity. Bring apples and snacks",
  46. "isComplete": false,
  47. "rid": "TGU0UkFNTkNqYjRFQUFBQUFBQUFBQT090"
  48.      }
  49.   ]
  50. }

**参考：**learn.microsoft.com/en-us/azure/cosmos-db/nosql/quickstart-portal#add-data-to-your-database

展开查看全部
赞(0）分享  回复(0）举报  2022-11-17
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com