Method and apparatus for functional integration of metadata

A computer program product for functional integration of metadata for a plurality of databases, the computer program product comprising:

• a computer readable memory having computer readable program code embodied therewith, the computer readable program code configured to:
• create a single set of classes and instances for the classes for metadata of at least one relational data schema and at least one non-relational data schema for the plurality of databases, wherein the single set of classes comprises first classes for the metadata and second classes for the instances of the first classes;
• create a single set of semantic relationships between the instances of the first classes and the second classes based on structural information in the relational data schema and the non-relational data schema;
• create a single set of triples for the semantic relationships between the instances of the first classes and the second classes;
• and
• store the single set of triples in a single file;
• wherein the computer readable program code configured to create the single set of the semantic relationships between the instances of the first classes and the second classes based on the structural information in the relational data schema and the non-relational data schema is further configured to:
• define the semantic relationships between the instances of the first classes and the second classes based on the structural information in the relational data schema and the non-relational data schema for the plurality of databases;
• create a first set of triples for the semantic relationships for the at least one relational data schema, wherein a range of one of the first set of triples links to a domain of another of the first set of triples forming a first chain of triples;
• create a second set triples for the semantic relationships for the non-relational data schema, wherein a range of one of the second set of triples links to a domain of another of the second set of triples forming a second chain of triples;
• and
• wherein the first chain and the second chain comprise matching attribute values.

A system, comprising:

• a plurality of databases defined by at least one relational data schema and at least one non-relational data schema;
• and
• a server comprising a processor and a computer readable storage medium having computer readable program code embodied therewith, wherein when the computer readable program code is executed by the processor, causes the server to:
• create a single set of classes and instances for the classes for metadata of the relational data schema and the non-relational data schema for the plurality of databases, wherein the single set of classes comprises first classes for the metadata and second classes for the instances of the first classes;
• create a single set of semantic relationships between the instances of the first classes and the second classes based on structural information in the relational data schema and the non-relational data schema;
• create a single set of triples for the semantic relationships between the instances of the first classes and the second classes;
• and
• store the single set of triples in a single file;
• wherein when the computer readable program code configured to create the single set of the semantic relationships between the instances of the first classes and the second classes based on the structural information in the relational data schema and the non-relational data schema is executed by the processor, further causes the server to:
• define the semantic relationships between the instances of the first classes and the second classes based on the structural information in the relational data schema and the non-relational data schema for the plurality of databases;
• creating a first set of triples for the semantic relationships for the at least one relational data schema, wherein a range of one of the first set of triples links to a domain of another of the first set of triples forming a first chain of triples;
• creating a second set triples for the semantic relationships for the non-relational data second set of triples forming a second chain of triples;
• and
• wherein the first chain and the second chain comprise matching attribute values.

A computer implemented method for functional integration of metadata for a plurality of databases, comprising:

• creating a single set of classes and instances for the classes for metadata of at least one relational data schema and at least one non-relational data schema for the plurality of databases, wherein the single set of classes comprises first classes for the metadata and second classes for the instances of the first classes;
• defining semantic relationships between the instances of the first classes and the second classes based on the structural information in the relational data schema and the non-relational data schema for the plurality of databases;
• creating a first set of triples for the semantic relationships for the at least one relational data schema, wherein a range of one of the first set of triples links to a domain of another of the first set of triples forming a first chain of triples;
• creating a second set triples for the semantic relationships or the non-relational data schema, wherein a range of one of the second set of triples links to a domain of another of the second set of triples forming a second chain of triples, wherein the first chain and the second chain comprise matching attribute values;
• storing the first chain and the second chain in a single file;
• and
• using the matching attribute values of the first chain and the second chain to navigate between the plurality of databases to formulate a response to a query.

A computer program product for functional integration of metadata for a plurality of databases, comprising:

• a computer readable memory having computer readable program code embodied therewith, the computer readable program code configured to:
• create a single set of classes and instances for the classes for metadata of at least one relational data schema and at least one non-relational data schema for the plurality of databases, wherein the single set of classes comprises first classes for the metadata and second classes for the instances of the first classes;
• define semantic relationships between the instances of the first classes and the second classes based on the structural information in the relational data schema and the non-relational data schema for the plurality of databases;
• create a first set of triples for the semantic relationships for the at least one relational data schema, wherein a range of one of the first set of triples links to a domain of another of the first set of triples forming a first chain of triples;
• create a second set triples for the semantic relationships for the non-relational data schema, wherein a range of one of the second set of triples links to a domain of another of the second set of triples forming a second chain of triples, wherein the first chain and the second chain comprise matching attribute values;
• store the first chain and the second chain in a single file;
• and
• use the matching attribute values of the first chain and the second chain to navigate between the plurality of databases to formulate a response to a query.