Telephone/transaction entry device and system for entering transaction data into databases

• US 5,987,103 A
• Filed: 08/11/1997
• Issued: 11/16/1999
• Est. Priority Date: 05/19/1995
• Status: Expired due to Term

• Current Assignee: CyberFone Systems LLC (Marathon Patent Group, Inc.)
• Original Assignee: Cyberfone Technologies Incorporated
• Inventors: Martino, Rocco L.
• Primary Examiner(s): Kuntz, Curtis A.
• Assistant Examiner(s): RAMAKRISHNAIAH, MELUR
• Application Number:
  US08/909,408
• Time in Patent Office: 827 Days
• Field of Search: 379/93.17, 379/93.25, 379/93.01, 379/88.18, 395/200.31, 395/200.33, 364/400, 348/13, 348/14, 381/110
• US Class Current: 379/93.17
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 9/466 Transaction processing
• CPC Class Codes: G06Q 20/00 Payment architectures, schemes or protocols apparatus for performing or posting payment transactions G07F7/08, G07F19/00; electronic cash registers G07G1/12
• CPC Class Codes: G06Q 20/04 Payment circuits
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 20/305 using wired telephone networks
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46
• CPC Class Codes: H04L 67/289 Intermediate processing functionally located close to the data consumer application, e.g. in same machine, in same home or in same sub-network
• CPC Class Codes: H04L 67/56 Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54
• CPC Class Codes: H04L 67/564 Enhancement of application control based on intercepted application data
• CPC Class Codes: H04L 67/566 Grouping or aggregating service requests, e.g. for unified processing
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols
• CPC Class Codes: H04M 3/493 Interactive information services, e.g. directory enquiries ; Arrangements therefor, e.g. interactive voice response [IVR] systems or voice portals
• CPC Class Codes: H04M 3/533 Voice mail systems
• CPC Class Codes: H04N 7/147 Communication arrangements, e.g. identifying the communication as a video-communication, intermediate storage of the signals selecting H04Q
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A data transaction processing system in which transaction data is entered by the user in response to prompts in a template which is tailored to each user application. The template and entered data are accumulated into data transactions which are immediately transmitted upon completion to an external database server for processing and storage. The data transactions are not locally stored for processing, and no conventional operating system is necessary. No local processing needs to be provided, and the only local storage is a flash PROM which stored the control firmware, a flash memory which stores the data streams making up the forms and menus, and a small RAM which operates as an input/output transaction buffer for storing the data streams of the template and the user replies to the prompts during assembly of a data transaction. The data transaction is received via standard protocols at a database server which, depending upon the application, stores the entire data transaction, explodes the data transaction to produce ancillary records which are then stored, and/or forwards the data transaction or some or all of the ancillary records to other database servers for updating other databases associated with those database servers. Also, in response to requests from the transaction entry device, the database server may return data streams for use in completing the fields in the data transaction or in presenting a menu on the display which was read in from the database server or a remote phone mail system. The transaction entry device is integrated with a telephone and is accessed via a touch screen, an optional keyboard, a magnetic card reader, voice entry, a modem, and the like.

Claims

1. A system for entering transaction data into a remote database, comprising:

a data input device;

a display;

a data transaction terminal including a microprocessor, a form memory, and a form driven operating system which controls said microprocessor to present to said display at least one form stored in said form memory as data streams, said form eliciting data input of a desired transaction type into said data input device by a user, said at least one form including at least one prompt customized to said desired transaction type, said data transaction terminal further including means for formatting at least said data input by said user in response to said at least one prompt into a data transaction for transmission to said remote database; and

a database server associated with said remote database which receives said data transaction, creates from said data transaction, depending on said desired transaction type, at least one additional data transaction containing data for a particular record in said remote database, and stores said at least one additional data transaction in said particular record.

2. A system as in claim 1, further comprising a plurality of remote databases, wherein said database server further creates from said data transaction, depending on said desired transaction type, at least one ancillary data transaction containing data for a particular record in one of said plurality of remote databases besides said remote database and stores said at least one ancillary data transaction in said particular record.

3. A system as in claim 2, wherein said form driven operating system includes means for sending a data request to said database server, said database server accessing data corresponding to said data request in at least one of said remote databases and returning one of data responsive to said data request, a list of options for selection by said user, a value calculated from data contained in said data request, and a data report.

4. A system as in claim 1, wherein said form driven operating system comprises a transaction assembly server (TAS) which presents said data streams to said microprocessor for display on said display, and said formatting means comprising a transaction buffer which stores said data input in to said data input device by said user in response to said at least one prompt until said data transaction is completed for transmission to said remote database.

5. A system as in claim 4, wherein said data transaction terminal further comprises a modem, a telephone and two telephone line connections, one for connecting said telephone to a telephone network, and one for providing a modem connection among said modem, said TAS, and said database server.

6. A system as in claim 5, wherein said data transaction terminal further comprises a mode switch for selecting a telephone mode in which said data transaction terminal operates exclusive of said TAS or a transaction entry mode in which said TAS operates exclusive of said telephone.

7. A system as in claim 4, wherein said data transaction terminal further comprises a modem, a telephone, a telephone line connection, and means for selectively connecting said telephone to a telephone network and said TAS to said database server via said telephone line connection.

8. A system as in claim 7, wherein said selectively connecting means comprises a mode switch for selecting a telephone mode in which said data transaction terminal operates exclusive of said TAS or a transaction entry mode in which said TAS operates exclusive of said telephone.

9. A system as in claim 1, wherein said database server comprises a modem, a data transaction queue for storing data transactions received from said data transaction terminal, and a transaction controller which processes the received data transactions to extract physical relationships of data of said data transactions with records in said remote database.

10. A system as in claim 1, wherein said form memory further stores a plurality of menus for presentation to said user, said user selecting options from one of said menus using said data input device for navigating to said at least one form.

11. A system as in claim 10, wherein said one menu provides said user with an option of selecting at least one of said at least one form, another menu, and a process for processing data in a data transaction.

12. A system as in claim 11, wherein said one menu further contains a remote process option, and when said user selects said remote process option from said one menu, data streams are downloaded via a modem to said form memory, said data streams containing control data for implementing functions designated by said selected remote process option.

13. A system as in claim 12, wherein said data transaction terminal further comprises an infrared transceiver and said control data comprises data for controlling a wavelength of energy emitted by said infrared transceiver.

14. A system as in claim 12, wherein said data transaction terminal further comprises a phone list memory for storing a phone list and said control data comprises data for updating said phone list.

15. A system for entering transaction data into a plurality of remote databases, comprising:

a data transaction terminal for capturing a data transaction having a one-to-many relationship to records of said plurality of remote databases, said data transaction terminal including a microprocessor, a form memory, and a form driven operating system which controls said microprocessor to present to a user at least one form stored in said form memory as data streams, said form eliciting data input of a desired transaction type into said data transaction terminal by said user, said at least one form including at least one prompt customized to said desired transaction type, said data transaction terminal further including means for formatting at least said data input by said user in response to said at least one prompt into said data transaction for transmission to at least one of said plurality of remote databases;

a first set of database servers associated with a first set of remote databases of said plurality of remote databases, said first set of database servers receiving said data transaction, creating from said data transaction a plurality of ancillary data transactions having a one-to-one relationship to said records of said plurality of remote databases, and storing said ancillary data transactions in designated records of said first set of remote databases; and

a second set of database servers associated with a second set of remote databases of said plurality of remote databases, said second set of database servers receiving certain of said plurality of ancillary data transactions, and creating from said certain ancillary data transactions additional data transactions which are stored in application specific records of said second set of remote databases in accordance with said desired transaction type of said at least one form.

16. A system as in claim 15, wherein each database server of said first and second set of database servers comprises a modem, a data transaction queue for storing data transactions, and a transaction controller which processes a received data transaction to extract physical relationships of data of said data transactions with records of a remote database associated with said each database server.

17. A system as in claim 15, wherein said data particular to said desired transaction type includes at least one of audio and video data.

18. A data transaction terminal for providing data transactions to a remote database server which stores records in an associated database, comprising:

a data input device;

a display;

a telephone circuit;

a data transaction assembler including a microprocessor, a form memory, and a form driven operating system which controls said microprocessor to present to a user at least one form stored in said form memory as data streams, said form eliciting data input of a desired transaction type into said data transaction assembler by said user, said at least one form including at least one prompt customized to said desired transaction type, and means for formatting at least said data input by said user in response to said at least one prompt into a data transaction for transmission to said remote database server; and

a mode switch for selectively connecting said telephone circuit to a telephone network in a telephone mode and said data transaction assembler to said remote database server in a data transaction entry mode.

19. A terminal as in claim 18, wherein said form driven operating system comprises a transaction assembly server (TAS) which presents said data streams to said microprocessor for display on said display, and said formatting means comprising a transaction buffer which stores said data input into said data input device by said user in response to said at least one prompt until said data transaction is completed for transmission to said remote database.

20. A terminal as in claim 19, wherein said TAS presents one of said menus to said user for selection, said one menu containing pointers to a plurality of forms, and upon selection of said at least one form from said menu by said user, said TAS initializes said transaction buffer and presents said at least one form to said display on a page by page basis for entry of said input data by s aid user.

21. A terminal as in claim 19, wherein said form memory further stores a plurality of menus for presentation to said user, said user selecting options from one of said menus using said data input device for navigating to said at least one form.

22. A terminal as in claim 21, wherein said one menu provides said user with an option of selecting at least one of said at least one form, another menu, and a process for processing data in a data transaction.

23. A terminal as in claim 22, wherein said one menu further contains a remote process option, and when said user selects said remote process option from said one menu, data streams are downloaded via a modem to said form memory, said data streams containing control data for implementing functions designated by said selected remote process option.

24. A terminal as in claim 23, further comprising an infrared transceiver, said control data comprising data for controlling a wavelength of energy emitted by said infrared transceiver.

25. A terminal as in claim 23, further comprising a phone list memory for storing a phone list, said control data comprising data for updating said phone list.

26. A terminal as in claim 18, furt her comprising a modem and two telephone line connections, one for connecting said telephone circuit to said telephone network, and one for providing a modem connection among said modem, said TAS, and said remote database server.

27. A terminal as in claim 18, further comprising a modem and a telephone line connection, said mode switch selectively connecting said telephone and said TAS to said telephone line connection.

28. A terminal as in claim 18, wherein said TAS processes said input data as it is entered in response to each prompt to determine if said input data satisfies predetermined conditions for input data entered in response to each said prompt.

29. A terminal as in claim 18, wherein said TAS sends a data request to said remote database server when said user requests assistance in replying to a prompt and inserts reply data from said remote database server into said data transaction in response to said prompt.

30. A terminal as in claim 18, wherein said TAS comprises means for creating from said data transaction, depending on said desired transaction type, at least one ancillary data transaction containing data for a particular record in said associated database and storing said at least one ancillary data transaction in said particular record in said associated database.

31. A terminal as in claim 30, wherein said ancillary data transaction creating means further creates from said data transaction, depending on said desired transaction type, an ancillary data transaction containing data for an application specific record in a secondary database and sends said ancillary data transaction to said secondary database for storage of said ancillary data transaction in said application specific record.

32. A terminal as in claim 18, wherein said data transaction assembler includes means for sending a data request to said remote database server, said remote database server accessing data corresponding to said request in said associated database and returning one of data responsive to said request, a list of options for selection by said user, a value calculated from data contained in said data request, and a data report.

33. A terminal as in claim 32, wherein said remote database server is a remote phone mail system and said telephone circuit makes a telephone connection to said remote phone mail system, said data request being sent via said telephone connection and including a request for a visual representation of navigation options of a phone mail menu of said remote phone mail system, and, in response to said data request, said remote phone mail system returning via said telephone connection a data stream containing said visual representation of said navigation options of said phone mail menu, said visual representation of said navigation options of said phone mail menu being presented to said display by said data transaction assembler for selection by said user using said data input device, and said data transaction assembler further sending data to said remote phone mail system via said telephone connection indicating which navigation option was selected from said phone mail menu by said user.

34. A terminal as in claim 33, wherein said remote phone mail system returns a data stream containing a visual representation of navigation options of a next phone mail menu via said telephone connection in response to said data indicating which navigation option was selected from said phone mail menu by said user.

35. A terminal as in claim 18, wherein said data input device comprises at least one of a touch screen associated with said display, a telephone numeric keypad, an alphanumeric keyboard, a memory card reader, and a magnetic card reader.

36. A terminal as in claim 35, wherein said alphanumeric keyboard comprises a retractable keyboard which retracts into a housing of said data transaction terminal.

