# US 7,613,717 B1 · Automated system for rating customer feedback > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 7,613,717 B1 - Document ID: US7613717B1 - Status: Granted - Kind: B1 - Application number: 10/055,828 - Filed: 2001-10-26 - Granted: 2009-11-03 - Earliest claimed: 2001-10-26 - Assignees: Teradata US, Inc. - Inventors: Michael L. Reed; Diane M. Wewerka - Web page: https://patentgrep.com/patent/US7613717B1 ## CPC - G06Q 30/02: Marketing; Price estimation or determination; Fundraising - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract A method and apparatus receives customer feedback and analyzes words in the customer feedback. The words in the customer feedback are compared to rating data to generate an indication to rate the customer feedback. The rating data associates predefined words with respective values. In one arrangement, the rating data is according to a user-defined data type (UDT) stored in a relational table. ## Claims ### Claim 1 A method executable by an automated system without requiring intervention by a human user, comprising: associating values with a plurality of predefined words; defining a user-defined data type having one or more data structures for storing said predefined words and associated values; invoking a first routine associated with the user-defined data type to load the predefined words and respective values in the one or more data structures; receiving from a client system customer feedback in the form of textual comments that originate with a human customer of an enterprise; comparing words in the customer feedback with said predefined words; invoking a second routine associated with the user-defined data type to calculate a score based on an identification of at least one word in the customer feedback as equivalent to one of said predefined words contained in the one or more data structures and the value of said equivalent one of said predefined words; presenting an indication to rate said customer feedback to a customer representative for said enterprise, said indication being based on said score. ### Claim 2 (depends on 1) The method of claim 1, wherein the one or more data structures comprise an array of the predefined words and associated values. ### Claim 3 (depends on 1) The method of claim 1, wherein invoking the first and second routines comprises invoking functions associated with the user-defined data type. ### Claim 4 (depends on 1) The method of claim 1, further comprising storing the one or more data structures in a first relational table. ### Claim 5 (depends on 4) The method of claim 4, further comprising storing customer feedback in a second relational table, wherein generating the score is based on performing a join of the first and second relational tables. ### Claim 6 (depends on 4) The method of claim 4, further comprising distributing the relational table across plural access modules. ### Claim 7 (depends on 1) The method of claim 1, wherein receiving the customer feedback comprises receiving the customer feedback in electronic mail. ### Claim 8 (depends on 1) The method of claim 1, wherein receiving the customer feedback comprises receiving customer-entered feedback at a web server. ### Claim 9 (depends on 1) The method of claim 1, wherein receiving the customer feedback comprises translating voice feedback to text feedback. ### Claim 10 (depends on 1) The method of claim 1, wherein receiving the customer feedback comprises receiving the customer feedback in a database system. ### Claim 11 An article comprising at least one storage medium containing instructions that when executed cause an automated system, without requiring intervention by a human user, to: cause the system to store rating data according to a user-defined data type having one or more data structures, the rating data associating a plurality of predefined words with respective values; invoke a first routine associated with the user-defined data type to load said plurality of predefined words and respective values in said one or more data structures; compare words in customer feedback received from a client system in the form of textual comments that originate with a human customer of an enterprise with said plurality of predefined words; invoke a second routine associated with the user-defined data type to calculate a score based on an identification of at least one word in the customer feedback as equivalent to one of said predefined words contained in the one or more data structures and the value of said equivalent one of said predefined words; and present an indication to rate said customer feedback to a customer representative for said enterprise, said indication being based on said score. ### Claim 12 (depends on 11) The article of claim 11, wherein the instructions when executed cause the system to generate the indication by generating an indication of customer satisfaction or dissatisfaction. ### Claim 13 (depends on 11) The article of claim 11, wherein the instructions when executed cause the system to generate the indication by generating an indication of customer approval or disapproval. ### Claim 14 (depends on 11) The article of claim 11, wherein the instructions when executed cause the system to generate the indication by generating an indication of customer emotion. ### Claim 15 (depends on 11) The article of claim 11, wherein the instructions when executed cause the system to store a negative value for a predefined word having a negative connotation and a positive value for a predefined word having a positive connotation in the rating data. ### Claim 16 (depends on 15) The article of claim 15, wherein the instructions when executed cause the system to store modifier values for adjectives to increase the positive and negative values of the words. ### Claim 17 (depends on 11) The article of claim 11, wherein the instructions when executed cause the system to load the rating data into a relational table. ### Claim 18 An automated system comprising: one or more storage modules to store rating data according to a user-defined data type having one or more data structures, the rating data associating a list of predefined words with respective values; and a controller adapted to: invoke a first routine associated with the user-defined data type to load said plurality of predefined words and respective values in said one or more data structures; compare words in customer feedback received from a client system in the form of textual comments that originate with a human customer of an enterprise with said plurality of predefined words; invoke a second routine associated with the user-defined data type to calculate a score based on an identification of at least one word in the customer feedback as equivalent to one of said predefined words contained in the one or more data structures and the value of said equivalent one of said predefined words; and presenting an indication to rate said customer feedback to a customer representative for said enterprise, said indication being based on said score. ### Claim 19 (depends on 18) The system of claim 18, the one or more modules to store the rating data in a first relational table. ### Claim 20 (depends on 19) The system of claim 19, the one or more storage modules to store the customer feedback in a second relational table. ### Claim 21 (depends on 20) The system of claim 20, wherein the controller is adapted to perform a join of the first and second relational tables to perform the comparison.