Patents Represented by Attorney, Agent or Law Firm Marcel Bingham
  • Rewriting queries to access materialized views that group along an ordered dimension
    Patent number: 6345272
    Abstract: A method and apparatus are provided for rewriting aggregate queries to access a materialized view when (1) the queries place a restriction on an ordered dimension, (2) the materialized view aggregates the information referenced in the query and groups by the same dimension, and (3) the materialized view groups the information at a coarser level of granularity than the granularity associated with the restriction contained in the aggregate queries.
    Type: Grant
    Filed: July 27, 1999
    Date of Patent: February 5, 2002
    Assignee: Oracle Corporation
    Inventors: Andrew Witkowski, Randall Bello, Mohamed Ziauddin