# Tips and Tricks **URL:** https://community.stardog.com/c/tips-and-tricks/15.md [Latest](https://community.stardog.com/latest.md) · [Categories](https://community.stardog.com/categories.md) --- ## [About the Tips and Tricks category](https://community.stardog.com/t/about-the-tips-and-tricks-category/2088)
**Author:** [@evren](https://community.stardog.com/u/evren)\ **Replies:** 0
This category is for developers to share tips and tricks about using Stardog, talk about features or approaches that might not be commonly known and share interesting examples of Stardog usage with others --- ## [SPARQL Query Optimization](https://community.stardog.com/t/sparql-query-optimization/4065)
**Author:** [@stardogboy](https://community.stardog.com/u/stardogboy)\ **Replies:** 5\ **Last updated:** [November 2, 2022, 9:04am UTC](https://community.stardog.com/t/sparql-query-optimization/4065 "2022-11-02T09:04:44Z")
Hi All, I am very new in using sparql. I have the below query that I'm currently looking for ways to optimize. Currently here is the execution metrics: Query mode | query Request execution time (ms)… --- ## [Recommendation for Geo ontology and internet data source](https://community.stardog.com/t/recommendation-for-geo-ontology-and-internet-data-source/3522)
**Author:** [@johnz](https://community.stardog.com/u/johnz)\ **Replies:** 2\ **Last updated:** [September 1, 2022, 4:17pm UTC](https://community.stardog.com/t/recommendation-for-geo-ontology-and-internet-data-source/3522 "2022-09-01T16:17:15Z")
To sell the idea that StarDog can integrate external knowledge and data, I want to focus on importing a Geospatial ontology with a public data source. The Geospatial ontology could be simple city in-a state in-a countr… --- ## [Stardog performance on the W3C SPARQL 1.1 Tests](https://community.stardog.com/t/stardog-performance-on-the-w3c-sparql-1-1-tests/3722)
**Author:** [@arwesterinen](https://community.stardog.com/u/arwesterinen)\ **Replies:** 0\ **Last updated:** [May 9, 2022, 10:47pm UTC](https://community.stardog.com/t/stardog-performance-on-the-w3c-sparql-1-1-tests/3722 "2022-05-09T22:47:06Z")
This is probably not a "tip" or a "technique", but I thought that it would be interesting. For some work that I am doing for WikiMedia, I needed to automate triple store testing. I found the BorderCloud Tests for Triple… --- ## [Incremental server backups](https://community.stardog.com/t/incremental-server-backups/2496)
**Author:** [@evren](https://community.stardog.com/u/evren)\ **Replies:** 2\ **Last updated:** [March 29, 2022, 12:32pm UTC](https://community.stardog.com/t/incremental-server-backups/2496 "2022-03-29T12:32:11Z")
In Stardog 7.0 we introduced the server backup functionality that differs from the existing database backups in two important ways: Server backups contain all the databases including the system database so you do not n… --- ## [\[SPARQL Fun\]: joins and NULLs](https://community.stardog.com/t/sparql-fun-joins-and-nulls/3330)
**Author:** [@pavel](https://community.stardog.com/u/pavel)\ **Replies:** 0\ **Last updated:** [October 21, 2021, 4:41pm UTC](https://community.stardog.com/t/sparql-fun-joins-and-nulls/3330 "2021-10-21T16:41:12Z")
Hey there, Not exactly a short tip or trick this time so it went to the Stardog Labs blog: Joins and NULLs in SPARQL Happy to discuss here so feel free to drop any questions. Cheers, Pavel --- ## [\[SPARQL Fun\]: mind the curly brackets](https://community.stardog.com/t/sparql-fun-mind-the-curly-brackets/3317)
**Author:** [@pavel](https://community.stardog.com/u/pavel)\ **Replies:** 2\ **Last updated:** [October 14, 2021, 1:24pm UTC](https://community.stardog.com/t/sparql-fun-mind-the-curly-brackets/3317 "2021-10-14T13:24:55Z")
Hello everyone, This section was created a while ago but remained fairly dormant. We're going to try to change that! Over the years we have seen many queries which, if executed according to the SPARQL spec, won't do wha… --- ## [Stardog drivers for Snowflake](https://community.stardog.com/t/stardog-drivers-for-snowflake/3007)
**Author:** [@jiteshjosh](https://community.stardog.com/u/jiteshjosh)\ **Replies:** 4\ **Last updated:** [July 29, 2021, 4:46pm UTC](https://community.stardog.com/t/stardog-drivers-for-snowflake/3007 "2021-07-29T16:46:27Z")
Snowflake drivers are available or not? if not, is there any way to connect. --- ## [How much do you use SHACL over OWL and RDFS?](https://community.stardog.com/t/how-much-do-you-use-shacl-over-owl-and-rdfs/3158)
**Author:** [@dlbis](https://community.stardog.com/u/dlbis)\ **Replies:** 0\ **Last updated:** [July 23, 2021, 12:07pm UTC](https://community.stardog.com/t/how-much-do-you-use-shacl-over-owl-and-rdfs/3158 "2021-07-23T12:07:37Z")
Hi, So far, I have been using OWL and RDFS to define ontologies and enable reasoning. Also, I would consider using SHACL for controlling the data integrity. However, I have just read two articles explaining why we shou… --- ## [Stardog webconsole](https://community.stardog.com/t/stardog-webconsole/2997)
**Author:** [@jiteshjosh](https://community.stardog.com/u/jiteshjosh)\ **Replies:** 0\ **Last updated:** [April 19, 2021, 4:50am UTC](https://community.stardog.com/t/stardog-webconsole/2997 "2021-04-19T04:50:57Z")
Does Stardog 7.6.1 supports Stardog webconsole. If yes, any documentation available around configuration of it. Another question, what is the default password for sudo in Centos linux (using Stardog docker image) --- ## [SQLite3 Information](https://community.stardog.com/t/sqlite3-information/2948)
**Author:** [@serge](https://community.stardog.com/u/serge)\ **Replies:** 0\ **Last updated:** [March 17, 2021, 11:56pm UTC](https://community.stardog.com/t/sqlite3-information/2948 "2021-03-17T23:56:43Z")
Over the last two year, some of us as spread knowledge across several post. I think it time that we have a consolidated and persitent place where we can simply update info, how-to and how it can be used in a single place… --- ## [Sharing URL of agnos.ai articles we are publishing this week](https://community.stardog.com/t/sharing-url-of-agnos-ai-articles-we-are-publishing-this-week/2933)
**Author:** [@mbarbieri77](https://community.stardog.com/u/mbarbieri77)\ **Replies:** 0\ **Last updated:** [March 12, 2021, 6:47pm UTC](https://community.stardog.com/t/sharing-url-of-agnos-ai-articles-we-are-publishing-this-week/2933 "2021-03-12T18:47:24Z")
Hello guys, First I would like to thank Pavel for helping me with the Named Graph article. Today we are finally sharing a few articles on Medium under the agnos publication, and as promised, I'm sharing the final links … --- ## [Stardog sandbox covid queries](https://community.stardog.com/t/stardog-sandbox-covid-queries/2635)
**Author:** [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 7:19pm UTC](https://community.stardog.com/t/stardog-sandbox-covid-queries/2635 "2020-08-06T19:19:55Z")
I've been playing around with some queries and data in the stardog sandbox that use some of the user defined functions that I put together and I thought I'd share. I like working with the CLI and wanted to be able to qu… --- ## [Hierarchy level identification using only SPARQL](https://community.stardog.com/t/hierarchy-level-identification-using-only-sparql/2558)
**Author:** [@dlbis](https://community.stardog.com/u/dlbis)\ **Replies:** 8\ **Last updated:** [July 3, 2020, 6:05pm UTC](https://community.stardog.com/t/hierarchy-level-identification-using-only-sparql/2558 "2020-07-03T18:05:09Z")
Hi, With SPARQL, we can easily go through a hierarchy recursively. But it is a lot harder to identify the level of each node in that hierarchy. Anyone has a full SPARQL solution for that? Thanks Daniel --- ## [Data Exploration in Studio with Search and Visualization](https://community.stardog.com/t/data-exploration-in-studio-with-search-and-visualization/2101)
**Author:** [@jason](https://community.stardog.com/u/jason)\ **Replies:** 0\ **Last updated:** [November 18, 2019, 4:00pm UTC](https://community.stardog.com/t/data-exploration-in-studio-with-search-and-visualization/2101 "2019-11-18T16:00:39Z")
As an inaugural "Tips and Tricks" post, I wanted to share an easy way to start exploring your knowledge graph using two existing features of Stardog Studio: Search and Visualization. Suppose I've got a music dataset wit… --- ## [Introducing Tips and Tricks category](https://community.stardog.com/t/introducing-tips-and-tricks-category/2100)
**Author:** [@evren](https://community.stardog.com/u/evren)\ **Replies:** 0\ **Last updated:** [November 18, 2019, 3:36pm UTC](https://community.stardog.com/t/introducing-tips-and-tricks-category/2100 "2019-11-18T15:36:10Z")
Dear Stardoggers, We have created a new "Tips and Tricks" category in our forum to occasionally share interesting examples of Stardog usage and highlight features or approaches that might not be commonly known. We hope …