Thanks! I love my Korg Monotron Duo. Small size, small price, but still a proper old-school analog synth. If you listen closely you can hear that I made it pan from left to right (or right to left, depending on your setup). Korg's video about it: th-cam.com/video/wWLOxRSll5Q/w-d-xo.html
Thanks for the tutorial! Was just wondering though at 8:10 the NOT EXISTS expression is written without FILTER (q7.rq). Would this be ok generally? As far as I understood, at least the Wikidata SPARQL endpoint requires the FILTER keyword along with NOT EXISTS.
Very good point. In a quick test I see that Wikidata does seem to require the FILTER keyword before NOT EXISTS and arq doesn't. I couldn't follow the official grammar at www.w3.org/TR/sparql11-query/#sparqlGrammar well enough to find an answer there, but I did find www.w3.org/2009/sparql/wiki/Design:Negation#Syntax, which says that "The keywords EXISTS and NOT EXISTS can be used both inside and outside FILTERs."
You can create your own. It's best to base it on a domain name that is under your control, so that for example if you create the URI myuri.org/vocab/dog to represent a dog you can actually put some data there (in which case it will then be a URL!)
Thank you very much! I did the piano and drums with a scoring program (the parts are simple enough that I could have played them for real, but miking those well would be a pain) and then I played acoustic rhythm guitar, electric lead guitar and electric bass.
Does a URI, like your example "www.snee.com/hr/hireDate" have to be a live URL, or is the URI truly just a namespace and identifier? Another way to ask this is if I have some data on some media presentations, like controlName (an internal identifier for our uses, examples include 160607_wpx_becton, 160607_wpx_smith, and 160607_wpx_jones), and I need to create a URI, can I use any thing for the URI (like our web address www.trufflemedia.com) plus some identifier info to create a URI like this "www.trufflemedia.com/presentation/160607_wpx_becton"? What happens to URIs that use live URL addresses and then those domains are shut down. For example, if, in a dataset, I use a URI like "www.trufflemedia.com/presentation/160607_wpx_becton" and then the "www.trufflemedia.com" domain is shut down, is the URI still valid? thx, very helpful SPARQL info.
It doesn't have to be a URL. It's just an identifier. The Linked Data movement stresses the value of making it a dereferenceable URL, so that is even better. If the domain is shut down, the URI still functions as an identifier, but obviously won't be a Locator any more if there's nothing at that location.
So we can make a conclusion to make it logically clear; that SPARQL "where" {....} instruction rely all the conditions inside it with "AND" by default, and to make it OR for some certain condition, we just put "optional" before it. Please tell me if I'm wrong..
That is correct. Just be careful with OR because it's asking the query engine to do a lot more scanning, which can slow things down. See www.bobdc.com/blog/dropping-optional-blocks-from/ for more.
Dear Sir, currently I am trying to create a website about Linked Data for my internship. I found your video very helpful in explaining, therefore I was wondering whether it would be okay to embed this video on my website. The website has informative purposes
Amazing video, but I gotta ask something. How is RDF used?? We have to write an RDF file from the content we have written for example in a news website or is it generated automatically by the computers. Or is it something we only make for important stuff like Chemistry fromulas ?? I'm lost
It's popular for the metadata of content, especially when using the JSON-LD syntax, so that would be good for a news website. See www.bobdc.com/blog/json-ld/ for more on JSON-LD. (I will fix the screwy syntax highlighting in the examples sometime tomorrow.)
Nice video, thank you for explaining this! Next time could you please go easy on that sound effect when you run a query, it gets really old really fast.
Thank you - this is a very helpful video. I disagree that it's difficult to store a 'second completed orientation date' in such a table though (or that SPARQL makes this concept easier) (th-cam.com/video/FvGndkpa4K0/w-d-xo.html). That is an implementation of SPARQL that is separate to how the query is phrased in itself. That threw me off the first couple times that I watched this video, as I couldn't figure out what you meant. in sql it's also easy to 'phrase' that same insertion statement: "insert into table values (emp1, engineer, date1), (emp1, engineer, date2);". And that would be fine in a denormalized table.
hi, can you please explain why can't we use "vcard" for "hiredate" and for "completeorientaion" ? you said that those properties are not available in vcard and we didn't understand why- what is the reson thanks a lot!!
+Bar Kohavi See the vcard ontology at www.w3.org/TR/vcard-rdf/ . You'll see that hireDate and completedOrientation are not part of the vcard vocabulary, so I had to make up new URIs for them, which is very easy in SPARQL.
SPARQL sucks. Looks like it was written by someone who doesn't know how SQL works. But thank you for the video. It will make it more easier if you explain what each keyword does and even make a comparison with SQL. For instance SELECT... FROM... WHERE... GROUP BY.. HAVING.. ORDER BY.. structure in SQL simplifies the selection, sourcing, filtering, aggregation, post aggregation filtering and sorting. What will be the equivalent of that in SPARQL. How is a WHERE in SQL is different (ex: order of conditions is irrelevant vs sequential filtering in SPARQL)..
Life was much easier 11 minutes ago. Kudos to the guy who invented this thing!!
I'm just laughing that "SPARQL" is the first word in the acronym, "SPARQL"
Recursion.
Like the "B" in "Benoit B. Mandelbrot" stands for "Benoit B Mandelbrot".
@@ChrisLuigiTails "WINE" stands for Wine Is Not an Emulator; "PINE" stands for Pine Is Not Elm and so on...
@@charliepank528 And GNU is Not Unix :D
Recursive names are a pretty common practice in CS actually :-)
So the S has to have a greater meaning then just recursion
Simplest video about SPARQL ever
Watching this at 4:43 am, and I have a presentation at 3:00pm . I have never been so proud of my procrastination attribute before.
I have an exam tomorrow at noon where 1 question is just SPARQL and this is the first time I am seeing this. Gonna nail that shit :D
@@malighos I have an assignment submission on Saturday and believe me, I feel how it is.
#Bliss
How were you in the presentation? :D
@@malighos did you nailed it?
Hello ,, it's meee :v ,, i have exam tomorrow :v
Best intro to SPARQL have found, especially love the sound when generating the result from the query
Thanks! I love my Korg Monotron Duo. Small size, small price, but still a proper old-school analog synth. If you listen closely you can hear that I made it pan from left to right (or right to left, depending on your setup). Korg's video about it: th-cam.com/video/wWLOxRSll5Q/w-d-xo.html
The most simple, effective and very nicely explained
The best short video explanation for sparql. Thanks!
You explained the basics of SPARQL very well. I appreciate the time you put into this video, and I plan on buying your book.
did you get his book?
I looked at a number of explanations, but just could not get to grips with it. Watched your video, and now I understand the basics of SPARQL. Thanks.
I bought the book!!! Looking forward to learning more SPARQL. Thanks for the intro.
This channel is underrated.
An Intro Video can not get much better than this. Thanks to the video creator.
Excellent overview of SPARQL and precursor to printed resources from the expert who wrote the O'Reilly book "Learning SPARQL". Well done Bob DuCharme
Extremely useful, clear, and to the point. Thank you very much!
This is a excellent introduction to SPARQL. If I end up working more with it, I will definitely consider buying your book. Thank you.
It took me 2 days to understand this 11 minutes video. But it cover all basics of sparql. Thank you.
Saved my Uni Degree thank you
Very nice explanation.
That sound effect is certainly not obnoxious.
lmao
Great Introduction video!!
Very nice job, Bob, sharing with my colleagues.
Please consider enabling the video for community contribution to add subtitles translations.
The SPARQL query processor sound is so absurd that its awesome xddddd
Thanks! That's my Korg Monotron Duo.
One of the best tutorials I came across online! Thanks so much!
u saved my exam
Very useful, thanks a lot
Simple and sleek 👍
thank you sir !
Second time watching this great video, thanks.
Thank you, this was a really good description of RDF as well
Thanks Bob!
Good Video.
Thanks for the tutorial!
Was just wondering though at 8:10 the NOT EXISTS expression is written without FILTER (q7.rq). Would this be ok generally? As far as I understood, at least the Wikidata SPARQL endpoint requires the FILTER keyword along with NOT EXISTS.
Very good point. In a quick test I see that Wikidata does seem to require the FILTER keyword before NOT EXISTS and arq doesn't. I couldn't follow the official grammar at www.w3.org/TR/sparql11-query/#sparqlGrammar well enough to find an answer there, but I did find www.w3.org/2009/sparql/wiki/Design:Negation#Syntax, which says that "The keywords EXISTS and NOT EXISTS can be used both inside and outside FILTERs."
It's well explained. Nice work bro !
what exactly is the URI? can I create my own URI? or do I have to somehow base on something?
You can create your own. It's best to base it on a domain name that is under your control, so that for example if you create the URI myuri.org/vocab/dog to represent a dog you can actually put some data there (in which case it will then be a URL!)
very nice video. Thank you
Great video
super easy to follow.. thanks for this vedio
You posted only one video????????
Wow !! Nice job man . good explanation
That song at the end rocks xD
Thank you very much! I did the piano and drums with a scoring program (the parts are simple enough that I could have played them for real, but miking those well would be a pain) and then I played acoustic rhythm guitar, electric lead guitar and electric bass.
Does a URI, like your example "www.snee.com/hr/hireDate" have to be a live URL, or is the URI truly just a namespace and identifier?
Another way to ask this is if I have some data on some media presentations, like controlName (an internal identifier for our uses, examples include 160607_wpx_becton, 160607_wpx_smith, and 160607_wpx_jones), and I need to create a URI, can I use any thing for the URI (like our web address www.trufflemedia.com) plus some identifier info to create a URI like this "www.trufflemedia.com/presentation/160607_wpx_becton"?
What happens to URIs that use live URL addresses and then those domains are shut down. For example, if, in a dataset, I use a URI like "www.trufflemedia.com/presentation/160607_wpx_becton" and then the "www.trufflemedia.com" domain is shut down, is the URI still valid?
thx, very helpful SPARQL info.
It doesn't have to be a URL. It's just an identifier. The Linked Data movement stresses the value of making it a dereferenceable URL, so that is even better. If the domain is shut down, the URI still functions as an identifier, but obviously won't be a Locator any more if there's nothing at that location.
Aww, it's just a crummy advertisement?
jk, very good, clear video for a total beginner.
Where can we find the basic table (showing in 02:28 )?what is it's name??
I put a turtle file with those triples at learningsparql.com/2ndeditionexamples/sparqlIn11Minutes.ttl.
HI! Thanks very much for this video.
Can you suggest a tool to verfy if the request is correct!?
So we can make a conclusion to make it logically clear; that SPARQL "where" {....} instruction rely all the conditions inside it with "AND" by default, and to make it OR for some certain condition, we just put "optional" before it. Please tell me if I'm wrong..
That is correct. Just be careful with OR because it's asking the query engine to do a lot more scanning, which can slow things down. See www.bobdc.com/blog/dropping-optional-blocks-from/ for more.
Thanks for the excellent presentation.
Just a question, can the results of these queries be considered inferences?
Good question. The result of CONSTRUCT queries, which are new triples, can work as inferences. See www.bobdc.com/blog/materializing/ for more.
Great tutorial, thanks!
Dear Sir, currently I am trying to create a website about Linked Data for my internship. I found your video very helpful in explaining, therefore I was wondering whether it would be okay to embed this video on my website. The website has informative purposes
Sure
super useful thanksss!
Thanks, this was very helpful!
Amazing video, but I gotta ask something.
How is RDF used??
We have to write an RDF file from the content we have written for example in a news website or is it generated automatically by the computers.
Or is it something we only make for important stuff like Chemistry fromulas ??
I'm lost
It's popular for the metadata of content, especially when using the JSON-LD syntax, so that would be good for a news website. See www.bobdc.com/blog/json-ld/ for more on JSON-LD. (I will fix the screwy syntax highlighting in the examples sometime tomorrow.)
@@bobdc thank you ^___^
Does anyone know of a free environment to develop RDFs in?
protege.stanford.edu/
Nice video, thank you for explaining this!
Next time could you please go easy on that sound effect when you run a query, it gets really old really fast.
Thank you - this is a very helpful video.
I disagree that it's difficult to store a 'second completed orientation date' in such a table though (or that SPARQL makes this concept easier) (th-cam.com/video/FvGndkpa4K0/w-d-xo.html). That is an implementation of SPARQL that is separate to how the query is phrased in itself. That threw me off the first couple times that I watched this video, as I couldn't figure out what you meant.
in sql it's also easy to 'phrase' that same insertion statement: "insert into table values (emp1, engineer, date1), (emp1, engineer, date2);". And that would be fine in a denormalized table.
hi,
can you please explain why can't we use "vcard" for "hiredate" and for "completeorientaion" ? you said that those properties are not available in vcard and we didn't understand why- what is the reson
thanks a lot!!
+Bar Kohavi See the vcard ontology at www.w3.org/TR/vcard-rdf/ . You'll see that hireDate and completedOrientation are not part of the vcard vocabulary, so I had to make up new URIs for them, which is very easy in SPARQL.
Is there a great source to learn GeoSPARQL?
great job!
thanks, really help full
thx u so much you made my day :)
Thanks a lot!
this helped. thanks
Running a query sounds epic :p
Thanks! That's my Korg Monotron Duo (with stereo panning!)
Thank you...
bro, without inserting, how you are getting the data?
That depends on the query engine. For example, with Jena arq, on the command line you specify the query file and the data file to run it against.
bravo
အသစ်ဆုံးပထမ
I love you
SPARQL sucks. Looks like it was written by someone who doesn't know how SQL works.
But thank you for the video. It will make it more easier if you explain what each keyword does and even make a comparison with SQL.
For instance SELECT... FROM... WHERE... GROUP BY.. HAVING.. ORDER BY.. structure in SQL simplifies the selection, sourcing, filtering, aggregation, post aggregation filtering and sorting. What will be the equivalent of that in SPARQL. How is a WHERE in SQL is different (ex: order of conditions is irrelevant vs sequential filtering in SPARQL)..
fuk yeah
.
the URI thing is dumb
Who the fuck uses this ? lol
Great video! Thank you so much