建模产品定价结构
我需要为我们的一些产品建立一个相当复杂的定价结构模型。
今天我们手动查找价格。这是一张图片，其中解释了我们今天使用的“矩阵”：示例模型（抱歉链接 - 但我不允许发布图像，因为我刚刚开设了帐户。）
现在我需要将此模型传输到 RDBMS 系统（SQL Server 2008 R2）。查找价格时的切入点是类别，然后是年度间隔，最后是取决于我们在此订单上销售的产品数量的间隔。查询的结果应该是两个价格。
您对如何建模有什么建议吗？我正在考虑将其建模为具有 RowNumber、CellNumber 和 CellValue 的矩阵。但随后我需要另一个表格来描述每个单元格中包含的内容（通过引用行和单元格编号）。如果这样做，我可以将价格包含在该描述表中。但这似乎不是最好的解决方案。
您对如何以最佳方式建模此问题有任何提示/解决方案吗？
I need to model a rather complex pricing structure for some of our products.
Today we lookup the prices manually. Here's a picture with explanations of the "matrix" that we use today: Sample model (sorry for the link - but I'm not allowed to post images because I've just opened my account.)
Now I need to transfer this model to a RDBMS system (SQL Server 2008 R2). The entry point when looking up a price is the Category, then the yearly interval and finally the interval depending on how many products we're selling on this order. The result of the query should be two prices.
Do you have any suggestions on how to model this? I was thinking of modeling it as a matrix with a RowNumber, CellNumber and a CellValue. But then I need another table for describing what is contained in each cell (by referencing the row and cell numbers). If doing that, I could just include the prices in that description table. But that doesn't seem like the best solution.
Do you have any hints/solutions on how to model this problem the best way?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我想我会做这样的事情：
类别被分成自己的表。
价格表中的每一行均由销售和发货范围的类别和起点唯一标识。我认为您不需要在表中指定终点（因为范围的终点应该是下一个范围的起点减一）。
编辑：使用此模型，您需要在价格表中为类别、销售数量间隔和发货数量间隔的每个组合添加一行，但现在我想不出更简单的方法。
I think I would make something like this:
Categories are separated into its own table.
Each row in the price table are uniquely identified by the category and starting point of the sold and shipped range. I don't think you would need to specify ending point in the table (since the end point of a range should be the starting point of the next range minus one).
Edit: With this model, you will need to add a row in the Prices table for each combination of category, units sold-interval and units shipped-interval, but right now I can't think of an easier way.