×

QUERY AND EXADATA SUPPORT FOR HYBRID COLUMNAR COMPRESSED DATA

  • US 20150032763A1
  • Filed: 09/08/2014
  • Published: 01/29/2015
  • Est. Priority Date: 11/12/2009
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • a storage system storing rows of database tables in a plurality of data blocks in non-volatile storage, each data block of said plurality of data blocks storing one or more columns of one or more rows of a database table of said database tables, said database tables being managed by a DBMS configured to return data from said database tables in response to database queries issued to the DBMS by clients of the DBMS;

    wherein said storage system is configured to;

    return, in entirety, requested data blocks to said DBMS in response to a request made by the DBMS that identifies the requested data blocks; and

    return, to said DBMS, rows that satisfy one or more column criteria in response to a request made the DBMS that identifies data blocks to filter according to the one or more column criteria;

    said storage system receiving a particular request for particular data blocks filtered according to particular one or more column criteria, said particular request identifying said particular data blocks and said one or more column criteria;

    in response to receiving said particular request for the particular data blocks;

    scanning said particular data blocks for particular rows having column values that satisfy said particular one or more criteria;

    storing in a return buffer the particular rows having column values that satisfy said particular one or more criteria; and

    returning the particular rows stored in said return buffer to said DBMS.

View all claims
  • 0 Assignments
Timeline View
Assignment View
    ×
    ×