通过查询重新确定值的优先级 [英] Prioritization of values retured by queries

问题描述

嗨伙计，


不是真的在寻找代码或其他任何东西，只是朝着正确的方向研究。


我我将设计一个系统，它将获取与SQL Server CE表中的值相关的大量用户输入，如果有10个选项，并且他们选择其中3个，我想返回所有内容的列表具有任何这些值的表，但优先考虑那些最匹配的值。


我正在考虑添加与记录集匹配的所有记录，并可能创建某种形式的临时数组可以通过增加一个值（对于匹配的每个值增加）来排序？有谁知道这种事情的任何技术？或类似的帖子？我看了看但却找不到任何东西。


干杯！


PS - 我觉得我听起来很清楚，但如果没有问的话我，我会澄清一些事情。我还没有开始设计系统，所以我无法提供表信息等。

Hi Folks,

Not really looking for code or anything here, just a point in the right direction to research.

I am going to be designing a system that will take a bunch of user inputs related to values in SQL Server CE tables, and if there are 10 options, and they select 3 of them, I want to return a list of all the things in the table that have any of those values, but prioritise the ones that match the most.

I was thinking of adding all records that match to a recordset, and possibly creating some form of temp array which could be ordered by say an incremented value (that increases for each value that matches up)? Anyone know about any techniques for this sort of thing? or similar posts? I had a look but couldn''t find anything.

Cheers!

PS - I think i sound clear, but if not ask me and I''ll clarify stuff. I havent started designing the system yet, so i cant provide table info etc.

推荐答案

也许你可以创建一个函数来计算记录匹配的接近程度，然后在查询的计算列中使用它并按它排序。

Perhaps you could create a function which calculates the closeness of the match for a record, then use that in a calculated column of your query and sort by it.

也许你可以创建一个函数来计算它的接近度匹配记录，然后在查询的计算列中使用它并按其排序。

Perhaps you could create a function which calculates the closeness of the match for a record, then use that in a calculated column of your query and sort by it.

嗯...我不认为这会对此有用，因为输入有望全部是预先定义的，即列表框，复选框等。它是将成为一个使用SQLServerCE的PDA应用程序，我理想地想要生成具有类似于本网站的功能/界面用于花卉识别的东西

花卉鉴定网站


这只是产生一个与你投入的费用。显然，其中一些结果会比其他结果更多。


ie


对象a - 匹配characteristcs a，b，c

对象b - 匹配b，c

对象c - 匹配


所以如果你输入，特征a和b

对象c和a将是结果（网站的功能，以及我很乐意与我的项目合作的地方），但是对象是一个matche他们两个都是，因此应该更高的结果（在某个地方我真的应该用我的项目）


我的编程将在PDA上运行。目前我的MASSIVE（恐慌攻击终止）问题是连接到SLQ Server CE数据库并向其传递SQL查询以获得某种形式的输出。不幸的是，似乎没有人回应我在这里寻求帮助的任何请求，我会爱听一下在VB中用PDA设计运行数据库系统的人，并且愿意他们花了一些时间来回答我的一些问题。

Hmm... I dont think that would work with this, as the inputs will hopefully all be pre-defined, i.e. list boxes, check boxes etc. It is going to be a PDA app with SQLServerCE and I had ideally wanted to produce something with function/interface similar to this website for flower identification

Flower Identification Site

Which just produces a list of things that match the feilds you put in. And obviously some of those results will feature in more fields than the others.

i.e.

object a - matches characteristcs a,b,c
object b - matches b,c
object c - matches a

so if you put in, characteristics a and b

objects c and a will be results (the function of the website, and somewhere i would happily be with my project) , however object a matches them both, thus should be higher up the results (somewhere I would IDEALLY be with my project)

My prog would be running on the PDA. Currently my MASSIVE (panic attack enducing) issue is connecting to a SLQ Server CE database and passing an SQL query to it to have some form of output. Unfortunatly no one seems to be responding to any of my pleas for help here, I would love to hear from someone who has designed a system running with a database on a PDA in VB and who would be willing to spare some of their time to answer a few questions I have.

我想在最简单（也可能是最慢）的情况下你可以用你最初的想法。将找到的记录复制到临时表中，添加匹配百分比。您的代码计算的字段。然后返回，按百分比排序。


但我仍然认为功能想法可能会起作用。当我有一些时间（可能在午餐时间，几个小时内）时，我会在查询构建器中玩它。

I suppose at the simplest (and possibly slowest) levem you could go with your original idea. Copy the found records to a temp table, adding in a "match percentage" field calculated by your code. Then return that, sorted by the percentage.

But I still think that the function idea might be able to work. I''ll have a play with it in the query builder when I have some time (maybe at lunch time, in a few hours).

这篇关于通过查询重新确定值的优先级的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！