Intelligent data integration system

• US 9,904,715 B1
• Filed: 04/07/2017
• Issued: 02/27/2018
• Est. Priority Date: 04/23/2012
• Status: Expired due to Fees

• Current Assignee: Monsanto Technology LLC (Bayer AG)
• Original Assignee: Monsanto Technology LLC (Bayer AG)
• Inventors: Taylor, Christopher Allen, Richt, Ryan Jerry
• Primary Examiner(s): Hasan, Syed
• Application Number:
  US15/482,053
• Time in Patent Office: 326 Days
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/243 Natural language query formulation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/285 Clustering or classification

Abstract

Data objects stored in a data store include data attribute(s) and associated value(s) for the attributes. Data analysis tools (DATs) stored in a data store are associated with reference data attritbute(s). The data objects are identified by one or more DATs based on each reference data attribute(s) of a corresponding DAT matching one of the data attribute(s) of the corresponding data object(s) and independent of the value for the data attribute(s). The DATs generate an additional data object as a function of the identified data object, and the additional data object is stored in the data store.

Claims

1. A tangible, non-transitory storage medium storing processor-executable instructions for self-assembling a plurality of individual data analysis tools into a workflow, said storage medium storing:

instructions for storing a plurality of data attributes for describing/defining one or more data objects in a storage device;

instructions for storing in a data store a first data object having a first attribute set comprising at least one first data attribute of the plurality of stored data attributes and a value for said at least one first data attribute;

instructions for storing in the data store a first data analysis tool (DAT), said first DAT associated with at least one first reference data attribute of the plurality of stored data attributes;

instructions for identifying said first data object based on each at least one first reference data attribute matching one of the at least one first data attribute of the first data attribute set and independent of the value for the at least one first data attribute of the first attribute set;

instructions for generating by said first DAT a second data object as a function of the identified first data object, wherein said second data object comprises a second attribute set comprising at least one second data attribute of the plurality of stored data attributes, and a value for said at least one second data attribute of the second attribute set;

instructions for storing the second data object in the data store;

instructions for storing in the data store a second data analysis tool (DAT), said second DAT associated with at least one second reference data attribute of the plurality of stored data attributes;

instructions for identifying said second data object based on each at least one second reference data attribute matching one of the at least second first data attribute of the second data attribute set and independent of the value for the at least one second data attribute of the second attribute set;

instructions for generating by said second DAT a third data object as a function of the identified second data object, wherein said third data object comprises a third attribute set comprising at least one third data attribute of the plurality of stored data attributes, and a value for said at least one third data attribute of the third attribute set;

instructions for storing said third data object in the data store;

instructions for receiving a user-provided value;

instructions for querying the data store as a function of the user-provided value to identify data attributes having values corresponding to the user-provided value;

instructions for generating a result set as a function of the querying, said result set including data objects having the identified data attributes, wherein said receiving, querying, and generating are performed for each of a plurality of user-provided values;

defining a display set of data objects, wherein said display set is a sub-set of the generated result set; and

rendering the display set of data objects for displaying to a user.

2. The storage medium of claim 1, wherein said instructions for identifying said first data object comprises instructions for determining that each of the at least one first reference data attribute is identical to or has a semantic lexical relationship with one of the at least one first reference data attribute.

3. The storage medium of claim 1, the storage medium further storing:

instructions for mapping a plurality of the stored data attributes together;

instructions for determining whether each at least one first reference data attribute is mapped to one of the at least one first data attribute, wherein the first data attribute matches the first reference data attribute when the first data attribute is determined to be mapped to the first reference data attribute.

4. The storage medium of claim 1, wherein said first DAT is associated with a first reference data object, said first reference data object having the at least one first reference data attribute.

5. The storage medium of claim 1, the storage medium further storing:

instructions for adding a new data object to the data store, said new data object having a particular set of data attributes;

in response to said adding the new data object to the data store;

instructions for determining whether each at least one first reference data attribute matches one of the data attributes of the new data object; and

instructions for determining whether each at least one second reference data attribute matches one of the data attributes of the new data object.

6. The storage medium of claim 1, the storage medium further storing:

instructions for iteratively selecting one identified first data object from the collection of identified first data objects for analysis by the first DAT, wherein the instructions for generating by said first DAT a second object as a function of the identified first data object comprises instructions for generating by said first DAT, for each iteratively selected one identified first data object, a second data object as a function of the selected one identified first data object.

7. The storage medium of claim 6, the storage medium further storing:

instructions for assigning a sequence number to each of the identified first data objects of the collection of identified first data objects, wherein the assigned sequence number defines an approximate order for analysis by the first DAT.

8. The storage medium of claim 7 wherein at least two of the identified first data objects of the collection of identified first data objects have the same assigned sequence number.

9. The storage medium of claim 1 wherein the identified first data objects of the collection are approximately ordered for analysis by the first DAT based on, for each identified first data object of the collection, a cumulative total number of display sets in which the identified first data object is included.

10. The storage medium of claim 1, further comprising receiving user-feedback for one or more data objects in the rendered display set.

11. The storage medium of claim 10, wherein the identified first data objects of the collection are approximately ordered for analysis by the first DAT based on the received-user feedback.

12. A tangible, non-transitory storage medium storing processor-executable instructions for self-assembling a plurality of individual data analysis tools into a workflow, said storage medium storing:

