Back to results
US 2017/0249371 A1Published application
Creating mappings between records in a database to normalized questions in a computerized document
AssigneeLinkedln Corporation
InventorsWojciech Krupa, Evan Alexander Owski, Timothy Jack Showalter, Gordon Wintrob
Life of this patent
Estimating the term…
Abstract
In an example embodiment, a solution that creates a questionnaire mapping record for questions in a computerized document is utilized to map questions in the computerized document to normalized questions. Where necessary, normalized questions can be automatically created and included in the questionnaire mapping record. Handing strategy rules may also be automatically created for the normalized question, with the handling strategy rules defining how data may be automatically retrieved and used to prepopulate answers to the questions in the computerized document.
Claims20
A computerized method comprising:
- receiving a computerized document containing one or more questions;
- creating a first questionnaire mapping record corresponding uniquely to the computerized document;
- for each question in the computerized document:
- creating a question record corresponding uniquely to the question;
- storing the question record corresponding uniquely to the question in the questionnaire mapping record;
- determining if the question matches a question identified in a question record in a questionnaire mapping record, stored in a database, other than the first questionnaire mapping record;
- in response to a determination that the question does not match a question identified in a question record in a questionnaire mapping record other than the first questionnaire mapping record:
- determining if the question matches a normalized question stored in a normalized question record in the database;
- in response to a determination that the question does not match a normalized question stored in a normalized question record in the database:
- creating a normalized version of the question;
- creating a normalized question record corresponding uniquely to the normalized version of the question, the normalized question record containing the normalized version of the question;
- and
- inserting an identification of the normalized question record in the question record corresponding uniquely to the question in the questionnaire mapping record to create a mapping between the question record corresponding uniquely to the question and the normalized question record.
10 more elements
A system comprising:
- a computer readable medium having instructions stored there on, which, when executed by a processor, cause the system to:
- receive a computerized document containing one or more questions;
- create a first questionnaire mapping record corresponding uniquely to the computerized document;
- for each question in the computerized document:
- create a question record corresponding uniquely to the question;
- store the question record corresponding uniquely to the question in the questionnaire mapping record;
- determine if the question matches a question identified in a question record in a questionnaire mapping record, stored in a database, other than the first questionnaire mapping record;
- in response to a determination that the question does not match a question identified in a question record in a questionnaire mapping record other than the first questionnaire mapping record:
- determine if the question matches a normalized question stored in a normalized question record in the database;
- in response to a determination that the question does not match a normalized question stored in a normalized question record in the database:
- create a normalized version of the question;
- create a normalized question record corresponding uniquely to the normalized version of the question, the normalized question record containing the normalized version of the question;
- and
- insert an identification of the normalized question record in the question record corresponding uniquely to the question in the questionnaire mapping record to create a mapping between the question record corresponding uniquely to the question and the normalized question record.
11 more elements
A non-transitory machine-readable storage medium comprising instructions, which when implemented by one or more machines, cause the one or more machines to perform operations comprising
- receiving a computerized document containing one or more questions;
- creating a first questionnaire mapping record corresponding uniquely to the computerized document;
- for each question in the computerized document:
- creating a question record corresponding uniquely to the question;
- storing the question record corresponding uniquely to the question in the questionnaire mapping record;
- determining if the question matches a question identified in a question record in a questionnaire mapping record, stored in a database, other than the first questionnaire mapping record;
- in response to a determination that the question does not match a question identified in a question record in a questionnaire mapping record other than the first questionnaire mapping record:
- determining if the question matches a normalized question stored in a normalized question record in the database;
- in response to a determination that the question does not match a normalized question stored in a normalized question record in the database:
- creating a normalized version of the question;
- creating a normalized question record corresponding uniquely to the normalized version of the question, the normalized question record containing the normalized version of the question;
- and
- inserting an identification of the normalized question record in the question record corresponding uniquely to the question in the questionnaire mapping record to create a mapping between the question record corresponding uniquely to the question and the normalized question record.
10 more elements
Dependencies are inferred from the claim text.