Appendix B: Queries



Download 3.88 Mb.
Page2/14
Date conversion04.02.2017
Size3.88 Mb.
1   2   3   4   5   6   7   8   9   ...   14


Gold standard:

American African Lion

Tiger

Jaguar


Leopard

Clouded leopard

Snow leopard

Black Panther

American Cheetah

Asiatic Cheetah

Karakal

Caracal


Caracal

Bay cat


Asian golden cat

Chinese Mountain Cat

Jungle cat

Pallas's cat

Pallas cat

Sand cat


Black-footed cat

nigripes


African Wild cat

Colocolo


Geoffroy's cat

Geoffroys cat

Kodkod

Andean mountan cat



Leopardus jacobitus

Ocelot


Oncilla

Margay


Serval

Canadian lynx

Eurasian lynx

Iberian lynx

Bobcat

Marbled cat



Leopard cat

Iriomote cat

Flat-headed cat

Rusty-spotted cat

Fishing cat

African golden cat

Cougar

Puma


Jaguarundi

Query: 7_trees



Original question: Genera of pine trees (Pinaceae)

SELECT DISTINCT ?genus

WHERE {

?tree dbp-ont:family dbpedia:Pinaceae.



?tree dbp-ont:genus ?genus

}

Factforge answers:



genus

Quality

Fir@en

5

Abies - firbutt@en

4

Abies@en

5

Pine@en

5

Pine Tree@en

3

Reproduction of pine trees@en

1

Pinus classification@en

2

Cedar@en

5

Pseudotsuga@en

4

Douglas-fir@en

3

Spruce@en

5

Larch@en

5

Keteleeria@en

5

Ducampopinus@en

5

Larix@en

5

Picea@en

5

Pinus@en

5

Tsuga@en

5

Hemlock (tree)@en

3



Gold standard:

Pinus:pine:Pineoideae

Abies:Tanne:Tannen:Thanen

Cedrus:Zeder:Zedern:Zederrn

Keteleeria:Keteleria:Kateleria

Nothotsuga:Notosuga:Nothotsuga longibracteata:longibracteata

Tsuga:Hemlocktanne:Hemlocktannen:Hemloktannen:Hemlocktanen

Pseudolarix:Goldlärche:Goldlaerche:Goldlerchen

Larch:Larix:Lärche:Lärchen:Lerchen

Cathaya:Taubenbaum:Taubennbaum:Tauben baum

Pseudotsuga:Douglasie:Douglasien:Duglasien

Spruce:Piceoideae:Fichte:Fichten:Fichtn

Query: 8_beer

Original question: Beer brands with over $1 billion in sales (2008)

SELECT DISTINCT ?company

WHERE {

?company rdf:type dbp-ont:Company .



?company dbp-ont:netIncome ?income .

?company ?somerelation ?beer .

FILTER regex(?beer, "beer", "i") .

FILTER (xsd:double(str(?income)) > 1000000000) .

}

Factforge answers:

company

Quality

dbpedia:San_Miguel_Brewery

4

dbpedia:Diageo

4

dbpedia:Carlsberg_Group

5


Gold standard:

Budweiser:Budveise

Bud Light:Bud Lite:BudLight:BudLite

Heineken:Heiniken:Heinicken:Heinecken

Corona:Korona:Coronna:Corrona

Stella Artois:Stela Artoise:Stella

Guinness:Guinisse:Guinnise:Giness:Guines

Miller Lite:Miller:Miler Lite:MillerLite

Skol:Sckol:Scol

Amstel:Amsstel:Amstell

Beck’s:Becks:Beks

Cruzcampo:Crucampo

Kronenbourg 1664:Kronenbourg:Kronenburg:Cronenburg:1664

Coors Light:CoorsLight:Coors Lite:Coors

Labatt’s:Labatts

Baltika:Baltica

Carlsberg Group:Karlsberg

Query: 9_technology



Original question: Technology brands with a value exceeding $5 billion (2009)

SELECT DISTINCT ?label

WHERE {

?Company ff:preferredLabel ?label .



?Company rdf:type opencyc-en:Business .

?Company dbp-prop:products ?Product .

?Product rdf:type umbel-sc:ComputerCode .

?Company dbp-ont:netIncome ?income .

FILTER (xsd:double(str(?income)) > 5000000000) .

}

Factforge answers:



label

Quality

Apple Inc.@en

5

Oracle Corporation@en

5


Gold standard:

Google:Googl:Googel

Microsoft:Micro Soft

IBM:International Business Machines

Apple:Apple Computers:Apple Inc.

Nokia:Nocia

