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:
Aug. 09, 2022
Filed:
May. 30, 2018
Oracle International Corporation, Redwood Shores, CA (US);
Beda Christoph Hammerschmidt, Los Gatos, CA (US);
Zhen Hua Liu, San Mateo, CA (US);
Vikas Arora, San Francisco, CA (US);
Prakashkumar Thiagarajan, San Jose, CA (US);
Douglas James McMahon, Redwood City, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Functionalities of new data types are enabled for data stored using native data types ('recognized data types') supported by DBMSs. Values having a latent data type may be stored using a recognized data type of a DBMS. That is, a value stored in a database table may be recognized by a DBMS as having a recognized data type (e.g., character string) but the value may also include information that indicates the value conforms to a particular latent data type. DBMSs compile database statements. The database statement can contain multiple expressions that may specify a latent data type or that may have a recognized data type but that also imply latent data types. By determining that various expressions have latent data types, operations that rely on the expressions as having a latent data type may be validated in a query and executed accordingly.