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:
Oct. 20, 2020
Filed:
Jan. 03, 2018
Oracle International Corporation, Redwood Shores, CA (US);
Anantha Kiran Kandukuri, Zurich, CH;
Seema Sundara, Nashua, NH (US);
Sam Idicula, Santa Clara, CA (US);
Pit Fender, Union City, CA (US);
Nitin Kunal, Zurich, CH;
Sabina Petride, Tracy, CA (US);
Georgios Giannikis, Zurchi, CH;
Nipun Agarwal, Saratoga, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques related to distributed relational dictionaries are disclosed. In some embodiments, one or more non-transitory storage media store a sequence of instructions which, when executed by one or more computing devices, cause performance of a method. The method involves generating, by a query optimizer at a distributed database system (DDS), a query execution plan (QEP) for generating a code dictionary and a column of encoded database data. The QEP specifies a sequence of operations for generating the code dictionary. The code dictionary is a database table. The method further involves receiving, at the DDS, a column of unencoded database data from a data source that is external to the DDS. The DDS generates the code dictionary according to the QEP. Furthermore, based on joining the column of unencoded database data with the code dictionary, the DDS generates the column of encoded database data according to the QEP.