The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 01, 2020
Filed:
Jan. 30, 2017
International Business Machines Corporation, Armonk, NY (US);
Eric B. Libow, Raleigh, NC (US);
Markus Lorch, Dettenhausen, DE;
Martin A. Oberhofer, Bondorf, DE;
Torsten Steinbach, Holzgerlingen, DE;
International Business Machines Corporation, Armonk, NY (US);
Abstract
An embodiment of the invention pertains to processing messages received from a set of devices. A mapping of message fields to fact table columns is stored in a mapping table of a relational database. The method comprises, for each received message, determining all fields of the received message. If it is determined that the mapping table does not assign a fact table column to each of the determined fields of the message, a new mapping between message fields to respective fact table is automatically stored in the mapping table. A mapping is identified in the mapping table that assigns each of the determined fields of the message to a respective one of the columns of the fact table. The field values of the message are stored in the fact table in accordance with the identified mapping.