Patent US6438552B1 successfully refreshed from Google Patents.
US6438552B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
SQL-Based automated histogram bin data derivation assist
Assignee: Teradata US Inc
•
Filing: 1999-10-01
•
Granted: 2002-08-20
•
Expires: 2019-10-01
Abstract
Abstract A method, apparatus, and article of manufacture for performing data mining applications in a massively parallel relational database management system. A scalable data mining function comprising an automated histogram bin data derivation assist function is instantiated and parameterized via an analytic application programming interface (API). The automated histogram bin data derivation assist function comprises a query that is performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Inventors
- 👤 Brian Don Tate
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 21:45
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: 39
Claim 1
Independent Claim
126 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 an automated histogram bin data derivation assist function performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Claim 2
Dependent Claim
126 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 an automated histogram bin data derivation assist function performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Claim 3
Dependent Claim
19 words
The system of claim 1 , wherein the automated histogram bin data derivation assist function comprises a binning function.
Claim 4
Dependent Claim
74 words
The system of claim 1 , wherein the automated histogram bin data derivation assist function accepts one or more parameters selected from a group comprising: a name of a table in the relational database, a name of a numeric column in the table, a desired number of equal sized bins, a bin width, one or more boundary values with spacing, and a number of bins with nearly equal number of values in each bin.
Claim 5
Dependent Claim
35 words
The system of claim 3 , wherein a null value is assigned to a bin when boundary values are given and a value from the numeric column does not fit within any of the boundaries.
Claim 6
Dependent Claim
46 words
The system of claim 1 , wherein the computer comprises a parallel processing computer comprised of a plurality of nodes, and each node executes one or more threads of the relational database management system to provide parallelism in the automated histogram bin data derivation assist function.
Claim 7
Dependent Claim
32 words
The system of claim 1 , wherein the automated histogram bin data derivation assist function processes data stored in the relational database and produces results that are stored in the relational database.
Claim 8
Dependent Claim
25 words
The system of claim 1 , wherein the automated histogram bin data derivation assist function does not extract the data elements from the relational database.
Claim 9
Dependent Claim
32 words
The system of claim 1 , wherein results from the automated histogram bin data derivation assist function are saved in a table in an analytic logical data model in the relational database.
Claim 10
Dependent Claim
24 words
The system of claim 1 , wherein the automated histogram bin data derivation assist function is created by parameterizing and instantiating the analytic API.
Claim 11
Dependent Claim
28 words
The system of claim 1 , wherein the automated histogram bin data derivation assist function comprises at least one query for execution by the relational database management system.
Claim 12
Dependent Claim
36 words
The system of claim 10 , wherein the automated histogram bin data derivation assist function is a dynamically generated query comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API.
Claim 13
Dependent Claim
16 words
The system of claim 10 , wherein the query is a Structured Query Language (SQL) query.
Claim 14
Independent Claim
112 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 programming interface (API) in the computer to generate an automated histogram bin data derivation assist function that is performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Claim 15
Independent Claim
112 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 programming interface (API) in the computer to generate an automated histogram bin data derivation assist function that is performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Claim 16
Dependent Claim
119 words
An article of manufacture comprising logic embodying 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 programming interface (API) in the computer to generate an automated histogram bin data derivation assist function that is performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Claim 17
Dependent Claim
119 words
An article of manufacture comprising logic embodying 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 programming interface (API) in the computer to generate an automated histogram bin data derivation assist function that is performed directly within the relational database management system, wherein the automated histogram bin data derivation assist function derives a new data element in the relational database based on a relation of a particular value of another data element to that element's overall distribution in the relational database.
Claim 18
Dependent Claim
19 words
The method of claim 13 , wherein the automated histogram bin data derivation assist function comprises a binning function.
Claim 19
Dependent Claim
74 words
The method of claim 13 , wherein the automated histogram bin data derivation assist function accepts one or more parameters selected from a group comprising: a name of a table in the relational database, a name of a numeric column in the table, a desired number of equal sized bins, a bin width, one or more boundary values with spacing, and a number of bins with neatly equal number of values in each bin.
Claim 20
Dependent Claim
35 words
The method of claim 16 , wherein a null value is assigned to a bin when boundary values are given and a value from the numeric column does not fit within any of the boundaries.
Claim 21
Dependent Claim
46 words
The method of claim 13 , wherein the computer comprises a parallel processing computer comprised of a plurality of nodes, and each node executes one or more threads of the relational database management system to provide parallelism in the automated histogram bin data derivation assist function.
Claim 22
Dependent Claim
32 words
The method of claim 13 , wherein the automated histogram bin data derivation assist function processes data stored in the relational database and produces results that are stored in the relational database.
Claim 23
Dependent Claim
25 words
The method of claim 13 , wherein the automated histogram bin data derivation assist function does not extract the data elements from the relational database.
Claim 24
Dependent Claim
32 words
The method of claim 13 , wherein results from the automated histogram bin data derivation assist function are saved in a table in an analytic logical data model in the relational database.
Claim 25
Dependent Claim
24 words
The method of claim 13 , wherein the automated histogram bin data derivation assist function is created by parameterizing and instantiating the analytic API.
Claim 26
Dependent Claim
28 words
The method of claim 13 , wherein the automated histogram bin data derivation assist function comprises at least one query for execution by the relational database management system.
Claim 27
Dependent Claim
36 words
The method of claim 23 , wherein the automated histogram bin data derivation assist function is a dynamically generated query comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API.
Claim 28
Dependent Claim
16 words
The method of claim 23 , wherein the query is a Structured Query Language (SQL) query.
Claim 29
Dependent Claim
21 words
The article of manufacture of claim 14 , wherein the automated histogram bin data derivation assist function comprises a binning function.
Claim 30
Dependent Claim
76 words
The article of manufacture of claim 14 , wherein the automated histogram bin data derivation assist function accepts one or more parameters selected from a group comprising: a name of a table in the relational database, a name of a numeric column in the table, a desired number of equal sized bins, a bin width, one or more boundary values with spacing, and a number of bins with nearly equal number of values in each bin.
Claim 31
Dependent Claim
37 words
The article of manufacture of claim 27 , wherein a null value is assigned to a bin when boundary values are given and a value from the numeric column does not fit within any of the boundaries.
Claim 32
Dependent Claim
48 words
The article of manufacture of claim 14 , wherein the computer comprises a parallel processing computer comprised of a plurality of nodes, and each node executes one or more threads of the relational database management system to provide parallelism in the automated histogram bin data derivation assist function.
Claim 33
Dependent Claim
34 words
The article of manufacture of claim 14 , wherein the automated histogram bin data derivation assist function processes data stored in the relational database and produces results that are stored in the relational database.
Claim 34
Dependent Claim
27 words
The article of manufacture of claim 14 , wherein the automated histogram bin data derivation assist function does not extract the data elements from the relational database.
Claim 35
Dependent Claim
34 words
The article of manufacture of claim 14 , wherein results from the automated histogram bin data derivation assist function are saved in a table in an analytic logical data model in the relational database.
Claim 36
Dependent Claim
26 words
The article of manufacture of claim 14 , wherein the automated histogram bin data derivation assist function is created by parameterizing and instantiating the analytic API.
Claim 37
Dependent Claim
30 words
The article of manufacture of claim 14 , wherein the automated histogram bin data derivation assist function comprises at least one query for execution by the relational database management system.
Claim 38
Dependent Claim
38 words
The article of manufacture of claim 34 , wherein the automated histogram bin data derivation assist function is a dynamically generated query comprised of combined phrases with substituting values therein based on parameters supplied to the analytic API.
Claim 39
Dependent Claim
18 words
The article of manufacture of claim 34 , wherein the query is a Structured Query Language (SQL) query.
References Cited (Backward Citations)
US5448727A
Cited
US5412806A
Cited
US5590322A
Cited
US5701400A
Cited
US5799310A
Cited
US5734887A
Cited
US5710915A
Cited
US5806066A
Cited
US5787413A
Cited
US5787425A
Cited
US5822751A
Cited
US5960435A
Cited
US5895465A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-08-19 | 2006-02-18 | 2006-08-20 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-08-19 | 2010-02-18 | 2010-08-20 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-08-19 | 2014-02-18 | 2014-08-20 | $7700.00 | Window Closed / Lapsed |