Database join disambiguation by grouping
CA 2371731 A1 · Owner: Potter, Charles Mike · Inventors: Seeds, Glen Michael; Potter, Charles Mike; Cazemier, Henk
Overview
Its claims, description and drawings are in the Canadian Patents Database.
Open the CIPO recordAbstract From the Canadian patent
The invention provides a means of disambiguation that is rule-driven. The user is relieved of understanding the details of how the disambiguation is being done. In some cases two tables can be joined by more than one association or criteria on the row values of selected columns to produce what, is effectively a wider table and this may result in an ambiguity of which join, should be used. The system described in this invention makes use of rules such that the user is not faced with a decision as to which rule to use but rather system makes the choice based on clear transformation rules which relate to folders or groups of the tables and their associations
Read the whole patent
Listed from its CIPO record in Patent Yard's archive of Canadian patents past their term. Its claims, description and drawings are in the CIPO record and on Google Patents, and the Claude kit works from them.
Why it's free to use
- Filed February 12, 2002. No grant is recorded for it in Canada; had it been granted, its 20-year term would have ended February 12, 2022.
- A certificate of supplementary protection adds at most two years for a drug, so even that would have ended by February 12, 2024.
- We check Canadian rights only. A patent in its family in another country could still be in force: check its family on Google Patents.
Timeline
Timeline From CIPO dates
Sources & verification
Official CIPO records
Everything on this page comes from the CIPO record linked above. Contains information licensed under the Open Government Licence – Canada.