OUTPUT DRIVEN GENERATION OF A COMBINED SCHEMA FROM A PLURALITY OF INPUT DATA SCHEMAS

• US 20150019477A1
• Filed: 09/30/2014
• Published: 01/15/2015
• Est. Priority Date: 03/13/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Jeff J., Nusbickel, Wendi L.
• Granted Patent: US 9,892,135 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

A computational device receives a plurality of versions of an input data schema. At least one element is selected from the plurality of versions of the input data schema based on an expected result. A combined schema is generated based on the at least one selected element. The input data is processed according to the combined schema.

Claims

1. A method, comprising:

receiving, via a computational device, a plurality of versions of an input data schema;

selecting at least one element from the plurality of versions of the input data schema based on an expected result; and

generating a combined schema based on the at least one selected element; and

processing input data according to the combined schema.

2. The method of claim 1, further comprising:

generating streaming events based on the combined schema.

3. The method of claim 2, wherein the streaming events correspond to tokens generated by a parser from the input data and the combined schema corresponds to a state machine, and wherein processing input data according to the combined schema further comprises:

sending the streaming events from the parser to the state machine to validate incoming data and generate an output.

4. The method of claim 1, wherein the generating of the combined schema is performed by an Extract Transform Load (ETL) component that executes in the computational device, and wherein the ETL component extracts information from the input data, transforms the information in conformance with operational needs, and generates an output.

5. The method of claim 1, wherein the at least one selected element is a first element, and wherein at least one of the plurality of versions of the input data schema include a second element that is not a part of the expected result, the method further comprising:

omitting the second element from the combined schema.

6. The method of claim 1, wherein the generating of the combined schema based on the at least one selected element further comprises:

configuring the combined schema to have all elements corresponding to a schema of the expected result, wherein all the elements corresponding to the schema of the expected result are a subset of an union of each of the plurality of versions of the input schema.