robt00/cs7is1

Knowledge & Data Engineering Project

CS7IS1

Knowledge & Data Engineering Project; Uplifiting F1 Data into RDF

Let's add some details here

10 Queries:

Which driver won race Y in season X ? Which constructor won the Y race in season X? Which circuit had the fastest lap time in season X? Which driver recorded the slowest lap time in year X ? What was the slowest lap time in year / season X? Which driver won the most races in season Y? Which driver won the championship in season X? Which constructor won the championship in season Y? Which driver got the most pole positions in season Y? Which constructor got the most pole positions in season Y?

13 Classes:

    http://example.org/f1/DriverStandings
    http://example.org/f1/LapTimes
    http://example.org/f1/Results
    http://example.org/f1/Qualifying
    http://example.org/f1/ConstructorStandings
    http://example.org/f1/ConstructorResults
    http://example.org/f1/PitStops
    http://example.org/f1/Driver
    http://example.org/f1/Race
    http://example.org/f1/Status
    http://example.org/f1/Constructor
    http://example.org/f1/Circuit
    http://example.org/f1/Season

49+ Properties:

    http://example.org/f1/driverid
    http://example.org/f1/driverstandingsid
    http://example.org/f1/points
    http://example.org/f1/position
    http://example.org/f1/raceid
    http://example.org/f1/wins
    http://example.org/f1/lap
...

Loading TripleStore

Setting Up Stardog

Follow the StarDog documnentation to create a local stardog server.

1. Start Server

stardog-admin server start --disable-security

2. (Optional) If querying to graph database externally, tunnel localhost port

./ngrok http 5820

3. Load database through interface using full_output_2.ttl

4. Get querying! Existing Sampel Queries in SPARQL_F1_queries

Explore Formula 1 Ontology Visually

Go to WebOwl Visual and Upload file f1_w_restrictions.owl to visualise ontology.

Ask the Chatbot any of the following questions

1. Which driver won race Y in season X ? 2. Which constructor won the Y race in season X? 3. Which circuit had the fastest lap time in season X? 4. Which driver recorded the slowest lap time in year X ? 5. What was the slowest lap time in year / season X? 6. Which driver won the most races in season Y? 7. Which driver won the championship in season X? 8. Which constructor won the championship in season Y? 9. Which driver got the most pole positions in season Y? 10. Which constructor got the most pole positions in season Y? 11. What was the main/leading reasons for not finishing a race in season X?

Ontology Documentation

Documentation of Ontology is done using Widoco. Output files are in F1_Ontology_Documentation/ folder.

Create Ontologies for Following Datasets by Friday (15th Nov)

WebProtege

Name	Datasets
Rob	circuits, lapTimes, pitStops
Uzair	constructor, constructorsStandings, constructorsResults
Sophie	drivers,driverStandings, results
Dhruv	races, seasons
Warren	status, qualifying