BlackBerry:Black Berry

Hewlett Packard:HP:HewlettPackard

SAP:Systemanalyse und Programmentwicklung:Systeme Anwendungen und Produkte in der Datenverarbeitung

Intel:Intell

Oracle:Oracel:Oracle Corporation

Cisco:Cisco Systems

Dell:Dell Computers

Accenture:Accenturre

Siemens:Simens

Canon:Cannon

Yahoo!:Yahoo:Yahou

Samsung:Samsun:Samsong

Sony:Sonie:Sonny

Baidu:Baiduh

Query: 10_oil

Original question: Oil companies with a value exceeding $700 million (2009)

SELECT DISTINCT ?label

WHERE {

?company rdfs:label ?label .


?company rdf:type dbp-ont:Company .

?company dbp-ont:equity ?eq .

?company skos:subject ?cat .

?cat skos:broader dbp-cat:Oil_companies .

FILTER (xsd:double(str(?eq)) > 700000000) .

FILTER ( lang(?label) = "en") .



}

Factforge answers:

label

Quality 1-5

Gazprom@en

5

Газпром@en

3

Royal Dutch Shell@en

5

Royal Dutch Shell plc@en

4

Shell Group@en

4

Shell Transport & Trading Co plc@en

2

Shell Transport & Trading Co@en

2

Shell Transport and Trading@en

2

Shell Transport & Trading@en

2

Royal Dutch/Shell@en

4

PetroChina Company Limited@en

4

PetroChina@en

5

ExxonMobil@en

5

Exxon Mobil Corporation@en

5

BP@en

5

BP plc@en

5

Chevron Corporation@en

5

Petronas@en

5

Petroliam Nasional Berhad (PETRONAS)@en

4

Total S.A.@en

5

Total SA@en

5

Total Compagnie Francaise Des Petroles@en

4

Compagnie Française des Pétroles@en

4

Compagnie Francaise des Petroles@en

4

Marathon Oil@en

5

Marathon Oil Corp@en

5

XTO Energy Inc.@en

4

XTO Energy@en

4

Apache Corporation@en

5

Apache Corp.@en

5

Valero Energy Corporation@en

4

National Oilwell Varco@en

4

Sasol Limited@en

4

Sasol@en

4

Indian Oil Corporation Limited@en

5

Indian Oil Corporation@en

5

Imperial Oil Limited@en

4

Imperial Oil@en

5

The Williams Companies, Inc.@en

4

Williams Companies@en

4

Halliburton@en

5

Halliburton Corporation@en

4

Baker Hughes Incorporated@en

4

Baker Hughes@en

4

Freeport-McMoRan Copper & Gold Inc.@en

3

Freeport-McMoRan@en

3

Freeport indonesia@en

3

Union Oil Company of California and Unocal Corporation@en

4

Unocal Corporation@en

5

Sunoco Inc.@en

4

Sunoco@en

4

Sun Company Inc.@en

5

Sun Oil@en

5

Plains Exploration & Production Company@en

4

Plains Exploration & Production@en

4

Petrohawk Energy Corporation@en

4

Petrohawk@en

5

Country Energy@en

4

CountryEnergy@en

4

Western Refining, Inc.@en

5

Western Refining@en

5

Gold standard:

British Petroleum:BP:British Petrol

Shell:Shel:Schell:Royal Dutch Shell

Mobil:Mobile:Exxon:Exon:Exxon Mobil Corporation:ExxonMobil Corporation

PetroChina:Petro China:PetroChina Company Limited

Texaco:Texxaco:Texacco

Chevron Corporation:Chevronn Corporation

Esso:Eso


Repsol:Repsohl

Aral:Arral

Query: 13_office

Original question: Products in the Suite

SELECT DISTINCT ?Product

WHERE {

?Product skos:subject ?MSO .



?Product rdfs:label ?label .

?MSO skos:prefLabel "Microsoft Office"@en



}

Factforge answers:

Product

Quality 1-5

CoWord@en

2

Ctfmon@en

1

Word Document@en

1

Excel Services@en

2

History of Microsoft Office@en

1

Information Bridge Framework@en

4

Microsoft Access@en

5

Microsoft Binder@en

5

Microsoft Graph@en

5

Microsoft Clip Organizer@en

3

Microsoft Document Imaging Format@en

2

2008

1

Microsoft Office Equation Editor@en

4

Excel Spreadsheet@en

2

Microsoft FrontPage@en

5

Microsoft Office Groove 2007@en

4

Microsoft Office InfoPath@en

4

Microsoft InterConnect@en

4

Microsoft Office@en

2

