Difference between revisions of "2018-19 Academic Year Research Report"

From Wikibase.slis.ua.edu
Jump to navigation Jump to search
Line 18: Line 18:
 
### [https://wikibase.slis.ua.edu/sparql/#%23%20Rushing%20touchdowns%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8.%0A%20%20%3FPlay%20wdt%3AP16%20wd%3AQ39.%0A%20%20%3FPlay%20wdt%3AP38%20%3Fplays__statYardage.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29%0A%7D%0ALIMIT%20100 Rushing touchdowns for plays over 50 yards during the 2017 Alabama Crimson Tide football season]
 
### [https://wikibase.slis.ua.edu/sparql/#%23%20Rushing%20touchdowns%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8.%0A%20%20%3FPlay%20wdt%3AP16%20wd%3AQ39.%0A%20%20%3FPlay%20wdt%3AP38%20%3Fplays__statYardage.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29%0A%7D%0ALIMIT%20100 Rushing touchdowns for plays over 50 yards during the 2017 Alabama Crimson Tide football season]
 
### [https://wikibase.slis.ua.edu/sparql/#%23%20Touchdown%20passes%20involving%20Jalen%20Hurts%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8%3B%20%20%23Is%20a%20play%0A%20%20%20%20%20%20%20%20wdt%3AP16%20wd%3AQ35%3B%20%20%23Touchdown%20pass%20play%0A%20%20%20%20%20%20%20%20wdt%3AP60%20wd%3AQ1355%3B%20%23Jalen%20Hurts%20as%20a%20participating%20player%0A%20%20%20%20%20%20%20%20wdt%3AP38%20%3Fplays__statYardage.%20%23%20Yardage%20gain%0A%20%20%20%20%20%20%20%20%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29.%20%20%23Yardage%20gained%20%3E%3D%2050%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%7D%0ALIMIT%20100 Touchdown passes involving Jalen Hurts for plays over 50 yards]
 
### [https://wikibase.slis.ua.edu/sparql/#%23%20Touchdown%20passes%20involving%20Jalen%20Hurts%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8%3B%20%20%23Is%20a%20play%0A%20%20%20%20%20%20%20%20wdt%3AP16%20wd%3AQ35%3B%20%20%23Touchdown%20pass%20play%0A%20%20%20%20%20%20%20%20wdt%3AP60%20wd%3AQ1355%3B%20%23Jalen%20Hurts%20as%20a%20participating%20player%0A%20%20%20%20%20%20%20%20wdt%3AP38%20%3Fplays__statYardage.%20%23%20Yardage%20gain%0A%20%20%20%20%20%20%20%20%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29.%20%20%23Yardage%20gained%20%3E%3D%2050%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%7D%0ALIMIT%20100 Touchdown passes involving Jalen Hurts for plays over 50 yards]
−
# One important result of our research work during this academic year is the demonstration of the use of linked data to provide access to individual multimedia assets that document individual plays. As shown above, an individual play can be discovered by navigating the linked data application or by querying the triplestore using SPARQL. In these examples, you will find video clips for each play thus demonstrating how linked data navigation or querying methods can lead to multimedia assets of those plays:
+
# '''<u>Applied research results: The use of linked data to provide access to multimedia assets</u>'''. One important result of our research work during this academic year is the demonstration of the use of linked data to provide access to individual multimedia assets that document individual plays. As shown above, an individual play can be discovered by navigating the linked data application or by querying the triplestore using SPARQL. In these examples, you will find video clips for each play thus demonstrating how linked data navigation or querying methods can lead to multimedia assets of those plays:
 
## [https://wikibase.slis.ua.edu/wiki/Tua_Tagovailoa_pass_complete_to_DeVonta_Smith_for_27_yds_for_a_TD_(Andy_Pappanastos_KICK)_(9/23/17) Tua Tagovailoa pass complete to DeVonta Smith for 27 yds for a TD]
 
## [https://wikibase.slis.ua.edu/wiki/Tua_Tagovailoa_pass_complete_to_DeVonta_Smith_for_27_yds_for_a_TD_(Andy_Pappanastos_KICK)_(9/23/17) Tua Tagovailoa pass complete to DeVonta Smith for 27 yds for a TD]
 
## [https://wikibase.slis.ua.edu/wiki/Da%27Ron_Payne_1_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) Da'Ron Payne 1 Yd pass from Jalen Hurts]
 
