Methods, computer program products, and systems that schedule loading data into databases

• US 20050102254A1
• Filed: 11/06/2003
• Published: 05/12/2005
• Est. Priority Date: 11/06/2003
• Status: Abandoned Application

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Marr, Gary William, Nowak, Jane Barbara, Volozhanin, Leonid
• Application Number:
  US10/702,283
• Publication Number:
  US 20050102254A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

Data is automatically loaded into a user database from an external data source based on a schedule. A determination is made as to whether a task schedule has been satisfied. An application database and the user database are opened using a batch process based on the determination. A macro may be used to load data from an external data source into the user database. A task scheduler may be used to invoke the batch process. The application database may be an Access application database. The macro may remove data from predefined fields in the user database, and then may load data from the external data file into at least some of the predefined fields of the user database. The macro may be used to quit the user database and the application database after the data is loaded into the user database.

Claims

1. A method of loading data into a user database, the method comprising:

determining that a task schedule has been satisfied;

opening an application database and a user database using a batch process based on the determination that the task schedule has been satisfied;

loading data from an external data source into the user database using a macro; and

quitting the user database using the macro.

2. The method of claim 1, further comprising quitting the application database using the macro.

3. The method of claim 1, wherein determining that the task schedule has been satisfied comprises monitoring time of day relative to a scheduled time.

4. The method of claim 1, wherein determining that the task schedule has been satisfied comprises monitoring day of week relative to a scheduled day.

5. The method of claim 1, wherein opening the application database and the user database using the batch process based on the determination that the task schedule has been satisfied comprises:

invoking the batch process from a task scheduler; and

opening the application database and the user database using batch code from the batch process.

6. The method of claim 5, wherein loading data from the external data source into the user database comprises opening the user database with a pointer to the macro that contains instructions for loading data from the external data source.

7. The method of claim 5, further comprising defining a schedule for invoking the batch process in a Scheduled Task program of Microsoft Windows.

8. The method of claim 5, wherein opening the application database and the user database from the batch process comprises identifying a path to an executable program for the application database and a path to a user database file.

9. The method of claim 1, wherein loading data from the external data source into the user database comprises:

removing data from predefined fields in the user database; and

loading data from the external data source into at least some of the predefined fields.

10. The method of claim 9, wherein loading data from the external data source into the database further comprises generating data in other predefined fields based on the data from the external data source.

11. A computer program product for loading data into a user database, the computer program product comprising program code embodied in a computer-readable storage medium, the computer program code comprising:

program code that is configured to determine that a task schedule has been satisfied;

program code that is configured to open an application database and a user database based on the determination that the task schedule has been satisfied;

program code that is configured to load data from an external data source into the user database; and

program code that is configured to quit the user database.

12. The computer program product according to claim 11, further comprising program code that is configured to quit the user database using macro instructions and to quit the application database using the macro instructions.

13. The computer program product according to claim 11, wherein the program code that is configured to open the application database and the user database comprises:

program code that is configured to invoke a batch process from a task scheduler; and

program code that is configured to open the application database and the user database from the batch process.

14. The computer program product according to claim 13, wherein the program code that is configured to open the application database and the user database from the batch process comprises program code that is configured to open a Microsoft Access application database and a user database file.

15. The computer program product according to claim 11, wherein the program code that is configured to load data from an external data source into the user database comprises:

program code that is configured to remove data from predefined fields in the user database; and

program code that is configured to load data from the external data source into at least some of the predefined fields.

16. A data processing system comprising:

an application database that is configured to access a user database;

a user database that comprises data fields;

a data source that is external to the application database and the user database, and that comprises data;

a macro that is configured to load data from the data source through the application database into the user database, and that is configured to quit the user database;

a batch process that is configured to open the application database, and is configured to open the user database, and is configured to initiate the macro; and

a scheduler that is configured to invoke the batch process when a task schedule has been satisfied.

17. The data processing system of claim 16, wherein the macro is configured to quit the application database.

18. The data processing system of claim 16, wherein the batch process is configured to load data from the data source into predefined fields of the user database.

19. The data processing system of claim 16, wherein the batch process is configured to quit the user database and to quit the application database after data is loaded from the data source into the user database.

20. The data processing system of claim 16, wherein the batch process is configured to open the user database with a pointer to the macro to be executed by the application database.