Microsoft Office 2007 filename extensions@en

1

Microsoft Office 2008 for Mac@en

5

Microsoft Office Accounting@en

5

Microsoft Office Communicator@en

5

Microsoft Office Document Imaging@en

3

Microsoft Office Document Scanning@en

3

Microsoft Office Language Packs 2007@en

2

Microsoft Office Live@en

5

Microsoft Office Live Meeting@en

4

Microsoft Office Mobile@en

3

Microsoft Office Online@en

2

Microsoft Office Outlook Connector@en

4

Microsoft Office Picture Manager@en

4

SpreadsheetML@en

1

Microsoft Office XP@en

2

Microsoft OneNote@en

5

Microsoft Office Outlook@en

5

Microsoft PhotoDraw@en

3

PowerPoint Presentation@en

1

PowerPoint Viewer@en

4

Microsoft Project@en

1

Microsoft Publisher@en

4

Microsoft Office Visio@en

5

Microsoft Word@en

5

Word Viewer@en

4

Microsoft Office 2004 for Mac@en

4

Office Assistant@en

3

Office Business Applications@en

4

Office Genuine Advantage@en

4

Office Open XML@en

3

Office Open XML Converter@en

2

Office Web Components@en

3

Outlook add-ins@en

2

Persistent Shared Object Model@en

1

Pivot table@en

1

Reviewing toolbar@en

1

SYmbolic LinK (SYLK)@en

1

Smart tag (Microsoft)@en

1

Standardization of Office Open XML@en

1

Transport Neutral Encapsulation Format@en

1

WordArt@en

2

Xnk@en

1

Personal Storage Table@en

1

Microsoft Office 97@en

3

Microsoft Office 2000@en

3

Microsoft Vizact@en

1

Microsoft Office SharePoint Designer@en

3

Microsoft Office 2001@en

3

2010

1

Excel Viewer@en

3

Microsoft Bulldog@en

3

CoOffice@en

1

List of Microsoft Office programs@en

1

InLoox@en

1

Microsoft Office 95@en

3

Microsoft Office 98 Macintosh Edition@en

3

Microsoft Office v. X@en

1

Microsoft Office 3.0@en

1

Office Open XML Intermediate 5 Month Ballot Results@en

1

Powerpoint-Karaoke@en

2

AutoNumber@en

1

Office Web Apps@en

1

Office Open XML Workbook@en

2

History of Microsoft Word@en

1


Gold standard:

Microsoft Word

Microsoft Excel

Microsoft Power Point

Microsoft Outlook

Microsoft Entourage

Microsoft Access

Microsoft Publisher

Microsoft Expression Media

Microsoft OneNote

Microsoft InfoPath

Microsoft Office Communicator

Microsoft MSN Messenger

Microsoft Groove

Microsoft SharePoint Designer

Microsoft Visio

Microsoft Project

Microsoft Virtual PC

Microsoft FrontPage

Microsoft Photo Editor

Microsoft PhotoDraw

Query: 14_apple



Original question: products (hard- or software) (2009)

SELECT DISTINCT ?product

WHERE {

{

dbpedia:HPod dbp-prop:manufacturer ?Apple .



?product dbp-prop:manufacturer ?Apple .

} UNION {

dbpedia:IMix dbp-ont:developer ?Apple .

?product dbp-ont:developer ?Apple .

}

?product owlim:hasPageRank ?pagerank .



?product rdfs:label ?label.
FILTER(LANG(?label) = "en")

}


Factforge answers:

product

Quality 1-5

IPod Nano@en

5

2nd Generation iPod Nano@en

4

Apple Desktop Bus@en

4

Apple Mighty Mouse@en

3

Apple Wireless Mighty Mouse@en

3

Apple TV@en

3

IBox@en

3

 TV@en

3

IPhone@en

5

Apple phone@en

3

IPhone 2@en

4

IPod@en

5

HPod@en

2

IPod HP@en

4

I pod@en

4

IPod socks@en

2

IPod U2 Edition@en

3

IFlea@en

3

Iflea@en

3

IPod U2 Special Edition@en

3

IPod U2@en

3

IPod models and software@en

2

Ipod U2@en

3

IMacs@en

5

IMac@en

5

Video iPod@en

3

IPod Video@en

3

IPod Classic@en

5

IPod Hi-Fi@en

4

IPod Mini@en

5

IPod Shuffle@en

5

IPod Touch@en

5

ISight@en

3

MagSafe@en

3

Mini-DVI@en

1

MessagePad@en

2

Apple Magic Mouse@en

3

IPad@en

5

Mini DisplayPort@en