## [https://wikibase.slis.ua.edu/wiki/Da%27Ron_Payne_1_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) Da'Ron Payne 1 Yd pass from Jalen Hurts]
 
## [https://wikibase.slis.ua.edu/wiki/Damien_Harris_run_for_75_yds_for_a_TD_(Andy_Pappanastos_KICK)_(10-14-17) Damien Harris run for 75 yds for a TD]
 
## [https://wikibase.slis.ua.edu/wiki/Damien_Harris_run_for_75_yds_for_a_TD_(Andy_Pappanastos_KICK)_(10-14-17) Damien Harris run for 75 yds for a TD]
 
## [https://wikibase.slis.ua.edu/wiki/Calvin_Ridley_12_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) Calvin Ridley 12 Yd pass from Jalen Hurts]
 
## [https://wikibase.slis.ua.edu/wiki/Calvin_Ridley_12_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) Calvin Ridley 12 Yd pass from Jalen Hurts]
−
# Important collaborators contributing to the research reported here:
+
# '''<u>Collaborator information</u>'''. Important collaborators contributing to the research reported here:
 
## '''[https://www.ua.edu/news/ua-theme-expert/gregory-bott/ Dr. Greg Bott]''', Assistant Professor, UA Culverhouse School of Business. Dr. Bott is co-PI on the RGC grant providing data management expertise focusing on optimizing the efficiency of data wrangling methods using Python scripting
 
## '''[https://www.ua.edu/news/ua-theme-expert/gregory-bott/ Dr. Greg Bott]''', Assistant Professor, UA Culverhouse School of Business. Dr. Bott is co-PI on the RGC grant providing data management expertise focusing on optimizing the efficiency of data wrangling methods using Python scripting
 
## '''David McMillan''', IT Team Leader, Enterprise Development & Application Support, UA Office of Information Technology (OIT). David has been a long time collaborator beginning in the late 1990s when he was Systems Admin in the School of Library and Information Studies, and we were co-authors on a UA patent. In the current research project, David has contributed crucial support in the installation, optimization, and ongoing management of the Mediawiki/Wikibase instance hosted by [https://oit.ua.edu/ UA OIT].
 
## '''David McMillan''', IT Team Leader, Enterprise Development & Application Support, UA Office of Information Technology (OIT). David has been a long time collaborator beginning in the late 1990s when he was Systems Admin in the School of Library and Information Studies, and we were co-authors on a UA patent. In the current research project, David has contributed crucial support in the installation, optimization, and ongoing management of the Mediawiki/Wikibase instance hosted by [https://oit.ua.edu/ UA OIT].
 
## '''Huapu Liu''', Graduate Research Assistant and MLIS student. Huapu served as my graduate research assistant for the entire 2018-19 academic year serving as an indispensable collaborator in the development of our understanding of Wikibase and linked data, which was essentially a long series of trial and error steps. Huapu helped me compose over 25 pages of data wrangling procedures needed to transform the JSON-encoded statistical play-by-play datasets into linked data in Wikibase. He also did more than his share of [https://wikibase.slis.ua.edu/sparql/#%23Cats%0ASELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP63%20wd%3AQ3398.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D data wrangling]! ('''to run SPARQL query, click on the Blue Arrow icon in lower left portion of screen after clicking on link''')
 
## '''Huapu Liu''', Graduate Research Assistant and MLIS student. Huapu served as my graduate research assistant for the entire 2018-19 academic year serving as an indispensable collaborator in the development of our understanding of Wikibase and linked data, which was essentially a long series of trial and error steps. Huapu helped me compose over 25 pages of data wrangling procedures needed to transform the JSON-encoded statistical play-by-play datasets into linked data in Wikibase. He also did more than his share of [https://wikibase.slis.ua.edu/sparql/#%23Cats%0ASELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP63%20wd%3AQ3398.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D data wrangling]! ('''to run SPARQL query, click on the Blue Arrow icon in lower left portion of screen after clicking on link''')
 
## '''Christine Schultz-Richert''', MLIS student. Christine joined the research team in early April after hearing about this project in the presentation I made about it in our LS 566 Metadata course. In this short amount of time, Christine was able to accomplish quite a bit in [https://wikibase.slis.ua.edu/sparql/#%23Cats%0ASELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP63%20wd%3AQ3199.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D wrangling data for us].
 
