Can the above produce dynamic minimal wheels as I described it in this thread? I doubt. Constructing dynamic wheels/coverings requires advanced mathematics and quite tuned and sophisticated algorithms to contain all the various and conflicting properties (single coverage, multiple coverage, filters etc) in one robust and compact wheel. Neither of these are supported by any means in DB applications. Filtering? Ok, but this doesn't construct dynamic coverings, at least by the means I describe them here and all the benefits they carry. If however, by any chance, you managed something so special using just SQL and ASP, you are nominated for the Nobel prize in computing and I'd like a description of what you did. Just to get you started, how do you construct with SQL and ASP a minimal close-covering, without any other restrictions?
Remember, the term dynamic minimal wheel, is a wheel which:
1) holds true for all the applied filters in all of its tickets to the maximum possible extend (not always possible to achieve that)
2) and additionally, it does have maximized (or close to maximum) single (or multiple - more complicated) coverage for the amount of tickets we want to construct, which is also affected negatively by the filters in 1). So we additionally aim to minimize the negative impact of additional restrictions applied in 1) above.
Its not a dynamic wheel, if it justs happens to qualify only in the case 1) above (actually its not even a minimal wheel if it doesn't carry the main property of maximum coverage in the simplest case). It's neither a dynamic wheel if it just qualifies for the 2) above.
Just consider the fact that constucting a wheel which only aims to offer maximum coverage in the simplest case (no filters or other restrictions), is an NP-hard problem (besides some exceptions of covering theory which can construct minimal ones). Now imagine, how much more difficult is to introduce restrictions and try to maintain the coverage and qualify to all the other restrictions.
Right now, I do not talk about various other wheel constructions such as grouped/Serotic wheels. These wheels fail to the condition 2) above.
lottoarchitect