Invention Grant
- Patent Title: Enabling data format specific database functionalities over existing data types by marking operand values
-
Application No.: US15993438Application Date: 2018-05-30
-
Publication No.: US11409741B2Publication Date: 2022-08-09
- Inventor: Beda Christoph Hammerschmidt , Zhen Hua Liu , Vikas Arora , Prakashkumar Thiagarajan , Douglas James McMahon
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/00
- 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.
Information query