Method for implementing data triplestore over a cloud analytical data store
Systems and methods are disclosed for processing data. The system represents semantic data in the semantic data storage using a schema native to Cloud Analytical Data Store (CADS) based on data defining a semantic model. The system modifies the schema based on a detected change in the semantic model. The system writes semantic data into the CADS, wherein the semantic data is formatted according to the schema using at least one of: (a) bulk load, or (b) a sequence of write requests. The system receives a semantic query. The system translates the semantic query into a translated query in a CADS-native format, wherein the translated query is formatted according to the schema. The system causes the CADS to provide an answer to the translated query based on data contained in the CADS.
1. A method comprising:
representing semantic data in the semantic data storage using a schema native to Cloud Analytical Data Store (CADS) based on data defining a semantic model;
modifying the schema based on a detected change in the semantic model, by:
performing a selection of one of (a) narrow strategy schema, or (b) wide strategy schema based on metadata of the CADS data storage and/or based on optimization methods native to the CADS data storage; and
modifying the schema based on the performed selection;
writing semantic data into the CADS, wherein the semantic data is formatted according to the schema using at least one of: (a) bulk load, or (b) a sequence of write requests;
receiving a semantic query;
translating the semantic query into a translated query in a CADS-native format, wherein the translated query is formatted according to the schema; and
causing the CADS to provide an answer to the translated query based on data contained in the CADS.
2. The method of claim 1 wherein the CADS comprises a compute portion and a data store portion, and wherein causing the CADS to provide the answer to the translated query compromises causing the compute portion of CADS to provide the answer based on data contained in the data store portion of the CADS.
3. The method of claim 1 , where semantic data storage is a triple store storage.
4. The method of claim 3 , wherein the semantic data storage is a Resource Description Framework (RDF) semantic data storage, and wherein the semantic query is a SPARQL Protocol and RDF Query Language (SPARQL) query.
5. A method of claim 1 , further comprising:
receiving a second semantic query;
translating the second semantic query into a second translated query in a CADS-native format, wherein the second translated query is formatted according to the schema;
publishing the second translated semantic query as a tabular object native to the CADS data storage; and
providing an interface that allows for running the second translated semantic query over the CADS data storage.
6. The method of claim 1 , wherein the schema comprises at least one of clustering or segmenting strategy.
7. The method of claim 1 , wherein:
selection of the narrow strategy schema, results in each concept in the semantic model being represented by a unique table, wherein each of the unique tables comprises three columns, wherein:
(a) first column comprises a concept instance identification (ID);
(b) second column comprises a property name for the concept instance associated with the concept instance; and
(c) third column comprises a value associated with the property name and the concept instance ID; and
wherein selection of the wide schema, results in each concept in the semantic model being represented by a unique table, wherein the table comprises multiple columns, each column being associated with a different property for a concept instance ID.
8. The method of claim 7 , wherein one column of the multiple columns comprises an identifier for each instance of the concept, and other columns the multiple columns are associated with a different property of the concept.
9. The method of claim 1 , wherein each of the unique tables comprises four columns, wherein the fourth column indicates whether property is unitary property or a relational property.
10. A system comprising:
control circuitry configured to:
represent semantic data in the semantic data storage using a schema native to Cloud Analytical Data Store (CADS) based on data defining a semantic model;
modify the schema based on a detected change in the semantic model, by:
performing a selection of one of (a) narrow strategy schema, or (b) wide strategy schema based on metadata of the CADS data storage and/or based on optimization methods native to the CADS data storage; and
modifying the schema based on the performed selection;
write semantic data into the CADS, wherein the semantic data is formatted according to the schema using at least one of: (a) bulk load, or (b) a sequence of write requests;
input/output circuitry configured to:
receiving a semantic query;
wherein the control circuitry is further configured to:
translate the semantic query into a translated query in a CADS-native format, wherein the translated query is formatted according to the schema; and
cause the CADS to provide an answer to the translated query based on data contained in the CADS.
11. The system of claim 10 wherein the CADS comprises a compute portion and a data store portion, and wherein the control circuitry is further configured to cause the CADS to provide the answer to the translated query by causing the compute portion of CADS to provide the answer based on data contained in the data store portion of the CADS.
12. The system of claim 10 , where semantic data storage is a triple store storage.
13. The system of claim 12 , wherein the semantic data storage is a Resource Description Framework (RDF) semantic data storage, and wherein the semantic query is a SPARQL Protocol and RDF Query Language (SPARQL) query.
14. A system of claim 10 ,
wherein the input/output circuitry is further configured to:
receiving a second semantic query; and
wherein the control circuitry is further configured to:
translate the second semantic query into a second translated query in a CADS-native format, wherein the second translated query is formatted according to the schema;
publish the second translated semantic query as a tabular object native to the CADS data storage; and
provide an interface that allows for running the second translated semantic query over the CADS data storage.
15. The system of claim 10 , wherein the schema comprises at least one of clustering or segmenting strategy.
16. The system of claim 10 , wherein: selection of the narrow strategy schema, results in concept in the semantic model being represented by a unique table, wherein each of the unique tables comprises three columns, wherein:
(a) first column comprises a concept instance identification (ID);
(b) second column comprises a property name for the concept instance associated with the concept instance; and
(c) third column comprises a value associated with the property name and the concept instance ID; and wherein selection of the wide schema, results in each concept in the semantic model being represented by a unique table, wherein the table comprises multiple columns, each column being associated with a different property for a concept instance ID.
17. The system of claim 16 , wherein one column of the multiple columns comprises an identifier for each instance of the concept, and other columns the multiple columns are associated with a different property of the concept.
18. The system of claim 10 , wherein each of the unique tables comprises four columns, wherein the fourth column indicates whether property is unitary property or a relational property.