Managing expressions in a database system
CA 2484009 C · Owner: Srinivasan, Jagannathan · Inventors: Srinivasan, Jagannathan; Yalamanchi, Aravind; Gawlick, Dieter
Overview
Its claims, description and drawings are in the Canadian Patents Database.
Open the CIPO recordAbstract From the Canadian patent
Managing expressions includes receiving a first query that includes a conditional expression. The expression is then represented as data in a column of a table. A second query is received that specifies a first set of criteria and the second query is executed to select data based at least on whether expressions in the column satisfy the first set of criteria. In an embodiment the second query further specifies a second set of criteria wherein executing , the second query includes selecting data based on whether data in columns other than the expression column satisfy the second criteria. A special index is defined, which can be created on the column that stores the expressions to , …
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 May 8, 2003 and granted December 11, 2012. A Canadian patent filed from October 1, 1989 lasts 20 years from filing, so its term ended May 8, 2023.
- A certificate of supplementary protection adds at most two years for a drug, so even that would have ended by May 8, 2025.
- 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.