Systems and methods for platform-independent data file transfers

• US 9,128,946 B2
• Filed: 06/23/2008
• Issued: 09/08/2015
• Est. Priority Date: 12/31/2007
• Status: Active Grant

• Current Assignee: Mastercard International Incorporated (MasterCard Incorporated)
• Original Assignee: Mastercard International Incorporated (MasterCard Incorporated)
• Inventors: McGeehan, Thomas
• Primary Examiner(s): Trujillo, James
• Assistant Examiner(s): CHEUNG, HUBERT G
• Application Number:
  US12/143,897
• Publication Number:
  US 20090171972A1
• Time in Patent Office: 2,633 Days
• Field of Search: 707/609
• US Class Current: 1/1
• CPC Class Codes: G06F 16/16 File or folder operations, e.g. details of user interfaces specifically adapted to file systems

Abstract

Systems and methods for storing data files to a file system coupled to a database, and reading data files from the file system. In one aspect, a method for transferring a data file between a client system and a server system is provided. The client executes a first computer operating system and the server executes a second computer operating system, includes a file system, and is coupled to a database. The method includes receiving, by the database, a request to store the data file, wherein the request is transmitted to the database by a software application associated with the client. The method also includes receiving the data file from the client, storing the data file in a directory in the server file system, storing a path for the directory in the database, and outputting one of a success code and a failure code to the client.

Claims

1. A method for transferring a data file between a client system and a server system, the server system having a file system, a database system, and a memory component, wherein the database system includes a database and provides the client system with access to the file system, wherein the client system executes a first computer operating system and the server system executes a second computer operating system, the method comprising:

receiving, by the database system, a request to store the data file, the request transmitted by a software application associated with the client system;

receiving, by the database system, the data file from the client system;

using the database system to store the data file in the memory component within the server system;

transferring the data file from the memory component within the server system to a destination directory included within the server file system, including declaring a Character Large Object (CLOB) variable and reading a first line of characters of the data file from the memory component;

storing within the database a directory path to the destination directory, the directory path providing a record of the destination directory within the server file system in which the data file has been stored; and

using the database system to output a success code to the client system if the data file is successfully stored in the destination directory, the success code indicates that the data file was successfully stored in the destination directory.

2. The method in accordance with claim 1 further comprising creating a plurality of directories within the server file system, wherein the directory in which the data file is stored is one of a selected directory and a default directory.

3. The method in accordance with claim 1 wherein the data file includes a plurality of character lines, storing the data file in the destination directory included within the server file system further comprises sequentially storing each line of the plurality of character lines into the directory by:

setting the CLOB variable equal to the first line of characters;

copying the CLOB variable contents into the directory; and

determining whether the data file contains additional lines.

4. The method in accordance with claim 1 wherein the server system comprises a first server and a second server, and wherein storing the data file in the memory within the server system comprises storing the data file in a temporary memory included within the first server.

5. The method in accordance with claim 4 wherein copying the data file into a destination directory comprises transmitting the received data file from the first server to the second server and storing the received data file in a memory of the second server.

6. The method in accordance with claim 4 further comprising:

receiving, by the database system, a request to transmit the data file to the client system;

searching for the destination directory included within the server file system associated with the data file;

opening the data file within the destination directory;

transmitting data from the data file into the memory component of the first server;

storing the data from the data file in the memory of the first server; and

transmitting the data file from the first server to the client system.

7. The method in accordance with claim 6 wherein the data file includes a plurality of character lines, and wherein storing data from the data file in the memory component of the first server comprises sequentially storing each line of the plurality of character lines into the memory component by:

accessing the data file stored in the destination directory;

declaring a Character Large Object (CLOB) variable;

setting the CLOB variable equal to each line;

copying the CLOB variable contents into the memory component; and

determining whether the data file contains additional lines.

8. The method in accordance with claim 6 wherein the client system is a first client system of a plurality of client systems, and wherein transmitting the data file from the first server to the client system comprises transmitting the data file to a second client system of the plurality of client systems, wherein the second client system executes a third computer operating system that is different than the first computer operating system executed by the first client system.

