US6421665B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
SQL-based data reduction techniques for delivering data to analytic tools
Assignee: Teradata US Inc
•
Filing: 1999-10-01
•
Granted: 2002-07-16
•
Expires: 2019-10-01
Abstract
Abstract A method, apparatus, and article of manufacture for performing data mining applications in a relational database management system executed by a massively parallel processing (MPP) computer system. An analytic application programming interface (API), executed by the computer, generates a data reduction function performed directly within the relational database management system. The data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Inventors
- 👤 Todd Michael Brye
- 👤 Brian Don Tate
- 👤 Anthony Lowell Rollins
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 15:35
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2458; G06F16/2462; G06F16/2453; G06F16/24532; G06F16/2465; G06F16/30; G06F16/33; G06F16/3331; G06F16/334; G06F16/3346; G06F2216/00; G06F2216/03; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/961; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934; Y10S707/99936; Y10S707/99941; Y10S707/99942; Y10S707/99943
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
141 words
A computer-implemented system for performing data mining applications, comprising: (a) a computer having one or more data storage devices connected thereto, wherein a relational database is stored on one or more of the data storage devices; (b) a relational database management system, executed by the computer, for accessing the relational database stored on the data storage devices; and (c) an analytic application programming interface (API), executed by the computer, that generates a data reduction function performed directly within the relational database management system, wherein the data reduction function comprises a dynamically generated query executed by the relational database management system that is comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API, and the data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Claim 2
Dependent Claim
141 words
A computer-implemented system for performing data mining applications, comprising: (a) a computer having one or more data storage devices connected thereto, wherein a relational database is stored on one or more of the data storage devices; (b) a relational database management system, executed by the computer, for accessing the relational database stored on the data storage devices; and (c) an analytic application programming interface (API), executed by the computer, that generates a data reduction function performed directly within the relational database management system, wherein the data reduction function comprises a dynamically generated query executed by the relational database management system that is comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API, and the data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Claim 3
Dependent Claim
42 words
The system of claim 1 , wherein the computer system is a massively parallel processing (MPP) computer system, and the data reduction function is decomposed into a plurality of steps that are executed concurrently in parallel by the relational database management system.
Claim 4
Dependent Claim
28 words
The system of claim 1 , wherein the data reduction function processes data stored in the relational database and produce results that are stored in the relational database.
Claim 5
Dependent Claim
20 words
The system of claim 1 , wherein the data reduction function is created by parameterizing and instantiating the analytic API.
Claim 6
Dependent Claim
66 words
The system of claim 1 , wherein the data reduction function is selected from a group comprising: (1) a data reduction function to build one or more data reduction matrices from a group comprising: (i) a Pearson-Product Moment Correlations matrix; (ii) a Covariance matrix; and (iii) a Sum of Squares and Cross Products (SSCP) matrix, and (2) a data reduction function to export a resultant matrix.
Claim 7
Dependent Claim
26 words
The system of claim 1 , wherein the data reduction function delivers the matrix to a statistical software program in order to perform multivariate statistical analysis.
Claim 8
Dependent Claim
26 words
The system of claim 1 , wherein the data reduction function builds a data reduction matrix directly in the relational database management system using SQL statements.
Claim 9
Dependent Claim
39 words
The system of claim 1 , wherein one or more numeric columns in at least one table in the relational database are reduced to an n-by-n matrix by the data reduction function, when there are n-columns in the table.
Claim 10
Independent Claim
127 words
A method for performing data mining applications, comprising: (a) storing a relational database on one or more data storage devices connected to a computer; (b) accessing the relational database stored on the data storage devices using a relational database management system; and (c) invoking an analytic application programing interface (API) in the computer, wherein the analytic API generates a data reduction function performed directly within the relational database management system, the data reduction function comprises a dynamically generated query executed by the relational database management system that is comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API, and the data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Claim 11
Independent Claim
127 words
A method for performing data mining applications, comprising: (a) storing a relational database on one or more data storage devices connected to a computer; (b) accessing the relational database stored on the data storage devices using a relational database management system; and (c) invoking an analytic application programing interface (API) in the computer, wherein the analytic API generates a data reduction function performed directly within the relational database management system, the data reduction function comprises a dynamically generated query executed by the relational database management system that is comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API, and the data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Claim 12
Dependent Claim
136 words
An article of manufacture comprising logic embodying a method for performing data mining applications, the method comprising: (a) storing a relational database on one or more data storage devices connected to a computer; b) accessing the relational database stored on the data storage devices using a relational database management system; and (c) invoking an analytic application programming interface (API) in the computer, wherein the analytic API generates a data reduction function performed directly within the relational database management system, the data reduction function comprises a dynamically generated query executed by the relational database management system that is comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API, and the data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Claim 13
Dependent Claim
136 words
An article of manufacture comprising logic embodying a method for performing data mining applications, the method comprising: (a) storing a relational database on one or more data storage devices connected to a computer; b) accessing the relational database stored on the data storage devices using a relational database management system; and (c) invoking an analytic application programming interface (API) in the computer, wherein the analytic API generates a data reduction function performed directly within the relational database management system, the data reduction function comprises a dynamically generated query executed by the relational database management system that is comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API, and the data reduction function builds at least one matrix within the relational database management system from data stored in the relational database.
Claim 14
Dependent Claim
45 words
The method of claim 9 , wherein the computer system is a massively parallel processing (MPP) computer system, and the method further comprises decomposing the data reduction function into a plurality of steps that are executed concurrently in parallel by the relational database management system.
Claim 15
Dependent Claim
28 words
The method of claim 9 , wherein the data reduction function processes data stored in the relational database and produce results that are stored in the relational database.
Claim 16
Dependent Claim
20 words
The method of claim 9 , wherein the data reduction function is created by parameterizing and instantiating the analytic API.
Claim 17
Dependent Claim
66 words
The method of claim 9 , wherein the data reduction function is selected from a group comprising: (1) a data reduction function to build one or more data reduction matrices from a group comprising: (i) a Pearson-Product Moment Correlations matrix; (ii) a Covariance matrix; and iii) a Sum of Squares and Cross Products (SSCP) matrix, and (2) a data reduction function to export a resultant matrix.
Claim 18
Dependent Claim
26 words
The method of claim 9 , wherein the data reduction function delivers the matrix to a statistical software program in order to perform multivariate statistical analysis.
Claim 19
Dependent Claim
26 words
The method of claim 9 , wherein the data reduction function builds a data reduction matrix directly in the relational database management system using SQL statements.
Claim 20
Dependent Claim
39 words
The method of claim 9 , wherein one or more numeric columns in at least one table in the relational database are reduced to an n-by-n matrix by the data reduction function, when there are n-columns in the table.
Claim 21
Dependent Claim
47 words
The article of manufacture of claim 10 , wherein the computer system is a massively parallel processing (MPP) computer system, and the method further comprises decomposing the data reduction function into a plurality of steps that are executed concurrently in parallel by the relational database management system.
Claim 22
Dependent Claim
30 words
The article of manufacture of claim 10 , wherein the data reduction function processes data stored in the relational database and produce results that are stored in the relational database.
Claim 23
Dependent Claim
22 words
The article of manufacture of claim 10 , wherein the data reduction function is created by parameterizing and instantiating the analytic API.
Claim 24
Dependent Claim
68 words
The article of manufacture of claim 10 , wherein the data reduction function is selected from a group comprising: (1) a data reduction function to build one or more data reduction matrices from a group comprising: (i) a Pearson-Product Moment Correlations matrix; (ii) a Covariance matrix; and (iii) a Sum of Squares and Cross Products (SSCP) matrix, and (2) a data reduction function to export a resultant matrix.
Claim 25
Dependent Claim
28 words
The article of manufacture of claim 10 , wherein the data reduction function delivers the matrix to a statistical software program in order to perform multivariate statistical analysis.
Claim 26
Dependent Claim
28 words
The article of manufacture of claim 10 , wherein the data reduction function builds a data reduction matrix directly in the relational database management system using SQL statements.
Claim 27
Dependent Claim
41 words
The article of manufacture of claim 10 , wherein one or more numeric columns in at least one table in the relational database are reduced to an n-by-n matrix by the data reduction function, when there are n-columns in the table.
References Cited (Backward Citations)
US5448727A
Cited
US5412806A
Cited
US5590322A
Cited
US5799310A
Cited
US5710915A
Cited
US5806066A
Cited
US5787413A
Cited
US5787425A
Cited
US6134555A
Cited
US5895465A
Cited
US6298342B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-07-15 | 2006-01-14 | 2006-07-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-07-15 | 2010-01-14 | 2010-07-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-07-15 | 2014-01-14 | 2014-07-16 | $7700.00 | Window Closed / Lapsed |