SPARQL in 11 minutes
An introduction to the W3C query language for RDF. Sample data and queries used in video available at learningsparql.com/misc/sparql.... See www.learningsparql.com for more information and see the complete first chapter of “Learning SPARQL” at www.oreilly.com/library/view/....
Пікірлер: 112
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"
@ChrisLuigiTails
4 жыл бұрын
Recursion. Like the "B" in "Benoit B. Mandelbrot" stands for "Benoit B Mandelbrot".
@charliepank528
4 жыл бұрын
@@ChrisLuigiTails "WINE" stands for Wine Is Not an Emulator; "PINE" stands for Pine Is Not Elm and so on...
@MindlessZombie2006
4 жыл бұрын
@@charliepank528 And GNU is Not Unix :D
@lorenzogabriele9533
3 жыл бұрын
Recursive names are a pretty common practice in CS actually :-)
@mariuseza812
3 жыл бұрын
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.
@malighos
6 жыл бұрын
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
@moonisali5296
4 жыл бұрын
@@malighos I have an assignment submission on Saturday and believe me, I feel how it is. #Bliss
@kayicomert7933
4 жыл бұрын
How were you in the presentation? :D
@ahmedboulahia6033
4 жыл бұрын
@@malighos did you nailed it?
@raghadmadwar8440
4 жыл бұрын
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
@BobDuCharme
5 жыл бұрын
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: kzread.info/dash/bejne/qYuAsdqLg8_SZbQ.html
The best short video explanation for sparql. Thanks!
Extremely useful, clear, and to the point. Thank you very much!
An Intro Video can not get much better than this. Thanks to the video creator.
The most simple, effective and very nicely explained
You explained the basics of SPARQL very well. I appreciate the time you put into this video, and I plan on buying your book.
@instaminox
2 жыл бұрын
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.
One of the best tutorials I came across online! Thanks so 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.
I bought the book!!! Looking forward to learning more SPARQL. Thanks for the intro.
This channel is underrated.
Very nice job, Bob, sharing with my colleagues.
Excellent overview of SPARQL and precursor to printed resources from the expert who wrote the O'Reilly book "Learning SPARQL". Well done Bob DuCharme
Thank you, this was a really good description of RDF as well
Second time watching this great video, thanks.
It's well explained. Nice work bro !
Saved my Uni Degree thank you
Great Introduction video!!
Wow !! Nice job man . good explanation
Thanks, this was very helpful!
Great tutorial, thanks!
super useful thanksss!
Great video! Thank you so much
thx u so much you made my day :)
super easy to follow.. thanks for this vedio
Very useful, thanks a lot
Simple and sleek 👍
Very nice explanation.
Thanks Bob!
Thanks a lot!
The SPARQL query processor sound is so absurd that its awesome xddddd
@BobDuCharme
3 жыл бұрын
Thanks! That's my Korg Monotron Duo.
u saved my exam
great job!
very nice video. Thank you
thanks, really help full
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.
@BobDuCharme
3 жыл бұрын
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."
That sound effect is certainly not obnoxious.
@_3nlil
8 ай бұрын
lmao
this helped. thanks
thank you sir !
Please consider enabling the video for community contribution to add subtitles translations.
HI! Thanks very much for this video. Can you suggest a tool to verfy if the request is correct!?
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) (kzread.info/dash/bejne/eKp70MakoMSae5M.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.
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.
That song at the end rocks xD
@bobdc
4 жыл бұрын
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.
Aww, it's just a crummy advertisement? jk, very good, clear video for a total beginner.
Good Video.
Thanks for the excellent presentation. Just a question, can the results of these queries be considered inferences?
@bobdc
3 жыл бұрын
Good question. The result of CONSTRUCT queries, which are new triples, can work as inferences. See www.bobdc.com/blog/materializing/ for more.
Thank you...
what exactly is the URI? can I create my own URI? or do I have to somehow base on something?
@BobDuCharme
4 жыл бұрын
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!)
Is there a great source to learn GeoSPARQL?
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
@BobDuCharme
5 жыл бұрын
Sure
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
@bobdc
4 жыл бұрын
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.)
@TheMaldingZucchini
4 жыл бұрын
@@bobdc thank you ^___^
You posted only one video????????
Running a query sounds epic :p
@BobDuCharme
5 жыл бұрын
Thanks! That's my Korg Monotron Duo (with stereo panning!)
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!!
@bobdc
8 жыл бұрын
+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.
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..
@bobdc
3 жыл бұрын
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.
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.
@bobdc
7 жыл бұрын
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.
bravo
Where can we find the basic table (showing in 02:28 )?what is it's name??
@BobDuCharme
5 жыл бұрын
I put a turtle file with those triples at learningsparql.com/2ndeditionexamples/sparqlIn11Minutes.ttl.
Does anyone know of a free environment to develop RDFs in?
@astucieuxzephyr
3 жыл бұрын
protege.stanford.edu/
I love you
bro, without inserting, how you are getting the data?
@BobDuCharme
5 жыл бұрын
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.
အသစ်ဆုံးပထမ
fuk yeah
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)..
.
the URI thing is dumb
Who the fuck uses this ? lol