%VOSWARNING%
%META:TOPICPARENT{name="VirtRDFViews"}%
---+Linked Data Views
-- Setup script for Linked Data Views of OpenLink Product Portfolio version 2
--
/*
* This view is currently designed to SPECIFICALLY load on data.openlinksw.com. We recommend you
* search for 'openlinksw.com' (as `http://' is sometimes encoded) and replace with either the default
* URIQA macro or your own hostname as appropriate.
*/
-- views to get the codes out instead of the id's
---- in hindsight these should ALL have been handled with
---- proper IRI functions like the rest, oh well, no harm AFAIK
---- will know for next time or might even replace this later.
DROP VIEW oplweb2.oplweb.product_formats_categories;
CREATE VIEW oplweb2.oplweb.product_formats_categories (
product_cat_code, product_cat_id, product_format_code, product_format_id, product_family_id
) as
select distinct
pc.product_cat_code,
pc.product_cat_id,
pf.product_format_code,
pf.product_format_id,
pc.product_family_id
from
oplweb2.oplweb.product_category pc,
oplweb2.oplweb.product_format pf,
oplweb2.oplweb.product p
where
p.product_cat_id = pc.product_cat_id and
p.product_format_id = pf.product_format_id
and exists (
select 1 from oplweb2.oplweb.component_archive ca
where ca.product_id = p.product_id
)
;
DROP VIEW oplweb2.oplweb.product_with_code;
CREATE VIEW oplweb2.oplweb.product_with_code as
select p.*, pc.product_cat_code, pf.product_format_code
from
oplweb2.oplweb.product_category pc,
oplweb2.oplweb.product_format pf,
oplweb2.oplweb.product p
where
p.product_cat_id = pc.product_cat_id and
p.product_format_id = pf.product_format_id ;
DROP VIEW oplweb2.oplweb.product_category_with_code;
CREATE VIEW oplweb2.oplweb.product_category_with_code as
select pc.*, pf.product_family_code
from
oplweb2.oplweb.product_category pc,
oplweb2.oplweb.product_family pf
where
pc.product_family_id = pf.product_family_id ;
DROP VIEW oplweb2.oplweb.product_family_features_with_code;
CREATE VIEW oplweb2.oplweb.product_family_features_with_code as
select a.*, b.product_family_code
from
oplweb2.oplweb.product_family_features a,
oplweb2.oplweb.product_family b
where
a.product_family_id = b.product_family_id
;
DROP VIEW oplweb2.oplweb.product_format_features_with_code;
CREATE VIEW oplweb2.oplweb.product_format_features_with_code as
select a.*, b.product_format_code
from
oplweb2.oplweb.product_format_features a,
oplweb2.oplweb.product_format b
where
a.product_format_id = b.product_format_id
;
DROP VIEW oplweb2.oplweb.product_category_features_with_code;
CREATE VIEW oplweb2.oplweb.product_category_features_with_code as
select a.*, b.product_cat_code
from
oplweb2.oplweb.product_category_features a,
oplweb2.oplweb.product_category b
where
a.product_cat_id = b.product_cat_id
;
DROP VIEW oplweb2.oplweb.components_for_rdfs;
CREATE VIEW oplweb2.oplweb.components_for_rdfs as
select *, cast(filesize as varchar) as str_filesize
from
oplweb2.oplweb.components
;
DROP VIEW oplweb2.oplweb.product_release_with_family;
CREATE VIEW oplweb2.oplweb.product_release_with_family as
select a.*, b.opsys_family_id, c.dbms_family_id
from
oplweb2.oplweb.product_release a,
oplweb2.oplweb.opsys b,
oplweb2.oplweb.dbms_engine c
where
a.opsys_name = b.opsys_name and
a.dbms_name = c.dbms_name
;
drop view oplweb2.oplweb.archive_coverage_osdb;
create view oplweb2.oplweb.archive_coverage_osdb as
select distinct
pfam.product_family_id, pfam.product_family_code,
p.product_format_id, pf.product_format_code,
p.product_cat_id, pc.product_cat_code,
p.product_id,
ca.opsys_name,
os.opsys_family_id,
ca.dbms_name,
db.dbms_family_id,
pr.processor_name,
pr.processor_mode_id,
pr.processor_family_id
from
oplweb2.oplweb.product p
join oplweb2.oplweb.product_category pc on (p.product_cat_id = pc.product_cat_id)
join oplweb2.oplweb.product_format pf on (p.product_format_id = pf.product_format_id)
join oplweb2.oplweb.product_family pfam on (pc.product_family_id = pfam.product_family_id)
join oplweb2.oplweb.component_archive ca on (ca.product_id = p.product_id)
join oplweb2.oplweb.opsys os on (os.opsys_name = ca.opsys_name)
join oplweb2.oplweb.dbms_engine db on (db.dbms_name = ca.dbms_name)
join oplweb2.oplweb.processors pr on (pr.processor_name = os.processor_name and pr.processor_mode_id = os.processor_mode_id)
;
GRANT SELECT ON oplweb2.oplweb.component_archive TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.component_archive_type TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.component_category TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.component_mode TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.component_type TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.components TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.components_for_rdfs TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.dbms_engine TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.dbms_family TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.download_location TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.download_protocol TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.download_partner TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.opsys TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.opsys_family TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.opsys_type TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.processor_family TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.processor_mode TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.processors TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_benefits TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_benefits_category TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_category TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_category_with_code TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_category_features TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_family TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_family_features TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_features TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_format TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_format_features TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_feature_category TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_release TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_release_features TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.vendor_category TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.vendor_category_family TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.vendors TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_formats_categories TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_with_code TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_family_features_with_code TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_format_features_with_code TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_category_features_with_code TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.product_release_with_family TO "SPARQL", "SPARQL_UPDATE";
GRANT SELECT ON oplweb2.oplweb.archive_coverage_osdb TO "SPARQL", "SPARQL_UPDATE";
drop index oplweb2_product_price_format_cat;
create index oplweb2_product_price_format_cat on oplweb2.oplweb.product_price(product_cat_id, product_format_id, product_price_type_id);
drop index oplweb2_product_discount_format_cat;
create index oplweb2_product_discount_format_cat on oplweb2.oplweb.product_general_discount(product_cat_id, product_format_id, product_price_type_id);
drop view oplweb2.DBA.license_model_type;
create view oplweb2.DBA.license_model_type (
product_release_id, product_cat_id, product_format_id, product_id, product_price_type_id
)
as
select distinct
product_release_id,
pp.product_cat_id, pp.product_format_id, product_id,
product_price_type_id
from
oplweb2.oplweb.product_price pp,
oplweb2.oplweb.product p
where p.product_cat_id = pp.product_cat_id and
p.product_format_id = pp.product_format_id
;
grant select on oplweb2.DBA.license_model_type to "SPARQL", "SPARQL_UPDATE";--, rdf;
drop view oplweb2.DBA.license_model;
create view oplweb2.DBA.license_model as
select distinct
product_release_id,
pc.product_cat_id,
pc.product_format_id,
pc.product_cat_code,
pc.product_format_code,
pc.product_id,
pp.opsys_family_id, pp.dbms_family_id,
replace(oo.opsys_family_name, ' ', '') as opsys_family_name,
replace(dd.dbms_family_name, ' ', '') as dbms_family_name,
pp.opsys_type_id,
pp.product_price_type_id,
pp.product_price_unit_type_id
from
oplweb2.oplweb.product_price pp,
oplweb2.oplweb.product_with_code pc, --category pc,
--oplweb2.oplweb.product_format pf,
oplweb2.oplweb.opsys os,
oplweb2.oplweb.dbms_engine dbe,
oplweb2.oplweb.dbms_family dd,
oplweb2.oplweb.opsys_family oo
--oplweb2.oplweb.product p
where
pp.product_format_id = pc.product_format_id and
pp.product_cat_id = pc.product_cat_id and
pp.opsys_family_id = oo.opsys_family_id and
pp.dbms_family_id = dd.dbms_family_id
--p.product_cat_id = pc.product_cat_id and
--p.product_format_id = pf.product_format_id and
;
grant select on oplweb2.DBA.license_model to "SPARQL", "SPARQL_UPDATE";--, rdf;
drop view oplweb2.DBA.license_model_units;
create view oplweb2.DBA.license_model_units as
select distinct
lm1.product_release_id,
lm1.product_id,
lm1.opsys_family_
pp.opsys_family_id, pp.dbms_family_id,
replace(oo.opsys_family_name, ' ', '') as opsys_family_name,
replace(dd.dbms_family_name, ' ', '') as dbms_family_name,
pp.opsys_type_id, ot.short_description as opsys_type_code
from
oplweb2.oplweb.product_price pp,
oplweb2.oplweb.opsys_type ot,
oplweb2.oplweb.dbms_family dd,
oplweb2.oplweb.opsys_family oo
where
pp.opsys_type_id = ot.opsys_type_id and
pp.opsys_family_id = oo.opsys_family_id and
pp.dbms_family_id = dd.dbms_family_id
and
pp.product_release_id = '6.1'
;
grant select on oplweb2.DBA.license_model_units to "SPARQL", "SPARQL_UPDATE";--, rdf;
drop view oplweb2.DBA.product_general_discount_vc;
create view oplweb2.DBA.product_general_discount_vc as
select distinct
product_release_id,
pgd.product_cat_id, pc.product_cat_code,
pgd.product_format_id, pc.product_format_code,
pc.product_id,
pgd.opsys_family_id, pgd.dbms_family_id,
pgd.opsys_type_id,
product_discount_description,
product_price_type_id,
cast(unit_discount as varchar) as unit_discount,
discount_start,
discount_end,
discount_token
from
oplweb2.oplweb.product_general_discount pgd,
oplweb2.oplweb.product_with_code pc
where
pgd.product_format_id = pc.product_format_id and
pgd.product_cat_id = pc.product_cat_id
;
drop view oplweb2.DBA.product_price_varchar;
create view oplweb2.DBA.product_price_varchar as
select
pp.product_price_id,
pp.product_release_id,
pp.product_cat_id, pc.product_cat_code,
pp.product_format_id, pf.product_format_code,
pp.opsys_family_id, pp.dbms_family_id,
replace(oo.opsys_family_name, ' ', '') as opsys_family_name,
replace(dd.dbms_family_name, ' ', '') as dbms_family_name,
pp.opsys_type_id, ot.short_description as opsys_type_code,
pp.product_price_type_id,
pp.product_price_unit_type_id, cast(pp.unit_price as varchar) as unit_price,
pp.component_archive_available
from
oplweb2.oplweb.product_price pp,
oplweb2.oplweb.product_category pc,
oplweb2.oplweb.product_format pf,
oplweb2.oplweb.opsys_type ot,
oplweb2.oplweb.dbms_family dd,
oplweb2.oplweb.opsys_family oo
where
pp.product_format_id = pf.product_format_id and
pp.product_cat_id = pc.product_cat_id and
pp.opsys_type_id = ot.opsys_type_id and
pp.opsys_family_id = oo.opsys_family_id and
pp.dbms_family_id = dd.dbms_family_id
--and
--pp.product_release_id = '6.1'
;
grant select on oplweb2.oplweb.product_price to "SPARQL", "SPARQL_UPDATE";--, rdf;
grant select on oplweb2.oplweb.product_price_type to "SPARQL", "SPARQL_UPDATE";--, rdf;
grant select on oplweb2.oplweb.product_price_unit_type to "SPARQL", "SPARQL_UPDATE";--, rdf;
grant select on oplweb2.DBA.product_general_discount_vc to "SPARQL", "SPARQL_UPDATE";--, rdf;
grant select on oplweb2.DBA.product_price_varchar to "SPARQL", "SPARQL_UPDATE";--, rdf;
grant select on oplweb2.DBA.license_model_type to "SPARQL", "SPARQL_UPDATE";--, rdf;
DB.DBA.RDF_AUDIT_METADATA (1, '*');
--DB.DBA.RDF_AUDIT_METADATA (2, '*');
--sparql drop graph ;
--possible previous graph now merging with this oplweb graph
sparql drop graph ;
--others that have a dependency on this graph that may need kicking first
--sparql drop graph ;
--sparql drop graph ;
--sparql drop graph ;
sparql drop graph ;
sparql drop graph ;
sparql drop graph ;
-- should now use
sparql drop quad map virtrdf:product_portfolio ;
--only use this if you really really mean it, it will totally nuke your RDF data, useful on
--test boxes in a bit of jam (hasn't happened to me for a while now)
--rdf_global_reset();
--utility for stripping url killing stuff from friendly strings used as ids
create function oplweb2.oplweb.FIXUP4URI (in _string varchar)
returns varchar
{
declare _s varchar;
_s := replace (_string, ' ', '');
_s := replace (_s, '&', '_');
_s := replace (_s, '/', '');
return _s;
}
;
--URI-IRI mapping functions
create function oplweb2.oplweb.DOWNLOAD_LOCATION_URI (in uri varchar)
returns varchar
{
return sprintf('http://data.openlinksw.com/oplweb/download_location/%s#this',
replace(uri, 'http://', ''));
};
create function oplweb2.oplweb.DOWNLOAD_LOCATION_URI_INVERSE (in dl_iri varchar)
returns varchar
{
declare parts any;
parts := sprintf_inverse(dl_iri,
'http://data.openlinksw.com/oplweb/download_location/%s#this', 1);
if (parts is not null)
{
return sprintf('http://%s', parts[0]);
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.DOWNLOAD_LOCATION_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.DOWNLOAD_LOCATION_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.DBMS_FAMILY_URI (in _family_id integer)
returns varchar
{
declare _family_string varchar;
select dbms_family_name into _family_string
from oplweb2.oplweb.dbms_family
where dbms_family_id = _family_id ;
return sprintf('http://data.openlinksw.com/oplweb/dbms_family/%s#this',
oplweb2.oplweb.FIXUP4URI(_family_string));
};
create function oplweb2.oplweb.DBMS_FAMILY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _family_id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/dbms_family/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 dbms_family_id into _family_id from oplweb2.oplweb.dbms_family
where lower(oplweb2.oplweb.FIXUP4URI(dbms_family_name)) = lower(parts[0]);
return _family_id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.DBMS_FAMILY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.DBMS_FAMILY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.COMPONENT_CATEGORY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.component_category
where component_category_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/component_category/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.COMPONENT_CATEGORY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/component_category/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 component_category_id into _id from oplweb2.oplweb.component_category
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_CATEGORY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_CATEGORY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.COMPONENT_MODE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.component_mode
where component_mode_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/component_mode/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.COMPONENT_MODE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/component_mode/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 component_mode_id into _id from oplweb2.oplweb.component_mode
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_MODE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_MODE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.COMPONENT_TYPE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.component_type
where component_type_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/component_type/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.COMPONENT_TYPE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/component_type/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 component_type_id into _id from oplweb2.oplweb.component_type
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_TYPE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_TYPE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.COMPONENT_ARCHIVE_TYPE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select component_archive_short_name into _string
from oplweb2.oplweb.component_archive_type
where component_archive_type_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/component_archive_type/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.COMPONENT_ARCHIVE_TYPE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/component_archive_type/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 component_archive_type_id into _id from oplweb2.oplweb.component_archive_type
where lower(oplweb2.oplweb.FIXUP4URI(component_archive_short_name)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_ARCHIVE_TYPE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.COMPONENT_ARCHIVE_TYPE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.FEATURE_BENEFIT_URI (in _id integer)
returns varchar
{
declare _string varchar;
select product_benefit_desc into _string
from oplweb2.oplweb.product_benefits
where product_benefit_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/feature_benefit/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.FEATURE_BENEFIT_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/feature_benefit/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_benefit_id into _id from oplweb2.oplweb.product_benefits
where lower(oplweb2.oplweb.FIXUP4URI(product_benefit_desc)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.FEATURE_BENEFIT_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.FEATURE_BENEFIT_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.OPSYS_FAMILY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select opsys_family_name into _string
from oplweb2.oplweb.opsys_family
where opsys_family_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/opsys_family/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.OPSYS_FAMILY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/opsys_family/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 opsys_family_id into _id from oplweb2.oplweb.opsys_family
where lower(oplweb2.oplweb.FIXUP4URI(opsys_family_name)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.OPSYS_FAMILY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.OPSYS_FAMILY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.OPSYS_TYPE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.opsys_type
where opsys_type_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/opsys_type/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.OPSYS_TYPE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/opsys_type/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 opsys_type_id into _id from oplweb2.oplweb.opsys_type
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.OPSYS_TYPE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.OPSYS_TYPE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PROCESSOR_FAMILY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select processor_family_name into _string
from oplweb2.oplweb.processor_family
where processor_family_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/processor_family/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PROCESSOR_FAMILY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/processor_family/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 processor_family_id into _id from oplweb2.oplweb.processor_family
where lower(oplweb2.oplweb.FIXUP4URI(processor_family_name)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PROCESSOR_FAMILY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PROCESSOR_FAMILY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
--FIXME might have to do something with possible & symbols
create function oplweb2.oplweb.PROCESSOR_MODE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select processor_mode_name into _string
from oplweb2.oplweb.processor_mode
where processor_mode_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/processor_mode/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PROCESSOR_MODE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/processor_mode/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 processor_mode_id into _id from oplweb2.oplweb.processor_mode
where lower(oplweb2.oplweb.FIXUP4URI(processor_mode_name)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PROCESSOR_MODE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PROCESSOR_MODE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_CATEGORY_FEATURE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.product_category_features
where product_category_feature_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_category_feature/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_CATEGORY_FEATURE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_category_feature/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_category_feature_id into _id from oplweb2.oplweb.product_category_features
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_CATEGORY_FEATURE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_CATEGORY_FEATURE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_FAMILY_FEATURE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.product_family_features
where product_family_feature_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_family_feature/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_FAMILY_FEATURE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_family_feature/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_family_feature_id into _id from oplweb2.oplweb.product_family_features
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FAMILY_FEATURE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FAMILY_FEATURE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_FEATURE_CATEGORY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_desc into _string
from oplweb2.oplweb.product_feature_category
where product_feature_category_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_feature_category/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_FEATURE_CATEGORY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_feature_category/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_feature_category_id into _id from oplweb2.oplweb.product_feature_category
where lower(oplweb2.oplweb.FIXUP4URI(short_desc)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FEATURE_CATEGORY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FEATURE_CATEGORY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_FEATURE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.product_features
where product_feature_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_feature/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_FEATURE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_feature/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_feature_id into _id from oplweb2.oplweb.product_features
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FEATURE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FEATURE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_FORMAT_FEATURE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.product_format_features
where product_format_feature_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_format_feature/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_FORMAT_FEATURE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_format_feature/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_format_feature_id into _id from oplweb2.oplweb.product_format_features
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FORMAT_FEATURE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_FORMAT_FEATURE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_RELEASE_FEATURE_URI (in _id integer)
returns varchar
{
declare _string varchar;
select short_description into _string
from oplweb2.oplweb.product_release_features
where product_release_feature_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_release_feature/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_RELEASE_FEATURE_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_release_feature/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_release_feature_id into _id from oplweb2.oplweb.product_release_features
where lower(oplweb2.oplweb.FIXUP4URI(short_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_RELEASE_FEATURE_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_RELEASE_FEATURE_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_BENEFIT_URI (in _id integer)
returns varchar
{
declare _string varchar;
select product_benefit_desc into _string
from oplweb2.oplweb.product_benefits
where product_benefit_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_benefit/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_BENEFIT_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_benefit/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_benefit_id into _id from oplweb2.oplweb.product_benefits
where lower(oplweb2.oplweb.FIXUP4URI(product_benefit_desc)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_BENEFIT_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_BENEFIT_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.PRODUCT_BENEFIT_CATEGORY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select description into _string
from oplweb2.oplweb.product_benefits_category
where product_benefit_category_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/product_benefit_category/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.PRODUCT_BENEFIT_CATEGORY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/product_benefit_category/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 product_benefit_category_id into _id from oplweb2.oplweb.product_benefits_category
where lower(oplweb2.oplweb.FIXUP4URI(description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_BENEFIT_CATEGORY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.PRODUCT_BENEFIT_CATEGORY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.VENDOR_URI (in _id integer)
returns varchar
{
declare _string varchar;
select vendor_name into _string
from oplweb2.oplweb.vendors
where vendor_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/vendor/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.VENDOR_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/vendor/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 vendor_id into _id from oplweb2.oplweb.vendors
where lower(oplweb2.oplweb.FIXUP4URI(vendor_name)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.VENDOR_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.VENDOR_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.VENDOR_CATEGORY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select vendor_category_description into _string
from oplweb2.oplweb.vendor_category
where vendor_category_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/vendor_category/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.VENDOR_CATEGORY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/vendor_category/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 vendor_category_id into _id from oplweb2.oplweb.vendor_category
where lower(oplweb2.oplweb.FIXUP4URI(vendor_category_description)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.VENDOR_CATEGORY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.VENDOR_CATEGORY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.VENDOR_CATEGORY_FAMILY_URI (in _id integer)
returns varchar
{
declare _string varchar;
select vendor_category_family_desc into _string
from oplweb2.oplweb.vendor_category_family
where vendor_category_family_id = _id ;
return sprintf('http://data.openlinksw.com/oplweb/vendor_category_family/%s#this',
oplweb2.oplweb.FIXUP4URI(_string));
};
create function oplweb2.oplweb.VENDOR_CATEGORY_FAMILY_URI_INVERSE (in _iri varchar)
returns integer
{
declare parts any;
declare _id integer;
parts := sprintf_inverse(_iri,
'http://data.openlinksw.com/oplweb/vendor_category_family/%s#this', 1);
if (parts is not null)
{
declare exit handler for not found return null;
select top 1 vendor_category_family_id into _id from oplweb2.oplweb.vendor_category_family
where lower(oplweb2.oplweb.FIXUP4URI(vendor_category_family_desc)) = lower(parts[0]);
return _id;
}
return NULL;
};
GRANT EXECUTE ON oplweb2.oplweb.VENDOR_CATEGORY_FAMILY_URI TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON oplweb2.oplweb.VENDOR_CATEGORY_FAMILY_URI_INVERSE TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LIT_PRODUCT_RELEASE_LABEL (
in _product_id varchar, in _id integer, in _opsys_name varchar, in _dbms_name varchar
)
returns varchar
{
declare _string varchar;
select 'OpenLink ' || poduct_description || ' (Release ' || product_release_id || ') on ' || commercial_name into _string
from oplweb2.oplweb.product_release pr,
oplweb2.oplweb.product p,
oplweb2.oplweb.opsys o
where
p.product_id = pr.product_id and
o.opsys_name = pr.opsys_name and
pr.product_release_id = _id and
pr.product_id = _product_id and
pr.opsys_name = _opsys_name and
pr.dbms_name = _dbms_name ;
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LIT_PRODUCT_RELEASE_LABEL TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LIT_FORMAT_CAT_LABEL (
in _format integer, in _cat integer
)
returns varchar
{
declare _string varchar;
select top 1 'OpenLink ' || cast(product_format_description as varchar) || ' ' || cast(product_category_description as varchar) into _string
from
oplweb2.oplweb.product_formats_categories fc,
oplweb2.oplweb.product_format f,
oplweb2.oplweb.product_category c
where
fc.product_format_id = f.product_format_id and
fc.product_cat_id = c.product_cat_id and
fc.product_format_id = _format and
fc.product_cat_id = _cat;
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LIT_FORMAT_CAT_LABEL TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_openlink_logo (in _code varchar)
returns varchar
{
declare _string varchar;
select top 1 product_family_logo_url into _string
from oplweb2.oplweb.product_family
where product_family_code = _code;
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_openlink_logo TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_homepage (in _code varchar)
returns varchar
{
declare _string varchar;
select top 1 product_family_homepage into _string
from oplweb2.oplweb.product_family
where product_family_code = _code;
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_homepage TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_opsys_icon (in _id integer)
returns varchar
{
declare _string varchar; _string := '';
select top 1 opsys_icon_name into _string
from oplweb2.oplweb.opsys_family
where opsys_family_id = _id;
_string := 'http://download.openlinksw.com/download/images/'||_string;
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_opsys_icon TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_to_shop (
in release_id varchar,
in product_id varchar,
in opsys varchar,
in dbms varchar
)
returns varchar
{
declare _string varchar; _string := '';
declare _cat, _format, _prod varchar;
_prod := product_id;
select top 1 cast(product_cat_id as varchar), cast(product_format_id as varchar)
into _cat, _format
from oplweb2.oplweb.product p
where p.product_id = _prod;
_string := sprintf(
'https://shop.openlinksw.com/?product_release_id=%s&product=%s&product_cat=%V&product_format=%V&os=%s&db=%s&buyme=yes',
release_id, product_id, _cat, _format, opsys, dbms
);
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_to_shop TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_license_model_type (
in _product_price_type_id integer
)
returns varchar
{
declare _string varchar; _string := '';
select top 1 product_price_type_description into _string from oplweb2.oplweb.product_price_type
where product_price_type_id = _product_price_type_id;
return _string || ' License';
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_license_model_type TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_license_model_explain (
in _product_price_type_id integer
)
returns varchar
{
declare _string varchar; _string := '';
select top 1 product_price_type_long_description into _string from oplweb2.oplweb.product_price_type
where product_price_type_id = _product_price_type_id;
return _string;
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_license_model_explain TO "SPARQL", "SPARQL_UPDATE";
create function oplweb2.oplweb.LITRDF_shop_sample (
in release_id varchar,
in product_id varchar,
in opsys varchar,
in dbms varchar
)
returns varchar
{
declare _string varchar; _string := '';
declare _cat, _format, _prod, _pricetype varchar;
_prod := product_id;
select top 1 cast(product_cat_id as varchar), cast(product_format_id as varchar), cast(product_price_type_id as varchar)
into _cat, _format, _pricetype
from oplweb2.DBA.license_model p, oplweb2.oplweb.opsys o, oplweb2.oplweb.dbms_engine e
where p.product_id = _prod and product_release_id = release_id and o.opsys_name = opsys and e.dbms_name = dbms
and p.dbms_family_id = e.dbms_family_id and o.opsys_family_id = p.opsys_family_id;
_string := sprintf(
'https://shop.openlinksw.com/price_calc.vsp?release=%s&cat=%V&format=%V&os=%s&db=%s&lictype=%V',
release_id, _cat, _format, opsys, dbms, _pricetype
);
return http_client(_string);
};
GRANT EXECUTE ON oplweb2.oplweb.LITRDF_shop_sample TO "SPARQL", "SPARQL_UPDATE";
-- $Id: oplweb_rdf_view_def.sql,v 1.2 2008/10/31 10:44:42 oplmis Exp $
-- Setup script for Linked Data View of OpenLink Product Portfolio version 2
--
--
-- This view is currently designed to SPECIFICALLY load on data.openlinksw.com. The default URI macro has NOT
-- been used here because it makes no sense on the target box which is actually my.usnet.private:8891 or
-- something similar. If you want to use this view on another box, a simple search-replace should do the trick,
-- but search-replace just`data.openlinksw.com' because http:// is sometimes encoded and you would miss it.
--
--
sparql drop quad map virtrdf:product_portfolio2 ;
sparql drop quad map virtrdf:product_portfolio ;
sparql
prefix opl:
drop iri class opl:DownloadLocation .
drop iri class opl:ComponentCategory .
drop iri class opl:Component .
drop iri class opl:ComponentArchive .
drop iri class opl:ComponentArchiveType .
drop iri class opl:ComponentCategory .
drop iri class opl:ComponentMode .
drop iri class opl:ComponentType .
drop iri class opl:DbmsEngine .
drop iri class opl:DbmsFamily .
drop iri class opl:DownloadProtocol .
drop iri class opl:DownloadPartner .
drop iri class opl:FeatureBenefit .
drop iri class opl:Opsys .
drop iri class opl:OpsysFamily .
drop iri class opl:OpsysType .
drop iri class opl:Processor .
drop iri class opl:ProcessorFamily .
drop iri class opl:ProcessorMode .
drop iri class opl:ProductRelease .
drop iri class opl:Product .
drop iri class opl:ProductCategory .
drop iri class opl:ProductCategoryFeature .
drop iri class opl:ProductPortfolio .
drop iri class opl:ProductFamily .
drop iri class opl:ProductFamilyFeature .
drop iri class opl:ProductFeatureCategory .
drop iri class opl:ProductFeature .
drop iri class opl:ProductFormat .
drop iri class opl:ProductFormatCategory .
drop iri class opl:ProductFormatFeature .
drop iri class opl:ProductReleaseFeature .
drop iri class opl:ProductBenefit .
drop iri class opl:ProductBenefitCategory .
drop iri class opl:Vendor .
drop iri class opl:VendorCategory .
drop iri class opl:VendorCategoryFamily .
drop iri class opl:PriceType .
drop iri class opl:PriceUnitType .
drop iri class opl:PriceUnitIncrementalDiscount .
drop iri class opl:ProductPrice .
drop iri class opl:LicenseType .
drop iri class opl:LicenseModel .
drop iri class opl:LicenseClass .
drop iri class opl:Discount .
drop literal class opl:lit_product_release_label .
drop literal class opl:lit_format_cat_label .
drop literal class opl:lit_openlink_logo .
drop iri class opl:lit_openlink_logo .
drop literal class opl:lit_homepage .
drop iri class opl:lit_homepage .
drop literal class opl:lit_opsys_icon .
drop iri class opl:lit_opsys_icon .
drop literal class opl:lit_to_shop .
drop iri class opl:lit_to_shop .
drop literal class opl:lit_license_model_type .
drop literal class opl:lit_license_model_explain .
drop literal class opl:lit_shop_sample .
drop literal class opl:lit_wikipedia_to_dbpedia .
drop iri class opl:lit_wikipedia_to_dbpedia .
drop literal class opl:lit_to_string .
drop iri class opl:wwwsitefamily .
drop iri class opl:wwwsiteformat .
drop iri class opl:wwwsitecategory .
drop iri class opl:wwwsiteproduct .
;
DB.DBA.RDF_AUDIT_METADATA (1, '*');
sparql
prefix opl:
create iri class opl:Component "http://data.openlinksw.com/oplweb/component/%s#this"
(in component_name varchar not null) .
create iri class opl:ComponentArchive "http://data.openlinksw.com/oplweb/component_archive/%s#this"
(in component_archive_name varchar not null) .
create iri class opl:ComponentArchiveType using
function oplweb2.oplweb.COMPONENT_CATEGORY_URI (in _id integer not null)
returns varchar,
function oplweb2.oplweb.COMPONENT_CATEGORY_URI_INVERSE (in _iri varchar)
returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/component_archive_type/%s#this' ).
create iri class opl:ComponentCategory using
function oplweb2.oplweb.COMPONENT_CATEGORY_URI (in _id integer not null)
returns varchar,
function oplweb2.oplweb.COMPONENT_CATEGORY_URI_INVERSE (in _iri varchar)
returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/component_category/%s#this' ).
create iri class opl:ComponentMode using
function oplweb2.oplweb.COMPONENT_MODE_URI (in _id integer not null)
returns varchar,
function oplweb2.oplweb.COMPONENT_MODE_URI_INVERSE (in _iri varchar)
returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/component_mode/%s#this' ).
create iri class opl:ComponentType using
function oplweb2.oplweb.COMPONENT_TYPE_URI (in _id integer not null)
returns varchar,
function oplweb2.oplweb.COMPONENT_TYPE_URI_INVERSE (in _iri varchar)
returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/component_type/%s#this' ).
create iri class opl:DbmsFamily using
function oplweb2.oplweb.DBMS_FAMILY_URI (in _family_id integer not null)
returns varchar,
function oplweb2.oplweb.DBMS_FAMILY_URI_INVERSE (in _iri varchar)
returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/dbms_family/%s#this' ).
create iri class opl:DbmsEngine "http://data.openlinksw.com/oplweb/dbms_engine/%s#this"
(in dbms_name varchar not null) .
create iri class opl:DownloadLocation using
function oplweb2.oplweb.DOWNLOAD_LOCATION_URI (in uri varchar not null)
returns varchar,
function oplweb2.oplweb.DOWNLOAD_LOCATION_URI_INVERSE (in dl_iri varchar)
returns varchar
option (bijection, returns 'http://data.openlinksw.com/oplweb/download_location/%s#this' ).
create iri class opl:DownloadProtocol "http://data.openlinksw.com/oplweb/download_protocol/%s#this"
(in protocol_name varchar not null) .
create iri class opl:DownloadPartner "http://data.openlinksw.com/oplweb/download_partner/%s/%s#this"
(
in host_name varchar not null,
in domain_name varchar not null
) .
create iri class opl:FeatureBenefit using
function oplweb2.oplweb.FEATURE_BENEFIT_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.FEATURE_BENEFIT_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/feature_benefit/%s#this' ).
create iri class opl:Opsys "http://data.openlinksw.com/oplweb/opsys/%s#this"
(in opsys_name varchar not null) .
create iri class opl:OpsysFamily using
function oplweb2.oplweb.OPSYS_FAMILY_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.OPSYS_FAMILY_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/opsys_family/%s#this' ).
create iri class opl:OpsysType using
function oplweb2.oplweb.OPSYS_TYPE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.OPSYS_TYPE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/opsys_type/%s#this' ).
create iri class opl:Processor "http://data.openlinksw.com/oplweb/processor/%s/%d#this"
(in processor_name varchar not null, in processor_mode_id integer not null) .
create iri class opl:ProcessorFamily using
function oplweb2.oplweb.PROCESSOR_FAMILY_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PROCESSOR_FAMILY_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/processor_family/%s#this' ).
create iri class opl:ProcessorMode using
function oplweb2.oplweb.PROCESSOR_MODE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PROCESSOR_MODE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/processor_mode/%s#this' ).
create iri class opl:Product "http://data.openlinksw.com/oplweb/product/%s#this"
(in product_id varchar not null) .
create iri class opl:ProductCategory "http://data.openlinksw.com/oplweb/product_category/%s#this"
(in product_cat_code varchar not null) .
create iri class opl:ProductCategoryFeature using
function oplweb2.oplweb.PRODUCT_CATEGORY_FEATURE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_CATEGORY_FEATURE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_category_feature/%s#this' ).
create iri class opl:ProductPortfolio "http://data.openlinksw.com/oplweb/portfolio/%s#this"
(in x varchar not null) .
create iri class opl:ProductFamily "http://data.openlinksw.com/oplweb/product_family/%s#this"
(in product_family_code varchar not null) .
create iri class opl:ProductFamilyFeature using
function oplweb2.oplweb.PRODUCT_FAMILY_FEATURE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_FAMILY_FEATURE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_family_feature/%s#this' ).
create iri class opl:ProductFeatureCategory using
function oplweb2.oplweb.PRODUCT_FEATURE_CATEGORY_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_FEATURE_CATEGORY_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_feature_category/%s#this' ).
create iri class opl:ProductFeature using
function oplweb2.oplweb.PRODUCT_FEATURE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_FEATURE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_feature/%s#this' ).
create iri class opl:ProductFormat "http://data.openlinksw.com/oplweb/product_format/%s#this"
(in product_format_code varchar not null) .
create iri class opl:ProductFormatCategory "http://data.openlinksw.com/oplweb/product_format_category/%s/%s#this"
(in product_format_code varchar not null, in product_cat_code varchar not null) .
create iri class opl:ProductFormatFeature using
function oplweb2.oplweb.PRODUCT_FORMAT_FEATURE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_FORMAT_FEATURE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_format_feature/%s#this' ).
create iri class opl:ProductReleaseFeature using
function oplweb2.oplweb.PRODUCT_RELEASE_FEATURE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_RELEASE_FEATURE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_release_feature/%s#this' ).
create iri class opl:ProductBenefit using
function oplweb2.oplweb.PRODUCT_BENEFIT_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_BENEFIT_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_benefit/%s#this' ).
create iri class opl:ProductBenefitCategory using
function oplweb2.oplweb.PRODUCT_BENEFIT_CATEGORY_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.PRODUCT_BENEFIT_CATEGORY_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/product_benefit_category/%s#this' ).
create iri class opl:ProductRelease "http://data.openlinksw.com/oplweb/product_release/%s/%s/%s/%s#this"
(
in product_id varchar not null,
in product_release_id varchar not null,
in opsys_name varchar not null,
in dbms_name varchar not null
) .
create iri class opl:Vendor using
function oplweb2.oplweb.VENDOR_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.VENDOR_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/vendor/%s#this' ).
create iri class opl:VendorCategory using
function oplweb2.oplweb.VENDOR_CATEGORY_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.VENDOR_CATEGORY_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/vendor_category/%s#this' ).
create iri class opl:VendorCategoryFamily using
function oplweb2.oplweb.VENDOR_CATEGORY_FAMILY_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.VENDOR_CATEGORY_FAMILY_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/vendor_category_family/%s#this' ).
create iri class opl:PriceType "http://data.openlinksw.com/oplweb/price_type/%d#this"
(in product_price_type_id integer not null) .
create iri class opl:LicenseType using
function oplweb2.oplweb.LICENSE_MODEL_TYPE_URI (in _id integer not null) returns varchar,
function oplweb2.oplweb.LICENSE_MODEL_TYPE_URI_INVERSE (in _iri varchar) returns integer
option (bijection, returns 'http://data.openlinksw.com/oplweb/license_type/%s#this' ).
create iri class opl:PriceUnitType "http://data.openlinksw.com/oplweb/price_unit_type/%s_%s_%d_%d_%d_%s#this"
(
in product_release_id varchar not null,
in product_id varchar not null,
in opsys_family_id integer not null,
in dbms_family_id integer not null,
in product_price_type_id integer not null,
in product_price_unit_type_id varchar not null) .
create iri class opl:PriceUnitIncrementalDiscount "http://data.openlinksw.com/oplweb/price_unit_discount/%s_%s_%d_%d_%d_%s#this"
(
in product_release_id varchar not null,
in product_id varchar not null,
in opsys_family_id integer not null,
in dbms_family_id integer not null,
in product_price_type_id integer not null,
in product_price_unit_type_id varchar not null) .
create iri class opl:ProductPrice "http://data.openlinksw.com/oplweb/product_price/%d#this"
(in product_price_id integer not null) .
create iri class opl:LicenseModel "http://data.openlinksw.com/oplweb/license_model/%s_%s_%d_%d_%d#this"
(
in product_release_id varchar not null,
in product_id varchar not null,
in opsys_family_id integer not null,
in dbms_family_id integer not null,
in product_price_type_id integer not null
) .
create iri class opl:Discount "http://data.openlinksw.com/oplweb/discount/%s/%d/%s/%d/%d/%d#this"
(
in product_release_id varchar not null,
in opsys_type_id integer not null,
in product_id varchar not null,
in opsys_family_id integer not null,
in dbms_family_id integer not null,
in product_price_type_id integer not null
) .
create iri class opl:wwwsitefamily "http://%s.openlinksw.com/"
(
in product_family_code varchar not null
) .
create iri class opl:wwwsitecategory "http://%s.openlinksw.com/%s/"
(
in product_family_code varchar not null,
in product_category_code varchar not null
) .
create iri class opl:wwwsiteformat using
function oplweb2.oplweb.wwwsiteformat_URI (
in product_category_code varchar,
in product_format_code varchar
)
returns varchar .
create iri class opl:Uri "%s"
( in uri varchar not null
) .
create literal class opl:lit_product_release_label using
function oplweb2.oplweb.LIT_PRODUCT_RELEASE_LABEL(
in _product_id varchar, in _id varchar, in _opsys_name varchar, in _dbms_name varchar
)
returns varchar .
create literal class opl:lit_format_cat_label using
function oplweb2.oplweb.LIT_FORMAT_CAT_LABEL(
in _format integer, in _cat integer
)
returns varchar .
create iri class opl:lit_openlink_logo using
function oplweb2.oplweb.LITRDF_openlink_logo(
in _code varchar
)
returns varchar .
create iri class opl:lit_homepage using
function oplweb2.oplweb.LITRDF_homepage(
in _code varchar
)
returns varchar .
create iri class opl:lit_opsys_icon using
function oplweb2.oplweb.LITRDF_opsys_icon(
in _id integer
)
returns varchar .
create iri class opl:lit_to_shop using
function oplweb2.oplweb.LITRDF_to_shop(
in release_id varchar,
in product_id varchar,
in opsys varchar,
in dbms varchar
)
returns varchar .
create literal class opl:lit_license_model_type using
function oplweb2.oplweb.LITRDF_license_model_type (
in _product_price_type_id integer
)
returns varchar .
create literal class opl:lit_license_model_explain using
function oplweb2.oplweb.LITRDF_license_model_explain (
in _product_price_type_id integer
)
returns varchar .
create literal class opl:lit_shop_sample using
function oplweb2.oplweb.LITRDF_shop_sample (
in release_id varchar,
in product_id varchar,
in opsys varchar,
in dbms varchar
)
returns varchar .
create iri class opl:lit_wikipedia_to_dbpedia using
function oplweb2.oplweb.LITRDF_wikipedia_to_dbpedia (
in wikipedia_url varchar
)
returns varchar .
create literal class opl:lit_to_string using
function oplweb2.oplweb.LITRDF_to_string (
in _s varchar
)
returns varchar .
create iri class opl:wwwsiteproduct using
function oplweb2.oplweb.wwwsiteproduct_URI (in _id varchar not null) returns varchar,
function oplweb2.oplweb.wwwsiteproduct_URI_INVERSE (in _iri varchar) returns varchar
.
make opl:ProductCategory subclass of opl:ProductFamily .
make opl:Product subclass of opl:ProductCategory .
make opl:Product subclass of opl:ProductFormat .
make opl:ProductRelease subclass of opl:Product .
make opl:Opsys subclass of opl:OpsysFamily .
make opl:DbmsEngine subclass of opl:DbmsFamily .
;
DB.DBA.RDF_AUDIT_METADATA (1, '*');
sparql
prefix opl:
prefix dc:
prefix oplsioc:
prefix sioc:
prefix foaf:
prefix wgs:
prefix rdfs:
prefix oplds:
prefix owl:
prefix umbel:
prefix gr:
prefix ore:
alter quad storage virtrdf:DefaultQuadStorage
from oplweb2.oplweb.component_archive as component_archive_tbl
from oplweb2.oplweb.component_archive_type as component_archive_type_tbl
from oplweb2.oplweb.component_category as component_category_tbl text literal component_category_long_description
from oplweb2.oplweb.component_mode as component_mode_tbl
from oplweb2.oplweb.component_type as component_type_tbl
from oplweb2.oplweb.components_for_rdfs as components_tbl
from oplweb2.oplweb.dbms_engine as dbms_engine_tbl
from oplweb2.oplweb.dbms_family as dbms_family_tbl
from oplweb2.oplweb.download_location as download_location_tbl
from oplweb2.oplweb.download_protocol as download_protocol_tbl
from oplweb2.oplweb.download_partner as download_partner_tbl
from oplweb2.oplweb.opsys as opsys_tbl
from oplweb2.oplweb.opsys_family as opsys_family_tbl
from oplweb2.oplweb.opsys_type as opsys_type_tbl
from oplweb2.oplweb.processor_family as processor_family_tbl
from oplweb2.oplweb.processor_mode as processor_mode_tbl
from oplweb2.oplweb.processors as processors_tbl
from oplweb2.oplweb.product as product_tbl text literal long_description
from oplweb2.oplweb.product_benefits as product_benefits_tbl text literal product_benefit_explanation
from oplweb2.oplweb.product_benefits_category as product_benefits_category_tbl
from oplweb2.oplweb.product_category as product_category_tbl
from oplweb2.oplweb.product_category_features_with_code as product_category_features_tbl text literal long_description
from oplweb2.oplweb.product_family as product_family_tbl
from oplweb2.oplweb.product_family as product_family_tbl_2
from oplweb2.oplweb.product_family_features_with_code as product_family_features_tbl text literal long_description
from oplweb2.oplweb.product_features as product_features_tbl text literal long_description
from oplweb2.oplweb.product_feature_category as product_feature_category_tbl text literal description
from oplweb2.oplweb.product_format_features_with_code as product_format_features_tbl text literal long_description
from oplweb2.oplweb.product_release_features as product_release_features_tbl text literal long_description
from oplweb2.oplweb.product_release_with_family as product_release_tbl
from oplweb2.oplweb.vendor_category as vendor_category_tbl
from oplweb2.oplweb.vendor_category_family as vendor_category_family_tbl
from oplweb2.oplweb.vendors as vendors_tbl
from oplweb2.oplweb.product_formats_categories as product_formats_categories
from oplweb2.oplweb.product_with_code as product_with_code
from oplweb2.oplweb.product_category_with_code as product_category_with_code
from oplweb2.oplweb.product_format as product_format_with_code
from oplweb2.oplweb.product_price as pp
from oplweb2.oplweb.product_price_type as pt
from oplweb2.DBA.license_model_unit_type as put
from oplweb2.DBA.license_model_unit_type as put2
from oplweb2.DBA.license_model as lm
from oplweb2.DBA.license_model as lm2
from oplweb2.DBA.license_model_type as license_model_type_tbl
from oplweb2.DBA.product_price_varchar as ppv
from oplweb2.DBA.product_general_discount_vc as gd
from oplweb2.oplweb.archive_coverage_osdb as ac1
{
create virtrdf:product_portfolio as
graph
{
opl:ProductPortfolio(product_family_tbl.product_family_code)
a opl:ProductPortfolio
as virtrdf:OplProductPortfolio .
opl:ProductPortfolio(product_family_tbl.product_family_code) opl:hasProductFamilies
opl:ProductFamily(product_family_tbl.product_family_code)
as virtrdf:OplProductPortfolioProductFamily .
opl:ProductFamily(product_family_tbl.product_family_code)
a opl:ProductFamily
as virtrdf:OplProductFamily ;
rdfs:label product_family_tbl.product_family_description
as virtrdf:rdfsOplProductFamilyDescription ;
foaf:name product_family_tbl.product_family_description
as virtrdf:nameOplProductFamilyDescription ;
foaf:logo opl:lit_openlink_logo(product_family_tbl.product_family_code)
as virtrdf:logoOpenLinkSoftware ;
foaf:homepage opl:lit_homepage(product_family_tbl.product_family_code)
as virtrdf:homepageProductFamily ;
foaf:homepage opl:wwwsitefamily(product_family_tbl.product_family_code)
# where (
# ^{product_family_tbl.}^.product_family_code = 'uda'
# )
as virtrdf:homepageProductFamilyUda ;
foaf:maker oplds:this
as virtrdf:OplDataspaceOpenLinkUri ;
owl:sameAs product_family_tbl.dbpedia_uri
as virtrdf:OplFamilyOwlSameAsDBPediaUri ;
opl:ProductFamilyCode product_family_tbl.product_family_code
as virtrdf:OplProductFamilyCode ;
opl:ProductFamilyDescription product_family_tbl.product_family_description
as virtrdf:OplProductFamilyDescription ;
dc:description opl:lit_to_string(product_family_tbl.long_description)
as virtrdf:OplProductFamilyLongDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy owl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy owl: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductCategory(product_category_with_code.product_cat_code)
a opl:ProductCategory
as virtrdf:OplProductCategory ;
a opl:ProductFamily
as virtrdf:OplProductCategorySubClassOfProductFamily ;
rdfs:label product_category_with_code.product_category_description
as virtrdf:rdfsOplProductCategoryDescription ;
foaf:homepage opl:wwwsitecategory(product_category_with_code.product_family_code, product_category_with_code.product_cat_code)
# where (
# ^{product_category_with_code.}^.product_family_code = 'uda'
# )
as virtrdf:homepageProductFamilyCategoryUda ;
opl:ProductCategoryCode product_category_with_code.product_cat_code
as virtrdf:OplProductCategoryCode ;
owl:sameAs product_category_with_code.dbpedia_uri
as virtrdf:OplCategoryOwlSameAsDBPediaUri ;
opl:hasFamily opl:ProductFamily(product_category_with_code.product_family_code)
as virtrdf:OplProductCategoryIsOfFamily ;
opl:ProductCategoryDescription product_category_with_code.product_category_description
as virtrdf:OplProductCategoryDescription ;
dc:description opl:lit_to_string(product_category_with_code.long_description)
as virtrdf:OplProductCategoryLongDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy owl: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy owl:
.
opl:ProductFormat(product_format_with_code.product_format_code)
a opl:ProductFormat
as virtrdf:OplProductFormat ;
opl:ProductFormatCode product_format_with_code.product_format_code
as virtrdf:OplProductFormatCode ;
rdfs:label product_format_with_code.product_format_description
as virtrdf:rdfsOplProductFormatDescription ;
dc:description product_format_with_code.product_format_description
as virtrdf:OplProductFormatDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
ore:isDescribedBy dc: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs: ;
rdfs:isDefinedBy dc:
.
opl:ProductFormatCategory(product_formats_categories.product_format_code, product_formats_categories.product_cat_code)
a opl:ProductFormatCategory
as virtrdf:OplProductFormatCategory ;
a opl:ProductFormat
as virtrdf:OplProductFormatCategoryProductFormat ;
a opl:ProductCategory
as virtrdf:OplProductFormatCategoryProductCategory ;
foaf:homepage opl:wwwsiteformat(product_formats_categories.product_cat_code, product_formats_categories.product_format_code)
# where (
# ^{product_category_with_code.}^.product_cat_code = ^{product_formats_categories.}^.product_cat_code
# and
# ^{product_category_with_code.}^.product_family_code = 'uda'
# )
as virtrdf:homepageProductFamilyCategoryFormatUda ;
opl:ProductFormatCode product_formats_categories.product_format_code
as virtrdf:OplProductFormatCategoryFormatCode ;
opl:ProductCategoryCode product_formats_categories.product_cat_code
as virtrdf:OplProductFormatCategoryCategoryCode ;
opl:isProductCategory opl:ProductCategory(product_formats_categories.product_cat_code)
as virtrdf:OplProductFormatCategoryisCategory ;
opl:isProductFormat opl:ProductFormat(product_formats_categories.product_format_code)
as virtrdf:OplProductFormatCategoryisFormat ;
rdfs:label opl:lit_format_cat_label(product_formats_categories.product_format_id, product_formats_categories.product_cat_id)
as virtrdf:rdfsOplProductFormatCategoryDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductCategory(product_category_with_code.product_cat_code) opl:hasProduct
opl:Product(product_with_code.product_id)
where (^{product_with_code.}^.product_cat_id = ^{product_category_with_code.}^.product_cat_id)
as virtrdf:OplProductCategoryIsCategoryOfProduct .
opl:ProductFormat(product_format_with_code.product_format_code) opl:hasProduct
opl:Product(product_with_code.product_id)
where (^{product_with_code.}^.product_format_id = ^{product_format_with_code.}^.product_format_id)
as virtrdf:OplProductFormatIsFormatOfProduct .
opl:ProductFamily(product_family_tbl.product_family_code) opl:hasCategory
opl:ProductCategory(product_category_with_code.product_cat_code)
where (^{product_family_tbl.}^.product_family_id = ^{product_category_with_code.}^.product_family_id)
as virtrdf:OplProductFamilyIsFamilyOfProductCategory .
opl:ProductFamily(product_family_tbl.product_family_code) opl:hasFormat
opl:ProductFormat(product_formats_categories.product_format_code)
where (
^{product_family_tbl.}^.product_family_id = ^{product_formats_categories.}^.product_family_id
)
as virtrdf:OplProductFamilyIsFamilyOfProductFormats .
opl:ProductFamily(product_family_tbl.product_family_code) opl:otherProductFamilies
opl:ProductFamily(product_family_tbl_2.product_family_code)
where (
^{product_family_tbl.}^.product_family_id <> ^{product_family_tbl_2.}^.product_family_id
)
as virtrdf:OplProductFamilyHasOtherProductFamilies .
opl:ProductFormat(product_format_with_code.product_format_code) opl:hasCategory
opl:ProductFormatCategory(product_formats_categories.product_format_code, product_formats_categories.product_cat_code)
where (^{product_formats_categories.}^.product_format_id = ^{product_format_with_code.}^.product_format_id)
as virtrdf:OplProductFormatIsFormatOfProductFormatCategories .
opl:ProductFormatCategory(product_formats_categories.product_format_code, product_formats_categories.product_cat_code)
opl:hasProduct
opl:Product(product_with_code.product_id)
where (
^{product_with_code.}^.product_cat_id = ^{product_formats_categories.}^.product_cat_id
and
^{product_with_code.}^.product_format_id = ^{product_formats_categories.}^.product_format_id
)
as virtrdf:OplProductFormatCategoryIsFormatCategoryOfProduct .
opl:VendorCategoryFamily(vendor_category_family_tbl.vendor_category_family_id)
a opl:VendorCategoryFamily
as virtrdf:OplVendorCategoryFamily ;
opl:VendorCategoryFamilyDescription vendor_category_family_tbl.vendor_category_family_desc
as virtrdf:OplVendorCategoryFamilyDesc .
opl:VendorCategory(vendor_category_tbl.vendor_category_id)
a opl:VendorCategory
as virtrdf:OplVendorCategory ;
a opl:VendorCategoryFamily
as virtrdf:OplVendorCategorySubClassOfVendorCategoryFamily ;
rdfs:label vendor_category_tbl.vendor_category_description
as virtrdf:rdfsOplVendorCategoryDescription ;
opl:VendorCategoryDescription vendor_category_tbl.vendor_category_description
as virtrdf:OplVendorCategoryDescription ;
opl:isVendorCategoryOf opl:VendorCategoryFamily(vendor_category_tbl.vendor_category_family_id)
as virtrdf:OplVendorCategoryIsOfCategoryFamily ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs:;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:Vendor(vendors_tbl.vendor_id)
a opl:Vendor
as virtrdf:OplVendor ;
a opl:VendorCategory
as virtrdf:OplVendorSubClassOfVendorCategory ;
rdfs:label vendors_tbl.vendor_name
as virtrdf:rdfsOplVendorsName ;
opl:VendorName vendors_tbl.vendor_name
as virtrdf:OplVendorsName ;
opl:WikipediaPage opl:Uri(vendors_tbl.wikipedia_url)
as virtrdf:OplVendorsWikipediaUrl ;
owl:sameAs opl:lit_wikipedia_to_dbpedia(vendors_tbl.wikipedia_url)
as virtrdf:OplVendorsWikipediaUrlOwlSameAs ;
foaf:homepage opl:Uri(vendors_tbl.vendor_homepage)
as virtrdf:OplFoafVendorHomepage ;
opl:isOfVendorCategory opl:VendorCategory(vendors_tbl.vendor_category_id)
as virtrdf:OplVendorIsOfVendorCategory ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy owl: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy owl:
.
opl:VendorCategoryFamily(vendor_category_family_tbl.vendor_category_family_id)
opl:hasVendorCategory
opl:VendorCategory(vendor_category_tbl.vendor_category_id)
where (
^{vendor_category_family_tbl.}^.vendor_category_family_id = ^{vendor_category_tbl.}^.vendor_category_family_id
)
as virtrdf:OplVendorCategoryFamilyHasVendorCategory .
opl:VendorCategory(vendor_category_tbl.vendor_category_id)
opl:hasVendorCategory
opl:Vendor(vendors_tbl.vendor_id)
where (
^{vendor_category_tbl.}^.vendor_category_id = ^{vendors_tbl.}^.vendor_category_id
)
as virtrdf:OplVendorCategoryHasVendors .
opl:OpsysFamily(opsys_family_tbl.opsys_family_id)
a opl:OpsysFamily
as virtrdf:OplOpsysFamily ;
rdfs:label opsys_family_tbl.opsys_family_name
as virtrdf:rdfsOplOpsysFamilyName ;
opl:OpsysFamilyName opsys_family_tbl.opsys_family_name
as virtrdf:OplOpsysFamilyName ;
opl:OpsysFamilyLicenseCode opsys_family_tbl.opsys_license_code
as virtrdf:OplOpsysFamilyLicenseCode ;
opl:OpsysFamilyVendor opl:Vendor(opsys_family_tbl.vendor_id)
as virtrdf:OplOpsysFamilyVendor ;
opl:OpsysFamilyRating opsys_family_tbl.rating
as virtrdf:OplOpsysFamilyRating ;
foaf:logo opl:lit_opsys_icon(opsys_family_tbl.opsys_family_id)
as virtrdf:OplLogoOpsysFamily ;
foaf:homepage opl:Uri(opsys_family_tbl.wikipedia_url)
as virtrdf:FoafHomepageOpsysFamilyWikipediaUrl ;
owl:sameAs opl:lit_wikipedia_to_dbpedia(opsys_family_tbl.wikipedia_url)
as virtrdf:FoafHomepageOpsysFamilyPediaUrlOwlSameAs ;
opl:WikipediaPage opl:Uri(opsys_family_tbl.wikipedia_url)
as virtrdf:OplOpsysFamilyWikipediaUrl ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy owl: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy owl:
.
opl:OpsysFamily(opsys_family_tbl.opsys_family_id) opl:hasOpsys
opl:Opsys(opsys_tbl.opsys_name)
where (^{opsys_tbl.}^.opsys_family_id = ^{opsys_family_tbl.}^.opsys_family_id)
as virtrdf:OplOpsysFamilyIsOpsysFamilyOfOpsys .
opl:DbmsFamily(dbms_family_tbl.dbms_family_id)
a opl:DbmsFamily
as virtrdf:OplDbmsFamily ;
rdfs:label dbms_family_tbl.dbms_family_name
as virtrdf:rdfsOplDbmsFamilyName ;
opl:DbmsFamilyName dbms_family_tbl.dbms_family_name
as virtrdf:OplDbmsFamilyName ;
opl:DbmsFamilyVendor opl:Vendor(dbms_family_tbl.vendor_id)
as virtrdf:OplDbmsFamilyVendor ;
foaf:homepage opl:Uri(dbms_family_tbl.wikipedia_url)
as virtrdf:FoafHomepageDbmsFamilyWikipediaUrl ;
owl:sameAs opl:lit_wikipedia_to_dbpedia(dbms_family_tbl.wikipedia_url)
as virtrdf:OwnSameAsDbmsFamilyPediaUrl ;
opl:WikipediaPage opl:Uri(dbms_family_tbl.wikipedia_url)
as virtrdf:OplDbmsFamilyWikipediaUrl ;
opl:DbmsFamilyRating dbms_family_tbl.rating
as virtrdf:OplDbmsFamilyRating ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy owl: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy owl:
.
opl:DbmsEngine(dbms_engine_tbl.dbms_name)
a opl:DbmsEngine
as virtrdf:OplDbmsEngine ;
a opl:DbmsFamily
as virtrdf:DbmsEngineSubClassOfDbmsFamily ;
a umbel:RelationalDatabaseServerProgram
as virtrdf:DbmEngineSubClassOfUmbel ;
opl:isOfDbmsFamily opl:DbmsFamily(dbms_engine_tbl.dbms_family_id)
as virtrdf:OplDbmsEngineisOfDbmsFamily ;
rdfs:label dbms_engine_tbl.dbms_name
as virtrdf:rdfsOplLabelDbmsName ;
opl:DbmsEngineVersion dbms_engine_tbl.dbms_version
as virtrdf:OplDbmsEngineVersion ;
opl:DbmsEngineUpwardCompatible dbms_engine_tbl.upward_compatible
as virtrdf:OplDbmsEngineUpwardCompatible ;
opl:DbmsEngineDownwardCompatible dbms_engine_tbl.downward_compatible
as virtrdf:OplDbmsEngineDownwardCompatible ;
opl:DbmsEngineRating dbms_engine_tbl.rating
as virtrdf:OplDbmsEngineRating ;
opl:DbmsEngineOldArchiveCode dbms_engine_tbl.old_archive_code
as virtrdf:OplDbmsEngineOldArchiveCode ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:DbmsFamily(dbms_family_tbl.dbms_family_id)
opl:hasDatabaseVersions
opl:DbmsEngine(dbms_engine_tbl.dbms_name)
where (
^{dbms_family_tbl.}^.dbms_family_id = ^{dbms_engine_tbl.}^.dbms_family_id
)
as virtrdf:OplDbmsFamilyToDbms .
opl:OpsysType(opsys_type_tbl.opsys_type_id)
a opl:OpsysType
as virtrdf:OplOpsysType ;
rdfs:label opsys_type_tbl.opsys_type_description
as virtrdf:rdfsOplOpsysTypeDescription ;
opl:OpsysTypeDescription opsys_type_tbl.opsys_type_description
as virtrdf:OplOpsysTypeDescription ;
opl:OpsysTypeShortDescription opsys_type_tbl.short_description
as virtrdf:OplOpsysTypeShortDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:OpsysType(opsys_type_tbl.opsys_type_id) opl:hasOpsys
opl:Opsys(opsys_tbl.opsys_name)
where (^{opsys_tbl.}^.opsys_type_id = ^{opsys_type_tbl.}^.opsys_type_id)
as virtrdf:OplOpsysTypeIsOpsysTypeOfOpsys .
opl:ProcessorMode(processor_mode_tbl.processor_mode_id)
a opl:ProcessorMode
as virtrdf:OplProcessorMode ;
opl:ProcessorModeName processor_mode_tbl.processor_mode_name
as virtrdf:OplProcessorModeName .
opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
a opl:Processor
as virtrdf:OplProcessor ;
opl:ProcessorName processors_tbl.processor_name
as virtrdf:OplProcessorName ;
opl:ProcessorVersion processors_tbl.processor_version
as virtrdf:OplProcessorVersion ;
rdfs:label processors_tbl.processor_description
as virtrdf:rdfsOplProcessorDescription ;
opl:ProcessorDescription processors_tbl.processor_description
as virtrdf:OplProcessorDescription ;
opl:ProcessorMode opl:ProcessorMode(processors_tbl.processor_mode_id)
as virtrdf:OplProcessorProcessorMode ;
opl:isOfProcessorFamily opl:ProcessorFamily(processors_tbl.processor_family_id)
as virtrdf:OplProcessorIsOfProcessorFamily ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ProcessorFamily(processor_family_tbl.processor_family_id)
a opl:ProcessorFamily
as virtrdf:OplProcessorFamily ;
opl:ProcessorFamilyName processor_family_tbl.processor_family_name
as virtrdf:OplProcessorFamilyName ;
opl:ProcessorFamilyVendor opl:Vendor(processor_family_tbl.vendor_id)
as virtrdf:OplProcessorFamilyVendor ;
foaf:homepage opl:Uri(processor_family_tbl.wikipedia_url)
as virtrdf:FoafHomepageProcessorFamilyWikipediaUrl ;
owl:sameAs opl:lit_wikipedia_to_dbpedia(processor_family_tbl.wikipedia_url)
as virtrdf:OwlSameAsProcessorFamilyPediaUrl ;
opl:WikipediaPage opl:Uri(processor_family_tbl.wikipedia_url)
as virtrdf:OplProcessorFamilyWikipediaUrl ;
rdfs:label processor_family_tbl.processor_family_description
as virtrdf:rdfsOplProcessorFamilyDescription ;
opl:ProcessorFamilyDescription processor_family_tbl.processor_family_description
as virtrdf:OplProcessorFamilyDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy owl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy owl: ;
rdfs:isDefinedBy rdfs:
.
opl:Opsys(opsys_tbl.opsys_name)
a opl:Opsys
as virtrdf:OplOpsys ;
a opl:OpsysFamily
as virtrdf:OpsysSubClassOfOplOpsysFamily ;
a umbel:OperatingSystem
as virtrdf:OpsysSubClassOfUmbelOpsys ;
opl:OpsysVersion opsys_tbl.opsys_version
as virtrdf:OplOpsysVersion ;
opl:OpsysUpwardCompatible opsys_tbl.upward_compatible
as virtrdf:OplOpsysUpwardCompatible ;
opl:OpsysDownwardCompatible opsys_tbl.downward_compatible
as virtrdf:OplOpsysDownwardCompatible ;
opl:OpsysSupported opsys_tbl.supported
as virtrdf:OplOpsysSupported ;
opl:OpsysLicenseCode opsys_tbl.opsys_license_code
as virtrdf:OplOpsysLicenseCode ;
rdfs:label opsys_tbl.commercial_name
as virtrdf:rdfsOplOpsysCommercialName ;
opl:OpsysCommercialName opsys_tbl.commercial_name
as virtrdf:OplOpsysCommercialName ;
opl:OpsysEmulationMode opl:ProcessorMode(opsys_tbl.emulation_mode_id)
as virtrdf:OplOpsysEmulationMode ;
opl:OpsysProcessor opl:Processor(opsys_tbl.processor_name, opsys_tbl.processor_mode_id)
as virtrdf:OplOpsysProcessor ;
opl:isOfOpsysFamily opl:OpsysFamily(opsys_tbl.opsys_family_id)
as virtrdf:OplOpsysIsOfOpsysFamily ;
opl:isOfOpsysType opl:OpsysType(opsys_tbl.opsys_type_id)
as virtrdf:OplOpsysIsOfOpsysType ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:Product(product_with_code.product_id)
a opl:Product
as virtrdf:OplProduct ;
a opl:ProductFormat
as virtrdf:ProductSubClassOfProductFormat ;
a opl:ProductCategory
as virtrdf:ProductSubClassOfProductCategory ;
a opl:ProductFormatCategory
as virtrdf:OplProductProductFormatCategory ;
rdfs:label product_with_code.poduct_description
as virtrdf:rdfsOplProductDescription ;
foaf:homepage opl:wwwsiteproduct(product_with_code.product_id)
as virtrdf:homepageProductFamilyCategoryFormatProductUda ;
opl:ProductDescription product_with_code.poduct_description
as virtrdf:OplProductDescription ;
dc:description opl:lit_to_string(product_with_code.long_description)
as virtrdf:OplProductLongDescription ;
opl:isOfCategory opl:ProductCategory(product_with_code.product_cat_code)
as virtrdf:OplProductIsOfCategory ;
opl:isOfFormat opl:ProductFormat(product_with_code.product_format_code)
as virtrdf:OplProductIsOfFormat ;
ore:isDescribedBy opl: ;
ore:isDescribedBy foaf: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy foaf: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:Product(product_with_code.product_id) opl:hasProductRelease
opl:ProductRelease(
product_release_tbl.product_id,
product_release_tbl.product_release_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
where (^{product_with_code.}^.product_id = ^{product_release_tbl.}^.product_id)
as virtrdf:OplProductIsProductOfProductRelease .
opl:ProductRelease(
product_release_tbl.product_id,
product_release_tbl.product_release_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
a opl:ProductRelease
as virtrdf:OplProductRelease ;
a opl:Product
as virtrdf:OplProductReleaseSubClassProduct ;
a gr:ProductOrService
as virtrdf:OplProductReleaseAgrProductOrService ;
rdfs:label opl:lit_product_release_label(
product_release_tbl.product_id,
product_release_tbl.product_release_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
as virtrdf:rdfsOplProductReleaseProductReleaseId ;
opl:ProductReleaseProductReleaseId product_release_tbl.product_release_id
as virtrdf:OplProductReleaseProductReleaseId ;
opl:isOfProduct opl:Product(product_release_tbl.product_id)
as virtrdf:OplProductReleaseIsOfProduct ;
opl:isForOpsys opl:Opsys(product_release_tbl.opsys_name)
as virtrdf:OplProductReleaseIsForOpsys ;
opl:isForDbmsEngine opl:DbmsEngine(product_release_tbl.dbms_name)
as virtrdf:OplProductReleaseIsForDbmsEngine ;
opl:UpwardCompatible product_release_tbl.upward_compatible
as virtrdf:OplProductReleaseUpwardCompatible ;
opl:DownwardCompatible product_release_tbl.downward_compatible
as virtrdf:OplProductReleaseDownwardCompatible ;
opl:PurchaseInShop opl:lit_to_shop (
product_release_tbl.product_release_id,
product_release_tbl.product_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
as virtrdf:OplProductReleaseToShop ;
gr:hasBusinessFunction gr:Sell as virtrdf:grbusinessfunctionsell;
opl:Supported product_release_tbl.supported
as virtrdf:OplProductReleaseSupported ;
ore:isDescribedBy opl: ;
ore:isDescribedBy gr: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy gr:
.
opl:ProductRelease(
product_release_tbl.product_id,
product_release_tbl.product_release_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
) opl:hasComponentArchive
opl:ComponentArchive(component_archive_tbl.component_archive_name)
where (
^{product_release_tbl.}^.product_id = ^{component_archive_tbl.}^.product_id and
^{product_release_tbl.}^.product_release_id = ^{component_archive_tbl.}^.product_release_id and
^{product_release_tbl.}^.opsys_name = ^{component_archive_tbl.}^.opsys_name and
^{product_release_tbl.}^.dbms_name = ^{component_archive_tbl.}^.dbms_name
)
as virtrdf:OplProductReleaseIsProductReleaseOfComponentArchive .
opl:Component(components_tbl.component_name)
a opl:Component
as virtrdf:OplComponent ;
opl:isOfComponentCategory opl:ComponentCategory(components_tbl.component_category_id)
as virtrdf:OplComponentIsOfComponentCategory ;
opl:isOfComponentType opl:ComponentType(components_tbl.component_type_id)
as virtrdf:OplComponentIsOfComponentType ;
opl:isOfComponentMode opl:ComponentMode(components_tbl.component_mode_id)
as virtrdf:OplComponentIsOfComponentMode ;
opl:isForOpsys opl:Opsys(components_tbl.opsys_name)
as virtrdf:OplComponentIsForOpsys ;
opl:isForDbmsEngine opl:DbmsEngine(components_tbl.dbms_name)
as virtrdf:OplComponentIsForDbmsEngine ;
opl:ComponentCvsid components_tbl.component_cvsid
as virtrdf:OplComponentComponentCvsId ;
opl:ComponentBuildDate components_tbl.component_build_date
as virtrdf:OplComponentComponentBuildDate ;
opl:Notes components_tbl.notes
as virtrdf:OplComponentNotes ;
opl:BuildComments components_tbl.build_comments
as virtrdf:OplComponentBuildComments ;
opl:Filesize components_tbl.str_filesize
as virtrdf:OplComponentFilesize ;
rdfs:isDefinedBy opl: ;
ore:isDescribedBy opl:
.
opl:DbmsEngine (dbms_engine_tbl.dbms_name) opl:hasComponents
opl:Component(components_tbl.component_name)
where (^{components_tbl.}^.dbms_name = ^{dbms_engine_tbl.}^.dbms_name)
as virtrdf:OplDbmsEngineForComponents .
opl:Opsys (opsys_tbl.opsys_name) opl:hasComponents
opl:Component(components_tbl.component_name)
where (^{components_tbl.}^.opsys_name = ^{opsys_tbl.}^.opsys_name)
as virtrdf:OplOpsysForComponents .
opl:ComponentMode(component_mode_tbl.component_mode_id)
a opl:ComponentMode
as virtrdf:OplComponentMode ;
rdfs:label component_mode_tbl.component_mode_description
as virtrdf:rdfsOplComponentModeDescription ;
opl:ComponentModeDescription component_mode_tbl.component_mode_description
as virtrdf:OplComponentModeDescription ;
opl:ComponentModeShortDescription component_mode_tbl.short_description
as virtrdf:OplComponentModeShortDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ComponentType(component_type_tbl.component_type_id)
a opl:ComponentType
as virtrdf:OplComponentType ;
rdfs:label component_type_tbl.component_type_description
as virtrdf:rdfsOplComponentTypeDescription ;
opl:ComponentTypeDescription component_type_tbl.component_type_description
as virtrdf:OplComponentTypeDescription ;
opl:ComponentTypeShortDescription component_type_tbl.short_description
as virtrdf:OplComponentTypeShortDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ComponentCategory(component_category_tbl.component_category_id)
a opl:ComponentCategory
as virtrdf:OplComponentCategory ;
rdfs:label component_category_tbl.component_category_description
as virtrdf:rdfsOplComponentCategoryDescription ;
opl:ComponentCategoryDescription component_category_tbl.component_category_description
as virtrdf:OplComponentCategoryDescription ;
opl:ComponentCategoryShortDescription component_category_tbl.short_description
as virtrdf:OplComponentCateegoryShortDescription ;
dc:description opl:lit_to_string(component_category_tbl.component_category_long_description)
as virtrdf:OplComponentCategoryLongDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ComponentArchive(component_archive_tbl.component_archive_name)
a opl:ComponentArchive
as virtrdf:OplComponentArchive ;
a opl:Component
as virtrdf:ComponentArchiveSubClassOfComponent ;
opl:ComponentArchiveName component_archive_tbl.component_archive_name
as virtrdf:OplComponentArchiveComponentArchiveName ;
rdfs:label component_archive_tbl.component_archive_name
as virtrdf:rdfsComponentArchiveComponentArchiveName ;
opl:ComponentArchiveType opl:ComponentArchiveType(component_archive_tbl.component_archive_type_id)
as virtrdf:ComponentArchiveComponentArchiveType ;
opl:isOfComponent opl:Component(component_archive_tbl.component_name)
as virtrdf:OplComponentArchiveIsOfComponent ;
opl:isOfProductRelease opl:ProductRelease(
component_archive_tbl.product_id,
component_archive_tbl.product_release_id,
component_archive_tbl.opsys_name,
component_archive_tbl.dbms_name
)
as virtrdf:OplComponentArchiveIsOfProductRelease ;
opl:AssemblyDate component_archive_tbl.assembly_date
as virtrdf:OplComponentArchiveAssemblyDate ;
opl:FileUri component_archive_tbl.file_uri
as virtrdf:OplComponentArchiveFileUri ;
opl:LicenseCode component_archive_tbl.license_code
as virtrdf:OplComponentArchiveLicenseCode ;
opl:ResFullPath component_archive_tbl.res_full_path
as virtrdf:OplComponentArchiveResFullPath ;
opl:ResName component_archive_tbl.res_name
as virtrdf:OplComponentArchiveResName ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ComponentArchiveType(component_archive_type_tbl.component_archive_type_id)
a opl:ComponentArchiveType
as virtrdf:OplComponentArchiveType ;
opl:ComponentArchiveShortName component_archive_type_tbl.component_archive_short_name
as virtrdf:OplComponentArchiveTypeComponentArchiveShortName ;
rdfs:label component_archive_type_tbl.component_archive_type_name
as virtrdf:rdfsOplComponentArchiveTypeComponentArchiveTypeName ;
opl:ComponentArchiveTypeName component_archive_type_tbl.component_archive_type_name
as virtrdf:OplComponentArchiveTypeComponentArchiveTypeName ;
opl:Extension component_archive_type_tbl.extension
as virtrdf:OplComponentArchiveTypeExtension ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:DownloadLocation(download_location_tbl.uri)
a opl:DownloadLocation
as virtrdf:OplDownloadLocation ;
opl:isOfComponentArchive opl:ComponentArchive(download_location_tbl.component_archive_name)
as virtrdf:OplDownloadLocationIsOfComponentArchive ;
opl:hasDownloadProtocol opl:DownloadProtocol(download_location_tbl.protocol_name)
as virtrdf:DownloadLocationHasProtocolName ;
rdfs:label download_location_tbl.uri_old
as virtrdf:rdfsOplDownloadLocationLabel ;
opl:isOfProductRelease opl:ProductRelease(
download_location_tbl.product_id,
download_location_tbl.product_release_id,
download_location_tbl.opsys_name,
download_location_tbl.dbms_name
)
as virtrdf:OplDownloadLocationIsOfProductRelease ;
opl:Uri download_location_tbl.uri
as virtrdf:OplDownloadLocationUri ;
opl:UriOld download_location_tbl.uri_old
as virtrdf:OplDownloadLocationUriOld ;
opl:hasDownloadPartner opl:DownloadPartner(
download_location_tbl.host_name,
download_location_tbl.domain_name
)
as virtrdf:OplDownloadLocationHasDownloadPartner ;
opl:DomainName download_location_tbl.domain_name
as virtrdf:OplDownloadLocationDomainName ;
opl:HostName download_location_tbl.host_name
as virtrdf:OplDownloadLocationHostName ;
opl:ResName download_location_tbl.res_name
as virtrdf:OplDownloadLocationResName ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:DownloadProtocol(download_protocol_tbl.protocol_name)
a opl:DownloadProtocol
as virtrdf:OplDownloadProtocolProtocolName ;
opl:ProtocolDescription download_protocol_tbl.protocol_description
as virtrdf:OplDownloadProtocolProtocolDescription .
opl:DownloadPartner(
download_partner_tbl.host_name,
download_partner_tbl.domain_name
)
a opl:DownloadPartner
as virtrdf:OplDownloadPartner;
rdfs:label download_partner_tbl.partner_name
as virtrdf:rdfsOplDownloadPartnerPartnerNamelabel ;
opl:DownloadPartner download_partner_tbl.partner_name
as virtrdf:OplDownloadPartnerPartnerName ;
opl:PortNumber download_partner_tbl.port_number
as virtrdf:OplDownloadPartnerPortNumber ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ComponentArchive(component_archive_tbl.component_archive_name)
opl:hasDownloadLocation
opl:DownloadLocation(download_location_tbl.uri)
where (
^{component_archive_tbl.}^.component_archive_name = ^{download_location_tbl.}^.component_archive_name
)
as virtrdf:OplComponentArchiveIsComponentArchiveOfDownloadLocation .
opl:DownloadLocation(download_location_tbl.uri)
opl:isDownloadLocationOf
opl:ComponentArchive(component_archive_tbl.component_archive_name)
where (
^{download_location_tbl.}^.component_archive_name = ^{component_archive_tbl.}^.component_archive_name
)
as virtrdf:OplDownloadLocationIsDowloadLocationOfComponentArchive .
#
# Extra Peripheral family/cat/format/etc... to/from... dbfamily/opsysfamily/....
# ==================================================================================
# ---------------------> product_family
# opl:ProductFamily(product_family_tbl.product_family_code)
# opl:OperatingSystems
# opl:Opsys(ac1.opsys_name)
# where (
# ^{product_family_tbl.}^.product_family_code = ^{ac1.}^.product_family_code
# )
# as virtrdf:OplProductFamilyToOpsys .
opl:ProductFamily(product_family_tbl.product_family_code)
opl:OperatingSystemsFamilies
opl:OpsysFamily(ac1.opsys_family_id)
where (
^{product_family_tbl.}^.product_family_code = ^{ac1.}^.product_family_code
)
as virtrdf:OplProductFamilyToOpsysFamily .
# opl:ProductFamily(product_family_tbl.product_family_code)
# opl:Databases
# opl:DbmsEngine(ac1.dbms_name)
# where (
# ^{product_family_tbl.}^.product_family_code = ^{ac1.}^.product_family_code
# )
# as virtrdf:OplProductFamilyToDbms .
opl:ProductFamily(product_family_tbl.product_family_code)
opl:DatabaseFamilies
opl:DbmsFamily(ac1.dbms_family_id)
where (
^{product_family_tbl.}^.product_family_code = ^{ac1.}^.product_family_code
)
as virtrdf:OplProductFamilyToDbmsFamily .
# opl:ProductFamily(product_family_tbl.product_family_code)
# opl:Processors
# opl:Processor(ac1.processor_name, ac1.processor_mode_id)
# where (
# ^{product_family_tbl.}^.product_family_code = ^{ac1.}^.product_family_code
# )
# as virtrdf:OplProductFamilyToProcessor .
opl:ProductFamily(product_family_tbl.product_family_code)
opl:ProcessorFamilies
opl:ProcessorFamily(ac1.processor_family_id)
where (
^{product_family_tbl.}^.product_family_code = ^{ac1.}^.product_family_code
)
as virtrdf:OplProductFamilyToProcessorFamily .
# ---------------------> product_format
# opl:ProductFormat(product_format_with_code.product_format_code)
# opl:OperatingSystems
# opl:Opsys(ac1.opsys_name)
# where (
# ^{product_format_with_code.}^.product_format_code = ^{ac1.}^.product_format_code
# )
# as virtrdf:OplProductFormatToOpsys .
opl:ProductFormat(product_format_with_code.product_format_code)
opl:OperatingSystemsFamilies
opl:OpsysFamily(ac1.opsys_family_id)
where (
^{product_format_with_code.}^.product_format_code = ^{ac1.}^.product_format_code
)
as virtrdf:OplProductFormatToOpsysFamily .
# opl:ProductFormat(product_format_with_code.product_format_code)
# opl:Databases
# opl:DbmsEngine(ac1.dbms_name)
# where (
# ^{product_format_with_code.}^.product_format_code = ^{ac1.}^.product_format_code
# )
# as virtrdf:OplProductFormatToDbms .
opl:ProductFormat(product_format_with_code.product_format_code)
opl:DatabaseFamilies
opl:DbmsFamily(ac1.dbms_family_id)
where (
^{product_format_with_code.}^.product_format_code = ^{ac1.}^.product_format_code
)
as virtrdf:OplProductFormatToDbmsFamily .
opl:ProductFormat(product_format_with_code.product_format_code)
opl:Processors
opl:Processor(ac1.processor_name, ac1.processor_mode_id)
where (
^{product_format_with_code.}^.product_format_code = ^{ac1.}^.product_format_code
)
as virtrdf:OplProductFormatToProcessor .
opl:ProductFormat(product_format_with_code.product_format_code)
opl:ProcessorFamilies
opl:ProcessorFamily(ac1.processor_family_id)
where (
^{product_format_with_code.}^.product_format_code = ^{ac1.}^.product_format_code
)
as virtrdf:OplProductFormatToProcessorFamily .
# ---------------------> product_category
# opl:ProductCategory(product_category_with_code.product_cat_code)
# opl:OperatingSystems
# opl:Opsys(ac1.opsys_name)
# where (
# ^{product_category_with_code.}^.product_cat_code = ^{ac1.}^.product_cat_code
# )
# as virtrdf:OplProductCatToOpsys .
opl:ProductCategory(product_category_with_code.product_cat_code)
opl:OperatingSystemsFamilies
opl:OpsysFamily(ac1.opsys_family_id)
where (
^{product_category_with_code.}^.product_cat_code = ^{ac1.}^.product_cat_code
)
as virtrdf:OplProductCatToOpsysFamily .
# opl:ProductCategory(product_category_with_code.product_cat_code)
# opl:Databases
# opl:DbmsEngine(ac1.dbms_name)
# where (
# ^{product_category_with_code.}^.product_cat_code = ^{ac1.}^.product_cat_code
# )
# as virtrdf:OplProductCatToDbms .
opl:ProductCategory(product_category_with_code.product_cat_code)
opl:DatabaseFamilies
opl:DbmsFamily(ac1.dbms_family_id)
where (
^{product_category_with_code.}^.product_cat_code = ^{ac1.}^.product_cat_code
)
as virtrdf:OplProductCatToDbmsFamily .
# opl:ProductCategory(product_category_with_code.product_cat_code)
# opl:Processors
# opl:Processor(ac1.processor_name, ac1.processor_mode_id)
# where (
# ^{product_category_with_code.}^.product_cat_code = ^{ac1.}^.product_cat_code
# )
# as virtrdf:OplProductCatToProcessor .
opl:ProductCategory(product_category_with_code.product_cat_code)
opl:ProcessorFamilies
opl:ProcessorFamily(ac1.processor_family_id)
where (
^{product_category_with_code.}^.product_cat_code = ^{ac1.}^.product_cat_code
)
as virtrdf:OplProductCatToProcessorFamily .
# ---------------------> product
opl:Product(product_with_code.product_id)
opl:OperatingSystems
opl:Opsys(ac1.opsys_name)
where (
^{product_with_code.}^.product_id = ^{ac1.}^.product_id
)
as virtrdf:OplProductToOpsys .
opl:Product(product_with_code.product_id)
opl:OperatingSystemsFamilies
opl:OpsysFamily(ac1.opsys_family_id)
where (
^{product_with_code.}^.product_id = ^{ac1.}^.product_id
)
as virtrdf:OplProductToOpsysFamily .
opl:Product(product_with_code.product_id)
opl:Databases
opl:DbmsEngine(ac1.dbms_name)
where (
^{product_with_code.}^.product_id = ^{ac1.}^.product_id
)
as virtrdf:OplProductToDbms .
opl:Product(product_with_code.product_id)
opl:DatabaseFamilies
opl:DbmsFamily(ac1.dbms_family_id)
where (
^{product_with_code.}^.product_id = ^{ac1.}^.product_id
)
as virtrdf:OplProductToDbmsFamily .
opl:Product(product_with_code.product_id)
opl:Processors
opl:Processor(ac1.processor_name, ac1.processor_mode_id)
where (
^{product_with_code.}^.product_id = ^{ac1.}^.product_id
)
as virtrdf:OplProductToProcessor .
opl:Product(product_with_code.product_id)
opl:ProcessorFamilies
opl:ProcessorFamily(ac1.processor_family_id)
where (
^{product_with_code.}^.product_id = ^{ac1.}^.product_id
)
as virtrdf:OplProductToProcessorFamily .
# ---------------------> to product
opl:Opsys(opsys_tbl.opsys_name)
opl:hasProducts
opl:Product(ac1.product_id)
where (
^{opsys_tbl.}^.opsys_name = ^{ac1.}^.opsys_name
)
as virtrdf:OplOpsysToProduct .
opl:OpsysFamily(opsys_family_tbl.opsys_family_id)
opl:hasProducts
opl:Product(ac1.product_id)
where (
^{opsys_family_tbl.}^.opsys_family_id = ^{ac1.}^.opsys_family_id
)
as virtrdf:OplOpsysFamilyToProduct .
opl:DbmsEngine(dbms_engine_tbl.dbms_name)
opl:hasProducts
opl:Product(ac1.product_id)
where (
^{dbms_engine_tbl.}^.dbms_name = ^{ac1.}^.dbms_name
)
as virtrdf:OplDbmsToProduct .
opl:DbmsFamily(dbms_family_tbl.dbms_family_id)
opl:hasProducts
opl:Product(ac1.product_id)
where (
^{dbms_family_tbl.}^.dbms_family_id = ^{ac1.}^.dbms_family_id
)
as virtrdf:OplDbmsFamilyToProduct .
opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
opl:hasProducts
opl:Product(ac1.product_id)
where (
^{processors_tbl.}^.processor_name = ^{ac1.}^.processor_name
and
^{processors_tbl.}^.processor_mode_id = ^{ac1.}^.processor_mode_id
)
as virtrdf:OplProcessorToProduct .
opl:ProcessorFamily(processor_family_tbl.processor_family_id)
opl:hasProducts
opl:Product(ac1.product_id)
where (
^{processor_family_tbl.}^.processor_family_id = ^{ac1.}^.processor_family_id
)
as virtrdf:OplProcessorFamilyProduct .
# ---------------------> to product_cat
# opl:Opsys(opsys_tbl.opsys_name)
# opl:hasProductCategory
# opl:ProductCategory(ac1.product_cat_code)
# where (
# ^{opsys_tbl.}^.opsys_name = ^{ac1.}^.opsys_name
# )
# as virtrdf:OplOpsysToProductCategory .
opl:OpsysFamily(opsys_family_tbl.opsys_family_id)
opl:hasProductCategory
opl:ProductCategory(ac1.product_cat_code)
where (
^{opsys_family_tbl.}^.opsys_family_id = ^{ac1.}^.opsys_family_id
)
as virtrdf:OplOpsysFamilyToProductCategory .
# opl:DbmsEngine(dbms_engine_tbl.dbms_name)
# opl:hasProductCategory
# opl:ProductCategory(ac1.product_cat_code)
# where (
# ^{dbms_engine_tbl.}^.dbms_name = ^{ac1.}^.dbms_name
# )
# as virtrdf:OplDbmsToProductCategory .
opl:DbmsFamily(dbms_family_tbl.dbms_family_id)
opl:hasProductCategory
opl:ProductCategory(ac1.product_cat_code)
where (
^{dbms_family_tbl.}^.dbms_family_id = ^{ac1.}^.dbms_family_id
)
as virtrdf:OplDbmsFamilyToProductCategory .
# opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
# opl:hasProductCategory
# opl:ProductCategory(ac1.product_cat_code)
# where (
# ^{processors_tbl.}^.processor_name = ^{ac1.}^.processor_name
# and
# ^{processors_tbl.}^.processor_mode_id = ^{ac1.}^.processor_mode_id
# )
# as virtrdf:OplProcessorToProductCategory .
opl:ProcessorFamily(processor_family_tbl.processor_family_id)
opl:hasProductCategory
opl:ProductCategory(ac1.product_cat_code)
where (
^{processor_family_tbl.}^.processor_family_id = ^{ac1.}^.processor_family_id
)
as virtrdf:OplProcessorFamilyProductCategory .
# ---------------------> to product_format
# opl:Opsys(opsys_tbl.opsys_name)
# opl:hasProductFormat
# opl:ProductFormat(ac1.product_format_code)
# where (
# ^{opsys_tbl.}^.opsys_name = ^{ac1.}^.opsys_name
# )
# as virtrdf:OplOpsysToProductFormat .
opl:OpsysFamily(opsys_family_tbl.opsys_family_id)
opl:hasProductFormat
opl:ProductFormat(ac1.product_format_code)
where (
^{opsys_family_tbl.}^.opsys_family_id = ^{ac1.}^.opsys_family_id
)
as virtrdf:OplOpsysFamilyToProductFormat .
# opl:DbmsEngine(dbms_engine_tbl.dbms_name)
# opl:hasProductFormat
# opl:ProductFormat(ac1.product_format_code)
# where (
# ^{dbms_engine_tbl.}^.dbms_name = ^{ac1.}^.dbms_name
# )
# as virtrdf:OplDbmsToProductFormat .
opl:DbmsFamily(dbms_family_tbl.dbms_family_id)
opl:hasProductFormat
opl:ProductFormat(ac1.product_format_code)
where (
^{dbms_family_tbl.}^.dbms_family_id = ^{ac1.}^.dbms_family_id
)
as virtrdf:OplDbmsFamilyToProductFormat .
# opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
# opl:hasProductFormat
# opl:ProductFormat(ac1.product_format_code)
# where (
# ^{processors_tbl.}^.processor_name = ^{ac1.}^.processor_name
# and
# ^{processors_tbl.}^.processor_mode_id = ^{ac1.}^.processor_mode_id
# )
# as virtrdf:OplProcessorToProductFormat .
opl:ProcessorFamily(processor_family_tbl.processor_family_id)
opl:hasProductFormat
opl:ProductFormat(ac1.product_format_code)
where (
^{processor_family_tbl.}^.processor_family_id = ^{ac1.}^.processor_family_id
)
as virtrdf:OplProcessorFamilyProductFormat .
# ---------------------> to product_family
# opl:Opsys(opsys_tbl.opsys_name)
# opl:hasProductFamily
# opl:ProductFamily(ac1.product_family_code)
# where (
# ^{opsys_tbl.}^.opsys_name = ^{ac1.}^.opsys_name
# )
# as virtrdf:OplOpsysToProductFamily .
opl:OpsysFamily(opsys_family_tbl.opsys_family_id)
opl:hasProductFamily
opl:ProductFamily(ac1.product_family_code)
where (
^{opsys_family_tbl.}^.opsys_family_id = ^{ac1.}^.opsys_family_id
)
as virtrdf:OplOpsysFamilyToProductFamily .
# opl:DbmsEngine(dbms_engine_tbl.dbms_name)
# opl:hasProductFamily
# opl:ProductFamily(ac1.product_family_code)
# where (
# ^{dbms_engine_tbl.}^.dbms_name = ^{ac1.}^.dbms_name
# )
# as virtrdf:OplDbmsToProductFamily .
opl:DbmsFamily(dbms_family_tbl.dbms_family_id)
opl:hasProductFamily
opl:ProductFamily(ac1.product_family_code)
where (
^{dbms_family_tbl.}^.dbms_family_id = ^{ac1.}^.dbms_family_id
)
as virtrdf:OplDbmsFamilyToProductFamily .
# opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
# opl:hasProductFamily
# opl:ProductFamily(ac1.product_family_code)
# where (
# ^{processors_tbl.}^.processor_name = ^{ac1.}^.processor_name
# and
# ^{processors_tbl.}^.processor_mode_id = ^{ac1.}^.processor_mode_id
# )
# as virtrdf:OplProcessorToProductFamily .
opl:ProcessorFamily(processor_family_tbl.processor_family_id)
opl:hasProductFamily
opl:ProductFamily(ac1.product_family_code)
where (
^{processor_family_tbl.}^.processor_family_id = ^{ac1.}^.processor_family_id
)
as virtrdf:OplProcessorFamilyProductFamily .
} .
} .
;
DB.DBA.RDF_AUDIT_METADATA (1, '*');
sparql
prefix opl:
prefix dc:
prefix oplsioc:
prefix sioc:
prefix foaf:
prefix wgs:
prefix rdfs:
prefix oplds:
prefix owl:
prefix umbel:
prefix gr:
prefix ore:
alter quad storage virtrdf:DefaultQuadStorage
from oplweb2.oplweb.component_archive as component_archive_tbl
from oplweb2.oplweb.component_archive_type as component_archive_type_tbl
from oplweb2.oplweb.component_category as component_category_tbl text literal component_category_long_description
from oplweb2.oplweb.component_mode as component_mode_tbl
from oplweb2.oplweb.component_type as component_type_tbl
from oplweb2.oplweb.components_for_rdfs as components_tbl
from oplweb2.oplweb.dbms_engine as dbms_engine_tbl
from oplweb2.oplweb.dbms_family as dbms_family_tbl
from oplweb2.oplweb.download_location as download_location_tbl
from oplweb2.oplweb.download_protocol as download_protocol_tbl
from oplweb2.oplweb.download_partner as download_partner_tbl
from oplweb2.oplweb.opsys as opsys_tbl
from oplweb2.oplweb.opsys_family as opsys_family_tbl
from oplweb2.oplweb.opsys_type as opsys_type_tbl
from oplweb2.oplweb.processor_family as processor_family_tbl
from oplweb2.oplweb.processor_mode as processor_mode_tbl
from oplweb2.oplweb.processors as processors_tbl
from oplweb2.oplweb.product as product_tbl text literal long_description
from oplweb2.oplweb.product_benefits as product_benefits_tbl text literal product_benefit_explanation
from oplweb2.oplweb.product_benefits_category as product_benefits_category_tbl
from oplweb2.oplweb.product_category as product_category_tbl
from oplweb2.oplweb.product_category_features_with_code as product_category_features_tbl text literal long_description
from oplweb2.oplweb.product_family as product_family_tbl
from oplweb2.oplweb.product_family as product_family_tbl_2
from oplweb2.oplweb.product_family_features_with_code as product_family_features_tbl text literal long_description
from oplweb2.oplweb.product_features as product_features_tbl text literal long_description
from oplweb2.oplweb.product_feature_category as product_feature_category_tbl text literal description
from oplweb2.oplweb.product_format_features_with_code as product_format_features_tbl text literal long_description
from oplweb2.oplweb.product_release_features as product_release_features_tbl text literal long_description
from oplweb2.oplweb.product_release_with_family as product_release_tbl
from oplweb2.oplweb.vendor_category as vendor_category_tbl
from oplweb2.oplweb.vendor_category_family as vendor_category_family_tbl
from oplweb2.oplweb.vendors as vendors_tbl
from oplweb2.oplweb.product_formats_categories as product_formats_categories
from oplweb2.oplweb.product_with_code as product_with_code
from oplweb2.oplweb.product_category_with_code as product_category_with_code
from oplweb2.oplweb.product_format as product_format_with_code
from oplweb2.oplweb.product_price as pp
from oplweb2.oplweb.product_price_type as pt
from oplweb2.DBA.license_model_unit_type as put
from oplweb2.DBA.license_model_unit_type as put2
from oplweb2.DBA.license_model as lm
from oplweb2.DBA.license_model as lm2
from oplweb2.DBA.license_model_type as license_model_type_tbl
from oplweb2.DBA.product_price_varchar as ppv
from oplweb2.DBA.product_general_discount_vc as gd
from oplweb2.oplweb.archive_coverage_osdb as ac1
{
create virtrdf:product_portfolio2 as
graph
option (exclusive)
{
#
# Product Benefits and things
# =========================================
opl:ProductBenefit(product_benefits_tbl.product_benefit_id)
a opl:ProductBenefit
as virtrdf:OplProductBenefit ;
rdfs:label product_benefits_tbl.product_benefit_desc
as virtrdf:rdfsLabelProductBenefitDescription ;
opl:isOfProductBenefitCategory opl:ProductBenefitCategory(product_benefits_tbl.product_benefit_category_id)
as virtrdf:OplProductBenefitIsOfProductBenefitCategory ;
opl:Description product_benefits_tbl.product_benefit_desc
as virtrdf:OplProductBenefitDescription ;
opl:Acronym product_benefits_tbl.product_benefit_acronym
as virtrdf:OplProductBenefitAcronym ;
opl:Explanation product_benefits_tbl.product_benefit_explanation
as virtrdf:OplProductBenefitExplanation ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductBenefitCategory(product_benefits_category_tbl.product_benefit_category_id)
a opl:ProductBenefitCategory
as virtrdf:OplProductBenefitCategory ;
rdfs:label product_benefits_category_tbl.description
as virtrdf:rdfsLabelProductBenefitCategoryDescription ;
opl:Description product_benefits_category_tbl.description
as virtrdf:OplProductBenefitCategoryDescription ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductFeatureCategory(product_feature_category_tbl.product_feature_category_id)
a opl:ProductFeatureCategory
as virtrdf:OplProductFeatureCategory ;
rdfs:label product_feature_category_tbl.short_desc
as virtrdf:rdfsLabelProductFeatureCategoryShortDescription ;
opl:ShortDescription product_feature_category_tbl.short_desc
as virtrdf:OplProductFeatureCategoryShortDescription ;
opl:Description product_feature_category_tbl.description
as virtrdf:OplProductFeatureCategoryDescription ;
opl:StandardsId product_feature_category_tbl.standards_id
as virtrdf:OplProductFeatureCategoryStandardsId ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductFeature(product_features_tbl.product_feature_id)
a opl:ProductFeature
as virtrdf:OplProductFeature ;
rdfs:label product_features_tbl.short_description
as virtrdf:rdfsLabelProductFeaturesShortDescription ;
opl:Description product_features_tbl.short_description
as virtrdf:OplProductFeaturesShortDescription ;
dc:description opl:lit_to_string(product_features_tbl.long_description)
as virtrdf:OplProductFeaturesLongDescription ;
opl:isOfProductBenefit opl:ProductBenefit(product_features_tbl.product_feature_benefit_id)
as virtrdf:ProductFeaturesIsOfProductBenefit ;
opl:isOfProductFeatureCategory opl:ProductFeatureCategory(product_features_tbl.product_feature_category_id)
as virtrdf:ProductFeaturesIsOfProductFeatureCategory ;
opl:isOfProduct opl:Product(product_features_tbl.product_id)
as virtrdf:ProductFeaturesIsOfProduct ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
ore:isDescribedBy dc: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:Product(product_with_code.product_id)
opl:hasFeature
opl:ProductFeature(product_features_tbl.product_feature_id)
where (
^{product_with_code.}^.product_id = ^{product_features_tbl.}^.product_id
)
as virtrdf:OplProductHasProductFeaturesProductFeatures .
opl:ProductFeature(product_features_tbl.product_feature_id)
opl:isFeatureOf
opl:Product(product_with_code.product_id)
where (
^{product_with_code.}^.product_id = ^{product_features_tbl.}^.product_id
)
as virtrdf:OplProductFeaturesAreProductFeaturesProduct .
opl:ProductFamilyFeature(product_family_features_tbl.product_family_feature_id)
a opl:ProductFamilyFeature
as virtrdf:OplProductFamilyFeature ;
rdfs:label product_family_features_tbl.short_description
as virtrdf:rdfsLabelProductFamilyFeaturesShortDescription ;
opl:Description product_family_features_tbl.short_description
as virtrdf:OplProductFamilyFeaturesShortDescription ;
dc:description opl:lit_to_string(product_family_features_tbl.long_description)
as virtrdf:OplProductFamilyFeaturesLongDescription ;
opl:isOfProductBenefit opl:ProductBenefit(product_family_features_tbl.product_family_feature_benefit_id)
as virtrdf:ProductFamilyFeaturesIsOfProductBenefit ;
opl:isOfProductFeatureCategory opl:ProductFeatureCategory(product_family_features_tbl.product_family_feature_cat_id)
as virtrdf:ProductFamilyFeaturesIsOfProductFeatureCategory ;
opl:isOfProductFamily opl:ProductFamily(product_family_features_tbl.product_family_code)
as virtrdf:ProductFamilyFeaturesIsOfProductFamily ;
ore:isDescribedBy opl: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductFamily(product_family_tbl.product_family_code)
opl:hasFeature
opl:ProductFamilyFeature(product_family_features_tbl.product_family_feature_id)
where (
^{product_family_tbl.}^.product_family_id = ^{product_family_features_tbl.}^.product_family_id
)
as virtrdf:OplProductFamilyHasProductFamilyFeaturesProductFamilyFeatures .
opl:ProductFamilyFeature(product_family_features_tbl.product_family_feature_id)
opl:isFeatureOf
opl:Product(product_family_tbl.product_family_code)
where (
^{product_family_tbl.}^.product_family_id = ^{product_family_features_tbl.}^.product_family_id
)
as virtrdf:OplProductFamilyFeaturesAreProductFamilyFeaturesProductFamily .
opl:ProductFormatFeature(product_format_features_tbl.product_format_feature_id)
a opl:ProductFormatFeature
as virtrdf:OplProductFormatFeature ;
rdfs:label product_format_features_tbl.short_description
as virtrdf:rdfsLabelProductFormatFeaturesShortDescription ;
opl:Description product_format_features_tbl.short_description
as virtrdf:OplProductFormatFeaturesShortDescription ;
dc:description opl:lit_to_string(product_format_features_tbl.long_description)
as virtrdf:OplProductFormatFeaturesLongDescription ;
opl:isOfProductBenefit opl:ProductBenefit(product_format_features_tbl.product_format_feature_benefit_id)
as virtrdf:ProductFormatFeaturesIsOfProductBenefit ;
opl:isOfProductFeatureCategory opl:ProductFeatureCategory(product_format_features_tbl.product_format_feature_cat_id)
as virtrdf:ProductFormatFeaturesIsOfProductFeatureCategory ;
opl:isOfProductFormat opl:ProductFormat(product_format_features_tbl.product_format_code)
as virtrdf:ProductFormatFeaturesIsOfProductFormat ;
ore:isDescribedBy opl: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductFormat(product_format_with_code.product_format_code)
opl:hasFeature
opl:ProductFormatFeature(product_format_features_tbl.product_format_feature_id)
where (
^{product_format_with_code.}^.product_format_id = ^{product_format_features_tbl.}^.product_format_id
)
as virtrdf:OplProductFormatHasProductFormatFeaturesProductFormatFeatures .
opl:ProductFormatFeature(product_format_features_tbl.product_format_feature_id)
opl:isFeatureOf
opl:ProductFormat(product_format_with_code.product_format_code)
where (
^{product_format_with_code.}^.product_format_id = ^{product_format_features_tbl.}^.product_format_id
)
as virtrdf:OplProductFormatFeaturesAreProductFormatFeaturesProductFormat .
opl:ProductCategoryFeature(product_category_features_tbl.product_category_feature_id)
a opl:ProductCategoryFeature
as virtrdf:OplProductCategoryFeature ;
rdfs:label product_category_features_tbl.short_description
as virtrdf:rdfsLabelProductCategoryFeaturesShortDescription ;
opl:Description product_category_features_tbl.short_description
as virtrdf:OplProductCategoryFeaturesShortDescription ;
dc:description opl:lit_to_string(product_category_features_tbl.long_description)
as virtrdf:OplProductCategoryFeaturesLongDescription ;
opl:isOfProductBenefit opl:ProductBenefit(product_category_features_tbl.product_category_feature_benefit_id)
as virtrdf:ProductCategoryFeaturesIsOfProductBenefit ;
opl:isOfProductFeatureCategory opl:ProductFeatureCategory(product_category_features_tbl.product_category_feature_category_id)
as virtrdf:ProductCategoryFeaturesIsOfProductFeatureCategory ;
opl:isOfProductCategory opl:ProductCategory(product_category_features_tbl.product_cat_code)
as virtrdf:ProductCategoryFeaturesIsOfProductCategory ;
ore:isDescribedBy opl: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:ProductCategory(product_category_with_code.product_cat_code)
opl:hasFeature
opl:ProductCategoryFeature(product_category_features_tbl.product_category_feature_id)
where (
^{product_category_with_code.}^.product_cat_id = ^{product_category_features_tbl.}^.product_cat_id
)
as virtrdf:OplProductCategoryHasProductCategoryFeaturesProductCategoryFeatures .
opl:ProductCategoryFeature(product_category_features_tbl.product_category_feature_id)
opl:isFeatureOf
opl:ProductCategory(product_category_with_code.product_cat_code)
where (
^{product_category_with_code.}^.product_cat_id = ^{product_category_features_tbl.}^.product_cat_id
)
as virtrdf:OplProductCategoryFeaturesAreProductCategoryFeaturesProductCategory .
opl:ProductReleaseFeature(product_release_features_tbl.product_release_feature_id)
a opl:ProductReleaseFeature
as virtrdf:OplProductReleaseFeature ;
rdfs:label product_release_features_tbl.short_description
as virtrdf:rdfsLabelProductReleaseFeaturesShortDescription ;
opl:Description product_release_features_tbl.short_description
as virtrdf:OplProductReleaseFeaturesShortDescription ;
dc:description opl:lit_to_string(product_release_features_tbl.long_description)
as virtrdf:OplProductReleaseFeaturesLongDescription ;
opl:isOfProductBenefit opl:ProductBenefit(product_release_features_tbl.product_release_feature_benefit_id)
as virtrdf:ProductReleaseFeaturesIsOfProductBenefit ;
opl:isOfProductFeatureCategory opl:ProductFeatureCategory(product_release_features_tbl.product_release_feature_cat_id)
as virtrdf:ProductReleaseFeaturesIsOfProductFeatureCategory ;
opl:isOfProduct opl:Product(product_release_features_tbl.product_id)
as virtrdf:ProductReleaseFeaturesIsOfProduct ;
opl:ProductReleaseId product_release_features_tbl.product_release_id
as virtrdf:ProductReleaseFeaturesProductRelease ;
ore:isDescribedBy opl: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:ProcessorFamily(processor_family_tbl.processor_family_id)
opl:hasProcessors
opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
where (
^{processor_family_tbl.}^.processor_family_id = ^{processors_tbl.}^.processor_family_id
)
as virtrdf:OplProcessorFamilyHasProcessors .
opl:Processor(processors_tbl.processor_name, processors_tbl.processor_mode_id)
opl:hasProductFamily
opl:ProductFamily(ac1.product_family_code)
where (
^{processors_tbl.}^.processor_name = ^{ac1.}^.processor_name
and
^{processors_tbl.}^.processor_mode_id = ^{ac1.}^.processor_mode_id
)
as virtrdf:OplProcessorToProductFamily .
#
# Product Licensing and Shop stuff
# =========================================
opl:ProductRelease(
product_release_tbl.product_id,
product_release_tbl.product_release_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
opl:hasLicenseModel
opl:LicenseModel(
lm.product_release_id,
lm.product_id,
lm.opsys_family_id,
lm.dbms_family_id,
lm.product_price_type_id
)
where (
^{lm.}^.product_id = ^{product_release_tbl.}^.product_id and
^{lm.}^.product_release_id = ^{product_release_tbl.}^.product_release_id and
^{lm.}^.opsys_family_id = ^{product_release_tbl.}^.opsys_family_id and
^{lm.}^.dbms_family_id = ^{product_release_tbl.}^.dbms_family_id
)
as virtrdf:OplProductReleaseHasLicenseModel .
opl:ProductRelease(
product_release_tbl.product_id,
product_release_tbl.product_release_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
opl:hasPriceSample
opl:lit_shop_sample (
product_release_tbl.product_release_id,
product_release_tbl.product_id,
product_release_tbl.opsys_name,
product_release_tbl.dbms_name
)
as virtrdf:OplPriceSamples .
opl:LicenseModel(
lm.product_release_id,
lm.product_id,
lm.opsys_family_id,
lm.dbms_family_id,
lm.product_price_type_id)
a opl:LicenseModel
as virtrdf:OplLicenseModel;
a gr:Sell
as virtrdf:OplLicenseModelAgrSell ;
a gr:ActualProductOrServiceInstance
as virtrdf:OplLicenseModelAgrProductOrServiceInstance ;
rdfs:label opl:lit_license_model_type(
lm.product_price_type_id
) as virtrdf:OplLabelLicenseModel ;
rdfs:description opl:lit_license_model_explain (
lm.product_price_type_id
) as virtrdf:OplLicenseModelExplain ;
opl:ProductReleaseId
lm.product_release_id
as virtrdf:lm_shop_price_product_release;
opl:isOfFormat
opl:ProductFormat(lm.product_format_code)
as virtrdf:lm_shop_price_product_format;
opl:isOfCategory
opl:ProductCategory(lm.product_cat_code)
as virtrdf:lm_shop_price_product_cat;
opl:OpsysFamily
opl:OpsysFamily(lm.opsys_family_id)
as virtrdf:lm_shop_price_opsys_family_oplweb;
opl:OpsysType
opl:OpsysType(lm.opsys_type_id)
as virtrdf:lm_shop_price_opsys_type;
opl:DbmsFamily
opl:DbmsFamily(lm.dbms_family_id)
as virtrdf:lm_shop_price_dbms_family ;
ore:isDescribedBy opl: ;
ore:isDescribedBy gr: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs: ;
rdfs:isDefinedBy gr:
.
opl:LicenseModel(
lm.product_release_id,
lm.product_id,
lm.opsys_family_id,
lm.dbms_family_id,
lm.product_price_type_id)
opl:hasPriceUnitType
opl:PriceUnitType(
lm2.product_release_id,
lm2.product_id,
lm2.opsys_family_id,
lm2.dbms_family_id,
lm2.product_price_type_id,
lm2.product_price_unit_type_id)
where (
^{lm.}^.product_release_id = ^{lm2.}^.product_release_id AND
^{lm.}^.product_id = ^{lm2.}^.product_id AND
^{lm.}^.opsys_family_id = ^{lm2.}^.opsys_family_id AND
^{lm.}^.opsys_type_id = ^{lm2.}^.opsys_type_id AND
^{lm.}^.product_price_type_id = ^{lm2.}^.product_price_type_id AND
^{lm2.}^.product_price_unit_type_id <> 'db_sessions'
and
(
^{lm.}^.dbms_family_id = ^{lm2.}^.dbms_family_id
OR
^{lm2.}^.dbms_family_id = 15
)
)
as virtrdf:OplLicenseModelPriceUnitTypes .
opl:LicenseModel(
lm.product_release_id,
lm.product_id,
lm.opsys_family_id,
lm.dbms_family_id,
lm.product_price_type_id)
gr:hasPriceSpecification
opl:PriceUnitType(
lm2.product_release_id,
lm2.product_id,
lm2.opsys_family_id,
lm2.dbms_family_id,
lm2.product_price_type_id,
lm2.product_price_unit_type_id)
where (
^{lm.}^.product_release_id = ^{lm2.}^.product_release_id AND
^{lm.}^.product_id = ^{lm2.}^.product_id AND
^{lm.}^.opsys_family_id = ^{lm2.}^.opsys_family_id AND
^{lm.}^.opsys_type_id = ^{lm2.}^.opsys_type_id AND
^{lm.}^.product_price_type_id = ^{lm2.}^.product_price_type_id AND
^{lm2.}^.product_price_unit_type_id = 'db_sessions'
and
(
^{lm.}^.dbms_family_id = ^{lm2.}^.dbms_family_id
OR
^{lm2.}^.dbms_family_id = 15
)
)
as virtrdf:OplLicenseModelBasePriceUnitTypes .
opl:Discount(
gd.product_release_id,
gd.opsys_type_id,
gd.product_id,
gd.opsys_family_id,
gd.dbms_family_id,
gd.product_price_type_id)
a opl:Discount
as virtrdf:product_discount;
rdfs:label gd.product_discount_description as virtrdf:OplLabelDiscount ;
rdfs:description gd.product_discount_description as virtrdf:OplDiscountExplain ;
opl:discount_description
gd.product_discount_description
as virtrdf:gd_discount_description;
opl:discount_start
gd.discount_start
as virtrdf:gd_discount_start;
opl:discount_end
gd.discount_end
as virtrdf:gd_discount_end;
opl:ProductPriceType
opl:PriceType(gd.product_price_type_id)
as virtrdf:gd_shop_price_type;
gr:hasUnitOfMeasurement
opl:PriceType(gd.product_price_type_id)
as virtrdf:gd_shop_price_type_grUnitOfMeasurement;
opl:ProductReleaseId
gd.product_release_id
as virtrdf:gd_shop_price_product_release;
opl:ProductFormat
opl:ProductFormat(gd.product_format_code)
as virtrdf:gd_shop_price_product_format;
opl:ProductCategory
opl:ProductCategory(gd.product_cat_code)
as virtrdf:gd_shop_price_product_cat;
opl:OpsysFamily
opl:OpsysFamily(gd.opsys_family_id)
as virtrdf:gd_shop_price_opsys_family_oplweb;
opl:OpsysType
opl:OpsysType(gd.opsys_type_id)
as virtrdf:gd_shop_price_opsys_type;
opl:DbmsFamily
opl:DbmsFamily(gd.dbms_family_id)
as virtrdf:gd_shop_price_dbms_family;
opl:discount_token
gd.discount_token
as virtrdf:gd_discount_token ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:PriceType(pt.product_price_type_id)
a opl:PriceType
as virtrdf:shop_product_price_type;
rdfs:label pt.product_price_type_description as virtrdf:OplLabelPriceType ;
rdfs:description pt.product_price_type_description as virtrdf:OplPriceTypeExplain ;
opl:PriceTypeDescription
pt.product_price_type_description
as virtrdf:shop_product_price_type_description;
dc:description
pt.product_price_type_long_description
as virtrdf:shop_product_price_type_long_description ;
ore:isDescribedBy opl: ;
ore:isDescribedBy dc: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy dc: ;
rdfs:isDefinedBy rdfs:
.
opl:PriceUnitType(
put.product_release_id,
put.product_id,
put.opsys_family_id,
put.dbms_family_id,
put.product_price_type_id,
put.product_price_unit_type_id)
a opl:PriceUnitType
as virtrdf:shop_product_price_unit_type;
rdfs:label put.product_price_unit_description as virtrdf:OplLabelproductpriceunitdescription ;
rdfs:description put.product_price_unit_description as virtrdf:OplproductpriceunitdescriptionExplain ;
gr:hasUnitOfMeasurement
opl:PriceType(put.product_price_type_id)
as virtrdf:put_shop_price_type_grUnitOfMeasurement;
opl:unitValue
put.unit_price
as virtrdf:unit_type_unit_price;
gr:hasValue
put.unit_price
as virtrdf:unit_type_unit_price_grHasValue;
opl:graceUnits
put.unit_grace
as virtrdf:unit_type_unit_grace;
opl:minUnits
put.unit_low
as virtrdf:unit_type_unit_low;
opl:maxUnits
put.unit_cap
as virtrdf:unit_type_unit_cap;
opl:unit_type_description
put.product_price_unit_description
as virtrdf:unit_type_description ;
ore:isDescribedBy opl: ;
ore:isDescribedBy rdfs: ;
rdfs:isDefinedBy opl: ;
rdfs:isDefinedBy rdfs:
.
opl:PriceUnitType(
put.product_release_id,
put.product_id,
put.opsys_family_id,
put.dbms_family_id,
put.product_price_type_id,
put.product_price_unit_type_id
)
opl:hasIncrementalDiscount
opl:PriceUnitIncrementalDiscount(
put2.product_release_id,
put2.product_id,
put2.opsys_family_id,
put2.dbms_family_id,
put2.product_price_type_id,
put2.product_price_unit_type_id
)
where (
^{put.}^.product_release_id = ^{put2.}^.product_release_id and
^{put.}^.product_id = ^{put2.}^.product_id and
^{put.}^.opsys_family_id = ^{put2.}^.opsys_family_id and
^{put.}^.dbms_family_id = ^{put2.}^.dbms_family_id and
^{put.}^.product_price_type_id = ^{put2.}^.product_price_type_id and
^{put.}^.product_price_unit_type_id = ^{put2.}^.product_price_unit_type_id
)
as virtrdf:OplLicenseModelUnitsIncrementalDiscounts .
opl:PriceUnitIncrementalDiscount(
put.product_release_id,
put.product_id,
put.opsys_family_id,
put.dbms_family_id,
put.product_price_type_id,
put.product_price_unit_type_id)
a opl:PriceUnitIncrementalDiscount
as virtrdf:shop_product_price_unit_type_incremental_discount;
rdfs:label put.product_price_unit_description as virtrdf:OplLabelproductpriceunitIncDisdescription ;
rdfs:description put.product_price_unit_description as virtrdf:OplproductpriceunitIncDisdescriptionExplain ;
opl:percentageOfBase
put.unit_discount
as virtrdf:unit_type_unit_discount;
opl:triggerPoint
put.quantity
as virtrdf:unit_type_unit_discount_quantity
.
opl:LicenseModel(
lm.product_release_id,
lm.product_id,
lm.opsys_family_id,
lm.dbms_family_id,
lm.product_price_type_id
)
opl:hasGeneralDiscounts
opl:Discount(
gd.product_release_id,
gd.opsys_type_id,
gd.product_id,
gd.opsys_family_id,
gd.dbms_family_id,
gd.product_price_type_id
)
where (
^{lm.}^.product_release_id = ^{gd.}^.product_release_id AND
^{lm.}^.product_id = ^{gd.}^.product_id AND
^{lm.}^.opsys_family_id = ^{gd.}^.opsys_family_id AND
^{lm.}^.dbms_family_id = ^{gd.}^.dbms_family_id AND
^{lm.}^.opsys_type_id = ^{gd.}^.opsys_type_id AND
^{lm.}^.product_price_type_id = ^{gd.}^.product_price_type_id
)
as virtrdf:OplLicenseModelGeneralDiscounts .
} .
} .
;
DB.DBA.XML_SET_NS_DECL ('OpenLink', 'http://www.openlinksw.com/schemas/oplweb#', 2);
DB.DBA.XML_SET_NS_DECL ('OplProductCategory', 'http://data.openlinksw.com/oplweb/product_category/', 2);
DB.DBA.XML_SET_NS_DECL ('OplProductFamily', 'http://data.openlinksw.com/oplweb/product_family/', 2);
DB.DBA.XML_SET_NS_DECL ('OplProductFormat', 'http://data.openlinksw.com/oplweb/product_format/', 2);
DB.DBA.XML_SET_NS_DECL ('OplProduct', 'http://data.openlinksw.com/oplweb/product/', 2);
DB.DBA.XML_SET_NS_DECL ('OplProductRelease', 'http://data.openlinksw.com/oplweb/product_release/', 2);
DB.DBA.XML_SET_NS_DECL ('ore', 'http://www.openarchives.org/ore/terms/', 2);
DB.DBA.RDF_AUDIT_METADATA (1, '*');
commit work;
-- Clear the 'cache' for immediate effects
select hs_local_iri, exec ('sparql clear graph <'||hs_local_iri||'>')
from sys_http_sponge
where hs_local_iri like '%oplweb%';
select id_to_iri(G), exec ('sparql clear graph <'||id_to_iri(G)||'>')
from rdf_quad
where id_to_iri(G) like '%oplweb%';
sparql clear graph ;
commit work;
sparql CONSTRUCT { ?p ?o }
FROM
WHERE { ?p ?o }
;
sparql select *
FROM
WHERE { ?p ?o }
limit 100
;
sparql define get:soft "soft" select *
FROM
WHERE { ?p ?o }
limit 100
;
sparql CONSTRUCT { ?p ?o }
FROM
WHERE { ?p ?o }
limit 100
;
sparql CONSTRUCT { ?p ?o }
FROM
WHERE { ?p ?o }
limit 1
;
sparql select ?p ?o
FROM
WHERE { ?p ?o }
limit 1
;
sparql
prefix opl:
select ?s ?o
FROM
WHERE { ?s opl:hasProcessors ?o }
limit 1
;
sparql
prefix opl:
select distinct ?o
FROM
WHERE { opl:hasProductFamily ?o }
limit 10
;
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/price_unit_type/6.1_odbc-sqlserver-st_1_2_1_db_sessions#this"
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/price_unit_type/6.1_odbc-sqlserver-st_1_2_1_cpu#this"
--select top 10 * from oplweb2.DBA.license_model_unit_type where product_release_id = '6.1' and product_id = 'odbc-sqlserver-st'
-- and opsys_family_id = 1 and dbms_family_id = 15 and product_price_type_id = 1 and product_price_unit_type_id = 'cpu';
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/rdfbrowser/index.html?uri=http%3A//data.openlinksw.com/oplweb/component_archive/6.1-odbc-oracle-st-i686-generic-win-32-ora10-odbclt-clnt-only_mv.msi"
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/product_family/uda"
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/product_category/odbc"
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/dbms_family/MySQL"
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/product_release/odbc-oracle-mt_6.1_i686-generic-win-32_ora9"
-- curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/license_model/6.1_odbc-sqlserver-st_1_2_1"
curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/rdfbrowser/index.html?uri=http%3A//data.openlinksw.com/oplweb/component_archive/6.1-odbc-oracle-st-i686-generic-win-32-ora10-odbclt-clnt-only_mv.msi"
curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/product_family/uda"
curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/product_release/odbc-oracle-mt_6.1_i686-generic-win-32_ora9"
curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/license_model/6.1_odbc-sqlserver-st_1_2_1"
--
-- XXX: note , the below would work only if www.openlinksw.com has the GRAPH
-- if experimenting on other box, then www.openlinksw.com should be replaced with [URIQA] DefaultHost INI value
--
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'oplweb2_rule2',
1,
'/oplweb(/[^#]*)',
vector('path'),
1,
'/sparql?query=CONSTRUCT+{+%%3Chttp%%3A//data.openlinksw.com/oplweb%U%%23this%%3E+%%3Fp+%%3Fo+}+FROM+%%3Chttp%%3A//www.openlinksw.com/dataspace/organization/openlink/oplweb/%%3E+WHERE+{+%%3Chttp%%3A//data.openlinksw.com/oplweb%U%%23this%%3E+%%3Fp+%%3Fo+}&format=%U',
vector('path', 'path', '*accept*'),
null,
'(text/rdf.n3)|(application/rdf.xml)',
0,
null
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'oplweb2_rule1',
1,
'(/oplweb/[^#]*)',
vector('path'),
1,
'/rdfbrowser/index.html?uri=http%%3A//data.openlinksw.com%U%',
-- '/DAV/RDF/rdfqry.vsp?uri=http%%3A//data.openlinksw.com%U%%23this',
vector('path'),
null,
'(text/html)|(\\*/\\*)',
0,
303
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'oplweb2_rule3',
1,
'(/[^#]*)/\x24',
vector('path'),
1,
'%s',
vector('path'),
null,
null,
0,
null
);
create procedure DB.DBA.REDO_OPLWEB2_RDF_DET()
{
declare colid int;
colid := DAV_SEARCH_ID('/DAV/RDF/oplweb2/', 'C');
if (colid < 0)
return;
update WS.WS.SYS_DAV_COL set COL_DET=null where COL_ID = colid;
}
;
DB.DBA.REDO_OPLWEB2_RDF_DET();
drop procedure DB.DBA.REDO_OPLWEB2_RDF_DET;
DB.DBA."RDFData_MAKE_DET_COL" ('/DAV/RDF/oplweb2/', 'http://data.openlinksw.com/oplweb', NULL);
VHOST_REMOVE (lpath=>'/oplweb/data/rdf');
DB.DBA.VHOST_DEFINE (lpath=>'/oplweb/data/rdf', ppath=>'/DAV/RDF/oplweb2/All/', is_dav=>1, vsp_user=>'dba');
-- procedure to convert path to DET resource name
create procedure DB.DBA.OPLWEB2_DET_REF (in par varchar, in fmt varchar, in val varchar)
{
declare res, iri any;
iri := 'http://data.openlinksw.com/oplweb' || val;
res := sprintf ('iid (%d).rdf', iri_id_num (iri_to_id (iri)));
return sprintf (fmt, res);
}
;
DB.DBA.URLREWRITE_CREATE_REGEX_RULE ('oplweb2_rdf', 1,
'/oplweb/(.*)', vector('path'), 1,
'/oplweb/data/rdf/%U', vector('path'),
'DB.DBA.OPLWEB2_DET_REF',
'application/rdf.xml',
2,
303);
DB.DBA.URLREWRITE_CREATE_RULELIST (
'oplweb2_rule_list1',
1,
vector (
'oplweb2_rule1',
'oplweb2_rule2',
'oplweb2_rule3',
'oplweb2_rdf'
));
VHOST_REMOVE (vhost=>'data.openlinksw.com:80', lpath=>'/oplweb');
DB.DBA.VHOST_DEFINE (vhost=>'data.openlinksw.com:80', lpath=>'/oplweb', ppath=>'/DAV/RDF/oplweb2/',
vsp_user=>'dba', is_dav=>1, def_page=>'sfront.vspx', is_brws=>0, opts=>vector ('url_rewrite', 'oplweb2_rule_list1'));
/*
DB.DBA.VHOST_DEFINE (vhost=>'data.openlinksw.com:80', lhost=>':80', lpath=>'/rdf_net', ppath=>'/rdf_net');
DB.DBA.VHOST_DEFINE (vhost=>'data.openlinksw.com:80', lhost=>':80', lpath=>'/sparql/',
ppath => '/!sparql/', is_dav => 1, vsp_user => 'dba', opts => vector('noinherit', 1));
VHOST_REMOVE (vhost=>'data.openlinksw.com', lpath=>'/proxy');
DB.DBA.VHOST_DEFINE (vhost=>'data.openlinksw.com', lhost=>':80', lpath=>'/proxy',
ppath=>'/SOAP/Http/ext_http_proxy', soap_user=>'PROXY');
DB.DBA.VHOST_DEFINE (vhost=>'data.openlinksw.com:80', lhost=>':80', lpath=>'/xml_a',
ppath=>'/SOAP/',soap_user=>'XML_A');
DB.DBA.VHOST_DEFINE (vhost=>'data.openlinksw.com:80', lhost=>':80', lpath=>'/XMLA',
ppath=>'/SOAP/', soap_user=>'XMLA', soap_opts => vector ('ServiceName', 'XMLAnalysis', 'elementFormDefault', 'qualified'))
GRANT EXECUTE ON DB.DBA.RDF_SPONGE_UP TO "SPARQL", "SPARQL_UPDATE";
GRANT EXECUTE ON DB.DBA.TTLP_EV_NEW_GRAPH TO "SPARQL", "SPARQL_UPDATE";
grant SPARQL_UPDATE to "SPARQL";
curl -H "Accept: application/rdf+xml" "http://data.openlinksw.com/oplweb/product_family/uda#this"
select hs_local_iri, exec ('sparql clear graph <'||hs_local_iri||'>') from sys_http_sponge;
*/
---+ OWL based Ontology
--sparql construct { ?x ?y ?z } from --
-- where { ?x ?y ?z }
DB.DBA.RDF_LOAD_RDFXML_MT (
'
ProductPortfolio
OpenLink Product Portfolio
oplweb
1.00
Product Family
Product Family
Product Category
Product Category
Product Format
Product Format
Product Format Category
Product Format Category
Product Family Description
Product Family Long Description
Product Family Long Description
Product Format Description
Product Format Long Description
Product Format Long Description
Product Category Description
Product Category Long Description
Product Category Long Description
Product
Product
Product
vendor_category_family
vendor_category_family
vendor_category
vendor_category
vendors
vendors
vendor name
vendor_category_family_description
vendor_category_description
vendor_category_description
Opsys Family
Opsys Family
Dbms Family
Dbms Family
Dbms Engine
Dbms Engine
Opsys Type
Opsys Type
Processor Mode
Processor Mode
Processor
Processor
Processor Family
Processor Family
Dbms Engine
opsys
Opsys Family Name
Opsys Family Rating
Opsys Family License Code
Opsys Family Vendor
DBMS Family Name
DBMS Family Vendor
DBMS Name
DBMS Version
DBMS Engine Rating
DBMS Engine old Archive Code
DBMS Upward Compatible
DBMS Downward Compatible
Opsys Type Description
Opsys Type Short Description
Opsys Name
Opsys Version
Opsys Compatible
Opsys Downward Compatible
Opsys License Code
Opsys Commercial Name
Opsys Processor
Opsys Emulation Mode
Processor Mode Name
Processor Name
Processor Mode
Processor Description
Processor Family Name
Processor Family Description
Processor Family Vendor
Product
Product
Product Release
Product Release
Product ID
Product Category
Product Category
Product Description
Product Long Description
Product Release ID
Product Release Opsys
Product Release DBMS
Product Release upward compatible
Product Release downward compatible
Product Release Supported
Components
Components
Component Mode
Component
Component
Component Type
Component Category
Component
Component Mode Description
Component Mode Short Description
Component Type Description
Component Type Short Description
Component Category Description
Component Category Long Description
Component Category Short Description
Components Name
Components CVSID
Components Build Date
Components Notes
Components Build Comments
Components Name
Components Component Category
Components Component Type
Components Component Mode
Components Opsys
Components DBMS
Component Archive
Component Archives
Component Archive Type
Component Archives Type
Component Archive Type Name
Component Archive Type Name
Component Archive Type Extension
Component Archive Component Archive Type
Component Archive Name
Component Archive Assembly Date
Component Archive File URI
Component Archive License Code
Component Archive DAV Resource Name
Component Archive DAV Full Path
Component Archive File Size in DAV
Download Location
Download Location
Download Protocol
Download Protocol
Download Partner
Download Partner
Protocol Name
Protocol Description
Protocol Active
Download Partner Partner Name
Download Partner Hostname
Download Partner Domain Name
Download Partner Port Number
Download Location URI
Download Location URI Old
Product Benefit
Product Benefit
Product Benefit
Product Benefit
Product Feature Category
Product Feature Category
Product Features
Product Features
Product Family Features
Product Family Features
Product Format Features
Product Format Features
Product Category Features
Product Category Features
Product Benefit
Product Benefit
product Benefits Category
Product Benefits Description
Product Benefits Description Details
Product Benefits Acronym
Product Benefits Explanation
The Features Demo URL
The Features Number of Hypes per second
The Features Short Description
License Type
License Type
Unit Type
Unit Type
General Discount
General Discount
Incremental Discount
Incremental Discount
License
License
Base Unit Cost
Price Unit Cost
Base Unit Cost
General Discount
Unit Value
Grace Unit
Minimum Units
Maximum Units
Code Word needed to activate this discount
Discount Start Date
Discount End Date
Percentage of cost attributing as discount
Discount Trigger Point
Percentage of base cost attributing as discount
Label
Name
logo
homepage
Maker
Name
',
'http://www.openlinksw.com/schemas/oplweb#',
'http://www.openlinksw.com/schemas/oplweb#')
--'http://www.openlinksw.com/dataspace/organization/openlink/ProductPortfolioOntology/1.0/')
;
rdfs_rule_set ('oplweb2_owlset', 'http://www.openlinksw.com/schemas/oplweb#', 1);
DB.DBA.XML_SET_NS_DECL ('opl', 'http://www.openlinksw.com/schemas/oplweb#', 2);