1

Macmini@en

4

Mac Mini@en

4

QuickTime@en

5

Qviktaym@en

4

QuickTime 6.5.1@en

4

Mov file@en

3

MOV file@en

3

.mov file@en

3

Quick Time@en

5

QuickTime 7.1.3@en

4

Address Book@en

1

Address Book (application)@en

1

Address Book (Mac OS X)@en

4

Aperture (photography software)@en

5

App Store@en

5

AppleWorks@en

5

apple'''Works@en

4

Apple Developer Tools@en

4

Script Editor@en

1

QTZ@en

1

Property List Editor@en

1

Apple FileMerge@en

5

Core Image Fun House@en

4

Pixie (Mac OS X)@en

3

PackageMaker@en

1

Icon Composer@en

3

Help Indexer@en

1

Repeat After Me@en

4

CHUD Tools@en

3

Thread Viewer@en

1

Shark (software)@en

3

OpenGL Shader Builder@en

1

FileMerge@en

3

CrashReporterPrefs@en

3

MallocDebug@en

3

Icns Browser@en

3

IORegistryExplorer@en

3

Apple HD SC Setup@en

4

Apple Loops Utility@en

4

Qmaster@en

4

Apple Qmaster@en

4

Apple Remote Desktop@en

4

Bonjour@en

4

Bonjour (software)@en

4

OpenTalk@en

4

Apple Rendezvous@en

4

Bonjour protocol@en

4

Software Update@en

1

Apple Software Update@en

3

Terminal@en

3

Apple Terminal@en

3

Aqua@en

2

Aqua (user interface)@en

2

Automator@en

3

Automator (software)@en

3

.Mac Backup@en

3

Backup (software)@en

1

OpenBSM@en

4

Basic Security Module@en

4

BootX@en

4

BootX (Apple)@en

4

Boot Camp@en

5

Boot Camp (software)@en

4

Darwin Calendar Server@en

3

Caldavd@en

2

Calendar Server@en

3

Carbon@en

3

Carbon (API)@en

3

Chess@en

1

Chess (application)@en

2

Clang@en

2

Cocoa@en

3

Cocoa (API)@en

3

Cocoa API@en

3

Color@en

4

Color (software)@en

4

FinalTouch@en

4

Final Touch@en

4

Crash Reporter@en

3

Crash Reporter (Mac OS X)@en

3

DVD Studio Pro@en

2

Darwin Streaming Server@en

3

Dashboard@en

3

Dashboard (software)@en

3

Dashboard widget@en

3

Dictionary@en

1

Dictionary (software)@en

3

Dictionary.app@en

2

Disk First Aid@en

3

Disk Utility@en

3

Dock@en

3

Dock (Mac OS X)@en

4

Final Cut Express@en

3

Final Cut Pro@en

3

Final Cut Server@en

3

Final Cut Studio@en

3

Finder@en

4

Finder (software)@en

5

Front Row@en

4

Front Row (software)@en

4

GarageBand@en

3

Grapher@en

3

HeaderDoc@en

3

HyperCard@en

3

iCal@en

4

ICal@en

4

Ical@en

4

iChat@en

4

IChat@en

4

iChat Server@en

3

IChat Server@en

3

iDVD@en

3

IDVD@en

3

iLife@en

3

ILife@en

3

ITunes@en

5

iTunes@en

5

IMix@en

3

I tunes@en

5

ITunes 7@en

4

iMovie@en

4

IMovie@en

4

iPhoto@en

5

IPhoto@en

5

iSync@en

4

ISync@en

4

iWeb@en

4

IWeb@en

4

iWork@en

4

IWork@en

4

Installer@en

1

Installer (Mac OS X)@en

3

Interface Builder@en

3

Internet Connect@en

3

Web connect@en

3

Keychain@en

4

Keychain (Mac OS)@en

4

Keynote@en

5

Keynote (presentation software)@en

5

LiveType@en

3

Logic Pro@en

3

Logic Studio@en

3

MacPaint@en

4

Mac OS Runtime for Java@en

3

Mail@en

2

Mail (application)@en

4

Spotlight@en

4

Spotlight (software)@en

4

Spotlight Server@en

4

Mdimport@en

2

Migration Assistant@en

1

Migration Assistant (Apple)@en

4

MobileMe@en

3

Motion@en

3

Motion (software)@en

3

NetBoot@en

3

Numbers@en

4

Numbers (software)@en

4

Pages@en

2

Apple Photo Booth@en

4

Photo Booth@en

4

Podcast Capture@en

4

Preview@en

2

Preview (software)@en

3

QuickTime VR@en

3

Quick Look@en

3

Remote Install Mac OS X@en

2

Screen Sharing@en

3

Shake@en

3

Shake (software)@en

3

Sherlock@en

3

Sherlock (software)@en

3

SimpleText@en

3

Spaces@en

3

Spaces (software)@en

3

System Image Utility@en

3

System Preferences@en

3

Time Machine@en

3

Time Machine (Apple software)@en

3

VoiceOver@en

2

WebKit@en

2

WebObjects@en

2

Wiki Server@en

2

X11@en

2

X11.app@en

2

XNU kernel@en

2

XNU@en

2

Xcode@en

2

Xgrid@en

3

Xsan@en

3

Rosetta@en

2

Rosetta (software)@en

3

Classic Environment@en

3

CUPS@en

3

Calculator@en

1

Calculator (Mac OS)@en

3

WaveBurner@en

2

MainStage@en

3

Mainstage (software)@en

3

Vortex@en

3

Vortex (iPod game)@en

3

MacRuby@en

3


Gold standard:

iPod classic

iPod touch

iPod nano

iPod shuffle

Mac mini


iMac

Macintosh

Mac Pro

MacBook


iBook

MacBook Pro

MacBook Air

iPhone


Apple Cinema Display

Xserver


Apple TV

AirPort Express

AirPort Extreme

Time Capsule

Keyboard

Mighty Mouse

Apple Mouse

Mac OS X


iLife

iWork


iTunes

Safari


MobileMe

QuickTime

Aperture

Final Cut Studio

Final Cut Server

Final Cut Express

Logic Studio

Logic Express

Shake

Apple Remote Desktop



Xsan

Mac OS X Server

iPhoto

iMovie


GarageBand

iWeb


Query: 15_us_cars

Original question: US-American car manufacturers (current)

SELECT DISTINCT ?label

WHERE {

{ ?company dbp-ont:foundationPlace ?place }



UNION

{ ?company dbp-ont:location ?place }

UNION

{ ?company dbp-ont:locationCity ?place }


?place geo-ont:parentFeature dbpedia:United_States .
{ ?company dbp-ont:product dbpedia:Automobile }

UNION


{ ?company dbp-ont:product dbpedia:Car }

UNION


{ ?company skos:subject dbp-cat:Motor_vehicle_companies }

?company rdfs:label ?label .

Filter(lang(?label) = "en")

}

Factforge answers:



Answer

Quality 1-5

General Motors@en

5

General Motors Company@en

5

General Motors do Brasil@en

3

AmeriCredit Corp.@en

1

AmeriCredit@en

1

Duesenberg@en

3

Penske Automotive Group, Inc.@en

4

Penske Automotive Group@en

4

Pontiac@en

5

Renntech@en

2

Reynolds Metals Company@en

2

Reynolds Metals@en

2

Saleen, Incorporated@en

2

Chrysler@en

5

Chrysler Group, LLC@en

3

Crysler@en

4


Gold standard:

Acura


Buick:Buik:Buic

Cadillac:Cadilac

Chevrolet:Chevy:Chevroley

Chrysler


Dodge

Ford


General Motors:GM

GMC


Hummer

Hyundai


Infiniti

Jeep


Lexus

Lincoln


Mercury

Oldsmobile:Olds Mobile

Pontiac

Regal:Buick Regal:Regal Buick



Saturn

Query: 17_japanese_cars



Original question: Japanese car manufacturers (current)

SELECT DISTINCT ?company

WHERE {

{ ?company dbp-ont:foundationPlace ?place }



UNION

{ ?company dbp-ont:location ?place }

UNION

{ ?company dbp-ont:locationCity ?place }


?place geo-ont:parentFeature dbpedia:Japan .
{ ?company dbp-ont:product dbpedia:Automobile } UNION { ?company dbp-ont:product
dbpedia:Car }

}

Factforge answers:



company

Quality 1-5

dbpedia:Infiniti

4

dbpedia:Mikuni

5

dbpedia:Suzuki

5

dbpedia:Nismo

5


Gold standard:

Acura:Akura

Daihatsu:Daihatzu

Honda


Infinity:Infiniti

Isuzu:Isutsu

Lexus

Mazda:Matzda:Madzda



Mitsubishi:Mitsubischi:Mitshubishi

Nissan:Nisan

Scion:Skion

Subaru


Suzuki

Toyota


Query: 20_pasta

Original question: Italian pasta varieties

PREFIX umbel-sc:

1   2   3   4   5   6   7   8   9   ...   14


The database is protected by copyright ©dentisty.org 2016
send message

    Main page