公开(公告)号：US11409741B2

公开(公告)日：2022-08-09

申请号：US15993438

申请日：2018-05-30

Applicant: Oracle International Corporation

Inventor： Beda Christoph Hammerschmidt ,  Zhen Hua Liu ,  Vikas Arora ,  Prakashkumar Thiagarajan ,  Douglas James McMahon

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/80 ,  G06F16/25

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.