Database equivalent view
A view that contains all the attributes and records of the defining relation, i.e. a copy of the relation.
Database join selection projection view
A database view that contains a subset of the attributes and the records of a join table.
Database join projection view
A database view that contains a subset of the attributes of a join table.
Database join and selection view
A database view that contains a subset of the records of a joined table.
Database join view
A database view that contains the attributes of two or more joined relations.
Database projection and selection view
A database view that contains a subset of the attributes of a relation and a subset of the records of those attributes given a condition.
Database projection view
A database view that contins a subset of the attributes of the database relation that defines it.
Database selection view
A database view that contains a subset of the records of a given relation.
TO DO: Check if it's necessary to add here the unary relations from the foreign key attributes of
dl:DBSingleDependentPrimaryKey
'Database non-key attribute'
or ('Database candidate key attribute'
and (not ('Database foreign key attribute'))
and (not ('Database primary key attribute')))
or ('Database non-primary key attribute'
and (not ('Database foreign key attribute')))
or ('Database primary and non-foreign key attribute'
and ('is part of' some 'Relation class mapping'))
1
Database relations that have independent primary keys, i.e. primary keys whose attributes are not foreign key to another relation are mapped to Entity Concept Mappints.
Database relations whose primary key depends on another entity, either partially or fully but with only one foreign key are also mapped to an entity class mapping.
A mapping from an entity or relation from a relational database to a concept/class in RDF/OWL that will represent an entity.
Previous version, not considering the primary key attributes.
dl:DBNonKeyAttribute
or (dl:DBCandidateKeyAttribute
and (not (dl:DBForeignKeyAttribute))
and (not (dl:DBPrimaryKeyAttribute)))
or (dl:DBNonPrimaryKeyAttribute
and (not (dl:DBForeignKeyAttribute)))
TO DO: The not null attribute included here has to be reviewed.
1
previous definition: dl:DBRelation
that dl:hasPart some (dl:DBPrimaryForeignKeyAttribute
that dl:isPartOf some (dl:DBSingleDependentPrimaryKey
that dl:hasAttribute max 1 dl:DBAttribute))
New definition
dl:DBNonPrimaryForeignKeyAttribute
or (dl:DBPrimaryForeignKeyAttribute
and (dl:isPartOf some
(dl:DBMultipleDependentPrimaryKey
or dl:DBPartiallyBinaryDependentPrimaryKey
or dl:DBPartiallyMultipleDependentPrimaryKey
or dl:DBPartiallySingleDependentPrimaryKey
or (dl:DBSingleDependentPrimaryKey and (dl:isPartOf some (dl:DBRelation and (dl:hasPart max 1 dl:DBPrimaryForeignKey))))
or (dl:DBBinaryDependentPrimaryKey
and (dl:isPartOf some
(dl:DBRelation
and (dl:hasPart some dl:DBNonKeyAttribute)))))))
Previous definition
dl:DBNonPrimaryForeignKeyAttribute
or (dl:DBPrimaryForeignKeyAttribute
and (dl:isPartOf some
(dl:DBMultipleDependentPrimaryKey
or dl:DBPartiallyBinaryDependentPrimaryKey
or dl:DBPartiallyMultipleDependentPrimaryKey
or dl:DBPartiallySingleDependentPrimaryKey
or dl:DBSingleDependentPrimaryKey
or (dl:DBBinaryDependentPrimaryKey
and (dl:isPartOf some
(dl:DBRelation
and (dl:hasPart some dl:DBNonKeyAttribute)))))))
This will be eliminated if the definition in the class is enough.
1
1
Department.id
Department.name
Department.location
City.city_id
City.city_name
City.province
=
ONTARIO)
1
2
1
1000
Employee.id
Employee.name
Employee.address
Employee.salary
Employee.name
Employee.id
Employee.name
Employee.address
Employee.salary
800)
>
Employee.name
Employee.salary
800)
>
ITJob
1
1
Manager.time_assigned
COUNT
all
Manager.id
Manager.entry_date
Manager.project
Manager.time_assigned
Outsourceproject.project_id
Outsourceproject.contract_id
Outsourceproject.phase
3
2
1
3
2
Project.name
Project.name
3000)
>
4
1
2
Worksfor.employee_id
Worksfor.department_id
2)
=