Database predicate constraints on structured query language statements
US8214382B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 25, 2008 |
| Grant date | Jul 3, 2012 |
| Priority date | — |
| Expiry date | Feb 10, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/245
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method of enforcing database predicate constraints on database accesses is provided. The method comprises receiving a database query, parsing the query based on constraints defined in system tables, and examining the query for the existence of a where clause. The method also comprises examining the where clause to determine compliance with the constraints defined in the system tables and executing the query only when the query contains a where clause and the where clause complies with the constraints defined in the system tables. The method also comprises rejecting the query when the query one of does not contain a where clause and does contain a where clause and the where clause does not comply with the constraints defined in the system tables.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.