Specifying indexes for relational databases
CA 2240155 C · Owner: British Telecommunications Public Limited Company · Inventors: Lenzie, Robert Stephen
Overview
Its claims, description and drawings are in the Canadian Patents Database.
Open the CIPO recordAbstract From the Canadian patent
An index set for a database is specified by analysing a sample (718) of SQL statements applied to the database (701) . Indexes (707) are identified. that could assist in the execution of the analysed statements and levels of improved operation are evaluated for each of said indexes. The evaluated levels are then processed (708) to specify an index set for inclusion on the database. The database may not include sufficient storage (702) for all of the specified indexes to be, included, therefore the available storage space is allocated and indexes are selected on a prioritized basis.
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 December 16, 1996 and granted February 5, 2002. A Canadian patent filed from October 1, 1989 lasts 20 years from filing, so its term ended December 16, 2016.
- A certificate of supplementary protection adds at most two years for a drug, so even that would have ended by December 16, 2018.
- 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.