## '''Christine Schultz-Richert''', MLIS student. Christine joined the research team in early April after hearing about this project in the presentation I made about it in our LS 566 Metadata course. In this short amount of time, Christine was able to accomplish quite a bit in [https://wikibase.slis.ua.edu/sparql/#%23Cats%0ASELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP63%20wd%3AQ3199.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D wrangling data for us].

Revision as of 22:08, 29 April 2019

This is an addendum to my 2018-19 Academic Year Research Report submitted for review via Digital Measures.

Online documentation for research accomplishments:

  1. Progress Report: RGC grant-funded research accomplishments thus far. We were able to successfully convert publicly accessible JSON-encoded statistical play-by-play datasets for all 14 games in the 2017 Alabama Crimson Tide football season into a linked data application using Wikibase. One can now navigate from play to play, drive to drive, and game to game within the 2017 football season using data drawn from existing statistical play-by-play datasets incorporated into the application by way of linked data methods. Highlights:
    1. Example of a JSON-encoded statistical play-by-play dataset from 2017 Alabama versus Florida State football game.
    2. Property list for the ontology developed for this application.
    3. Examples of three types of entities ("play" "drive" "game") in our linked data application. Each example provides links to Mediawiki site pages and to Wikibase item pages (each item page contains the metadata statements (each statement a "triple") about each entity using properties drawn from our ontology):
      1. Mediawiki site page for a typical play (here is this play's corresponding Wikibase item page)
      2. Mediawiki site page for a typical drive (here is this drive's corresponding Wikibase item page)
      3. Mediawiki site page for a typical game (here is this game's corresponding Wikibase item page)
    4. Infobox templates deployed to generate infoboxes on each Mediawiki page:
      1. For a play
      2. For a drive
      3. For a game
    5. Example SPARQL queries for retrieving entity instances (to run each query, click on the Blue Arrow icon in lower left portion of screen after clicking on links below):
      1. Rushing touchdowns for plays over 50 yards during the 2017 Alabama Crimson Tide football season
      2. Touchdown passes involving Jalen Hurts for plays over 50 yards
  2. Applied research results: The use of linked data to provide access to multimedia assets. One important result of our research work during this academic year is the demonstration of the use of linked data to provide access to individual multimedia assets that document individual plays. As shown above, an individual play can be discovered by navigating the linked data application or by querying the triplestore using SPARQL. In these examples, you will find video clips for each play thus demonstrating how linked data navigation or querying methods can lead to multimedia assets of those plays:
    1. Tua Tagovailoa pass complete to DeVonta Smith for 27 yds for a TD
    2. Da'Ron Payne 1 Yd pass from Jalen Hurts
    3. Damien Harris run for 75 yds for a TD
    4. Calvin Ridley 12 Yd pass from Jalen Hurts
  3. Collaborator information. Important collaborators contributing to the research reported here:
    1. Dr. Greg Bott, Assistant Professor, UA Culverhouse School of Business. Dr. Bott is co-PI on the RGC grant providing data management expertise focusing on optimizing the efficiency of data wrangling methods using Python scripting
    2. David McMillan, IT Team Leader, Enterprise Development & Application Support, UA Office of Information Technology (OIT). David has been a long time collaborator beginning in the late 1990s when he was Systems Admin in the School of Library and Information Studies, and we were co-authors on a UA patent. In the current research project, David has contributed crucial support in the installation, optimization, and ongoing management of the Mediawiki/Wikibase instance hosted by UA OIT.
    3. Huapu Liu, Graduate Research Assistant and MLIS student. Huapu served as my graduate research assistant for the entire 2018-19 academic year serving as an indispensable collaborator in the development of our understanding of Wikibase and linked data, which was essentially a long series of trial and error steps. Huapu helped me compose over 25 pages of data wrangling procedures needed to transform the JSON-encoded statistical play-by-play datasets into linked data in Wikibase. He also did more than his share of data wrangling! (to run SPARQL query, click on the Blue Arrow icon in lower left portion of screen after clicking on link)
    4. Christine Schultz-Richert, MLIS student. Christine joined the research team in early April after hearing about this project in the presentation I made about it in our LS 566 Metadata course. In this short amount of time, Christine was able to accomplish quite a bit in wrangling data for us.
Retrieved from "http://wikibase.slis.ua.edu/w/index.php?title=2018-19_Academic_Year_Research_Report&oldid=143223"