9. The method in accordance with claim 8 wherein transmitting the data file to a second client system comprises transmitting the data file to the second client system, wherein the second client is associated with a software application that is written in a different programming language than the language of the software application associated with the first client system.

10. The method in accordance with claim 6 further comprising:

receiving, by the database system, an identifier associated with the request to transmit the data file; and

retrieving from the database system the destination directory of the data file using at least the identifier.

11. The method in accordance with claim 4 wherein the second computer operating system executed by at least one of the first server and the second server is different than the first computer operating system executed by the client system.

12. The method in accordance with claim 1 wherein receiving, by the database system, the data file from the client system comprises receiving at least one of an image file, an audio file, and a multimedia file.

13. The network-based system in accordance with claim 12 wherein the database system is further configured to:

store the received data file in the memory component of the first server;

transmit the received data file from the first server to the second server; and

store the data file in the destination directory within the file system of the second server using the CLOB variable.

14. The network-based system in accordance with claim 13 wherein the database system is further configured to:

receive a request to transmit the data file to a client of the plurality of clients;

access the data file stored in the destination directory within the second server;

declare a Character Large Object (CLOB) variable in the database;

set the CLOB variable equal to each line;

copy the CLOB variable contents into the memory component of the first server;

determine whether the data file contains additional lines; and

transmit the data file to the client from the memory component.

15. The method in accordance with claim 1 wherein the database system includes a table, the table including a column for storing directory paths, wherein storing within the database a directory path to the destination directory further comprises storing the directory path within the table.

16. A network-based system for performing platform independent data file transfers, the system comprising:

a plurality of client systems comprising a first client and a second client, wherein the first client executes a first computer operating system and is associated with a software application written in a first programming language, the second client executes a second computer operating system and is associated with a software application written in a second programming language; and

a server system comprising a file system, a memory component, and a database system, the server system executes a third computer operating system and is configured to be coupled to the plurality of clients, the database system including a database and configured to provide the plurality of clients with access to the file system, the database system configured to;

receive, from the first client, a request to store a data file;

receive the data file from the first client;

store the data file in the memory component;

transfer the data file from the memory component within the server system to a destination directory included within the server file system, wherein the database system is further configured to declare a Character Large Object (CLOB) variable and read a first line of characters of the data file from the memory component;

store within the database a path for the destination directory, the directory path providing a record of the destination directory within the server file system in which the data file has been stored; and

output a success code to the first client if the data file is successfully stored in the destination directory, the success code indicating that the data file was successfully stored in the destination directory.

17. The network-based system in accordance with claim 16 wherein the database is further configured to create a plurality of directories within the file system, wherein the directory in which the data file is stored is one of a selected directory and a default directory.

18. The network-based system in accordance with claim 16 wherein the data file includes a plurality of character lines, the database system is further configured to:

set the CLOB variable equal to the first line of characters;

copy the CLOB variable contents into the destination directory; and

determine whether the data file contains additional lines.

19. The network-based system in accordance with claim 16 wherein the first computer operating system executed by the first client is different than at least one of the computer operating system executed by the second client and the third operating system executed by the server system.

20. The network-based system in accordance with claim 16 wherein the first programming language used to write the software application associated with the first client is different than the second programming language used to write the software application associated with the second client.

21. The network-based system in accordance with claim 16 wherein the server system comprises a first server and a second server, and wherein the memory component is included within the first server and the file system is included within the second server.

22. A computer coupled to a database system for performing platform independent data file transfers, the computer comprising a file system and a memory component, the computer in communication with a client, wherein the client executes a first computer operating system and the computer executes a second computer operating system, the database system comprising a database and configured to:

receive, from the client, a request to store a data file;

receive the data file from the client;

store the data file in the memory component;

transfer the data file from the memory component within the server system to a destination directory included within the server file system, wherein the database is further configured to declare a Character Large Object (CLOB) variable and read a first line of characters of the data file from the memory component;

store within the database a directory path to the destination directory, the directory path providing a record of the destination directory within the file system in which the data file has been stored; and

output a success code to the client if the data file is successfully stored in the destination directory, the success code indicating that the data file was successfully stored in the destination directory.

23. The computer in accordance with claim 22 wherein the database system is further configured to:

set the CLOB variable equal to the first line of characters in the data file stored in the memory component;

copy the CLOB variable contents into the destination directory; and

determine whether the data file contains additional lines.

24. The computer in accordance with claim 22 wherein the database system is further configured to:

receive a request to transmit the data file to the client;

access the data file stored in the destination directory;

declare a Character Large Object (CLOB) variable in the database;

set the CLOB variable equal to each line;

copy the CLOB variable contents into the memory component of the computer;

determine whether the data file contains additional lines; and

transmit the data file to the client from the memory component.

25. The computer in accordance with claim 24 wherein the client is a first client of a plurality of client systems, the computer is configured to transmit the data file to a second client of the plurality of client systems, wherein the first client executes the first computer operating system that is different from the second computer operating system executed by the computer, and wherein the second client executes a third operating system.

26. A non-transitory computer readable storage medium storing computer-executable instructions thereon for performing platform independent data file transfers between a client system and a server system that includes a file system, a database system, and a memory component, the database system including a database and configured to provide the client system with access to the file system, wherein the client system executes a first computer operating system and the server system operates a second computer operating system, wherein when executed by the server system, the computer-executable instructions cause the server system to cause the database system to:

receive a request to store a data file, the request transmitted by a software application associated with the client system;

receive the data file from the client system;

store the data file in the memory component within the server system;

transfer the data file from the memory component within the server system to a destination directory included within the server file system, wherein the computer-executable instructions further cause the server system to cause the database system to declare a Character Large Object (CLOB) variable and read a first line of characters of the data file from the memory component;

store a directory path for the destination directory, the directory path providing a record of the destination directory within the server file system in which the data file has been stored; and

output a success code to the client system if the data file is successfully stored in the destination directory, the success code indicating that the data file was successfully stored in the destination directory.

27. The non-transitory computer readable storage medium in accordance with claim 26 wherein said computer-executable instructions further cause the server system to cause the database system to:

store the data file in a memory of the server;

set the CLOB variable equal to a first line of characters in the data file stored in the memory component;

copy the CLOB variable contents into the destination directory; and

determine whether the data file contains additional lines.

28. The non-transitory computer readable storage medium in accordance with claim 26 wherein said computer-executable instructions further cause the server system to cause the database system to:

receive a request to transmit the data file to the client system;

access the data file stored in the destination directory;

declare a Character Large Object (CLOB) variable;

set the CLOB variable equal to each line;

copy the CLOB variable contents into the memory component of the server system;

determine whether the data file contains additional lines; and

transmit the data file to the client from the memory component.

29. The non-transitory computer readable storage medium in accordance with claim 26 wherein the client system includes a first client of a plurality of clients, wherein said computer-executable instructions further cause the server system to cause the database system to transmit the data file to a second client of the plurality of clients, wherein the first client executes the first computer operating system that is different from the second computer operating system executed by the server, and wherein the second client executes a third operating system.

30. A method for transferring a data file between a client system and a server system, the server system having a file system, a database system, and a memory component, wherein the database system includes a database and provides the client system with access to the file system, wherein the client system executes a first computer operating system and the server system executes a second computer operating system, the method comprising:

receiving, by the database system, a request to store the data file, the request transmitted by a software application associated with the client system;

receiving, by the database system, the data file from the client system;

using the database system to store the data file in the memory component within the server system;

transferring the data file from the memory component within the server system to a destination directory included within the server file system, including declaring a Character Large Object (CLOB) variable and reading a first line of characters of the data file from the memory component;

storing within the database a destination directory path and a file name, the destination directory path and the file name providing a record of a location within the server file system in which the data file has been stored; and

using the database system to output a success code to the client system if the data file is successfully stored in the destination directory, the success code indicates that the data file was successfully stored in the destination directory.