instructions for storing a plurality of data attributes for describing/defining one or more data objects in a storage device;

instructions for storing in a data store a first data object having a first attribute set comprising at least one first data attribute of the plurality of stored data attributes and a value for said at least one first data attribute;

instructions for storing in the data store a first data analysis tool (DAT), said first DAT associated with at least one first reference data attribute of the plurality of stored data attributes, wherein said first DAT is associated with a first reference data object, said first reference data object having the at least one first reference data attribute;

instructions for identifying said first data object based on each at least one first reference data attribute matching one of the at least one first data attribute of the first data attribute set and independent of the value for the at least one first data attribute of the first attribute set;

instructions for generating by said first DAT a second data object as a function of the identified first data object, wherein said second data object comprises a second attribute set comprising at least one second data attribute of the plurality of stored data attributes, and a value for said at least one second data attribute of the second attribute set;

instructions for storing the second data object in the data store;

instructions for storing in the data store a second data analysis tool (DAT), said second DAT associated with at least one second reference data attribute of the plurality of stored data attributes;

instructions for identifying said second data object based on each at least one second reference data attribute matching one of the at least second first data attribute of the second data attribute set and independent of the value for the at least one second data attribute of the second attribute set;

instructions for generating by said second DAT a third data object as a function of the identified second data object, wherein said third data object comprises a third attribute set comprising at least one third data attribute of the plurality of stored data attributes, and a value for said at least one third data attribute of the third attribute set;

instructions for storing said third data object in the data store;

instructions for storing a first reference data object class in the data store, said first reference data object class defining requirements for instances of first reference data objects, wherein said storing a first DAT in the data store comprises;

validating said first DAT, wherein said validating includes verifying that the at least one first reference data object associated with said first DAT meets the requirements for the stored first reference object class;

compiling said first DAT; and

uploading the validated and compiled first DAT to the data store.

13. The storage medium of claim 12, wherein said instructions for identifying said first data object comprises instructions for determining that each of the at least one first reference data attribute is identical to or has a semantic lexical relationship with one of the at least one first reference data attribute.

14. The storage medium of claim 12, the storage medium further storing:

instructions for mapping a plurality of the stored data attributes together;

instructions for determining whether each at least one first reference data attribute is mapped to one of the at least one first data attribute, wherein the first data attribute matches the first reference data attribute when the first data attribute is determined to be mapped to the first reference data attribute.

15. The storage medium of claim 12, the storage medium further storing:

instructions for adding a new data object to the data store, said new data object having a particular set of data attributes;

in response to said adding the new data object to the data store;

instructions for determining whether each at least one first reference data attribute matches one of the data attributes of the new data object; and

instructions for determining whether each at least one second reference data attribute matches one of the data attributes of the new data object.

16. The storage medium of claim 12 wherein the identified first data objects of the collection are approximately ordered for analysis by the first DAT based on, for each identified first data object of the collection, a cumulative total number of display sets in which the identified first data object is included.

17. The storage medium of claim 12, further comprising receiving user-feedback for one or more data objects in the rendered display set.

18. A tangible, non-transitory storage medium storing processor-executable instructions for self-assembling a plurality of individual data analysis tools into a workflow, said storage medium storing:

instructions for storing a plurality of data attributes for describing/defining one or more data objects in a storage device;

instructions for storing in a data store a first data object having a first attribute set comprising at least one first data attribute of the plurality of stored data attributes and a value for said at least one first data attribute;

instructions for storing in the data store a first data analysis tool (DAT), said first DAT associated with at least one first reference data attribute of the plurality of stored data attributes;

instructions for identifying said first data object based on each at least one first reference data attribute matching one of the at least one first data attribute of the first data attribute set and independent of the value for the at least one first data attribute of the first attribute set;

instructions for generating by said first DAT a second data object as a function of the identified first data object, wherein said second data object comprises a second attribute set comprising at least one second data attribute of the plurality of stored data attributes, and a value for said at least one second data attribute of the second attribute set;

instructions for storing the second data object in the data store;

instructions for storing in the data store a second data analysis tool (DAT), said second DAT associated with at least one second reference data attribute of the plurality of stored data attributes;

instructions for identifying said second data object based on each at least one second reference data attribute matching one of the at least second first data attribute of the second data attribute set and independent of the value for the at least one second data attribute of the second attribute set;

instructions for generating by said second DAT a third data object as a function of the identified second data object, wherein said third data object comprises a third attribute set comprising at least one third data attribute of the plurality of stored data attributes, and a value for said at least one third data attribute of the third attribute set; and

instructions for storing said third data object in the data store,

wherein the first DAT is associated with the at least one first reference data attribute and an other first reference data attribute, and wherein said instructions for identifying said first data object comprises instructions for determining that a Boolean combination of the at least one first reference data attribute and the other first reference data attribute matches the at least one first data attribute of the first data attribute set.

19. The storage medium of claim 18, the storage medium further storing:

instructions for mapping a plurality of the stored data attributes together;

instructions for determining whether each at least one first reference data attribute is mapped to one of the at least one first data attribute, wherein the first data attribute matches the first reference data attribute when the first data attribute is determined to be mapped to the first reference data attribute.

20. The storage medium of claim 18 wherein the identified first data objects of the collection are approximately ordered for analysis by the first DAT based on, for each identified first data object of the collection, a cumulative total number of display sets in which the identified first data object is included.