Grupo 3
Financiamento Desportivo
Com este trabalho pretende-se desenvolver um perfil de aplicação com o objetivo de divulgar informação sobre o financiamento público, dado às várias modalidades desportivas, o doping, o número de praticantes por escalão etário, e também sobre os formados em cursos desportivos, em Portugal, ao longo dos anos, através da utilização de Open Linked Data.
Na figura que se segue está representado o nosso Plano de Projeto. Este plano irá servir de guia de modo a auxiliar a equipa de trabalho desde o dia em que foi realizado o plano, até ao dia da apresentação final. No plano encontram-se detalhadas as atividades que irão ser desenvolvidas no ao longo do projeto, assim como a duração de cada uma dessas atividades.
Figura 1 - Plano de Projeto
Os requisitos de alto nível são compostos pelos requisitos funcionais e pelos requisitos não-funcionais. No âmbito de um trabalho desta natureza apenas serão utilizados os requisitos funcionais.
Pesquisar por:
Comparar por:
Para demonstrar os requisitos funcionais anteriormente definidos, de forma simples e intuituva, apresenta-se de seguida o diagrama de casos de uso em notação UML.
Figura 2 - Modelo de Casos de Uso
O modelo de domínio representa as relações existentes entre os metadados. Este modelo é a representação base para a criação do perfil de aplicação, isto é, a identificação de classes e as suas relações.
Figura 3 - Modelo de Dominio
O Dataset utilizado contém registos relativos a 12 anos, de 2003 a 2014, e apresenta apenas 5 colunas, sendo elas o Ano, Federação Desportiva (encontra-se listado em sub-coluna desta as várias modalidades), Doping (encontra-se listado em sub-coluna a percentagem de violações e o número de modalidades controladas), Praticantes por escalão etário (encontra-se listado em sub-coluna os vários escalões etários, sendo eles, Até Juniores, Juniores, Seniores e Veteranos) e Formados em cursos Desportivos (encontra-se listado em sub-coluna Treinador e Árbitros e Juízes). A forma que arranjamos para tratar as sub-colunas foi tratá-las como atributos e criamos um novo atributo para tratar o valor a que corresponde por ano. No caso da tabela Federações_Desportivas, criamos o nome_modalidade, para representar a sub-coluna com as várias modalidades, e criamos também o valor_financeiro, para representar o valor que é atribuido a cada modalidade por ano. No caso da tabela Doping, não foi necessário criar nenhum atributo, isto porque a informação de cada sub-coluna não fazia sentido agregar. No caso da tabela Praticantes_por_Escalão_Etário criamos o atributo Escalão, que representa todos os escalões listados na sub-coluna, e também criamos o atributo numero_praticantes, para representar o numero de praticantes existentes por escalão ao longo dos anos. No caso da tabela Formados_Cursos_Desportivos criamos o atributo tipo_formados, para representar as sub-colunas treinadores e árbitros e Juízes, e também criamos o atributo numero_formados, para representar o numero de formados por ano. Temos ainda a tabela Calendário, onde temos o atributo ano, isto porque toda a informação existente diz respeito aos anos. (Link relativo ao dataset utilizado como base para a realização deste trabalho https://drive.google.com/file/d/1E2QH4PUmm93Eyh_CK8xDeBsYAfR8PF49/view?usp=sharing)
Tabela 1 - Lista de Vocabulário
Nome | Prefixo | Full name URL | Descrição |
---|---|---|---|
An Ontology for vCards | vcard | http://www.w3.org/2006/vcard/ns | “This Ontology models and represents vCards in RDS, using best practises” |
Time Ontology | time | http://www.w3.org/2006/time | “This vocabulary defines temporal entities such time intervals” |
Friend of a Friend vocabulary | foaf | http://xmlns.com/foaf/spec/ | “FOAF is a project devoted to linking people and information using the Web. Regardless of whether information is in people's heads, in physical or digital documents, or in the form of factual data, it can be linked”. |
The DBpedia Ontology | dbpedia-owl | http://dbpedia.org/ontology/ | “The DBpedia ontology provides the classes and properties used in the DBpedia data set”. |
The RDF Concepts Vocabulary | rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# | “This is the RDF Schema for the RDF vocabulary terms in the RDF Namespace, defined in RDF 1.1 Concepts”. |
Schema.org vocabulary | schema | http://schema.org/ | “Search engines including Bing, Google, Yahoo! and Yandex rely on schema.org markup to improve the display of search results, making it easier for people to find the right web pages”. |
DCMI Metadata Terms | dcterms | http://purl.org/dc/terms/ | “An up-to-date specification of all metadata terms maintained by the Dublin Core Metadata Initiative, including properties, vocabulary encoding schemes, syntax encoding schemes, and classes”. |
VIVO Core Ontology | vivo | http://vivoweb.org/ontology/core | “An ontology of academic and research domain, developed in the framework of the VIVO project”. |
Tabela 2 - NameSpaces
NameSpaces
Attribute original name | Label | Namespace | Namespace prefix | Property_Name |
---|---|---|---|---|
nome_pais | country | http://www.w3.org/2006/vcard/ns | vcard | Country-name |
nome_modalidades | sport | http://wikiWS.org/sports-financing | fd | sport |
valor_financeiro | finance value | http://wikiWS.org/sports-financing | fd | FinanceValue |
per_violacoes | doping violations % | http://wikiWS.org/sports-financing | fd | percentageViolation |
numero_modalidades_controladas | federation controlled | http://wikiWS.org/sports-financing | fd | federationControlled |
ano | year | http://dbpedia.org/ontology/year | dbpedia-owl | year |
Escalão | Age category | http://wikiWS.org/sports-financing | fd | ageCategory |
numero_praticantes_por_escalao | number of athletes per Age category | http://wikiWS.org/sports-financing | fd | numberAthletesAC |
Tipo_formados | types of graduates | http://wikiWS.org/sports-financing | fd | typesOfGraduates |
numero_formados | number of graduates | http://wikiWS.org/sports-financing | fd | numberOfGraduates |
Atributos | Property name | Original Domain | Original Range | Domain in the MAP | Range in the MAP | Cardinality |
---|---|---|---|---|---|---|
nome_pais | Country-name | Unspecified | Xsd:string | fd:financiamentoDesportivo | Xsd:string, TGN (exactly location: http://vocab.getty.edu/page/tgn/1000090) | 1-2 |
nome_modalidades | sport | Unspecified | Unspecified | fd:financiamentoDesportivo | novo vocabulário a criar (SKOS) | 1…* |
valor_financeiro | financeValue | Unspecified | Unspecified | fd:financiamentoDesportivo | Xsd:int | 1…* |
per_violacoes | percentageViolation | Unspecified | Unspecified | fd:financiamentoDesportivo | Xsd:int | 1…* |
numero_modalidades_controladas | federationControlled | Unspecified | Unspecified | fd:financiamentoDesportivo | Xsd:int | 1…* |
ano | year | owl:Thing | Xsd:gYear | fd:financiamentoDesportivo | Xsd:gYear | 1…* |
Escalão | ageCategory | Unspecified | Unspecified | fd:financiamentoDesportivo | novo vocabulário a criar (SKOS) | 1-4 |
numero_praticantes_por_escalao | numberOfAthletesAC | Unspecified | Unspecified | fd:financiamentoDesportivo | Xsd:int | 1…* |
Tipo_formados | typesOfGraduates | Unspecified | Unspecified | fd:financiamentoDesportivo | novo vocabulário a criar (SKOS) | 1-2 |
numero_formados | numberOfGraduates | Unspecified | Unspecified | fd:financiamentoDesportivo | Xsd:int | 1…* |
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:dc="http://purl.org/dc/elements/1.1/"> <skos:ConceptScheme rdf:about="http://wikiWS.org/sports-financing"> <dc:title>Tipo de Modalidades</dc:title> <dc:date>2018</dc:date> <skos:hasTopConcept rdf:resource="#2018000"/> <skos:hasTopConcept rdf:resource="#2018001"/> <skos:hasTopConcept rdf:resource="#2018002"/> <skos:hasTopConcept rdf:resource="#2018003"/> <skos:hasTopConcept rdf:resource="#2018004"/> <skos:hasTopConcept rdf:resource="#2018005"/> <skos:hasTopConcept rdf:resource="#2018006"/> <skos:hasTopConcept rdf:resource="#2018007"/> <skos:hasTopConcept rdf:resource="#2018008"/> <skos:hasTopConcept rdf:resource="#2018009"/> <skos:hasTopConcept rdf:resource="#2018010"/> <skos:hasTopConcept rdf:resource="#2018011"/> <skos:hasTopConcept rdf:resource="#2018012"/> <skos:hasTopConcept rdf:resource="#2018013"/> <skos:hasTopConcept rdf:resource="#2018014"/> <skos:hasTopConcept rdf:resource="#2018015"/> <skos:hasTopConcept rdf:resource="#2018016"/> <skos:hasTopConcept rdf:resource="#2018017"/> <skos:hasTopConcept rdf:resource="#2018018"/> <skos:hasTopConcept rdf:resource="#2018019"/> </skos:ConceptScheme> <skos:Concept rdf:about="#2018001" xml:lang=""> <skos:prefLabel xml:lang="pt">Andebol</skos:prefLabel> <skos:altLabel xml:lang="en">Handball</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018002" xml:lang=""> <skos:prefLabel xml:lang="pt">Atletismo</skos:prefLabel> <skos:altLabel xml:lang="en">Athletics</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018003" xml:lang=""> <skos:prefLabel xml:lang="pt">Basquetebol</skos:prefLabel> <skos:altLabel xml:lang="en">Basketball</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018004" xml:lang=""> <skos:prefLabel xml:lang="pt">Campismo e Montanhismo</skos:prefLabel> <skos:altLabel xml:lang="en">Camping and Mountaineering</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018005" xml:lang=""> <skos:prefLabel xml:lang="pt">Ciclismo</skos:prefLabel> <skos:altLabel xml:lang="en">Cycling</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018006" xml:lang=""> <skos:prefLabel xml:lang="pt">Columbofilia</skos:prefLabel> <skos:altLabel xml:lang="en">Columbofilia</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018007" xml:lang=""> <skos:prefLabel xml:lang="pt">Futebol</skos:prefLabel> <skos:altLabel xml:lang="en">Football</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018008" xml:lang=""> <skos:prefLabel xml:lang="pt">Ginástica</skos:prefLabel> <skos:altLabel xml:lang="en">Gymnastics</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018009" xml:lang=""> <skos:prefLabel xml:lang="pt">Golfe</skos:prefLabel> <skos:altLabel xml:lang="en">Gulf</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018010" xml:lang=""> <skos:prefLabel xml:lang="pt">Judo</skos:prefLabel> <skos:altLabel xml:lang="en">Judo</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018011" xml:lang=""> <skos:prefLabel xml:lang="pt">Karaté</skos:prefLabel> <skos:altLabel xml:lang="en">Karaté</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018012" xml:lang=""> <skos:prefLabel xml:lang="pt">Natação</skos:prefLabel> <skos:altLabel xml:lang="en">Swimming</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018013" xml:lang=""> <skos:prefLabel xml:lang="pt">Patinagem</skos:prefLabel> <skos:altLabel xml:lang="en">Skating</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018014" xml:lang=""> <skos:prefLabel xml:lang="pt">Rugby</skos:prefLabel> <skos:altLabel xml:lang="en">Rugby</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018015" xml:lang=""> <skos:prefLabel xml:lang="pt">Ténis</skos:prefLabel> <skos:altLabel xml:lang="en">Tennis</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018016" xml:lang=""> <skos:prefLabel xml:lang="pt">Vela</skos:prefLabel> <skos:altLabel xml:lang="en">Sailing</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018017" xml:lang=""> <skos:prefLabel xml:lang="pt">Voleibol</skos:prefLabel> <skos:altLabel xml:lang="en">Volleybal</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018018" xml:lang=""> <skos:prefLabel xml:lang="pt">Comité Olímpico Portugês</skos:prefLabel> <skos:altLabel xml:lang="en">Portuguese Olympic Committee</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018019" xml:lang=""> <skos:prefLabel xml:lang="pt">Comité Paralímpico Portugês</skos:prefLabel> <skos:altLabel xml:lang="en">Portuguese Paralympic Committee</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> </rdf:RDF>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:dc="http://purl.org/dc/elements/1.1/"> <skos:ConceptScheme rdf:about="http://wikiWS.org/sports-financing"> <dc:title>Praticantes por escalão etário</dc:title> <dc:date>2018</dc:date> <skos:hasTopConcept rdf:resource="#2018201"/> <skos:hasTopConcept rdf:resource="#2018202"/> <skos:hasTopConcept rdf:resource="#2018203"/> <skos:hasTopConcept rdf:resource="#2018204"/> </skos:ConceptScheme> <skos:Concept rdf:about="#2018201" xml:lang=""> <skos:prefLabel xml:lang="pt">Até Juniores</skos:prefLabel> <skos:altLabel xml:lang="en">all Under 17years</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018202" xml:lang=""> <skos:prefLabel xml:lang="pt">Juniores</skos:prefLabel> <skos:altLabel xml:lang="en">Juniors</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018203" xml:lang=""> <skos:prefLabel xml:lang="pt">Seniores</skos:prefLabel> <skos:altLabel xml:lang="en">Senior</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018204" xml:lang=""> <skos:prefLabel xml:lang="pt">Veteranos</skos:prefLabel> <skos:altLabel xml:lang="en">Veterans</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> </rdf:RDF>
Figura 5 - Grafo relativo à Faixa Etária
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:dc="http://purl.org/dc/elements/1.1/"> <skos:ConceptScheme rdf:about="http://wikiWS.org/sports-financing"> <dc:title>Formados em cursos Desportivos</dc:title> <dc:date>2018</dc:date> <skos:hasTopConcept rdf:resource="#2018301"/> <skos:hasTopConcept rdf:resource="#2018302"/> </skos:ConceptScheme> <skos:Concept rdf:about="#2018301" xml:lang=""> <skos:prefLabel xml:lang="pt">Treinadores</skos:prefLabel> <skos:altLabel xml:lang="en">Coaches</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> <skos:Concept rdf:about="#2018302" xml:lang=""> <skos:prefLabel xml:lang="pt">Árbitros e JuÌzes</skos:prefLabel> <skos:altLabel xml:lang="en">Arbitrators and Judges</skos:altLabel> <skos:inScheme rdf:resource="http://wikiWS.org/sports-financing"/> <skos:topConceptOf rdf:resource="http://wikiWS.org/sports-financing"/> </skos:Concept> </rdf:RDF>
Figura 6 - Grafo relativo aos formados
Para a realização do RDF, utilizamos como base os dados referentes a 1 ano, o ano 2014, sendo que o dataset contém registo de 12 anos, de 2003 a 2014. No caso dos Formados em Cursos Desportivos utilizamos o ano 2013, visto que não havia registos para o ano 2014.
<?xml version="1.0" encoding="utf-8"?> <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:time="http://www.w3.org/2006/time" xmlns:vcard="http://www.w3.org/2006/vcard/ns" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dbpedia="http://dbpedia.org/ontology/" xmlns:vivo="http://vivoweb.org/ontology/core/" xmlns:fd="http://wikiWS.org/sports-financing"> <!--Federacoes Desportivas--> <rdf:Description rdf:about="https://www.fpf.pt"> <rdf:type rdf:resource="http://purl.org/dc/terms/Location"/> <!-- Andebol --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Andebol</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>2009855</fd:FinanceValue> </vivo:subjectArea> <!-- Atletismo --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Atletismo</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>255020</fd:FinanceValue> </vivo:subjectArea> <!-- Basquetebol --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Basquetebol</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>1982280</fd:FinanceValue> </vivo:subjectArea> <!-- Campismo e Montanhismo --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Campismo e Montanhismo</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>73500</fd:FinanceValue> </vivo:subjectArea> <!-- Ciclismo --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Ciclismo</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>863000</fd:FinanceValue> </vivo:subjectArea> <!-- Columbofilia --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Columfilia</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>37000</fd:FinanceValue> </vivo:subjectArea> <!-- Futebol --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Futebol</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>1815000</fd:FinanceValue> </vivo:subjectArea> <!-- Ginástica --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Ginástica</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>1127500</fd:FinanceValue> </vivo:subjectArea> <!-- Golfe --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Golfe</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>310230</fd:FinanceValue> </vivo:subjectArea> <!-- Judo --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Judo</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>1155400</fd:FinanceValue> </vivo:subjectArea> <!-- Karaté --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Karaté</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>140000</fd:FinanceValue> </vivo:subjectArea> <!-- Natação --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Natação</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>1590800</fd:FinanceValue> </vivo:subjectArea> <!-- Patinagem --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Patinagem</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>765236</fd:FinanceValue> </vivo:subjectArea> <!-- Rugby --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Rugby</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>754000</fd:FinanceValue> </vivo:subjectArea> <!-- Ténis --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Ténis</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>666000</fd:FinanceValue> </vivo:subjectArea> <!-- Vela --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Vela</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>712000</fd:FinanceValue> </vivo:subjectArea> <!-- Voleibol --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Voleibol</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>1613255</fd:FinanceValue> </vivo:subjectArea> <!-- Comité Olímpico Português --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Comité Olímpico Português</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>4982875</fd:FinanceValue> </vivo:subjectArea> <!-- Comité Paralímpico Português --> <vivo:subjectArea rdf:parseType="Resource"> <vcard:country rdf:parseType="Resource"> <rdf:value>Portugal</rdf:value> <rdf:value rdf:resource="http://vocab.getty.edu/page/tgn/1000090"/> </vcard:country> <fd:sport>Comité Paralímpico Português</fd:sport> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:FinanceValue>555000</fd:FinanceValue> </vivo:subjectArea> </rdf:Description> </rdf:RDF>
Figura 7 - Grafo Modalidades
<?xml version="1.0" encoding="utf-8"?> <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:time="http://www.w3.org/2006/time" xmlns:vcard="http://www.w3.org/2006/vcard/ns" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dbpedia="http://dbpedia.org/ontology/" xmlns:fd="http://wikiWS.org/sports-financing"> <!--Doping--> <rdf:Description rdf:about="https://www.fpf.pt"> <!-- Percentagem de Violações --> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:percentageViolation> 0,0065</fd:percentageViolation> <!-- Numero de Modalidades Controladas --> <fd:federationControlled>52</fd:federationControlled> </rdf:Description> </rdf:RDF>
Figura 8 - Grafo Doping
<?xml version="1.0" encoding="utf-8"?> <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:time="http://www.w3.org/2006/time" xmlns:vcard="http://www.w3.org/2006/vcard/ns" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dbpedia="http://dbpedia.org/ontology/" xmlns:vivo="http://vivoweb.org/ontology/core/" xmlns:fd="http://wikiWS.org/sports-financing"> <!--Praticantes por escalão etário--> <rdf:Description rdf:about="https://www.fpf.pt"> <!-- Até Juniores--> <vivo:subjectArea rdf:parseType="Resource"> <fd:ageCategory>Até Juniores</fd:ageCategory> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:numberOfAthletesAC>314490</fd:numberOfAthletesAC> </vivo:subjectArea> <!--Juniores--> <vivo:subjectArea rdf:parseType="Resource"> <fd:ageCategory>Juniores</fd:ageCategory> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:numberOfAthletesAC>46711</fd:numberOfAthletesAC> </vivo:subjectArea> <!--Seniores--> <vivo:subjectArea rdf:parseType="Resource"> <fd:ageCategory>Seniores</fd:ageCategory> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:numberOfAthletesAC>136003</fd:numberOfAthletesAC> </vivo:subjectArea> <!--Veteranos--> <vivo:subjectArea rdf:parseType="Resource"> <fd:ageCategory>Veteranos</fd:ageCategory> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2014</dbpedia:year> <fd:numberOfAthletesAC>41374</fd:numberOfAthletesAC> </vivo:subjectArea> </rdf:Description> </rdf:RDF>
Figura 9 - Praticantes por Escalão Etário
<?xml version="1.0" encoding="utf-8"?> <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:time="http://www.w3.org/2006/time" xmlns:vcard="http://www.w3.org/2006/vcard/ns" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dbpedia="http://dbpedia.org/ontology/" xmlns:vivo="http://vivoweb.org/ontology/core/" xmlns:fd="http://wikiWS.org/sports-financing"> <!--Praticantes por escalão etário--> <rdf:Description rdf:about="https://www.fpf.pt"> <!--Treinadores--> <vivo:subjectArea rdf:parseType="Resource"> <fd:typesOfGraduates>Treinadores</fd:typesOfGraduates> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2013</dbpedia:year> <fd:numberOfGraduates>5842</fd:numberOfGraduates> </vivo:subjectArea> <!--Árbitros e Juízes--> <vivo:subjectArea rdf:parseType="Resource"> <fd:typesOfGraduates>Árbitros e Juízes</fd:typesOfGraduates> <dbpedia:year rdf:datatype="http://www.w3.org/2001/XMLSchema#gYear">2013</dbpedia:year> <fd:numberOfGraduates>2285</fd:numberOfGraduates> </vivo:subjectArea> </rdf:Description> </rdf:RDF>
Figura 10 - Formados em Cursos Desportivos
Ao longo da elaboração deste trabalho, a equipa de trabalho deparou-se com algumas dificuldades, sendo elas:
- o dataset encontrado continha poucas colunas, o que levou a que se procurassem ainda mais datasets para se poder completar com mais informação o dataset principal;
- o dataset continha colunas e sub-colunas, isto é, uma coluna, ex: Federação, e dentro dessa continha sub-colunas, ex:Andebol, Atletismo, Futebol…., o que levou a que tratassemos essas sub-colunas como atributos para se poder definir o modelo de dominio;
- na identificação dos namespaces e das respetivas propriedades reparamos que, após varias pesquisas, para a nossa semântica não havia muitos vocabulários ja definidos para podermos utilizar, o que levou a que criassemos o nosso próprio vocabulário;
- no desenvolvimento do código rdf;
Fábio Lima: N-2
João Vilaverde: N+1
Ricardo Carvalho: N+1