CONFIGURING CHECK CONSTRAINT AND ROW VIOLATION LOGGING USING ERROR TABLES
Number of patents in Portfolio can not be more than 2000
United States of America
Stats
-
N/A
Issued Date -
Feb 20, 2025
app pub date -
Aug 17, 2023
filing date -
Aug 17, 2023
priority date (Note) -
Published
status (Latency Note)
Importance
Abstract
Provided herein are systems and methods for configuring integrity constraints (including a check constraint) and row violation logging using error tables. An example method includes decoding a query received at a network-based database system. The query includes a command to perform an operation on a base table. An integrity constraint associated with the base table is retrieved. The integrity constraint specifies a desired configuration for the base table. A verification of the integrity constraint is performed to detect erroneous data of the base table that violates the desired configuration. The erroneous data is input into an error table that is configured as a nested object of the base table. A notification that the erroneous data is available in the error table is generated and output.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully