System and method of mapping database fields to a knowledge base using a graphical user interface

• US 6,408,302 B1
• Filed: 06/28/1999
• Issued: 06/18/2002
• Est. Priority Date: 06/28/1999
• Status: Expired due to Term

• Current Assignee: Aspect Software Incorporated
• Original Assignee: Davox Corporation (Aspect Software Incorporated)
• Inventors: Subramanian, Srikanth, Lee, Gene W.
• Primary Examiner(s): JUNG, DAVID YIUK
• Application Number:
  US09/344,875
• Time in Patent Office: 1,086 Days
• Field of Search: 707/1-206, 379/201-207, 709/310-332, 706/45-50
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system and method for mapping a plurality of data base fields from an arbitrary ODBC-compliant data base to a plurality of attributes in a knowledge base having a known data attribute format is provided. The system includes a data base selection interface displayed on a display associated with a system user. The data base selection interface is configured to allow a system user to select the data base to map to the knowledge base having a known data attribute format. The system also includes a data attribute mapping interface, which is also displayed on the system user display. The data attribute mapping interface is configured to display a plurality of data attributes included in the knowledge base and to allow the system user to select at least one data attribute to map to at least one data field in the arbitrary data base to be converted. Also included is an edit field mapping interface, which is also displayed on the system user display. The edit field mapping interface allows at least one selected data attribute to be displayed and allows the system user to select a data base field to map to each displayed data attribute. Finally, the system includes a data map memory for storing the mapped data base fields.

Claims

1. An automated system for mapping a plurality of database fields from an arbitrary ODBC-compliant database to a plurality of attributes in a knowledge base having a known data attribute format for use in a computer system, said automated database mapping system comprising:

a database selection interface displayed on a system user display, said database selection interface for allowing a system user to select a database to map to said knowledge base having said known data attribute format;

a data attribute mapping interface displayed on said system user display, said data attribute mapping interface for displaying a plurality of data attributes included in said knowledge base and to allow said system user to select at least one displayed data attribute to map to at least one data field in said arbitrary database;

an edit field mapping interface displayed on said system user display, said edit field mapping interface configured to display said at least one selected data attribute and to allow said system user to select a database field to map to each said displayed data attribute; and

data map memory for storing each of said database fields mapped to each said data attribute.

2. The system of claim 1 further comprising a lookup processor, responsive to a call for data associated a data attribute associated with said knowledge base of known data format, for searching said data map memory, identifying said database field mapped to said data attribute and retrieving data included in said database field mapped to data attribute.

3. The system of claim 1, wherein said computer system comprises a computer telephony integration (CTI) system.

4. The system of claim 1, wherein said data attribute mapping interface displayed on said system user display is further configured to display at least one database field mapped to said at least one displayed data attribute.

5. The system of claim 1, wherein said database selection interface further comprises at least one data field for receiving additional information in order to access said database.

6. The system of claim 5, wherein said additional information input includes a connect string.

7. The system of claim 5, wherein said additional information input includes a user ID.

8. The system of claim 5, wherein said additional input includes a password.

9. The system of claim 1, wherein edit field mapping interface includes an attribute label input for allowing said system user to assign a description to an attribute.

10. The system of claim 1 further including a data formatter for formatting data into a specified knowledge base format.

11. An automated method for mapping a plurality of database fields from an arbitrary ODBC-compliant database to a plurality of attributes in a knowledge base having a known data attribute format, said method comprising the steps of:

providing a database selection interface on a display associated with a system user, said database selection interface displaying at least one user-selectable database to map to said knowledge base having said known data attribute format;

selecting a database to map to said knowledge base from said at least one user-selectable database displayed on said database selection interface;

providing a data attribute mapping interface on said system user display, said data attribute mapping interface displaying a plurality of data attributes included in said knowledge base;

selecting at least one displayed data attribute to map to at least one data field in said arbitrary database;

providing an edit field mapping interface on said system user display, said edit field mapping interface displaying said at least one selected data attribute;

selecting a database field to map to each said displayed data attribute; and

storing each said database field mapped to each said data attribute in a data map memory.