The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 20, 1999
Filed:
Aug. 29, 1997
Bruce P Szalwinski, Austin, TX (US);
Advanced Micro Devices, Inc., Austin, TX (US);
Abstract
The present invention discloses a system and method for identifying and retrieving data from a database in a computer system having at least two processors, a memory, and at least one non-volatile storage system and uses a query statement to identify data to be retrieved. The query predicates are classified into a first tier and a second tier, wherein the first tier query predicates relate to higher level data and the second tier query predicates relate to lower level data. The second tier query predicates are divided into two or more views of the lower level data. The first tier query predicates are applied against the higher level data to determine pointers to one or more particular views and the pointers are stored, for example, in a driving table. The second tier query predicates are applied against the particular views of the lower level data and the pointers and particular views of the lower level data are processed wherein data may be identified. The query statement, including the query predicates, is submitted identifying data to be retrieved. The data, as identified in the query statement, is retrieved from the lower level data based on the second tier query predicates and the pointers to the views of said lower level data. The pointers are stored, for example, in a driving table. The driving table and the particular views of the lower level data are processed, preferably, in parallel.