LOCKING MECHANISM USING A PREDEFINED LOCK FOR MATERIALIZED VIEWS IN ADATABASE SYSTEM
Patent №
US 7,149,737
Granted
2006-12-12
Filed 2002
Owner
NCR CORPORATION
Lab
—
AI components
1
planning
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
10117497
A database system includes a locking mechanism for a materialized view defined on base relations. In response to updates of a base relation, a predefined lock (e.g., Y lock or IY lock) is placed on the materialized view. With the locking mechanism, transaction concurrency is enhanced by enabling concurrent updates of a materialized view by plural transactions in certain cases.
AI classification
Planning0.99
AI hardware0.24
Machine learning0.02
Natural language0.02
Knowledge representation0.00
Evolutionary computation0.00
Vision0.00
Speech0.00
Ownership
NCR CORPORATION
assignment · 127800422
Assignors
LUO, GANG, WATZKE, MICHAEL W., ELLMANN, CURT J., NAUGHTON, JEFFREY F.
On an employer assignment, the assignors are typically the inventors.
From the same owner
SYNTHETIC BANKNOTE DATA GENERATION USING A GENERATIVE ADVERSARIAL NETWORK WITH SPATIALLY COMPOSITED MULTISPECTRAL DATAUS 12,450,968 · 2025METHOD FOR DETECTING MOUNTING OF AN OBJECT AT A TERMINAL DEVICEUS 12,039,395 · 2024ANTICIPATORY AND REMOTE-CONTROLLED MEDIA MANAGEMENTUS 11,880,817 · 2024HAND ACTION TRACKING FOR CARD SLOT TAMPERINGUS 11,881,088 · 2024MONITORING AND PREDICTING PHYSICAL FORCE ATTACKS ON TRANSACTION TERMINALSUS 11,881,089 · 2024FRICTIONLESS INQUIRY PROCESSINGUS 11,854,068 · 2023SELF-SERVICE TERMINAL (SST) ITEM RETURN ANTI-FRAUD PROCESSINGUS 11,836,735 · 2023INDOOR WAYFINDER INTERFACE AND SERVICEUS 11,828,600 · 2023