Patent ID: 8775448

Claim:
A method carried out in a computer system to generate personalized messages using data stored in a relational database, comprising the steps of: parsing a message template for commands to be executed to look up data from a plurality of tables of the relational database, each table of the tables having a primary key; identifying for each command of the commands, a corresponding table from the plurality of tables and a look-up key, wherein the commands include a plurality of commands to be executed to look up data from a first table, the plurality of commands employing a plurality of unique look-up keys that are different from a primary key of the first table; transforming each one of the plurality of tables identified as corresponding to one of the commands into a respective key-value data structure if the respective key-value data structure has not yet been created, wherein the respective key-value data structure has the same number of entries as the one of the plurality of tables and includes a key field, a value field, and an index field, wherein the key field stores the primary key of the one of the plurality of tables, wherein the value field stores a plurality of data fields of the one of the plurality of tables encoded as a single value, wherein the index field stores the look-up key corresponding to the one of the commands, and wherein the key-value data structure that is transformed from the first table includes a plurality of index fields in which the plurality of unique look-up keys are stored; and generating personalized messages using the message template and the key-value data structures transformed from the tables.