Patent · US Expired

Method, apparatus and system for screening database queries prior to submission to a database

US7058622B1 · kind B1 · utility

76Cited by
8References
153Claims
0Family size

Inventor

Key dates

Filing dateDec 26, 2001
Grant dateJun 6, 2006
Priority date
Expiry dateJul 13, 2022

Classification

  • Technology area (CPC Y)Emerging Cross-Sectional Technologies
  • CPC primaryY10S707/99939
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

To maintain the integrity and operability of enterprise database systems, queries intended for a particular database engine are intercepted, preferably by a separate processing system, prior to being acted upon by the database engine. The query is evaluated to determine its projected impact on available database system resources. The variables evaluated include user rights, administrator-imposed limits to searches, the amount of presently-available system resources, the cost of query and the like. If the query's potential impact does not surpass a predetermined threshold, it is submitted to the search engine. If the query is too resource-intensive or costly, the query may be (i) optimized by a query-optimization system, (ii) stored until more system resources are available, or (iii) rejected.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.