← Back to Patent Explorer
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
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

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.

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

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag