System and method to acquire information from a database

• US 20040181513A1
• Filed: 03/11/2003
• Published: 09/16/2004
• Est. Priority Date: 03/11/2003
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Henderson, Daniel L., Lieberman, Elliott B., Soemeri, Deni S., Freschl, Charles M.
• Granted Patent: US 8,868,553 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A system and method to retrieve information is disclosed. The system may include a processor to run a query application to retrieve selected information from one or more databases. The query application may include a client layer and a presentation layer to interface with the client layer. A database access layer may be provided and an interface layer may be provided to interface between the presentation layer and the database access layer.

Claims

1. A system to retrieve information, comprising:

a processor to run a query application to retrieve selected information from one or more databases, wherein the query application includes;

a client layer,

a presentation layer to interface with the client layer,

a database access layer, and

an interface layer to interface between the presentation layer and the database access layer.

2. The system of claim 1, wherein the client layer comprises a structure to at least one of validate search parameters entered by a user, dynamically adjust predetermined search selection options in response to one or more search parameters previously entered by the user and retain a history of a prior set of search parameter entered by the user.

3. The system of claim 1, wherein the presentation layer comprises a structure to define at least one input query form page for a user to enter different search parameters and at least one output page to present search results to the user in response to the search parameters.

4. The system of claim 3, wherein the at least one input query page and the at least one output page are configurable for different users.

5. The system of claim 1, wherein the interface layer comprises a structure to form links to selected information in the one or more databases in response to search parameters entered by a user.

6. The system of claim 1, wherein the interface layer comprises a plurality of data objects to execute a search of the one or more databases in response to search parameters entered by a user in the presentation layer and to form a structure to display search results.

7. The system of claim 1, wherein the interface layer comprises a JavaBean layer.

