US6418450B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Data warehouse programs architecture
Assignee: Twitter Inc
•
Filing: 1999-01-07
•
Granted: 2002-07-09
•
Expires: 2019-01-07
Abstract
Abstract A method, apparatus, and article of manufacture for a data warehouse programs architecture. Data in a database stored on a data storage device is transformed. Initially, a program template is retrieved that contains parameters. A business view is invoked with the program template. Under control of the business view, a transformation program is invoked that transforms source data to generate target data using the parameters provided in the program template.
Inventors
- 👤 Jean-Jacques Paul Daudenarde
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 02:21
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; G06F16/25; G06F16/258; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 82
Claim 1
Independent Claim
117 words
A method of transforming data in a database stored on a data storage device, comprising: defining a program template containing default parameter values corresponding to parameters of a pre-existing transformation program; defining at least one business view having an association with the program template, said business view including scheduling information and a parameter string initialized to the default parameter values; creating at least one scheduled instance of operation of the transformation program by receiving selective modifications of the parameter string and the scheduling information of the at least one business view from the user; and invoking the at least one scheduled instance of operation of the transformation program under control of the at least one business view.
Claim 2
Independent Claim
117 words
A method of transforming data in a database stored on a data storage device, comprising: defining a program template containing default parameter values corresponding to parameters of a pre-existing transformation program; defining at least one business view having an association with the program template, said business view including scheduling information and a parameter string initialized to the default parameter values; creating at least one scheduled instance of operation of the transformation program by receiving selective modifications of the parameter string and the scheduling information of the at least one business view from the user; and invoking the at least one scheduled instance of operation of the transformation program under control of the at least one business view.
Claim 3
Dependent Claim
26 words
The method of claim 1 , wherein the program template contains tokens, which are replaced by system data at the time the transformation program is invoked.
Claim 4
Dependent Claim
13 words
The method of claim 1 , wherein the transformation program is a command.
Claim 5
Dependent Claim
13 words
The method of claim 1 , wherein the transformation program is a utility.
Claim 6
Dependent Claim
17 words
The method of claim 1 , wherein the business view is invoked based on a predefined schedule.
Claim 7
Dependent Claim
16 words
The method of claim 1 , wherein the program template comprises information about the transformation program.
Claim 8
Dependent Claim
15 words
The method of claim 1 , wherein the source is identified in the business view.
Claim 9
Dependent Claim
16 words
The method of claim 1 , wherein the transformation program is identified in the business view.
Claim 10
Dependent Claim
15 words
The method of claim 1 , wherein the target is identified in the business view.
Claim 11
Dependent Claim
15 words
The method of claim 1 , wherein the source is identified in the program template.
Claim 12
Dependent Claim
15 words
The method of claim 1 , wherein the target is identified in the program template.
Claim 13
Dependent Claim
16 words
The method of claim 1 , wherein the transformation program is identified in the program template.
Claim 14
Dependent Claim
24 words
The method of claim 1 , further comprising the step of storing results of the invocation of the transformation program in a history file.
Claim 15
Dependent Claim
66 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein the creating of at least one scheduled instance of operation of the transformation program includes: displaying the parameter values of the parameter string; receiving modifications of the displayed parameter values from the user; and updating the parameter string based on the received selective modifications.
Claim 16
Dependent Claim
38 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein the defining of said program template includes: defining a program template using a graphical user interface.
Claim 17
Dependent Claim
89 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein: the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes defining at least one default parameter value as a token; and the invoking of the at least one scheduled instance of operation of the transformation program under control of the at least one business view includes replacing the token with a system data value corresponding to the token.
Claim 18
Dependent Claim
65 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes: defining a program template for a pre-existing transformation program, said pre-existing transformation program being one of an SQL query and a data warehouse program.
Claim 19
Dependent Claim
41 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein the defining of said program template includes: storing metadata relating to the pre-existing transformation program in the program template.
Claim 20
Dependent Claim
71 words
The method of transforming data in a database stored on a data storage device as set forth in claim 18 , wherein the storing of metadata relating to the pre-existing transformation program in the program template includes: storing at least one of a business name, a physical name, an executable file type, a description, and a server agent at which the data warehouse program is installed with a specified physical name.
Claim 21
Dependent Claim
62 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes: defining a program template containing default parameter values specifying default source and target parameter values relating to the pre-existing transformation program.
Claim 22
Dependent Claim
36 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , further comprising: storing information corresponding to results of the invoking step in a history file.
Claim 23
Dependent Claim
133 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein: the defining of at least one business view includes defining at least a first business view and a second business view; the creating of at least one scheduled instance of operation of the transformation program includes selectively scheduling the first business view and the second business view to run concurrently; and the invoking of the at least one scheduled instance of operation of the transformation program includes invoking a first scheduled instance of operation of the transformation under control of the first business view and invoking a second scheduled instance of operation of the transformation under control of the second business view, said first and second invoked scheduled instances running concurrently.
Claim 24
Dependent Claim
111 words
The method of transforming data in a database stored on a data storage device as set forth in claim 1 , wherein the invoking of the at least one scheduled instance of operation of the transformation program under control of the at least one business view includes: retrieving a copy of the program template; passing the parameter string of the business view to the retrieved copy of the program template and thereby selectively modifying the default parameters of the retrieved copy of the program template; and starting an instance of operation of the transformation program, said instance receiving the selectively modified default parameters of the retrieved copy of the program template.
Claim 25
Independent Claim
111 words
An apparatus for transforming data in a database, comprising: a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores the database; one or more computer programs, performed by the computer, retrieving a program template containing parameters corresponding to parameters of a pre-existing transformation program, invoking a business view with the program template, the business view including scheduling information and a parameter string initialized to default parameter values, and, under control of the business view, based on said scheduling information and said parameter string, invoking said transformation program that transforms source data to generate target data using the parameters provided in the program template.
Claim 26
Independent Claim
111 words
An apparatus for transforming data in a database, comprising: a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores the database; one or more computer programs, performed by the computer, retrieving a program template containing parameters corresponding to parameters of a pre-existing transformation program, invoking a business view with the program template, the business view including scheduling information and a parameter string initialized to default parameter values, and, under control of the business view, based on said scheduling information and said parameter string, invoking said transformation program that transforms source data to generate target data using the parameters provided in the program template.
Claim 27
Dependent Claim
26 words
The apparatus of claim 24 , wherein the program template contains tokens which are replaced by system data at the time the transformation program is invoked.
Claim 28
Dependent Claim
13 words
The apparatus of claim 24 , wherein the transformation program is a command.
Claim 29
Dependent Claim
13 words
The apparatus of claim 24 , wherein the transformation program is a utility.
Claim 30
Dependent Claim
17 words
The apparatus of claim 24 , wherein the business view is invoked based on a predefined schedule.
Claim 31
Dependent Claim
16 words
The apparatus of claim 24 , wherein the program template comprises information about the transformation program.
Claim 32
Dependent Claim
15 words
The apparatus of claim 24 , wherein the source is identified in the business view.
Claim 33
Dependent Claim
16 words
The apparatus of claim 24 , wherein the transformation program is identified in the business view.
Claim 34
Dependent Claim
15 words
The apparatus of claim 24 , wherein the target is identified in the business view.
Claim 35
Dependent Claim
16 words
The apparatus of claim 24 , wherein the source file is identified in the program template.
Claim 36
Dependent Claim
16 words
The apparatus of claim 24 , wherein the target file is identified in the program template.
Claim 37
Dependent Claim
15 words
The apparatus of claim 24 , wherein the transformation is identified in the program template.
Claim 38
Dependent Claim
23 words
The apparatus of claim 24 , further comprising means for storing results of the invocation of the transformation program in a history file.
Claim 39
Dependent Claim
122 words
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for transforming data in a database operation on a database stored on a data storage device, the method comprising the steps of: retrieving a program template containing parameters corresponding to parameters of a pre-existing transformation program; invoking a business view with the program template, the business view including scheduling information and a parameter string initialized to default parameter values; and under control of the business view based on said scheduling information and said parameter string, invoking said transformation program that transforms source data to generate target data using the parameters provided in the program template.
Claim 40
Dependent Claim
122 words
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for transforming data in a database operation on a database stored on a data storage device, the method comprising the steps of: retrieving a program template containing parameters corresponding to parameters of a pre-existing transformation program; invoking a business view with the program template, the business view including scheduling information and a parameter string initialized to default parameter values; and under control of the business view based on said scheduling information and said parameter string, invoking said transformation program that transforms source data to generate target data using the parameters provided in the program template.
Claim 41
Dependent Claim
28 words
The article of manufacture of claim 37 , wherein the program template contains tokens which are replaced by system data at the time the transformation program is invoked.
Claim 42
Dependent Claim
15 words
The article of manufacture of claim 37 , wherein the transformation program is a command.
Claim 43
Dependent Claim
15 words
The article of manufacture of claim 37 , wherein the transformation program is a utility.
Claim 44
Dependent Claim
19 words
The article of manufacture of claim 37 , wherein the business view is invoked based on a predefined schedule.
Claim 45
Dependent Claim
18 words
The article of manufacture of claim 37 , wherein the program template comprises information about the transformation program.
Claim 46
Dependent Claim
17 words
The article of manufacture of claim 37 , wherein the source is identified in the business view.
Claim 47
Dependent Claim
18 words
The article of manufacture of claim 37 , wherein the transformation program is identified in the business view.
Claim 48
Dependent Claim
17 words
The article of manufacture of claim 37 , wherein the target is identified in the business view.
Claim 49
Dependent Claim
18 words
The article of manufacture of claim 37 , wherein the source file is identified in the program template.
Claim 50
Dependent Claim
18 words
The article of manufacture of claim 37 , wherein the target file is identified in the program template.
Claim 51
Dependent Claim
17 words
The article of manufacture of claim 37 , wherein the transformation is identified in the program template.
Claim 52
Dependent Claim
23 words
The article of manufacture of claim 37 , further comprising storing results of the invocation of the transformation program in a history file.
Claim 53
Independent Claim
83 words
A system for creating and scheduling data transformation operations using an associated transformation program in a data warehouse, comprising: a template corresponding to the associated transformation program, said template including a set of default parameter values for parameters of the transformation program; a business view in operative communication with the template and including a parameter string comprising values for parameters of the transformation program; and means for invoking an instance of operation of the transformation program under the control of the business view.
Claim 54
Independent Claim
83 words
A system for creating and scheduling data transformation operations using an associated transformation program in a data warehouse, comprising: a template corresponding to the associated transformation program, said template including a set of default parameter values for parameters of the transformation program; a business view in operative communication with the template and including a parameter string comprising values for parameters of the transformation program; and means for invoking an instance of operation of the transformation program under the control of the business view.
Claim 55
Dependent Claim
45 words
The system as set forth in claim 50 , further comprising: a business view generator having: means for initializing the parameter string to comprise the default parameter values of the template, and means for selective user modification of the parameter string of the business view.
Claim 56
Dependent Claim
44 words
The system as set forth in claim 51 , wherein the means for selective user modification of the parameter string of the business view includes: an interactive graphical user interface by which the user selectively modifies the parameter values contained in the parameter string.
Claim 57
Dependent Claim
50 words
The system as set forth in claim 50 , wherein the business view further includes: scheduling information whereby the means for invoking an instance of operation of the transformation program under the control of the business view invokes the instance at one or more times according to the scheduling information.
Claim 58
Dependent Claim
32 words
The system as set forth in claim 50 , further comprising: an operations file that stores information on the success or failure of the invoked instance of operation of the transformation program.
Claim 59
Independent Claim
146 words
An apparatus for transforming data in a database, comprising: a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores the database; and one or more computer programs, performed by the computer, for performing a method comprising: defining a program template containing default parameter values corresponding to parameters of a pre-existing transformation program, defining at least one business view having an association with the program template, said business view including scheduling information and a parameter string initialized to the default parameter values, creating at least one scheduled instance of operation of the transformation program by receiving selective modifications of the parameter string and the scheduling information of the at least one business view from the user, and invoking the at least one scheduled instance of operation of the transformation program under control of the at least one business view.
Claim 60
Independent Claim
146 words
An apparatus for transforming data in a database, comprising: a computer having a memory and a data storage device coupled thereto, wherein the data storage device stores the database; and one or more computer programs, performed by the computer, for performing a method comprising: defining a program template containing default parameter values corresponding to parameters of a pre-existing transformation program, defining at least one business view having an association with the program template, said business view including scheduling information and a parameter string initialized to the default parameter values, creating at least one scheduled instance of operation of the transformation program by receiving selective modifications of the parameter string and the scheduling information of the at least one business view from the user, and invoking the at least one scheduled instance of operation of the transformation program under control of the at least one business view.
Claim 61
Dependent Claim
55 words
The apparatus as set forth in claim 55 , wherein the creating of at least one scheduled instance of operation of the transformation program includes: displaying the parameter values of the parameter string; receiving selective modifications of the displayed parameter values from the user; and updating the parameter string based on the received selective modifications.
Claim 62
Dependent Claim
26 words
The apparatus as set forth in claim 55 , wherein the defining of said program template includes: defining a program template using a graphical user interface.
Claim 63
Dependent Claim
77 words
The apparatus as set forth in claim 55 , wherein: the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes defining at least one default parameter value as a token; and the invoking of the at least one scheduled instance of operation of the transformation program under control of the at least one business view includes replacing the token with a system data value corresponding to the token.
Claim 64
Dependent Claim
53 words
The apparatus as set forth in claim 55 , wherein the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes: defining a program template for a pre-existing transformation program, said pre-existing transformation program being one of an SQL query and a data warehouse program.
Claim 65
Dependent Claim
29 words
The apparatus as set forth in claim 55 , wherein the defining of said program template includes: storing metadata relating to the pre-existing transformation program in the program template.
Claim 66
Dependent Claim
59 words
The apparatus as set forth in claim 60 , wherein the storing of metadata relating to the pre-existing transformation program in the program template includes: storing at least one of a business name, a physical name, an executable file type, a description, and a server agent at which the data warehouse program is installed with a specified physical name.
Claim 67
Dependent Claim
50 words
The apparatus as set forth in claim 55 , wherein the defining of a program template containing default parameter values corresponding to parameters of said pre-existing transformation program includes: defining a program template containing default parameter values specifying default source and target parameter values relating to the pre-existing transformation program.
Claim 68
Dependent Claim
24 words
The apparatus as set forth in claim 55 , further comprising: storing information corresponding to results of the invoking step in a history file.
Claim 69
Dependent Claim
121 words
The apparatus as set forth in claim 55 , wherein: the defining of at least one business view includes defining at least a first business view and a second business view; the creating of at least one scheduled instance of operation of the transformation program includes selectively scheduling the first business view and the second business view to run concurrently; and the invoking of the at least one scheduled instance of operation of the transformation program includes invoking a first scheduled instance of operation of the transformation under control of the first business view and invoking a second scheduled instance of operation of the transformation under control of the second business view, said first and second invoked scheduled instances running concurrently.
Claim 70
Dependent Claim
99 words
The apparatus as set forth in claim 55 , wherein the invoking of the at least one scheduled instance of operation of the transformation program under control of the at least one business view includes: retrieving a copy of the program template; passing the parameter string of the business view to the retrieved copy of the program template and thereby selectively modifying the default parameters of the retrieved copy of the program template; and starting an instance of operation of the transformation program, said instance receiving the selectively modified default parameters of the retrieved copy of the program template.
Claim 71
Dependent Claim
148 words
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform a method for transforming data in a database operation on a database stored on a data storage device, the method comprising: defining a program template containing default parameter values corresponding to parameters of a pre-existing transformation program; defining at least one business view having an association with the program template, said business view including scheduling information and a parameter string initialized to the default parameter values; creating at least one scheduled instance of operation of the transformation program by receiving selective modifications of the parameter string and the scheduling information of the at least one business view from the user; and invoking the at least one scheduled instance of operation of the transformation program under control of the at least one business view.
Claim 72
Dependent Claim
148 words
An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform a method for transforming data in a database operation on a database stored on a data storage device, the method comprising: defining a program template containing default parameter values corresponding to parameters of a pre-existing transformation program; defining at least one business view having an association with the program template, said business view including scheduling information and a parameter string initialized to the default parameter values; creating at least one scheduled instance of operation of the transformation program by receiving selective modifications of the parameter string and the scheduling information of the at least one business view from the user; and invoking the at least one scheduled instance of operation of the transformation program under control of the at least one business view.
Claim 73
Dependent Claim
57 words
The article of manufacture as set forth in claim 66 , wherein the creating of at least one scheduled instance of operation of the transformation program includes: displaying the parameter values of the parameter string; receiving selective modifications of the displayed parameter values from the user; and updating the parameter string based on the received selective modifications.
Claim 74
Dependent Claim
28 words
The article of manufacture as set forth in claim 66 , wherein the defining of said program template includes: defining a program template using a graphical user interface.
Claim 75
Dependent Claim
79 words
The article of manufacture as set forth in claim 66 , wherein: the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes defining at least one default parameter value as a token; and the invoking of the at least one scheduled instance of operation of the transformation program under control of the at least one business view includes replacing the token with a system data value corresponding to the token.
Claim 76
Dependent Claim
55 words
The article of manufacture as set forth in claim 66 , wherein the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes: defining a program template for a pre-existing transformation program, said pre-existing transformation program being one of an SQL query and a data warehouse program.
Claim 77
Dependent Claim
31 words
The article of manufacture as set forth in claim 66 , wherein the defining of said program template includes: storing metadata relating to the pre-existing transformation program in the program template.
Claim 78
Dependent Claim
61 words
The article of manufacture as set forth in claim 71 , wherein the storing of metadata relating to the pre-existing transformation program in the program template includes: storing at least one of a business name, a physical name, an executable file type, a description, and a server agent at which the data warehouse program is installed with a specified physical name.
Claim 79
Dependent Claim
52 words
The article of manufacture as set forth in claim 66 , wherein the defining of said program template containing default parameter values corresponding to parameters of a pre-existing transformation program includes: defining a program template containing default parameter values specifying default source and target parameter values relating to the pre-existing transformation program.
Claim 80
Dependent Claim
26 words
The article of manufacture as set forth in claim 66 , further comprising: storing information corresponding to results of the invoking step in a history file.
Claim 81
Dependent Claim
123 words
The article of manufacture as set forth in claim 66 , wherein: the defining of at least one business view includes defining at least a first business view and a second business view; the creating of at least one scheduled instance of operation of the transformation program includes selectively scheduling the first business view and the second business view to run concurrently; and the invoking of the at least one scheduled instance of operation of the transformation program includes invoking a first scheduled instance of operation of the transformation under control of the first business view and invoking a second scheduled instance of operation of the transformation under control of the second business view, said first and second invoked scheduled instances running concurrently.
Claim 82
Dependent Claim
101 words
The article of manufacture as set forth in claim 66 , wherein the invoking of the at least one scheduled instance of operation of the transformation program under control of the at least one business view includes: retrieving a copy of the program template; passing the parameter string of the business view to the retrieved copy of the program template and thereby selectively modifying the default parameters of the retrieved copy of the program template; and starting an instance of operation of the transformation program, said instance receiving the selectively modified default parameters of the retrieved copy of the program template.
References Cited (Backward Citations)
US5596747A
Cited
US5408654A
Cited
US5574910A
Cited
US5455945A
Cited
US5522068A
Cited
JPH07152615A
Cited
US5559692A
Cited
US5721915A
Cited
JPH08202597A
Cited
JPH0934758A
Cited
US5832496A
Cited
US5870746A
Cited
US5970490A
Cited
US6230309B1
Cited
US6134541A
Cited
US6014670A
Cited
US6128624A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-07-08 | 2006-01-07 | 2006-07-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-07-08 | 2010-01-07 | 2010-07-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-07-08 | 2014-01-07 | 2014-07-09 | $7700.00 | Window Closed / Lapsed |