Semantic Annotation for Tabular Data with DBpedia: Adapted SemTab 2019 with DBpedia 2016-10
<p>Semantic Annotation for Tabular Data with DBpedia: Adapted SemTab 2019 with DBpedia 2016-10</p>
<p>Github: https://github.com/phucty/mtab4dbpedia<br>
---------------------------------------------------------------------------------------------------------------------------------------</p>
<p>CEA: </p>
<ul>
<li>
<p>Keep only valid entities in DBpedia 2016-10</p>
</li>
<li>
<p>Resolve percentage encoding</p>
</li>
<li>
<p>Add missing redirect entities</p>
</li>
</ul>
<p>CTA: </p>
<ul>
<li>
<p>Keep only valid types</p>
</li>
<li>
<p>Resolve transitive types (parents and equivalent types of the specific type) with DBpedia ontology 2016-10</p>
</li>
</ul>
<p>CPA:</p>
<ul>
<li>
<p>Add equivalent properties</p>
</li>
</ul>
<p>Statistic of Adapted Tabular data SemTab 2019</p>
<pre><code>| | CEA | | | CPA | | | CTA | | |
|---------|:--------:|:-------:|:------:|:--------:|:-------:|:------:|:--------:|---------|--------|
| | Orginal | Adapted | Change | Orginal | Adapted | Change | Orginal | Adapted | Change |
| Round 1 | 8418 | 8406 | -0.14% | 116 | 116 | 0.00% | 120 | 120 | 0.00% |
| Round 2 | 463796 | 457567 | -1.34% | 6762 | 6762 | 0.00% | 14780 | 14333 | -3.02% |
| Round 3 | 406827 | 406820 | 0.00% | 7575 | 7575 | 0.00% | 5762 | 5673 | -1.54% |
| Round 4 | 107352 | 107351 | 0.00% | 2747 | 2747 | 0.00% | 1732 | 1717 | -0.87% |</code></pre>
<p> </p>
<p>---------------------------------------------------------------------------------------------------------------------------------------<br>
DBpedia 2016-10 extra resources: (Original dataset http://downloads.dbpedia.org/2016-10/)</p>
<p>---------------------------------------------------------------------------------------------------------------------------------------</p>
<p>File: _dbpedia_classes_2016-10.csv</p>
<p>Information: DBpedia classes and parents: (We remove the abstract types: Agent, Thing)</p>
<p>Total: 759 classes</p>
<p>Structure: [class, parents (separate with space)] (without prefix dbo: or http://dbpedia.org/ontology/)</p>
<p>Example: "City","Location Place PopulatedPlace Settlement"</p>
<p>---------------------------------------------------------------------------------------------------------------------------------------</p>
<p>File: _dbpedia_properties_2016-10.csv</p>
<p>Information: DBpedia properties and these equivalents</p>
<p>Total: 2865 properties</p>
<p>Structure: [property, it’s equivalent properties] (without prefix dbo: or http://dbpedia.org/ontology/)</p>
<p>Example: "restingDate","deathDate"</p>
<p>---------------------------------------------------------------------------------------------------------------------------------------</p>
<p>File: _dbpedia_domains_2016-10.csv</p>
<p>Information: DBpedia properties and these domain types</p>
<p>Total: 2421 properties (have types as their domain)</p>
<p>Structure: [property, type (domain)] (without prefix dbo: or http://dbpedia.org/ontology/)</p>
<p>Example: "deathDate","Person"</p>
<p>---------------------------------------------------------------------------------------------------------------------------------------</p>
<p>File: _dbpedia_entities_2016-10.jsonl.bz2 </p>
<p>Information: DBpedia entity dump</p>
<p>Format: json list bz2 (bz2 Compressed json list)</p>
<p>Source: DBpedia dump 2016-10 core</p>
<p>Total: 5,289,577 entities (No disambiguation entities)</p>
<p>Structure:</p>
<p>An entity: for example “Tokyo”: (datatype: dictionary),</p>
<p>{</p>
<p>'wd': 'Q1322032', (Wikidata ID, datatype: string)</p>
<p>'wp': 'Tokyo', (Wikipedia ID, add prefix <a href="https://en.wikipedia.org/wiki/">https://en.wikipedia.org/wiki/</a> + wp to get the Wikipedia URL, datatype: string)</p>
<p>'dp': 'Tokyo', (DBpedia ID, add prefix <a href="http://dbpedia.org/resource/">http://dbpedia.org/resource/</a> + dp to get the DBpedia URL, datatype: string)</p>
<p>'label': 'Tokyo', (Entity label, datatype: string)</p>
<p>'aliases': ['To-kyo', 'Tôkyô Prefecture', ..], (Other entity names, datatype: list) </p>
<p>'aliases_multilingual': ['东京小子', 'طوكيو', ...], (Other entity names in multilingual, datatype: list)</p>
<p>'types_specific': 'City', (Entity direct type, datatype: string) </p>
<p>'types_transitive': ['Human settlement', 'City', 'PopulatedPlace', 'Location', 'Place', 'Settlement'], (Entity transitive types, datatype: list)</p>
<p>'claims_entity': { (entity statements, datatype: dictionary. Keys: properties, Values: list of tail entities)</p>
<p>'governingBody': ['Tokyo Metropolitan Government'], </p>
<p> 'subdivision': ['Honshu', 'Kantō region'],</p>
<p>...</p>
<p>},</p>
<p>'claims_literal': {</p>
<p>'string': { (String literal: datatype: dictionary. Keys: properties, Values: list of values</p>
<p>'postalCode': ['JP-13'], </p>
<p>'utcOffset': ['+09:00', '+9'],</p>
<p>…</p>
<p>}</p>
<p>'time': { (Time literal: datatype: dictionary. Keys: properties, Values: list of date time</p>
<p>'populationAsOf': ['2016-07-31'], </p>
<p>...</p>
<p>}), </p>
<p>'quantity': { (Numerical literal: datatype: dictionary. Keys: properties, Values: list of values</p>
<p>populationDesity: [6224.66, 6349.0], </p>
<p>'maximumElevation': [2017], </p>
<p>...</p>
<p>},</p>
<p>'pagerank': 2.2167366040153352e-06 (Entity page rank score calculated on DBpedia Graph)</p>
<p>}</p>
<p>---------------------------------------------------------------------------------------------------------------------------------------</p>
<p>THIS DATA IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.</p>
opencc-by-4.0Jun 2021View details →