8. The system of claim 7, wherein the JavaBean layer comprises a plurality of Java Server Pages (.jsp'"'"'s) that execute a search of the one or more databases in response to search parameters entered by a user and create hypertext mark-up language (HTML) structures displayable by a browser.

9. The system of claim 1, wherein the database access layer comprises a structure and objects to form a structured query language (SQL) query in response to search parameters entered by a user, to access selected ones of a plurality of tables in the one or more databases corresponding to the SQL query, and to retrieve information corresponding to the SQL query.

10. The system of claim 9, wherein the database access layer comprises a structure and objects to establish links between data in the selected ones of the plurality of tables related to the SQL query.

11. The system of claim 1, further comprising an Internet type server to interface between a browser and the processor.

12. The system of claim 1, wherein the query application comprises a transaction query application to retrieve information related to financial transactions.

13. The system of claim 12, wherein the one or more databases each comprise a plurality of relational transaction message tables.

14. The system of claim 12, further comprising a user logon page presentable to a user in response to a browser accessing the transaction query application.

15. The system of claim 12, further comprising a transaction query page displayable on a display and generable by operation of the transaction query application on the processor in response to a user accessing the transaction query application.

16. The system of claim 15, wherein the transaction query page comprises a plurality of fields presentable to a user to enter transaction search parameters.

17. The system of claim 16, wherein the transaction query page comprises at least fields presentable to the user to enter a type of money transfer system and a transaction date.

18. The system of claim 17, wherein the transaction query page further comprises fields presentable to the user to enter at least one of a transaction number, a transaction amount, a transaction direction, input message accountability data for any messages sent from a bank to the Federal Reserve (FED IMAD INBOUND), an input message sequence number for any messages received from the Federal Reserve (FED ISN INBOUND), an input sequence message number for any messages sent from a bank to the Federal Reserve (FED ISN OUTBOUND), a clearing house interbank payment system (CHIPS) message sequence number (CHP SSN) and account information.

19. The system of claim 16, further comprising a transaction summary page generable by operation of the transaction query application on the processor and displayable to the user including selected transaction data retrieved from the one or more databases for each transaction corresponding to the search parameters entered by the user on the transaction query page.

20. The system of claim 19, wherein the selected transaction information comprises a transaction reference number, a message source indicator, a message direction indicator, an activity type indicator, an advice type indicator, a credit identification indicator, a type of currency indicator and an amount of the wire transfer for each transaction.

21. The system of claim 19, further comprising a transaction detail page generable by operation of the transaction query application on the processor to present transaction data for a single transaction generated in response to only one transaction matching the search parameters entered on the transaction query page or in response to a user selecting one transaction from a plurality of transactions listed on the transaction summary page.

22. The system of claim 21, wherein the transaction data presented on the transaction detail page comprises debit information and credit information.

23. The system of claim 21, further comprising a transaction text page generable by operation of the transaction query application on the processor to present a text message stream of the single transaction.

24. The system of claim 21, further comprising a transaction history page generable by operation of the transaction query application on the processor to present a list of operations by a money transfer system in conducting the transaction.

25. The system of claim 21, further comprising a transaction destination page generable by operation of the transaction query application on the processor to present how a notice of funds transfer was delivered.

26. The system of claim 12, wherein the selected information comprises wire transfer data for any transactions corresponding to a query.

27. A system to retrieve information, comprising:

an application server;

an Internet type server to interface between a browser and the application server, wherein the Internet type server is other than a common gateway server; and

a query application to run on the application server.

28. The system of claim 27, wherein the query application comprises:

a client layer;

a presentation layer to interface with the client layer;

a database access layer; and

an interface layer to interface between the presentation layer and the database layer.

29. The system of claim 28, wherein the client layer comprises a structure to at least one of validate search parameters entered by a user, dynamically adjust predetermined search selection options in response to one or more search parameters previously entered by the user and retain a history of a prior set of search parameter entered by the user.

30. The system of claim 28, wherein the presentation layer comprises a structure to define at least one input query form page for a user to enter different search parameters and at least one output page to present search results to the user in response to the search parameters.

31. The system of claim 30, wherein the at least one input query page and the at least one output page are configurable for different applications.

32. The system of claim 28, wherein the interface layer comprises a structure to create links to selected information in the one or more databases in response to search parameters entered by a user.

33. The system of claim 28, wherein the database access layer comprises a structure and objects to form a structured query language (SQL) query in response to search parameters entered by a user, to access selected ones of a plurality of tables in the one or more databases corresponding to the SQL query, and to retrieve information corresponding to the SQL query.

34. The system of claim 33, wherein the database access layer comprises a structure and objects to establish links between data in the selected ones of the plurality of tables related to the SQL query.

35. The system of claim 27, further comprising at least one username table.

36. The system of claim 27, wherein the query application is for retrieving transaction query information from one or more transactional databases.

37. A method to retrieve information, comprising:

presenting an input query page to a user to enter different search parameters;

forming a query data object in response to the search parameters entered by the user;

executing a search of one or more databases based on the query data object; and

presenting results of the search to the user.

38. The method of claim 37, further comprising creating links to selected information in the one or more databases in response to the search parameters entered by the user.

39. The method of claim 37, further comprising:

validating the search parameters entered by the user; and

alerting the user in response to entry of an invalid search parameter.

40. The method of claim 37, further comprising dynamically adjusting predetermined search selection options in a query form page in response to one or more search parameters previously entered by the user.

41. The method of claim 37, further comprising notifying the user if a consolidated database is available to reduce search time.

42. The method of claim 37, further comprising:

forming a structured query language (SQL) query in response to the search parameters entered by the user;

accessing selected ones of a plurality of tables in the one or more databases corresponding to the SQL query; and

retrieving information corresponding to the SQL query.

43. The method of claim 42, further comprising establishing links between data in the selected ones of the plurality of tables related to the SQL query.

44. The method of claim 37, further comprising accessing a query application on an application server using a browser.

45. The method of claim 37, further comprising presenting a user logon page to the user in response to a browser accessing a query application.

46. The method of claim 37, further comprising accessing a transaction query application to retrieve information related to financial transactions.

47. The method of claim 46, wherein presenting results of the search comprises presenting a transaction summary page including selected transaction information retrieved from the one or more databases for each transaction corresponding to the search parameters entered by the user on the input query page.

48. The method of claim 46, further comprising presenting a transaction detail page for a single transaction in response to only one transaction matching the search parameters or in response to a user selecting one transaction from a plurality of transactions listed on the transaction summary page.

49. The method of claim 48, further comprising providing links between the transaction summary page, the transaction detail page, a transaction history page, a transaction text page, and a transaction destination page.

50. A method to retrieve information, comprising:

accessing a query application on a processor to retrieve selected information from one or more databases, wherein the query application includes;

a client layer;

a presentation layer to interface with the client layer; and

a database access layer.

51. The method of claim 50, wherein an interface layer interfaces between the database layer and the presentation layer.

52. The method of claim 50, wherein accessing the query application comprises directing a browser to the query application

53. The method of claim 50, further comprising:

presenting an input query page to a user to enter different search parameters;

forming a query data object in response to the search parameters entered by the user;

executing a search of one or more databases based on the query data object; and

presenting results of the search to the user.

54. A computer-readable medium having computer-executable instructions for performing a method, comprising:

presenting an input query page to a user to enter different search parameters;

forming a query data object in response to the search parameters entered by the user;

executing a search of one or more databases based on the query data object; and

presenting results of the search to the user.

55. The computer-readable medium having computer-executable instructions for performing the method of claim 54, further comprising:

validating the search parameters entered by the user; and

alerting the user in response to entry of an invalid search parameter.

56. The computer-readable medium having computer-executable instructions for performing the method of claim 54, further comprising dynamically adjusting predetermined search selection options in a query form page in response to one or more search parameters previously entered by the user.

57. The computer-readable medium having computer-executable instructions for performing the method of claim 54, further comprising:

forming a structured query language (SQL) query in response to the search parameters entered by the user;

accessing selected ones of a plurality of tables in the one or more databases corresponding to the SQL query; and

retrieving information corresponding to the SQL query.

58. The computer-readable medium having computer-executable instructions for performing the method of claim 54, further comprising accessing a query application on an application server using a browser.

59. The computer-readable medium having computer-executable instructions for performing the method of claim 58, wherein the query application comprises:

a client layer;

a presentation layer to interface with the client layer; and

a database access layer.

60. The computer-readable medium having computer-executable instructions for performing the method of claim 58, wherein the query application comprises a transaction query application to retrieve transaction information.