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:
Nov. 19, 2024
Filed:
Feb. 28, 2023
Oracle International Corporation, Redwood Shores, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Srikrishnan Suresh, Belmont, CA (US);
Beda Christoph Hammerschmidt, Palo Alto, CA (US);
Adrian Daniel Popescu, Zurich, CH;
Jesse Kamp, Castro Valley, CA (US);
Zhen Hua Liu, San Mateo, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A computer analyzes a relational schema of a database to generate a data entry schema and encodes the data entry schema as JSON. The data entry schema is sent to a database client so that the client can validate entered data before the entered data is sent for storage. From the client, entered data is received that conforms to the data entry schema because the client used the data entry schema to validate the entered data before sending the data. Into the database, the entered data is stored that conforms to the data entry schema. The data entry schema and the relational schema have corresponding constraints on a datum to be stored, such as a range limit for a database column or an express set of distinct valid values. A constraint may specify a format mask or regular expression that values in the column should conform to, or a correlation between values of multiple columns.