US6035307A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Enterprise data movement system and method including opportunistic performance of utilities and data move operations for improved efficiency
Assignee: Informatica LLC
•
Filing: 1998-03-30
•
Granted: 2000-03-07
•
Expires: 2018-03-30
Abstract
Abstract An Enterprise Data Movement (EDM) system and method for performing data move operations in an enterprise computing system with improved efficiency. Data move operations preferably use operations of an existing database utility, for example, one or more of an unload or load operation, wherein the utility is already required to be performed. In other words, according to the invention, data move operations preferably use the utilities in an opportunistic or parasitic fashion, when they are already being performed for other reasons, thereby providing a dual purpose operation and increased efficiency.
Inventors
- 👤 James L. Martin
- 👤 Abolfazl Sirjani
- 👤 Kevin D. Seppi
- 👤 Lisa S. Keeler
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 22:40
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/258; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99936; Y10S707/99938; Y10S707/99939; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99954
Claims Analysis
Total Claims: 71
Claim 1
Independent Claim
175 words
A method for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database, wherein the data move operations are performed with improved efficiency, the method comprising: initializing an extract utility to begin an extract operation to extract data from the source database, wherein the extract utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data from the source database; the extract utility performing the extract operation to extract the data; providing the data to at least one data move process in response to performing the extract operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data from the source database; the data move process moving the data received from said providing.
Claim 2
Independent Claim
175 words
A method for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database, wherein the data move operations are performed with improved efficiency, the method comprising: initializing an extract utility to begin an extract operation to extract data from the source database, wherein the extract utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data from the source database; the extract utility performing the extract operation to extract the data; providing the data to at least one data move process in response to performing the extract operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data from the source database; the data move process moving the data received from said providing.
Claim 3
Dependent Claim
51 words
The method of claim 1, wherein the enterprise computing system includes a target database; wherein the at least one data move task is required to move the data from the source database to the target database; wherein said moving comprises the data move process moving the data to the target database.
Claim 4
Dependent Claim
76 words
The method of claim 1, wherein said determining data move requirements comprises: providing information to an EDM process about the extract operation and the data which is the subject of the extract operation; the EDM process determining if the data is desired for a data move operation using the information; configuring the extract utility to provide the data to a specified destination in response to determining that the data is desired for a data move operation.
Claim 5
Dependent Claim
40 words
The method of claim 3, wherein the EDM process determining if the data is desired for a data move operation includes querying a repository for task profiles to determine data move requirements of the at least one data move task.
Claim 6
Dependent Claim
86 words
The method of claim 4, wherein said determining data move requirements includes examining required transformation information in the repository regarding the at least one data move task; the method further comprising: creating a transform process in response to said required transformation information, wherein said creating is performed in response to determining that the at least one data move task requires the data from the source database and in response to examining the required transformation information in the repository regarding the at least one data move task.
Claim 7
Dependent Claim
63 words
The method of claim 1, further comprising: initializing the at least one data move process in response to determining that said at least one data move process requires the data, wherein the at least one data move process is initialized prior to said providing the data, wherein the at least one data move process corresponds to the at least one data move task.
Claim 8
Dependent Claim
22 words
The method of claim 1, wherein said determining the data move requirements is performed in response to said initializing the extract utility.
Claim 9
Dependent Claim
29 words
The method of claim 1, wherein the extract utility executes on a first computer system; wherein the at least one data move process executes on the first computer system.
Claim 10
Dependent Claim
62 words
The method of claim 1, wherein the data move task requires movement of the data from the source database to a target database; wherein the source database resides on a first computer system and wherein the target database resides on a second computer system; wherein said moving the data includes: establishing a connection to a receive process in the second computer system.
Claim 11
Dependent Claim
61 words
The method of claim 9, wherein said moving the data includes: establishing a connection to a remote server process in the second computer system; providing information to the remote server process about which tasks desire or require the data; the remote server process starting the at least one data move process in the second computer system in response to said providing.
Claim 12
Dependent Claim
47 words
The method of claim 10, wherein said moving the data further includes: the remote server process receiving information regarding the data move; the method further comprising: creating a transform process on the remote side in response to the remote server process receiving information regarding the data move.
Claim 13
Dependent Claim
38 words
The method of claim 1, wherein the data move task requires movement of the data from the source database to a target database; wherein the source database and the target database both reside on a first computer system.
Claim 14
Dependent Claim
17 words
The method of claim 1, wherein said data move task is unrelated to said first database operation.
Claim 15
Dependent Claim
17 words
The method of claim 1, wherein said data move task is related to said first database operation.
Claim 16
Dependent Claim
58 words
The method of claim 1, further comprising: configuring the data move task to take advantage of existing utility operations in an opportunistic fashion prior to said determining data move requirements; wherein said determining data move requirements is performed in response to said configuring the data move task to take advantage of existing utility operations in an opportunistic fashion.
Claim 17
Dependent Claim
24 words
The method of claim 1, wherein the data move process takes advantage of the extract utility performing the extract operation in an opportunistic fashion.
Claim 18
Dependent Claim
13 words
The method of claim 1, wherein the extract utility comprises an unload utility.
Claim 19
Dependent Claim
13 words
The method of claim 1, wherein the extract utility comprises a copy utility.
Claim 20
Independent Claim
215 words
A method for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of distributed computer systems and includes a source database and a target database, wherein the data move operations are performed with improved efficiency, the method comprising: initializing a load utility to begin a load operation to load data onto a source database, wherein the load utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data being loaded onto the source database, wherein the at least one data move task is required to move the data from the source database to the target database; the load utility performing the load operation to load the data onto the source database; providing the data to at least one data move process in response to performing the load operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data being loaded onto the source database; and the data move process moving the data received from said providing to the target database.
Claim 21
Independent Claim
215 words
A method for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of distributed computer systems and includes a source database and a target database, wherein the data move operations are performed with improved efficiency, the method comprising: initializing a load utility to begin a load operation to load data onto a source database, wherein the load utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data being loaded onto the source database, wherein the at least one data move task is required to move the data from the source database to the target database; the load utility performing the load operation to load the data onto the source database; providing the data to at least one data move process in response to performing the load operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data being loaded onto the source database; and the data move process moving the data received from said providing to the target database.
Claim 22
Dependent Claim
76 words
The method of claim 19, wherein said determining data move requirements comprises: providing information to an EDM process about the load operation and the data which is the subject of the load operation; the EDM process determining if the data is desired for a data move operation using the information; configuring the load utility to provide the data to a specified destination in response to determining that the data is desired for a data move operation.
Claim 23
Dependent Claim
40 words
The method of claim 20, wherein the EDM process determining if the data is desired for a data move operation includes querying a repository for task profiles to determine data move requirements of the at least one data move task.
Claim 24
Dependent Claim
86 words
The method of claim 21, wherein said determining data move requirements includes examining required transformation information in the repository regarding the at least one data move task; the method further comprising: creating a transform process in response to said required transformation information, wherein said creating is performed in response to determining that the at least one data move task requires the data from the source database and in response to examining the required transformation information in the repository regarding the at least one data move task.
Claim 25
Dependent Claim
63 words
The method of claim 19, further comprising: initializing the at least one data move process in response to determining that said at least one data move process requires the data, wherein the at least one data move process is initialized prior to said providing the data, wherein the at least one data move process corresponds to the at least one data move task.
Claim 26
Dependent Claim
22 words
The method of claim 19, wherein said determining the data move requirements is performed in response to said initializing the load utility.
Claim 27
Dependent Claim
29 words
The method of claim 19, wherein the load utility executes on a first computer system; wherein the at least one data move process executes on the first computer system.
Claim 28
Dependent Claim
62 words
The method of claim 19, wherein the data move task requires movement of the data from the source database to a target database; wherein the source database resides on a first computer system and wherein the target database resides on a second computer system; wherein said moving the data includes: establishing a connection to a receive process in the second computer system.
Claim 29
Dependent Claim
60 words
The method of claim 19, wherein said moving the data comprises: establishing a connection to a remote server process in the second computer system; providing information the remote server process regarding which tasks desire or require the data; the remote server process starting the at least one data move process in the second computer system in response to said providing.
Claim 30
Dependent Claim
41 words
The method of claim 27, the remote server process receiving information regarding the data move; the method further comprising: creating a transform process on the second computer system in response to the remote server process receiving information regarding the data move.
Claim 31
Dependent Claim
17 words
The method of claim 19, wherein said data move task is unrelated to said first database operation.
Claim 32
Dependent Claim
58 words
The method of claim 19, further comprising: configuring the data move task to take advantage of existing utility operations in an opportunistic fashion prior to said determining data move requirements; wherein said determining data move requirements is performed in response to said configuring the data move task to take advantage of existing utility operations in an opportunistic fashion.
Claim 33
Dependent Claim
24 words
The method of claim 19, wherein the data move process takes advantage of the load utility performing the load operation in an opportunistic fashion.
Claim 34
Dependent Claim
13 words
The method of claim 19, wherein the load utility comprises a reorganization utility.
Claim 35
Dependent Claim
183 words
A memory media which stores program instructions for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of distributed computer systems and includes a source database, wherein the data move operations are performed with improved efficiency, wherein the program instructions implement: initializing an extract utility to begin an extract operation to extract data from the source database, wherein the extract utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data from the source database; the extract utility performing the extract operation to extract the data; providing the data to at least one data move process in response to performing the extract operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data from the source database; the data move process moving the data received from said providing.
Claim 36
Dependent Claim
183 words
A memory media which stores program instructions for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of distributed computer systems and includes a source database, wherein the data move operations are performed with improved efficiency, wherein the program instructions implement: initializing an extract utility to begin an extract operation to extract data from the source database, wherein the extract utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data from the source database; the extract utility performing the extract operation to extract the data; providing the data to at least one data move process in response to performing the extract operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data from the source database; the data move process moving the data received from said providing.
Claim 37
Dependent Claim
52 words
The memory media of claim 33, wherein the enterprise computing system includes a target database; wherein the at least one data move task is required to move the data from the source database to the target database; wherein said moving comprises the data move process moving the data to the target database.
Claim 38
Dependent Claim
77 words
The memory media of claim 33, wherein said determining data move requirements comprises: providing information to an EDM process about the extract operation and the data which is the subject of the extract operation; the EDM process determining if the data is desired for a data move operation using the information; configuring the extract utility to provide the data to a specified destination in response to determining that the data is desired for a data move operation.
Claim 39
Dependent Claim
41 words
The memory media of claim 35, wherein the EDM process determining if the data is desired for a data move operation includes querying a repository for task profiles to determine data move requirements of the at least one data move task.
Claim 40
Dependent Claim
89 words
The memory media of claim 36, wherein said determining data move requirements includes examining required transformation information in the repository regarding the at least one data move task; wherein the program instructions further implement: creating a transform process in response to said required transformation information, wherein said creating is performed in response to determining that the at least one data move task requires the data from the source database and in response to examining the required transformation information in the repository regarding the at least one data move task.
Claim 41
Dependent Claim
68 words
The memory media of claim 33, wherein the program instructions further implement: initializing the at least one data move process in response to determining that said at least one data move process requires the data, wherein the at least one data move process is initialized prior to said providing the data, wherein the at least one data move process corresponds to the at least one data move task.
Claim 42
Dependent Claim
23 words
The memory media of claim 33, wherein said determining the data move requirements is performed in response to said initializing the extract utility.
Claim 43
Dependent Claim
30 words
The memory media of claim 33, wherein the extract utility executes on a first computer system; wherein the at least one data move process executes on the first computer system.
Claim 44
Dependent Claim
63 words
The memory media of claim 33, wherein the data move task requires movement of the data from the source database to a target database; wherein the source database resides on a first computer system and wherein the target database resides on a second computer system; wherein said moving the data includes: establishing a connection to a receive process in the second computer system.
Claim 45
Dependent Claim
62 words
The memory media of claim 41, wherein said moving the data includes: establishing a connection to a remote server process in the second computer system; providing information to the remote server process about which tasks desire or require the data; the remote server process starting the at least one data move process in the second computer system in response to said providing.
Claim 46
Dependent Claim
49 words
The memory media of claim 42, wherein said moving the data further includes: the remote server process receiving information regarding the data move; the program instructions further implementing: creating a transform process on the remote side in response to the remote server process receiving information regarding the data move.
Claim 47
Dependent Claim
39 words
The memory media of claim 33, wherein the data move task requires movement of the data from the source database to a target database; wherein the source database and the target database both reside on a first computer system.
Claim 48
Dependent Claim
18 words
The memory media of claim 33, wherein said data move task is unrelated to said first database operation.
Claim 49
Dependent Claim
18 words
The memory media of claim 33, wherein said data move task is related to said first database operation.
Claim 50
Dependent Claim
62 words
The memory media of claim 33, the program instructions further implementing: configuring the data move task to take advantage of existing utility operations in an opportunistic fashion prior to said determining data move requirements; wherein said determining data move requirements is performed in response to said configuring the data move task to take advantage of existing utility operations in an opportunistic fashion.
Claim 51
Dependent Claim
25 words
The memory media of claim 33, wherein the data move process takes advantage of the extract utility performing the extract operation in an opportunistic fashion.
Claim 52
Dependent Claim
14 words
The memory media of claim 33, wherein the extract utility comprises an unload utility.
Claim 53
Dependent Claim
14 words
The memory media of claim 33, wherein the extract utility comprises a copy utility.
Claim 54
Dependent Claim
222 words
A memory media which stores program instructions for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of distributed computer systems and includes a source database and a target database, wherein the data move operations are performed with improved efficiency, wherein the program instructions implement: initializing a load utility to begin a load operation to load data onto a source database, wherein the load utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data being loaded onto the source database, wherein the at least one data move task is required to move the data from the source database to the target database; the load utility performing the load operation to load the data onto the source database; providing the data to at least one data move process in response to performing the load operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data being loaded onto the source database; and the data move process moving the data received from said providing to the target database.
Claim 55
Dependent Claim
222 words
A memory media which stores program instructions for performing data move operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of distributed computer systems and includes a source database and a target database, wherein the data move operations are performed with improved efficiency, wherein the program instructions implement: initializing a load utility to begin a load operation to load data onto a source database, wherein the load utility is initialized to perform a first database operation; determining data move requirements within the enterprise computing system, wherein said determining determines that at least one data move task requires the data being loaded onto the source database, wherein the at least one data move task is required to move the data from the source database to the target database; the load utility performing the load operation to load the data onto the source database; providing the data to at least one data move process in response to performing the load operation, wherein the at least one data move process corresponds to the at least one data move task, wherein said providing is performed in response to determining that at least one data move task requires the data being loaded onto the source database; and the data move process moving the data received from said providing to the target database.
Claim 56
Dependent Claim
81 words
The memory media of claim 51, wherein said determining data move requirements wherein the program instructions implement: providing information to an EDM process about the load operation and the data which is the subject of the load operation; the EDM process determining if the data is desired for a data move operation using the information; configuring the load utility to provide the data to a specified destination in response to determining that the data is desired for a data move operation.
Claim 57
Dependent Claim
41 words
The memory media of claim 52, wherein the EDM process determining if the data is desired for a data move operation includes querying a repository for task profiles to determine data move requirements of the at least one data move task.
Claim 58
Dependent Claim
88 words
The memory media of claim 53, wherein said determining data move requirements includes examining required transformation information in the repository regarding the at least one data move task; the program instructions further implementing: creating a transform process in response to said required transformation information, wherein said creating is performed in response to determining that the at least one data move task requires the data from the source database and in response to examining the required transformation information in the repository regarding the at least one data move task.
Claim 59
Dependent Claim
68 words
The memory media of claim 51, wherein the program instructions further implement: initializing the at least one data move process in response to determining that said at least one data move process requires the data, wherein the at least one data move process is initialized prior to said providing the data, wherein the at least one data move process corresponds to the at least one data move task.
Claim 60
Dependent Claim
23 words
The memory media of claim 51, wherein said determining the data move requirements is performed in response to said initializing the load utility.
Claim 61
Dependent Claim
30 words
The memory media of claim 51, wherein the load utility executes on a first computer system; wherein the at least one data move process executes on the first computer system.
Claim 62
Dependent Claim
63 words
The memory media of claim 51, wherein the data move task requires movement of the data from the source database to a target database; wherein the source database resides on a first computer system and wherein the target database resides on a second computer system; wherein said moving the data includes: establishing a connection to a receive process in the second computer system.
Claim 63
Dependent Claim
61 words
The memory media of claim 51, wherein said moving the data comprises: establishing a connection to a remote server process in the second computer system; providing information the remote server process regarding which tasks desire or require the data; the remote server process starting the at least one data move process in the second computer system in response to said providing.
Claim 64
Dependent Claim
43 words
The memory media of claim 59, the remote server process receiving information regarding the data move; the program instructions further implementing: creating a transform process on the second computer system in response to the remote server process receiving information regarding the data move.
Claim 65
Dependent Claim
18 words
The memory media of claim 51, wherein said data move task is unrelated to said first database operation.
Claim 66
Dependent Claim
63 words
The memory media of claim 51, wherein the program instructions further implement: configuring the data move task to take advantage of existing utility operations in an opportunistic fashion prior to said determining data move requirements; wherein said determining data move requirements is performed in response to said configuring the data move task to take advantage of existing utility operations in an opportunistic fashion.
Claim 67
Dependent Claim
25 words
The memory media of claim 51, wherein the data move process takes advantage of the load utility performing the load operation in an opportunistic fashion.
Claim 68
Dependent Claim
14 words
The memory media of claim 51, wherein the load utility comprises a reorganization utility.
Claim 69
Dependent Claim
261 words
An enterprise computing system which performs data move operations with improved efficiency, comprising: a plurality of computer systems, wherein said plurality of computer systems includes a source computer system which includes a source database; an extract utility which executes in the source computer system which is initialized to begin an extract operation to extract data from the source database, wherein the extract utility is initialized to perform a first database operation, wherein the extract utility is operable to perform an extract operation to extract data; a program which executes in the enterprise computing system which is operable to determine data move requirements within the enterprise computing system, wherein said program determines data move requirements in response to initialization of said extract utility, wherein the program determines that at least one data move task requires the data; a data move process which corresponds to the at least one data move task; wherein the program is operable to configure the extract utility to provide data to the data move process corresponding to the at least one data move task which is determined to require the data from the source database; wherein the extract utility is operable to provide the data to the data move process during performance of the extract operation, wherein the extract utility is operable to provide the data to the data move process in response to the program determining that the at least one data move task requires the data from the source database; wherein the data move process is operable to move the data received from the extract utility.
Claim 70
Dependent Claim
261 words
An enterprise computing system which performs data move operations with improved efficiency, comprising: a plurality of computer systems, wherein said plurality of computer systems includes a source computer system which includes a source database; an extract utility which executes in the source computer system which is initialized to begin an extract operation to extract data from the source database, wherein the extract utility is initialized to perform a first database operation, wherein the extract utility is operable to perform an extract operation to extract data; a program which executes in the enterprise computing system which is operable to determine data move requirements within the enterprise computing system, wherein said program determines data move requirements in response to initialization of said extract utility, wherein the program determines that at least one data move task requires the data; a data move process which corresponds to the at least one data move task; wherein the program is operable to configure the extract utility to provide data to the data move process corresponding to the at least one data move task which is determined to require the data from the source database; wherein the extract utility is operable to provide the data to the data move process during performance of the extract operation, wherein the extract utility is operable to provide the data to the data move process in response to the program determining that the at least one data move task requires the data from the source database; wherein the data move process is operable to move the data received from the extract utility.
Claim 71
Dependent Claim
65 words
The enterprise computing system of claim 65, wherein said plurality of computer systems includes a target computer system which includes a target database; wherein the at least one data move task is required to move the data from the source database to the target database; wherein the data move process is operable to move the data received from the extract utility to the target database.
References Cited (Backward Citations)
US5170480A
Cited
US5566332A
Cited
US5287496A
Cited
US5261094A
Cited
US5640561A
Cited
US5627961A
Cited
US5459864A
Cited
US5412384A
Cited
US5613113A
Cited
US5603024A
Cited
US5553279A
Cited
US5440735A
Cited
US5581754A
Cited
US5603026A
Cited
US5577240A
Cited
US5787247A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-03-07 | 2003-09-06 | 2004-03-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-03-07 | 2007-09-06 | 2008-03-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-03-07 | 2011-09-06 | 2012-03-07 | $7700.00 | Window Closed / Lapsed |