oracle spatial summit€¦ · hybrid cloud using oracle dbaas: how the italian workers comp...
TRANSCRIPT
Oracle Spatial Summit 2015
Hybrid Cloud Using Oracle DBaaS: How the Italian Workers Comp Authority Uses Graph Technology
Patrizio Galasso, Information Governance Manager, Inail Giovanni Corcione, Master Principal Sales Consultant, Oracle Italia
INAIL “Workplace Accidents” linked data system
OVERVIEW
• Inail, the Italian Government Workers Compensation Authority, a public non-profit entity safeguarding workers against physical injuries and professional diseases.
• +10K employees - management of about 600K incidents and 60K professional diseases per year – Services for +3 million Italian companies - 1800 virtual servers, 520 phisical servers
• ULA: Oracle DBMS EE+Options - SOA,BPM,WEBCENTER, WLS – OBI EE.
CHALLENGES / OPPORTUNITIES • 5 stars W3C OpenData model Endpoint service. • Inail scalable RDF-Graph triplestore . • Zero impact on Inail IT infrastructure
SOLUTIONS • Oracle Cloud DBaaS, DBMS 12.1 EE High Performance
• Spatial and Graph - RDF-Graph • Partitioning - Multitenant
• Oracle Fusion Middleware 11.1.1.7
RESULTS • Linked Open Data system UE/Italian Gov Agency
compliance • 10 Italian Regions: about 90M RDF triples • Security: infrastructure separation provided by PaaS
Cloud services. • Semantic interoperability with Italian federated Linked
Open Data • Rapid implementation, -3 days, with significant
operational cost reduction. • Query simplification for complex analysis • Inail now better understands activities to deploy
additional linked data for both internal and public services
Objectives • “Workplace Accidents” Linked OpenData Endpoint Service • Scalabale Triplestore • Zero impact on Inail IT infrustructure • Reduce operational costs without compromising data security • A minimal ontology to represent basic concept about Accidents at Work • A specialised ontology to infer restricted fare insurance on accidents and
injuries
3
Agenda • Objectives • Architecture • Process Implementation • “Workplace Accidents” Ontology design • Demo queries • Lesson Learned
4
Workplace Accidents Open Data W3C OpenData model From 3 stars to 5 stars
5
Database Cloud Service – Full Instance Editions
Extreme Performance High Performance Enterprise Edition (EE)
Reference: http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html
adds… adds… adds…
Multitenant
Partitioning
Advanced Compression
Advanced Security, Label Security, Database Vault
Real Application Clusters (RAC)
In Memory
Active Data Guard
• Full database instance
• Up to 16 OCPUs
Standard Edition
• Transparent Data Encryption (TDE)
• Data Guard
• All standard EE features
Real Application Testing
OLAP, Analytics, Spatial and Graph
Management Packs
Greater Capabilities
7
Cloud instantiation
8
ETL: Inail Triplestore
Per each region
RDF Graph .csv
sem_apis.bulk_load_from_
staging_table sem_apis.export_rdfview_model
Add to Staging table
<http://dati.inail.it/infortuni/Lazio>
sqlldr
sem_apis.create_rdfview_model
Region.csv into
Staging Table
R2RML Triples Genration
Triples Materialization
Add region named graph
Populate INAIL
TripleStore
9
dati.inail.it/opendata
Inail Triplestore: Global, Local, Asserted and Inferred
• 10 Italian regions
• Named Graph per each region
• 10 Local Model (Triple Store)
• 1 Tbox containing the Inail Ontology
• A global Virtual Model, Accidents_Vm: asserted and inferred
10
Using NGGI and NGLI Together
11
Named Graph Global Inference: all over Italy
Named Graph Local Inference: per each Regional Model
INAIL_TBOX
LAZIO
LOMBARDIA
.....
VENETO
INFERENCE
OWL2RL
1. exec sem_apis.create_entailment('infortuni_ent', sem_models('TBOX', 'LAZIO','LOMBARDIA‘,……), sem_rulebases('OWL2RL'),include_default_g=>sem_models('TBOX'), options=>' entail_anyway=t,DOP=4 ');
2. exec sem_apis.create_entailment('infortuni_ent', sem_models('TBOX', 'LAZIO','LOMBARDIA‘,……), sem_rulebases('OWL2RL'),options=>' local_ng_inf=t,entail_anyway=t,DOP=4 ');
3. exec sem_apis.create_virtual_model('infortuni_vm',sem_models ('TBOX', 'ABRUZZO','LAZIO','LOMBARDIA','PIEMONTE','CAMPANIA….), sem_rulebases('OWL2RL'));
Accidents
Companies Injured Workers Disablement
Permanent
Medium
objectProperties
subClass
FARES
Industry & Serives
Farming Others
“Workplace Incidents” Ontology
12
Workplace Accidents Fares Inferencing
Accidents
Fare
Manufacturing
Textile Chemical
Handicraft
Textile Agricolture Chemical
Tertiary
Chemical Agricolture
Industry Fare
SuperClass
Textile
Chemical
Agriculture Tertiary Sector
Handicraft
Manufacturing
asserted triples
Inail:Industry-Chemical owl:equivalentClass
[ rdf:type owl:Class ;
owl:intersectionOf
( Inail:IndustryFare Inail:Chemical ) ] .
Chemical Manufacturing
OWL2
RL profile
13
Global Accidents from Inail Triplestore
ACCIDENTS_VM:
Inferred: 86,320,601
asserted: 57,671,441
Ontology: 625 axioms/triples
Abruzzo inferred: 3,508,302
asserted: 2,338,933
Campania inferred: 4,664,035
asserted: 3,118,958
Lazio inferred: 10,066,777
asserted: 6,716,297
Liguria inferred: 4,916,277
asserted: 3,283,652
Lombardia inferred: 25,109,454
asserted: 16,739,993
Veneto inferred: 15,626,558
asserted: 10,459,590
14
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#timeout=100,qid=123>
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#STRICT_DEFAULT=F,ALLOW_DUP=T>
PREFIX dati:<http://dati.inail.it/opendata/infortuni/ns/>
SELECT distinct ?age
from dati:Piemonte WHERE
{ ?s rdf:type dati:TariffeArtigianato-CostruzioniImpianti .
?s dati:haInfortunato ?injured . ?injured dati:eta ?age
}
order by desc (?age)
Ask Fare to get Age
Age of injured artisans in construction industry
... Piemonte Named triples ... Building-Artisan Class
15
Age of injured artisans in Construction Industry age
"81" ^^<http://www.w3.org/2001/XMLSchema#decimal> "80" ^^<http://www.w3.org/2001/XMLSchema#decimal> "79" ^^<http://www.w3.org/2001/XMLSchema#decimal> "78" ^^<http://www.w3.org/2001/XMLSchema#decimal> "77" ^^<http://www.w3.org/2001/XMLSchema#decimal> "76" ^^<http://www.w3.org/2001/XMLSchema#decimal> "70" ^^<http://www.w3.org/2001/XMLSchema#decimal> .... .... "40" ^^<http://www.w3.org/2001/XMLSchema#decimal> "33" ^^<http://www.w3.org/2001/XMLSchema#decimal> "29" ^^<http://www.w3.org/2001/XMLSchema#decimal> "28" ^^<http://www.w3.org/2001/XMLSchema#decimal> "20" ^^<http://www.w3.org/2001/XMLSchema#decimal> "19" ^^<http://www.w3.org/2001/XMLSchema#decimal> "18" ^^<http://www.w3.org/2001/XMLSchema#decimal> "17" ^^<http://www.w3.org/2001/XMLSchema#decimal> "16" ^^<http://www.w3.org/2001/XMLSchema#decimal> "15" ^^<http://www.w3.org/2001/XMLSchema#decimal>
16
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#timeout=100,qid=123>
PREFIX ORACLE_SEM_FS_NS: <http://oracle.com/semtech#STRICT_DEFAULT=F,ALLOW_DUP=T>
PREFIX dati:<http://dati.inail.it/opendata/infortuni/ns/>
SELECT ?injured ?goingAtWork ?age
from dati:Lazio WHERE
{ ?s rdf:type dati:TariffeIndustria-TessileConfezioni .
?s dati:conSenzaMezzoTrasporto dati:S; dati:modalitaAccadimento ?goingAtWork;
dati:haInfortunato ?injured.
?injured dati:eta ?age.
}
order by desc(?goingAtWork) desc(?age)
Textile workers going at work by car
17
Accidents occurred from home to workplace
Textile workers going at work by car
18
Next: Public Sector Federation
ISTAT
LOD interoperability to enhance Private sector services
19
INPS (Pension)
LABOR
INAIL
Executive Order 13642 of May 9, 2013
Making Open and Machine Readable the New Default for Government Information
Section 1. General Principles.
Openness in government strengthens our democracy, promotes the delivery of efficient and effective services to the public, and contributes to economic growth. As one vital benefit of open government, making information resources easy to find, accessible, and usable can fuel entrepreneurship, innovation, and scientific discovery that improves Americans' lives and contributes significantly to job creation.
https://en.wikisource.org/wiki/Executive_Order_13642
The Shark Fin Of Digital Transformation
Traditional Business Cycle Plan, Provision, Engineer
Business Case to Ask for Big Investment
Avoid Any Possible Risk
Innovative Business Cycle Try, Innovate, React
From Beta to Enterprise in a “Big Bang” Test, fail and restart
20