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:
Aug. 22, 2000
Filed:
Jul. 18, 1997
Seetha M Lakshmi, Cupertino, CA (US);
Shaoyu Zhou, Mountain View, CA (US);
Informix Software, Inc., Menlo Park, CA (US);
Abstract
A computer operated apparatus estimates values needed by an optimizer in a database management system (DBMS). The DBMS has one or more tables for storing data, each table having zero or more columns of user-definable data types and zero or more associated user-defined routines (UDRs). The apparatus has a feature vector extractor connected to the database tables for converting the UDR inputs into a base type representation. A neural network receives the feature vector and generates estimated values which are provided to the optimizer of the DBMS. The neural network can be trained periodically using randomly generated queries, or it can be trained dynamically by capturing data generated during a query. During operation, the optimizer dynamically invokes the neural network to generate estimates such as selectivity and cost per call for determining optimum query search sequence.