37. A terminal as in claim 18, further comprising a video input terminal for receiving input video data and a video output terminal for providing output video data to a video monitor.

38. A terminal as in claim 37, further comprising a data compression circuit for compressing said input video data prior to including said input video data in a data transaction and a data decompression circuit for decompressing output video data prior to display on said video monitor.

39. A terminal as in claim 18, further comprising a computer I/O port for receiving input data from a computer device and providing output data to at least one of said computer device and a printer.

40. A terminal as in claim 18, further comprising a RF transceiver for providing a wireless connection between said data transaction terminal and a data processing device.

41. A terminal as in claim 18, further comprising a battery for providing power to said data transaction terminal for portable operation.

42. A terminal as in claim 18, wherein said data input device comprises a voice recognition circuit for accepting data input selections annunciated by said user.

43. A terminal as in claim 18, further comprising a voice synthesizer responsive to said data transaction for audibilizing a portion of said data transaction to said user.

44. A terminal as in claim 43, further comprising a voice recorder for recording at least one of said audibilized portion of said data transaction when in said data transaction entry mode and voice input from a called party when in said telephone mode.

45. A method of entering transaction data into a remote database using a data transaction terminal, comprising the steps of:

loading from a remote database server at least one predetermined form including at least one prompt customized to a desired transaction type into a form memory of a form driven operating system of said data transaction terminal, said form driven operating system controlling a microprocessor of said data transaction terminal to accept input data of said desired transaction type from a user;

said form driven operating system presenting to a display said at least one predetermined form for eliciting data input of said desired transaction type from said user;

said user inputting data in response to said at least one prompt using a data input device;

formatting at least said input data from said user into a data transaction for transmission to said remote database; and

transmitting said data transaction to said remote database.

46. A method as in claim 45, comprising the additional steps of:

receiving said data transaction at said remote database;

creating from said data transaction, depending on said desired transaction type, at least one additional data transaction containing data for a particular record in said remote database; and

storing said at least one additional data transaction in said particular record.

47. A method as in claim 46, comprising the additional steps of:

creating from said data transaction, depending on said desired transaction type, at least one ancillary data transaction containing data for a particular record in an ancillary database different from said remote database; and

storing said at least one ancillary data transaction in said particular record in said ancillary database.

48. A method as in claim 45, comprising the additional steps of:

sending a data request to a database server of said remote database; and

said database server accessing data corresponding to said data request in said remote database and returning one of data responsive to said data request, a list of options for selection by said user, a value calculated from data contained in said data request, and a data report.

49. A method as in claim 45, comprising the additional steps of:

storing a plurality of menus for presentation to said user; and

said user selecting said at least one form from one of said menus using said data input device.

50. A terminal for displaying navigation options of a phone mail menu of a remote phone mail system on a local display, comprising:

a telephone circuit for making a telephone connection to said remote phone mail system;

control means for sending a request for a visual representation of said navigation options of said phone mail menu via said telephone connection, for receiving a data stream containing said visual representation of said navigation options of said phone mail menu from said remote phone mail system via said telephone connection, and for presenting said visual representation of said navigation options of said phone mail menu to said local display; and

selection means for selecting a navigation option from said navigation options of said phone mail menu displayed on said local display and for instructing said control means to send data to said remote phone mail system via said telephone connection indicating which navigation option was selected from said phone mail menu.

51. A terminal as in claim 50, wherein said remote phone mail system returns a data stream containing a visual representation of navigation options of a next phone mail menu via said telephone connection in response to said data indicating which navigation option was selected from said phone mail menu.

52. A method of displaying navigation options of a phone mail menu of a remote phone mail system on a local display, comprising the steps of:

establishing a telephone connection to said remote phone mail system;

sending a request for a visual representation of said navigation options of said phone mail menu via said telephone connection;

receiving a data stream containing said visual representation of said navigation options of said phone mail menu from said remote phone mail system via said telephone connection;

presenting said visual representation of said navigation options of said phone mail menu to said local display;

selecting a navigation option from said navigation options of said phone mail menu displayed on said local display; and

sending data to said remote phone mail system via said telephone connection indicating which navigation option was selected from said phone mail menu.

53. A method as in claim 52, wherein said remote phone mail system further returns a data stream containing a visual representation of navigation options of a next phone mail menu via said telephone connection in response to said data indicating which navigation option was selected from said phone mail menu.