Patent Yard Sign in
Canadian application, no grantCanada

Method of facilitating database access

CA 2451076 A1 · Owner: Hsu, Joy · Inventors: Hsu, Joy; Shringeri, Sanjatha

CIPO record

Overview

Drawings and full text

Its claims, description and drawings are in the Canadian Patents Database.

Open the CIPO record

Abstract From the Canadian patent

A method of optimizing ranking queries in analytic applications. The method involves dividing a ranking query constructed by a user into multiplesubcommands. These sub-commands are based on the relationship between the foreign key and raking attributes of a table of data and are run as a batch of commands. As usable data is extracted from each sub-command it is stored and , the foreign key is used as a filter for the next query in the batch. This eliminates accessing irrelevant data and facilitates the query operation. The extracted data is joined as the last step of the process in order to minimize the number of join operations performed by the query while the batch is being …

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 June 18, 2002. No grant is recorded for it in Canada; had it been granted, its 20-year term would have ended June 18, 2022.
  • A certificate of supplementary protection adds at most two years for a drug, so even that would have ended by June 18, 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.
FiledJune 18, 2002
GrantedNo grant recorded
Term endedJune 18, 2022
Patent numberCA 2451076 A1
Classification (IPC)—

Timeline

Timeline From CIPO dates

2003200520072009201120132015201720192021Application filedJune 18, 2002Term endedJune 18, 2022

Sources & verification

Everything on this page comes from the CIPO record linked above. Contains information licensed under the Open Government Licence – Canada.