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:
Feb. 21, 2017
Filed:
Nov. 20, 2015
International Business Machines Corporation, Armonk, NY (US);
Luis Campo Giralte, Dublin, IE;
Jose Luis Mujeriego Gomez, Dublin, IE;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A denormalized dataset, an associated primary key field, one or more associated secondary key fields and information identifying one or more normalized datasets associated with each secondary key field, is received. A denormalized table comprising fields and data types corresponding to said denormalized dataset, said denormalized table having a primary key field corresponding to said primary key field associated with said denormalized dataset, is created. The said information identifying the one or more normalized datasets associated with each secondary key field, creating one or more normalized tables, each of said one or more normalized tables corresponding to a respective one of said one or more normalized datasets, each of said one or more normalized tables comprising a foreign key corresponding to said associated primary key and a primary key corresponding to the secondary key field associated with said normalized dataset, is utilized. Additionally, each of said foreign keys is utilized.