MongoDB深入嵌入查询(MongoDB deep embeded query)

 我有这个文件 
 
item = {
"name": "string",
"promotions": [{
    "store_id": "key",
    "url": "string",
    "prices": [{
        "cc": "string",
        "price_regular_in_cent": "integer",
        "price_sale_in_cent": "integer",
        "percent": "integer"
             }]
         }]
     }
 
 我正在开发的一个模拟推广应用程序，用于学习NodeJS，MongoDB和Angular。 最高级别是商品信息的去处，促销是每个促销用于同一商品（每个商品可以在多个商店中），价格是每种支持货币的价格。 我创建了这个结构，因为我不想知道价格而不知道该项目，但我有一些过滤问题。 
 
 编辑：例如，如果我想过滤百分比> 50的数据库中的所有项目，我将如何在mongodb中执行此操作？ 性能是否最佳？ 
 
 我认为这个数据结构应该用SQL而不是NoSQL更好地实现，这是正确的吗？ 

I have this document
 
item = {
"name": "string",
"promotions": [{
    "store_id": "key",
    "url": "string",
    "prices": [{
        "cc": "string",
        "price_regular_in_cent": "integer",
        "price_sale_in_cent": "integer",
        "percent": "integer"
             }]
         }]
     }
 
for a demo promotion app that I'm developing to learn NodeJS, MongoDB and Angular. The top level is where the item information go, the promotions is there each promotion go for the same item (each item can be in multiple stores) and the prices is the price in each supported currency. I created this structure since I don't want to know the price without knowing the item but I have some problems with filtering.
 
Edit: For example if i wanted to filter all items in the db with percent >50 how would I do it in mongodb? And is the performance optimal?
 
And I'm thinking this data structure should be better implemented with SQL instead of NoSQL, is this correct?

原文：