Database search system using interpolated data with defined resolution

• US 7,739,260 B1
• Filed: 12/28/2006
• Issued: 06/15/2010
• Est. Priority Date: 12/28/2006
• Status: Active Grant

• Current Assignee: Scientific Components Corporation
• Original Assignee: Scientific Components Corporation
• Inventors: Anati, Eitan, Kaylie, Harvey L.
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Nguyen; Kim T
• Application Number:
  US11/648,238
• Time in Patent Office: 1,265 Days
• Field of Search: 707/3, 707/4
• US Class Current: 707/706
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/2462 Approximate or statistical queries
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A database search system is disclosed that interpolates between actual data points to achieve a defined level of data resolution while populating a database with a mixture of actual and interpolated data. Users of the database system enter search requests that include a range of values to search through for at least one parameter. This range of values is tested against the interpolation resolution value and if the user-specified range of search would result in a higher resolution than the interpolation resolution value, the user-specified range of search is adjusted to match the defined level of data resolution. The database is then searched, and the presence of interpolated data generally offers significant improvement to the number of appropriate items found and provided as output to the user as at least one of tabular, graphical or other displayed form.

Claims

1. A database search system comprising:

a database configured for organized storage in a memory and retrieval of data from a memory;

a search engine in communication with said database;

an interpolation resolution value;

a data entry module for entering actual parametric data into said database;

a data analysis and interpolation module in communication with said data entry module and said database, said data entry and interpolation module configured for analyzing said actual parametric data, creating interpolated parametric data according to said interpolation resolution value, and entering said interpolated parametric data into said database;

a search query entry module;

a data resolution comparison module in communication with said search query entry module, said data resolution comparison module configured for determining whether said search query has a resolution greater than said interpolation resolution value;

a data resolution adjustment module in communication with said data resolution comparison module and said search engine, said data resolution adjustment module configured for adjusting the resolution of said search query to match said interpolation resolution value if said search query has a resolution greater than said interpolation resolution value;

said search engine configured to accept said search query and search said database; and

an output module in communication with said search engine, said output module configured for outputting said data as search results.

2. A database search system as described in claim 1, wherein at least a portion of said interpolated parametric data is created in response to said search query entry.

3. A database search system as described in claim 2, wherein at least a portion of said interpolated parametric data is stored only for the duration of said search query.

4. A database search system as described in claim 2, wherein said interpolation resolution value may be adjusted for at least a limited numerical range by the user performing the search.

5. A database search system as described in claim 4, wherein at least a portion of said interpolated parametric data is stored only for the duration of the search query.

6. A database search system as described in claim 5, wherein multiple data interpolation algorithms are used based on an automated analysis of curve-fitting needs and automated scaling of data.

7. A database search system as described in claim 5, wherein at least one predictive data processing algorithm is used to extrapolate data values beyond the bounds of the actual data set.

8. A database search system for parametric component data comprising:

a database configured for organized storage in a memory and retrieval of parametric component data from a memory,

a search engine in communication with said database;

said database further configured for organized storage and retrieval of a class of items consisting at least of descriptions of the components for which the parametric data is stored;

an interpolation resolution value;

a data entry module for entering actual parametric component data into said database;

a data analysis and interpolation module in communication with said data entry module and said database, said data analysis and interpolation module configured for analyzing said parametric component data, creating interpolated parametric component data according to said interpolation resolution value, and entering said interpolated parametric component data into said database;

a search query entry module;

a data resolution comparison module in communication with said search query entry module, said data resolution comparison module configured for determining whether said search query has a resolution greater than said interpolation resolution value;

a data resolution adjustment module in communication with said data resolution comparison module and said search engine, said data resolution adjustment module configured for adjusting the resolution of said search query to match said interpolation resolution value if said search query has a resolution greater than said interpolation resolution value;

said search engine configured to accept said search query and search said database; and

an output module in communication with said search engine, said output module configured for outputting as search results data from the group consisting of descriptions of the components, tabulated parametric component data and graphically displayed parametric component data.

9. A database search system for parametric component data as described in claim 8, wherein at least a portion of said interpolated parametric component data is created in response to said search query entry.

10. A database search system for parametric component data as described in claim 9, wherein at least a portion of said interpolated parametric component data is stored only for the duration of said search query.

11. A database search system for parametric component data as described in claim 9, wherein said interpolation resolution value may be adjusted for at least a limited numerical range by the user performing the search.

12. A database search system for parametric component data as described in claim 11, wherein at least a portion of said interpolated parametric component data is stored only for the duration of the search query.

13. A database search system for parametric component data as described in claim 8, wherein at least one data interpolation algorithm other than a generally linear interpolation algorithm is used.

14. A database search system for parametric component data as described in claim 13, wherein multiple data interpolation algorithms are used based on an automated analysis of curve-fitting needs and automated scaling of data.

15. A database search system for parametric component data as described in claim 13, wherein at least one predictive data processing algorithm is used to extrapolate data values beyond the bounds of the actual data set.